Skip to main content

How to export and search your orders data

The Orders Export allows you to analyse your sales data outside of Photohawk using Microsoft Excel, Apple Numbers or Google Sheets.

You can export all orders across all of your galleries, making it easy to search, filter and analyse your sales.

How to Export Your Orders

  1. Log in to your Photohawk account.

  2. Navigate to Sales > Orders.

  3. This page displays every order across all of your galleries.

  4. In the top-right corner of the page, you'll see two download options:

    • Download Summary CSV

    • Download Details CSV (one row per item)

Which export should I use?

Summary CSV

  • One row per order.

  • Best for reporting, searching orders, coupon usage and customer information.

Details CSV

  • One row per purchased item.

  • Best when you need a breakdown of every individual image or product purchased.

Opening the Export

Once downloaded, open the CSV using:

  • Microsoft Excel

  • Apple Numbers

  • Google Sheets

  • Any spreadsheet application that supports CSV files

Searching Your Data

You can use your spreadsheet application's Search, Find, or Filter feature to quickly locate information.

Common things you may want to search include:

  • Order ID

  • Customer name

  • Email address

  • Mobile number

  • Gallery name

  • Coupon codes

  • Order status

  • Payment method

  • Date

  • Currency

You can also filter the data to show only specific results, such as:

  • Orders from a particular gallery - Gallery name

  • Orders placed during a specific date range.

  • Orders using a particular coupon.

  • Orders paid using a specific payment method.

Information Included in the Export

The exported file contains a wide range of order information, including:

Field

Description

Order ID

Unique order reference.

Currency

Currency used for the purchase.

Method

Payment method used by the customer.

Payout Status

Indicates whether the order has been included in a payout.

Date

Date the order was placed.

Time

Time the order was placed.

Status

Current order status.

Gallery

Gallery the purchase was made from.

Type

Order type.

First Name

Customer's first name.

Last Name

Customer's last name.

Name

Customer's full name.

Email Address

Customer's email address.

Mobile Number

Customer's phone number.

Coupons

Coupon code(s) applied to the order.

No Images

Number of images purchased.

Unit Value

Value of each item before discounts.

Discount

Discount applied to the order.

Gross Profit

Total order value before fees.

Fee

Processing fees applied.

Commission Fee

Commission charged on the order.

Shipping Fees

Shipping charges (where applicable).

Platform Services Fees

Platform service charges.

Transaction Fee

Payment processing fee.

Net Profit

Final amount payable after fees and deductions.

Common Uses

The Orders Export can be used to:

  • Track coupon usage.

  • Find a customer's order.

  • Analyse sales performance.

  • View orders by gallery.

  • Monitor payouts.

  • Check payment methods.

  • Identify repeat customers.

  • Review discounts given.

  • Report on revenue and profit.

  • Filter orders by date, gallery or customer.

Tips

  • Use the Summary CSV for most reporting and customer searches.

  • Use Filters instead of scrolling through thousands of orders.

  • Save a copy of your exported file before making any edits so you always have the original data available.

Did this answer your question?