Configuring Quantity Calculations in NetSuite Connector

TL;DR Opening

You can perform arithmetic operations on item quantities before syncing them to the storefront via the NetSuite Connector. This feature allows for operations like addition, subtraction, multiplication, or division, providing flexibility to adjust the quantities as needed. A common use case is to set a buffer by subtracting a specific amount from the quantity.

How to Perform Mathematical Operations on Inventory Before Quantity Sync

Start by following these steps to configure the desired arithmetic operations on inventory quantities:

1. Log in to your NetSuite Connector account at app.farapp.com.
2. Select the connector and the relevant account.
3. Navigate to Mappings > Products.
4. Based on your connector type, choose:
   • For marketplace connectors like Amazon or Walmart, select the category where your current inventory mapping resides from the Category list.
   • For other connectors, select either Price/Quantity Only or Full Product from the Select Sync Type field.
5. Once in the product mappings list, find the inventory mapping and click Special Mapping - Click to Edit.
   • The Inventory Mapping window opens. Ensure you have selected the correct locations or custom fields for inventory mapping.
   • Note: If the inventory field relevant to your storefront isn't visible, click Add Mapping to include it.
6. Click Add Operation Row to introduce a new operation.
7. From the Operations list, choose Subtract.
8. In the Value field, input 5 to set a buffer.
9. (Optional) For additional mathematical operations, repeat steps 7 and 8 as needed.
10. Click Save Changes once you've set the operations.
11. Finally, click Save to apply your configurations.

Key Considerations

• The ability to modify inventory quantities before syncing can greatly aid in maintaining accurate stock levels across your storefront and NetSuite environment.
• Ensure that the operations applied align with your inventory management objectives to prevent stock discrepancies.

Who This Affects

This configuration process primarily impacts:

• NetSuite Administrators: Managing data synchronization and inventory accuracy.
• eCommerce Managers: Ensuring storefront stock levels reflect actual availability.

Key Takeaways

• You can perform various arithmetic operations on item quantities before syncing.
• Setting buffers can help avert overselling items.
• Always review the inventory mappings and ensure fields are correctly linked.

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