Export Commerce orders

false

Export Commerce orders

Last updated October 09, 2026 17:41

Download your orders as a .csv spreadsheet, or send new orders to Google Drive or Zapier automatically.

Export your orders to review sales data, do your bookkeeping, or manage orders outside Squarespace. Exports for specific products include add to cart and checkout form responses.

Export orders to a .csv file

To download your orders as a spreadsheet:

  1. Open the Products & Services panel and click Orders.
  2. Click Export data, then click Download CSV.
  3. Choose the order statuses to include.
  4. Choose a date range to export orders created within the range.
  5. Choose All products or Specific product.
  6. If you chose Specific product, search for and select a product. Only active products on enabled store pages appear. Exports for specific products include add to cart form responses.
  7. To leave out add to cart form responses, uncheck Include product form data.
  8. Click Download.

Auto-export orders to Google Drive

You can auto-export to Google Drive on the Core, Plus, and Advanced plans, and some legacy plans.

Send each new order to a sheet or folder in Google Drive automatically. New orders appear in Google Drive within an hour.

  1. Open the Products & Services panel and click Orders.
  2. Click Export data, then click Auto-Export Orders.
  3. Click Connect beside Google Drive, then follow the prompts to allow access.
  4. Choose One spreadsheet for all orders or Individual spreadsheets by product. Individual spreadsheets include add to cart form responses, plus a single spreadsheet with all orders.
  5. If you chose One spreadsheet for all orders, enter a spreadsheet name, then click Save.
  6. If you chose Individual spreadsheets by product, enter a Drive folder name, choose a spreadsheet option from the dropdown menu, then click Save. You can create spreadsheets for every product, or only those with forms.

Auto-export orders to Zapier

Send orders to Zapier and build automated workflows with other third-party services:

  1. Open the Products & Services panel and click Orders.
  2. Click Export data, then click Auto-Export Orders.
  3. Click Connect Zapier. In the tab that opens, follow the prompts to connect your Zapier account.
  4. Finish setting up your workflows in Zapier.

Is Zapier free to use?

Zapier has free plans, but might charge for a subscription depending on your usage.

Find your exported orders

Where your data lands depends on the export you set up:

  • .csv file - The downloads folder on your computer. Open the file in Microsoft Excel, Numbers, or another spreadsheet program.
  • Google Drive - The folder you named during auto-export setup. Exports for specific products all go to that same folder.
  • Zapier - The third-party service in your Zapier workflow. Check your Zapier account to learn where the data went.

Turn off an auto-export connection

To stop sending orders to Google Drive or Zapier:

  1. Open the third-party tools panel.
  2. Click Orders auto-export.
  3. Beside Google Drive, click Disconnect.
  4. Beside Zapier, click •••, then click Disconnect.

Columns included in an order export

Every order export includes these columns:

  • Order ID
  • Email
  • Financial Status
  • Paid at
  • Fulfillment Status
  • Fulfilled at
  • Currency
  • Subtotal
  • Shipping
  • Taxes
  • Amount Refunded
  • Total
  • Discount Code
  • Discount Amount
  • Shipping Method
  • Created at
  • Lineitem quantity
  • Lineitem name
  • Lineitem price - Partially refunded orders show the full purchase price.
  • Lineitem sku
  • Lineitem variant
  • Lineitem requires shipping
  • Lineitem taxable
  • Lineitem fulfillment status
  • Billing Name
  • Billing Address1 - Details from billing address line 1.
  • Billing Address2 - Details from billing address line 2.
  • Billing City
  • Billing Zip
  • Billing Province
  • Billing Country
  • Billing Phone
  • Shipping Name
  • Shipping Address1 - Details from shipping address line 1.
  • Shipping Address2 - Details from shipping address line 2.
  • Shipping City
  • Shipping Zip
  • Shipping Province
  • Shipping Country
  • Shipping Phone
  • Cancelled at
  • Private Notes
  • Channel Type - Online or in-person.
  • 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.
  • Payment Method
  • Payment Reference
  • Checkout form submissions - Each form field has its own column.
  • Add to cart form submissions - Only included in exports for specific products. Each form field has its own column.

Why are some rows missing data?

A cell will be blank if there’s no data to display. For example, if there was no discount code applied to the order, the Discount code column will be empty.

If an order contains multiple products, details that apply to the whole order (like Order ID, financial status, and shipping address) appear only in the first row with that order ID. The other rows show lineitem details only.

Why is my export missing checkout or add to cart form responses?

Checkout form responses export with every order. Add to cart form responses export only when you export orders for a specific product, not when you orders for all products. Form fields with duplicate names don't export, so give each field a unique name.

Why didn't my auto-exported order update after I changed its status?

Auto-exported orders don't update in Google Drive or Zapier when order statuses change. To get current statuses, download a new .csv file.

What you can't export

You can export orders for active, visible products only. Exports don't include:

  • Former versions of products. If you rename a product, you can't export orders or custom product forms for the older version.
  • Hidden products.
  • Products on disabled store pages.
  • Add to cart form fields with duplicate names.

Was this article helpful?

Yes No

70 out of 245 found this helpful

Yes No

Export Commerce orders