Boosting backend business operations
Synchronise warehouse with website
Why choose Engine Room Technology?
At Engine Room Technology, we have worked on many successful integrations between diverse stock management, EPOS, warehousing and accounting systems and the leading ecommerce platforms.
We can help save costs on what can be expensive and unnecessary middleware by developing lean, efficient and extensible direct solutions which are tailored to precise business goals. We also have great experience collaborating with the vendors of accounting and warehousing software on our clients’ behalf, enabling us to produce great results in less time.
Contact us today to discuss your requirements.
The case for stock integration
Stock level and delivery information is absolutely essential for any serious ecommerce web site. Customers shopping online today expect products to be in stock and available for rapid delivery, and so there’s a direct connection between accurate stock data and sales success.
An ecommerce site must store stock levels for individual products so that accurate information about availability and delivery time can be presented to customers. For example, the system can check any given product’s stock status and expected delivery time when loading the product page. Then when a customer selects the colour and size of a garment, they will see stock status and delivery timescale immediately.
A highly informative product page using these techniques contributes greatly to the likelihood of a sale. Without such information or with ambiguous or unrealistically long delivery times, it’s highly likely a potential customer will go straight to a competitor’s site, find the the desired product in stock for rapid delivery and place their order there instead.
All of this creates a burden on any ecommerce business to ensure that stock status and product data is regularly and actively synchronised between inventory in website and warehouse. That is where we can help…
Example Use Cases
Clothing Retailer
Sage IntegrationStock & Sales Sync
We worked with a major specialist garment vendor to connect their Magento ecommerce store to an in-house Sage accounting system, synchronising sales and inventory. A bespoke solution was created to meet precise requirements.
Hardware Store
Inventory ManagementInventory & Sales Integration
A bespoke Magento solution to integrate with our clients stock systems, to display up-to-date, accurate inventory and pricing, including tiered pricing and discounts.
Music Retailer
Sales & Distribution IntegrationWooCommerce export to distributor
This application of our integration services created a connection between our client’s retail CD and Vinyl ecommerce store, to their distributor’s stock and dispatch systems. We also handle order receipt and dispatch acknowledgements to update orders in WooCommerce.
The challenges of ecommerce stock integration
Integrating in-house stock data from third-party accounting or warehousing systems into an online ecommerce web site can be achieved by a number of methods. The necessity for integration solutions arises from the need to transform data from the format understood by a vendor’s in-house stock system to something intelligible to and usable by an ecommerce system.
The in-house system and the website software will be determining factors in the ultimate solution, but methods can include ODBC connectors, MySQL syncs, scheduled tasks, XML, JSON or CSV transfers and parsing routines, or indeed some combination of these methods.
Whichever method is selected, the integration must then go beyond the standard import process included with many ecommerce systems. This is because the data requirements of an ecommerce system, such as Magento, are significantly greater than that of, for example, an accounting system like Sage. It is not a matter of simply exporting and importing a spreadsheet from one to the other, for reasons that become clear when looking at the structure of the data on an inventory system versus that of an ecommerce system. More data is required to successfully display products on a website.
How the solutions work
To make this data usable on an ecommerce store, a process of transformation is therefore required. This will convert the individual stock lines, each with their own name, price, SKU, MPN, EAN and so on, that are stored in the stock system into product data that the ecommerce system can store in its database and subsequently use to display product pages.
Product pages on an ecommerce site might loosely be considered as stock groups. Each ecommerce system has its own terminology but they may be referred to as “configurable products”, “grouped products” or “parent products”. While some products without options may be displayed successfully as individual pages, stock with multiple variants (e.g. size, colour, length etc) is most effectively presented as a single page from which a product variant may be selected.
Therefore, as the stock data export rarely contains information about the relationships of products, another task of the import process is to associate individual stock lines – or “simple products” – with the relevant parent product, to populate the options from which the customer can ultimately select for purchase.
Improving speed and efficiency in ecommerce
Ensuring product data and stock status is automatically synchronised between website and in-house systems means greater speed and efficiency when managing an ecommerce store. It reduces duplication of labour and cuts back on manual admin tasks. This permits admin staff to devote more time to tasks directly linked to boosting sales, such as writing effective product descriptions, merchandising, marketing and promotion.
Ultimately, how stock level information and product data is used and presented on an ecommerce web site is up to the specific needs of an individual business, and that’s where we can work closely with you to understand your precise requirements. Working with Engine Room Technology is flexible, bespoke and geared to your business goals.
