Exporting Orders in Squarespace
TL;DR:
- Export orders, membership orders, and custom product form submissions to CSV files
- Use filters to refine data by order status, date range, and specific products
- Only current and active products can be exported
- CSV includes order details, payment info, and shipping data
- Custom form submissions can be included in exports
Exporting your Squarespace orders gives you a spreadsheet with all your sales data. This is handy for accounting, analyzing sales trends, or keeping records outside of Squarespace.
How to Export Your Orders
Head to your Squarespace dashboard and navigate to Products & Services, then click Orders. You'll see the export options at the top of the page.
Filter by Order Status
You can choose which types of orders to include:
- Pending – Orders that haven't been fulfilled yet
- Completed – Finished orders
- Cancelled – Orders that were cancelled
Tick the boxes for the order types you want. Most people export all three to get the full picture.
Set Your Date Range
Use the Include Orders From dropdown to choose your timeframe:
- Last 30 days
- Last 90 days
- This year
- All time
- Custom date range
For custom ranges, pick Specific date range and set your start and end dates.
Choose Specific Products
By default, Squarespace exports all products. To focus on specific items:
- Select Specific Product instead of All Products
- Choose the product from the dropdown
- Tick Include product form data if you want custom form submissions
Remember, you can only export data for products that are currently active on your store. Hidden or deleted products won't appear in the export options.
What's in the CSV File
The exported file opens in Excel, Numbers, or any spreadsheet app. It contains several columns of data:
Order Information
- Order ID and date
- Sales channel (online store, etc.)
- Order status
Payment Details
- Transaction totals
- Payment method
- Refund information
- Transaction status
Product Information
- Product names and SKUs
- Quantities ordered
- Individual prices
- Product variants
Customer Information
- Billing addresses
- Shipping addresses
- Customer contact details
The file can get quite wide with lots of columns, so you might want to hide columns you don't need for easier viewing.
Common Issues and Solutions
Missing products in export options: Only active products show up in the export filter. If you need data for a product that's no longer active, you'll need to temporarily make it active again.
Custom form data not appearing: Make sure you ticked Include product form data before downloading. Also check that your product forms have proper field names set up.
Large date ranges taking time: Exports with thousands of orders can take a few minutes. Squarespace will email you the download link when it's ready.
FAQs
Can I export orders for specific products only?
Yes, select "Specific Product" during the export process to filter by individual products.
Can I export data for hidden or deleted products?
No, only active products that are currently visible on your store can be exported.
How do I include custom product form submissions?
Tick the "Include product form data" checkbox before downloading your export.
What format is the exported file?
Squarespace exports to CSV format, which opens in Excel, Numbers, or Google Sheets.
Is there a limit to how many orders I can export?
No, but very large exports may take longer to process and will be emailed to you.
Jargon Buster
CSV – Comma Separated Values, a file format that stores data in rows and columns, readable by spreadsheet applications
Order Status – Whether an order is Pending, Completed, or Cancelled
SKU – Stock Keeping Unit, a unique code that identifies each product or variant
Wrap-up
Exporting your Squarespace orders is straightforward once you know where to find the controls. Use the filters to get exactly the data you need, whether that's all orders from the past month or just sales of a specific product. The CSV file gives you all the details you need for accounting, analysis, or keeping your own records.
Ready to dive deeper into Squarespace? Join Pixelhaze Academy for more detailed tutorials and expert tips.