Skip to content

Instantly share code, notes, and snippets.

@bunnywong

bunnywong/gist:516e9a6d01c82e331d43

Created March 12, 2015 15:52
Show Gist options
  • Save bunnywong/516e9a6d01c82e331d43 to your computer and use it in GitHub Desktop.
Save bunnywong/516e9a6d01c82e331d43 to your computer and use it in GitHub Desktop.
Download ZIP
Opencart - Fix reward as product price
Raw
gistfile1.sql
UPDATE oc_order_product SET reward = total
WHERE name LIKE '%以上%'
AND (quantity * price - reward) < 0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment