This page covers the procedure for importing orders from your Amazon store, as well as additional details about ship responses and inventory. This is a specific feature only available to clients who have initiated an Amazon integration. Although this guide focuses on manual importing, our Amazon integration can also be set to run automatically on a set schedule.

If you have an Amazon store that you would like to integrate with Orderbot, please contact support@orderbot.com for more details.

  NOTE: This same page is used for Shopify and Big Commerce integrations as well. The filepath and steps are the same, but you will only see the option to click on an integration after you've completed the implementation process and provided your credentials.

This stage merely grabs the orders from Amazon and displays them. This step does not create any orders in Orderbot.

1. Go to: Orders > Third Party Orders > Manage Orders
2. Click the Amazon icon. You must do this step before you can import any orders. If you have multiple integrations available (e.g. Big Commerce or Amazon), clicking this icon will allow you to select which one you would like to import at this time.
3. Select FBA (Fulfilled by Amazon) or FBM (Fulfilled by Merchant), depending on the type of orders you would like to import.
4. Select your Date Range. This is the date range used for pulling orders from Amazon. Don't worry about if this date range overlaps with one you've previously imported orders for: an order can only be imported once.

   The date field searches for a date as of 00:00 or midnight of that day. This means that to search for orders from August 19th, you would search 08/29/2019 to 08/30/2019–that would search for the very beginning of August 29th to the very beginning of August 30th, covering 24 hours.

5. When you're ready, click Get Orders.

   

IMPORTANT - When importing, Amazon orders may only be brought in one page at a time. Click 'next' to jump to the next page. You may encounter a message indicating that you will need to wait a couple minutes before trying again–this is because Amazon prevents sending too many order requests within a short span of time

After the orders have been pulled from Amazon, they'll display as a list. Once you click 'Upload Orders' orders and customers will be created with the same details in the order list.

1. Review orders - Make sure all the order info looks correct. If any data doesn't look right, double check the order in Amazon. You may need to edit your order to correct shipping address information or other fields.

   

2. Click 'Upload Orders' - This imports the orders into Orderbot. This may take a couple minutes, so avoid closing the page until this process is complete.
3. Check Errors - After orders are imported, there will be a message displayed showing which orders were imported successfully, and any that were not able to be imported into Orderbot.

The most common reason for import failure is because of a SKU mismatch between Amazon and Orderbot. The message will indicate which SKU does not exist in Orderbot; you can go to Products > Product Management > Manage Products to add or edit a product so that its SKU matches Amazon.

There is also an additional setting that switches the Amazon integration to use your product UPC instead. This allows you to match to Orderbot even in cases where your Orderbot SKU is not the same as what you are using for Amazon. To enable this feature, please contact your account manager or email support@orderbot.com for more information.

After you import an order from Amazon into Orderbot, you may mark it as fulfilled in Amazon by changing its status in Orderbot to 'Shipped.'

Please note that order fulfillment in Amazon is not immediate. At the time an order is marked as shipped in Orderbot, it enters a queue of orders in Amazon. There may be a delay of up to an hour before Amazon processes the ship response file.

See our guide on changing order status for more information. Regardless of which page you use to change your order status, if your order originated in Amazon, Orderbot will send a response to update its status in Amazon!

After Amazon orders are imported into Orderbot, they'll be assigned a new Orderbot ID. However, you can still search for them using their original ID–this will be imported as a reference ID that is searchable within Orderbot.

1. Find your reference ID: you can see it as the 'Web / Ref ID' when importing your orders.

    Note: When you're viewing your orders during the 'Getting Orders' phase of bringing in your Amazon orders, you can also view previously-imported orders like the one below.

2. Go to Orders > View Orders.
3. Enter your 'Reference Order ID' in the search field.
4. Click 'Submit.'

   

   

If you have had your Amazon integration set up to import automatically on a schedule, you can see your import history by going to Reports > Order Reports > Log Report. Please note that manually-imported orders will not appear in this log.

Filters

• Select an Integration: Display all integrations together or limit your results by a specific integration.
• Select a Date Range: Select range of dates you would like to see.
• Select Status: Filter by status. You can use this to limit your results to errors only, so you can focus on any orders in need of your attention.

Status

• Not Started: This is a process-related message. It's used for orders that have been queued but not yet imported.
• Success: Order imported successfully.
• Error: This message may contain both warnings from Orderbot and Amazon. If an order fails to import for any reason, this is how you will identify both the problem order and the reason for the import failure. If you see an error message you don't understand, please contact support@orderbot.com with a screenshot of this log.
• Note: This status is used for imports that were successful, but which came with a warning or information message that may need your attention.

When Orderbot tries to bring in Orders from Amazon, it's important that your Orderbot settings be completed correctly to accommodate your settings in Amazon. Below are common causes of Amazon import failures, as well as how to resolve them.

• SKU Mismatch - Your product SKUs in Amazon must match your product SKU in Orderbot. If one of your products has a mismatching SKU, or you have any products missing a SKU, your order cannot be imported. Luckily, the solution to this issue is very simple. If you have an order fail due to SKU mismatch, you can simply update your products in Orderbot to match the Amazon SKU.

There is also an additional setting that switches the Amazon integration to use your product UPC instead. This allows you to match to Orderbot even in cases where your Orderbot SKU is not the same as what you are using for Amazon. To enable this feature, please contact your account manager or email support@orderbot.com for more information.

• Ship Methods - When you completed your initial implementation of your Amazon integration, you should already have gone through the process of providing your Amazon ship methods, as well as the Orderbot ship methods you would like to map them to. However, sometimes you may need to add a new Amazon method. If you try to import an order with an unmapped method, you will encounter a message explaining that Orderbot does not recognize your shipping method. If this happens, please contact Orderbot support with the name of your method, as well as the name of the Orderbot method you'd like to map it to. (Often, you will find that the names will already be similar, but for mapping purposes, the name must be exact.)

Keep your Amazon inventory updated from Orderbot to prevent overselling.

At the time that your Amazon orders import into Orderbot, your Amazon inventory will be updated to reflect Orderbot's available inventory for your products.

• Orderbot Available inventory is calculated by subtracting inventory allocated to any To Be Shippedstatus orders from your On-Hand inventory for your warehouse.
• If the Available inventory for your product is greater than zero, the product will be available. If your available inventory falls to zero, the Amazon product will no longer be available.
• Only inventory quantities that have changed since the last time you imported orders will be included in the update.

NOTE: All inventory changes are entered into a queue to be processed in Amazon. Depending on how many changes have entered the queue, it may take up to an hour for your changes to show.

Pre-requisites for using Amazon Inventory Sync

• Your Amazon integration must be set up to import orders on a set schedule.
• Either the SKU or UPC you are using in Orderbot must match your SKU in Amazon. (Please note that if you are saving your Amazon SKU in Orderbot's UPC field, you may need to have an account manager adjust your settings. Please contact support@orderbot.com if you are interested in learning more.)