How to Integrate Shopify with Wicked Reports

Table of Contents

1. Introduction To Shopify Integration
   1. Steps to Integrating Your Shopify Store
   2. Steps to Manually Add Tracking To Your Checkout Process
   3. Steps to Complete Your Subscription Setup*
   4. Steps to Validate Your Revenue
2. What's Next?
3. Troubleshooting
4. FAQ

Introduction To Shopify Integration

Integrating Shopify with Wicked Reports ensures that all essential order details are passed into Wicked Reports. In addition, this integration will automatically add our tracking code directly to your store. 

• If Shopify is your "source of truth" OMS, storing all of the orders Wicked Reports needs to attribute, then you can use Shopify as a standalone integration.
• If you're integrating Shopify and other Order Management Systems, then you'll need to ensure that the orders stored in Shopify are unique and stored only Shopify. Otherwise, you're other order management systems will send duplicate orders into Wicked Reports.

What is the Shopify Setup Process?

The Shopify setup process is as follows:

1. Integrate Your Shopify Store
2. Manually Add Tracking To Your Checkout Process
3. Complete Your Subscription Setup*
4. Validate Your Revenue

Once you've completed all four steps, your Shopify integration will be complete and reliably set up to successfully track and attribute data. Let's begin.

Steps to Integrating Your Shopify Store

As of January 1, 2026, Shopify updated its Apps feature, which makes the integration process slightly more complex than before.  We’re now in the process of  optimizing our Shopify integration to make this setup as seamless as possible. For now, please follow the steps below to create your app and integrate it with your Wicked Reports account.

If you have any questions or run into issues, reach out to support@wickedreports.com and our team will be happy to help.

 

Create a Shopify Custom App

1. Log in to your Shopify Store.
2. In the left nav bar, press Apps.
   
3. In the drop-down menu, select App and sales channel settings.
   
   
4. Select Develop Apps.
   Note: You need to be either the store owner or have the "Enable app development" permission to see buttons related to App Development. 
   
5. In the App Development page, select Build apps in Dev Dashboard.
   
   
6. Click Create app.
   
7. Enter an app name.
   Example: Wicked Reports
   
   
8. Click Create.
   

Configure Distribution Model

1. In the left navigation, select Versions.
   
2. Navigate to the Access section.
   
3. Click Request access to open it a new tab
   Note: If you don't see "Request Access", then you already have access. Skip to Configure & Release Your App, Step 6 and continue your integration steps from there.
   
4. In the Request additional scopes and APIs section, click Choose distribution.
   
5. Select Custom distribution.
   
6. Click Select custom distribution.
   
7. Add your Shopify store domain.
   Note: This is found in your App and sales channel settings page
   
8. Click Generate link twice.
   
9. Copy the Install link.
   
10. Open the install link in a new browser tab.
    
11. Select your store.
    
12. Click Install.
    

Enable Read_All_Orders Permission

1. Return to the Shopify Dev Dashboard tab.
2. Click Request access again.
   
3. Scroll to the Read All Orders Scope section.
   
4. Click Request access.
5. Add a reason for the request.
   Example: Adding historical order data to Wicked Reports
6. Submit the request.
   

Configure & Release Your App 

1. Return back to the Dev Dashboard.   
   
   
2. Select your App
   
3. Go to the Versions page
   
4. Press Create A Version
   
   
5. Go to the Access section
   
6. Click Select scopes.
   
   
7. Filter by Admin API.
   
8. Select the following scopes:
   
   
   • read_all_orders
   • Read_orders
   • Write_orders
   • read_customers
   • Read_products
   • Write_products
   • Read_script_tags
   • Write_script_tags
   • Read_content
9. Press Done to add your scopes.
10. In the Access scopes section, select Use legacy install flow.
    
11. In the Redirect URLs field, add the following URL:
    
    1. https://my.wickedreports.com/shopify_token.php
12. Click Release.
    
13. In the popup:
    
    
    1. Set the version name to v1 (or something similar)
    2. Click Release

Update your Apps Data Access

1. In the left navigation of your Dev Dashboard, select Settings.
   
2. Copy your Client ID.
   
3. Save it temporarily.
4. Replace the placeholders, in the URL below, with your Shopify Shop Name and Shopify Client ID.
   1. https://YOUR_SHOP_NAME.myshopify.com/admin/oauth/authorize?client_id=YOUR_CLIENT_ID&scope=read_customers,read_orders,read_all_orders,write_orders,read_products,write_products,read_script_tags,write_script_tags,read_content&redirect_uri=https://my.wickedreports.com/shopify_token.php&state=wicked_reports
   2. For reference:
      1. Your Shopify Shop Name can be found on the App and sales channel settings page. Example:
         
      2. Your Shopify Client ID is what you just copied in the last step.
5. Paste the updated Authorization URL into your browser’s address bar.
   
