Amazon Sales Tax 101

How to Change Your Product Tax Codes in Amazon

by Guest Post

Product Tax Codes Amazon

This guest post was originally written by Georgene S. Harkness, C.P.A., who has worked in the tax industry for more than 20 years. This post is specifically about how to quickly change your Product Tax Codes in Amazon. If you have other questions about Amazon Product Tax codes, read our Amazon Product Tax Codes FAQThanks to Karen Holmes who helped us update this post for 2018 due to changes in Amazon Seller Central.

If you’re an Amazon seller like me, you may have a thousand (or more) different SKUs and the very idea of opening and updating each one is daunting. So, as promised in Part 1 of this short series for Amazon Sellers, here’s my post about a way to update your Product Tax Codes in Amazon without manually opening each one in Manage | Inventory

The following process is a much easier and quicker way to update your Product Tax Codes all in a batch. However, let me caution you to do a test run of no more than 10-15 SKUs before you add all your Product Tax Codes, to make sure you are getting the changes you want and that the process works correctly.

Note: This procedure is for PCs.  I can’t make any promises that it will work correctly with a Mac.

First, in your Seller Central account, go to Inventory | Add Products via Upload.

Amazon Product Tax Codes

Choose the Download Template button under “download inventory file templates.”

Amazon Upload product tax codes in Seller Central

Scroll all the way down past Step 1 and 2 until you get to Inventory Files.

Amazon product tax codes Inventory Files

You can choose Inventory Loader or Listing Loader to add Product Tax Codes. This feature is only available to Professional Selling Plans

You can also watch this video tutorial, which mentions Product Tax Codes at 5:15. Take note – it’s important to watch until the end of the video, because if you do not follow all instructions then shipping may revert back to default settings. (Must be logged into Amazon Seller Central to watch the video).

Clicking on the Inventory Loader Template link automatically downloads the template.

InventoryLoader Template Amazon Seller Central

Now go back to Seller Central > Inventory > Inventory Reports.

Amazon Seller Central Customize Inventory Report

There are options for customizing reports now. You will want the minimum number of columns.

Amazon custom inventory reports

From here, you can either click Group TaxCode or Add ProductTaxCode from  bottom of list to right hand side.

Select these attributes:

Customize inventory reports in Amazon Seller Central

Click Save.

Now go back (hit the back arrow) and Request Report.  It downloads as a Text File. Go to Edit > Select All > Save in Excel – copy and paste.

You’ll notice it says “Inventory Report (Custom).” Wait until it is ready for Download.

Go back to the Inventory Loader template you downloaded. Enable editing.   It tells you the required fields.

From the custom inventory file you downloaded you can fill out the first 2 columns.

Look at Data Definitions on the bottom to understand this report.  A SKU is required, and a product-id (such as ASIN) is desired.

 Scroll to product-tax-code column (could be Column O) to fill in appropriate tax code. If in doubt refer to the Product Tax Codes on Amazon.

Make sure handling time doesn’t need to be reentered if you have changed it from the default, as it says in the above video. Check with Amazon.

Next, Save as Text (tab delimited).

When this is complete, go back to Seller Central, Inventory> Add Products via Upload

Step 1 is Check your file.  Click “Choose file” to search for the saved text delimited file. Click “Check my File.”

You may need to refresh and wait until Actions Is completed.  You can select to be emailed when this  is done.

Once you have your file, download and check your file. If there are any errors, open it up and see the explanations via the bottom tabs.

When all the errors are checked and rechecked, go to Step 2, Upload file.

It may take a short while for all the Product Tax Codes to populate, but from there you should be good to go.

If you have any questions or feedback, let me know in the comment section below.

For more from Georgene at the TaxJar blog, see Amazon Tax Codes: How to Code Your SKUs for Sales Tax in Amazon.

For more from Karen, check out her excellent Amazon tutorials at KarenBrit.com.

  • imkens

    Hello Georgene, Great article. Thank you. One question, when we upload the Inventory Uploader file do we need to have a single completed worksheet as I noticed the original download has three tabs/worksheets.

    • Georgene6767

      Hi, thanks for your comment! Actually what happens is that the original worksheet does have several tabs. But when you save it as a .txt file, per the instructions, it ONLY saves the sheet you are on! So, be sure you are on the tab where the actual data exists (not on the instructions, data definitions, or any other tab), save as a .txt file and only that sheet will be saved.

      When you save, Excel will give you a few warnings, but just say Yes you do want to save it as a .txt (be sure to select the format of .txt in the dropdown when you are saving). Name it something that you will recognize and save it to a location that you will remember. Select the .txt file when you are ready to upload, and ONLY the page that has data will be sent (and that is what you want).

      Good luck!

  • Holly

    Great, clear article. However, I’ve tried to do a test file twice, and I don’t see any change in the listings to show that the upload was successful. I am baffled and must be overlooking something. I am an experienced Excel as well as database user, but this admittedly is my first attempt to tackle anything related to editing and/or listing via Amazon upload. Thus, I very clearly understood (at least I thought I did) your instructions and the logical process from beginning to end. I must be missing something very obvious here and hope you can point me in the right direction.

    • Georgene6767

      So, question, Holly. Can you choose just one item that you think isn’t too likely to sell right away, and change the product tax code to something really ridiculous? And, you probably already know this already, but sometimes it takes up to about an hour for changes to appear. So, try the ridiculous category change and see what happens, OK? And then let us know…

  • Holly

    Yes, change made and it “took.”

  • Kenton

    Thank you for making this guide. It was extremely helpful. I would like to mention that if you do add the product descriptions to the inventory loader document to help you assign the right tax codes, you have to remove them before saving and uploading the file. I did not do this the first time and got an error on every item. After removing the product descriptions it worked perfectly. Thanks again!

  • Holly

    Thank you so much, Kenton. That was exactly it. As soon as I removed the product descriptions, the file went thru fine.

  • Kenton

    Awesome! Glad to hear.

  • Brianna Moller Greene

    Excellent guide! I followed it step by step using a Mac and it worked perfectly. Thank you!

  • Could you possibly update it with the new version of “add products via Upload” . They have completely redesigned the procedure. I couldn’t find any of the info with the new version … thank you

  • Hi Arin,

    I consulted wit the author of this post and we’re still seeing this as the same process. She said to make sure that you’re a Pro Seller and to make sure you’re choosing the template “Inventory Loader.” I’m sorry we couldn’t be of more help. Let me know if it works or if you’re still having trouble and we’ll dig in more!

  • Pingback: Amazon Tax Codes: How to Code Your SKUs for Sales Tax in Amazon()

  • Pingback: How Not to Over or Under Collect Sales Tax for Amazon Prime Day()

  • Pingback: Sales Tax By State: Are Grocery Items Taxable?()

Start your 30 day free trial of TaxJar. No credit card required.