Exporting Data Out of Commerce7.

All data on Commerce7 can be pulled out via our API's - but if you're not a developer, using our bulk export tool will be much easier. 

Using our export tool, you can export all or filtered orders, products, customers, club members and reservations. The data is pulled out as a CSV file and can be opened in Excel, Google Sheets, Numbers, etc. We would recommend working in Google Sheets as this program requires the least amount of formatting. If you use Excel, some light formatting may be required such as formatting the "date" column to a "string date".

To get started, navigate to either the orders, customers, products, or club members section of the admin, and filter your data is desired. Then click the "export" button. 

 

 

You'll be prompted to select whether you'd like to export the data as you've filtered it, or all of the data. 

Note: On an order export you have the option to 'Include Items (Order Details), select this if you want order details in your report.

 

order export-3

After exporting, a message will pop up alerting you that your CSV file has been emailed to you. 

 

 

Inside the email, you'll find a button to download your data export. 

 

 

To view your previous exports, navigate to "settings > data exports" in the admin panel. If an export was created within the last hour, you'll be able to download it from this page.