Syncing Shopify with an External Product Database
We were approached for this project in order to integrate a supplier product database, with an existing Shopify store, in order to display the entire available inventory on the Shopify site. Live external inventory checks were integrated to ensure that products being purchased were always available at the supplier level, alongside daily automated product syncs, to ensure that new products and images were always up to date.
Classic Automotive Product Lookup
With the products synced to the store, we were then tasked with mapping the database associations in order to build a classic automotive make / model / part lookup system used to quickly find the exact product from a catalog of over 100,000 items.
To ensure the merchant had full control over the data, we developed an admin area within Shopify to trigger syncing of products, and adjust any live data being read from the external database.