How to export Orders data from Squarespace

Let’s explore the way to export Squarespace Orders data to a .csv file to analyze via third-party services

Export orders

1. From the Admin Home Menu, go to Selling > Orders.

2. In the top right corner, click or Download CSV.

Squarespace Export Orders

Filter the export by Order Status

1. Check or uncheck the status to export. There are 3 Fulfilment statuses to choose Pending orders, Completed orders, and Cancelled orders.

2. Click Download.

Step-by-step tutorial included

6 STEPS

1. Go to Admin Home Menu and click Selling

2. Click Orders

3. Click Download CSV

4. Check or uncheck the statuses to export

5. Click Download

6. That's it. You're done.

Here's an interactive tutorial

** Best experienced in Full Screen (click the icon in the top right corner before you begin) **

https://www.iorad.com/player/2364442/Squarespace---How-to-export-Orders-data-by-Status

Next step

Filter the export by Order Date

The date range is based on when orders were created.

1. Select a date range from the Order Date drop-down menu.

2. You can choose between 13 date range options in the menu.

   1. All time will select all orders from beginning

   2. Specific date range to set a custom time window

3. Click Download.

Step-by-step tutorial included

10 STEPS

1. Go to Admin Home Menu and click Selling

2. Click Orders

3. Click Download CSV

4. Click Order Date dropdown

5. You can choose default ranges or create custom range Specific date range

6. Choose Start date

7. Click Select

8. Choose End date

9. Click Download

10. That's it. You're done.

Here's an interactive tutorial

** Best experienced in Full Screen (click the icon in the top right corner before you begin) **

https://www.iorad.com/player/2364444/Squarespace---How-to-export-Orders-data-by-Order-Date

Next step

Filter product details

By default all products will be exported, you can choose specific product to be exported

1. Select All products to download orders for all products. All exports will include Custom Checkout Form, with each form field in its own column.

2. Select Specific Product, you should be able to start typing the name of a product and then select it from a list.

3. Check Include product form data to include Custom Product Form submissions in the .csv.

4. Click Download to export.

Step-by-step tutorial included for Specific Product

8 STEPS

1. Go to Admin Home Menu and click Selling

2. Click Orders

3. Click Download CSV

4. Click Specific product

5. Enter search by product

6. Choose the Product

7. Check Include product form data selected if needed

8. Click Download

Here's an interactive tutorial

** Best experienced in Full Screen (click the icon in the top right corner before you begin) **

https://www.iorad.com/player/2364446/Squarespace---How-to-export-Orders-data-by-Specific-product

Next step

What is in the exported data

You can open the .csv file with text editor or any spreadsheet application such as MS Excel or Google Sheets, the .csv contains

• 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

FAQs for the exported Orders data

Question: How can I open the csv file?

You can open the file with any text editor or spreadsheet program such as MS Excel or Google Sheet

Question: Can the csv file contains Orders which have multiple products?

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

Question: How can get insights and answers from the Orders data?

You can use program like MS Power BI, Google Data Studio to import the file and generate analysis from it, or you can utilize Conduit's AI analysis features. These tools enable you to import the exported .csv file and generate insights, reports, and visualizations in a ChatGPT-like interface, help you give questions to your dataset in plain English

Conduit Copilot interface

Check out Introducing Condui AI analyst