Can anyone advise which 2 shipment reports would be the best to export & combine?
End result is to de-dupe after merge and attain shipping cost for those single item orders.
Data needed:
Order #
SKU
Shipping Cost
Solved
Merge shipment export reports
Best answer by JuanAdmin
Hey,
On the orders tab, when you click the “Shipped” dropdown it will allow you to export the data with those orders. When you create a new format what you want to do is make sure you’re creating it with “Export Order Line Items”. There you will have the option to include SKU.
You can get all three data points (Order #, SKU, and Shipping Cost) in a single CSV file by creating a custom Order Line Items export format.
Here is how to set this up:
- Go to the Orders tab
- Select any order (or multiple orders), click Other Actions at the top, and select Export Orders
- In the pop-up window, click the Create a New Format button
- Give your format a name (e.g., 'Single Item Order Shipping Cost')
- Choose Export Order Line Items (instead of Export Orders) so that the SKU field becomes available
- Drag and drop (or check the boxes) to select only the following fields from the list
-
Order - Number (Order #)
-
Item - SKU (SKU)
- Amount - Shipping Cost (The shipping cost of the label)
-
Hi Juan,
If I go to the Orders tab, those are live orders. I need those that have shipped which shows the shipping cost we have paid.
Additionally, there is no Item - SKU option in the Available fields.
Look forward to hearing from you.
Hey,
On the orders tab, when you click the “Shipped” dropdown it will allow you to export the data with those orders. When you create a new format what you want to do is make sure you’re creating it with “Export Order Line Items”. There you will have the option to include SKU.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.