6. Press Enter.
7. Update data access by pressing Update and then stay on your Authorization Page.
   Note: If an update page is not available, just press install on the install page and continue on.
   

Generate your Permanent Access Token

1. In a new tab, return back to the Dev Dashboard.   
   
   
2. Select your App
   
3. In the left navigation of your Dev Dashboard, select Settings.
   
   
   1. Copy your Client ID.
   2. Copy your Secret.
4. Return to your Authorization page
   
   
5. Enter your Credentials
   
   
6. Press Exchange for Access Token
   
7. Copy your Permanent Access Token.
   Note: Your Admin API token will begin with shpca.
   
8. Keep this page open until you've finished the authorization below.

Connect Shopify within Wicked Reports

1. Log in to your Wicked Reports account.
2. Navigate to:
   Setup > Authorizations
   
3. Click Connect next to Shopify.
   
4. Enter:
   
   
   • Your Shopify Store URL
   • Your Shopify Admin API Token
     Note: This is your Permanent Access Token that starts with shpca. Not shpat, as that's for legacy users.
5. Click Authorize.

Great! Well done. With that being completed, our tracking code will be automatically added to your store and you'll see orders flowing into your Wicked Reports account by tomorrow morning.

Please continue to the next section, Steps to Manually Add Tracking To Your Checkout Process, to progress through your Shopify Setup Process.

Steps to Manually Add Tracking To Your Checkout Process

Adding our custom tracking code, on your Shopify Checkout Page, is crucial for attribution. However, Shopify does not currently allow us to update your Checkout automatically. Rather, it requires a manual process to add the custom tracking code.

• To install the custom tracking code, you’ll need to create a Custom Pixel and install the Custom Tracking Code onto your Checkout Page. This will enable us to properly track Checkout opt-in submissions.
• Please follow this guide for more details.

Once completed, your Checkout process will be fully configured for effective tracking. Continue to the next step to progress through your Shopify Setup Process.

Steps to Complete Your Subscription Setup*

• Native
  If you're using a Native Shopify APP for subscriptions, then no additional setup step is required. Your subscriptions will automatically track using Shopify's variant_ID. 
• Recharge
  If you're using Recharge for subscriptions, and you are using their Product Subscription Plans, then additional setup steps are required. Please read here to learn How To Integrate Recharge for Shopify.
  
• Alternative Platform
  If you're using an alternative third-party platform to manage your subscriptions, then please reach out to our support team. We'll help you identify if any additional setup steps are required.

Once completed, your subscription setup will be fully configured. Continue to the next step to progress through your Shopify Setup Process.

Steps to Validate Your Revenue

Wicked Reports Gross Revenue often has a small variance when comparing to your Shopify Gross Revenue after completing your integration. However, verifying your revenue is important because it ensures your integration is set up and orders are flowing in properly. When verifying, we expect the data to be within a 3% margin due to these common causes:

• Time zone differences between your source system and Wicked Reports (EST).
• Not comparing Gross to Gross and/or differences in how these values are calculated.
• You have orders that are entered with back-dates, edited days later, or deleted days later.

To quickly validate your revenue, wait one day after the integration is authorized. After,

1. Login to your Wicked Reports Account
2. Go to the Funnel Vision Report
3. In your filters, Select a 7 day date range
4. In your attribution settings, select Gross Revenue 
5. Compare your accounts summary metric "Total Revenue" to Shopify's Gross Revenue

This test is simply designed to validate that orders are flowing through. It's not designed to be an exact match with Shopify's Dashboard. If the comparison is within 3%, then your system is correctly integrated and your Shopify Setup Process is completed! If your comparison has over a 3% discrepancy, then please reference the troubleshooting section below before moving forward. 

What's Next?

• Historical Orders
  Wicked Reports will now automatically retrieve your entire Shopify order history for cohort and customer lifetime value reporting.
• When will I see my data?
  Each morning, at about 12:00 pm UTC, Wicked Reports updates its database. This is when we will retrieve the previous day's Shopify orders, attribute them back to clicks, leads, and ad spend, and update your reports.

Troubleshooting

• Are you having difficulty trusting your Shopify Integration?
• Do you feel like something is off or missing?
• Are you experiencing one of these issues?
  
  • My Gross revenue is different from what's in Shopify Dashboard.
    
    • Primarily, differences in Shopify's Gross Revenue come from a difference in the way our systems calculate Gross Revenue.
    • If you're still not confident in the accuracy of your order data within Wicked Reports, then run through this Revenue Validation Test.
      • This test is designed to compare Shopify's Gross spreadsheet data with Wicked Reports Gross spreadsheet data. It gives a more "apples to apples" comparison and is highly effective at ensuring the Shopify/Wicked integration data is accurate. With this accuracy confirmed, you can rest easy knowing the differences between the two platforms is simply the way we calculate Gross.

• • My Net Revenue is different from what's in Shopify's Dashboard.
    • Primarily, differences in Shopify's Net Revenue come from a difference in the way our systems calculate Net Revenue.
    • Secondarily, Shopify's Net Revenue will show refunds for past orders in current reports (the date the refunds came in). However, Wicked Reports shows refunds for past orders in past reports (the date those orders were originally created.)
    • That being said, if you're not confident in the accuracy of your data within Wicked Reports, then run through this Revenue Validation Test.
      • This test is designed to compare Shopify's Gross spreadsheet data with Wicked Reports Gross spreadsheet data. It gives a more "apples to apples" comparison and is highly effective at ensuring the Shopify/Wicked integration data is accurate. With this accuracy confirmed, you can rest easy knowing the differences between the two platforms is simply the way we calculate Net.

• • I have attributed leads and sales, but less than what Shopify attributes.
    • If so, run through the Tracking Validation Routine.
    • The Tracking Validation routine is a series of tests designed to validate your tracking setup; locate issues and bring your tracking up to the highest quality standard. If you're currently experiencing a tracking issue, then this routine is designed to find it.

If you're still experiencing one of these issues after running through the tests, or if you're facing any other issues, then please contact our customer support team and we'll help get things squared away!

FAQs:

1. How can I optimize my Shopify Tracking performance?
   

   1. You can manually move the Wicked Reports tracking code directly before the </body> tag in the theme template.

   2. You can turn off lazyload for the Wicked Reports script in your Shopify Account
2. How do I track a non-Shopify Checkout Page?
   If you have a checkout page that allows our tracking script to be directly added to it or through GTM, then that's exactly what you should do. Otherwise, you'll need to set up a trackable Thank-You Page. Reach out to support if you'd like assistance.
3. I have orders coming into stores that aren't in Shopify. What should I do?
   1. If you notice orders from sources outside your Shopify store, ensure accurate tracking by authorizing additional order sources through the Setup->Authorizations menu.
   2. Only authorize sources that generate unique orders not already present in your Shopify store. If you exclusively use Stripe for processing Shopify orders, there's no need to authorize it separately; simply authorize Shopify for comprehensive tracking.
      
4. Can I filter/block orders from coming into Wicked via Shopify Tag?
   Yes. If you would like to do this, then please open a support ticket or email support@wickedreports.com with the tag(s) you'd like to filter with. We will then have our development team activate this for you.
   Note: If you filter by tags, you're Shopify dashboard revenue will no longer align with the revenue in Wicked Reports.
5. Can I choose only to send in select orders via Shopify Tag?
   Yes. If you would like to do this, then please open a support ticket or email support@wickedreports.com with the order tag(s) you'd like to have sent to Wicked. We will then have our development team activate this for you.
   Note: If you only send in select orders by tags, you're Shopify dashboard revenue will no longer align with the revenue in Wicked Reports.
6. Will Wicked Reports report on the product information in my Shopify account?
   

   Yes, we report off the product names in your Shopify store. Note: For this to work, you'll need to create products in Shopify and then have your Shopify checkout use those products as line items of the order. If you do not use product names, the product attribution and product reporting will not equal your daily sales

7. Does Wicked Reports support Up-Sell Software with Shopify?
   Yes, Wicked Reports seamlessly integrates with both CartHook and Zipify's One Click Upsell, ensuring accurate tracking and reporting of upsell orders. If you utilize a different upsell software, then please reach out to support@wickedreports.com for additional details.
8. Does Wicked Report work with my Subscription Software?
   Please read Steps To Complete Your Subscription Setup.
9. How do I get my historical data attributed?
   By default, this data will be attributed as Pre-Wicked. However, if you have tracking (or, attribution) data stored in their CRM from your past efforts, you can send it to Wicked Reports.  We will then attribute your custom tracking data to Shopify sales & revenue. You can learn more here. 

10. Does the Shopify integration automatically pull in all contacts, even if no sale is associated?
    Yes. Once connected, the Shopify integration will pull in all contacts from your Shopify account, including contacts that do not yet have an associated order or completed purchase. 

11. How does Wicked Reports report the breakdown of Gross & Net for Shopify Sales compared to Shopify? 
    Shopify's Dashboard Formula:

    1. Gross Revenue = Product Price x Quantity Sold (excluding taxes, discounts, returns, etc...)

    2. Net Revenue = Gross Revenue - Discounts - Returns/Refund

    Wicked's Dashboard Formula for Shopify
    1. Gross Revenue = Shopify's Gross Revenue + shipping + tax 
    2. Net Revenue  = Shopify's Gross Revenue - refunds - discounts + shipping + tax
    Example Order from Shopify:
    1. Shopify's gross revenue figure is $83.96
    2. Wicked's gross revenue figure is $83.96 + $6.24 = $90.2