Configuring Assembly Item Quantities in NetSuite Connector

NetSuite Connector allows you to synchronize both the quantity of assembled items and the quantity of buildable items from specific locations for assembly items. If your focus is solely on syncing the quantity of assembled items, you must adjust your settings accordingly in the product mappings.

How to Change the Sync Quantity for Assembly Items

Follow these steps to configure the sync settings for assembly items in NetSuite Connector:

1. Log in to NetSuite Connector.
2. Select the connector and the relevant account.
3. Navigate to Mappings > Products. The Product Mappings page will display.
4. Depending on your connector type, determine the sync type:
   • For connectors like BigCommerce and Shopify, choose your sync type under the Select Sync Type section by clicking either the Price/Quantity Only or Full Product button.
   • For marketplace connectors such as Amazon and Walmart, select the generic marketplace category from the dropdown. The sync type buttons will not be available for these.
5. Locate the inventory field—specifically, find inventory_level under the BigCommerce Field column. If this field is missing, you can add it by clicking the Add Mapping button.
6. Edit the product mapping:
   1. Click the Special Mapping - Click to Edit link next to the NetSuite Field ID column, leading to the inventory_level Mapping page.
   2. Choose the appropriate locations for inventory syncing.
   3. Uncheck the box labeled For Assembly Items, Include Buildable Quantity When Syncing Total. This action restricts the sync to only the assembled quantity, excluding any buildable quantity.
   4. Click Save Changes once you've made your selections.
7. Finally, remember to click Save on the Product Mappings page to apply your changes.

Key Considerations

• Ensure you have the correct sync type selected to avoid potential issues in data synchronization.
• Regularly check your mappings and sync settings to maintain optimal performance and accurate inventory levels.

Who This Affects

This configuration process is relevant for:

• Administrators managing inventory syncs
• Developers working on integrations with eCommerce platforms
• Accountants seeking accurate financial tracking via inventory management

Key Takeaways

• You can configure the sync settings to include only assembled item quantities.
• Adjust settings in the Product Mappings to ensure proper inventory synchronization.
• Regular review of sync configurations can help prevent issues in data management.

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