Sql database

Retired Boards Appdev Graphql Basics And Troubleshooting

Topic summary

A user seeks to establish bidirectional data synchronization between a physical retail store’s SQL database and Shopify. The goal is to push product data (features, prices, inventory) to Shopify while pulling customer and order information back to SQL, ideally in real-time.

Proposed Solutions:

  • On-premises SQL: Develop a native app using the Shopify Admin API (https://shopify.dev/api/admin) to facilitate the connection
  • Cloud-based SQL: Check if existing software accessing the database offers API integration capabilities that could link to Shopify
  • Third-party tool: Skyvia is recommended as a proven solution for bidirectional SQL-Shopify data synchronization

The discussion remains open regarding which approach best fits the user’s specific infrastructure setup.

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

What is the best way to connect a physical retail stores SQL database to Shopify.

Want to send SQL data like Product features, prices, inventory levels, (from SQL to SHOPIFY)

Want to send SHOPIFY data like Customer info, Orders, etc. (from SHOPIFY to SQL)

and can this be setup to work instantaneously.

???

2

Hi

If on premises rather than cloud based you would need to develop a native app and connect the data with Shopify API: https://shopify.dev/api/admin

If the SQL database is cloud based I’m guessing it must be used by some sort of software to access it. You need to check if that software has any integration possibilities via API etc which could then be used to link data to Shopify.

Regards

Tom

1 Like