Download a .csv file or auto-export orders and form data to Google Drive.

Export Commerce orders to analyze sales data or manage orders outside of Squarespace. Order exports for specific products include Add to cart and Checkout form responses.

Exporting via .csv is available on all plans. Auto-exporting to Google Drive is available on the Business, Commerce Basic, Commerce Advanced, Core, Plus, and Advanced plans. Auto-exporting to Zapier is available on all plans.

Export orders to a .csv file

To export orders to a .csv file:

1. Open the Products & Services panel and click Orders.
2. Click Export data, then click Download CSV.
3. Select the order statuses to include in the export.
4. Select a date range. This is based on when orders were created, not when you marked them as fulfilled.
5. Select All products or Specific product.
6. If you selected All products, click Download.
7. If you selected Specific product, search for and select a product. Only active products on enabled store pages will appear. By default, the export for specific products includes Add to cart form data. Uncheck the box to exclude these responses. Click Download. 

Auto-export orders to Google Drive

You can automatically send orders to a sheet or folder in Google Drive. New orders export in under 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 and follow the prompts to allow access.
4. On the auto-export page, select One spreadsheet for all orders or Individual spreadsheets by product. Individual spreadsheets by product include add to cart form responses. If you choose this option, you’ll get per-product spreadsheets in addition to a single spreadsheet containing all orders.
5. If you chose One spreadsheet for all orders, enter a spreadsheet name and click Save. 
6. If you chose Individual spreadsheets by product, enter a Drive folder name (this is where all export spreadsheets will live in Google Drive), and choose a spreadsheet option from the drop-down menu. You can create individual spreadsheets for every product, or only those with forms.
7. When you’re finished, click Save.

Auto-export orders to Zapier

On all plans, you can send orders to Zapier to build automated workflows with other third-party services. Zapier has free plans, but may require a paid subscription based on your usage.

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.

Find your exported orders

Depending on how you made the export, you can find your exported data in:

• The downloads folder on your computer. You can open this .csv file in Microsoft Excel, Numbers, or another spreadsheet program.
• Your Google Drive. Order exports for specific products all go to the same folder, which you named during the auto-export setup process.
• The third-party service you built into your Zapier workflow. Zapier acts as a wire between your Squarespace orders and a number of third-party apps. Check your Zapier account to see 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 the … icon, then click Disconnect.

What’s included in the export

• 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 display 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 will be in its own column.
• Add to cart form submissions - Only included in order exports for specific products. Each form field will be in 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.

Also, if the order contains multiple products, details that apply to the entire order (like Order ID, financial status, and shipping address) will only appear in the first row that has the order ID. Rows for other products within the same order will only display the lineitem details. 
 

What doesn’t export

Order exports don’t include:

• Former versions of products. For example, 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. Ensure your form fields are unique.
• Order status updates. Auto-exported orders don’t update in Google Drive or Zapier when you change the order status.