Troubleshooting Duplicate SKUs Error in NetSuite on Order Sync
You should always have unique SKUs in NetSuite across all item types. For example, with NetSuite Connector, you should not use the same SKU on both an inventory item and kit item.
Fixing Duplicate SKUs Error
If you have inadvertently used the same SKU twice, follow these steps to fix the problem.
To fix the duplicate SKUs error:
-
Determine which of the duplicate SKUs you are going to use in future.
-
For the SKU that you do not want to use,
-
Fulfill all the orders containing that SKU.
-
Change the SKU field to some unique value. For example, if the SKU value was MYSKU, change it to MYSKU-OLD.
-
-
Wait until the order sync process runs again. This time, NetSuite Connector should find only one matching SKU and sync the order.
Do not set the SKU that you do not want to inactive. NetSuite Connector will still continue to search that SKU and may show a different error about the SKU being inactive.
You should not delete the SKU that you do not want to use. If there are open fulfillments for the old SKU, you can face issues after deleting the SKU.
If you change the SKU value, you can always temporarily change it to the original value, if needed.