How to: Bulk Insert Stores, Warehouses, and Customers to a Hierarchy Node

In this article

To bulk insert stores to a Store, Warehouse Location, or Customer Hierarchy node

To bulk insert warehouse locations to a Store, Warehouse Location, or Customer Hierarchy node

To bulk insert customers to a Store, Warehouse Location, or Customer Hierarchy node

The same procedure applies whether you are adding Stores, Warehouses, or Customers to a Hierarchy node: 

  1. Click the icon, enter Hierarchy, and select the relevant link.
  2. Select a hierarchy of the type Store/Warehouse Loc./Customer (the Type column), and click the Edit Hierarchy action.
  3. In the Type column on the Hierarchy Node Links FastTab, select either Store, Store Group, Warehouse Location, Customer, or Customer Group in the Type field, depending on the type of link you want to add.
  4. To add a selection of stores, warehouses, or customers, click the Add action, and then the appropriate action (Add Stores, Add Warehouse Locations, or Add Customers) and fill in the filters.

    Note: To add a single store, warehouse, or customer instead of a bulk, click the arrow in the No. column and select from the list.

To bulk insert stores to a Store, Warehouse Location, or Customer Hierarchy node

Example: 

You have created a new hierarchy tree called STORES with two nodes, NORTH and SOUTH. Now you want to add all stores with a name that contains the word "North" to the NORTH node:

  1. On the Hierarchy page, click the Edit Hierarchy action, and in the Edit Hierarchy - STORES page, place the cursor on the NORTH line and click the Add - Add Stores action.
  2. A list of filters is displayed where you can enter your search criteria, "North", in the Name filter.
  3. Click OK.
  4. The stores that have a name containing the word "North" have now been added to the node.

To bulk insert warehouse locations to a Store, Warehouse Location, or Customer Hierarchy node

Example:

Your new hierarchy tree has a Node called WAREH and it has only one Node, Warehouses. Now you want to add to that node all warehouse locations that have a name containing the word "Warehouse":

  1. Click the Edit Hierarchy action, and in the Edit Hierarchy - WAREH page, select the WAREHOUSES line and click the Add - Add Warehouse Locations action.
  2. Fill in the filters to include only the warehouses you want to insert under your node.
  3. Enter "Warehouse" in the Name filter field, and click OK.
  4. All locations that have a name containing the word "Warehouse" have now been added to the node.

To bulk insert customers to a Store, Warehouse Location, or Customer Hierarchy node

Example:

Your new hierarchy tree has a Node called CUSTOMERS with three child nodes, DOMESTIC, EU, and FOREIGN. You want to add to the DOMESTIC node all Customers with a Customer Posting Group = DOMESTIC.

  1. Click the Edit Hierarchy action, and in the Edit Hierarchy - CUSTOMER page, select the DOMESTIC line.
  2. Click the Add - Add Customers action.
  3. In the Add Customers to Hierarchy Node page, enter "DOMESTIC" in the Customer Posting Group filter field, and click OK.
  4. All customers with the DOMESTIC value have now been added to the Node.