Subtracting Backordered Quantities in NetSuite Connector

Starting in NetSuite Connector, by default, backordered quantities are not considered when syncing inventory across multiple locations. For instance, if you have two locations, A and B, and an item has 19 backorders with no available quantity at location A, and 1 backorder with 25 available at location B, the connector will sync the full available quantity of 25 from location B. However, you can configure the connector to subtract the total backordered quantity from the available quantity before synchronization.

How to Subtract Backordered Quantity

To set up this subtraction during inventory synchronization, follow these steps:

1. Log in to app.farapp.com.
2. Select the connector and the relevant account.
3. Navigate to Mappings > Products.
4. Depending on the type of connector:
   • For marketplace connectors like Amazon or Walmart, select the category in the Category list related to your inventory mapping.
   • For other connectors, choose either Price/Quantity Only or Full Product from the Select Sync Type field.
5. In the product mappings list, find the relevant inventory mapping and click on Special Mapping - Click to Edit.
6. In the inventory mapping window, ensure you have the correct inventory field mapped. If not visible, click Add Mapping to create it.
7. Check the box labeled Subtract Backordered Quantity At Selected Locations From Total.
8. Click Save Changes.
9. Finally, click Save.

Following these steps will enable NetSuite Connector to reduce the quantity it syncs based on the total backordered quantity at specified locations.

Note: Always double-check your mappings to ensure that the correct fields are included to avoid syncing errors. This configuration helps maintain accurate inventory data across multiple sales channels, preventing overselling and improving customer satisfaction.

Who This Affects

• Administrators: Users responsible for setting up inventory sync configurations.
• Developers: Users customizing or integrating the NetSuite Connector with external platforms.
• eCommerce Managers: Users managing marketplace and storefront inventory.

Key Takeaways

• NetSuite Connector can be configured to subtract backordered quantities when syncing inventory.
• Accurate inventory management is vital to prevent overselling.
• The configuration process involves mapping settings in the connector interface.

Source: This article is based on Oracle's official NetSuite documentation.