Skip to main content
Question

Amazon Connector: order import fails with duplicate ASIN cross-reference on stock and non-stock items

  • July 21, 2026
  • 4 replies
  • 32 views

Jeff96
Captain II
Forum|alt.badge.img+5

We are using the  native Amazon Connector (BC201020), importing seller-fulfilled orders.


I originally set up an item as a stock item and added its ASIN as an Alternate ID (Global type) on the Cross-Reference tab. We later decided the item should be a non-stock item instead. I created the non-stock item, removed the cross-reference row from the stock item (and saved), and added the same ASIN as a Global cross-reference on the non-stock item.


When the Amazon Connector imports an order containing that ASIN, it errors out saying the cross-reference exists on two items — both the original stock item and the new non-stock item.

**What I've checked:**
- Reopened the stock item (IN202500) — the cross-reference row is not visible on the Cross-Reference tab.
- The non-stock item (IN202000) shows exactly one row for the ASIN, Alternate Type = Global.
- Only one UOM row exists per item; no duplicates within either item.

**Questions:**
1. Is there a place other than the item's Cross-Reference tab (e.g., a residual row in INItemXRef by different AlternateType, or a hidden UOM variant) where the old mapping could still be living?
2. Does the Amazon Connector cache a SKU → InventoryID resolution in prepared data or in BCSyncStatus/BCEntityStats such that clearing/reprepping is required after moving a cross-reference between items?
3. If so, what's the recommended reset — delete the failed sync record on Process Data (BC501500) and re-prepare, or something more involved?

 

4 replies

Yuri Karpenko
Captain II
Forum|alt.badge.img+7

@Jeff96 , find that association in the Sync History screen, delete it (for Stock Item). And then try to process the order again.


Forum|alt.badge.img+1

@Jeff96 
I would recommend to please create a support case for us. It should not happen if the reference has been removed from stock item. 


Jeff96
Captain II
Forum|alt.badge.img+5
  • Author
  • Captain II
  • August 13, 2026

@Jeff96 , find that association in the Sync History screen, delete it (for Stock Item). And then try to process the order again.

Unfortunately, this didn’t help. 


Yuri Karpenko
Captain II
Forum|alt.badge.img+7

@Jeff96 , find that association in the Sync History screen, delete it (for Stock Item). And then try to process the order again.

Unfortunately, this didn’t help. 

Well, then I’d go with Acumatica support ASAP.