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

That was probably a huge import, @sdre. You were an Amazon customer since the earliest days.

I built the best-effort import tool to try to avoid reimporting old data. You can try importing the entire file again. There will be a chance to confirm the date range on new transactions before they are inserted into the Transactions sheet— you can confirm that the date range starts in May 2023 at this point. If the de-duplication algorithm isn’t working as expected, you can filter on the start date or manually strip earlier transactions out of the CSV file with a text editor before running the import workflow.

The new Privacy Central CSV includes information on Amazon returns, but I have not yet updated this import mapping. I hope to get to that in the coming weeks.

I’ve got data going back ~20 years as well and it makes the date slider pretty hard to pick just the last month or two. Maybe there is an option to make relative dates — something like last N days?

Are you seeing then that the de-duper is not working, @kraig? My testing is limited to my personal data, but the intent is for it to not reimport line-items.

so far i haven’t had a problem with the deduper, probably just being overly cautious. i’ll let it run for a larger window

My preferred Amazon data hack at the moment is that if you make purchases on an Amazon Store Card (this is the Synchrony card, not the Chase card), the transaction description will load your actual item description straight into the description, no separate Amazon download needed. If you buy multiple items, it will just list them all and not break up the transaction amount, but my workaround there is to place multiple orders for different groupings of items when I would want to separate them (and often they still arrive together in the same box when your orders are placed close together). I still often leave things in my default “Amazon” category, but when they’re big enough or part of categories I’m tracking more closely, I overwrite the AutoCat with a different category. Anyway, just another data workaround for Amazon for those searching and end up overwhelmed with the Amazon data download process.

1 Like

Oh, that’s a great idea! I’ll have to see about getting that card.

To fix your delivery issue: you may have noticed that there is an “Amazon Delivery Day” option on shipping? It’s one day of the week you can choose to have your Amazon packages delivered, and if you choose that on separate orders they’ll try to group the packages together in boxes and orders.

Yes, that’s a great option too! Usually I am emergency ordering diapers or cat food or other things that can’t wait a week, so I usually override that option, but it seems that as long as it’s coming from the same warehouse, even picking the faster shipping options, they do generally pack multiple separate orders into the same box!

It’s a little bit lame but I did my best to update the returns/refunds workflow, @sdre & @sagor.

1 Like

A post was merged into an existing topic: Update on Importing Amazon Returns & Refunds into Google Sheets (May 2023)

Hi Randy - could you clarify how these amazon fresh purchases work? I’m assuming the reason to exclude would be because they are already showing up in someone’s bank account another way - is that correct? What would the description be if it doesn’t come through the bank as “amazon fresh”? Is it the same as whole foods? Just trying to decipher an upload I did for someone else and the totals are WAY off – the amazon upload has tens of thousands more in charges than the bank account shows are for Amazon and I think that these “panda” or amazon fresh charges maybe have something to do with it.