How do I export order data?

Your order data can be exported to a CSV (comma-separated values) file. Then, it’s easy to load into Excel or Numbers to slice and dice the data however you want.

A few examples of how order data can be used:

  1. Export all customer email addresses and use them in email campaigns.
  2. Group orders by SKU and identify repeat buying patterns.
  3. Filter orders by the state to figure out sales tax calculations.

Topics

  1. How are the Order Summary and Detail reports different?
  2. Helpful tips
  3. How to export order data
  4. Order Summary / Detail column headers

How are the Order Summary and Detail reports different?

Order Summary

  • There is one row per order.
  • Product line information is not included. For example, SKUs and item names.

Order Detail

  • There is one row per order line (i.e., product on order).
  • For example, there will be three rows if an order includes three products.

See the comprehensive list of column headings in each report.

Helpful tips

The report may show different data based on the order shipping method or your Ordoro subscription.

Orders shipped via Flat Rate methods

  • A few examples are:
    • USPS Small Flat Rate Box
    • FedEx One Rate Boxes
    • UPS Express Boxes
  • The report will not include package dimensions because the dimensions are predetermined.
  • The shipping weight will be included since that can vary.

Multi-package shipments

Allocation

  • Allocation is only available for customers who have opted into the Allocation module. See our pricing page here for more details.
  • The export has a column for Allocation, but the data is only accurate for customers who have opted into the Allocation module.
  • Also, there are two Allocation columns: 1) Allocation Status and 2) Order Line Allocation.
    • Allocation Status: the order level status
    • Order Line Allocation: which lines have/have not been allocated

How to export order data

1. Go to the Orders tab -> select Actions.

2. From the dropdown, select Export Order Info.

3. This will open the Export Order Info modal. Choose from the options to customize the export:

  • Recipient Email Addresses (optional)
    • Comma-separated list of recipients for the Order report.
  • The date filter for your report.
    • Created Date: When the order was placed in your sales channel.
    • Shipped Date: When the order was shipped in Ordoro.
  • Interval
    • Interval Options:
      • Specific Date Range
      • Hour
      • Day
      • Week
      • Month
    • If you select Hour, Day, Week, or Month – then Ordoro uses your current time to run the report.
      • Example: if the current time is 9:18am, selecting “Hour” will return results from 8:18am to 9:18am.
    • Truncate to start of hour / day / week / month
      • By selecting this option, the report will run from the start of the chosen interval (minute 0) to the end of the same interval (minute 0).
      • Example: if the current time is 9:18pm, selecting the truncate option will return results from 8:00am to 9:00am.
  • Time Zone
  • Status
    • Choose which order status to include.
    • Options: All, Awaiting Fulfillment, Shipped, Dropshipment Requested, Cancelled
  • Sales Channel
    • Choose the sales channel for the order report.
    • Options: All or each sales channel is listed separately.
  • Supplier
    • Choose orders that are assigned to specific suppliers.
    • Options: All or each supplier is listed separately.
  • Carrier
    • Only available if Status: Shipped has been selected.
    • Select from: All, No Carrier, Specific Carrier Types.
    • If you select Specific Carrier Types, choose the checkbox next to the carriers you’d like to include in the report.
  • Allocation Status
    • This feature is exclusive to customers who have opted into the Allocation module.
    • Options: All, Allocated, Partially Allocated, Unallocated, Could not Allocate, Overallocated
  • Level of Detail
    • Options: Order Summary, Order Detail
    • See this section to understand the difference.
  • Order Tags
    • A dropdown list of all your tags

4. After entering your report parameters, click Export or Schedule.

  • If you select Schedule, you’ll be prompted to create a report. See this support article for details.

5. Once the report is complete, it is available in the Activity Menu -> Exports.

6. Click the CSV button. The file will automatically download to your computer.

Order Summary / Detail Column Headers

ColumnOrder SummaryOrder Detail
Order ID✓✓
External Order ID✓✓
Order Date✓✓
Cart Name✓✓
Order Status✓✓
Number of Lines✓✓
Total Price✓✓
Product Subtotal✓✓
Discount✓✓
Shipping & Handling✓✓
Tax✓✓
Credit Card Issuer✓✓
Bill To (Company Name)✓✓
Bill To (Name)✓✓
Bill To (Street1)✓✓
Bill To (Street2)✓✓
Bill To (City)✓✓
Bill To (State)✓✓
Bill To (Code)✓✓
Bill To (Country)✓✓
Bill To (Email)✓✓
Bill To (Phone)✓✓
Bill To (Fax)✓✓
Bill To (Reference Number)✓✓
Ship To (Company Name)✓✓
Ship To (Name)✓✓
Ship To (Street1)✓✓
Ship To (Street2)✓✓
Ship To (City)✓✓
Ship To (State)✓✓
Ship To (Code)✓✓
Ship To (Country)✓✓
Ship To (Email)✓✓
Ship To (Phone)✓✓
Ship To (Fax)✓✓
Ship To (Reference Number)✓✓
Requested Shipping Method✓✓
Customer Instructions✓✓
Internal Notes✓✓
Order Allocation Status✓✓
Shipment Date✓✓
Ship From◯✓
SKU◯✓
SKU Description◯✓
SKU Additional Details◯✓
Category◯✓
Ordered Qty◯✓
Order Line Price◯✓
Shipped Qty◯✓
Order Line Allocated◯✓
Vendor✓✓
Shipping Method✓✓
Tracking Number✓✓
Tracking Status (USPS only)✓✓
Shipping Cost✓✓
Length✓✓
Width✓✓
Height✓✓
Weight (in oz)✓✓
Package Type✓✓
Weighted Average Unit Cost◯✓
Tags✓✓
Supplier✓✓
Supplier SKU◯✓
Serial Numbers◯✓
Tagged: