Resolved Import price not updated

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.

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,
Yes, you need to use these fields in your import file.

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,
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.

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

THX

.

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

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.

To modify/delete a price why I need to know the current price?

Joomla 1.7, VM1,+CSV -> sku+price=new price update, i'm happy

Hello,

To modify/delete a price why I need to know the current price?

Who says that? I am only saying that CSVI can't find the existing price in your database. I asked you a question you didn't answer. This makes it impossible for me to help you.

Sorry my english is very poor, I can't really understand you.
So what I would like to do is published product's price to modify.
I used to use last version of the CSV Improved (Joomla 1.7).
In the last version with the "product_sku" field and "product_price" field i could modify the product's prieces.

Now it cannot working:
test.csv content (product_sku=283, product_price=410), two column.

For example at the attached image how can I change the product's price (410) to another price.
The more I try the price doesn't update, just added another new price, so the product have two prices.
I cannot change any of the product's price.
Could you tell me wich fields is have to use to work it? I attached a new image.
Attached image for database.

Thank you,

David

Hello David,
You still haven't answered to the question we have asked for. We understand that your price is getting added instead of update. You need to first tell us if you have also update your CSVI VirtueMart addon to 7.0.2 version. Your debug log shows something missing in price selecting query which says us that you are still running old CSVI VirtueMart addon extension.

It is installed plg_csviaddon_virtuemart_csvi_7.0.2 plugin.

Hello David,
Can you try to run the price import again as you have updated your CSVI VirtueMart addon to 7.0.2 version and see if the price gets updated? If you have any issues send us the latest debug log along with sample import file to check.

After signing up I did the update. Not now. I'm doing it a try.

Hello,

The screenshot you posted is what I wanted to see I think but the screenshot is unreadable. Can you post a more readable version?

I uploaded the pictures:
http://www.vagyonvedelem2000.hu/images/stories/virtuemart/product/phpmyadmin.jpg
http://www.vagyonvedelem2000.hu/images/stories/virtuemart/product/new_price3.jpg

THX,
David

Attached logs. Thx, David

Hello David,
Can you try to load the attached patch file and then try doing the import? If you have issues, please post the latest debug log and also your import file to check.

patch_product_price_2017_02_14.zip