Appearance
Shipped products
The Shipped products report lists the products that left the warehouse, per shipment, parcel and product. For each row you see the order, the destination, the carrier and tracking number, the parcel's dimensions and weight, and the value of the goods. It is the most complete outbound report and is often used for invoicing, customs and customer reporting.
Open it from the sidebar: Reporting › Shipped products.
What is included
Shipments of the accounts you have access to that are labelled, shipped or delivered. Each row is one product in one parcel of one shipment for one order; if a parcel contains three different products, that parcel has three rows. Products shipped for return orders are left out.
Because labelled shipments are included, a row can appear before the shipment has actually left the building. Such rows have no Shipped at yet. Filter Shipped at is not empty to see only shipments that really left.
The report is refreshed every four hours; see How report data is updated.
Columns
Shipment and order
| Column | Meaning |
|---|---|
| Shipped at | When the shipment was shipped. Empty for shipments that are labelled but not shipped yet. |
| Shipment number | The shipment's number. Click it to open the shipment. |
| Created at | When the order was created. |
| Order number | The order's number. Click it to open the order. |
| Customer reference number | The customer's reference on the order. |
| Other reference number | The other reference on the order. |
| Account | The account of the shipment. Shown only when your account has sub-accounts. |
| Business model | Business to consumer, Business to business, Business to government, or Buy online, pickup in shop. |
| Delivery terms | The delivery terms (Incoterms) on the order. |
| Shipping method | The shipping method of the order. |
| Ship at | The order's planned ship date and time. |
| Ship earliest on | The order's earliest ship date. |
Destination and carrier
| Column | Meaning |
|---|---|
| Company name | The company of the shipment's destination. |
| Contact | The first and last name of the destination contact. |
| The destination contact's e-mail address. | |
| Address | The destination address lines. |
| City | The destination city. |
| Postal code | The destination postal code. |
| Country | The destination country. |
| Tracking number | The parcel's tracking number, or the shipment's tracking number when the parcel has none. |
| Carrier | The carrier of the shipment. |
| From location | The location the shipment left from. |
Product and value
| Column | Meaning |
|---|---|
| Product number | The product's number (SKU). |
| Product description | The product's name. |
| Country of origin | The product's country of origin. |
| Quantity | The number of units of this product in this parcel. |
| Currency | The currency of the value. |
| Value | The value of the units: the product's default price times the quantity. When the product has no default price, the value is 0 and the currency shows USD. |
| Product category | The product's category. |
| Serial numbers | How many of these units have a serial number. |
| Lots | How many of these units have a lot number. |
| UN numbers | How many of these units are of a product with a UN number (dangerous goods). |
| Purchase order number | The purchase order number of the purchase order on which these units were originally received. |
Parcel
| Column | Meaning |
|---|---|
| Parcel | The parcel's identifier. |
| Parcel description | The parcel's description. |
| Physical packaging | The parcel's physical packaging. |
| Weight | The parcel's weight. |
| Weight unit | The unit of the weight. |
| Length, Width, Height | The parcel's dimensions. |
| Dimension unit | The unit of the dimensions. |
INFO
Weight and dimensions belong to the parcel, not to the product row. When a parcel holds several products, each of its rows repeats the same parcel weight and dimensions. Do not add them up per row to get a total weight; count each parcel once.
Filters
Every column can be filtered (see Filters). These columns offer a list of values:
| Column | Values |
|---|---|
| Business model | Business to consumer, Business to business, Business to government, Buy online, pickup in shop |
| Carrier | All carriers |
| From location | The locations you have access to |
Useful filters:
- Shipped at between two dates, for a month's shipments.
- Country isn't your home country, to see export shipments for customs.
- Carrier is a carrier, to reconcile a carrier's invoice.
- UN numbers greater than 0, for shipments containing dangerous goods.
- Customer reference number is a reference, to see everything shipped for one web shop order.
Sorting and search
The report is sorted by Shipped at, newest first. Search looks in all columns, including tracking numbers, names, addresses and product numbers.
Exporting
Use the export button to download the report as CSV. See Exporting. With over forty columns, hiding the columns you do not need before exporting keeps the file manageable.
Typical use
- Outbound invoicing: filter Shipped at on the month and export; count parcels, units or orders per account.
- Carrier invoice check: filter on Carrier and the period, and compare tracking numbers, weights and dimensions with the carrier's invoice.
- Customs and export administration: the Country, Country of origin, Value and Delivery terms columns provide the data for export declarations and statistics.
- Customer reporting: export a customer's shipments with tracking numbers so they can inform their own customers.
- Tracing: the Purchase order number column links shipped goods back to the purchase order they came in on, for example for a recall.
Who can see it
Admins, Warehouse associates, Account owners, Shopify account owners and users with the Reporting role. See Who can see reports.