On our Analytics pages, you can view your Top 20 selling items. However, you may want to see all products sold over a date range. See how to export this information below.

Topics:

  1. How to export from the Orders page
  2. How to export from the Products page
  3. What the report looks like

How to export from the Orders page

1. Go to the Orders page. Make sure no orders are selected.

2. Select Other Actions -> Export Sales by SKU.

3. Enter the desired Date Range.

  • Note: If orders are already filtered by a date range, then the Start and End dates will be those dates.
  • Otherwise, the default range is the last 30 days.

4. The Group products by sales channel option will list a separate row per cart. If this is unselected, then only one row per SKU will be displayed.

  • For example, SKU ABC was sold on Amazon and Shopify.
  • If Group products by sales channel is selected, then the report will list two rows: one for Amazon, and the other for Shopify.
  • If Group products by sales channel is not selected, then the report will list one row listing the total sales from Amazon and Shopify.

5. Select Export.

6. The report will be available in the Activity Menu, located to the left of the Sync button. Select the orange CSV link and the file will download to your computer.


How to export from the Products page

1. Click on the Products tab in the green bar.

2. Select Other Actions -> Export Sales by SKU.

3. Enter the Date Range.

  • Note: If the date filter is set in the Orders tab, the date range will not forward to the Products tab.

4. The Group products by sales channel option will list a separate row per cart. If this is unselected, then only one row per SKU will be displayed.

  • For example, SKU ABC was sold on Amazon and Shopify.
  • If Group products by sales channel is selected, then the report will list two rows: one for Amazon, and the other for Shopify.
  • If Group products by sales channel is not selected, then the report will list one row listing the total sales from Amazon and Shopify.

5.. Select Export.

6. The report will be available in the Activity Menu, located to the left of the Sync button. Select the orange CSV link and the file will download to your computer.


What the report looks like

The CSV will contain the following columns:

  • Product Name
  • SKU
  • Units Sold Direct
    • The amount sold directly on an order (i.e. was not a kit.)
  • Units Sold Via Kit
    • For example: SKU XYZ was sold.
    • SKU XYZ is a kit with components SKU A and SKU B.
    • SKU A and B would appear as Units Sold Via Kit.
  • Total Amount Sold
    • The sum total of Units Sold Direct and Units Sold Via Kit.
  • Cart (Optional)
    • This column will appear if Group products by sales channel was selected.
    • The Group products by sales channel option will list a separate row per cart.

Leave a Reply

Your email address will not be published.