Storeep can export your orders to a standard XLS (xlsx) spreadsheet that opens in Excel, Google Sheets, or any compatible application. The export is fully configurable: choose which date range to include, optionally filter by status, and pick exactly which data columns you want in the file.
Opening the export dialog
On the Orders page, click the Export to XLS button (spreadsheet icon) in the top-right toolbar. The button is only visible when your account has the orders permission. A modal dialog titled Export orders to sheet XLS opens.
Filters
Date range
Use the calendar picker to select a start date and end date. Both ends of the range are optional: you can export from a start date with no end, up to an end date with no start, or use neither to export all orders. The filter applies to the order's creation date.
Order status
The Order status dropdown lets you restrict the export to a single status. The default is All statuses, which includes every status. Select one of the fourteen statuses to narrow the export. Test orders and deleted orders are always excluded regardless of this setting.
Selecting columns
The export dialog shows two lists side by side: Available fields and Selected fields. Move fields between lists using the arrow buttons in the centre. You must select at least one field: submitting with nothing selected returns a validation error. The order of fields in the Selected fields list determines the column order in the spreadsheet.
Complete list of available fields
The following fields can be included in the export. Order-level fields output data only on the first row of each order; if an order has multiple items, subsequent item rows leave those cells empty to avoid repeating the same value.
Order fields (one value per order)
- Order's ID: the unique identifier of the order
- Order's Number: the human-readable sequential number prefixed with #
- Order's date: the date and time the order was placed
- Order's shipping method: the shipping method chosen by the customer
- Order's weight: the total weight of all items combined, with the store's weight unit appended
- Order's payment method: for example, Cash on delivery, Bank transfer, Card, PayPal, Stripe, CMI, or Paystack
- Order's subtotal: the sum of item prices before discounts and shipping
- Order's discount: the discount amount deducted
- Order's shipping: the shipping fee charged
- Order's vat: the VAT amount applied
- Order's total: the final amount charged
- Order's currency: the currency code (e.g. USD, EUR)
- Order's market: the full country name of the shipping market
- Order's market code: the ISO country code of the shipping market
- Order's status: the current status label (e.g. Pending, Confirmed, Shipped)
- Order's abandoned status: a checkmark (✅) if the order was originally an abandoned cart, empty otherwise
- Order's duplicated status: a checkmark (✅) if the order is flagged as duplicated, empty otherwise
- Order's returning customer status: a checkmark (✅) if the customer is a returning buyer, empty otherwise
- Order's test status: a checkmark (✅) if the order is a test order (test orders are excluded from exports, so this column will always be empty)
Product / item fields (one value per line item)
- Product's ID: the product's unique identifier
- Product's name: the product name at the time of the order
- Product's price: the unit price of the item
- Product's quantity: the quantity ordered
- Product's sku: the SKU assigned to the item's variant
- Product's barcode: the barcode assigned to the item's variant
- Product's weight: the individual item weight with the store's weight unit
- Product's variants: the selected variant option values joined with a dash (e.g. Red - Large)
- Product's link: the full storefront URL of the product
Customer fields (one value per order)
- Customer ID: the customer's unique identifier
- Customer's fullname
- Customer's birthday
- Customer's gender
- Customer's company
- Customer's address1
- Customer's address2
- Customer's state / region
- Customer's city
- Customer's commune
- Customer's province
- Customer's postal code
- Customer's country: the full name of the shipping country
- Customer's real country: the country detected from the customer's IP address
- Customer's email
- Customer's phone
- Customer's whatsapp
- Customer's note: any note the customer added at checkout
- Customer's browser
- Customer's OS
- Customer's device
- Customer's IP
UTM / tracking fields (one value per order)
- UTM's source
- UTM's medium
- UTM's campaign
- UTM's term
- UTM's content
Store field
- Store's name: useful when merging exports from multiple stores
Downloading the file
Click Export. Storeep builds the spreadsheet and triggers a download in your browser. The filename follows the pattern orders-YYYY-MM-DD.xlsx using the current date. If no orders match the selected filters, you will see the message: No orders found matching the selected criteria.
Row structure note
Because one order can contain multiple line items, the export uses one row per item. Order-level data (totals, customer address, UTM values) appears only on the first row for each order; subsequent rows for the same order leave those cells blank. When opening the file in a spreadsheet application, use the Order's ID or Order's Number column to group rows belonging to the same order.