Hello all,
I'm reaching out to seek advice on an issue we're experiencing with the NetSuite Connector, which we use to sync inventory levels between NetSuite and our Amazon listings using realtime sync. We can't use the scheduled interval sync as that caused listing to never come back in stock despite the sync. Here's a brief overview of the problems:
- Inconsistent Inventory Sync: Some listings do not update correctly, causing them to display incorrect inventory quantities. For example, despite syncing a quantity of 10, the listing continues to show 15, which is several days old.
- Underreported Inventory: Other listings show fewer items than we actually have in stock. For instance, we sync 10 units, but the listing only shows 6.
- Inactive Listings Despite Ample Stock: Occasionally, a listing goes inactive due to supposed lack of inventory, even though we have a large quantity available (e.g., syncing 200 units, but the listing is inactive).
- Missing SKUs in Reports: SKUs disappear from inventory reports for entire days. For example, SKU 123 is reported to have 385 units on Monday, vanishes from Tuesday's report, and reappears on Wednesday with 835 units. Whether that's an error in the report or the listing did actually vanish for a day I cannot tell.
- Consistency: This problem has existed across a varierity of SKUs that are inventory items, serialized inventory items and kits. The consistency is it's inconsistency.
- Band-Aid: If I edit any field mapped to amazon it forces a correction across all skus. To keep things afloat I've been changing our synced price +/- a penny.
- Vendor Support: This is one of those cases where NetSuite and Amazon have had no idea what's happening and the escalations have existed for a while with both sides.
This has been a true Twilight Zone issue and I've not found anything online that matches our specific circumstances. Any thoughts?
