Missing POS Location Name Data in Shopify

Missing POS Location Name Data in Shopify

Info
If you're seeing blank or missing data or "0" values for metrics when using the POS Location Name dimension in your Shopify reports, this article will help you resolve the issue. This problem occurs when your Shopify connection doesn't have the required permissions to access Point of Sale location data.

Issue

When using the field POS Location Name as a dimension in Shopify reports, metrics may show "0" values, missing data, or blank values.

Cause

The POS Location Name field requires a specific permission called the read_locations scope to display data in your reports. This scope is enabled by the View store data permission in Shopify. This means:
  1. Customers may see blank data or "0" values for metrics using POS Location Name as a dimension
  2. Your other metrics and data will display correctly; only metrics using the POS Location Name dimension are affected

Solution

To obtain POS Location Name data in your reports, you'll need to manually reconnect your Shopify data source and grant the additional permissions:

Step 1: Disconnect Your Shopify Data Source

  1. Go to your Power My Analytics Hub at hub.powermyanalytics.com
  2. Click on Sources in the left navigation panel and find your Shopify data source in the list.
  3. Click the three-dots Action menu next to your Shopify source.
  4. Select Remove source from the dropdown menu.
  5. Click Confirm to disconnect the data source.
For more information on managing data sources in your hub, please see Manage and Configure Data Sources.

Step 2: Reconnect Your Shopify Data Source

  1. Click the orange + Add new source button above the main sources table.
  2. Select Shopify from the data connector gallery.
  3. Follow the connection process to install the Power My Analytics app from the Shopify app store.
  4. When prompted, grant all requested permissions, including the read_locations scope (View store data permission).



  5. Complete the connection process. Your Shopify data source is now reconnected to your Power My Analytics hub.
Notes
Disconnecting and reconnecting your data source will not impact your existing reports. Your reports will continue to work normally during this process.

Step 3: Backfill Historical Data

After reconnecting, you'll need to manually backfill your historical data to obtain POS Location Name information for past orders:
  1. In your Hub, go to Sources and find your newly reconnected Shopify source.
  2. Click the three-dots Action menu next to your Shopify source and select Backfill data range
  3. Select the time period over which you need to obtain POS Location Names data. The backfilling process will begin.
For more information on backfilling data in your hub, please see Backfill Connection Data.

Need Additional Help?

For additional Shopify troubleshooting resources, see our Basic Troubleshooting guide or submit a support ticket.

    • Related Articles

    • Troubleshooting Shopify

      Most of the difficulties our customers have with Shopify are easy to solve independently without the need to wait for a support ticket reply. This article will help you find everything you need. Try these articles if you are having difficulty ...

    • Shopify Data Connector User Guide

      <div style="overflow-wrap: break-word"></div> <div style="overflow-wrap: break-word"> <div><span class="KB_New_Editor_Highlights" style="background-color: rgb(193, 225, 244); border-right: ...

    • Why Do the Sales Numbers Not Align with My Shopify Sales Reports?

      This article will help you to understand some of the discrepancies you may see between Shopify Sales Reports and the reports you make with our connectors. There are many potential causes for missing or incorrect data in your Shopify report. Time ...

    • How to Connect to Shopify

      The following article provides the steps for setting up your Shopify store to allow PMA's connector to collect data. Prerequisites Before you begin, ensure you have: Store owner access or staff access with all permissions to set up the connection ...

    • Instagram Insights Data Is Missing from My Report

      This article will assist with the following issue: Certain Instagram Insights data is missing. Cause Many of Instagram's Insight key metrics are lifetime. Instagram's API does not collect historical data for lifetime metrics. We will begin saving ...