Zoho Inventory - Amazon UK Integration
IN THIS PAGE…
Watch this video for in-depth understanding of the integration.
1. Generate your account identifiers
- Go to sellercentral.amazon.com
- Log into your Amazon Seller Central account.
- Go to the Appstore menu and click Manage Your Apps.
- Click the Authorize new developer button.
- Enter ‘Zoho Inventory’ for Developer Name, and ‘556617177700’ for Developer ID.
- Click Next to proceed to the license agreement page.
- Accept the Amazon MWS License Agreements and click Next.
Your account identifiers (Seller ID and MWSAuthtoken ID) will be generated. Note them down as they’re essential to establish the integration between Zoho Inventory and Amazon UK.
2. Integrate with Amazon UK
- The base currency in Zoho Inventory and your Amazon UK marketplace must be the same.
- Enable VAT in Zoho Inventory. To do so, go to Settings, then VAT.
To integrate Zoho Inventory with Amazon UK:
- Log in to your Zoho Inventory organisation.
- Go to Settings, Integrations, then Marketplaces.
- Click the Set Up Now button under amazon.co.uk.
- Enter your account identifiers (Seller ID and MWSAuthtoken ID).
- Click the Connect button to proceed.
After a brief authentication, your amazon account will be successfully integrated with Zoho Inventory. You can start tracking inventory for every sale you make in Amazon UK.
How it works
Your data will be synced in 15 mins from successful authentication. After that, an automated sync takes place every four hours.
- If a sales channel item matches an item in Zoho Inventory in terms of SKU or item name, they’re linked automatically.
- If a sales channel item does not match any item in Zoho Inventory, it’s categorised as an Unconfirmed Item. You can link it to an existing item or add them as a new item. Learn more about managing sales channel items.
- Item groups from amazon with more than three attributes will not be synced, as Zoho Inventory only supports up to three attributes.
Sales Orders & Customers
- When a customer places an order for your item on amazon, a sales order is generated automatically in Zoho Inventory as well.
- All guest customers who place an order through your amazon store will be recorded as Customers in Zoho Inventory.
- A marketplace customer is mapped to an existing customer in Zoho Inventory by matching their email address. If email address is not available, they are matched based on customer name.
- VAT Treatment for the customer will be set based on the taxing region provided by amazon in every tax applied order. The following are the applicable VAT treatments:
- Taxing Region is UK: United Kingdom VAT
- Taxing Region is among the EU countries and VAT Registration Numer is present: EU - VAT Registered
- Taxing Region is among the EU countries and VAT Registration Numer is NOT present: EU - Non VAT Registered
- Taxing Region is NOT one among EU countries: Non - European Union
- When stock syncing is active, stock update gets triggered whenever the stock level of the marketplace item changes in Zoho Inventory.
- If you have disabled automatic sync, then the stock will no longer be updated to your marketplace.
- When shipments are created for your amazon orders in Zoho Inventory, the shipping information gets updated to your amazon account automatically.
- The payment status of an inbound order from amazon can be found as a comment under the sales order.
- As amazon supports only paid orders, the payment status would be indicated as Paid.
Fulfilment by Amazon
Fulfilment by Amazon (FBA) facilitates sellers to rent Amazon’s storage space to keep their goods, while also fulfiling online orders and handling customer services.
How FBA works
- The seller ships his goods to Amazon’s storage facility where they sort and store the products.
- When a customer orders an item, Amazon picks and packs it from their nearest warehouse.
- They ship the packages and share the tracking information with the seller.
- Post delivery, Amazon handles customer feedbacks and services.
- On a biweekly basis, Amazon deposits the seller’s share of profit in their bank account after deduction.
Advantages of using FBA:
- Access to unlimited storage space.
- Your products will be showcased to Prime customers.
- You only have to pay the holding cost and shipping fees.
Setting up FBA in Zoho Inventory
In Zoho Inventory, you can designate a warehouse to track your FBA goods and orders.
Note: The FBA tracking and warehouse mapping are mutually exclusive features i.e., at a given time, you can enable only one of them.
To designate an FBA warehouse:
Go to Settings, then Integrations.
If you’ve already integrated with Amazon, click Set FBA Warehouse. Otherwise, you can set up FBA during integration.
In the pop-up, select the warehouse and click Confirm.
Note: Cross-border feature is not supported as of yet, i.e., your business location in Zoho Inventory must be set as U.S.A in order to enable FBA for your organisation.
Marking FBA Items
Products that are handled by Amazon can be marked as FBA items in Zoho Inventory. Also, ensure that you have actively listed them on Amazon.
To mark FBA item:
Go to the Items module on the left sidebar.
Select the items you want to mark as as FBA.
Click on the Bulk Actions button at the top.
Select Mark as FBA Item option from the drop-down.
- Go to the Items module on the left sidebar.
- Open the item you want to mark as as FBA.
- Click on More and select Mark as FBA Item from the drop-down.
If you no longer want the item to be FBA tracked, follow the steps above and select Mark as MFN item from the drop-down.
Link FBA and MFN items
Some sellers project one item as several items on amazon(Amazon fulfilled and seller fulfilled). If you are one of those sellers, then you can link multiple FBA and MFN items to a single Zoho Inventory item. This not only helps maintain a master stock for multiple online items but also allows you to dispatch shipment from the nearest warehouse while cutting down on the FBA processing charges.
To link an FBA/MFN item to a Zoho Inventory item:
- Go to the Zoho Inventory Dashboard.
- Under the Product Details section click on Unconfirmed Items.
- Click on an amazon item to view its details.
- Click the Link to existing item button in the item details page.
- Select an item in Zoho Inventory to which you want to link this sales channel item.
- Click Merge.
When you mark an item as FBA, its current stock in Amazon gets fetched into Zoho Inventory. If there is a mismatch, you can record the difference as an adjustment.
To view the FBA stock for an item,
Go to Items in the left sidebar
Click on the FBA item to view its details.
Go to the Associated Sales Channels section.
Click the sync icon next to Stock Details to fetch the current stock from Amazon. If there is a difference in stock between the two platforms, it’s indicated as Mismatch.
Click on Mismatch to drill-down the details.
Click Adjust Stock to update the stock difference in your FBA warehouse.
An Inbound Shipment is Amazon’s term for sending your items from your warehouse to an Amazon Fulfillment Center, where it will be stored and delivered to your customer by Amazon.
When a customer places an order for an FBA item on Amazon, it gets recorded as a force-fulfilled order in Zoho Inventory. You will not be able to edit the order or change its shipping status, since it is shipped and tracked by Amazon.
If you sell an FBA item offline or on other marketplaces, you must create an outbound shipment for that item.
Scenario: Mark runs a handicraft business which he sells offline, as well as on Amazon. He cannot afford a warehouse or hire workforce, so he avails the FBA service from Amazon. In Zoho Inventory, he adds a warehouse to track his FBA stock and orders. Whenever he receives an offline quote, he records a sales order with the FBA item and creates an outbound shipment. Amazon ships the consignment from their warehouse and periodically updates the status of the order in Zoho Inventory.
To create an outbound shipment:
- Log in to your Zoho Inventory organisation.
- Open the sales order with the FBA item.
- Click Create, then click Outbound Shipment from the drop-down.
- A fulfilment request is sent to Amazon for the FBA items in the order.
- Amazon picks, packs and ships the consignments and updates the shipping status in Zoho Inventory. You can also fetch the status manually.
The non-FBA items in the order must be shipped separately by you.
Change FBA Warehouse
To change your FBA warehouse in Zoho Inventory:
Go to Integrations, then Marketplaces.
Click the Show Details option under Amazon.
Scroll down to the Stock Syncing section.
Click Change and select the new warehouse under which you want to track your FBA goods and orders.
To disable FBA in Zoho Inventory:
Go to Integrations in the left sidebar, then Marketplaces.
Under Amazon, click Disable FBA
You will no longer be able to track your FBA items or create outbound shipments in Zoho Inventory.
After setting up the integration, orders from Amazon UK are tracked in the primary warehouse and stock updates take place in the organisation level. You can designate a warehouse specifically to track orders and update stock to this sales channel.
Prerequisite: Make sure to enable the Multi-warehouse feature in Zoho Inventory before proceeding.
To map a warehouse:
Log in to Zoho Inventory.
Go to Settings, Integrations, then Marketplaces.
Under amazon.co.uk, and click the Show Details button next to your store name.
Go to Modules in Sync.
Click the Enable button under Choose a warehouse to track your orders and stock updates from Amazon UK text.
In the following pop-up, choose a warehouse to associate with your Amazon UK marketplace.
All stock updates and orders received henceforth from this sales channel will be tracked under this warehouse.
- To change your warehouse selection, click on the pencil icon near the warehouse name and select another warehouse.
- To disable warehouse mapping for this sales channel, click Disable. On doing so, your orders from this sales channel will go back to being tracked in the primary warehouse, and the stock available on the organisation level will be updated to the marketplace.
To modify your sync preferences for this marketplace integration:
Go to Settings, Integrations, then Marketplaces.
Click the Show Details button under amazon.co.uk.
By default, automated sync is set to take place between Zoho Inventory and the sales channel every four hours.
To modify the sync cycle, click Change and choose a preferred sync interval from the drop-down.
The sync history page logs every sync that takes place between Zoho Inventory and the sales channel. The details include, date and time of sync, sync type, and number of records synced. To view the complete sync history of a sales channel:
Click the Overall Sync History option near the Modules in Sync section.
Click on the records to view the details of items or orders that were fetched in the particular sync.
Click the Resync button against a task to re-initiate a sync for it. All items and orders that were synced or failed to sync first time will be fetched again from the marketplace.
Insight: The successful sync records older than a month and sync failures older than two months gets deleted automatically. You’ll only be able to view the history but not the details of the sync.
Manual Sync - Items & Orders
You can initiate an instant sync between Zoho Inventory and the sales channel at any time by clicking the Sync Manually button for Items and Orders. Be aware that initiating a sync in one channel will trigger a sync in other sales channels as well.
The arrow indicates the direction of sync. Items and orders are fetched into Zoho Inventory from the sales channel, and stock update is pushed to the sales channel from Zoho Inventory.
To set your order sync preferences, click the pencil icon near Orders to be synced and select your sync preferences from the drop-down. You can choose to fetch either Confirmed orders or Confirmed and Fulfilled orders from your sales channel.
Insight: Your order sync preferences will be applied across all integrated sales channels.
If you no longer want to fetch items and orders from Amazon UK, you can disable the integration. To do so:
Navigate to Settings, Integrations, then Marketplaces.
Click on the Show Details button under amazon.co.uk.
Click the Disable Integration button at the top-right corner.
Confirm your action.
- On disabling the integration, your Amazon integration will be moved to the Inactive state.
- To reactivate the integration, follow step 1 and 2, and click Enable Integration on the top-right corner.
Amazon’s Data Protection Policy dictates strict standards to protect sensitive information from known or reasonably anticipated threats or hazards to its security and integrity, accidental loss, alteration, disclosure, and all other unlawful forms of processing. We at Zoho Inventory have implemented the following changes to protect customer data:
- Orders synced from Amazon will be associated with a default customer name (Amazon UK - Customer). The actual customer information obtained from Amazon will be concealed at application sections where contact information is displayed and revealed only on demand.
- The PII (Personally Identifiable Information) of customers will be deleted 30 days post fulfilment. This applies to void orders as well.
- When an unfulfilled order is fulfilled again, the PII expiration time will be reset as per the new date of fulfillment.
- Cases where PII sharing has been restricted:
- While cloning customers or sales orders synced from Amazon, PII will not be carried forward.
- Export files, Sales Order PDFs and existing GET APIs of sales order, package and shipments will not contain PII. However, contact information will be displayed on PDFs of package slips and shipment slips for fulfillment purposes.
- PII will not be shared with integrated applications except shipping carriers for shipment creation purposes.
- The above changes take effect only on the orders synced post implementation of the new security standards. Existing orders will remain unaffected.