When you install Datadrew from the Shopify App Store, our app automatically connects to your Shopify store through Shopify's secure app authentication. There is no separate login or API key required for your Shopify data -- it flows into Datadrew as part of the standard app installation.
What Datadrew accesses from your Shopify store
Datadrew reads the following data from your Shopify store to power your analytics dashboards and Drew AI insights:
Orders -- Your complete order history including line items, discounts, shipping, taxes, and fulfillment status. This is the foundation for revenue analytics, product performance, and customer lifetime value calculations.
Customers -- Customer profiles including email, name, order count, total spend, and tags. Used for RFM segmentation, new-vs-returning analysis, and cohort breakdowns.
Products -- Your product catalog including titles, variants, prices, inventory levels, and images. Powers product performance dashboards and cart analysis.
Product images -- Product image URLs used to display product visuals in your dashboards and AI-generated reports.
Refunds -- Order refund data including reason codes and amounts. Ensures your revenue metrics reflect net (not gross) figures.
Shop details -- Basic store configuration like currency, timezone, and store name. Used to format your reports correctly.
How the data sync works
After you install Datadrew, your Shopify data is synced automatically through our managed data pipeline (powered by our data pipeline). Here is what to expect:
Initial sync -- Your full order, customer, and product history is pulled into Datadrew. Depending on your store size, this may take anywhere from a few minutes to several hours.
Ongoing syncs -- After the initial sync, Datadrew pulls new and updated records on a regular schedule. Most data types use incremental syncs, meaning only changed records are fetched.
Data transformation -- Once raw data lands in our warehouse, our our data transformation layer pipeline transforms it into analytics-ready tables. This is what powers your dashboards, metrics, and AI queries.
Sync frequency
Starter plan -- Data syncs once every 24 hours.
Pro plan -- Data syncs every hour for near-real-time reporting.
Data security and privacy
Your Shopify data is stored securely in Google our data warehouse (EU region) with strict tenant isolation. Each store's data is kept in its own dataset, and row-level security ensures no cross-store data leakage. Datadrew never modifies or writes data back to your Shopify store.
We are fully compliant with Shopify's mandatory GDPR webhooks. If a customer requests data deletion through your Shopify store, the request is automatically processed.
Disconnecting
If you uninstall the Datadrew app from Shopify, your data connection is automatically severed. You can also manage your Shopify integration from Settings > Integrations within the Datadrew app.
Need help? Contact us at support@datadrew.io.
Related articles
Need help?
If you have questions or run into issues, reach out to us at support@datadrew.io or use the in-app chat. We're happy to help.