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 spreadsheet icon in the top toolbar. Its tooltip reads Export to XLS. A modal dialog titled Export orders to sheet XLS opens. You need the orders permission on your account to export: without it the request is refused with a permission error.
Filters
Date range
Use the Date range calendar picker to set a start and end. The picker includes the time of day and will not let you pick a date in the future (its maximum is today). Leave the range empty to export every order. The filter applies to the order's creation date.
Order status
The Order status dropdown restricts the export to a single status. The default is All statuses, which includes every status. You can narrow it to any one of the fourteen statuses: Abandoned, Pending, Confirmed, Prepared, Shipped, Delivered, Done, Out of stock, Not reached, Cancelled, Rejected, Return request, On return, or Returned. Test orders, deleted orders, and hidden orders (the blurred rows in your orders list) are always excluded, whatever you choose here.
Selecting columns
The export dialog shows two lists side by side: Available fields and Selected fields. There are 56 fields to choose from. Move fields between the lists with the arrow buttons in the centre (single arrows move the highlighted fields, double arrows move all of them). You must select at least one field: submitting with nothing selected shows the error Please select at least one column to export. The order of fields in the Selected fields list sets the column order in the spreadsheet.
Complete list of available fields
The following fields can be included in the export. Order-level fields output their value only on the first row of each order (see Row structure below).
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 market country (same source as Order's market)
- Customer's real country: the country detected from the customer's IP address, which can differ from the shipping country
- 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
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 of each order; later rows for the same order leave those cells blank. Group rows by the Order's ID or Order's Number column to see all items belonging to one order.