Walmart Error: Failed to add Walmart Order# xxx. Failed to save record because This record already exists

Data flow: Walmart (WFS) order to NetSuite order (add)

Error code: dup_rcrd

Error message: Failed to add Walmart Order# xxx. Failed to save record because This record already exists.

Reason: This issue primarily occurs when two integration app tiles are set up to link distinct Walmart stores to a single NetSuite account because there are chances that Walmart can generate identical order IDs. By default, the integration app generates an external ID by concatenating the 'externalIdPrefix' and the 'purchaseOrderId', separated by a hyphen ('-'), directly within the backend. This automatic generation of external IDs happens irrespective of whether an external ID mapping configuration exists in the Post Walmart Fulfillment Services orders to NetSuite import process. To resolve or prevent this duplication error, it is recommended to implement custom external mapping for each integration app tile, as detailed below.

Resolution: 

The external ID serves as the unique identifier that the app utilizes to synchronize duplicate orders across different app tiles.

To resolve this error:

1. Go to integrator.io and navigate to the Walmart - NetSuite integration app tile.
2. Go to Flows > Order (WFS).
3. Next to the Walmart (WFS) order to NetSuite order (add) flow, click Mappings > Post Walmart Fulfillment Services orders to NetSuite import to edit the Field mappings.
4. In the Mappings section, perform the 'External ID' mapping as shown in the screenshot, Storename-{{purchaseOrderId}} :: External ID.

   Tip: To avoid confusion arising from managing stores across two or more tiles, prepending the store name as a prefix to the Walmart purchase order ID field is recommended as shown in the screenshot below.

5. Save your changes.
6. Now, you can go to the Integrator dashboard and view the Error dialog. 
7. Click Retry to re-run the order import flow successfully.