Custom API bridge to sync 50,000 SKU’s with WooCommerce.
Founded in Oxford 2012, Absolute Antibody are specialists in antibody sequencing, engineering and recombinant manufacturing, providing pharmas globally.
Struggling with a legacy system, and being increasingly dependant on third party systems to sync products from an in-house database, Absolute Antibody challenged us to completely reinvent the website and product sync.
WooCommerce forms the foundation for this integrated solution. We had to heavily customise Woo to work with the unique product structure, making use of grouped products and variable products to form a three-tier product structure.
We custom built a Laravel-powered sync tool, pulling the existing product data for 50,000 products from SQL Server via a hosted API and pushing this data into WordPress via the WooCommerce API. It was important to improve on the speed of the previous sync tool, and a full sync was reduced from 8-12 hours to half the time at 4-6 hours. More importantly, we are now able to do an incremental sync that only synchronises the updated product details. This means that the data can be synced multiple times a day, keeping the website up to date.