CSV Import Error for "Amazon Business Purchases"

Google Sheets
,
23

The importer is pretty brittle. When the report data organization changes even a little the importer chokes. I can take a look at it next week but need a copy of at least the header row and one representative row of data. Could you DM that to me?

Thanks.

24

Hey Randy, I am still having issues with importing amazon business purchases… can you please share what columns the importer is looking for? I ask because the business report has options to include/exclude columns if we can align these columns to what the importer is looking for then maybe it will work… thx

25

It currently expects all of the following columns (or else it will not “recognize” the CSV):

  • 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
  • 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
  • Segment
  • Family
  • Class
  • Commodity
26

@randy
FYI, the following do not appear to be in the exported amazon files anymore:

*Discount Program
*Pricing Discount applied ($ off)
*Pricing Discount applied (% off)

Here is the list of columns from the current Shipments Report Export:

  • 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
  • Delivery Status
  • Expected Delivery Date
  • 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
  • Pricing Savings program
  • Agreement
  • Pricing Discount Applied
  • Receiving Status
  • Received Quantity
  • Received Date
  • Receiver Name
  • Receiver Email
  • GL Code
  • Department
  • Cost Center
  • Project Code
  • Location
  • Custom Field 1
  • Custom Field 2
  • Custom Field 3
  • Custom Field 4
  • Custom Field 5
  • Custom Field 6
  • Custom Field 7
  • Custom Field 8
  • Custom Field 9
  • Custom Field 10
  • Custom Field 11
  • Custom Field 12
  • Custom Field 13
  • Seller Name
  • Seller Credentials
27

Sorry to be slow to see this, @al1…

I just pushed these changes to the Amazon Business Purchases workflow. Can you let me know if they work for you?

Thanks for the quick and actionable change reco.