Update on Importing Amazon Orders into Google Sheets (May 2023)

[brittany.sciolla]

Hi there! I’m not sure if I’m in the right place or on the most recent thread but I’m wondering if someone has a step-by-step guide to integrate your Amazon CSV files into the Tiller foundation template or can direct me to a more detailed breakdown of how to do it.

[twalane]

@brittany.sciolla this blog entry was updated for 2025. Leads back to Import CSV Line Items documentation which is pretty thorough with FAQs and so on. Hope that helps!

[samcha]

The export I received from Amazon today is in a new format. The new format provides an Order History.csv that is largely the same as the old Retail.OrderHistory.1.csv file, but with some columns renames.

I was able to import it using the existing importer by generating an “old style” csv using the Miller tool:

mlr --csv rename “Original Quantity,Quantity”,“Payment Method Type,Payment Instrument Type”,“Gift Recipient Contact,Gift Recipient Contact Details”,“Total Amount,Total Owed” then cut -o -f Website,“Order ID”,“Order Date”,“Purchase Order Number”,Currency,“Unit Price”,“Unit Price Tax”,“Shipping Charge”,“Total Discounts”,“Total Owed”,“Shipment Item Subtotal”,“Shipment Item Subtotal Tax”,ASIN,“Product Condition”,Quantity,“Payment Instrument Type”,“Order Status”,“Shipment Status”,“Ship Date”,“Shipping Option”,“Shipping Address”,“Billing Address”,“Carrier Name & Tracking Number”,“Product Name”,“Gift Message”,“Gift Sender Name”,“Gift Recipient Contact Details”,“Item Serial Number” orders_new.csv > orders_old.csv

You could also do this manually:

Converting Amazon order export from new format to old format

1. Open the new format CSV

2. Delete the Column 1 and Column 2 columns

3. Rename these columns:

   • Original Quantity → Quantity

   • Payment Method Type → Payment Instrument Type

   • Gift Recipient Contact → Gift Recipient Contact Details

   • Total Amount → Total Owed

4. Reorder columns to this sequence:

   • Website

   • Order ID

   • Order Date

   • Purchase Order Number

   • Currency

   • Unit Price

   • Unit Price Tax

   • Shipping Charge

   • Total Discounts

   • Total Owed

   • Shipment Item Subtotal

   • Shipment Item Subtotal Tax

   • ASIN

   • Product Condition

   • Quantity

   • Payment Instrument Type

   • Order Status

   • Shipment Status

   • Ship Date

   • Shipping Option

   • Shipping Address

   • Billing Address

   • Carrier Name & Tracking Number

   • Product Name

   • Gift Message

   • Gift Sender Name

   • Gift Recipient Contact Details

   • Item Serial Number

NOTE: I found it helpful to delete transactions not related to the dates I wanted, and to delete the whole foods/panda01 transactions before importing.

Hopefully @randy and team can get the tool updated soon.

[daveahlers]

I have been informed the tool is no longer being updated. I created my own import tool here: GitHub - daveinlosbarriles/TillerAmazonOrdersCSVImport · GitHub.

[pwstamps]

Thank you for your response. I will try it by the end of the week. Thank you for creating this tool! Pierre

[pwstamps]

Hello Randy,

Thank you for the post of May 2023. Unfortunately, I am not sure that I understand how you suggest to fix the problem. I am 71 years old and not very computer savy!

Yes is unfortunate that the Tiller sidebar is no longer working. I get the error message (see screenshot in my original question). “The Importer does not recognize the uploaded file”. Would a simple tweak each time I run the solution work? Could it be as simple as mapping change, which, if I understand correctly, would be to change the column name in the Order History.csv file I got from Amazon. I look forward to hearing from you. Thank you! Pierre

PS: I am keeping my file Order History.csv on my Desktop and cannot attach it to this message

[lava890]

Thanks for the write up. When I try your command, mlr gives an error about the "tracking number” which must have something to do with the ampersand.

[samcha]

Hi, it looks like the forum software converted the straight quotes to curly quotes. You can copy the command from here:

https://gist.githubusercontent.com/sbc/d8236be0c56bc2990f29a9292bade192/raw/099de18eeb88d1f86d382e8a110741465a642c26/convert_amzn_order_history.txt

[randy]

Hey @samcha! Thanks for the details. As @daveahlers mentioned, we have not been able to maintain this with all the product-focused work we are doing. I can’t commit to fixing the column mappings— especially for the next couple of weeks— but I will see if there is an opportunity to slot it in a little further out. It would really help me if you could DM me a few rows of the CSV. I realize there will be some PII in the purchase history, but if you can give provide a CSV file with an intact header row and ~2 rows of innocuous product lines that will speed things along and provide fodder for testing. Thanks.

[lava890]

That worked. Thank you!

[daveahlers]

My updated tool is now live on Google Marketplace here: https://workspace.google.com/marketplace/app/tiller_tools_by_dave/135351721412

Detailed documentation here: TillerTools/README.md at master · daveinlosbarriles/TillerTools · GitHub

[randy]

Congratulations on making it through that process, @daveahlers! Excited for your new tool!

[Mark.S]

I also confirmed Tiller Tools by Dave is visible via searching the Google Marketplace for Tiller: