Resolved import prices double in virtuemart

Hello Shimon,

1) Should I apply this patch as well ?

Did you clean your prices? Without doing that applying this patch wont help you.

2) I do not understand what you mean by "after cleaning the prices, the first import will insert your prices and the second import will do an update". I have to import twice ?

Yes, you need to import twice to check if price is getting updated and so i said to clean up the prices which are already there in database table, then first import will insert the prices and the second import will update it.

Roland,

I understand the patch wont fix the prices that are messed up already.
Will the patch eliminate the issue of double prices for any subsequent uploads? This is what I would like to know.


I still have to fix the database by removing the prices and then uploading twice, but until I do that I would like to upload some products and I would like to avoid the problem getting worse.

Hello Shimon,

I understand the patch wont fix the prices that are messed up already.
Will the patch eliminate the issue of double prices for any subsequent uploads? This is what I would like to know.

Yes you can install the patch and it will help you for any new imports.

I still have to fix the database by removing the prices and then uploading twice, but until I do that I would like to upload some products and I would like to avoid the problem getting worse.

I would recommend you to clean the prices and then do any new imports. This way when you clean your prices, you wont lose the records in database which are good.

Hello Shimon,

There is a little miscommunication I think. Tharuna mentioned to do two imports just so the topic starter can see the price is updated. A double import is not needed to get the prices into the system.

As Tharuna mentioned in her last post, this will only work for products that get a new price, not for products that have existing issues with prices.

I discovered what was causing products to show up on the back end as "Price Not Set" even though they had prices.

The prices were set, but the product_prices table had the product_currency set to NULL.
I don't know why this could happen, because according to the documentation the price is set to the Vendor's currency by default if not specified in the import. My imports don't specify product_currency , however all the Vendors have their currency set to 144 (USD). When I set the product_price currency to 144, this issue is fixed.

I have a question. On the About tab there are 2 buttons at the top.
Fix Database and Fix Menu.

Is there documentation what this does ?

Thanks

Hello Shimon,

I discovered what was causing products to show up on the back end as "Price Not Set" even though they had prices.

The prices were set, but the product_prices table had the product_currency set to NULL.

I had a look into your database with the products in the import file you had sent me and all of the prices are set with product_currency as 144. CSVI will look for vendor_name field as first in import file, find the vendor_id from the vendor name and insert. If not, then if virtuemart_vendor_id field is in import file, it will be inserted directly, else default vendor_id of 1 will be inserted. product_currency is inserted according to the vendor_id.

I don't know why this could happen, because according to the documentation the price is set to the Vendor's currency by default if not specified in the import. My imports don't specify product_currency , however all the Vendors have their currency set to 144 (USD). When I set the product_price currency to 144, this issue is fixed.

CSVI has done its job as it should. It has taken your Vendor's product currency and inserted it. The debug log you had sent me shows it all, there is no product in your debug log where product_currency has been inserted as NULL. So i am not sure which products you are referring to.

I have a question. On the About tab there are 2 buttons at the top.
Fix Database and Fix Menu.

Is there documentation what this does ?

There is no documentation for these buttons yet. Fix menu will solve the issue as explained in the thread here. Fix database will solve inconsistencies in database tables. Like for an outdated version of tables.

"I had a look into your database with the products in the import file you had sent me and all of the prices are set with product_currency as 144."

Yes, this is the case now. This is after I ran:

UPDATE jos_virtuemart_product_prices
SET product_currency = 144
where product_currency IS NULL;

How they got to be NULL is still a mystery to me since Vendor =1 ( and all the other vendors) have vendor_currency = 144

Hello Shimon,

Yes, this is the case now. This is after I ran:

UPDATE jos_virtuemart_product_prices
SET product_currency = 144
where product_currency IS NULL;

But the product_currency was already to 144 for products in your import file, This is the one of the log entry from your debug log

UPDATE `jos_virtuemart_product_prices` SET `virtuemart_product_id`='31849',`virtuemart_shoppergroup_id`='0',`product_price`='13.46',`override`='0',`product_currency`='144',`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`='0000-00-00 00:00:00',`created_by`='0',`modified_on`='0000-00-00 00:00:00',`modified_by`='0',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_product_price_id`='38574'

How they got to be NULL is still a mystery to me since Vendor =1 ( and all the other vendors) have vendor_currency = 144

Your vendor_id in your import files you sent me was 12 and 50 and all had currency to it and even the product prices have got these currency.

Hello Shimon,

Is there documentation what this does ?

No specific page for this but the Fix Database fixes database tables if needed and Fix Menu fixes database menu entries if needed. It doesn't fix your imports though.