Amazon Odoo Connector
Amazon Odoo Connector
Amazon Odoo Connector

Odoo Amazon FBA Integration

A. Introduction

What is Fulfillment by Amazon services ?

Fulfillment By Amazon services helps you to increase your online sales by giving you access to Amazon`s world-class fulfilment resources, fast delivery options for your products, and trusted & acclaimed customer service. In this service, you can simply send your products to an Amazon fulfilment center, and Amazon will store your inventory, pick, pack & ship your orders across your country and provides outstanding customer services.

In FBA services, Amazon stores your inventory and take care of shipping to your customers so it will be time saving process for you and you can focus on your business rather than warehouse and storage headaches.

With our FBA connector module, you can manage Amazon`s FBA services features in Odoo. Moreover this module can automate most of your FBA processes into Odoo without any kind of end user interaction and make you more productive.

B. Installation

After successfully downloading the Odoo Amazon FBA Integration App from Odoo store or Emipro shop, place it on the Odoo Add-ons path or at any other desired path. Now, restart the Odoo instance and navigate to Apps in the dashboard. Click on Update Apps List from the menu. Once it completes loading successfully, Odoo Amazon FBA Integration will be visible in Apps.

Click on the Install button. Success! Now, you are ready to use the Odoo Amazon FBA Integration in your Odoo.

1. Seller Configuration

Auto Import FBA Pending Order

This field is used to configure scheduled import of Amazon FBA (Fulfillment By Amazon) Pending Orders from Amazon.

You can create a Scheduler for this field that can automate this process.

Auto Check Canceled FBA Order in Amazon ?

System will create a scheduler to check the draft FBA orders (yet not shipped to customer) in Amazon and if it is canceled in Amazon then system will automatically cancel it in Odoo too.

Request FBA Shipment Report

This field is for automatic request of Shipment report in Amazon. You can create a Scheduler for this field that automates the request for Shipment Report.

Download Process FBA Shipment Report

System will automatically download Shipment report and process it in ERP. Also, you can create a Scheduler for this field.

For request and process report, the time difference you set must be five minutes.

Does another software create the FBA shipment reports ?

If you are using any third party tool then those tools also request report and for same time range if we request report two times then Amazon will cancel one request.

Due to that reason we are providing this configuration, rather then request for new report system will get reports which have requested by another software.

Request FBA Customer Return Report ?

You can Configure a Scheduler, that can Request for Customer Return Report automatically in Amazon FBA.

Download and Process FBA Customer Returns ?

This field will automatically process Customer Returns for those which are integrated in ERP. This field is also used for Creating a Scheduler.

For request and process, the report time difference must be five minutes.

Auto Import FBA Inbound Shipment Item Status ?

This scheduler is use to check status of inbound shipments and based on it, the Amazon status system will receive quantity in Amazon warehouse.

System will check status of all inbound shipment which are already shipped and not finally closed by Amazon. If shipment is closed by Amazon then based on check status days configuration, Odoo will check status in Amazon.

Request FBA Live Stock Report ?

You can create a scheduler for that will be automatically import Product Stock report from Amazon FBA.

Download Process FBA Live Stock Report ?

This field will automatically download Product Stock report and process it in Odoo while creating inventory adjustment in ERP.

Is default Odoo Sequence in Sales Orders (FBA) ?

If you tick this field, by default Odoo Sequence numbers will set in FBA Sales Orders.

Default Customer for FBA pending order

When you import Amazon FBA Pending Order, it will not give details about customer in pending orders. At that time this customer is set in quotation for FBA pending orders..

By default Connector will automatic create one customer for FBA pending orders.

Auto Create Outbound Order ?

This Connector is providing functionality to Create Outbound Order (deliver other channel Orders through Amazon).

You can configure a scheduler that can create automatic Outbound orders by setting desired timings. By clicking on this field, you must need to configure other related fields :

  • Fulfillment Action :
    There are two actions,
    Ship: The fulfillment order ships now.
    Hold: An order hold is put on the fulfillment order.
  • Shipment Category :
    Standard - Standard shipping method.
    Expedited - Expedited shipping method.
    Priority - Priority shipping method.

Note: Shipping method service level agreements vary by marketplace. See the Amazon Seller Central website in your marketplace for shipping method service level agreements and fulfillment fees.

Fulfillment Policy

There are 3 policies : FillOrKill, FillAll, FillAllAvailable

    FillOrKill :

If an item in a fulfillment order is determined to be unfulfillable before any shipment, order moves to the Pending status (the process of picking units from inventory has begun), then the entire order is considered as unfulfilled.

However, if an item in a fulfillment order is determined to be unfulfillable after a shipment, order moves to the Pending status and Amazon cancels as much of the fulfillment order as possible.

    FillAll :

All fulfillable items in the fulfillment order are shipped. The fulfillment order remains in a processing state until all items are either shipped by Amazon or cancelled by the seller.

    FillAllAvailable:

All fulfillable items in the fulfillment order will be shipped. All unfulfillable items in the order are cancelled by Amazon.

    Notify By Email :

If you tick this field, system will notify followers by Email

1.1 FBA Workflow

You can configure FBA workflow same as FBM workflow.

In this case system will auto conform and transfer delivery in shipment report process and create & validate invoice based on Workflow configuration.

Connector will create a default sales workflow for seller. For configuring workflow, go to menu Amazon / Configuration / Auto Sales Workflow and open that workflow.

There are many options that you can use when Orders are imported.

  • Create Invoice: Create Invoice in Draft State
  • Validate Invoice: Change State of Invoice (from ‘Draft → Open’)
  • Register Payment: Automatic Paid Invoice
  • Force Invoice Date: By default when you validate invoice, then its date will be current date and the invoice number will be generated based on invoice date. If you want to generate account entry based on order date then you can use this configuration. After that, invoice date becomes same as current date and journal entry date is now same as order date.

You must configure shipping policy under order configuration in auto sales workflow. This shipping policy is set in FBA orders. You must configure sales journal that is also set in FBA sale orders for invoice.

By default Invoice policy is based on product configuration and you can configure policy based on delivery order or sales order. If you configure then Odoo will not follow default policy for Amazon orders. It will follow policy based on auto workflow configuration.

2. Marketplace Configuration

Allow Process Unshipped Products in Inbound Shipment ?

If you tick this field, then the system will auto receive the product which is received by Amazon but it will not be added in Inbound Shipment.

Some time it may be possible that warehouse guys send wrong products and those products are not in plan or shipment. If you allow in configuration then system will receive products in FBA warehouse and negative stock create in transit location.

Check Status Days

Amazon can change quantity after close inbound shipment, due to that we need to still check the status of inbound shipment after it is closed.

The system will check status after closed status based on a number of days configuration. If you set 10 then the system will check 10 days after a close statement. By default, connector will set 30 days.

FBA Warehouse

Connector will create one Fulfillment Warehouse for FBA Orders. When FBA Sale Orders are created in ERP, at that time this Warehouse will be set and Goods are calculate from this warehouse. You can set different Warehouse for each Instance.

In Warehouse, the system will auto add list of fulfillment center. In future if any new fulfillment central is create by Amazon then user must add manually because Amazon is not providing any API to import it automatically.

Once the order gets imported, system will first search warehouse based on fulfillment center. If warehouse is found, then select that warehouse else system will select marketplace configured warehouse.

Above configuration is visible if FBA warehouse is set.

Unsellable Location
You can select instance wise Unsellable Location. Track Unsellable Products from customer return through this location.

3. Configure Automation Schedulers

For Creating a Scheduler, check the automation scheduler field and configure the below fields.

  • Interval Number
  • Interval Type: Minutes, Hours,
  • Days, Weeks or Months
  • Next Execution Time
  • User: By whom this Scheduler will run

List Of Schedulers Provide By Connector

  • Auto Import FBA Pending Order
  • Auto Check Canceled FBA Order in Amazon
  • Request FBA Shipment Report
  • Download Process FBA Shipment Report
  • Request FBA Customer Return Report
  • Download and Process FBA Customer Returns
  • Auto Import FBA Inbound Shipment Item Status
  • Auto Update Small Parcel Tracking
  • Auto Update LTL Tracking
  • Request FBA Live Stock Report
  • Download Process FBA Live Stock Report

4. Import Pending Orders

What is pending Orders?

Pending order means those orders which are placed by customer, payment verified by amazon but shipment is pending. In Pending order details, Amazon is not providing any details related to customer and product price. Amazon will just provide details of order reference, order date, product and quantity.

This feature is useful to those sellers who wants to reserve stock in quotation state and their purpose is for advance purchase reordering process.

Before importing orders you must verify below configurations.

Allow to Create New Product if not found in Odoo ?

When Orders are imported from Amazon and if they don’t find a Product in ERP, then it will automatically create a new Odoo Product and Amazon Product. It will also make mapping between Odoo Product and Amazon Product. Check this field for this operation.

System will set partner based on seller configuration and create order sequence based on seller configuration.

Pending order state must be in draft and order amount value should be 0. User must not edit or modify order manually.

User can process Pending Order using two methods.

    1. Operations

Go to Amazon ⇐> Odoo / Operations / Import Operations (FBA) and select marketplaces and click on import pending orders.

    2. Scheduler

You can configure a scheduler under Amazon / Configuration / Amazon Settings and select Amazon Seller. Configure Auto Import FBA Pending Order.

Cancel FBA Pending Order in amazon

In case of Amazon Pending orders, it can be possible that order can be canceled by Amazon or customer.

In connector there is one feature available, it is check pending order status. If it is cancelled by Amazon then system will cancel order in Odoo too. If user have manually confirmed orders then system will not cancel order in Odoo.

User can process Cancel Order using two methods.

    1. Operations

Go to Amazon ⇐> Odoo / Operations / Import Operations (FBA), select marketplaces and click on check cancelled order in Amazon.

    2. Scheduler

You can configure a scheduler under Amazon / Configuration / Amazon Settings and select Amazon Seller. Configure ‘Check Canceled Order in Amazon’.

5. Process Shipment Reports

Amazon Shipment Report provides comprehensive details of Orders which are Shipped by Amazon (FBA → Fulfillment By Amazon) including price, quantity, tracking numbers and shipping info. You can download Shipment Report from Amazon either automatically or manually for specific date periods, process it and changes the states of your FBA Orders and update tracking information in Orders respectively.

You can see Amazon FBA Sale orders at Amazon / Sales / Sales Orders (FBA).

While processing orders, first system will check if pending order is available. Then it will update pending order and if pending order is not available then system will create new orders.

Before Process Shipment Report, you must take care of some configurations.

    1. In orders, system will apply tax based on your product and fiscal position configuration.
    2. If product not found in Odoo and you have configured auto create true, then system will create new product automatically and create orders.
    3. Before process orders check configuration of prefix and default sequence of Odoo in Amazon / Seller / Settings.

5.1 Behaviour of shipment report

In process of Amazon orders, system will not create any duplicate orders.

If Amazon delivers the order partially like if in one order have two products and one product delivers by today and another product by tomorrow then system will create same order in two different reports and create order like amazon-order-ref /1, amazon-order-ref/2, amazon-order-ref/3.

In shipment report we are getting marketplace and fulfillment center. Based on marketplace and seller, system will search marketplace in Odoo order and system will search warehouse based on fulfillment center code. If it is found then select warehouse or select fba warehouse based on marketplace configuration.

In Connector we are providing functionality to configure fiscal position based on fulfillment warehouse country. Go to Accounting / Configuration / Fiscal position and configure fiscal position and set Origin country.

When order is imported, system will match warehouse country and fiscal position origin country and apply fiscal position. If it is not found then it will follow default rule of Odoo.

User can process Shipment report using three methods.

1. Request report & Download report

Go to FBA / Order & Returns / FBA Shipments and select seller.

System will select start date and end date. End date is current date and start date is the difference between Current Date & Default Shipment Request Report Days. By default user can configure Shipment Request Report days in Amazon Seller.

Amazon recommends to request report for last three days. It is by default 3 days set by connector though, user can change manually. It can also change date manually as well and request report.

After request report button, check status button will visible, you need to wait for 10 or 20 seconds and click on check status. If still report is not done from Amazon side then report status will be in PROGRESS and once the report is available then system will set state DONE and get report button visible.

Click on Get Report to import Report in Odoo. After clicking on Get Report, two buttons will be visible. Download Report & Process File. You can download that report by clicking on Download Report. Just click on Process report to process file.

After Process report system will create order, process delivery orders and create, validate invoice based on auto workflow configuration. Now, system will show two buttons Reprocess file and Mismatch details.

Reprocess File:

User can reprocess file if products are missing and after create products just reprocess file.

Mismatch details:

User can see mismatch details and correct it , like product not found in ERP.

1. Scheduler

You can configure a scheduler under at menu ‘Amazon / Configuration / Amazon Settings’ and select Amazon Seller. Configure ‘Request FBA shipment report’ and ‘Download Process FBA Shipment report’.

User must set time difference of 5 or 10 minutes before sending request. If user have configure Does another software create the FBA shipment reports? then system will not request report and just get report.

End date is current date and start date is the difference between Current Date & Default Shipment Request Report Days. System will automatically get or request reports and process it. You must configure both scheduler to get and process reports.

2. List Shipment reports

If you have configure Does another software create the FBA shipment reports? then system will allow to get reports and user must select seller and system will auto select end date is current date and start date is the difference between Current Date & Default Shipment Request Report Days.

After that user can process reports manually or system will process via schedulers.

6. Process Customer Returns

There is one feature to Import FBA Customer Returns and process those Return Reports in Odoo. In the report you can get the return reason for why a product is returned if return reason is provided by customer. Also, you can identify that product in report is Sellable or Unsellable. Amazon Manage Unsellable Inventory for Unsellable Products.

This Connector also manage Unsellable Location in Odoo. To configure Unsellable Location, go to menu Amazon / Configuration / Amazon Settings and go to Amazon Marketplace configuration page.

At the end of the page you can see Unsellable Location. Connector will default create one Unsellable Location. You can set different Unsellable Location to each Marketplace.

When user will process return report then system will search that sales orders and if it is not found then system will not create return transfer. If order is available then system will create return transfer and source location is customer and destination location which is set based on product type.

If product is unsellable then go to unsellable location and if product is saleable then it will be returned back to Amazon warehouse. System will not create any credit note in return process.

There are two ways to Process Customer Return Report :

1. Request report and Process FBA Customer Returns

You can import this report from the menu Amazon / FBA / Customer Returns. Create a new record by given date range and select Amazon Seller.

By default start date is last process date and end date is current date.

After clicking on Request Report, Shipment state will be Submitted and Check Status button will be visible. You must wait for 10 or 20 seconds and click on Check Status. If report is still in process at Amazon then report state will change from Submitted → In_Progress.

If it is complete at Amazon side then report state will change from Submitted → Done.

Click on Get Report to import Report in Odoo. After clicking on Get Report, two buttons will be visible. Download Report & Process File. You can download that report by clicking on Download Report. Click on Process File to process Return Report file and Create FBA Customer Return Orders in Odoo.

After Successfully processed Return report, you can see Return Orders.Now, system will visible two buttons Reprocess file and Mismatch details.

Reprocess File :

User can reprocess file if products are missing and after create products just reprocess file.

Mismatch details :

User can see mismatch details and correct it, like Order not available in ERP.

7. Configuration of Settlement Reports (For Reimbursement Report)

Amazon provides Settlement / Payment Reports to view information about your payments related to Sales and Operational activity for your Amazon account. There are millions of products in Amazon with everyday deal. You can get reimburse for your products from Amazon by getting Settlement Report.

Settlement report contains different types of details: Orders, Refunds, Reimbursement, Amazon Fees. Before process Amazon Settlement / Payment Reports for reimbursement, you need to set some configurations under menu Amazon / Configuration / Sellers. At Seller page, go to Settlement Report Settings tab and see at below Reimbursement Details.

In Settlement report processing system will create reimbursement of customer invoice for all reimbursement transactions. For that you must configure or verify configurations.

    Reimbursement Customer: To get your reimburse / claim from Amazon, you will require a Reimbursement customer. In our case Amazon is our customer. You can see at Amazon Seller page under at ‘Reimbursement Details’.
    By default, Connector will automatically create a reimbursement customer and set in this field. you can change as per your requirement.

    Reimbursement Product : System will consider reimburse / claim in product way. Connector will automatically create one reimbursement product to process reimbursement lines in settlement report. You can see at Amazon seller page under at ‘Reimbursement Details’.

    Sales Journal: System will set default sales journal and user can change journal manually for reimbursement invoice.

8. Prepare Product For Export

Prepare product for export feature is available in Amazon-Odoo connector, in FBA connector user can do same operation but additionally user can select fulfillment by.

9. Multi Channel Outbound Orders

Outbound orders management in Odoo gives you the scale of Amazon's world-class fulfillment network while lowering costs and freeing time and resources to focus on growing your business. For your outbound orders, you can manage following process in Odoo.

From Amazon-FBA connector we can create Outbound Orders using three methods.

    1) Select draft orders from other sales channels --> Prepare Outbound Orders --> Create/Update/Cancel Fulfilment.

In Sales quotation user must select FBA warehouse from Amazon which will deliver products to customer.

In the wizard user must select marketplace and based on that system will show list of orders. Make sure system will not consider any confirm orders.

  • Fulfillment Action :
    There are two actions:
    Ship :The fulfillment order ships now.
    Hold : An order hold is put on the fulfillment order.
  • Shipment Category :
    Standard - Standard shipping method.
    Expedited - Expedited shipping method.
    Priority - Priority shipping method.

Note: Shipping method service level agreements vary by marketplace. See the Amazon Seller Central website in your marketplace for shipping method service level agreements and fulfillment fees.

    Fulfillment Policy
    There are 3 policies : FillOrKill, FillAll, FillAllAvailable

    FillOrKill :
    If an item in a fulfillment order is determined as unfulfillable before any shipment in the order, it moves to the Pending status (the process of picking units from inventory has begun), and the entire order is considered as unfulfilled.
    However, if an item in a fulfillment order is determined to be an unfulfillable after a shipment in the order, it moves to the Pending status and Amazon cancels as much of the fulfillment order as possible.

    FillAll:
    All fulfillable items in the fulfillment order are shipped. The fulfillment order remains in a processing state until all items are either shipped by Amazon or cancelled by the seller.

    FillAllAvailable:
    All fulfillable items in the fulfillment order are shipped. All unfulfillable items in the order are cancelled by Amazon.

    Notify By Email :

    If you tick this field, System will notify the followers by Email.

    Displayable Date Required ?
    If this field is true then system will ask to select order date.

    Displayable Order Date
    Amazon will print date in order package.

User can select marketplace, order and select required fields and click on create or cancel button. After that system will just prepare order and user can create, update or cancel fulfillment order. If order is already shipped and user will try to cancel order then Amazon will give an error.

Those orders must not confirmed by user manually, system will automatic process all outbound orders by Amazon shipment reports.

2. Scheduler

User can configure scheduler at Amazon / Config / Seller and configure

Auto Create Outbound Order ?

User just need to set FBA warehouse in sales quotations and system will auto detect and create outbound order in Amazon.

3. Manually directly in sales quotation.

In sales Quotation if user selects any FBA warehouse then system will show button create outbound shipments.

System will open popup and user can prepare outbound orders. After prepare orders user can create,update and cancel outbound order from FBA / Outbound Orders.

10. Create Inbound Shipment Plan

Send your goods from Odoo to Amazon with Inbound Shipment Plan. An Inbound shipment plan is a virtual collection of products that you want to send to Amazon fulfillment centers. To create/view shipment plan, you can use the menu Amazon / FBA / Inbound / Inbound Shipment Plan.

The first step in creating a shipping plan is to choose the products in your inventory that you want to ship to Amazon. So in Shipment plan, you can select the products you want to send to Amazon, including the quantity of each product.

Once you list all the product and click on Create Shipment Plan button, Odoo will automatically submit products to Amazon and get response from Amazon with different Fulfillment centers to where you need to deliver your goods. Upon proper response from Amazon, status of your Shipment plan in Odoo will be changed to Shipment Plan Approved.

Here it is important for you to remember that a single shipping plan may be broken into in multiple shipments based on fulfillment centers. You can manage partnered and non-partnered carrier options for FBA in Odoo.

    Marketplace : User must select marketplace from where he/she want to send stock to Amazon.
    Warehouse : By default system will select marketplace merchant warehouse and user can change merchant warehouse manually. Goods will deliver from merchant warehouse to Amazon Warehouse.

Label Prep Preference:

    SELLER_LABEL : Seller affix the labels on items in the inbound shipment when labels are required.

    AMAZON_LABEL_ONLY:Amazon attempts to label the items in the inbound shipment when labels are required. If Amazon determines that it does not have the information required to successfully label an item, that item is not included in the inbound shipment plan.

    AMAZON_LABEL_PREFERRED: Amazon attempts to label the items in the inbound shipment when labels are required. If Amazon determines that it does not have the information required to successfully label an item, that item is included in the inbound shipment plan and the seller must label it.

Note: Unless you are enrolled in the FBA Label Service, SELLER_LABEL is the only valid Label Prep Preference value. The FBA Label Service is not available in China (CN) or India (IN) and is currently in beta development in Japan (JP). For more information about the FBA Label Service, see the Seller Central Help for your marketplace.

    Ship From Address:
    The address from which you will send your inbound shipment. Required fields are Name, AddressLine1, City and Country Code.

    Ship To Country Code:
    The two-character country code for the country where you want your inbound shipment to be sent.

    Are Cases Required ?
    Indicates whether or not an inbound shipment contents case-packed boxes. A shipment must either content all case-packed boxes or all individually packed-boxes.
  • true – All boxes in the shipment must be case packed.
  • false – All boxes in the shipment must be individually packed.

Note: If AreCases Required = true for an inbound shipment, then the value of Quantity Case must be greater than zero for every item in the shipment. Otherwise the service returns an error.

Intended Box Contents Source

How the seller intends to provide Carton Contents Info for this shipment.

This parameter is valid only in the US, Spain, UK, France, Germany, and Italy marketplaces. Specifying Intended Box Contents Source in other marketplaces results in an error. Intended Box Contents Source values: NONE, FEED, and 2D_BARCODE

Default: NONE

Is Partnered ?

Use to identify your carrier is partner carrier or not.

If Amazon carrier will pick-up cartons from merchant warehouse it means partner carrier. If Merchant carrier will send cartons to Amazon, it means non-partner carrier.

Shipping Type
  • SP – Small Parcel
  • LTL – Less Than Truckload/Full Truckload (LTL/FTL)
  • You can import inbound shipment plan from csv file. Click on Import Products(csv) and system will open wizard. In the file you need to specify product internal reference, quantity and quantity in case.

    After create plan manually or import file, you just need to click on Create inbound shipment plan and Amazon will return ship to address and shipment ids, based on that Odoo will create inbound shipment. One Amazon Inbound shipment plan can have multiple inbound shipments.

    If Amazon will give any error then system will set state in Error and user can see error log too. After correct inbound shipment plan user can click on reset to draft and create shipment plan again.

11. Warehouse configuration

In inbound shipments, system will always create pickings in two steps. From Merchant warehouse to transit and transit to Amazon warehouse.

However, in your case, you must configure route and if not configured then system will not create inbound shipment pickings automatically.

User must configure resupply warehouse from where the stock will transfer.

12. Manage Inbound shipments

After create inbound shipments, the first step is to verify routes have configured or not and if not configured then user can see error message in error log and Create Shipment Picking button will be shown.

User can configure route and click on create shipment picking button. Next step is to select Shipping Type and Transport Type. There are two types of Shipping Type (Partner / Non-partnered)

There are two types of Transport Type ( Small/LTL)

Case :1 Non-Amazon-partnered carrier shipments

If carrier is non-Amazon partner it means merchant will select carrier and delivery products to Amazon.

Small Parcel

If Carrier is non-partner and transport type is small then Amazon will require the Carrier Name and list of tracking number.

LTL Parcel

If carrier is non-partner and transport type is LTL then Amazon will require carrier name and Pro-number.

12.1 Import Inbound Shipment from Amazon to Odoo (optional)

In certain cases, when the inbound shipment from Amazon is created in Seller Portal, we can integrate it with Odoo by importing the inbound shipment details from Amazon to Odoo directly.

Navigate to Amazon / FBA / Import Shipment and you will see the wizard to setup the inbound shipment from Amazon.

In this wizard, you will the fields for importing the inbound shipment.

Warehouse: Select the warehouse from which you will deliver the required products to Amazon Fulfilment Center.

Shipment ID: Enter the Shipment ID from the seller portal for this inbound shipment.

Instance: Select the instance for which Amazon inbound shipment will be carried out.

After entering all the required details, click on the button Import Shipment.

Once, the details are successfully fetched from your Amazon Seller Account, you will be able to see all the required information for the products you are sending to Amazon Fulfilment Center.

Here, for each inbound shipment, there will be two pickings. One from your own warehouse to transit (Delivery Order) & second from transit to Amazon (Receipt). You can check both of the below screenshots for better understanding.

So, this is also one of the ways to manage and process inbound shipments for Amazon in case if it is not directly integrated/configured with Odoo.

13. Get/Print Package/Pallet labels for Inbound Shipment

If you are not using Unique labels concept then user can print package/pallet labels and it is required when we send packages/pallet to Amazon. For each Inbound Shipment you can print Package as well as Pallet labels from Odoo as per your type. If your Shipment is type of Small Parcel then you just need to get the package label. In case of Full truckload kind of Shipments, you need pallet label too.

When your Inbound Shipment is in Working state, you will able to see the button Get Package Label in any Inbound Shipment. Clicking on that button, Pop up will open in which user can submit Package types and the Number of Boxes they want from Amazon to provide labels. Clicking on Print Box Labels button will straight away request Amazon and get your package labels in PDF format. That file will be added as an attachment inside respective Inbound Shipment.

You can download those labels and stick them with your Shipment packages. To be able to send our Goods to Amazon FBA fulfillment center, it is essential to stick the labels with your packages and pallets.

Case :2 Amazon-partnered carrier shipments

If carrier is Amazon partner it means merchant can select Amazon carrier and delivery products to Amazon via Amazon carrier. All packages will be picked-up By Amazon carrier.

    Small Parcel: Following are the parameter for small parcel.
    CarrierName: Indicates the Amazon-partnered carrier that you want to use for your inbound shipment and it is not required.
    PackageList: A list of packages, including the dimensions and weight of each package. Dimensions and weight which is already configured in carton content information. It is required by Amazon.

LTL/FTL Info

If carton weight is more than 20 kg then Amazon prefer to user LTL Transport type.

Following are then fields of LTL/FTL info.

    Contact : Contact information for the person in your organization who is responsible for the shipment. Used by the carrier if they have questions about the shipment.
    BoxCount: The number of boxes in the shipment. System will auto calculate from carton content information.
    Seller Freight Class: For information about determining the freight class, contact your carrier. If you do not provide the freight class, Amazon will estimate the freight class based on the contents of the shipment.
    Freight Ready Date: The date that the shipment will be ready to be picked up by the carrier.
    TotalWeight: It will auto calculate based on carton content information.

13.1 Pallet List:

Dimension & Weight:

Dimensions and weight which is already configured in carton content information. It is required by Amazon. Length and width must be 40 inches by 48 inches. Height must be less than or equal to 60 inches.

IsStacked:

Indicates whether pallets will be stacked when carrier arrives for pick-up.

SellerDeclaredValue:

Your declaration of the total value of the inventory in the shipment. User can calculate value manually or also calculate value automatically based on inventory quant cost.

13.2 Update Carton Content information & Get Carton Content Result

If you are using Amazon Partner carrier then Amazon recommended unique product labels and for that user must import following details. If inbound shipment have 3 box then user must create 3 box info in Inbound shipment with all product details.

In box info user must specify both dimension,weight, product and quantity. Also, each box id is number and user can start with 1,2..N. After input carton details user must submit to Amazon and wait for 120 seconds and one button will show-up is called Get Carton Content Result.

On click on this button system will check if any error in Amazon then system will set state to working and Update carton content button will visible. User can see error log In error log tab and correct it after that again update carton content information to Amazon.

Same cycle will execute if we will not submit correct carton details to Amazon. User can import Carton content using CSV file as well.

13.3 Update Transport Information

After successfully update carton details to Amazon next step is to Update Transport details to Amazon.

13.4 Estimate Fee Request

The Estimate Transport Request operation initiates the process of estimating the shipping cost for an inbound shipment by an Amazon-partnered carrier.

This operation is available in all marketplaces except Brazil and China. Amazon will return Transport status.

    WORKING - You have successfully called the Update Transport Information operation for this shipment but have not yet called the Estimate Transport Request operation.
    ERROR_ON_ESTIMATING - There was a problem with your call to the Estimate Transport Request operation and an error was returned.
    ESTIMATING - You have successfully called the Estimate Transport Request operation for this shipment and the carrier is in the process of estimating the shipment cost.
    ESTIMATED – The carrier has completed the process of estimating the shipment cost. Your transportation request is ready to be confirmed by you.
    ERROR_ON_CONFIRMING - There was a problem with your call to the Confirm Transport Request operation and an error was returned.
    CONFIRMING - You have successfully called the Confirm Transport Request operation but the confirmation process is not yet complete.
    CONFIRMED - Your transportation request has been confirmed. Important: For a Small Parcel shipment, you can void your transportation request up to 24 hours after you confirm it. For a Less Than Truckload/Full Truckload (LTL/FTL) shipment, you can void your transportation request up to one hour after you confirm it. After the grace period has expired your account will be charged for the shipping cost.
    VOIDING - You have successfully called the Void Transport Request operation for a confirmed carrier shipment but the voiding process is not yet complete.
    VOIDED -Your confirmed carrier shipment has been voided. Your account will not be charged for the shipping cost.
    ERROR_IN_VOIDING -There was a problem with your call to the Void Transport Request operation and an error was returned.

13.5 Get Transport Content

The Get Transport Content operation returns current transportation information about an inbound shipment. This includes the current workflow status for shipments by Amazon-partnered carriers and the current workflow status for individual Small Parcel Delivery packages as they are processed by the Amazon fulfillment center. This also includes the Partnered Estimate response element, which indicates the estimated shipping cost for an inbound shipment by an Amazon-partnered carrier.

Note that Partnered Estimate will not be returned unless the TransportStatus value of the inbound shipment is ESTIMATED, CONFIRMING, or CONFIRMED. Amazon will return estimate amount of inbound shipment shipping charge and system will store in Inbound shipment.

14. Confirm Transport Request

The Confirm Transport Request operation confirms that you accept the Amazon-partnered shipping estimate, agree to allow Amazon to charge your account for the shipping cost, and request that the Amazon-partnered carrier ship your inbound shipment.

Important: After confirming the transportation request, if you decide that you do not want the Amazon-partnered carrier to ship your inbound shipment, you can Void Transport Request operation to cancel the transportation request.

Note that for a Small Parcel shipment, you have 24 hours after confirming a transportation request to void the transportation request.

For a Less Than Truckload/Full Truckload (LTL/FTL) shipment, you have one hour after confirming a transportation request to void it. After the grace period has expired your account will be charged for the shipping cost.

14.1 Void Transport Request

The Void Transport Request operation voids a previously-confirmed request to ship your inbound shipment using an Amazon-partnered carrier.

Important: The Void Deadline date is 24 hours after you confirm a Small Parcel shipment transportation request or one hour after you confirm a Less Than Truckload/Full Truckload (LTL/FTL) shipment transportation request. After the void deadline passes, your account will be charged for the shipping cost.

14.2 GetUniquePackageLabels

Returns unique package labels for faster and more accurate shipment processing at the Amazon fulfillment center. Based on your box content info Amazon will provide Unique labels to Seller.

Use this operation to get unique shipping labels for the packages in all types of inbound shipments: Small Parcel, Less Than Truckload/Full Truckload (LTL/FTL), Amazon-partnered, or non-Amazon-partnered shipments. For Amazon-partnered, Small Parcel shipments, this operation returns carrier labels in addition to shipping labels.

15. Update Inbound Shipments

The UpdateInboundShipment operation can add, update, and remove items from an existing inbound shipment. If you include the Inbound Shipment Items request parameter, the behavior is as follows:

Including an item that doesn't exist in the inbound shipment, as identified by the Seller SKU, adds the new item to the inbound shipment.

Including an item that already exists in the shipment, as identified by the Seller SKU, replaces the existing item. Note that if the new item that replaces the old item has Quantity Shipped set to zero, this indicates that the item is removed from the inbound shipment.

16. Cancel Inbound Shipments

If inbound shipment is not shipped then user can cancel inbound shipment from Odoo to Amazon and inbound shipment state will be canceled in Odoo. After cancel inbound shipment user can not edit or reopen again.

17. Check Status

When product will transfer from Merchant warehouse to transit then user must transfer first picking. Merchant warehouse to transit location. After that user can check status in Amazon. On click of this button, system will check status in Amazon and transfer stock from Transit to FBA location.

In some case, Amazon will take long time to close shipment and if amazon processes it partially then system will also process picking partially.

Some time if may be possible that warehouse send extra products and Amazon will receive extra products. In this case, system will receive those products based on seller configuration and stock will negative in transit location. If you have configured transit location as internal type or if transit location type is transit then system will not create negative stock in transit location

Using two methods user can check status.

1. Manually In Inbound shipment

User can just click on Manually button inbound shipment and system will receive quantity in inbound shipment as per Amazon inbound shipment status.

Also, user can see Amazon response in FBA transfer messaging log.

2. Scheduler

User can configure scheduler Amazon / Config / Seller. Auto check status. If true then system will execute scheduler and check for all inbound shipment which are not closed and also for those shipment which are not finally closed by Amazon.

18. Amazon Stock Adjustment in Odoo

In many cases, your stock in Amazon Fulfilment Center faces some problems and cannot be used further until it is restored back. For this, Amazon prepares reports on FBA inventory adjustments and update the latest usable stock in it. So, based on this, you can carry out stock movement according to this in your Odoo.

Now here, following are the group of reasons of FBA inventory adjustment given by Amazon itself:

  • Misplaced and Found inventory: Inventory is misplaced or found in amazon fulfillment center.
  • Damage inventory: Inventory is found as damage and can be further transfer to unsellable location.
  • Unrecoverable inventory: Inventory is damaged/lost. In this case the seller can claim for reimbursement.
  • Inbound shipment received adjustments: In inbound shipment receiving process, if there is any issue like miscount or product scan occurs.
  • Software corrections: Software correction of inventory tracking discrepancies in Amazon.
  • Transferring ownership: In the case, where Amazon has reimbursed for the products which were lost. Now, if it is found later on, then Amazon will change ownership for that product in holding account.
  • Catalog management: The two products with separate identifier are found as same in our catalog with Amazon, they will delete one of them and move inventory in another product.

Above all groups amazon is managing using different codes as shown in below screenshots.

18.1 Configure Amazon Stock Adjustment in Odoo

To let Amazon carry out FBA inventory adjustment hassle-free, we need to configure the stock adjustment in Odoo.

Navigate to Amazon / Amazon Sellers / (Company Name) and go to the tab Stock Adjustment. Here, you can see many parameters as follows:

Group: Select any one group of reason for which the stock adjustment will take place in Amazon FBA Inventory. Refer above section for more details on reason.

Location: Select the location of your warehouse you configured in Odoo in which you want to record this type of transactions.

Is Send Email? : System will send email to configured users for any transactions take place for Stock Adjustment in Amazon FBA Inventory. You can select the Email Template here for this type of transactions.

Picking Type: Select the picking type for the location you selected for Stock Adjustment in your Odoo.

Once the Stock Adjustment Configuration is done, we will fetch the stock adjustment report from Amazon. Navigate to Amazon / Stock Adjustment / Stock Adjustment Report and you will find all the reports fetched over here.

Now, we need to process the fetched reports from Amazon. Click on any of the listed reports. You will see the button to process the Inventory Adjustments as shown below. You can also see the real-time status of adjustment in Amazon FBA Inventory.

Note: The outstanding amounts from/to Amazon for stock adjustments in FBA Inventory will be mentioned in the settlement report provided by the Amazon at certain time interval.

19. Amazon Removal Order

There can be a scenario, when some of your stock becomes unsellable due to unavoidable circumstances in which it cannot be restored back to original state. In this case, either you need to remove that stock from Amazon FBA warehouse or dispose it.

Now, to integrate this process and track the stock status from Amazon FBA warehouse in your Odoo, navigate to Amazon / Configuration and you will find the parameters like Unsellable Location, Removal Orders section, etc. as shown in below screenshot.

Here,

Unsellable Location: Set one Unsellable location in Amazon FBA Warehouse here. All the products which cannot be sold further, will be moved to this location.

Removal Configuration: Check the box Allow Create Removal Order in FBA to create product removal order on Amazon FBA Warehouse from Odoo.

Also, set the Removal Warehouse in your Odoo where all the records of unsellable stock will be maintained. This warehouse is in your Odoo itself.

There are two types of removal orders:

    Return:

In removal order process, user can create removal order to bring back product from Amazon warehouse to Merchant warehouse.

User can return two types of products: Unsellable and Sellable.

If product is unsellable, then the system will transfer from Amazon unsellable location to Merchant warehouse scrap location.

If product is sellable, then the system will transfer from Amazon stock location to Merchant warehouse stock location.

System will select Merchant warehouse based on configuration.

    Disposal:

In this case, Amazon will dispose products and in ERP system, it will create internal transfer from Amazon sellable/unsellable location to Inventory Loss.

If Product is sellable, then the system will transfer from Amazon stock location to Inventory Loss.

If product is unsellable, then the system will transfer from Amazon unsellable location to Inventory Loss.

19.1 Create Removal Order from Odoo

User can create removal order from Odoo to Amazon or in amazon user can set-up automatic removals.

To create removal order user need to enter following details.

Instance: Marketplace for which you would like to create removal.

Removal Disposition: Return / Dispose.

Destination Warehouse: By default system will select Removal Warehouse based on instance configuration.

Shipping Address: If removal disposition is return, then shipping address is required. User can create removal order manually or import using csv file.

When the removal order is created by the user, the system will automatically create removal order on Amazon and change the state to removal plan approved.

Navigate to Amazon / FBA / Removal Orders and you will be able to process removal orders in Amazon.

When the Removal Order in Draft Stage, Amazon will decide to process it further. After that, you can see the status of all products covered in Removal Order by clicking on button generated at top right as shown below.

Here the status will change to Removal Plan Approved if your Removal Order is processed successfully by Amazon.

Process Removal Order Report

In this, the system will process removal order report. There are three states of Removal process i.e. Completed, Pending and Cancelled.

Now, if status is Cancelled, then the system will cancel all those related moves of products from Amazon FBA warehouse to your warehouse.

If status is Completed, then the system will transfer picking in Odoo otherwise system will just skip the lines.

In the report, if we are getting removal order reference which are not existing in ERP but auto created by Amazon, then the system will also create removal order and process it further just as you processed earlier orders which were created manually.

20. Live Stock Report

Amazon-FBA connector is providing feature to get live stock and upgrade sellable/non-sellable inventory in ERP. System will create & validate inventory adjustment based on this report.

User can do it this process using two methods.

1. Manually

Go to Amazon / FBA / FBA Live Inventory. User can select seller and request for report. Same as shipment and customer return report user can request report and wait for 10 or 20 seconds to click on check status button. Some time if report is not ready then status shown is In Progress and when the report is ready then status shown is Done. If status is DONE then user can click on Get report and process report. Here, system will create two different inventory for sellable and unsellable product stock.

If product not found then system will skip products and create mismatch log for that.

2. Scheduler

User can configure scheduler to request live inventory and process inventory from Amazon / Config / Seller. For both scheduler, user must set time difference 5 to 10 minutes.

21. FBA Navigation Dashboard

All in one screen for easy navigation to any data regarding your FBA operations.

Our Amazing navigation dashboard is an overview of all of FBA operations at a glance. From the dashboard itself, you will be able to easily execute any operation for FBA or navigate to any useful data directly. By clicking on main menu 'Amazon', you will able to see beautiful dashboard containing all Amazon navigation menus in one screen. You will able to see no. of records at each box in red fonts. Clicking on each box will navigate you to respective screens.