Sync item transparency code from NetSuite fulfillment record to Amazon

Contents

• Step 1: Configure a mapping in the Amazon order flow
• Step 2: Create a custom field in NetSuite at line-level
• Step 3: Configure the NetSuite saved search
• Step 4: Configure a mapping in the fulfillment flow

If you’ve subscribed to the transparency program in your Amazon account, it shares the “IsTransparency” value at the item level in a “true” or “false“ format on the orders. The “IsTransparency” value is synced from Amazon to NetSuite order using the Amazon MFN Order to NetSuite Order Add flow. The transparency code on the NetSuite fulfillment record is synced to the Amazon shipment using the NetSuite Fulfillment to Amazon Shipment Add flow.

Step 1: Configure a mapping in the Amazon order flow

Amazon shares the “IsTransparency” value at the item level in “true” or “false“ format.

1. Log in to your integrator.io account
2. Go to Flows > Order (MFN)
3. Next to the Amazon (MFN) Order to NetSuite Order Add flow, click Mappings.
4. On the Edit Mapping: Amazon (MFN) Order Import Adaptor page, configure the following mapping:
   

   Export field (Amazon Seller Central)	Import field (NetSuite)
   IsTransparency	<Map to the NetSuite custom field> Note: Map to a custom field that will show the status of transparency code such as “true” or “false.”

5. Click Save & close.
6. Run the Amazon (MFN) Order to NetSuite Order Add flow.
   When you run the Amazon (MFN) Order to NetSuite Order Add flow, the flow picks the value from the IsTransparency node in Amazon and syncs the value to NetSuite order.

Step 2: Create a custom field in NetSuite at line-level

Note: You can create multiple custom fields as per your business requirements.

1. Log in to your NetSuite account
2. From the top menu, go to Customization > Lists, Records & Fields > Transaction Line Fields > New.
3. On the Transaction Line Field page, in the Label field, enter an appropriate label.
4. In the Type drop-down menu, select Free-Form Text.
5. In the Applies To tab, check the Item Fulfillment box.
6. Click Save.
   
   

Step 3: Configure the NetSuite saved search

1. In NetSuite, in the search menu, enter Amazon Fulfillment Export
2. From the search results, select the appropriate option.
3. On the Celigo Amazon Fulfillment Export Search page, click Edit this Search. 
4. Go to Results > Columns.
5. Add a new row as follows:
   

   Field	Custom Label
   Select the custom field you created in Step 1 Example: transparency_code (Custom Column)	item_TransparencyCode
   Transparency_code_1 (Custom Column)	item_TransparencyCode
   Transparency_code_2 (Custom Column)	item_TransparencyCode

   Amazon limitation: You can define one to 10 transparency codes for an item as per Amazon.
6. Click Save.
   

Step 4: Configure a mapping in the fulfillment flow

1. Go to Flows > Fulfillment.
2. Next to the NetSuite Fulfillment to Amazon Shipment Add flow, click Mappings.
3. On the Edit Mapping: Amazon Fulfillment Import Adaptor page, configure the following mapping:
   

   Export field (NetSuite)	Import field (Amazon Seller Central)
   Items[*].item_TransparencyCode	Items[*].TransparencyCode

4. Click Save & close.
   When you run the NetSuite Fulfillment to Amazon Shipment Add flow, the manually provided transparency code on the NetSuite fulfillment record is synced to Amazon shipment.