Hello! Thank you for your quick reply on my other topic, hope for the same again! :)
I am having a very strange issue, seems everything is fine on preview with price same as CSV @ 6.46
..but ...
the import SQL statement is not taking that price but the price the product is already at oO
2016-03-08 05:16:45 1 [DEBUG] Query for ProductPrice
2016-03-08 05:16:45 1 [QUERY] UPDATE `j25_virtuemart_product_prices` SET `virtuemart_product_id`='19145',`virtuemart_shoppergroup_id`='0',`product_price`='6.140000',`override`='0',`product_override_price`='0.00000',`product_tax_id`='0',`product_discount_id`='0',`product_currency`='52',`product_price_publish_up`='0000-00-00 00:00:00',`product_price_publish_down`='0000-00-00 00:00:00',`price_quantity_start`='0',`price_quantity_end`='0',`created_on`='2013-07-15 02:36:24',`created_by`='2',`modified_on`='2016-03-08 05:16:45',`modified_by`='2',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_product_price_id`='20623'
Hello,
Can you post screenshot of prices you have for this product in Virtuemart? are you trying to update existing price or insert a new price? If you already have any price set for shopper_group_id as 0 and for matching currency, CSVI will do an update to the price. Also for updating existing price you need to use product_price_new field with your new price and product_price with price already set.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Great info thank you. Setting product_price_new works as long as there is a field product_price, regardless of whether product_price is the correct old price or not. But it works on the test product. Going to try 40K products now, thanks again.
**
are you trying to update existing price or insert a new price?**
Update.
If you already have any price set for shopper_group_id as 0 and for matching currency, CSVI will do an update to the price.
If I add product_price_new
**Also for updating existing price you need to use product_price_new field with your new price and product_price with price already set. **
Doesnt seem to care about the price already set on initial test
Thank you :)
Glad to hear that it works, Yes you need product_price_new field set for updating price.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Log in to reply to this topic.