Richard Andrew
10/01/2025, 8:44 AMCeligo AI
10/01/2025, 8:44 AMAI generated answer (using internal Slack threads):Based on the conversations, the best way to detect when inventory stock is updated in NetSuite and trigger your backend endpoint to update BigCommerce whenever an item’s quantity changes for a specific inventory item would be to use a scheduled SuiteScript. You can create a SuiteScript that runs at regular intervals (for example, every 10-15 minutes) and checks for changes in the
lastquantityavailablechange field. This field tracks the last time the available quantity of an item changed. If there is a change, your script can then trigger your backend endpoint to update the quantity in BigCommerce.
Here's a high-level overview of how you might implement this:
1. Create a SuiteScript that runs on a schedule.
2. In the script, fetch all items where the lastquantityavailablechange field has changed since the last time the script ran.
3. For each item that has changed, call your backend endpoint to update the quantity in BigCommerce.
4. Store the time the script ran so you can use it the next time to fetch only items that have changed since then.
Please note that this method is not real-time and there might be a delay between when the stock changes in NetSuite and when it gets updated in BigCommerce. Also, unapproved quantities are not factored into the available figure, which might result in over-reporting.
******
Disclaimer:
This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******Celigo AI
10/01/2025, 8:44 AMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.848144531
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.837524474
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.831420898
Celigo AI
10/01/2025, 8:44 AM