Resolved Successful import but nothing changes

Hello,

You will need to post the information as requested in the blue box at the top under Looking for a useful answer?. This most likely has something to do with your import settings/file. Post the information requested and we will take a look.

CSVI Version 7.11

Sample of File being imported:
product_sku virtuemart_product_id product_name product_s_desc product_price manufacturer_name published
AWS-S601372 3862 Andersen Hog Heaven Anti-Fatigue Industrial Matting 421, 422, 423, 424 0 The Andersen Company 1
AWS-S601373 3863 Andersen Hog Heaven Spill Control Anti-Fatigue Matting 507, 508, 509, 510 0 The Andersen Company 1
AWS-S601374 3864 Andersen Kneeling Comfort Anti-Fatigue Matting 433 0 The Andersen Company 1
AWS-S601375 3865 Andersen SuperScrape Slip-Resistant Matting 450 0 The Andersen Company 1
AWS-S601376 3866 Andersen Corrugated Switchboard Matting 781 0 The Andersen Company 1
AWS-S601377 3867 Andersen Diamond Plate Switchboard Matting 783 0 The Andersen Company 1
AWS-S601378 3868 Andersen Military Switchboard Diamond Matting 784 0 The Andersen Company 1
AWS-S601379 3869 Andersen Military Switchboard Smooth Matting 782 0 The Andersen Company 1
AWS-S601380 3870 Andersen Waterhog Eco Elite Indoor / Outdoor Matting 2240 0 The Andersen Company 1
AWS-S601381 3871 Andersen Waterhog Classic Entrance Mat 200 0 The Andersen Company 1
AWS-S601382 3872 Andersen Waterhog Classic Diamond Indoor / Outdoor Matting 208 0 The Andersen Company 1
AWS-S601383 3873 Andersen Flex Tip Outdoor Matting 874 0 The Andersen Company 1


Vermilion 5.0.4 Rocket theme template being used.

Hello,
Posting the sample of import file is not enough, we would need your import debug log and a copy of your import template to check. To get the debug log check How to collect debug information? document. You can create a copy of your template from CSVI Maintenance page, select CSVI Pro in first dropdown and Backup templates in second dropdown and select your import template and click continue. Post the downloaded XML file as well.

[attachment]csvi_templates_http://www.americanworksafety.com_20190220.xml[/attachment] com_csvi.log.158.zip

Debug log and backup Template

Hello,
You have virtuemart_product_id field and that is not needed for product import. CSVI will identify a product in database using product_sku field. Using virtuemart_product_id says that the product is already in database and needs to be updated. New products will not be created. Remove virtuemart_product_id field and run your import and check.

The products are already in my database, Would that still be true if I only want to update the product_price?

Hello,
If the products are already in database then virtuemart_product_id will be used to identify the product row and update it so that should be fine. Just that any new products will not be created.

So checking into the debug log i see there was no update to price field and that is because you are trying to update all the product prices to 0(checking the sample of your import file). Are you trying to set all product prices to 0? May i know the reason behind this? I don't understand the need to having a product with price set to 0 in a eshop.

Even If I am only wanting to update the price of the products, I should still take out virtuemart_product_id?

Hello,
If you are sure that products are already in database then using virtuemart_product_id should not be a problem. We generally don't recommend using fields ending with _id as these are primary key fields of a database table and the values of these fields should be managed by database itself. You did not answer my question yet. Why do you want to update your product prices to 0?

I want to update my prices to zero so customers have to call to order. I have two other sites that this generally works for but this particular site no imports work

Hello,
With the patch file attached you will be able to import product prices with value 0. But to select a product price CSVI needs few other fields and not just product_price. The other fields are price_quantity_start, price_quantity_end, product_price_publish_up, product_price_publish_down and shopper_group_name_price. If these fields are not in import file, CSVI will add a new price for a product.

So if you want to just have product prices to 0, in import template settings set Delete existing prices to Yes on Options tab and then run the import. This way all previous prices will be removed for a product and value 0 will be imported.

Load the patch file and let us know if your issue is solved.

Just want to update patch solved issue

Hello,

Thank you for reporting your findings. The patch will be included in the next release.