Overview

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.
  • We recommend 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:

AttributeDescription
Attribute TitleThe name of the attribute.
Type of AttributeSpecifies the attribute type, such as text, number, date, Boolean, serial, or list of values.
Description (Optional)Provides additional details about the attribute.
DecimalIndicates if the attribute allows decimal values. Valid values are true (allows decimals) or false (only whole numbers). Applicable only to number-type attributes. The default value is true.
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 FormatSpecifies 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.
MandatorySpecifies whether the attribute is required. Valid values are true (mandatory) or false (optional).
Start WithDefines the starting value for a serial-type attribute. Applicable only to serial-type attributes.
Increment bySpecifies 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 (list of values) or false (not a list). To specify options, use additional columns (Value 1, Value 2, Value 3).

Prerequisites

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

Procedure

  1. In the left menu, click Product Catalog > Attributes > Product. The Product Attributes page is displayed.
  2. Click Import. The Import CSV file window is displayed, providing a link to download an example template for the CSV file.
  3. 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.
  4. Click Import file. The CSV file is imported, and the product attributes are added.