Syncing Inventory

Ben Buie | 8/15/14

I almost forgot to write about this project.

One of the hardest things to do in eCommerce is keep your product inventory synced with the warehouse, particularly if you have both eCommerce and physical stores. wanted to take their ability to the next level, so they asked us to build sync functionality between their master inventory database and Shopify. The tough part wasn’t syncing, Shopify’s API made that pretty easy (although their throttling makes it painfully slow), it was matching the products on the web with products in the database. Some products had incorrect names, colors, sizes, and even SKUs! To solve this problem I made a quick Excel file that cleaned up the majority of products (thousands) leaving only a couple hundred that had to be done manually. Once we matched the products, we updated the bar codes on Shopify (note to self, never upload products somewhere without bar-codes). Using the bar-codes we can do a nightly sync of inventory numbers. A real-time sync would have been better, but that is not what the client paid for. Maybe next time!

Live Project Link:

About The Author

Ben currently works as a senior developer and technical business consultant outside of Boulder, Colorado.

Read more about Ben

About Buink

Buink Web Development is a development shop founded in 2009 by Ben Buie. For years, Ben built and modified web assets for clients in Utah. In 2011, he moved the company to Colorado and in 2015 he started taking on new clients full-time.

Buink’s Core Values:

  • Cost effective technology (with business strategy in mind)
  • Eloquent, maintainable code
  • Responsive and transparent communication
  • Quick project turn-around
  • Less code, less bugs
  • Start with responsive styles

Read more about Buink’s core values

Read more about Buink

Connect with Buink

Connect with Buink via email, send us a message, or subscribe to our blog.