Import Commerce Categories from Site Builder to SuiteCommerce

Perform the following tasks to convert existing Site Builder Categories to Commerce Categories:

• Install Commerce Categories Migration Tools
• Export Site Builder Categories
• Create Commerce Categories
• Set Field Mapping

1. Install Commerce Categories Migration Tools

To convert existing Site Builder Categories to Commerce Categories, perform the following actions:

1.Request Migration Tool Bundles

If you cannot locate the following bundles on your NetSuite account, submit a Bundle Provisioning Request (BPR).

• Site Category Export – bundle ID 155283.
• Commerce Category Import – bundle ID 153740.

To submit a BPR:

1. Log in to NetSuite with your primary role and go to Cases > Other Lists > Bundle Provisioning > New.
2. Complete all fields marked with an asterisk (*).
3. Under Bundle to Share, choose the following:
   • Site Category Export – bundle ID 155283.
   • Commerce Category Import – bundle ID 153740.
4. Go to the Target Accounts tab to share the bundles with additional accounts.
5. In the Target Account Numbers field, enter the account numbers.
6. Click Save.

If you are unable to submit a BPR, contact the NetSuite account manager to provision the bundles to the NetSuite account.

2. Install Site Category Export Tool

The Site Category Export tool generates a CSV file from Site Builder Category records.

To install the Site Category Export tool:

1. Confirm SuiteTalk web services are enabled for the NetSuite account by going to Setup > Company > Enable Features. To enable SuiteTalk web services, go to the SuiteCloud tab and in the SuiteTalk (Web Services) area, check the SOAP Web Services box.
2. Install the Site Category Export bundle (bundle ID 155283).
3. Configure SOAP web services integration if you have not already done so.
4. Locate your integration application ID by going to Setup > Integration > Integration Management > Manage Integrations (Administrator).
5. Update the Site Category Export script parameters with the integration application ID by going to Customization > Scripting > Script Deployments.
6. Click Edit next to the script, NSTS | SL | Export Site Categories, and perform the following actions:
   • In the NS SUITETALK APPLICATION ID field, enter the integration application ID (for example: 0880BF13-7ADB-4C8B-95FA-9C8EBBA25650).
   • For NetSuite sandbox accounts, update the NS SUITETALK DOMAIN field value to webservices.sandbox.netsuite.com.
   • Click Save.

To export the subcategory order (optional):

1. Go to Documents > Files > File Cabinet.
2. Copy the ExportCategories.Service.ss file from the bundle folder (for example: SuiteBundles > Bundle 155283) to the website service directory (for example: Web Site Hosting Files > Live Hosting Files > SSP Applications > NetSuite Inc. — SCA 2023.1.0 > Development > services).
3. Update the Site Category Export script by going to Customization > Scripting > Script Deployments.
4. Click Edit next to the script, NSTS | SL | Export Site Categories, and perform the following actions:
   • In the SCA Export Categories Domain field, enter your website domain (for example: demo.production.example.com).
   • In the SCA Export Categories SSP URL Component field, enter the SuiteScript Server Page URL (for example: sca-dev-2023-1-0).
   • Click Save.

3. Install Commerce Category Import Tool

The Commerce Category Import tool lets you import a CSV file of category information created by the Site Category Export tool for use in your Commerce Categories. 

To install the Commerce Category Import tool:

1. Go to Customization > Scripting > Script Deployments.
2. Click Edit next to the deployment record for the Commerce Category Import Tool Suitelet.
3. Go to the Parameters tab and set the Commerce Category Import Folder field to the internal ID of the folder in the file cabinet where the CSV import files is located.

Step 2 – Export Site Builder Categories

Step 3 – Create Commerce Categories

Step 4 – Set Field Mapping