API for offline orders and invoices

Technical Q&A

Topic summary

A user is integrating SAP B1 (ERP) with Shopify and received conflicting information from interface providers about syncing offline orders and invoices.

Core Issue:

  • One provider claims offline orders cannot be synced to Shopify
  • Another provider says it’s possible through proper API field matching
  • Goal: Display both Shopify orders and offline SAP orders in customer account history, along with ERP-generated invoices (content only, no PDF)

Proposed Solutions:

  • For invoices: Use Shopify metafields to store ERP invoice data (number, date, items, total, status), then customize the customers/order.liquid theme template to display this information on customer order pages
  • For offline orders: Sync via Shopify API with correct field mapping, create custom pages to display invoice content, and link all orders/invoices to customer accounts

Current Status:
The discussion remains open. The original poster requests more detailed technical guidance to share with their interface provider, who maintains the integration isn’t feasible with Shopify’s API.

Summarized with AI on October 26. AI used: claude-sonnet-4-5-20250929.
1

Hi there. We are in negotiations with an interface provider to sync our ERP (SAP B1) to Shopify. He says that offline orders cannot be synced, but I have read and also got another offer from another interface provider, that offline orders can be synced to Shopify. It´s just a matter of field matching when connecting over API. Same issue for invoices. We would like to display the invoices created in our ERP on shopify. Just the content, no layout or PDF needed. Our customers should see a history of the orders (made on Shopify and offline orders created in SAP) and their invoices. I would appreciate some help here. Thanks a lot!

2

Hi @broilking-de

This is David from SearchPie: SEO, Speed & Schema

To answer your question regarding your invoice: Yes, you can display ERP invoices (in your casefrom SAP B1) on Shopify using metafields. When an invoice is generated in your ERP, you can sync the relevant data (invoice number, date, items, total, status, etc.) into the order metafields in Shopify.

Then, by customizing your theme specifically the customers/order.liquid template. Then you can display this invoice data directly on the customer’s order page. It doesn’t create a Shopify invoice, but shows the ERP one clearly, with no need for PDF generation. Clean, flexible, and fully customizable.

Hope this helps!

If you find this helpful, please let me know by giving PieLab a ‘Like’ or marking this as a ‘Solution’

Cheers,
David

1 Like
3

Hi,

Hope this will help

  • Show offline orders : Use Shopify API + match fields correctly
  • Show invoice content : Push data via API & show it in a custom page
  • Let customers see all history: Link orders and invoices to each customer account
4

Hi. Well, I would need a more detailed approach. If there is any technical assistance that could guide our interface provider as they said it won´t work with Shopify. Thanks.