Categories
View Replies (3)

Resolved Price in CSV and Preview Different to SQL....

  1. rjcroasdale
    rjcroasdale
  2. RO CSVI
  3. Tuesday, 08 March 2016
  4.  Subscribe via email
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
csvipricepreview.jpg
..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'
0
Responses (3)
tharuna
tharuna
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 1
rjcroasdale
rjcroasdale
Accepted Answer Pending Moderation
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 :)
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 3
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!