OLD-6208: CSV Import - add 'update' function for existing products

[cpaschen]

Description

When importing a CSV file, the importer should check to see if the product already exists, and if so, then the record from the CSV should UPDATE the existing record (not create a new record).

NOTE: This should esp. work when you are using an export file from the Generic export function.
So that you can export the data, modify the data in a spreadsheet (like updating prices, etc.) and then upload to update all products.

History

#8 Updated by Chris DioscouriChris Paschen. 8 months ago

Target version changed from Version 0.9.9 - Misc Bug Fixes and New Features to Version 0.9.4 - Plugin Testing and Finalization

#7 Updated by Rod Farrell 12 months ago

This should be expanded to allow bulk updates of "Track Inventory" Y/N. Currently you can add quantities (not for new products, only on update) but if you want to track them you have to manually update every product. Also, quantities need to be per attribute.

#6 Updated by Chris DioscouriChris Paschen. 12 months ago

Good news everyone ... we just got a sponsor on this, so we're moving this up in the project.
Watch for it in 0.8.4.

#5 Updated by Iain Mace 12 months ago

A massive vote from me Chris. I am spending a HUGE amount of time maintaining existing sites just now.

#4 Updated by Chris DioscouriChris Paschen. 12 months ago

We need to get more votes for this or someone to sponsor it to move it up in the production process.

#3 Updated by Rod Farrell 12 months ago

As existing sites mature this is becoming more critical. The inability to easily update product data in bulk is a real headache. We also need the ability to export a file in the correct format to make quick changes and reimport. This is not the case now with the general export. Exported products files don't have categories, attributes and other required information for importing.

#2 Updated by Chris DioscouriChris Paschen. about 1 year ago

Yes, this should be relatively easy.

The Generic Export seems to provide the needed file format.

And the CSV importer does a good job of importing that.

This probably would also require a way to check and only update data that actually has valid data (not just 'replace' the entire existing record - so if the import doesn't have an inventory level field/column, it doesn't get set to "0", but is just skipped and the existing data is left as is.

NOTE: This will probably take some good documentation to ensure users don't have problems.

#1 Updated by Dave Karlsven about 1 year ago

We definitely want this feature.

Especially if it will make it so we can update the prices of our products in mass by exporting a spreadsheet, changing the prices for all the products on the spreadsheet, and then importing the spreadsheet to update all the products with the new prices.