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

News from Tiller
, ,
84

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.

1 Like