Resolved Import price not updated

Hello,

Since I don't understand the values on the image you posted I just have to guess. So, CSVI is trying to find the existing price like this:

SELECT `virtuemart_product_price_id` FROM `k2xip_virtuemart_product_prices` WHERE `virtuemart_product_id` = 257 AND `price_quantity_start` = 0 AND `price_quantity_end` = 0 AND `virtuemart_shoppergroup_id` IS NULL AND `product_currency` = 64 AND `product_price_publish_up` IS NULL AND `product_price_publish_down` IS NULL

So comparing this to your image, the quantities of 0 match your image, so that is OK. Next it checks the shoppergroup which is set to NULL for the check. Since I don't understand the screenshot, is this field also NULL in your database? The product currency seems to be fine. The publish_up and publish_down fields are odd. Your debug log shows you run CSVI 7.0.2 but did you also update the CSVI VirtueMart addon? I would expect something else in the query.

CSVI doesn't find a price matching these settings, that is why it adds a price. So we need to see what the actual values are for this price in the database.

It does not work, It recognized the fields. It can see in the picture. THX

.

I have attached log.
You will find everything it can to create new price.

THX

Hello,
Can you post your import debug log and sample import file to check? To know on how to get the debug log check Where to get the debug information? section on top of this page.

It does not work, create a new price.
I use the program for a long time, Joomla 1.7 was not a problem.
Price changes need it: SKU, PRICE (not need other fields)

Hello,
Yes, you need to use these fields in your import file.

Hello,

I use this template?

Update a price
"product_sku";"shopper_group_name";"product_currency";"price_quantity_start";"price_quantity_end";"product_price";"product_price_new"

Hello David,
To update your old prices there is a format you need to follow in your import file. You don't have that in your import file as per your debug log and so it has not worked. You need to have few required fields so CSVI can find the correct record based on these fields and update the price. These required fields are explained in Import VirtueMart prices document. Along with these fields you should also have product_price_new field with new price in your import file so when CSVI finds the matching record, it will use the price from product_price_new field. Hope it is clear.