Skip to content

Instantly share code, notes, and snippets.

@Hotfirenet

Hotfirenet/remove_all_product_category_in_cart_rule.sql

Created July 25, 2019 09:49
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Hotfirenet/c8fd31f0392a8a455a7da6d565333a06 to your computer and use it in GitHub Desktop.
Save Hotfirenet/c8fd31f0392a8a455a7da6d565333a06 to your computer and use it in GitHub Desktop.
Download ZIP
Permet de supprimer tous les produits d'une règle panier contenu dans une categorie sur prestashop.
Raw
remove_all_product_category_in_cart_rule.sql
DELETE FROM ps_cart_rule_product_rule_value WHERE id_item IN (SELECT id_product FROM ps_category_product WHERE id_category = 53) AND id_product_rule = 1076
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment