Read first: Understanding how QuickBooks Commerce syncs data with your Amazon store
Read next: Module 4: Importing and Creating Relationships
QuickBooks Commerce integration with Amazon makes it easier than ever to manage your product prices, inventory and automate the fulfillment of your orders from Amazon. Once integrated, you’ll be able to:
- Link products in QuickBooks Commerce with your existing Amazon products by shared SKUs
- Easily optimise revenue from Amazon sales using QuickBooks Commerce Intelligence
- Fulfill Amazon orders directly from QuickBooks Commerce
Before you import your products from Amazon into QuickBooks Commerce, please ensure that you understand Initial Costs - they should be set up promptly as a part of the import process. If you do not update your Initial Costs upon import and transactions take place, your Moving Average Cost (MAC) and profit margin data will be inaccurate.
Because this is the first time you’ll be creating products in QuickBooks Commerce, the installation steps are as follows:
- Prep work within your Amazon store
- Installing your Amazon store on QuickBooks Commerce
- Reviewing and testing your integration settings
Step 1 of 3: Prep work within your Amazon store
Here we’ll cover:
- Reviewing your product SKUs in Amazon
- (Optional) Reviewing existing installed apps in Amazon
- Authorizing API Access for QuickBooks Commerce
Reviewing your Product SKUs in Amazon
QuickBooks Commerce uses SKUs to identify and link inventory between Amazon and QuickBooks Commerce in order to facilitate inventory updates and streamline order management.
Before proceeding to the next step, go into your Amazon account, and ensure that each product and variant have unique SKUs.
Learn about SKUs and why you need to start using them today (click here).
If you have multiple listings for the same product/variant, this is against Amazon’s terms of service. As a result QuickBooks Commerce will not be able to centralize your inventory listing(s) for these products. If this applies to you and you need assistance, please contact Support by submitting a ticket here.
(Optional) Reviewing your Existing Installed Apps
If you are using any multi-currency plugins or product bundle plugins for your Amazon store, let Support know by submitting a ticket here so we can advise you on the best setup approach.
One of QuickBooks Commerce’s main benefits is to provide your business with centralized inventory control and automation.
If you are currently using any apps or integrations that update your inventory levels, we recommend that you uninstall them prior to integrating QuickBooks Commerce and Amazon.
If you’re having trouble uninstalling them for whatever reason, contact Support by submitting a ticket here.
Authorizing API Access for QuickBooks Commerce
Login to the Amazon developer website for your country to access Amazon Marketplace Web Services (Amazon MWS). Learn more about Amazon MWS.
- Amazon US https://developer.amazonservices.com
- Amazon CA https://developer.amazonservices.ca
- Amazon MX https://developer.amazonservices.com.mx
- Amazon UK https://developer.amazonservices.co.uk
- Amazon IT https://developer.amazonservices.it
- Amazon DE https://developer.amazonservices.de
- Amazon FR https://developer.amazonservices.fr
- Amazon ES https://developer.amazonservices.es
- Amazon AU https://developer.amazonservices.com.au
Sign in to MWS.
To authorize QuickBooks Commerce to access your store’s API, select the following option:
“I want to give a developer access to my Amazon seller account with MWS.”
Enter the following values in the corresponding fields:
AMAZON US, CA, MX
Developer Name: QuickBooks Commerce
Developer Account No: 7950-6528-3889
AMAZON UK, IT, DE, ES, FR
Developer Name: QuickBooks Commerce
Developer Account No: 6146-4536-6656
Developer Name: QuickBooks Commerce
Developer Account No: 4302-6550-8529
Click on “Next.”
Review and accept the terms & conditions, then click the “Next” button.
Save your Merchant ID, Marketplace ID and MWS Authorisation Token - you’ll need this for the next step.
Step 2 of 3: Installing your Amazon store on QuickBooks Commerce
Here we’ll cover:
- Connecting your Amazon store
- Location Mapping
- Price List Sync
- Initial Product Import
- Review what will happen next
Connecting your Amazon Store
Go into your QuickBooks Commerce account.
Go to the App Store by clicking Browse Apps on the left side bar.
Click Marketplaces from the menu, then click the Amazon button.
Click the “Install App” button.
Please follow the step-by-step instructions provided in the setup wizard.
Make sure you select the correct country for your Amazon store.
Let’s set up your fulfillment and inventory locations in QuickBooks Commerce.
In Amazon, orders could be fulfilled in 2 ways:
- Amazon MFN: Orders fulfilled by merchants fulfilment networks
- Amazon AFN: Orders fulfilled by Amazon fulfilment networks for example, Fulfilment by Amazon
For each location in Amazon, we’ll create an equivalent location in QuickBooks Commerce and specify which fulfilment location in QuickBooks Commerce should take the orders from Amazon MFN or Amazon AFN respectively.
If you created all of your locations when preparing your Settings in the previous module, you’ll be able to map them now.
QuickBooks Commerce will only update stock levels for Amazon AFN products.
Price List Sync
Let’s set up your price lists by either mapping to an existing price list in QuickBooks Commerce or creating a new one now by clicking the “Create New” button.
For each product price list in Amazon, we will create an equivalent price list in QuickBooks Commerce.
When a product price is changed in Amazon or QuickBooks Commerce, we will update the latest price information to the mapped price list.
Initial Product Import
From within the QuickBooks Commerce installation wizard, choose how you would like you product information to be imported from Amazon to QuickBooks Commerce.
What it does
Import Products Now
If selected, only during installation QuickBooks Commerce will import products from Amazon as new products in QuickBooks Commerce.
After installation, if you create a new product in Amazon, QuickBooks Commerce will not import the product as new product.
QuickBooks Commerce customers select this option when they have not set up any products in QuickBooks Commerce during their trial.
Import Products Later
If selected, during installation QuickBooks Commerce will not import or match any products from Amazon.
After installation, if merchant creates a new product in Amazon, QuickBooks Commerce will not import the product as new product.
QuickBooks Commerce’s customers select this option when they have already created some or all of their products in QuickBooks Commerce prior to the installation process.
Some customers also prefer this option if they have existing products within Amazon that they don’t want to bring over to QuickBooks Commerce.
Review What Will Happen Next
When you complete the installation, depending on the sync options selected, QuickBooks Commerce will begin to:
- Import your products from Amazon into QuickBooks Commerce
- Import future orders based on status mapping from Amazon into QuickBooks Commerce
- For MFN products: QuickBooks Commerce will now be the master of your MFN products. QuickBooks Commerce will update product inventory and prices in your Amazon store. QuickBooks Commerce will update your Amazon MFN products whenever there are changes in stock levels and prices.
- For AFN products: QuickBooks Commerce will only import orders from Amazon. QuickBooks Commerce won’t update product inventory for AFN products, only product prices.
If your store has a large number of products (>10,000 variants), it may take between 3-6 hours for the import process to complete. Do not change any settings until the import process has completed - you will receive an email when the import is complete.
Step 3 of 3: Reviewing & Testing your Integration Settings
Once your installation and import have completed, you’ll want to review and test the integration.
Reviewing your Orders
To see any unfulfilled orders that were imported into QuickBooks Commerce, click here: https://go.tradegecko.com/orders
To see if there are any orders that were not imported successfully, go to the My Apps section and click on your Amazon store and click the Orders Listing tab. Support can help you fix this issue if you submit a ticket here.
(Optional) Updating a product’s price
To test the price sync we recommend that you complete this test with a product that is not marked as “available” within your Amazon store because the integration between QuickBooks Commerce and Amazon is now live.
From within QuickBooks Commerce, change the list price of the variant that you would like to test.
To confirm if the price change was successful, go into your Amazon account to review that variant’s “new” price.
(Optional) Creating and linking new products between QuickBooks Commerce and Amazon
After your initial installation, new products need to be created independently in QuickBooks Commerce and Amazon. In order to manage inventory levels and orders, these products should be linked by SKU.
Create a new product in each platform.
When complete, go into QuickBooks Commerce and select the new variant that you’d like to link.
Link the variant.
Continue setting up your QuickBooks Commerce account → Read next: Module 4: Importing and Creating Relationships.