Ensuring That NetSuite and Storefront Order Totals Are Matching
You must ensure that every order and total in NetSuite is imported correctly by NetSuite Connector to match what is posted on the storefront. To do this, follow these best practices:
-
The prices of the items on the order must match the prices set up in NetSuite.
By default, the NetSuite Connector will override the prices set up for items in NetSuite and will use the item prices on the order. This ensures that item totals match. If you have setup your Order Item mappings to use a price level other than -1, or Custom, the NetSuite prices will be used instead, which can cause mismatched order totals. If you notice that the item prices on the order in NetSuite do not match those on the storefront order, go to Mappings > Orders to open the Order Item Mappings page. Then, ensure that your mapping for Price Level is set to Custom (IID: -1) for this storefront or account. If you do not have a Price Level mapping yet, you can add one by clicking Add Mapping Row.
-
Configure discounts in the NetSuite Connector discount settings before applying them to orders.
If there is a discount on a particular order, you must check if that discount is included in NetSuite. If not, you must set up the discount in the NetSuite Connector so that they import properly into NetSuite. For more information, refer to Managing Order Discounts in NetSuite Connector.
-
The tax totals on the NetSuite order must match those from the channel order.
For taxes to import correctly into NetSuite, you must configure them in NetSuite Connector. If the tax total in NetSuite is incorrect, refer to Configure Taxes in Setting Up NetSuite Connector Order Sync.
-
Configure discount items in NetSuite.
If an order has a discount, you must check the Apply Before Taxes box on the discount item in NetSuite. For more information, see Applying Sales Tax or VAT to Discount Items and Applying VAT Before or After Discounts.
To review your configuration, refer to Configuring Discount Settings in NetSuite Connector.