Update prices on Shopp


/ Published in: MySQL



Copy this code and paste it in your HTML
  1. INSERT INTO wp_shopp_price (
  2. wp_shopp_price.product,
  3. wp_shopp_price.label,
  4. wp_shopp_price.context,
  5. wp_shopp_price.type,
  6. wp_shopp_price.donation
  7. )
  8. wp_shopp_product.id,
  9. "Price & Delivery",
  10. "product",
  11. "Shipped",
  12. 'a:2:{s:3:"var";s:3:"off";s:3:"min";s:3:"off";}'
  13. FROM wp_shopp_product
  14. WHERE id NOT IN (SELECT product FROM wp_shopp_price);

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.