Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Import csv without replacing non-complex data
 
husby
Member
 
Avatar
Total Posts:  72
Joined:  2009-01-07
Roseville, MN
 

We need a way to import data without wiping out all the current non-complex data in the system. For instance, if I’m importing a spreadsheet, and don’t include the qty column, the system should not wipe out the existing qty values in the system. If we wanted it to do that, we’d include the qty column and put values in there.

For an example of why this would be important, please see my bug report where I initially reported this as a bug:

http://www.magentocommerce.com/bug-tracking/issue?issue=12044

When I import a csv using the new 1.5 import feature, and if I do not include qty and visibility in the csv file, they both get reset for all imported products. Qty becomes 0 for everything and visibility becomes “Catalog, Search” for everything. I am using the “Append Complex Data” import behavior.

You can test this by importing data for a product. Set the inventory to 100 and the visibility to “not visible individually” in Magento. Then, create a csv file that has a sku and a name column. After importing, the inventory will now be 0 and the visibility will be “catalog, search” even though we were appending data and those fields were not defined in the csv.

So far, these are the only fields I’ve had a problem with if they are not included in the csv. Especially for the qty field, this is critical because inventory can change rapidly and I don’t want to be uploading out of date inventory data.

Thank you!

 
Magento Community Magento Community
Magento Community
Magento Community
 
Alexandrable
Member
 
Total Posts:  55
Joined:  2011-09-01
 

Try this software for the purpose - Store Manager for Magento: http://www.mag-manager.com. You might not need this tool in general, but it implements data import in .csv file format with no problem. All the fields and info is kept safe and sound.

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top