Resolved Import price not updated

Hello,
Something just comes to mind, before applying the last patch you ran the import and new prices were created, were those prices deleted? May be the product has those leftover price entries and the new import is updating the first found price. Can you clean up the price and try doing the import again?

Hello,
I do not understand, does this product has two prices? Which price you are expecting to update? As per your import file product with sku 465 has to be updated with product_price 16000. The query in debug log shows that the product price has been updated. Can you explain your issue?

Dot not update to price. Attached image. It will never be good :-/ THX, David

Hello,
It has worked, Please see the below query from your debug log, price has been updated.

UPDATE `k2xip_virtuemart_product_prices` SET `virtuemart_product_id`='361',`virtuemart_shoppergroup_id`='0',`product_price`='16000',`override`='0',`product_override_price`='0.00000',`product_tax_id`='4',`product_discount_id`='0',`product_currency`='64',`product_price_publish_up`='0000-00-00 00:00:00',`product_price_publish_down`='0000-00-00 00:00:00',`created_on`='2017-02-14 08:29:37',`created_by`='0',`modified_on`='2017-02-15 07:09:09',`modified_by`='0',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_product_price_id`='7'

Thank you for help but it does not work.
The message is good. Message: Product price updated

Hello David,
Can you again try to load the attached patch file and then try doing the import? Let me know how it goes.

patch_product_price_2017_02_15.zip

I sent the private email.

Hello David,
Can you send me your Joomla site administrator login details and also database access details to check? You can send it as a private message or send an email to tharuna@csvimproved.com. Don't forget to attach your import file with the details.

I load the patch, i run imported, not updated price.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

Attached logs. Thx, David

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

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?

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

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.

It is installed plg_csviaddon_virtuemart_csvi_7.0.2 plugin.

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.

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,

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.

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