Support Hours
U.S. & North America
Mon-Fri: 8 AM - 8 PM ET

Europe
Mon-Fri: 8 AM - 1 AM GMT

Australia, Asia, Pacific
Mon-Fri: 8 AM - 5 PM DST

Twitter Feed


How do I create custom attributes using the bulk update spreadsheet?

To create custom attributes using the bulk update spreadsheet, you will want to download the bulk update spreadsheet template. To do this, go to the Inventory > Products > Upload a File view, click on the "Custom Upload Format" file link or the "ChannelAdvisor Upload Format" link and then download the revelant file.

Open the spreadsheet. You will want to enter all of the SKUs you wish to update into the Inventory Number column. Fill in the Attribute#Name/Attribute#Value columns with the desired attribute name and value for each of the attributes that you want to use. For example:

Inventory Number: 12345
Classification: Clothing
Attribute1Name: Color
Attribute1Value: Red
Attribute2Name: Shirt Size
Attribute2Value: Large
...

If the attributes are defined as Classification attributes, then you will want to populate the Classification Name column with the appropiate classification.
Otherwise the attributes will be created as global attributes.
If the class/attribute name that you enter does not match an existing classification, the system will automatically create a new class/attribute in that classification.

After the spreadsheet is complete, you will need to save the file as a tab delimited text file. Now return to your IInventory > Products > Upload a File view, choose "Inventory" as the upload type and browse to the tab delimited file you just saved. The SKUs in the spreadsheet will be updated with the classification, attributes, and attribute values.

Classification attributes are "tagable" fields that you can use in your ad templates and posting templates. The tag format for the attributes is {{ATTRIBUTE NAME}}. For example:

Attribute1Name: Color
Attribute Tag: {{COLOR}}
Attribute2Name: Shirt Size
Attribute Tag: {{SHIRT SIZE}}

1.5
Your rating: None Average: 1.5 (6 votes)
1.5
Your rating: None Average: 1.5 (6 votes)

Enter Keywords:
Alerts Alerts

Subscribe to have Alerts delivered to your mailbox

Get Started with Support
  1. Subscribe to System Alerts
  2. Release Notes
  3. Join the Forum Community
  4. Keep up to date with industry news via Our Blogs
  5. Follow us:  Twitter, Facebook and Youtube