Posted By

pwd on 06/17/11


Tagged

select insert wordpress prices shopp


Versions (?)

Update prices on Shopp


 / Published in: MySQL
 

  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. SELECT
  9. wp_shopp_product.id,
  10. "Price & Delivery",
  11. "product",
  12. "Shipped",
  13. 'a:2:{s:3:"var";s:3:"off";s:3:"min";s:3:"off";}'
  14. FROM wp_shopp_product
  15. WHERE id NOT IN (SELECT product FROM wp_shopp_price);

Report this snippet  

You need to login to post a comment.