NetSuite limitation of the customer-subcustomer hierarchy in the Shopify-NetSuite Integration App – Celigo Help Center

Issue:

One of the configuration options in the Customer Import data flow is to set the imported Customers as child records of a default Parent Customer. Unfortunately, NetSuite places a limitation of a maximum of 10,000 sub customers (all levels included) in a customer hierarchy. Once this limit is reached, NetSuite will not allow the creation of a new sub customer. This will cause the Order Import data flow to fail.

Reference: NetSuite Help Guide

"NetSuite limits the maximum number of customers you can include in a customer-sub customer hierarchy. A customer hierarchy is comprised of the top-level parent customer, all of its sub customers, and all of its sub customers. You can have a maximum of 10,000 customers and sub customers in a customer hierarchy.

This limit is in place to improve performance. If you need to increase your account's limit, please contact NetSuite Customer Support. Going beyond the set hierarchy limit may cause a performance impact related to customer credit limits, customer balances and consolidated balances, as well as payments to the top-level customer."

There are two alternate solutions.

Solution 1: The first solution is to configure the Customer Import data flow to add the Customers to a new, or different, Parent Customer record.

Solution 2: Alternately, if the use of a Parent Customer is not needed, this issue can be resolved by removing the Parent Customer mapping. The default Integration App setup only uses one default Customer.

Related articles