How to Automate SKU, Price, and Inventory Updates From Lightspeed DMS to Shopify?

[tirthmehta10]

I have 4,000 products listed on Shopify and 60,000 products managed in Lightspeed DMS. I want to implement real-time updates so that whenever there is a change in price or inventory in Lightspeed, it reflects immediately on Shopify. I’m considering two methods for this integration: 1) Lightspeed Third-Party Access (3PA) API, which allows me to access product data but doesn’t support webhooks for real-time updates, and 2) Shopify GraphQL Admin API, which enables product updates on Shopify but requires handling large datasets efficiently and staying within rate limits. How can I automate this process to sync the data in near real-time, especially given the large number of products? Should I use periodic polling to check for changes in Lightspeed or is there a better approach to achieve real-time synchronization? Also, how can I efficiently handle bulk updates for 60,000 products in Shopify using GraphQL, and are there any middleware solutions or tools that can help streamline this process?

I haven’t yet implemented a solution, but I am exploring the best approach to integrate Lightspeed DMS with Shopify for real-time updates of price and inventory changes. I’m expecting to find an efficient way to automatically sync 60,000 products between the two systems using the Lightspeed 3PA API and Shopify GraphQL API. My goal is to have near real-time updates whenever there are changes in Lightspeed, reflecting immediately in Shopify, while handling bulk data efficiently and managing API rate limits. I’m looking for advice on whether to use periodic polling or another method, and any middleware or tools that could help with this integration.

[PaulNewton]

Hi @tirthmehta10  Doesn't lightspeeds own shopify integration handle this.

Should I use periodic polling to check for changes in Lightspeed or is there a better approach to achieve real-time synchronization?

---

Lightspeeds the chokepoint in this so any performance questions needs to be handled on that side or in their support areas.

Especially if the only api notification "method" is through polling 🤢

Use the shopify bulk operations apis for bulk data.

For middleware there's automation tools like mechanic, examples https://tasks.mechanic.dev/?q=bulk&tags=Products 

With that caveat it uses only basic-http-auth for third party apis and it doesn't currently support Oauth

[tirthmehta10]

Hi Paul,

Thank you for your response! I believe you might be referring to Lightspeed Retail (formerly Onsite or eCom), but I’m working with Lightspeed DMS (Dealer Management System). Unfortunately, DMS doesn’t seem to have webhook support, making periodic polling my primary option for syncing data. Do you happen to know of any third-party integrations or tools specifically designed to connect Lightspeed DMS with Shopify? I’d appreciate it if you could share any resources or links!

Thanks again!