Importing Product Attributes

Product attributes are specific product descriptors that define characteristics such as size, color, or material. This document covers the process of importing multiple product attributes using a CSV file. You also have the option to add product attributes manually.

CSV File Guidelines

Product attributes can be imported using CSV files exclusively, as fabric doesn’t support other data or file formats. Here are some essential points to keep in mind:

The headers in the first row of the CSV file should match the attribute titles.
While attribute titles aren’t case-sensitive, maintaining case consistency with the original attribute titles is recommended.
Empty rows and columns are ignored.
fabric recommends downloading the template file to serve as a guide when creating your own CSV file for import, minimizing errors during the process.

Attribute data formatting

When preparing your CSV file for import, ensure that the product attribute data format aligns with the column requirements. Different columns have specific data input requirements:

Attribute	Description
Attribute Title	The name of the attribute.
Type of Attribute	Specifies the attribute type, such as text, number, date, boolean, serial, or list of values, which is also known as list of options.
Description (Optional)	Provides additional details about the attribute.
Decimal	Indicates if the attribute allows decimal values. Valid values are true if decimals are allowed or false if only whole numbers are allowed. Applicable only to number-type attributes. The default value is true, and you must ensure that the number is in decimals.
Min (Optional)	Defines the minimum value for validation. Applicable only to number-type attributes.
Max (Optional)	Defines the maximum value for validation. Applicable only to number-type attributes.
Date Format	Specifies the required date format, such as MM/DD/YYYY, MM-DD-YYYY, DD/MM/YYYY, DD-MM-YYYY, YYYY/MM/DD, or YYYY-MM-DD. This is mandatory for date-type attributes; otherwise, the attribute can’t be imported.
Calculation Formula (Optional)	JavaScript formula used to calculate the attribute value.
Validations Formula (Optional)	JavaScript formula used to define business validation rules for the attribute.
Mandatory	Specifies whether the attribute is required. Valid values are true if the attribute is mandatory or false if it’s optional.
Start With	Defines the starting value for a serial-type attribute. Applicable only to serial-type attributes.
Increment by	Specifies the increment value for a serial-type attribute.
Options Select Type (List of Value)	Determines if the attribute is a list of values. Valid values are true if the attribute is a list of values or false if it’s not. To specify options, use additional columns, such as Value 1, Value 2, Value 3, etc.

The following table provides an example for a product attribute import CSV file:

Attribute Title	Type of Attribute	Sub Type	Mandatory
On Sale	`BOOLEAN`		`TRUE`
Description 1	`TEXT`	`SMALL_TEXT`	`FALSE`
Description 2	`TEXT`	`TEXT_AREA`	`TRUE`
Description 3	`TEXT`	`HTML`	`FALSE`
Color	`OPTIONS`

Prerequisites

Ensure that you have access to fabric Product Catalog in Copilot.

Procedure

You can’t import CSV files with duplicate names. Ensure that every file you import has a unique filename.

In the left menu, click Product Catalog > Attributes > Product. The Product Attributes page is displayed.
Click Import. The Import CSV file window is displayed, providing a link to download an example template for the CSV file.
To import a CSV file, choose one of the following options:
- Drag and drop the CSV file into the window.
- Click Select a File from your computer.
Click Import file. The CSV file is imported, and the product attributes are added.

Error messages

Error Message	Description
File header not present	A column header in the CSV file is incorrect.
INVALID_ATTRIBUTE_TYPE	An invalid attribute type was provided during import. Supported types are: `TEXT` `BOOLEAN` `OPTIONS` `SERIAL` `DATETIME` `NUMBER`
ATTRIBUTE_TYPE_NOT_FOUND	An the attribute type wasn’t mentioned in the CSV file during import.
Duplicate headers found [“Sub Type”]	Duplicate columns are present in the CSV file.
Attribute not found in formula definition.	An invalid attribute was provided for a custom formula during import.
At least one of the properties in startWith or increment are missing.	A startWith or increment value was missing for a serial type attribute during import.
`acceptedValues` must be unique and can’t be empty	Duplicate or empty values were present for a list of values attribute during import.

Product Catalog

Product Catalog User Guides

Product Catalog API

Developer Guide

Catalog Connector User Guides

Catalog Connector API

Importing Product Attributes

CSV File Guidelines

Attribute data formatting

Prerequisites

Procedure

Error messages

​CSV File Guidelines

​Attribute data formatting

​Prerequisites

​Procedure

​Error messages

​Related Topics

CSV File Guidelines

Attribute data formatting

Prerequisites

Procedure

Error messages

Related Topics