When integrating your Shopify store with Google Analytics 4 (GA4), the item ID typically follows this format:
shopify_COUNTRY_ProductID_VariantID
Example:
shopify_se_8733325066578_47627007492434
To ensure correct data mapping between Google Analytics and PriceShape, the ID format in PriceShape must match the format used in GA4. This allows the system to correctly associate analytics data with the corresponding products.
All required IDs are available for PriceShape. It simply needs to be structured correctly in an output feed and added as a subfeed.
Step 1: Check the IDs in PriceShape
Search for the ProductID and VariantID in the Product List.
If both IDs exist → go to Step 3
If one or both are missing → continue to Step 2
Step 2: Map missing data (If needed)
Go to Feed → Input Feeds
Click the three dots (⋯) on the relevant feed
Select Edit Feed
Open Step 2 – Mapping
The ID field is mapped by default to ID.
If needed, map the relevant IDs, for example:
Product > id → SKU
(or another relevant custom attribute in the category ID).
Save your changes.
Step 3: Create the output feed
Go to Feed → Output Feeds.
Click Create New Output Feed.
Navigate to Step 2: Product Selection.
Set the filter to “Feed is XXX.”
Go to Step 3: Product Attributes.
Under Own Attributes, add the following fields:
ProductID
VariantID
UPI (required)
The UPI must be included, as this feed will be used as a subfeed.
Step 4: Construct the GA4 Item ID
Create a new sheet (tab) in the same spreadsheet.
You can use a formula in your spreadsheet to construct the GA4 item ID.
You can use:
=ARRAYFORMULA("shopify_xx_" & 'Sheet1'!B:B & "_" & 'Sheet1'!A:A)
or
=ARRAYFORMULA("shopify_xx_"&B2:B&"_"&D2:D)
This formula:
Adds the prefix (e.g.,
shopify_xx_)Combines ProductID and VariantID
Applies to the entire column automatically
Final sheet structure:
Column 1: UPI
Column 2: GA4 Item ID
Example result:
UPI | GA4 Item ID |
8733325066578 | shopify_se_8733325066578_47627007492434 |
Step 5: Add the output feed as a subfeed
Verify the column structure:
Column 1 → UPI
Column 2 → GA4 Item ID
Send the file or feed URL to:
[email protected]
The support team will connect the subfeed to your main feed.
Step 6: Field Mapping
Once connected:
UPI → ID
GA4 Item ID → SKU or MPN
The GA4 ID must be mapped to an allowed identifier field (e.g., SKU or MPN).
Matching the ID format ensures:
Correct data mapping between Google Analytics and PriceShape
Accurate product-level analytics
Proper performance tracking
If the format does not match exactly, PriceShape will not be able to associate GA4 data with the correct products.