PIM is now called Products
Some of fabric's products are undergoing name changes. PIM is becoming Products, but you may see the old name in some places as we make the transition.
Products enables importing data from external sources using a CSV document.
The operations on this page require attributes and categories to be configured in advance. If this is your first entry, visit the Quickstart Guide to complete the necessary setup.
Category Node: This represents the category of Category where the item belongs and has to be provided to create an item. Any item without a node will not be created.
SKU: It is mandatory to provide a SKU for all items.
Parent SKU: This is only required for item variant SKUs. Leave this field blank if the item doesn't have a parent.
Products only accepts CSV files; no other data or file formats are accepted at this time.
Category Node is mandatory. If the category node is missing, the item will not be created.
Delimiter for the category nodes is “->”. If the Category node is not mapped correctly or not found in the system, the item will not be created.
Headers of the CSV file (first row) represent the attributes of the item. Attribute titles are not case sensitive, but we recommend you maintain case-consistency with the original attribute titles.
Formulas in formula-driven attributes will be executed automatically after items have been imported.
Empty rows and columns are ignored.
Attribute data format must conform to attribute type requirements:
- Text: text string
- Number: only numbers are imported; other data is ignored
- Boolean: TRUE or FALSE only; other values are ignored
- Date: use the same format used during attribute creation
- List of values: the value must be an exact match to one of the list values
- Serial: leave this blank
SKU must be provided for the items to be created.
Status attribute will be imported as Live only when all mandatory attributes are provided for the item, otherwise it will automatically change to Draft no matter what value was given in the spreadsheet.
In case the CSV doesn't have an attribute that is added to the Category, you can simply add a new column in the CSV and put the attribute name in the header and upload will populate the value for this attribute.
Go to the Items page.
Search for or browse to the appropriate category node and click Next.
Select Choose file and navigate to your file to upload.
To obtain a template to review and populate, select the template here link in the dialog box.
Click Upload file. You can monitor the status of your upload inImport History.
The status of bulk imports is available on the Import History page.
To view your past imports, go to the Item list page.
Click Import History to see all imports with their status.
Clicking on any listing will take you to the Import Summary for that upload to view additional details including errors. The operation is all or nothing. Any errors prevent any portion of the upload.
You can export errored items, correct the errors, and re-upload the file.
- File name - title that will appear when item is visible on a webpage.
- Type - number of alternative versions such as color or size.
- Status - successfully Completed or Failed with error.
- Created - date uploaded to Products.
- Message - Import successful or Errors identified if more than one type.
Clicking on any listing in the Import History page will provide details on that import.
Export errored items will download a copy of the file originally uploaded and a CSV file with all errors listed.
Download original file will download a copy of the file originally uploaded.
|Error Message||What it means?||What happens to the item?||How to resolve?||Comment|
|Category Node not found||Category Node name is incorrect or missing.||Item can’t be created without a proper category node given.||Verify the name of the node and the delimiter.|
|Internal Server Error||Server issues||Item is not created/updated||Try again||This is an intermittent issue, might come randomly.|
|“Attribute Name” not found||The attribute mentioned in the CSV header is not added to the Category. Attribute Name must be an exact match.||Item is created but this specific attribute will be ignored.||Check the name of the attribute, ensure that this attribute is added to the Category you are trying to import items for.|
|“Attribute Name” value is invalid||The value provided has some flaws/validation issues.||The attribute value will not be saved to the item.||Provide correct attribute value.||Example - if you add a text for a number type attribute, you will receive this error.|
|Status Mandatory attributes required||In order to set Status = Live for an item, all mandatory attributes are required.||Item will be created and attributes will be updated. Item can’t be set to Live; Item Status will default to Draft.||Ensure that all mandatory attributes have a value in the CSV you are trying to import.||When doing a delta import, it is required to have all mandatory attributes and values added for the existing items for the “Live” attribute.|
|Some mandatory attribute values are missing.||There are some mandatory attributes for the category/items that need values. These could be global mandatory (set at the attribute level) or category mandatory (Set at the individual category level).||Item is created with errors. Only given attribute values will be added.||Include values for all the mandatory attributes.||Items can always be created with errors, but they can’t be published unless all mandatory attributes have a value.|
Updated about 1 month ago