Exporting orders

Export Commerce orders to a .csv file to analyze your sales data with third-party services.

Last updated September 18, 2024

You can export Commerce orders to a .csv file. Use the filters in the export tool to refine the exported data by order status and date range.

Before you begin

  • To export custom product form submissions, select a specific product during the export process.
  • When you export orders for a specific product, you can only choose current, active products. For example, if you rename a product, you can't export orders or custom product forms for the older version.
  • If a product is hidden or deleted, or if it's on a disabled store page, you can't choose it or its custom product form submissions for export.
  • To export submissions for multiple products, repeat the steps below to export each product individually.
  • Partially-refunded orders display the full purchase price.

Export orders

  1. Open the Products & Services panel and click Orders.
  2. Click Download CSV.

Filter the export by Order Status

  1. Check or uncheck the orders to export. You can choose to export any combination of Pending orders, Completed orders, and Cancelled orders.
  2. Click Download.
Export_Orders.png

Filter the export by Order Date

The date range is based on when orders were created, not when you marked them as completed.

  1. Select a date range from the Include Orders From drop-down menu.
  2. There are 13 date range options in the menu. Select Specific date range to set a custom date range.
  3. Click Download.

Choose product details

Refine which products to include in the order export. All products export by default.

  1. Select All products to download orders for all products.
  2. Select Specific Product and search for a product to download orders that include specific products.
  3. Check Include product form data to include custom product form submissions in the .csv.
  4. Click Download to export.

Note

Before exporting, ensure all product form fields have unique names. Fields with duplicate names won't export.

Exported data

You can open an export file in Microsoft Excel, Numbers, or another spreadsheet program. In the spreadsheet, most details for orders containing multiple products will display in the first product row. Additional products in the order will only display their product line item details. The .csv file includes:

Order information

  • Canceled at (date & time of cancellation)
  • Channel (online or in-person sale, or a third-party sales channel)
  • Channel Name (Squarespace, or the name of the third-party sales channel where the order imported from)
  • Channel Order Number (the Order ID assigned by the sales channel)
  • Created at (date & time created)
  • Custom checkout form submissions (each form field will be in its own column)
  • Custom product form submissions (when a specific product is selected. Each form field will be in its own column)
  • Discount Code
  • Email (customer's email)
  • Fulfilled at (date & time fulfilled)
  • Order ID
  • Private Notes
  • Shipping Method

Payment information

  • Amount Refunded
  • Currency
  • Discount Amount
  • Financial Status (status of charge)
  • Paid at (date & time of payment)
  • Payment Method
  • Payment Reference (reference code for payment)
  • Shipping (cost of shipping)
  • Subtotal
  • Taxes
  • Total

Item information

  • Lineitem fulfillment status (fulfillment status of item)
  • Lineitem name (name of item)
  • Lineitem price (price of item)
  • Lineitem quantity (quantity of item)
  • Lineitem requires shipping (shipping required for item)
  • Lineitem sku (SKU of item)
  • Lineitem taxable (item can be taxed)
  • Lineitem variant (variants chosen for item)

Billing information

  • Billing Address 1 (line 1)
  • Billing Address 2 (line 2)
  • Billing City
  • Billing Country
  • Billing Name
  • Billing Phone
  • Billing Province
  • Billing Zip

Shipping information

  • Shipping Address 1 (line 1)
  • Shipping Address 2 (line 2)
  • Shipping City
  • Shipping Country
  • Shipping Name
  • Shipping Province
  • Shipping Zip

Tip

If you're interested in order fulfillment and inventory integrations, learn about our Commerce APIs.

Footer Image
  • Get help from our community

  • Get help from our community on advanced customizations.

  • Hire a Squarespace Expert

  • Stand out online with the help of an experienced designer or developer.