How Do I Set Up Attributes With The Import?
The attributes import can be used to set the following options - Attribute Name, Attribute Value, Attribute SKU and Attribute Description.
You can also control whether the attributes are internal, enabled, set on a separate order line and the u display order.
To create new Attributes, the relevant Products should first be 'selected' or filtered in Product Manager prior to generating an Attribute Export.
The generated CSV file serves as a template, allowing the Product data to be added in a format that is then suitable for use with the Attribute Import to update the Products.
It is recommended that Imports are tested on a sample range prior to rollout across a high volume of Products.
The CSV file contains all Attribute data for the selected Products under the following column headers;
- Attribute ID - Unique Attribute number (if existing)
- Attribute Name - The defined Group Name, eg 'Size'
- Attribute Value - The defined option, eg 'Medium'
- attribute.is_internal - Determines if the Attribute is selectable, or not
- A value of 1 indicates this is enabled, 0 means this is disabled
- attribute.is_enabled - Determines if the Attribute is functional, or not
- A value of 1 indicates this is enabled, 0 means this is disabled
- attribute.is_seperate_order_line
- A value of 1 indicates this is enabled, 0 means this is disabled
- attribute.ui_display_order - Changes the Attribute list order in the Smartlink
- Attribute SKU - The associated option SKU
- Attribute Description - Any added option details
- Attribute Spec - Any added specification details
- Product ID - Unique Product Number
The fields can then be populated based on the required options / settings.
Prior to import, the CSV must be formatted. If using OpenOffice or equivalent, save as .CSV and be sure to:
Enable 'Edit the Filter Settings'
Keep Current Format
Change the character set to UNICODE (UTF-8)
The saving delimeter needs to be ","
Enable 'Quote all text cells'
The file can then be imported.
Can You Show Me This Import?
The following video runs through the process: from setting up our import, to importing and to finally seeing the generated attributes from manually checking a product to running the export