CSV Import Error for "Amazon Business Purchases"

I am getting this error msg when trying to import “Amazon Business Purchases”:

The importer does not recognize the uploaded file. Check that you are uploading a supported file type.

Anyone else getting this error when importing?

Here are the headers in the “Amazon Business Purchases” csv file:

  1. Order Date
  2. Order ID
  3. Account Group
  4. PO Number
  5. Order Quantity
  6. Currency
  7. Order Subtotal
  8. Order Shipping & Handling
  9. Order Promotion
  10. Order Tax
  11. Order Net Total
  12. Order Status
  13. Approver
  14. Account User
  15. Account User Email
  16. Invoice Status
  17. Total Amount
  18. Invoice Due Amount
  19. Invoice Issue Date
  20. Invoice Due Date
  21. Payment Reference ID
  22. Payment Date
  23. Payment Amount
  24. Payment Instrument Type
  25. Payment Identifier
  26. Amazon-Internal Product Category
  27. ASIN
  28. Title
  29. UNSPSC
  30. Segment
  31. Family
  32. Class
  33. Commodity
  34. Brand Code
  35. Brand
  36. Manufacturer
  37. National Stock Number
  38. Item model number
  39. Part number
  40. Product Condition
  41. Company Compliance
  42. Listed PPU
  43. Purchase PPU
  44. Item Quantity
  45. Item Subtotal
  46. Item Shipping & Handling
  47. Item Promotion
  48. Item Tax
  49. Item Net Total
  50. PO Line Item Id
  51. Tax Exemption Applied
  52. Tax Exemption Type
  53. Tax Exemption Opt Out
  54. Discount Program
  55. Pricing Discount applied ($ off)
  56. Pricing Discount applied (% off)
  57. GL Code
  58. Department
  59. Cost Center
  60. Project Code
  61. Location
  62. Custom Field 1
  63. Seller Name
  64. Seller Credentials
  65. Seller City
  66. Seller State
  67. Seller ZipCode

They must have changed the export format again.

I can see at least the following expected headers are no longer present:

  • Shipment Date
  • Carrier Tracking #
  • Shipping Address
  • Product Category (maybe this has become “Amazon-Internal Product Category”?)

I can add this to my to do list for the next week.

Since I don’t have access to a reference CSV, is it possible you can share a sample CSV with just the header and one row of dat, @al1? It is ok if you want to change text fields to anonymize the data just be careful not to change the way the data will be parsed (e.g. deleting a comma).

https://drive.google.com/file/d/1-5cNnsjhWsRW37FbxkAWnc72OT_2WQDa/view?usp=sharing

Here is a link to a CSV with only the headers to use as a reference csv.

Thanks for sharing the headers, @Spence, but these are different than the headers that @al1 provided. Can you each confirm where you downloaded your report from and when? Thanks.

I downloaded mine through the Business Analytics page,Reports section, Orders, Download CSV. This page allows you to select a time period and down load a csv with all of the orders placed during that time period. I downloaded it Jan 18

Can you let us know where (and when) you got the version with the different headers, @al1? I think @Spence is saying that the importer still works for him.

No, I am not saying the importer works. When I download the csv file from the source I show, it fails to load with the message stated earlier.

here ya go… sorry just saw your msg… thanks for helping!
sample file

I downloaded this export from amazon business orders on 1/19/21…

This is the same place I downloaded my orders history file… I did not filter, or if I did, I selected all the columns available.

Sorry, I meant 1/19/22

I can’t download this, @al1. Can you make the share available to anyone?

@randy Here it is: orders_from_20210101_to_20220116_20220117_1251-sample.csv - Google Drive

Thanks, @al1. I can see from your CSV that the following columns were in the CSV that the rules were built from but are not in your version of the CSV:

  • Shipment Date
  • Shipment Status
  • Carrier Tracking #
  • Shipment Quantity
  • Shipping Address
  • Shipment Subtotal
  • Shipment Shipping & Handling
  • Shipment Promotion
  • Shipment Tax
  • Shipment Net Total
  • Carrier Name
  • Product Category
  • Seller Address

What I’m having a hard time with is that the versions of the CSV that you and @spence are sharing look different— i.e. those columns were present, I believe, in the share from @spence— and I am reluctant to update the rules file if I don’t know which one is correct. (And without an Amazon business account, I can’t download it myself to determine which is correct.)

Do you and @Spence have an idea why the CSV files look different?

@randy I just reran this report again… When running the report, all “Adjust columns” are selected by default on my account under “Business Analytics:” > “Orders”.

Reviewing these bulleted columns you provided, these appear to be in the “Shipments” report… “Business Analytics:” > “Shipments report”. See below column headers from the “Shipments” report that I just ran…

These are the confirmed columns for “Orders”:

  • Order Date
  • Order ID
  • Account Group
  • PO Number
  • Order Quantity
  • Currency
  • Order Subtotal
  • Order Shipping & Handling
  • Order Promotion
  • Order Tax
  • Order Net Total
  • Order Status
  • Approver
  • Account User
  • Account User Email
  • Invoice Status
  • Total Amount
  • Invoice Due Amount
  • Invoice Issue Date
  • Invoice Due Date
  • Payment Reference ID
  • Payment Date
  • Payment Amount
  • Payment Instrument Type
  • Payment Identifier
  • Amazon-Internal Product Category
  • ASIN
  • Title
  • UNSPSC
  • Segment
  • Family
  • Class
  • Commodity
  • Brand Code
  • Brand
  • Manufacturer
  • National Stock Number
  • Item model number
  • Part number
  • Product Condition
  • Company Compliance
  • Listed PPU
  • Purchase PPU
  • Item Quantity
  • Item Subtotal
  • Item Shipping & Handling
  • Item Promotion
  • Item Tax
  • Item Net Total
  • PO Line Item Id
  • Tax Exemption Applied
  • Tax Exemption Type
  • Tax Exemption Opt Out
  • Discount Program
  • Pricing Discount applied ($ off)
  • Pricing Discount applied (% off)
  • GL Code
  • Department
  • Cost Center
  • Project Code
  • Location
  • Custom Field 1
  • Seller Name
  • Seller Credentials
  • Seller City
  • Seller State
  • Seller ZipCode

These are the columns from the “Shipments” report:

  • Order Date
  • Order ID
  • Account Group
  • PO Number
  • Order Quantity
  • Currency
  • Order Subtotal
  • Order Shipping & Handling
  • Order Promotion
  • Order Tax
  • Order Net Total
  • Order Status
  • Approver
  • Account User
  • Account User Email
  • Shipment Date
  • Shipment Status
  • Carrier Tracking #
  • Shipment Quantity
  • Shipping Address
  • Shipment Subtotal
  • Shipment Shipping & Handling
  • Shipment Promotion
  • Shipment Tax
  • Shipment Net Total
  • Carrier Name
  • Amazon-Internal Product Category
  • ASIN
  • Title
  • UNSPSC
  • Segment
  • Family
  • Class
  • Commodity
  • Brand Code
  • Brand
  • Manufacturer
  • National Stock Number
  • Item model number
  • Part number
  • Product Condition
  • Company Compliance
  • Listed PPU
  • Purchase PPU
  • Item Quantity
  • Item Subtotal
  • Item Shipping & Handling
  • Item Promotion
  • Item Tax
  • Item Net Total
  • PO Line Item Id
  • Tax Exemption Applied
  • Tax Exemption Type
  • Tax Exemption Opt Out
  • Discount Program
  • Pricing Discount applied ($ off)
  • Pricing Discount applied (% off)
  • GL Code
  • Department
  • Cost Center
  • Project Code
  • Location
  • Custom Field 1
  • Seller Name
  • Seller Credentials

I have had the same issues importing Amazon Business orders.

My Orders report categories match @al1’s list.

The Shipment report is marked “new” on the Business Analytics home page. Could it be that Amazon created a new Shipment report and pulled shipping information from the Orders report?

I reran the export as well, my file headers match what @Randy is showing. Not sure why the first runs did not match but these definately do.

I appreciate your patience on this thread, everyone… I have been head-down on some other product work for the past week.

It took a little while to pick through it but I found this post from @al1 really helpful in understanding the new export formats.

The Orders Export

The Orders export appears to drop the following fields which were used in the workflow:

  • Shipment Date - logged in Metadata
  • Carrier Tracking # - used in unique identifier + logged in Metadata
  • Shipping Address - logged in Metadata
  • Product Category - logged in Metadata + mapped the Category Hint column

The Orders export adds the following new fields:

  • Amazon-Internal Product Category
  • Segment
  • Family
  • Class
  • Commodity
  • Seller City
  • Seller State
  • Seller ZipCode

The Shipments Report Export

The Shipments Report export appears to drop the following fields which were used in the workflow:

  • Payment Instrument Type - logged in Metadata + mapped the Account column
  • Payment Identifier - logged in Metadata + mapped the Account column
  • Product Category - logged in Metadata + mapped the Category Hint column

The Shipments Report export adds the following new fields:

  • Amazon-Internal Product Category
  • Segment
  • Family
  • Class
  • Commodity

Solution

We generate a pseudo unique ID for each record using a number of fields to avoid reimporting records. I’ve decided to use the Shipments Report since it preserves the Carrier Tracking # which is part of the existing unique ID. This should prevent (overlapping) records from reimporting after we upgrade the import rules.

Both reports appear to replace the “Product Category” field with the new “Amazon-Internal Product Category”. I will map this to the Category Hint column.

The Account number was rendered as a concatenation of:
Payment Instrument Type + Payment Identifier / Account User
With the first two fields missing, I’m not seeing anything that could help identify the payment method. I will leave the Account field blank in the new importer.

Hope to have this live soon.
Randy

I just pushed updated rules per the changes :point_up:. Give it about 20 minutes to clear any cloud caching— you may want to reload the add-on— and then let me know if it is working for you. I don’t have a valid Shipments export so I am unable to test.

:crossed_fingers: