# Amazon CSV import--original orders and new \[Amazon Orders\] offsets don't match **URL:** \ **Category:** Ask Anything\ **Tags:** amazon, google-sheets, tcs-csv\ **Created:** [February 19, 2024, 8:30am UTC](https://community.tiller.com/t/amazon-csv-import-original-orders-and-new-amazon-orders-offsets-dont-match/24143 "2024-02-19T08:30:37Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![grlwndr](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/grlwndr/32/16385_2.png) [@grlwndr](https://community.tiller.com/u/grlwndr)\ **Post date:** [February 19, 2024, 8:30am UTC](https://community.tiller.com/t/amazon-csv-import-original-orders-and-new-amazon-orders-offsets-dont-match/24143/1 "2024-02-19T08:30:37Z")
I am newbie to Tiller but am loving the flexibility and features so far. We do a fair amount of purchasing through Amazon, so was really excited about the Amazon/CSV Line Item Importer, but I’m struggling to make it work. The tool _seems_ to work–I imported several months of Amazon data and it generated the new [Amazon Order] and [Amazon Item] line, the former are correctly categorized as “Amazon” and the latter, I manually categorized. When I go through my new updated transactions sheet, I can still find (by filtering) the original order line items, which also are categorized as Amazon. Here’s the problem: the original order line items and the new [Amazon Order] line items don’t seem to match. I know from reading here that there’s an issue with not having matching dates. I can live with that. But the entries don’t seem to fully match up either. Shouldn’t I have one [Amazon Order] entry for every original order line item? And shouldn’t the amounts match, or be close? My entries are way off. I have: 31 original order line items, but I have 57 [Amazon Order] entries! And they don’t appear to be duplicates (at least as far as I can tell from reviewing the Descriptions and the amounts). Also, shouldn’t the amounts add up to the same number? Well, the new [Amazon Order] line items add up to more than 3x the original order lines. The [Amazon Order] rows and the [Amazon Item] rows do seem to add up, however. Any thoughts on what I’m doing wrong and how to fix it? I’m close to throwing in the towel and just reverting back to my pre-CSV Import Tool sheet–thankfully I saved a back up. If I can’t get it to work, anyone know the best way to revert back to my back-up sheet to avoid breaking any links/scripts/etc? I created the back up file using the File\>Make A Copy function and saved it in a different Tiller Back Up folder. Thanks in advance! ---
**Author:** ![Mark.S](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/mark.s/32/14650_2.png) [@Mark.S](https://community.tiller.com/u/Mark.S)\ **Post date:** [February 19, 2024, 4:24pm UTC](https://community.tiller.com/t/amazon-csv-import-original-orders-and-new-amazon-orders-offsets-dont-match/24143/2 "2024-02-19T16:24:07Z")
Maybe you are seeing [Amazon CSV Import Exceptions](https://community.tiller.com/t/docs-import-csv-line-items/2512#amazon-csv-import-exceptions-14)? > [@Docs: Import CSV Line Items](https://community.tiller.com/t/docs-import-csv-line-items/2512/1): > > ## Gift Cards > > _When you check out an Amazon purchase, you can apply Amazon gift cards which lowers the amount (if any) that is charged to your credit card, but the item report will still list the transaction for the full amount prior to applying the gift card. example: order $25 item, apply $10 gift card, credit card is charged 15. there is no way to see this in the items report CSV. If you download the orders & shipments report, in the Payment Instrument Column, it will list IF a gift card was used, but there is no way I have seen yet to determine how much was provided by the gift card. So the only automation here would be to ingest the orders CSV and throw a flag to trigger a manual adjustment if it detects a gift card._ > > ## Shipping Costs > > _If you don’t have Prime, or you have Prime and order something from a vendor who charges shipping on Amazon, you are charged a shipping charge. This is visible in the orders CSV in the “shipping charge” column, but not in the items CSV. You’d have to import both files and then correlate the charges. Or document/flag it as something that needs a manual adjustment._ > > ## Grocery Delivery Charges > > _While every single item from a grocery delivery order is listed in the item report, they delivery fee/tip is not. But it shows up as an Amazon Grocery charge on your credit card. Again, only manual adjustments possible here._ Here’s an example of what it should look like. Do you have a screenshot of an example you don’t think is working properly? > [@Docs: Import CSV Line Items](https://community.tiller.com/t/docs-import-csv-line-items/2512/1): > > Here is an instructive example: > > ![190718_AmazonLineItem_Transactions_6](https://us1.discourse-cdn.com/flex020/uploads/tillermoney/original/1X/c1890671871f3f56ac02a0bc856267b089266db6.jpeg) ---
**Author:** ![grlwndr](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/grlwndr/32/16385_2.png) [@grlwndr](https://community.tiller.com/u/grlwndr)\ **Post date:** [February 19, 2024, 5:43pm UTC](https://community.tiller.com/t/amazon-csv-import-original-orders-and-new-amazon-orders-offsets-dont-match/24143/3 "2024-02-19T17:43:11Z")
Thanks, but unfortunately none of these exceptions account for the problem I’m seeing. We are prime members, and we don’t generally use Amazon grocery delivery or gift cards. So, while there might be a small handful (maybe 1 or 2 entries) where I will need to manually adjust for these exceptions, that doesn’t account for the scope of the problem. Any other ideas? ---
**Author:** ![Mark.S](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/mark.s/32/14650_2.png) [@Mark.S](https://community.tiller.com/u/Mark.S)\ **Post date:** [February 19, 2024, 5:47pm UTC](https://community.tiller.com/t/amazon-csv-import-original-orders-and-new-amazon-orders-offsets-dont-match/24143/4 "2024-02-19T17:47:23Z")
I think I’d need an example screenshot of what you’re seeing to understand it better. ---
**Author:** ![Mark.S](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/mark.s/32/14650_2.png) [@Mark.S](https://community.tiller.com/u/Mark.S)\ **Post date:** [February 19, 2024, 6:26pm UTC](https://community.tiller.com/t/amazon-csv-import-original-orders-and-new-amazon-orders-offsets-dont-match/24143/5 "2024-02-19T18:26:34Z")
One other suggestion is to look at one of them and compare it to the Amazon invoice details to see what’s different.