Can I Import Amazon Business CSV Line Items?

Spreadsheets Google Sheets
1

I just tried uploading an Amazon business account CSV, and got an error saying the format wasn’t recognized. (In contrast, uploading order reports from personal Amazon accounts works as expected.) Perhaps the business format changed?

3

To recognize file types, the workflow looks that a list of column headers are all present. The Amazon business workflow is expecting this full list of columns:

  • 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
  • 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
  • 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
  • Seller Address

Could you have a look at your CSV file, @Ghopper21, and let me know how the fields differ? Thanks.