To establish a Shopify → Google BigQuery pipeline, follow the steps outlined below.
Step 1: Share your "Shopify store name" with the OWOX manager
Locate the name of your Shopify store in the URL. For instance, if your URL is https://TEST.myshopify.com, then the name would be 'TEST'. Alternatively, find it within the Store details section of your Settings.
Step 2. Create a Custom App (skip if you already have one)
Authentication to the Shopify API requires a custom application. Follow these instructions to create a custom app and find your Admin API Access Token:
2.1. Navigate to Settings > App and sales channels > Develop apps > Create an app.
2.2. Name your new app.
2.3. Select Configure Admin API scopes.
2.4. Tick all the scopes prefixed with read_:
read_analytics
read_assigned_fulfillment_orders
read_gdpr_data_request
read_locations
read_price_rules
read_product_listings
read_products
read_reports
read_resource_feedbacks
read_script_tags
read_shipping
read_locales
read_shopify_payments_accounts
read_shopify_payments_bank_accounts
read_shopify_payments_disputes
read_shopify_payments_payouts
read_content
read_themes
read_third_party_fulfillment_orders
read_translations
read_customers
read_discounts
read_draft_orders
read_fulfillments
read_gift_cards
read_inventory
read_legal_policies
read_marketing_events
read_merchant_managed_fulfillment_orders
read_online_store_pages
read_order_edits
read_orders2.5. Click the Save button.
2.6. Click the Install app to give this app access to your data.
2.7. Once installed, go to API Credentials to copy the Admin API Access Token.
Step 3. Share your "Admin API access token" with the OWOX manager
To ensure a seamless connection between Shopify and BigQuery, provide the OWOX manager with the Admin API access token you obtained in the previous step. This token grants OWOX the necessary permissions to securely access and retrieve your Shopify data for integration with BigQuery.
Final. Now you're all done!
0 Comments