Synchronizing data from MySQL DB to Shopify

Excursionist
17 3 1

Hi,
I have a software on my physical store to manages products, it uses MySQL database.
What's the best way to mutate Shopify from that database?

0 Likes
Shopify Partner
48 3 14

Hi,

 

I don't know of any solutions that are super simple, so I will tackle this issue from an shopify app developer perspective.

 

From what I understand, you have an MySql database that you keep to updated separately from some separate software. When you update that database you want to update shopify to reflect the changes to products.

 

I don't know of any app that does this so this probably consists of custom code. This situation is a bit tricky, because it depends on your that separate software that you use to manage that products.

 

Building a custom app:

Polling: A custom app on shopify will connect to your mysql database every so often to query for any changes that you've made over the last while. Then it will fire API calls to shopify to update the values in Shopify. There are potential issues and time delay related to updates through polling.

 

Event Driven: This is where you would need your separate product management software to fire an event to the custom shopify app to update Shopify's data. This is the better approach, but can be more difficult to implement or impossible depending on your Product Management Software.

 

Both of these require some background knowledge and information about how the shopify app/API system works and programming in general.

 

Best of luck.

If you need professional assistance, feel free to contact me/us.

ui-gab
Vancouver, BC Canada
https://www.uiavenue.ca
uiavenue.help@gmail.com
We specialize in Shopify App Development. If you need help just reach out.
1 Like
Excursionist
17 3 1

Yes, event driven seems to be the way to go. I will place a flag on the software that when triggered will update Shopify. If it were polling, maybe through a cron job?
Thank you for the heads up ui-gab. Cheers.

0 Likes
Shopify Partner
48 3 14

Yup, we might be oversimplifying some of this, but yup through a cron job.

 

Cheers

ui-gab
Vancouver, BC Canada
https://www.uiavenue.ca
uiavenue.help@gmail.com
We specialize in Shopify App Development. If you need help just reach out.
0 Likes