CSV Import Error for "Amazon Business Purchases"

Google Sheets
,
17

@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