Column names

A forum where issues related to the DataPort utility can be discussed.
Post Reply
User avatar
jmestep
AbleCommerce Angel
Posts: 8164
Joined: Sun Feb 29, 2004 8:04 pm
Location: Dayton, OH
Contact:

Column names

Post by jmestep » Wed Nov 04, 2009 12:45 pm

On the variant import, the directions say ProductName, ProductSku,ProductCategories.
The fields in the Product import have Name, Sku, Categories.
Is this supposed to be this way? I'm doing variant and product imports by importing the variants first for a new product, then using the product sku to match up the other product data for a second import. I have to change the names of my columns if I do this. I'm doing it this way so I can do a sku match rather than do the products first, put the productid in for each variant, then do the variants.
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx

User avatar
Naveed
Rear Admiral (RADM)
Rear Admiral (RADM)
Posts: 611
Joined: Thu Apr 03, 2008 4:48 am

Re: Column names

Post by Naveed » Fri Nov 06, 2009 3:47 am

Yes, the product fields Name, Sku, Categories should be named "ProductName", "ProductSku" etc. This is to distinguish those from variants fields with similar names. The respective variant fields should be named with Variant prefix, something like "VariantName","VariantSku" etc.

FYI: Just adjusting the column names is enough but keep in mind that white spaces in CSV header column names can cause import issues. So, while editing column names do not leave any spaces between them.

Post Reply