QuickBooks HelpQuickBooksHelpIntuit

Set up Amazon or Amazon FBA SKU Aliases

SOLVEDby QuickBooksUpdated November 16, 2022

Learn how to set up Amazon or Amazon FBA SKU Aliases in QuickBooks Commerce. 

If you sell on multiple sales channels, your products’ SKUs may differ. An SKU Alias lets you centralize your inventory by linking different SKUs to a single parent SKU in QuickBooks Commerce. Here’s how to create one.

QuickBooks Commerce is no longer available for purchase as a stand-alone product.
The features referred to in this article are only relevant for customers who still have QuickBooks Commerce bundled with their QuickBooks Online subscription.
If you want to learn more about e-commerce accounting features that are part of QuickBooks Online, check out Accounting for e-commerce FAQ.

Learn about SKU Aliases 

When you install a new Amazon or Amazon FBA channel in QuickBooks, you might already have your products and created their SKUs. So, your SKUs in QuickBooks might not match with your SKUs in Amazon or Amazon FBA, especially if Amazon created unique SKUs.

If you sell a product with different SKUs in multiple sales channels, you can add an SKU Alias to it. It links the product with different SKUs to the same product in QuickBooks so you can have accurate stock levels and sales.

Set up an SKU Alias

Here’s how to set up an SKU Alias depending if you already installed Amazon or not.

Important:  

  • For Amazon FBA, SKU Alias and ASIN should match each Amazon channel (MFN and FBA). You should not use the ASIN as the SKU Alias. The SKU Alias you entered on QuickBooks Commerce should be the SKU of the product in Amazon for either MFN or FBA. 

When you connect your Amazon or Amazon FBA channel, QuickBooks automatically detects SKU differences between your Amazon listings and current QuickBooks Commerce inventory.

Step 1: Install Amazon and download your product sheet

To edit your SKU Aliases in bulk, download your product sheet.

  1. Install Amazon in QuickBooks Commerce.
  2. Select Download a list of your QuickBooks Commerce products, then open the CSV file. 
  3. In your Amazon or Amazon FBA channel column, enter TRUE next to the SKU of the product you want to link.
  4. In the SKU Alias column, enter the SKU Alias.
    AMZID_QBC_US_091119.PNG
  5. Save as a CSV file.

Step 2: Upload your product sheet   

To update your SKU Aliases in QuickBooks Commerce, upload your product sheet. 

  1. Go to Inventory, then select Products.   
  2. Select the Bulk Manage ▼  dropdown, then select Update Existing Products or Import New Products.   
  3. Select Yes, I have a spreadsheet with updated product data ready to upload.
  4. In QuickBooks, select Upload Filled CSV.
  5. Select browse for a file and select the CSV file you updated, then Select Open.
  6. Select Continue, then select Yes, this is correct.

If you have your Amazon or Amazon FBA channel already set up in QuickBooks, you just need to update your existing products.  

Step 1: Download your product sheet

To edit your SKU Aliases in bulk, download your product sheet.

  1. Go to Inventory, then select Products
  2. Select the Bulk Manage ▼  dropdown, then select Update Existing Products.
  3. Select No, I need to download a list of my products.
  4. On the Sales Channels ▼ dropdown, select the Amazon or Amazon FBA channel you want to set aliases up for.
  5. Select Build Product Sheet, then Download Product Sheet
  6. In your Amazon or Amazon FBA channel column, enter TRUE next to the SKU of the product you want to link.
  7. In the SKU Alias column, enter the SKU Alias.
    AMZID_QBC_US_091119.PNG
  8. Save as a CSV file.

Step 2: Upload your product sheet  

To update your SKU Aliases in QuickBooks Commerce, upload your product sheet.

  1. In QuickBooks, select Upload Filled CSV.
  2. Select browse for a file and select your product sheet CSV file, then Select Open.
  3. Select Continue, then select Yes, this is correct.

Was this helpful?

You must sign in to vote, reply, or post
QuickBooks Commerce Coreundefined

Sign in for the best experience

Ask questions, get answers, and join our large community of QuickBooks users.

More like this