Matching Order Totals Between NetSuite and Storefront

To ensure all order totals in NetSuite accurately reflect those posted on your storefront, it's essential to implement specific best practices. This guarantees that item prices, discounts, and tax totals align correctly during the order import process. Here’s how to achieve that:

Best Practices for Matching Order Totals

1. Verify Item Prices
   Ensure that the item prices on orders align with those set up in NetSuite. By default, the NetSuite Connector applies prices from the storefront order unless a specific mapping is established. If you’ve configured your Order Item mappings to employ a price level other than -1 or Custom, NetSuite prices are automatically used, leading to possible mismatches.
   To check this, go to Mappings > Orders and access the Order Item Mappings page. Set the Price Level Mapping to Custom (IID: -1) for the relevant storefront or account. To create a new mapping, click Add Mapping Row if none exists.

2. Set Up Discounts in NetSuite Connector Settings
   If an order includes a discount, ensure it exists within NetSuite. If it is not established, create the appropriate discount in NetSuite Connector for successful importation. Refer to the section on Managing Order Discounts in NetSuite Connector for detailed guidelines.

3. Ensure Tax Totals Are Accurate
   It’s crucial that the tax totals from the storefront order match those in the NetSuite order. To configure taxes appropriately, ensure you verify settings in the Configure Taxes section found in the documentation for Setting Up NetSuite Connector Order Sync.

4. Discount Items Setup in NetSuite
   For any order containing a discount, remember to check the Apply Before Taxes box on the relevant discount item within NetSuite. Detailed instructions can be found in Applying Sales Tax or VAT to Discount Items and Applying VAT Before or After Discounts. For comprehensive review, read Configuring Discount Settings in NetSuite Connector to verify your configurations.

Key Considerations

• Track Discounts: Post all discounts as a generic item on the order header in NetSuite to ensure the order’s total displays correctly against the totals from marketplaces or carts.
• Automatic Discount Configuration: The NetSuite Connector SuiteApp can automatically create and configure the generic discount item, reducing the need for manual setups.

Conclusion

By following these best practices, you can ensure that all aspects of your online orders in NetSuite remain consistent with your storefront's order totals. This alignment is vital for accurate reporting and effective management of your eCommerce business.