Revision: 47849
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
at June 17, 2011 10:59 by pwd
Initial Code
INSERT INTO wp_shopp_price (
wp_shopp_price.product,
wp_shopp_price.label,
wp_shopp_price.context,
wp_shopp_price.type,
wp_shopp_price.donation
)
SELECT
wp_shopp_product.id,
"Price & Delivery",
"product",
"Shipped",
'a:2:{s:3:"var";s:3:"off";s:3:"min";s:3:"off";}'
FROM wp_shopp_product
WHERE id NOT IN (SELECT product FROM wp_shopp_price);
Initial URL
Initial Description
Initial Title
Update prices on Shopp
Initial Tags
wordpress
Initial Language
MySQL