With fabric Product Catalog, you can import data from external sources by using a CSV file.
Ensure that you have configured attributes and categories to import data through CSV.
Generate a CSV file to import items, bundles, categories, or product attributes.
Category Node: This represents the category to which the item belongs and is mandatory to add an item.
SKU: The Stock Keeping Unit (SKU) must be specified for all items that needs to be imported.
Parent SKU: This is can be optionally included for item variants. Leave this field blank if the item does not have a parent.
Live
only when all the mandatory attributes are specified for the item. Otherwise, it automatically changes to Draft
status, regardless of the value in the file.requestBody
type to view the select file option and upload a CSV from local system.Error Message | Description | Impact | Troubleshooting | Comment |
---|---|---|---|---|
Category Node not found | Category Node name is incorrect or missing. | Item cannot be created without a proper category node. | Verify the name of the node and the delimiter. | |
Internal Server Error | Server issues | Item is not created or 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. | The item is created but this specific attribute is ignored. | Check the name of the attribute, ensure this attribute is added to the Category to which you are trying to import the items. | |
“Attribute Name” value is invalid. The value provided did not pass the validation. | The attribute value is not saved to the item. | Specify the correct attribute value. | For example, if you add a text for a number type attribute, you will get this error. | |
Status Mandatory attributes required | To set Status as Live for an item, all the mandatory attributes must be filled out. | The item will be created and attributes will be updated. Item cannot be set to Live. Its status defaults to Draft. | Ensure 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 or 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 the specified attribute values are added. | Include values for all the mandatory attributes. | Items can always be created with errors, but they cannot be published unless all mandatory attributes have a value. |
With fabric Product Catalog, you can import data from external sources by using a CSV file.
Ensure that you have configured attributes and categories to import data through CSV.
Generate a CSV file to import items, bundles, categories, or product attributes.
Category Node: This represents the category to which the item belongs and is mandatory to add an item.
SKU: The Stock Keeping Unit (SKU) must be specified for all items that needs to be imported.
Parent SKU: This is can be optionally included for item variants. Leave this field blank if the item does not have a parent.
Live
only when all the mandatory attributes are specified for the item. Otherwise, it automatically changes to Draft
status, regardless of the value in the file.requestBody
type to view the select file option and upload a CSV from local system.Error Message | Description | Impact | Troubleshooting | Comment |
---|---|---|---|---|
Category Node not found | Category Node name is incorrect or missing. | Item cannot be created without a proper category node. | Verify the name of the node and the delimiter. | |
Internal Server Error | Server issues | Item is not created or 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. | The item is created but this specific attribute is ignored. | Check the name of the attribute, ensure this attribute is added to the Category to which you are trying to import the items. | |
“Attribute Name” value is invalid. The value provided did not pass the validation. | The attribute value is not saved to the item. | Specify the correct attribute value. | For example, if you add a text for a number type attribute, you will get this error. | |
Status Mandatory attributes required | To set Status as Live for an item, all the mandatory attributes must be filled out. | The item will be created and attributes will be updated. Item cannot be set to Live. Its status defaults to Draft. | Ensure 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 or 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 the specified attribute values are added. | Include values for all the mandatory attributes. | Items can always be created with errors, but they cannot be published unless all mandatory attributes have a value. |