Auto-increment orders by 1. Incrementing by 3 is confusing when syncing externally.

[Ryanvlogica016]

We submitted a ticket saying we synchronize orders in Magento to NetSuite. We bring them over using the Magento ID as the sales order ID in NetSuite (itemid, not internalid). Incrementing by 3 is very confusing for our staff, making it hard to notice if an order has been overlooked in processing. This can lead to frustrated customers and lost revenue. The idea that this is a restriction of Adobe Cloud's database clusters and cannot be fixed is frustrating.

[jagdishvnm4b47]

That sounds like a frustrating issue, especially when order tracking and reconciliation are so critical. In NetSuite Magento integration, a practical workaround is to create a custom field in NetSuite that stores a sequential reference number while keeping the original Magento order ID intact. This way, your team can rely on a clean sequence for internal processing while still maintaining the Magento ID for external reference.

Another approach is to use a middleware or script that normalizes order numbers before syncing them to NetSuite, ensuring they follow a consistent pattern. If the issue is tied to Adobe Commerce’s cloud infrastructure, applying a logic layer in the integration can help mitigate the confusion.