If you would like to see a report of how many products have sold within a certain date range follow the steps below to retrieve this report from your Ordoro account:

**DISCLAIMER** If you have kits, this report will only show the total sold for the Parent SKU. The total sold will NOT reflect in the child SKU totals. If the child SKU is also sold as an individual SKU, the total sold will display only for those orders with the child SKU purchased.

 

In Ordoro v3:

  • Click on the Orders tab in the green bar
  • Select Other Actions
  • Select the CSV Export option
  • Select the Date Range of orders (note the Date is based off the Order date of the Order)
  • Select the Order Detail option from the Level of Detail dropdown menu
  • Select Shipped from the Status Dropdown (note the date range is based off the Order date of the Order)
  • Select the Export button
  • Download the CSV file from the activities menu located to the left of the blue sync button
  • Open the .csv file and SAVE AS a .xlsx file
  • Highlight all data
  • Click on the Data option in the actions menu within Excel
  • Create a Pivot Table – see this link about Pivot Tables

  • Clear everything in the Pivot Table Builder
  • In the Pivot Table Builder, drag the SKU option in the Field Name under the Row Labels field
  • Optional to drag the SKU Description field to Row Labels field under the SKU
  • In the Pivot Table Builder, drag the SHIPPED QTY in the Field Name option under the Values field (MAKE SURE TO SUM!!)
  • Optional to drag the Order Line Price field to the Values area (MAKE SURE TO SUM!!)

 

 

 

In Ordoro v2:

  • Click on the Orders tab in the green bar
  • Select the Export option on the right side of the screen
  • Select the Order Detail option from the dropdown menu
  • Select the Date Range that will cover all orders sitting in the New and In Process status
  • Select the Export button
  • Download the CSV file from the activities menu located to the left of the blue sync button
  • Open the .csv file and SAVE AS a .xlsx file
  • Highlight all data
  • Click on the Data option in the actions menu in Excel
  • Select the Sort option
  • Sort by Status
  • Delete all rows that are in Awaiting Fulfillment, In Process and Cancelled Status (only Shipped status should remain)
  • Click on the Data option in the actions menu within Excel
  • Create a Pivot Table – see this link about Pivot Tables
  • Clear everything in the Pivot Table Builder
  • In the Pivot Table Builder, drag the SKU option in the Field Name under the Row Labels field
  • Optional to drag the SKU Description filed to Row Labels field under the SKU
  • In the Pivot Table Builder, drag the SHIPPED QTY in the Field Name option under the Values field (MAKE SURE TO SUM!!)
  • Optional to drag the Order Line Price field to the Values area (MAKE SURE TO SUM!!)

Results will show SKUs/SKU Descriptions that have sold within the date range selected.

 

**TIPS**
If you click on the quantity in the Total column, a new spreadsheet will create with orders associated with the SKU.

Leave a Reply

Your email address will not be published. Required fields are marked *