Amazon CSV import--original orders and new [Amazon Orders] offsets don't match

[Mark.S]

Maybe you are seeing Amazon CSV Import Exceptions?

@randy

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?

@randy

Here is an instructive example: