Bakewell Cookshop switched their website platform from Magento to BigСommerce. However, this caused problems synchronising data from their retail store to the new website. Like many e-commerce businesses, they also have a physical shop, and it is important that online and offline inventory is perfectly synchronised to avoid overselling.
The synchronization was performed in 2 steps:
A Windows batch file executed an SQL Query that exported the filtered data to a CSV file. It was scheduled to run every hour.
On the Magento platform the CSV file was uploaded automatically, but after switching to BigCommerce, the process became more complicated, so Bakewell Cookshop started looking for a data integration solution.
To us it sounded very simple – upload CSV data to Dropbox on a schedule and let BigСommerce monitor the Dropbox folder for changes. The main challenge was that the built-in tools of BigCommerce were not so reliable and could not be easily automated. We spoke to many developers, but they wanted to charge huge amounts to automate this process."