Salesforce–NetSuite Sync for Household Brands Serving Janitorial Distributors

What this looks like in household consumables

A household-product manufacturer sells through a janitorial distributor that supplies schools and office facilities. Sales tracks those end facilities as opportunities, but the distributor is the payer. A naive account sync could create financial customers for every facility and move order history away from the actual buying relationship.

Records, ownership, and update rules

Work through the process

1. 01
   Identify who buys and who receives

   Map the distributor, end facility, and delivery destination separately. Direct shipment to an end facility does not automatically make that facility the financial customer.
2. 02
   Define the shared fields

   Select account identifiers and approved status information sales needs. Keep financial balances and terms under finance ownership while allowing sales to manage the relationship context.
3. 03
   Review new account creation

   Resolve whether a new opportunity belongs to an existing distributor payer before creating another ERP customer. Require approval for changes to the legal billing relationship.
4. 04
   Test channel reporting

   Check that sales can see the end-facility opportunity while finance still attributes the order and payment to the correct distributor. Preserve both relationships in reconciliation.
5. 05
   Ship one order to a school and check who NetSuite bills

   Take a real order where the distributor buys but the goods go straight to a school it serves. In Salesforce, log the school as end-facility context on the distributor account and let the records sync. Then open NetSuite: the customer list should hold no new entry for the school, the sales order should name the distributor as the customer, and the ship-to address should be the school. Repeat with an opportunity created for a second facility under the same distributor. A school appearing as a NetSuite customer, or a sales order billed to the facility, stops the rollout until the account-creation review is fixed.

Handle the exceptions explicitly

Goods ship directly to a facility

Keep the distributor payer and actual destination explicit.

Distributor changes its billing entity

Require finance review and preserve historical transaction ownership.

Facility name matches an existing customer

Use approved identifiers and relationship evidence rather than a name-only merge.

What to verify before expanding

• End-facility activity does not become an unintended legal customer.
• Orders retain both the correct payer and actual receiving destination.
• A direct-to-facility order preserves the distributor payer and actual ship-to as separate relationships.
• A facility sharing a name with an existing customer cannot merge accounts without approved identifier and relationship evidence.

Technical references

• Stacksync two-way sync quick start
• Stacksync NetSuite supported objects