The Sales by SKU report helps you understand what’s selling and how much you’ve sold in a specific time period. You can use it to reorder inventory, spot bestsellers, and track performance across sales channels.
Topics
- When this is helpful
- Export the Sales by SKU report
- Choose the report settings
- Download the report
- Understand the columns
When this is helpful
Use this report when you want to:
- Reorder smarter. Example: Pull the last 30 days of sales to set reorder quantities.
- Compare channels. Example: See how the same SKU performs on Shopify vs. Amazon.
- Understand kits. Example: See what sold directly vs. what sold as part of a kit.
- Report on a promotion. Example: Export sales for a weekend sale date range.
Export the Sales by SKU report
- Go to Products.
- Click Other Actions.
- Select Export Sales by SKU.
- Set your report options.
- Click Export or Schedule.
Choose the report settings
When the export window opens, you’ll choose how the report is built.
Recipient email addresses
Enter one or more emails to receive the report. Use commas to separate multiple addresses.
Email subject line
Enter the subject line you want for the email.
Date filter
Choose how Ordoro filters sales by date.
- Ordered Date: Uses the date the order was placed in your sales channel.
- Example: Use this to measure sales from a promo that ran Friday to Sunday.
- Shipped Date: Uses the date the order was shipped in Ordoro.
- Example: Use this to measure what you shipped last week.
Interval
Choose the time window for the report.
- Specific Date Range: Pick your own start and end dates.
- Example: Last month, last quarter, or a custom promo period.
- Hour, Day, Week, Month: Uses your current time to calculate the range.
- Example: If it’s 8:49 AM and you select Hour, the report returns 8:49 AM to 9:49 AM.
Truncate to start of hour, day, week, or month
Turn this on to get clean time blocks.
- Example: If it’s 8:49 AM and you select Hour with truncate enabled, the report returns 8:00 AM to 9:00 AM.
Time zone
Select the time zone you want the report to use for date and time calculations.
Group products by sales channel
Turn this on to get separate rows per sales channel.
- If selected, the report can show one row per SKU per cart.
- Example: SKU ABC was sold on Shopify and Amazon. Therefore, there will be two rows.
- If not selected, the report shows one row per SKU total.
- Example: SKU ABC appears as a single row with combined totals from Shopify and Amazon.
Download the report
After you export or schedule the report, you can download it from the Reports Activity Log.
- Go to Company Name.
- Click Reports.
- Select the Activity Log tab.
- Download the CSV file.
Understand the columns
Your CSV includes sales totals and helpful product details.
- Product Name. The product name in Ordoro.
- SKU. The SKU in Ordoro.
- Units Sold Direct. Quantity sold as a standalone item, not through a kit.
- Units Sold Via Kit. Quantity sold as a kit component. Example below.
- You sell a kit SKU XYZ that includes SKU A and SKU B.
- When XYZ sells, SKUs A and B appear under Units Sold Via Kit.
- Total Amount Sold. Units Sold Direct + Units Sold Via Kit.
- Product Category. The product category in Ordoro.
- Total of Orders Direct. Number of orders where the SKU was sold directly.
- Total of Orders Via Kit. Number of orders where the SKU was sold via a kit.
- Number of Units Dropshipped. Quantity dropshipped based on Units Sold Direct.
- Product Created Date. When the product was created in Ordoro.
- Cart. Only included if Group products by sales channel is selected.
