Skip to content

Instantly share code, notes, and snippets.

@eighty20results

eighty20results/insert-price-for-addon-packages.sql

Created February 1, 2017 17:03
Show Gist options
  • Save eighty20results/fb93bfaa9f037c6d018bbbd035591fa1 to your computer and use it in GitHub Desktop.
Save eighty20results/fb93bfaa9f037c6d018bbbd035591fa1 to your computer and use it in GitHub Desktop.
Download ZIP
SQL Example for adding price to multiple addon packages
Raw
insert-price-for-addon-packages.sql
INSERT INTO PREFIX_postmeta (`post_id`, `meta_key`, `meta_value`)
SELECT `ID`, '_pmproap_price`, '<your price without a currency sign, i.e. 3.99>'
FROM PREFIX_posts
WHERE ID IN ( <comma>, <separated>, <list>, <of>, <addon>, <package>, <post>, <ids> );
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment