Analysis that was submitted earlier to the client
Initial Setup – One-Time Sync
- Enable inventory tracking on product records in BigCommerce. This allows BigCommerce to manage inventory for items.
- Perform a one-time mass update to enable inventory tracking for all existing products already synced with BigCommerce. This will ensure that the available quantity for all products is updated and tracked in BigCommerce.
Ongoing Sync – Scheduled Inventory Updates
- Introduce a custom checkbox field on inventory-affecting transactions in NetSuite.
- Implement a scheduled script to run every 15 minutes. This script will:
- Identify unchecked inventory-affecting transactions.
- Retrieve the current available quantity for items from the designated location, The Nutty Company, and sync these quantities to BigCommerce.
- Automatically mark the checkbox for successfully synced transactions to avoid reprocessing.
- This ensures that inventory updates occur for every relevant transaction in NetSuite, maintaining accurate inventory levels in BigCommerce.
These Inventory effecting transactions will be considered for syncing inventory level
- Item receipts (PO, TO, Customer RMA)
- Item fulfillments (SO, TO, Vendor RMA)
- Standalone Bill
- Standalone Invoice
- Standalone Credit memos
- Standalone Bill credits
- Cash sale
- Inventory adjustments
- Inventory adjustment worksheets
Note:
- As per BigCommerce documentation, the product API supports syncing inventory levels only to the default location configured in the account. For now, we will sync inventory from the NetSuite location The Nutty Company.
- If multiple locations are introduced in BigCommerce in the future, this possibility needs to be checked.
- Please note that the sync process is scheduled and may result in a delay of up to 15 minutes.
The estimated effort for this update will be 26 Hours. Let us know if this solution aligns with your requirements or if adjustments are needed.
Please share your thoughts.
Work
Hours
Analysis
4h
One time sync
4h
Scheduled inventory level sync
- Checkbox creation – 30m
- Script logic structuring – 2h
- Script development – 6h
8.5h
Testing
3.5h
Live deployment
2h
Project mgmt
4h
Estimated effort: 26 Hours