Hi @Dan
I’m currently sending profit values successfully by pulling data from the Stape server.
Here’s the challenge:
For a store with 50 products, it works fine. But when there are 1K–2K products, and the client wants to update COGS and profit for 500+ items, it becomes hard to manage. We’d need to constantly monitor for changes if we use the Stape store.
The client already maintains a Google Sheet with item_id, retail price, COGS, and profit.
I’ve connected this sheet to Stape and used Stape’s Spreadsheet Reader variable in server GTM to read those data.
Then, I created two custom variable templates:
- One matches
item_idfrom the event data and calculates total profit. - The other handles the logic for discounts and returns the final profit value.
Everything is working correctly so far.
My questions are:
-
Is it a better approach to pull profit from the Google Sheet since updates are automatic and we don’t need to manually sync data (as we would with the Stape store)?
-
Will pulling data from a sheet with 50K products cause performance issues with the Spreadsheet Reader?
-
What are the potential limitations or issues if the product list grows to 50K+ items?
-
For high product volumes, which approach would you recommend: Google Sheet or Stape store?
Appreciate your thoughts on this. Thanks!