Creating a Merchandise Hierarchy by CSV


You can create parts of a merchandise hierarchy by CSV import when you have merchandise hierarchy data available in a CSV (comma-separated value) file.

You can do the following:

  • Import merchandise hierarchy nodes to an existing merchandise hierarchy version (import type: Classification)

  • Import items to a merchandise hierarchy (import type: Items)

  • Update existing items to assign them to a merchandise hierarchy (import type: Items)

  • Apply attributes to items assigned to a merchandise hierarchy (import type: Items)

You cannot import merchandise hierarchy versions or levels. Therefore, before you import merchandise hierarchy nodes, you must first create a hierarchy version and the levels to which the nodes will be assigned. For more information, see Creating a Hierarchy Version and Creating a Hierarchy Level.

For more information, see the CSV Imports topic.

Creating Nodes in Bulk by CSV

When you are creating a new merchandise hierarchy, adding new nodes to an existing hierarchy, or re-parenting existing nodes you can import the nodes in bulk by CSV import.

The following is an example of a CSV file and the results displayed in the Hierarchy Manager when the CSV file is imported into NetSuite.

Note that the parentnode value assigns a parent node using the ExternalID of the parent node. For example, the parentnode value for Women’s Wear is 100, this is the ExternalID for NORSO, and therefore makes NORSO the parent node for Women’s Wear.

For information regarding the importing of merchandise hierarchy nodes by CSV, see the help topic Merchandise Hierarchy Node Import

Assigning Items and Applying Attributes by CSV

You can add and assign new items or existing items to a merchandise hierarchy by CSV import. You can also apply existing attributes to the items in the same CSV import.

The following image is an example of a CSV file containing items and attributes.

Note that you can assign a parent node for an item in two ways:

  • Enter the Internal ID of the parent node (as shown in the example above). During the import, remember to change the reference type of the parent node to Internal ID when mapping the fields.

  • Enter the full path of the selected node back to the root node of the merchandise hierarchy. For example NORSO : Women's Wear : Bottoms : Pants. If you select this method you will have to ensure that the path is entered correctly, observing that there is space, a colon, and another space in between each node in the path.

You can apply attributes by adding existing attribute values to a column or columns in the CSV file. The Attributes will be available to map to in the list of NetSuite fields.

After the items have been imported you will see the items assigned to the appropriate node in the Hierarchy Manager.


Before you can create or update items to be assigned to a merchandise hierarchy by CSV, you must first create the hierarchy nodes to which the items will be assigned.

For information regarding importing or updating items by CSV, see the Items Import topic.