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:

  1. Merchant Fulfilled Network or Amazon MFN or Fulfilled by Merchant (FBM)
  1. Amazon Easy Ship (Ship by Amazon Logistics)
  2. Amazon Self Ship (Ship by Seller Own Logistics)
  3. Amazon B2B (Customers having GSTIN)

                                                       

2. Amazon AFN or Amazon fulfilled network:

  1. Amazon FBA or Fulfilled by Amazon
  2. 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:

  1. SKU Pull
  2. Order Pull and Create
  3. Inventory Pull (both single and multi-location)
  4. FBA Order Return Pull
  5. 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:

 

1. Login on https://sellercentral.amazon.in  or any other country domain link. (For Example for Amazon US it is https://sellercentral.amazon.com) 

Graphical user interface, application

Description automatically generated

2. Enter the Username and Password.

3. Approve Notification and enter OTP details.

Graphical user interface, text, application, email 
Description automatically generated


4. Go to “Settings” and select “User Permissions” as mentioned in the screenshot below.



  
5. Click on “Visit Manage your Apps” under the “Third-party Developer and Apps” section.
Graphical user interface, application 
Description automatically generated 

6. Click on the “Authorize new Developer” Button.

 


7. Enter the Developer name and Developer ID as per the information provided below:

  1. Developer Id is: 073980952359; Developer name:  vinculum (For India, UK, MEA, Japan and other countries except US and Australia)
  2. 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.

 

8. Once the Developer Name and Developer Id is entered, we will click on the “Next” Button, Merchant Id (Seller ID), MWS Token, and Marketplace Id will be generated.

* 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

https://mws.amazonservices.com

A2Q3Y263D00KWC

Canada

CA

https://mws.amazonservices.ca

A2EUQ1WTGCTBG2

Mexico

MX

https://mws.amazonservices.com.mx

A1AM78C64UM0Y8

US

US

   https://mws.amazonservices.com

ATVPDKIKX0DER

 

Table 2. Europe region

Country 

Country

Code

Amazon MWS Endpoint

Marketplace Id

United Arab Emirates (U.A.E.)

AE

https://mws.amazonservices.ae

A2VIGQ35RCS4UG

Germany

DE

https://mws-eu.amazonservices.com

A1PA6795UKMFR9

Egypt

EG

https://mws-eu.amazonservices.com

ARBP9OOSHTCHU

Spain

ES

https://mws-eu.amazonservices.com

A1RKKUPIHCS9HS

France

FR

https://mws-eu.amazonservices.com

A13V1IB3VIYZZH

UK

GB

https://mws-eu.amazonservices.com

A1F83G8C2ARO7P

India

IN

https://mws.amazonservices.in

A21TJRUUN4KGV

Italy

IT

https://mws-eu.amazonservices.com

APJ6JRA9NG5V4

Netherlands

NL

https://mws-eu.amazonservices.com

A1805IZSGTT6HS

Saudi Arabia

SA

https://mws-eu.amazonservices.com

A17E79C6D8DWNP

Sweden

SE

https://mws-eu.amazonservices.com

A2NODRKZP88ZB9

Turkey

TR

https://mws-eu.amazonservices.com

A33AVAJ2PDY3EV

Table 3. Far East region

Country

Country code

Amazon MWS Endpoint

Marketplace Id

Singapore

SG

https://mws-fe.amazonservices.com

A19VAU5U5O7RUS

Australia

AU

https://mws.amazonservices.com.au

A39IBJ37TRP1C6

Japan

JP

https://mws.amazonservices.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)

  1. To enable the invoice pull, the FetchInvSync in locationext should be set to 1.
  2. Entry in Global DB’s GtaskInfo table is made with the Taskname as InvoiceUpdate (take reference of other clients whose mapping already present).
  3. 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).
  4. To enable the FBA returns, OrderPullScheduled=1 should be set in Locationext.

 

Common Issues in Amazon Integration

  1. 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.
  2. 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.