Skip to content

Instantly share code, notes, and snippets.

@frkosk

frkosk/gist:f9091b6a044c32e7077a958847079f9e

Last active January 9, 2020 10:21
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save frkosk/f9091b6a044c32e7077a958847079f9e to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save frkosk/f9091b6a044c32e7077a958847079f9e to your computer and use it in GitHub Desktop.
Download ZIP
Prestashop - bulk update product price by reference
Raw
gistfile1.sql
UPDATE ps_product_shop SET wholesale_price=0.88, price=0.88 WHERE id_product IN (SELECT id_product FROM ps_product WHERE reference='19-ir8');
UPDATE ps_product SET wholesale_price=0.88, price=0.88 WHERE reference='19-ir8';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment