Amazon Connector Linker

by Inwizards Technology Pvt Ltd

Inwizards Software Technology is a leading US-based software development company that assists businesses to adopt digital transformation and acquire immense success. We specialize in offering a wide range of services, including IT consulting, Custom Software Development, Digital Marketing, SEO, Product Development, Mobile App Development and many more.

$ 500

Installation and Update of the Connector

To upgrade the latest module of our apps for the same Odoo version, Please follow the steps below.

User Access

The system will set Amazon Manager rights to admin and Odoobot as a user once the connector is installed.

There are two types of users:

SP API Re-Authorisation

SP-API Re-Authorisation is a simple process. This process is only applicable once you complete the migration of SP-API.

Navigate to Amazon ↣ Configurations ↣ Sellers

Click the SP-API Re-Authorisation button and you’re done.

SP-API Re-Authorisation:

After clicking on the button SP-API Re-Authorisation You will receive an email with an authentication link that helps you to redirect to Amazon Seller Central and re-authenticate your seller account. This link will expire in 1 hour.

You simply need to click on the Authenticate SP-API button in the email, which will take you to Amazon’s Seller Central login page. You must then log into your Seller Central account.

SP-API data consent: 

When you log into the seller account, Amazon will ask for your consent to access data using the SP API. Simply click the Confirm button. With this, you have successfully completed the registration process.

Amazon Seller Registration and Configuration

Here users can find detailed information about how to register a seller ID/Merchant token, connect a seller central account, connect all the active marketplaces, choose or switch fulfillment by FBA or FBM or FBA FBM, and also an overview of the Amazon connector dashboard.

1st Go to Amazon ↣ Configuration ↣ Settings

TABLE OF CONTENTS

Register Your Seller ID

As per Amazon’s ​Acceptable Use Policy and ​Data Protection Policy, the seller has to authorize  Inwizards’s Seller Application in their Seller Central account, in order to use the connector.
Go to Amazon ↣ Configuration ↣ Settings
Click on Register Your Seller ID

Step-1: Seller Registration Form

A registration form will open after you click on the Register Your Seller ID button. This form requires a few fields to be filled in.

Step-2: Email Verification:

Once the user clicks the Register button on the form. An email verification link will be sent to the email address the user provided in the form. You simply need to click on the Verify button in the email to complete the email verification process.

Step-3: SP API Authentication:

As soon as the email has been verified, the user will receive another email with an authentication link that helps us synchronize with the user’s Seller Central account.

The user simply needs to click on the Authenticate SP-API button in the email, which will take the user to Amazon’s Seller Central login page.

The user must log into his/her Seller Central account.

Step-4: SP-API data consent:

When the user logs in to the seller account, Amazon will ask for the user’s consent to access data using the SP API. Simply click the Confirm button. With this, the User has successfully completed the registration process.

1.1 How to Get Merchant Token/Id:

2.Connect Your Seller Central Account

Go to Amazon ↣ Configuration ↣ Settings Click on Connect Your Seller Central Account A pop-up window will open and you need to fill in the required details here.

After filling in the all required details click on the Create button. Good job, the User has successfully connected your seller account to the Amazon Odoo Connector.

Add More Marketplace to Integrate

3. Add More Marketplace to Integrate:

Once the Amazon seller account is created, the next step is to create marketplaces for the seller.

1.Europe region:

2.USA region:

Switch Amazon Fulfillment By

5.Switch Amazon Fulfillment By: 

Once the user has completed Amazon’s setup and configuration with FBM, FBA, or FBM FBA fulfillment If the seller wants to change their fulfillment network, Inwizards Amazon connector allows the user to change it as per the need.

Amazon Navigation Dashboard

Connector’s dashboard will be helpful for users to analyze different marketplaces. Inwizards Amazon connector dashboard will be the user’s single page to monitor all the Amazon marketplace’s orders as well as products. Based on graphical analyses of orders the user can get an idea about current sales volume.

FBA FBM common configuration

After completing the Amazon registration and marketplace integration process, the user can now go with the common configurations that will apply to both FBA and FBM.

TABLE OF CONTENTS

Settlement Report

1.Settlement Report:

Reimbursement Customer:

Reimbursement Sales Journal

Reimbursement Product:

Configure Amazon Seller Transaction Type:

Transaction Types:

Account

Analytical account Tags

Tax

Shipments and Other Fees

3.Shipments and Other Fees:

Upon installing the connector, the below-mentioned fees will be automatically created. Later on, The user can change it if the user needs to.

Products and Other Configurations

Allow to create new product if not found in Odoo?

Payment Term:

Invoice Upload Policy

4.Invoice Upload to Amazon:

Invoice Upload Policy:

Based on this configuration, users can choose to either upload their invoices to Amazon or download their Amazon-generated invoices.

1) Amazon creates invoices: If the seller has opted for VCS (VAT calculation service) at Seller Central then to enable this feature in odoo, the seller just needs to select Amazon creates invoices in the configuration.

NOTE

*If this configuration is missing in the connector, the seller may get an incorrect tax calculation and order amount.

2) Upload invoices from Odoo: All sellers who have not chosen VCS need to set this invoice policy.

US Seller Tax Configuration

This tax configuration is only for the sellers who belong to the US (United States) region. Here the connector gives support for Python Code for the tax computation. With the help of this feature system will set the product price and its tax based on the configuration

Let’s understand with an example.

NOTE

Marketplace Configuration(FBM FBA)

Configurations:

Stock Type: Here the user has 2 options. The user can update the stock based on Free quantity or based on forecasting quantity. As per the business requirement, the user can choose the option.

Settlement Report Journal: The journal set over here will be used to create a bank statement while processing the settlement report

Ending Balance Account Description: Using this account will allow The user to transfer funds from Amazon to a liquidity or transit account with a given ending balance description.

Analytical Account(Amazon)​: If your analytical account configuration is enabled from Accounting ↣ Configuration ↣ Settings

Analytic Tags(Amazon)​: If your analytical tags configuration is enabled from Accounting ↣ Configuration ↣ Settings

Language Name: ​The user can set the language for the marketplace. Languages can be set differently for different marketplaces. Marketplace-configured Language will be set in Amazon contacts.

Pricelist Name: ​By default, the connector will create a different price list for each instance. When an Amazon order is created, the system sets the price list according to marketplace configuration. Also when the user updates the price of the product on Amazon at that time, the price will be considered based on the marketplace price list.

Account Payable: Select a payables account while creating a new customer, if it is set the account will be assigned to the customer. If it is not configured, the system will set an account based on Odoo flow.

Amazon Sales Team: ​The user can configure different Sales teams for each instance. This Sales team is set in FBM FBA Orders when orders are imported.

Amazon Receivable: When creating a new customer, The user can select a specific receivable account. If it is selected, then the account will be set in the customer. If it is not configured, the system will set an account based on the Odoo flow.

FBM Warehouse: ​It is a fulfillment warehouse for FBM orders. It calculates stock for FBM Products. The stock will also be updated on Amazon from this warehouse.

FBM Warehouse(s): The user can select multiple FBM warehouses to update the total inventory of FBM products from Odoo to Amazon.

FBA Warehouse: This is an Amazon fulfillment warehouse with a different Fulfillment center. When a fulfillment center cannot be found, FBA orders are shipped from this warehouse to the customer.

FBM Seller Configurations

Here we will discuss the FBM Seller Configurations

1. FBM Orders : 

Go to Amazon ↣ Configuration ↣ Settings and select one of the Seller.

Is default Odoo Sequence in Sales Orders (FBM)?

Amazon Order Prefix

Auto Workflow

Inwizards Amazon connector has the facility to configure auto sales workflow to import orders in different stages. Such as in draft state or to import as confirmed sales orders or import as confirmed sales order along with auto invoice creation or import as confirmed sales order along with auto invoice creation and mark invoice as “in payment” with bank journal.

Options to be filled while creating workflow are:

NOTE

2.Inventory

Fulfillment Latency:

In Odoo, fulfillment latency is known as the delivery lead time, which is useful when exporting inventory to Amazon. The user can configure it by following below steps:

FBA Seller Configurations

1.FBA Orders

Does Another Software Create the FBA Shipment Reports?

If The user is using any third-party integration other than this connector and those tools also request shipment reports for the same time range for which the user requested this shipment report then in such case Amazon will cancel one request, so if this option is selected then the system will not ask for the new shipment report instead, it will download the report already generated by another software.

Default Customer for FBA Pending order

Customer to be set in a quotation for FBA pending order.

Is Default Odoo Sequence in Sales Orders (FBA) ?

At the time of importing orders into Odoo, you have the option of selecting whether you want to set Odoo’s SO number or Amazon’s SO number in the order. If this option is selected then by default Odoo’s SO number will be applied to that Sales Order.

Amazon FBA Order Prefix

The user can set the prefix to add before the order reference so as to identify the orders that have come from Amazon.

Are Fulfillment Centers Required to Import FBA Orders?

Note

You can sync the latest fulfillment centers to your warehouses by clicking on the sync fulfillment centers button visible only when the Are fulfillment centers required to import FBA orders the toggle is active.

Options to be filled while creating workflow are:

NOTE

Force Accounting Date:

If ticked, it’s the default behaviour of the system to take the current date as the invoice date upon validating the invoice. In this case, the invoice number will be generated based on the invoice date. This field is used when the user wants to generate account entry based on order date instead of the current date. In this case, the invoice date will be the same as the current date and the journal entry date will be same as order date.

Payment Journal:

The user needs to set the Payment Journal to register payment.

Debit method:

The user can set the debit method of the payment. Alternatively, The user can create a debit method using either an inbound or outbound payment type.

Shipping Policy:

​The user needs to set a shipping policy for FBM orders.

Sales Journal:

The Invoices for Customers must be set up in the Sales journal.

2.Inventory

Auto Validate Amazon FBA Live Stock Report

If true, the system will automatically validate and adjust the stock based on the FBA Live inventory report.

Is Reserved Quantity to be Included FBA Live Inventory Report?

If the user wants the reserved quantity to be included in the FBA Live inventory page then the user needs to set this value true.

Does Other Software Create the FBA Inventory Reports?

If users are using any third-party integration other than this connector tool and those tools also request inventory reports for the same time for which we requested this inventory report then in such case Amazon will cancel one request, so if this option is selected then the system will not ask for the new inventory report instead, it will download the report already generated by another software.

3.Removal Orders

Allow Create Removal Order In FBA ?

A removal order will be created by the system for the configured marketplace.

Removal Order Marketplace

Removal Warehouse

After clicking on Allow Create Removal Orders in FBA, the system asks the user to set up a removal warehouse.

FBA Liquidation Partner: Clicking on Allow Create Removal Orders in FBA prompts the system to set an FBA liquidation partner.

4.Outbound Shipment

This connector provides functionality to create outbound orders (Orders other than Amazon marketplace). Outbound orders refer to orders that come from another marketplace or other e-commerce platform.

Allow Auto Create Outbound Orders: If this configuration is enabled, the system will automatically start the scheduler to create outbound orders from Odoo to Amazon.

Fulfillment Policy:

There are three fulfillment policies for outbound orders.

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 canceled by the seller.

FillAllAvailable:

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

NOTE

​Shipping method service level agreements vary depending on the marketplace. See the Amazon Seller Central website for shipping methods service level agreements and fulfillment fees on the marketplace.

Create Outbound on Order Confirmation: If this configuration is enabled, the system will automatically create outbound orders from Odoo to Amazon when a Sales order is confirmed.

Default Instance for Outbound Orders: When outbound sales orders are created in the system, this instance will be set as default.

FBA FBM Operations

Here we will discuss some operations of Connector. These operations are common whether The seller is enrolled with FBA or FBM or both.

TABLE OF CONTENTS

Import/Map Products

The connector doesn’t directly sync products between Amazon and Odoo, instead, it creates a layer above odoo products called Amazon products. It will sync Amazon products with existing odoo products and if the product is not found, then the system will create a product in odoo based on configuration.

Sync process:​ The user can sync the products in 2 ways:

1. Import Products

How To Process this operation:

The sync process will search for SKUs in Amazon products. If SKU is found, it will update with the latest data received from the report and move that report to the processed stage.

If the system does not sync the report correctly, a screen like the following is displayed:

To view mismatch details, click on the Mismatch Details button.

2. Map Products

How To Process this operation:

Here the user can download a sample format to map the products. click on the Download sample attachment to download a sample file with the required format.

The sample file will have 5 columns viz. - Title, Internal Reference, Seller SKU, Marketplace, Fulfilment.

NOTE

Tip Multiple Amazon products can be managed under the same Odoo product. In this case, Internal Reference will be the same and the Seller SKU will vary.

Export/Update Products

Export products to Amazon (This way will export products from amazon products layer to amazon marletplace)

After importing the CSV , .xlsx or .xls files the user must configure the required fields.

1.Product Info

2.Amazon Info

3.Product listing and elements

Based on this system, this is the main field that exports products from Odoo to Amazon. Here you can manage your products’ dimensions and weights that update in Amazon.

4.Features Search terms

Those fields are not required, but the seller can configure them if they wish to use different features and search terms.

5.Description Disclaimer

Here you can add the product description that is updated on the Amazon marketplace.

Export to Amazon :

TIP

NOTE

Update Products Price and Stock in Amazon

1. Update Product Price in Amazon

Once The user sets the price list then after the user can update the price by

TIP

When a user exports a product from Odoo to Amazon, the system will first create a listing as incomplete. After exporting price and stock, the listing will become active on Amazon.

Seller Rating

Manual through Operations:

Automatically through Scheduler:

To make this process automated you can navigate to Amazon ↣ Configuration ↣ Sellers ↣ FBA FBM Schedulers.

Settlement Report Process

NOTE

​Amazon provides settlement reports in 3 formats. viz. XML, Flat file Flat file V2, out of which the module supports ​Flat file V2 ​format only. So before proceeding with settlement report processing in Odoo please check Amazon seller central settings and make necessary changes if required.

How this process works:

Configurations to be ensured Before processing Settlement Report:

All the Amazon fees such as Amazon subscription, commission fees, or other transaction types will be reconciled automatically with the accounts you have configured under Amazon ↣ Configuration ↣ Settings ↣ Settlement Report ↣ Click on Configure Amazon seller transactions type.

Settlement Report Process

The user can process the settlement report in 2 ways.

1.Manually through Operations:

Settlement reports are generated regularly by Amazon at the seller central account, and the seller can download them from Odoo.

If the user does not specify the date range then the system by default will request a report for the past 90 days.

The user can see all of your settlement reports from the menu ​Amazon ↣ Sales ↣ Invoices Settlement ↣ Settlement Reports​. The user can see all the settlement reports marketplace-wise.

2.Automatically through scheduler:

The user can set a scheduler in the system to download and process settlement reports automatically. The user can set the scheduler by navigating to Amazon ↣ Configuration ↣ Sellers ↣ FBA FBM Schedulers.

*Sometimes seller may receive Fatal or cancel status of this reports.

Fatal status: Seller can get Fatal status for two reasons.

Cancel status: When Seller already has data in your Odoo environment, the connector will cancel any duplicate reports.

FBM Operations

Here the user can get detailed information about different FBM operations. Such as importing FBM unshipped/shipped orders, Canceling FBM orders in Amazon Seller Central, and how to update shipping information in Seller Central.

TABLE OF CONTENTS

Export or Update Product Stock in Amazon

Consider the below-mentioned configuration-related export/update product stock.

There are 3 ways to update stock from Odoo to Amazon:

1.Individual product wise :

The user can select specific products from the Amazon product list and click on the Update Stock in Amazon option. As the product over here is associated with a single marketplace, it will update the stock for that concerned marketplace only.

2.Bulk product with marketplace

3.With help of scheduler :

Export shipping details with tracking number in Amazon

Once the unshipped orders are imported into Odoo, The user can update the tracking number for each delivery order.

There are 2 ways to update tracking numbers:

Manually Through Operations

Automatically Through Scheduler

The user can configure this automated job from Amazon configuration. This scheduler will set a specific interval for updating order status and tracking number from your sales orders from Odoo to Amazon. The user can set different schedulers for different sellers.

Delivery/Shipping Method

As per FBM FBA shipping methods. Amazon offers the following shipping service level categories.

1.Configuration of Delivery/shipping Method

Shipping Method Name: The user can enter the name of the shipping method here. For reference, it can be anything.

Amazon Carrier Code: Amazon provides a list of different carrier codes that also have been provided in the connector, If the shipping provider code is not in the list then the user can select “Other”.

Amazon Shipping Method(FBM, FBA): As mentioned above, Amazon supports different shipping methods along with orders.

Here The user can select the shipping method for the orders when orders are imported from the Amazon system will select delivery/shipping method according to the configured Amazon Shipping Method(FBM, FBA)

Shipment Service Level Category (Outbound Orders): Here The user can select the shipment service level category for the outbound orders. In the process of exporting orders from Odoo to Amazon, the configured service level categories are exported.

FBM Shipping Method: If the user selects Amazon Carrier Code with the option of Other from the drop-down the user should configure the shipping method name. If the FBM Shipping Method contains Other carriers, the system will export this code and if they are available, but not configured, the system will export the delivery carrier name from Odoo to Amazon.

Please refer to the below-mentioned cases which are helpful for the configuration of delivery/shipping methods.

Case-01: Delivery method with Amazon carrier code

Condition 01 : Amazon shipping method(FBM,FBA) : Set as Standard Result: When the order is imported, the system will set the carrier because the Amazon shipping method(FBM, FBA) is set.

Condition 02 : Amazon shipping method(FBM,FBA) :Not Set Result: When the order is imported, the system will not set the carrier because the Amazon shipping method(FBM, FBA) is not set.

Case-03: Delivery method with Amazon carrier code as “Other” and FBM shipping method

Condition 01 : If Amazon carrier code : Set as “Other” , FBM shipping method : Set

Condition 02 : If Amazon carrier code : Set as “Other” , FBM shipping method : Not Set

When the order status is updated in Amazon Seller Central, the system will send the tracking number with delivery/shipping method name.

2.How to set manually delivery carrier

After processing the FBM unshipped orders you have to ship them to the customer address with the user’s shipping provider.

The user can select the carrier by manual process.

The user will see the below screen

If the Amazon shipping method is configured with the delivery/shipping method so system will automatically select the delivery method accordingly.

If the Amazon shipping method is not configured with the delivery/shipping method the user has to set it manually.

FBM Cancel Orders

The user can cancel any Amazon orders directly from Odoo and can also import FBM-canceled orders from Amazon to Odoo.

1. Cancel order from odoo to Amazon

To cancel the orders first the user needs to cancel the delivery picking for a specific sales order and then the user will be able to cancel the order.

2. Cancel order from Amazon to odoo

The user can even cancel the order from Amazon and it will be updated in Odoo as well while importing orders.

When an order is canceled in Amazon, the system will cancel the order in Odoo as well. The system can fetch FBM cancel orders from Amazon to Odoo in 2 ways:

A. AUTOMATICALLY THROUGH SCHEDULER

Go to ​Amazon ↣ Configurations ↣ Sellers ↣ FBM scheduler.

MANUALLY THROUGH OPERATIONS

Import FBM shipped orders

Manually Through Operations:

Automatically Through Scheduler:

FBM Unshipped Orders

There are two ways to import FBM Unshipped sales orders from Amazon to Odoo.

1. Manually through Operations

The user can manually import unshipped orders by following the below path.

As soon as the user clicks on the Execute button, the user will see a new screen with the Process Orders button, and the order queues will be in the Draft stage at that time. *Then if there is any mismatch then the queue will be in the partial process stage and if there is no mismatch then queues will be deleted at the same moment.

For viewing the Unship order list Navigate to ​FBM menu ↣ Sale Order Report

2. Automatically Through Scheduler

  • Go to ​Amazon ↣ Configuration ↣ Sellers ↣ FBM Scheduler.
  • If the user wants to fetch FBM unshipped orders from Amazon to Odoo automatically at specific intervals then the user can create a scheduler using this option to request an FBM order report from Amazon.
  • By default, the system will import only unshipped orders of last 30 days.

FBM Missing Unshipped Orders scheduler

  • Missing unshipped orders means which orders due to any reason not imported while requesting unshipped orders.
  • When the user requests FBM missing unshipped orders to Amazon, the system sends a request to Amazon the find the missing unshipped order to be imported.
  • After requesting the FBM missing unshipped orders reports system created an order data queue which automatically processed after a while, and the queue will disappear from the list view after being processed by the system.
  • A missing unshipped order process is similar to the FBM unshipped orders.

FBA Operations

  • Here the user can get detailed information about the FBA operations of the Amazon connector. Such as importing FBA pending and shipped orders, importing FBA live stock from Seller Central, marking cancel orders in odoo from Seller Central, how to import inbound shipments, and how a user can prepare an inbound shipment plan from odoo itself.

TABLE OF CONTENTS

  • FBA Live Inventory Report
  • FBA Pending Cancel Orders
  • FBA Shipment Report
  • FBA Customer Returns
  • FBA Stock Adjustments
  • FBA Removal Orders
  • Outbound Shipment Orders
  • Inbound Shipment
  • Inbound Shipment Plan

FBA Live Inventory Report

Amazon FBA connector provides features to get livestock and upgrade sellable/non-sellable inventory in Odoo. The system will create validate inventory adjustments based on this report.

  • Before processing the FBA live inventory report the user has to ensure the FBA Inventory configuration which is mentioned in the FBA Seller configuration.
  • The user can do this process using two ways:

Manually through Operations

  • Step-1: Go to ​Amazon ↣ Operations
  • Step-2: Select the Amazon Seller and
  • Step-3: Select Operations for FBA
  • Step-4: Select Operations as Import FBA Inventory.
  • Step-5: Click on button Execute

Same as shipment and customer return reports, users can request a report and wait for 10 or 20 seconds to click on the check status button. If the report is not ready then the status shown is In Progress and when the report is ready then the status shown is Done.

  • If the status is Done then the user can click on Get report
  • After getting this report user can click on Process file and process report.
  • Here, the system will create two different inventories for sellable and unsellable product stock.
  • Also user can download the report in an Excel sheet by clicking on Download Report

Go to ​FBA ↣ Inventort Report ↣ Select Any Report If the selected report has been processed so user can see the smart button top on the right side with Stock inventory.

The quantity of FBA inventory in your ODOO system will be updated based on the total amount of AFN-fulfillable-quantity that the seller has in their live inventory report.

  • If a customer wants to add a reserved quantity from the FBA live inventory report to Odoo FBA inventory quantity, they need to enable the option “Is Reserved Quantity to be included in the FBA Live Inventory Report?” in the settings section.
  • It is not possible to add information about the lot/ serial number in the Odoo system through the FBA inventory report. The seller needs to manage this manually.

Automatically through Scheduler

User can configure the scheduler to request and process FBA live inventory report from Amazon ↣ Configuration ↣ Sellers ↣ FBA Scheduler.

FBA Pending Cancel Orders

1. Import Pending Orders

What is Pending Orders?

  • Pending order means those orders which are placed by the customer, payment verified by Amazon but shipment is pending by Amazon.
  • In Pending orders, Amazon does not provide any details related to customer and product price. Amazon only provides order references, order dates, products, and quantities.
  • This feature is useful to those sellers who want to reserve stock in quotation state for advance purchase reordering process.
  • Configurations to be ensured before importing FBA Pending orders

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 Odoo, then it will automatically create a new Odoo Product and Amazon Product. It will also create a mapping between Odoo Products and Amazon Products. Check this field for this operation.
  • This can be done from ​Amazon ↣ Configuration ↣ Settings ↣ Products and Other Configurations.

Note

A System will set partners and create order sequences based on seller configuration. Pending order must be in draft state and order amount value should be 0. Users can not edit or modify orders manually. Users can process Pending Orders using two methods.

1.Manually through Operations

  • Step-1: Go to ​Amazon ↣ Operations​.
  • Step-2: Select the respective Amazon Seller
  • Step-3: Select Operation for FBA
  • Step-4: Select Operations as Import Unshipped Orders
  • Step-5: Click on the Excute button
  • Step-6: Select Marketplace: the user can select multiple marketplaces.
  • Updated After features the user needs to choose the date from when the user wants to Import the pending Order.
  • It will import the pending order from the date the user has chosen until the current date.

2.Automatically through Scheduler

The user can configure a scheduler by navigating to ​Amazon ↣ Configuration ↣ Seller ↣ FBA Scheduler​.

FBA Cancel Order in Amazon

  • In the case of Amazon Pending orders, it can be possible that the order is canceled by Amazon or a customer.
  • In the connector there is a feature to check the pending order status.
  • If it is canceled by Amazon then the system will cancel the order in Odoo too.
  • If the user has manually confirmed orders then the system will not cancel the order in Odoo.

Users can process Cancel orders using two methods.

1.Manually through Operations

  • Step-1: Go to ​Amazon ↣ Operations​.
  • Step-2: Select the respective Amazon Seller
  • Step-3: Select Operation for FBA
  • Step-4: Select Operations as Mark cancel orders
  • Step-5: Click on the Execute button

2. Automatically through Scheduler

The user can configure a scheduler by navigating to Amazon ↣ Configuration ↣ Sellers ↣ FBA Scheduler.

FBA Shipment Report

Amazon Shipment Report provides comprehensive details of Orders that are Shipped by Amazon FBA (Fulfilment By Amazon) including price, quantity, tracking numbers, and shipping info.

The user can download a Shipment Report from Amazon either automatically or manually for specific date periods. The system will request, download, and process it and change the status of your FBA Orders (If any pending FBA orders) and update tracking information in Orders respectively.

Configuration to be ensured before processing shipment report: refer to FBA seller configurations

Tax configurations of Odoo:

While importing orders, the system will apply tax based on your product and fiscal position configuration.

Product:

  • At the time of processing the shipment report If the product is not found in Odoo and the user has configured auto-create product true in Amazon Settings, then the system will create a new product automatically and create orders.

Amazon FBA Order Prefix:

  • Before processing orders check the configuration of the prefix and default sequence of Odoo from Amazon ↣ Configurations ↣ Settings ↣ Amazon Seller. The user will be able to locate it under the FBA Orders section.
  • Once the user processes the shipment report, the user will be able to see FBA orders under ​Amazon ↣ Sales ↣ FBA ↣ Orders.

How the Shipment Report is Processed in the System

Order:

  • While processing the report, the first system will check whether any pending order is available. If it is available then the system will delete the pending order and create a new order. No duplicate orders will be created during this process.

Stock Move:

  • After creating order in odoo, the system will create stock moves for orders and do stock moves based on the availability of stock in the respective stock locations.
  • The state of the stock moves will depend on Odoo’s default workflow when the stock is not available.

Warehouse:

  • In the shipment report the user gets details of the marketplace and fulfillment center. While processing the order system will search the marketplace and warehouse in odoo based on the fulfilment centre code.
  • If it is found then the system will select warehouse or FBA warehouse (Based on marketplace configuration).

Tax calculation:

  • In this connector, there is a functionality to detect fiscal positions based on fulfillment warehouse country. For this user needs to ensure that their fiscal positions are configured properly in Accounting ↣ Configuration ↣ Fiscal Position.
  • Whenever an order is imported, the system checks if it is an Amazon order. If not, it will use the default fiscal position setting of Odoo.

Below are the steps showing how the fiscal position is applied to the Amazon orders.

  • Find the fiscal position where both the origin country and country are set.
  • Find the fiscal position only for the country.
  • Find the fiscal position where the origin country and the country group are set.
  • Find the fiscal position only for the country group.
  • Find the fiscal position only for the origin country.

Note

  • The first fiscal position that was acquired in the above steps will be applied to the sale order.
  • The origin country is the country set in the warehouse.
  • Based on the delivery address, the country and country group is searched.

Request and Process Shipment Report

There are 2 ways to request and process shipment reports in the system:

Manually through Operations:

  • Step-1:Go to Amazon ↣ Operations.
  • Step-2:Select the respectiveAmazon Seller
  • Step-3: Select FBA Operation
  • Step-4:Select Operation for Import FBA shipped orders
  • The system will select the start date and end date. The end date is the current date and the start date is the difference between the Current Date and default Shipment Request Report Days. By default, the user can configure Shipment Request Report days in Amazon Seller. Default days to request a report are set for 3 days in the connector.
  • Click on the Excute button

The user can view all the generated Shipment reports from ​Amazon ↣ FBA ↣ Orders Returns ↣ Shipment Reports.

Process to be followed:

  • When the user clicks on the Execute button the user can see the Check Status button will be visible on screen.
  • It will take a few seconds to process their request on the Amazon server
  • Now, click on the Check Status button, if the report is still not done from the Amazon side then the status will be In Progress.
  • Once the report is available the status will be changed to Done and the Get Report button will be visible.
  • Click on Get Report to import report in Odoo.
  • After clicking on Get Report, two buttons will be visible. Download Report and Process File.
  • The user can download that report by clicking on the Download Report but report data is encrypted.
  • Just click on Process File to process the file.

After Processing the report, the system will create orders, process delivery orders, create invoices, and validate invoices based on Auto workflow configuration.

Now, the system will show two buttons Reprocess file and Mismatch details.

Reprocess File: User can reprocess file if products are missing in Odoo. After creating products just reprocess the file to fetch the orders for those products.

  • Mismatch details:User can see mismatch details and correct them like products not found in Odoo.
  • Top right side the user can see the Two smart buttons as Sales Orders and Stock moves with the help of those buttons the user can redirect to the FBA sales orders.

TIP

If the seller has enabled the VCS feature then the system will not create invoices while processing shipment reports. Instead, Invoices will be created when the user imports a VCS report from Amazon.

Automatically through scheduler:

  • The user can configure a scheduler under the menu ​Amazon ↣ Configuration ↣ Sellers ↣ FBA scheduler.

FBA Customer Returns

  • This feature is used to Import FBA Customer Returns from Seller Central and process those Return Reports in Odoo.
  • In these reports, the user will also get the return reason for which the product was returned, if the return reason is provided by the customer.
  • The user can also identify that the product in the report is either Sellable or Unsellable. Amazon Manages Unsellable Inventory for Unsellable Products.
  • When the user processes the return report then the system will search the sales orders and if it is not found, then the system will not create the return stock move.
  • If an order is available then the system will create a return stock move the source location will be the customer and the destination location will be set based on the product type it can be Sellable or Unsellable
  • If the product is unsellable then you need to go to the unsellable location and if the product is sellable then it will be returned to the Amazon warehouse. The system will not create any credit notes in the return process.

With the help of this connector, you can even manage Unsellable Location in Odoo

  • To configure Unsellable Location, you need to go to the menu ​Amazon ↣ Configuration ↣ Settings and Go to Amazon Marketplace configuration page under Orders and Returns.

Tip

The connector by default creates one Unsellable Location. You can set different Unsellable Locations for each Marketplace.

Request and Process Customer's Return Report

There are two ways to Process Customer Return Reports:

Manually Through Operations:

  • Step-1: Go to ​Amazon ↣ Operations​.
  • Step-2: Select the respective Amazon Seller
  • Step-3: Select FBA Operation
  • Step-4: Select Operations for Import Customer Returns Orders
  • Step-5: Click on the Excute button
  • By default, the system will choose the last three days in the date range.

Process to Follow

  • Once the user selects the date and Amazon seller the user needs to click on the Execute, Shipment state will be Submitted, and the Check Status button will be visible.
  • The user must wait for 10 or 20 seconds and click on Check Status.
  • If the report is still in process at the Amazon side then the report state will change from the Submitted state -> InProgress state.
  • Once the process is completed from the Amazon side then the status will be moved from the Submitted state -> Done.
  • Once the report is processed, the user will be able to see the Get Report button.
  • The user clicks on Get Report to import the Report in Odoo. After the user clicks on Get Report, He/she will be able to see two buttons, Download Report Process File.

The user can download the report by clicking on the Download Report. To process the Return Report file The user needs to click on Process File and Create FBA Customer return stock moves in Odoo.

After Successfully processing the Return report, The user can see return stock moves. Now, the user will be able to see two buttons Reprocess file and Mismatch details.

Reprocess File: The user can reprocess the file if products are missing and after creating the missing products the user just needs to re-process the file.

Mismatch details: User can see mismatch details and correct them like Order not available in ERP.

The User can see all the FBA return reports under the ​Amazon ↣ FBA ↣ Orders Return ↣ Customer Return Reports.

Automatically through scheduler:

The user can use the scheduler to process the customer returns.

  • The user can Configure a Scheduler that will Request, download, and process Customer Return Reports automatically from Amazon FBA.
  • To set the scheduler Go to ​Amazon ↣ Configuration ↣ Sellers ↣ FBA Scheduler.
  • The return orders stock moves are listed under the ​Amazon ↣ Sales ↣ FBA ↣ Returns Moves.

FBA Stock Adjustment

In many cases, the stock in Amazon fulfillment center faces some problems and it cannot be used further until it is replaced.

Amazon prepares reports for those on FBA inventory adjustments and updates the latest usable stock in it. So, based on this, the user can carry out stock movements accordingly in Odoo.

Group of reasons for FBA inventory adjustment

  • Misplaced and Found inventory: Products which are misplaced by Amazon or the products which were misplaced by Amazon and found by Amazon.
  • Damage inventory: Products that are damaged by Amazon and then transferred to the unsellable location.
  • Unrecoverable inventory: Products that are either damaged by Amazon or which are lost by Amazon in these cases the seller can claim reimbursement.
  • Inbound shipment received adjustments: During the inbound shipment receiving process if there is any issue related to miscount or product not scanned.
  • Software corrections: Software correction of inventory tracking discrepancies in Amazon.
  • Transferring ownership: In this case, Amazon has reimbursed the products that were lost. Now, if it is found later, then Amazon will change ownership for that product in holding an account.
  • Catalog Management: The two products with separate identifiers are found as the same in our catalog with Amazon, they will delete one of them and move inventory to another product.

Configurations for Stock Adjustment Reason:

All the groups mentioned above have different codes provided by Amazon as shown in the screenshot below. The user will be able to locate the reason under the Amazon ↣ Configuration ↣ FBA Stock Adjustment Reasons.

Configurations for Stock Adjustment:

  • The user can configure Amazon Stock Adjustment in Odoo
  • Go to ​Amazon ↣ Configuration ↣ FBA Stock Adjustment.

Group: Select any one reason from the drop-down menu for which the stock adjustment needs to be made in the Amazon FBA Inventory.

  • Location: Select the location of your warehouse from the drop-down menu the user had configured in Odoo where the user wants to record this type of transaction.
  • Is Send Email?: The system will send emails to configured users for any transactions taken place for Stock Adjustment in Amazon FBA Inventory. The user can select the Email Template from the drop-down menu or you can create a new template for this type of transaction.

Request and Process Stock Adjustment

Once the Stock Adjustment Configuration is done, we will fetch the stock adjustment report from Amazon. There are two ways to fetch their Amazon stock adjustment in Odoo.

Manually through Operations

  • Step-1: Go to ​Amazon ↣ Operations​.
  • Step-2: Select the respective Amazon Seller
  • Step-3: Select FBA Operation
  • Step-4: Select Operations for Import FBA Stock Adjustment
  • Step-5: The user can select the data range.
  • Step-6: Click on the Excute button

Once, the user requests a stock adjustment report from Amazon,

It will be visible under the tab Amazon ↣ FBA ↣ FBA Inventory ↣ Stock Adjustment. The user will also find all the previously created reports.

Now, the user needs to process the fetched reports from Amazon. Click on any of the listed reports. The user will see the button to process the Inventory Adjustments as shown below. The user can also see the real-time status of adjustments in the Amazon FBA Inventory.

Note

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

Automatically through Scheduler:

Go to ​Amazon ↣ Configuration ↣ Sellers ↣ FBA Scheduler.

FBA Removal Order Process

  • There can be a scenario where some of the stock becomes unsellable due to unavoidable circumstances in which it cannot be restored back to its original state.
  • In this case, The user can either remove the stock from the Amazon FBA warehouse or dispose of it.

There are three types of removal orders

  • Return
  • Disposal
  • Liquidation

1.Return:

  • In the removal order process, the user can create removal orders to get back the product from the Amazon warehouse to the Merchant warehouse.
  • User can return two types of products: Sellable and Unsellable products.
  • If the product is **unsellable, then the system will transfer from Amazon’s unsellable location to the Merchant warehouse, scrap location.
  • If the product is **sellable, then the system will transfer from the Amazon stock location to the Merchant warehouse stock location.

NOTE

The system will select a Merchant warehouse based on configuration and also select a location based on routes.

2.Disposal:

  • In this case, Amazon will dispose of products and in the Odoo system, it will create an internal transfer from Amazon sellable/unsellable location to Inventory Loss.
  • If the product is **sellable, then the system will transfer from Amazon stock location to Inventory Loss.
  • If the product is **unsellable, then the system will transfer from Amazon’s unsellable location to Inventory Loss.

3.Liquidation:

In this case, Amazon will liquidate the products, and the connector will create an internal transfer from Amazon’s sellable/unsellable location to the Customers’ location.

Create Removal Order from Odoo

The user can request the FBA removal orders in two ways, one is Manually and the other is using the scheduler.

NOTE

  • This report contains all the removal orders, including the items in each removal order, placed during any given time period.
  • This can be used to help reconcile the total number of items requested to be removed from an Amazon fulfillment center with the actual number of items > removed, along with the status of each item in the removal order.

Manually through Operations:

  • Step-1: Go to ​Amazon ↣ Operations​.
  • Step-2: Select the respective Amazon Seller
  • Step-3: Select FBA Operation
  • Step-4: Select Operations for Import FBA Removal Orders
  • Step-5: The user needs to select the data range.
  • Step-6: Click on the Excute button

Automatically through Scheduler:

The user needs go to ​Amazon ↣ Configuration ↣ Sellers ↣ FBA Scheduler.

Create Removal Order from Odoo

  • The user can create a removal order by
  • Go to Amazon ↣ FBA ↣ Removal Orders ↣ Create Removal Order Plan.
  • Here The user can specify removal order Marketplace.

After performing the above action, The user will be redirected to the removal order form view, where the user can enter the following details:

  • Marketplace: Choose the Marketplace for which the user would like to create a removal order.
  • Destination Warehouse: By default, the system will select Removal Warehouse based on instance configuration.
  • Removal Disposition: The user can choose either to return the product or to dispose of the product.
  • Shipping Address: If removal disposition is returned, then the shipping address is required. Users can create removal orders manually or import using a CSV file.
  • When the removal order is created by the user, the system will automatically create a removal order on Amazon and change the state to the removal plan approved.

When the Removal Order is in the Draft Stage, Amazon will decide to process it further. Once the order is processed, the user can see the status of the products covered in the Removal Order by clicking on the button generated at the top right as shown below.

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

Process Removal Order Report

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

  • If the status is Cancelled, then the system will cancel all those related moves of products from the Amazon FBA warehouse to the seller’s warehouse.
  • If the status is Completed, then the system will transfer picking in Odoo otherwise the system will just skip the lines.
  • If the status is Pending, then there are 3 possibilities:
    1. If it finds the shipped quantity, then the system will create a transfer picking.
    2. If it finds the canceled quantity, then the system will cancel the stock moves for those products.
    3. If it finds the in-progress quantity, then the system will create a backorder for partially shipped products.

The user can view the removal orders report by going to Amazon ↣ FBA ↣ Removal ↣ Removal Orders Report.

In the report, if we have a removal order reference that does not exist in Odoo but where auto-created by Amazon, then the system will create those removal orders and process it further just as the user processed earlier orders that were created manually.

Scheduler Configuration

What is a scheduler and its usage ?

With the help of the scheduler, the operation will automatically be performed by the time intervals configured by the system.

  • It can be hours, days, or months.
  • The user needs to configure the scheduler Seller-wise
  • Go to Amazon ↣ Configuration ↣ Sellers

Archive Seller

  • The user can see in the following screen the Archive seller button
  • Click on the Archive seller button
  • With the help of this feature, the user can archive or unarchive their seller.

Note

By clicking on Confirm, the system will perform the following operations-

  • Archive the seller’s Account
  • Archive the FBA Warehouse associated with the selected Seller Account
  • Archive Schedulers activated for the selected Seller Account
  • Archive Marketplaces connected to the selected Seller Account
  • Remove Fulfillment Centers connected to the selected Seller Account
  • Remove Amazon Products mapping connected to the selected Seller Account

FBM Schedulers

The user can set the following schedulers with the help of this connector to automate their transactions.

  • Step-1: Go to Amazon ↣ Configuration ↣ Sellers.
  • Step-2: Click on the Seller
  • Step-3: Click on the FBM Scheduler button

To set the scheduler, the user will be required to enter 3 values:

  • Time:​The user can set the interval in Hours Dayswhich means the scheduler will run after a selected time interval.
  • Execution date time: Here the user can set the execution date and time from which the scheduler will operate. To avoid conflict among cron jobs of the scheduler, It is advisable to keep a few minutes difference among all schedulers.
  • User:​The user has to select the user through which he/she wants the task to be carried out. Make sure that the user selected for this task has the rights to the same.

Auto Import FBM Order Report

  • This scheduler will import FBM Unshipped Orders reports and process them from Amazon to Odoo.
  • Scheduler’s ideal time interval:
    1. FBM: Import Amazon orders: 12 Hours
    2. FBM: Process Amazon Orders: 30 minutes

Auto Export Stock

  • This scheduler will export the FBM products stocks to Amazon from the configured warehouses.
  • Stocks exported from the Odoo warehouse to Amazon.

Auto Update FBM Order Status

  • This scheduler will update the Tracking numbers and order status for the FBM orders on Amazon which are shipped by the Merchant.
  • Update tracking number and order status in Odoo to Amazon.

Auto Check Canceled FBM Order in Amazon

  • Cancelled FBM orders** will be imported and processed from Amazon to Odoo using this scheduler.

Auto Import FBM shipped Orders

  • This scheduler will import and process FBM orders from Amazon into Odoo.
  • Scheduler’s ideal time interval:
    1. FBM: Import FBM Shipped Orders: 1 Hour
  • the user can view all the schedulers in the following section.

FBA Schedulers

The Amazon connector will perform all the below-mentioned FBA processes automatically based on the intervals set by users for each process.

  • Step-1: Navigate to Amazon ↣ Configuration ↣ Sellers.
  • Step-2: Click on the Seller
  • step-3: Click on the FBA Scheduler button

To set the scheduler, the user will be required to enter 3 values:

  • Time:​The user can set the interval in Hours Dayswhich means the scheduler will run after a selected time interval.
  • Execution date and time: Here the user can set the execution time and date of when the scheduler will begin.
  • User:​The user has to select the user through which he/she wants the task to be carried out. Make sure that the user selected for this task has the rights to the same.

Auto Request FBA Pending Order

  • This scheduler automates the process of FBA pending orders and checks canceled orders on Amazon.

Auto Request and Process FBA Shipment Report

  • This scheduler automates the request and process of the FBA shipment report. Partially processed reports need to be processed manually. The scheduler will not process partially processed schedulers.
  • Scheduler’s ideal interval time:
    1. FBA: Import Amazon FBA Shipment Report: 12 hours
    2. FBA: Process Amazon FBA Shipment Report: 30 minutes.

Auto Request and Process Removal Order Report

  • This scheduler automates the request and process of the removal order report.

Auto Request and Process FBA Customer Return Report

  • This scheduler automates the request and process of the FBA customer return report.

Auto Request and Process FBA Live Stock Report

  • This scheduler automates the request and process of the live FBA inventory report from Amazon.

Auto Request and Process FBA Stock Adjustment Report

  • This scheduler automates the request and process of the live FBA stock adjustment report from Amazon.

Auto Import FBA Inbound Shipment Item Status

  • This scheduler automates the process of importing FBA inbound shipment item status from Amazon.

The system will check the status of all inbound shipments that have not yet been completely closed by Amazon. According to the setup for status days, if the shipment is closed by Amazon, the system will check the status with Amazon.

Inwizards online

Inwizards

Hi,
How can I help you ?

Start Chat