In commerce category import, External ID is a required value. This serves as a unique ID key for the record. This can be user-defined for a manually generated CSV import file.
The commerce category import lets you add or update the following information for commerce categories:
- Commerce Categories
- Subcategories
- Category item assignments
- Category tags
- Category translations
You can use the fields referenced here to create CSV files for import. You can manually create the CSV files or export them from another system, including SiteBuilder Categories.
External ID
Each CSV file includes an External ID column. Use the external ID in your CSV files to link the rows in one file to the relevant row in another file. You should also use the external ID for columns that reference a subcategory. Even though you can use the category names in these columns, category names are not necessarily unique and it is best practice to use the External ID instead.
Note: Refer SuiteAnswer ID: 70210 for more related information