| using this methode we can do Category import if there are subCategory in the Category using CSV import |
Commerce Category Import
The commerce category import lets you add or update the following information for commerce categories:
- Commerce Categories
- Customer segment assignments
- Subcategories
- Category item assignments
- Category tags
- Category translations
Commerce categories are used to create a hierarchical structure of items in your web store. The fields supported for commerce category CSV import reflect those on the Commerce Category Record at Commerce > Content Management > Catalog & Categories > Commerce Categories. After the import, the categories and items are displayed on your site and are available for management through Site Management Tools and also through the Commerce Category record in NetSuite.
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.
The import includes categories and related sublists. These include:
- Commerce Category
- Commerce Category Customer Segment Assignment
- Commerce Category Items Sublist
- Commerce Category Subcategory Sublist
- Commerce Categories Tags Sublist
- Commerce Category Translation Sublist
See Commerce Categories for more information on categories, subcategories, and item assignments.
External ID Best Practice
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
Any category created with Site Management Tools or through the NetSuite UI are not assigned an external ID in the CSV file. After the export, you must manually enter an external ID for each record.
Updating Items in Commerce Categories
There are multiple ways to update the items or item sequence numbers in your commerce categories. Using a CSV import is normally the most efficient way to update your commerce categories. When using a CSV to update your items or item sequence numbers it is possible to overwrite existing data depending on the options used for the import.
To update items in Commerce Categories
- Create a saved search of your existing commerce category items. For more information, see Saved Searches.
- Export the saved search as a CSV.
- Update the CSV file with the new items and edit the list sequence numbers as needed.
- Create a new CSV import.
- Use the Import Assistant to import your updated CSV file. For more information, see Importing CSV Files with the Import Assistant.