How we can add the category in the Commerce Category implementation for the NetSuite and this will show in the Webstore as well.
For this we’ve to use CSV files in the three levels i.e. level1, level2 and level3. And here these three level means Parent Category, Sub Category and Child Category of implementation.
In the first step you’ve to create CSV files in excel sheets in your system and you’ve to create the Columns in that with the required names for Commerce Category.
It should be used in while mapping the fields when we import these files into NetSuite account import tab in account. You must’ve create all the required columns in the CSV files i.e.
- EXTERNAL ID(Required) Always in the First position
- NAME(Required)
- DESCRIPTION
- CATALOG(Required)
- PRIMARY PARENT(Required)
- PAGE TITLE(Required)
- HEADING(Required)
- URL FRAGMENT(Required)
- PAGE BANNER
- THUMBNAIL IMAGE
You must note External Id before importing your CSV files if you import without knowing external Id it’ll overwrite all the existing category and some will lost as well for that you take backup first from the Commerce Categories page then you’ll the external id and start with new Id.
After doing these steps you’re ready to import your CSV files into NetSuite account for that you can use path.
Setup -> import/export -> import CSV records
from the upcoming page there you’ve to choose Website as Import type from dropdown and commerce category from the Record type from dropdown.
Upload your files and if everything is correct you’ll see the Field Mapping page and Mapping should be done automatically if every column you’ve added in the CSV file. And if this will done you’ll have next page for add a name for record and after that you can check your progress in the status section.
Note
- Alternatively we can do all these things in the NetSuite account as well but this is not easy and sometimes not possible since it’s time consuming process and while you inserting your records in the account and someone will login in the same account your all changes will lost.
- This is only for Commerce category implementation.