Items, which are also referred to as products, are services or stand-alone objects sold individually. This document covers the process of importing items, which is done using a CSV or JSON file.

​
File Guidelines

You can import products using a .csv or .json file only. No other data or file formats are supported.
  • SKU is a required field to create or update an item.
  • You can detach child or variant items from the parent item when importing by entering detach in the Parent SKU field. When the parent/child relationship is removed, the child or variant item becomes a standalone SKU.
  • When updating or upserting items, entering null in a spreadsheet cell will override existing values with blank values.
Although not required, fabric recommends that you download the template file to use as a guide when creating your own file for import to minimize errors during the import process.

​
Attribute data format

When preparing your file for import, ensure that the attribute data format aligns with following attribute type requirements:
  • String: Ensure the data is in text string format. If a string attribute contains multiple values, the values need to be sent as a stringified array, for example: "a", "b".
  • Number: Numerical data only.
  • Boolean: Use true or false only; other values will be ignored.

​
Procedure

  1. In the left menu, click Catalog Connector > List > Items. The Items page is displayed.
  2. Click Import items. The Import CSV file window is displayed. This window provides a link to download example templates for .csv and .json files.
  3. To import a file, do one of the following options:
    • Drag the file into the window.
    • Click Select a File from your computer.
  4. Click Import file.
The file is imported and the items are added to your product list. fabric stores the files that you upload to your account. You can view the status of the import operation and re-download the original files by visiting the Import History page.

​
Troubleshooting

For a list of common errors when importing and how to correct them, refer to the following table:
Error MessageDescriptionImpactCommentComment
Internal Server ErrorServer issuesThe item isn’t created or updated.Try againThis is an intermittent issue.