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

It’s really helpful - thank you for discovering this and sharing!

2 Likes

Thanks for making this Randy you rock :rock:

@randy I want to see if I can build something to lookup the amazon ASIN and bring back amazon categories to make it easier to categorize in Tiller. Ideally I would get it to the point of auto mapping the correct Tiller category.

Can you have this import include the ASIN at the end of the Description? Maybe something like:

[Amazon Item] Seventh Generation Dishwasher Detergent Packs for Sparkling Dishes Free & Clear Dishwasher Tabs 45 Count, Pack of 2 (Packaging May Vary) [ASIN: B01FHUJ1FC]

Good question, @al1. We capture the “ISBN” in a JSON object in the Metadata column. Due to some evolving migration issues, the label is a bit of a misnomer. This is actually the ASIN. With a regex formula, you should be able to extract this value for your needs. Will that work?

I see that now… Let me play around with this and see what I can come up with. Thanks!

1 Like

Editing this post to answer my own question.

I downloaded my data from Amazon Privacy Central and uploaded it to Tiller using the import tool, but got the message “Analyzing line items history…” which wouldn’t clear. The solution for me was to edit the CSV to remove all of the entries in the “Discounts” column which have quotation marks that can’t be processed. Once I deleted those items the CSV imported no problem. Posting here in case anyone has the same issue. Thanks again for this workflow!

1 Like

Does this work for returns as well?

Yes it does! It comes it with the exact same description as the purchase description. I’ve toyed with some ideas of what to do with this but haven’t explored them yet. Could be cool to match them up to help track incoming returns!

Does it always show the items individually? Could you possibly show what it looks like on your end with multiple items if they don’t appear individually?

The last time I imported Amazon orders it had each item, including when I went to an Amazon Fresh store.

Oops, my bad. Meant that as a reply to @Caroleen regarding the Synchrony Amazon Store Card!

3 posts were split to a new topic: Line Item CSV Workflow Hanging on Amazon Orders

Randy, I just finished writing a script that gets Amazon transactions out of the notification emails and synchronizes them the Tiller sheet. I’m new to Tiller and wanted to get Amazon purchase details without having to download and import. I want to make it available to the community. In your app, you’ve probably mitigated every possible problem. Would you be wiling to talk briefly to me about mine? Or we could add this functionality to yours. :slight_smile:

1 Like

Hi @DanielTweddell thanks for your post here and letting us know you’ve built a script to help with this. It sounds pretty cool! Randy and our other engineers are heads down on our current dev cycle priorities, but I’ll flag this for our “cool down” period as I think it might be a fun project they’d consider reviewing during that period.