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).
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.
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:
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 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.
I just pushed updated rules per the changes . 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.
Still getting errors when importing a Shipments Report for Amazon Business Analytics.
Error Message: The importer does not recognize the uploaded file. Check that you are uploading a supported file type.
I checked the file type, it was originally a CVS UTF-8 (Comma Delimited) (.csv). I resaved as a CSV (Comma delimated) (.csv). just to see if this was the issue and it still failed. I did notice that in Amazon Bus Analytics \ Reports it shows the Shipments report selection as New so perhaps they have changed it again. I would be willing to send you a copy of the report if that would help.
. 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.