Prerequisites
Before connecting Shopify to QUANTI, ensure you have:
Shopify Store: An active Shopify store with admin access
Admin Permissions: Store Owner or Staff account with full permissions
Custom App Access: Ability to create and install custom apps in your Shopify store
Store Data: Existing orders, products, or customer data to synchronize
Setup Instructions
Enable custom app development
Log in to your Shopify admin
Go to Settings > Apps and sales channels
Click Develop apps
Click Allow custom app development (if not already enabled)
Confirm by clicking Allow custom app development
Create a custom app
Click Create an app
Enter an app name (e.g., "QUANTI Connector")
Select an app developer from the dropdown ([email protected])
Click Create app
Configure Admin API scopes
Click Configure Admin API scopes
Select the following read access scopes:
Scope
Description
read_all_orders
Access to all orders history
read_products
Products catalog
read_customers
Customer data
read_inventory
Inventory levels
read_locations
Store locations
read_fulfillments
Fulfillment data
read_draft_orders
Draft orders
read_price_rules
Price rules and discounts
read_discounts
Discount codes
read_shipping
Shipping settings
read_returns
Returns data
read_shopify_payments_payouts
Payout data
read_shopify_payments_disputes
Payment disputes
Click Save
Shopify Plus only: The read_gift_cards and read_users scopes are available only for Shopify Plus accounts.
Install the app and get your API token
Click Install app
Confirm by clicking Install
In the API credentials tab, click Reveal token once
Copy and save your Admin API access token — it will only be shown once
Store this token securely. If lost, you'll need to uninstall and reinstall the app to generate a new one.
Find your shop name
Your shop name is the part before .myshopify.com in your store URL.
Example: If your URL is mystore.myshopify.com, your shop name is mystore.
Connect to QUANTI
In QUANTI, click on Connect to Shopify
Enter your Shop Name (without .myshopify.com)
Paste your Admin API access token
Click Validate to verify the connection
Click Next
Select Pre-built Tables
Review the available pre-built tables (see section below for details)
All tables are selected by default - you can deselect tables you don't need
Recommended: Keep all tables enabled for complete e-commerce data tracking
Click Next
Finish setup
Define a sync period and a lookback window - Click save
For the first sync, you have the following options:
Activate auto-sync for recurring syncs based on your sync settings by clicking the switch button
Launch a historical data recovery by choosing your desired dates in the historical data tab
Launch a manual sync immediately by clicking the Sync now button
Wait for the sync to complete. Then navigate to your data warehouse to verify that tables are populated
Check the connector dashboard for sync status and any potential errors
Pre-built Tables
Shop: Table de configuration contenant les informations générales de la boutique Shopify : identité, localisation géographique, devises, paramètres fiscaux et fonctionnalités activées. Toutes les données sont en lecture seule et représentent l'état actuel de la boutique.
Order: Table transactionnelle centrale capturant l'ensemble du cycle de vie d'une commande : création, paiement, expédition, annulation et remboursement. Contient les données client, les montants financiers (prix, taxes, remises), les statuts de paiement et fulfillment, les informations d'attribution marketing (landing_site, referring_site) et les codes promo utilisés.
Order_line: Table transactionnelle détaillant chaque produit/variante acheté dans une commande. Contient les informations produit (SKU, titre, variante), les données financières (prix, remises ventilées, taxes) et le statut logistique (fulfillment, quantités expédiées).
Notes
Data Refresh: Shopify data can be synchronized multiple times per day
Historical Data: Full historical data is available with no API limitations on date ranges
Order Data: Orders include complete financial details including line items, shipping, taxes, and discounts
Multi-Currency: If your store uses Shopify Payments with multi-currency, amounts will be in the presentment currency
Metafields: Custom metafields are not included by default but can be added upon request
API Rate Limits: Shopify enforces rate limits based on your plan tier (Basic: 2 req/s, Shopify: 4 req/s, Advanced/Plus: 10 req/s). QUANTI automatically manages these limits
Deleted Records: Deleted products, orders, or customers can be tracked if enabled in sync settings
GraphQL vs REST: The connector uses Shopify's Admin API (REST) for maximum compatibility
Webhooks: Real-time webhook support can be configured for instant updates on order creation/updates
Privacy: Customer data complies with GDPR and privacy regulations