Skip to main content

Report wholesale sales and units shipped by week

A weekly wholesale report usually answers two questions: how much did wholesale accounts order each week, and how many units went out the door. SKU.io answers the first in Custom Reports, which can group order dates by week. The second comes from an export of your shipments, totalled by week in a spreadsheet.

This page is a recipe. For a full tour of the report builder, see Build a custom report.

Before you begin​

  • You need access to Custom Reports, and permission to view sales orders for the Shipments tab.
  • Decide how SKU.io can tell a wholesale order apart. SKU.io has no wholesale flag on an order. Custom Reports can filter by Channel Name, Customer Name, or Customer Company, so use whichever fits your setup:
    • Your wholesale orders arrive through their own sales channel, such as NuORDER. Filter on that channel.
    • Your wholesale orders share a channel with retail orders. Filter on the list of wholesale customers.
  • Customer tags and pricing tiers aren't fields in Custom Reports. To split revenue by a Wholesale customer tag instead, see Segment the Profitability report by customer tag.

Report wholesale sales by week​

  1. Go to Insights → Reports, open Custom Reports, and click New Report.

  2. Under Data Source, choose the Sales domain and the Sales Order Lines base entity.

  3. In the Fields list, under Sales Orders, drag Order Date onto Rows.

    The field arrives grouped by month, and its chip reads MONTH.

  4. Click the MONTH chip and choose WEEK.

    Each row is now one week, labelled with the year and week number, such as 2026-W46. Weeks start on Monday and follow your account's time zone.

  5. Drag the field to compare onto Columns:

    • For sales by channel, drag Channel Name from Sales Channels.
    • For sales by customer, drag Customer Name or Customer Company from Sales Orders.
  6. Drag Net Revenue onto Values.

    Net Revenue is the line total after discounts, in your home currency. Add Units Sold as a second value if you also want the units ordered.

  7. In the Config tab, under Filters, click Add and set Order Date between the first and last day of the period you want.

  8. Click Add again and filter to your wholesale orders. For example, set Channel Name is one of your wholesale channels, or Customer Name is one of your wholesale accounts.

  9. Click Add again and set Order Status is not cancelled.

    Add one more filter for draft if you don't want unconfirmed orders counted.

  10. Click Run Report.

    The pivot shows one row per week, one column per channel or customer, and a grand total.

  11. Under Report Name, enter a name, such as Wholesale sales by week, and click Save.

  12. To download the results, click Export and choose CSV, XLSX, or PDF.

The report keeps its settings, so next time you only change the Order Date filter and click Run Report. To have it emailed every week, see Share a custom report and email it on a schedule.

Ordered, not shipped

This report counts sales by the date the customer placed the order. Units that shipped in a given week come from your shipments, below.

Report units shipped by week​

Custom Reports can count shipments by week, but it can't total the units inside them. The Shipments export has each shipment's quantity and the date it was fulfilled, so you total it by week in a spreadsheet.

  1. Go to Orders → Fulfillments and open the Shipments tab.

  2. Click the Date filter, choose Fulfilled At, select the first and last day of your period, and click Apply.

    Shipments that haven't been fulfilled yet have no fulfilled date, so they drop out.

  3. Set Voided to Hide Voided.

    The list shows voided shipments by default, and their units never left.

  4. To count only wholesale shipments, set the Sales Channel filter to your wholesale channel.

    This filter matches the kind of channel, such as NuORDER, not one store. It separates wholesale only when your wholesale orders come through a channel of their own kind.

  5. Check that the Total Qty and Fulfilled columns are showing. If you hid either one, turn it back on with the column selector.

    The export includes only the columns on screen.

  6. Click Export.

  7. Under Records to export, choose Filtered results.

  8. Under Content, choose Fulfillment Summary, which gives one row per shipment.

  9. Under File format, choose XLSX (Excel) and click Export.

    A large export runs in the background. Follow it in the job tray, which downloads the file when it's ready.

  10. Open the file in Excel or Google Sheets. In a new column beside Fulfilled At, work out the Monday that starts each shipment's week. If Fulfilled At is in column Q, enter =INT(Q2)-WEEKDAY(Q2,3) in row 2, fill it down, and format the column as a date.

    If your spreadsheet reads the dates as text, convert the column to dates first.

  11. Insert a pivot of the sheet in Excel or Google Sheets. Put the new week column in the rows and the sum of Qty in the values.

    Each row is one week and the units shipped in it. These Monday-start weeks line up with the weeks in Custom Reports.

Units by product

To see which products shipped each week, choose Fulfillment with Line Items in step 8. The file then has one row per product in each shipment. Sum Item Qty, not Qty: Qty is the shipment's total, repeated on every one of its rows.

Next steps​

Last verified: