Skip to main content
Beta feature - This feature is currently in beta. If you’d like to use it, please ask us on live chat.
Data warehouse export keeps a copy of your storekit data in a warehouse you own. Orders, order items and taxes, menus, payments and refunds land as ready-to-query tables, so your analysts and BI tools work against the same data storekit does, without exporting CSVs or polling the API. storekit runs the export through its partner Prequel.

How It Works

  • Once a day. New data is synced to your warehouse once a day by default. Owners and admins can also click Sync now on the Data export page.
  • You own the destination. Data is written into a Snowflake account or an Amazon S3 bucket in your own cloud account.
  • One export per account. The export is set up once for the whole account, not per store. Every table carries the store, so you can report per store or across the whole group.

What Is Exported

The export has these datasets, in this order on the Data export page: Customer records and the browsing events described in Event Tracking are not exported.
Treat the exported tables with the same access controls you apply to storekit itself; see the Security Policy for how storekit handles this data on its side.

Supported Destinations

The list is fixed:
  • Snowflake
  • Amazon S3
If your warehouse is not listed, contact our team.

Getting Set Up

Data export is a beta feature that storekit turns on per account. Once it is on, Data export appears under Integrations. Only account owners and admins can change its settings; other members see the page read-only.
1

Open Data export

In the sidebar, click Integrations, then Data export.
2

Choose your warehouse

Under Connect your warehouse, pick Snowflake or Amazon S3 as the Warehouse, then enter your Snowflake account host (for example ABCDEFG-XY12345.snowflakecomputing.com) or your S3 bucket name.
3

Enable the export

Click Enable data export. A connection link from Prequel appears on the page and is also emailed to you. The link can be used once.
4

Connect your warehouse

Open the link and follow Prequel’s steps to give it access to your warehouse. The Connection status changes from Link sent, waiting for connection to Connected.
Once connected, the page shows the export’s Health, Schedule, Datasets, Last transfer and Where to find your data. In Snowflake, your database and schema appear after the first sync.

Frequently Asked Questions

Syncs run once a day rather than in real time. If you need to react to an order the moment it happens, for example to trigger a kitchen workflow, use webhooks instead and keep the warehouse for reporting.
No. The dashboard reports stay as they are. The export is for teams who want to combine storekit data with other sources, build their own dashboards, or keep a long-term archive under their own control.
No. Data warehouse export is one-way, from storekit to your warehouse. To change menus, stock or store settings, use the dashboard or the API.
The Connection status changes to Disconnected, for example after you rotate the warehouse credentials. Click Generate a new link and connect again. Last transfer says whether a failure came from your warehouse, from storekit or from Prequel.
Click Disable data export. Daily syncs stop, and data already exported stays in your warehouse. You can enable the export again later.
Contact our team for pricing for your account.