Store Properties Filter Errors in Analytics / Reports

Customer Success
1

FrequentlyAsked Question / Exact Problem

  1. “In Store Analysis, while filtering with ‘Top 40 Stores’, I am getting an error.”
  2. “Store filter in the transaction report is not working.”
  3. “Custom store tag (e.g., top40stores) is not returning any results.”

Affected Tenant / Context
Pepe Jeans (top40stores custom field filter), Whitemart (view table access error via store filter)

Root Cause

  1. Pepe store filter with custom fields — The store tags component in the UI is used in two different contexts: fetching stores from PG (by name) and fetching dashboard results from CH (by custom field column). A single API call can’t serve both correctly. Custom field csf2 (top40stores) wasn’t mapped properly, and the display name case-sensitivity caused the filter to fail.
  2. Whitemart view table dependency on old store view — Database views for Whitemart were querying an old store view that didn’t include the required store data. Switching to tenant_brand_business_store fixed access.

️Common Debugging Steps (For CS Team)

  1. For custom store tags (like top40stores): confirm the display name exactly matches the field name in the store master upload (case-sensitive).
  2. Re-upload the store master after correcting field names if there’s a mismatch.
  3. For Whitemart view table access errors: escalate immediately — it’s a backend DB view permissions issue.
  4. Verify you’re logged into the correct tenant — for Pepe, there are multiple tenants with
    similar names in the system.

Fix Made & Developer Conclusion

  • Pepe top40stores filter: NisarAhamed M implemented a fix at the API level to standardize how custom field names are passed across all analysis dashboards. Fix moved to prod after QA testing.
  • Whitemart view: Dharshini switched the store dependency to
    tenant_brand_business_store and granted proper permissions. Applied the same fix
    across all views.

Exact Dev to Reach Out To
NisarAhamed M — Store tag API fix, custom field in analytics
Shriram — Store analysis component, custom field mapping rules
Dharshini — DB view access, CH store table