Resolved Update existing prices in Virtuemart

Hello Anders,

The debug log you posted is 0 bytes, so not much in there Can you view the log on the site and paste it into a text file and then upload it here?

How can i update existing price without creating a new one?

Not sure if you have seen the Import VirtueMart prices document but it lists the fields needed to update an existing price.

Hi
I did follow the Import VirtueMart prices document...
______________________________________________
CHANGE A PRICE
To change a price the following fields are required:

product_sku
shopper_group_name
product_price
product_price_new
product_currency
___________________________________________
Only required if you use these fields: (I did not use these last rows)

price_quantity_start
price_quantity_end
[/strike][/strike][/i]
[/i]

Here is the log file with a little more content

Thanks for taking a look at this!

Hello,

Could you apply the patch from this topic I posted and see if the update works for you?

Hi
No, it did not work. It still adds a new price.

Hello,

To understand why it can't find the existing price. Can you do a price export of all fields of the product you are importing? This way we can compare the values against the one CSVI is using for checking the existing price.

Hi
I did an export of all products and added the file below. I marked the product i was testing the priceupdate on.


Kind regards
Anders

Sorry, missed the file...

Hello Anders,

The file is not attached, can you check and post the file again. Perhaps it needs to be zipped.

Now maybe

Yes, the file worked but I am missing some fields. The fields product_price_publish_up and product_price_publish_down are not in the file. CSVI looks for these fields as well with a value of 0000-00-00 00:00:00 and I now wonder if these prices don't have this default value in your case. As a result it doesn't find it.

Here is the export with these two fields...

When i look at the productprice in my database it look fine like this 0000-00-00 00:00:00 in the fields product_price_publish_up and product_price_publish_down.

SELECT `virtuemart_product_price_id` FROM `dinbok2_virtuemart_product_prices` WHERE `virtuemart_product_id` = 118 AND `price_quantity_start` = 0 AND `price_quantity_end` = 0 AND `virtuemart_shoppergroup_id` IS NULL AND `product_currency` = 124 AND `product_price_publish_up` = '0000-00-00 00:00:00' AND `product_price_publish_down` = '0000-00-00 00:00:00'

I think I just saw it when pasting this query. The shopper group ID is set to NULL. That is because you do have the shopper_group_name in your file but for the price it is the shopper_group_name_price field.

I am not so sharp today

Hi
I changed to "shopper_group_name_price" field but it still does not find the existing price and creates a new price.

Any more ideas?

Hello,

Do you have the debug log for me?

Sorry, here it is...

Hi
It works fine now :lol:
I didnt understand your erlier reply about shopper_group_name_price field. That was the problem but i thought you mean i should choose shopper_group_name_price field. But when i changed it to virtuemart_shoppergroup_id it works fine.

So with theese fileds it works to update virtuemart existing price....

product_sku
virtuemart_shoppergroup_id
product_currency
price_quantity_start
price_quantity_end
product_price
product_price_new

Many thanks for an excellent support Roland!!

Hello,

That was the problem but i thought you mean i should choose shopper_group_name_price field.

That is what I meant. Looking at the log you posted that worked to the point where CSVI finds shopper group ID 2.

SELECT `virtuemart_product_price_id` FROM `dinbok2_virtuemart_product_prices` WHERE `virtuemart_product_id` = 8520 AND `price_quantity_start` = 0 AND `price_quantity_end` = 0 AND `virtuemart_shoppergroup_id` = 2 AND `product_currency` = 124 AND `product_price_publish_up` = '0000-00-00 00:00:00' AND `product_price_publish_down` = '0000-00-00 00:00:00'

Which ID are you using now then?

Hi
I use the virtuemart_shoppergroup_id and that seems to work.

Hello,

I see the shoppergroup in your new log is 0 and in the old one it is 2. So if you set the shopper_group_name_price field to * in your import file, it would have worked as well.