AMAZON FBA
About Amazon
Amazon.com, Inc., is an American multinational technology company based in Seattle, Washington. Amazon is the world's largest online marketplace, AI assistant provider, live-streaming platform and cloud computing platform as measured by revenue and market capitalization.
Amazon Marketplace allows sellers to resell used and new items for a percentage of the profits. Amazon is the largest Marketplace globally and operated in 5 continents i.e. Asia (India, Middle East Asia, Singapore, China, Japan), UK (France, Italy Spain), Russia, America (US, Canada, Mexico), Australia.
Models of Amazon Integrated with Vin e-Retail:
- Merchant Fulfilled Network or Amazon MFN or Fulfilled by Merchant (FBM)
- Amazon Easy Ship (Ship by Amazon Logistics)
- Amazon Self Ship (Ship by Seller Own Logistics)
- Amazon B2B (Customers having GSTIN)
2. Amazon AFN or Amazon fulfilled network:
- Amazon FBA or Fulfilled by Amazon
- Amazon Flex
In this document, we will discuss about Vin E-retail integration with Amazon FBA*
Amazon FBA
Amazon Says, “You sell it, we ship it”. Amazon has one of the most advanced fulfillment networks in the world. With Fulfilment by Amazon (FBA), Brand stores his products in Amazon's fulfillment centers, and Amazon pick, pack, ship, and provide customer service for these products. FBA can help the brand to scale your business and reach more customers. With FBA, Brand gets the PRIME tag on all his products and there are multiple benefits for both the customers and Brands If the Brand chooses the FBA program.
* Amazon MFN and Amazon Flex integrations are discussed in separate documents.
Amazon charges both storage and fulfillment fees and provides Amazon 24 x 7 customer service, the cost of shipping goods to customers, and access to one of the largest and most advanced fulfillment networks in the world.
In Amazon FBA Integration, we have:
- SKU Pull
- Order Pull and Create
- Inventory Pull (both single and multi-location)
- FBA Order Return Pull
- Order Invoice Pull
Prerequisites
Below mentioned are mandatory requirements for configuring Amazon FBA for Inventory Management, Order Fulfilment, and Return Management.
- Merchant ID
- Marketplace ID
- MWS Access Key or Secret Key OR MWS Auth Token
- Panel ID (User ID on seller central)
- Panel ID Password (Password on seller central)
- Developer ID (073980952359 for India)
- Developer Name (vinculum)
Process to Generate MWS Access Key:
2. Enter the Username and Password.
3. Approve Notification and enter OTP details.
4. Go to “Settings” and select “User Permissions” as mentioned in the screenshot below.
6. Click on the “Authorize new Developer” Button.
7. Enter the Developer name and Developer ID as per the information provided below:
- Developer Id is: 073980952359; Developer name: vinculum (For India, UK, MEA, Japan and other countries except US and Australia)
- Developer Id: 18802594138; Developer name: vinculum (US)
*Developer ID and Developer name should not be with any space and Developer name should be in small caps always.
* These IDs are confidential and hence cannot be shown in this document.
CHANNEL CONFIGURATION
Once all the above IDs are gathered, open your vin e-retail instance (ERP)
1. Go to Sales > Manage Channels.
2. Go to the top right-hand side of the window and click on “Add New.”
3. Select the “Amazon FBA” window from the list.
4. After selecting the correct Amazon Channel option, below “Channel Maintenance” window will appear.
5. Fill in all the details like Channel Name, order Source WH, Order Sync from date, Return Sync from Date, Inventory Sync Method, Enable Inventory Reconciliation, etc.
6. Click on “Configure Interface.”
7. There are 3 different Channel configuration windows as per the location (India, UAE and US & other countries)
Amazon UAE
Amazon US, Canada, France, Italy, Spain, UK, Australia, Mexico
Amazon India
8. Enter the details
- Seller ID = Merchant ID (Mandatory)
- Access Key= MWS Access Key (Confidential), If the client is registered on Vinculum’s Developer ID, then enter the default value as “_”
- Secret Key = MWS Secret Key (Confidential); If the client is registered on Vinculum’s Developer ID, then enter the default value as “_”
- Marketplace ID = MWS Marketplace Id for India i.e. A21TJRUUN4KGV
*For rest countries, look at the table at the end.
- MWS Token = MWS token is generated during Seller ID.
- Panel User Id (Mandatory): Login Username of Amazon Seller central.
- Panel Password (Mandatory): Panel password of Amazon Seller central.
- Enable FC wise Order Pull: On setting this as "NO," Orders of all Amazon FCs will be pulled and created under 1 channel code and warehouse. On Setting this Flag as "YES," we pull the FC-wise orders from Amazon. If there are 10 Amazon FCs to which the client ships the inventory. 10 channels with 10 FC Ids should be created in Vin-eRetail and all 10 Channels should be mapped to 10 Amazon Warehouses created in Vin-eRetails.
- Warehouse ID (Optional): If the client has enabled the FC wise order to pull then It is mandatory to Define the FC for which the order needs to be pulled in ERP.
For other countries, the Marketplace Id is mentioned below:
Table 1. North America region | |||
Country | Country Code | Amazon MWS Endpoint | Marketplace Id |
Brazil | BR | A2Q3Y263D00KWC | |
Canada | CA | A2EUQ1WTGCTBG2 | |
Mexico | MX | A1AM78C64UM0Y8 | |
US | US | ATVPDKIKX0DER |
Table 2. Europe region | ||||||
Country | Country Code | Amazon MWS Endpoint | Marketplace Id | |||
United Arab Emirates (U.A.E.) | AE | A2VIGQ35RCS4UG | ||||
Germany | DE | A1PA6795UKMFR9 | ||||
Egypt | EG | ARBP9OOSHTCHU | ||||
Spain | ES | A1RKKUPIHCS9HS | ||||
France | FR | A13V1IB3VIYZZH | ||||
UK | GB | A1F83G8C2ARO7P | ||||
India | IN | A21TJRUUN4KGV | ||||
Italy | IT | APJ6JRA9NG5V4 | ||||
Netherlands | NL | A1805IZSGTT6HS | ||||
Saudi Arabia | SA | A17E79C6D8DWNP | ||||
Sweden | SE | A2NODRKZP88ZB9 | ||||
Turkey | TR | A33AVAJ2PDY3EV | ||||
Table 3. Far East region | ||||||
Country | Country code | Amazon MWS Endpoint | Marketplace Id | |||
Singapore | SG | A19VAU5U5O7RUS | ||||
Australia | AU | A39IBJ37TRP1C6 | ||||
Japan | JP | A1VC38T7YXB528 |
Channel Maintenance Window
Channel Maintenance set up helps the seller to reduce manual intervention and avoid the multiple usages of marketplace seller portal. With the selection of below options at the Channel Maintenance window (Sales>Manage Channels>Add New>Select Amazon India) get the advantage of using multiple features of Vin E-retail:
S.No. | Features | Where to Click on Channel Maintenance | Dropbox/Checkbox | Details |
1. | Order Pull/ Order Pack/ Invoice/ Order Shipment/ Shipping label generation | Orders> Order Sync> Yes/No | Order Pull: User can choose to sync the order from the channel to e-Retail by managing this option. If this is disabled, the Order pull will not happen also the shipping label/Invoice and manifest will not get generated. | |
2. | Order Return | Orders> Return Order Sync | Users can click this option to sync Return Orders. Important Note: In Return Pull Services, the “Return” is always created in Confirmed status. Users needs to do an inbound from Return Inbound functionality available on Application. | |
3. | Prefetch Shipment Label | Orders> PrePack Enabled checkbox | PrePack Enabled: The user can enable prepack for the order from here.To avoid delay in Order processing and Shipment fulfilled with in a provided SLA, we have a feature to pull the shipment Label and Invoice at the same time of picklist generation instead of during Pack Call. To use this functionality, we just need to enable Prepack checkbox available under Channel Configuration set up screen and user need to click on Prefetch deliveries during pending picklist status available on Picklist enquiry screen. | |
4. | Ready to Ship Status at | Orders>Ready to ship at | Users can choose to mark the status of ready to ship at any of the two events: -at Manifest or -at Pack | |
5. | Use Market Place Shipping Label | Orders>Use Marketplace Shipping label checkbox | Users can check this option to notify the Shipping label by marketplace and then opt from the Shipment label drop box. | |
6. | Inventory update | Inventory>Inventory Sync | If selected "Yes" from the dropdown box, it automatically pulls and updates the inventory | |
7. | Inventory Reconciliation | Inventory>Enable Inventory Recon | By clicking Inventory Recon as “Yes,” it enables Vin E-retail to reconcile the inventory. (* It is only scheduled for once/day) |
Channel Mappings
The Merchant SKU code of Amazon should be mapped in ChannelSKUcode of Vin e-Retail and ASIN needs to be mapped in ChannelProductId. We also have the provision available for SKU Pull.
Invoice Pull & Return Pull Configuration
(Requires manual intervention from the backend, Inform Account Manager)
- To enable the invoice pull, the FetchInvSync in locationext should be set to 1.
- Entry in Global DB’s GtaskInfo table is made with the Taskname as InvoiceUpdate (take reference of other clients whose mapping already present).
- User must be whitelisted i.e. OTP login should be successfully done. (Make sure the user is not present as a blacklisted user in Admin console application).
- To enable the FBA returns, OrderPullScheduled=1 should be set in Locationext.
Common Issues in Amazon Integration
- Error: ‘Blank DTO list responded by integration.’ This occurred in the order list either because the orders are not present, or the credentials are not correct.
- Error: Invoice No. did not pull and stored in FBA Orders. This error comes If and only If the configs mentioned for the invoice pull are not correct or the user is blacklisted.