When the Fulfillment by Amazon (FBA, also known as Amazon Fulfilled Network) inventory gets stocked out, you may still want to keep selling your item by using the Merchant Fulfilled Network (MFN). To continue selling on MFN, you can follow either of the below approaches:
- Switch fulfillment network of the published product from FBA to MFN (OR)
- Publish an additional listing for MFN on Amazon. You can use the item alias feature to manage additional listings (one each for FBA and MFN) for a product in Amazon with a single NetSuite SKU.
Approach 1: Switch Amazon fulfillment type from FBA to MFN
Step1: Configure your NetSuite saved search
Before you add mappings and run the inventory or product flow from your Integration App, you need to add new columns in the inventory and item saved search in NetSuite. The formula for every parameter in your saved search may differ for every user based on the setup in NetSuite for identification of fulfillment type (MFN or FBA).
Inventory
- Login to your NetSuite account.
- In the global search box, enter “Celigo Amazon Inventory Export.”
- Select the appropriate search from the results and click on it.
- On the Celigo Amazon Inventory Export Search page, click Edit this Search.
- Click on the “Results” tab.
- Add the following rows:
Note: The below formulas are just for reference and will vary as per your custom labels and business needs.
Field Formula Custom Label Formula (Text) CASE WHEN {custitem_celigo_fba_fulfilled_by} = ‘AFN’ ELSE “MFN” END Switch Fulfillment To Formula (Text) CASE WHEN {custitem_celigo_fba_fulfilled_by} = ‘AFN’ THEN ‘AMAZON_NA’ ELSE ‘DEFAULT’ END Fulfillment Center ID Formula (Text) CASE WHEN {custitem_celigo_fba_fulfilled_by} = ‘AFN’ THEN ‘FulfillmentNetwork’ ELSE NULL END Lookup Amazon Days To Ship (Custom) Fulfillment Latency
Items
- Login to your NetSuite account
- In the global search box, enter “Celigo Amazon Item Export”
- Select the appropriate search from the results and click on it.
- On the Celigo Amazon Item Export Search page, click Edit this Search.
- Click on the “Results” tab.
- Add the following row:
Note: The below formulas are just for reference and will vary as per your custom labels and business needs.
Field Formula Custom Label Formula (Text) CASE WHEN {custitem_celigo_fba_fulfilled_by} = ‘AFN’ THEN ‘AMAZON_NA’ ELSE ‘DEFAULT’ END Fulfillment Center ID
Step 2: Configure your integration app flows
Order
Any order created on the MFN listing is synced using the “Amazon (MFN) Order to NetSuite Order Add” flow. To understand more about this flow, refer here.
Inventory
Note: The “Switch Fulfillment To”, “Lookup”, and “FulfillmentLatency” are custom fields created in NetSuite saved search for these mappings. You can provide the values as per your label names.
- Go to Amazon - NetSuite Integration App > Integration Flows > Inventory.
- Next to the “NetSuite Inventory to Amazon Inventory Add/Update” flow, click on the Field Mappings icon.
- On the Mappings window, add the following mappings:
- In the Import Field (HTTP) field, enter FulfillmentCenterID.
- Next to the field, click the gear icon.
- On the Settings window, for the “Field Mapping Type option”, select Hard-Coded.
- From the options, select Use Custom Value.
- In the text field, enter DEFAULT.
- For the FulfillmentCenterID mapping:
Note: The value entered must be in all capital letters.
Export Field (NetSuite) Import Field (HTTP) Switch Fulfillment To SwitchFulfillmentTo “DEFAULT” FulfillmentCenterID Lookup Lookup FulfillmentLatency FulfillmentLatency - Click Save.
- On the Mappings window, click Save & Close.
- In the Import Field (HTTP) field, enter FulfillmentCenterID.
Product
- Go to Amazon - NetSuite Integration App > Integration Flows > Product.
- Next to the “NetSuite Item to Amazon Product Add/Update” flow, click on the Field Mappings icon.
- On the Product Mappings window, go to the Fulfillment section, add the following mapping:
Amazon NetSuite Fulfillment Center ID “DEFAULT” - In the Amazon field, enter FulfillmentCenterID.
- Next to the field, on the right side, click the gear icon.
- On the Settings window, for the “Field Mapping Type option”, select Hard-Coded.
- From the options, select Use Custom Value.
- In the text field, enter DEFAULT.
Note: The value entered must be in all capital letters.
- Click Save.
- On the Product Mappings window, click Save & Close.
Approach 2: Create an additional product listing for MFN on Amazon
Using this approach you need not switch your fulfillment network of the existing listing from FBA to MFN. You can use the item alias feature to manage additional listings (one each for FBA and MFN) for a product in Amazon with a single NetSuite SKU.
Steps to create product listing and item aliases
- Log in to your Amazon account and create a new product listing for MFN with a different SKU. For more information, refer here.
- Log in to your NetSuite account and configure new SKU aliases for that particular FBA item in NetSuite. For more information, refer here.
- In your integration app, select the Item aliases are configured in NetSuite advanced setting box in the Order (MFN), Inventory, and Pricing section.
Switch from Amazon MFN to Amazon FBA
This is an additional section in this article that will help you understand how to switch from MFN to FBA. This approach is similar to Approach 1.
Step1: Configure your NetSuite saved search
Refer above on how to configure your NetSuite saved search.
Step 2: Configure your integration app flows
Inventory
- Go to Amazon - NetSuite Integration App > Integration Flows > Inventory.
- Next to the “NetSuite Inventory to Amazon Inventory Add/Update” flow, click on the Field Mappings icon.
- On the Mappings window, add the following mappings:
- For the FulfillmentCenterID mapping:
- In the Import Field (HTTP) field, enter FulfillmentCenterID.
- Next to the field, click gear icon.
- On the Settings window, for the “Field Mapping Type option”, select Hard-Coded.
- From the options, select Use Custom Value.
- In the text field, enter AMAZON_NA.
Important: Make changes for the Fulfillment Center ID value as follows based on the marketplace:
- AMAZON_NA is for the North America Marketplace
- AMAZON_EU is for Europe
- AMAZON_CN is for Canada
Export Field (NetSuite) Import Field (HTTP) Switch Fulfillment To SwitchFulfillmentTo “AMAZON_NA” FulfillmentCenterID Lookup Lookup FulfillmentLatency FulfillmentLatency
- For the FulfillmentCenterID mapping:
- Click Save.
- On the Mappings window, click Save & Close.
Product
- Go to Amazon - NetSuite Integration App > Integration Flows > Product.
- Next to the “NetSuite Item to Amazon Product Add/Update” flow, click on the Field Mappings icon.
- On the Product Mappings window, go to the Fulfillment section, add the following mapping:
Amazon NetSuite Fulfillment Center ID “AMAZON_NA” - In the Amazon field, enter FulfillmentCenterID.
- Next to the field, on the right side, click the gear icon.
- On the Settings window, for the “Field Mapping Type option”, select Hard-Coded.
- From the options, select Use Custom Value.
- In the text field, enter AMAZON_NA.
Important: Make changes for the Fulfillment Center ID value as follows based on the marketplace:
- AMAZON_NA is for the North America Marketplace
- AMAZON_EU is for Europe
- AMAZON_CN is for Canada
- Click Save.
- On the Product Mappings window, click Save & Close.
Please contact Celigo support to know more about customization needed in the Formula column within the saved search based on the setup and configuration of your NetSuite account.
Comments
Please sign in to leave a comment.