Getting a bank statement table

Shopify Plus

Topic summary

A user is seeking an efficient method to display bank statement data from their CaniasERP system on their Shopify B2B store. The concern is that using metafields with JSON data would require transferring large volumes of information for some customers.

Proposed Solution:

  • Implement an API integration to fetch data directly from the ERP system on request
  • Consider using caching tables to improve performance
  • Avoid storing large datasets in Shopify metafields

Key Considerations:

  • Given the sensitive nature of bank statement information, proper security and authentication measures must be implemented
  • The discussion remains open with no final implementation decision made
Summarized with AI on November 1. AI used: claude-sonnet-4-5-20250929.
1

Hi,

In our ERP system which CaniasERP we use, there is a bank statement section for our B2B customers. We want to display this information in a section on our Shopify store where customers can view it. While it might be possible to achieve this using metafields with JSON data, it would mean sending a large amount of data for some customers. Is there a more practical and efficient way to achieve this, possibly using an API or another method to transfer data directly from the ERP system to Shopify?

Regards,

Mert

2

If storing the data in Shopify (e.g., via Metafields) isn’t practical, the best approach is to fetch it directly from the ERP system upon request or use caching tables for improved performance. An API integration would be the most efficient way to retrieve and display the data on Shopify. Given the sensitivity of the information, ensure that proper security and authentication measures are in place.