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 inventory items to a merchandise hierarchy

  • Update existing inventory items to assign them to a merchandise hierarchy

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 by CSV

You can add and assign new inventory items to a merchandise hierarchy or assign existing inventory items to a merchandise hierarchy by CSV import.

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

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 below)

  • 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.

The Assigned Node Name in the CSV file is the parent node which represents the full path of the selected node back to the root node of the merchandise hierarchy.

Note

Before you can create or update inventory 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 inventory items by CSV, see the Items Import topic.