Improving wine Flow: Online retailer boosts efficiency through integration

Published on the 21/01/2016 | Written by Flow Software

Advintage wines
icon_case study

AT A GLANCE

INDUSTRY

  • FMCG

BUSINESS OBJECTIVE

  • With an eCommerce platform update, Advintage required integration of the online Magento system with the MYOB EXO back office solution to handle new customer acquisition, stock synchronisation and invoice/accounting automation.

SOLUTION

  • Flow Software middleware

BUSINESS BENEFITS

  • Synchronisation of stock and other data across website and business management systems
  • Elimination of manual data entry
  • Error free data across applications
  • Improved business efficiency through automation

FOR MORE INFORMATION

FLOW SOFTWARE
W: www.flowsoftware.com
E: info@flowsoftware.com
T: +64 9 476 3569

Advintage optimises e-commerce upgrade by integrating web platform with back office business systems…

When leading New Zealand online wine retailer Advintage upgraded its ecommerce solution, it looked to Flow Software to integrate the Magento online solution with the company’s MYOB EXO back office software. By connecting the two systems, Advintage is able to maintain a close eye on stock levels and company performance without any manual data entry.

With a reputation for offering superior service and the best wine deals available anywhere, Hawke’s Bay-based Advintage is a trusted wine retailer which delivers thousands of cases of wine per month to customers around the country.

Situation
Advintage Operations manager Gilly Greville explains that the company executed a full redesign of its online presence, shifting to the Magento eCommerce platform, in 2014. “That meant bringing the site up to speed for mobile devices as well as some serious upgrades in features and functionality,” she relates. “However, that also meant we needed to integrate the new web sales platform with the existing back office business system – MYOB EXO – so we could have a consistent view of stock levels and company performance.”

Going into more detail, Greville says stock, accounting, and shipping is managed in MYOB Exo, so when sales are made online, it is necessary to update the back end system to accurately record stock levels. Similarly, should sales be made out of its retail premise, or via the telephone, information needs to be fed through to the website to avoid ‘out of stock’ disappointments.

Solution
As Advintage had previously worked with Flow on other projects, it had full confidence in the ability of the integration specialist to deliver the required solution to enable data flows between Magento eCommerce and MYOB Exonet.

“Implementing a full eCommerce redesign was a pretty lengthy process, taking the better part of six months; we worked with Flow for around two to three months on the integration,” says Greville.

Flow Software’s middleware provided the necessary integration layer, while the vendor also provided the necessary implementation and support expertise.

With its digital support partner located in Sydney, Australia, and technical development teams in Korea, further complications of working across time zones were presented. “That wasn’t a problem for Flow; there are always teething problems and odd technical issues which crop up with projects of this nature but the Flow technical support team was always available and always had the answers,” she notes.

Results
The integration means that Advintage has end-to-end business process automation internally, and with its customers, regardless of whether sales are made online, in its retail store or over the phone.

When customers purchase via Magento, the integration automatically creates a sales order for the purchase in EXO meaning no re-keying of the order is necessary.  The sales order also prompts a stock adjustment to be made in EXO with the ‘Stock On Hand’ updated in Magento so that both systems have up to date product stock availability and details.

Once payment has been received, the integration updates EXO accordingly and the order shipment and tracking details are sent back to Magento so that customers can access them and see where their goods are. The Flow integration manages the data exchange between the two business systems; Magento data is accessed via API, while EXO data is accessed directly from the database.

Greville adds that as part of its commitment to delivering positive customer experiences, Advintage wanted to equip customers to manage their own details via the Magento website. The integration supports this via a one-way process, so that EXO is updated with data changed by the customer at the Magento end. A built in exception handling capability instantly notifies Advintage staff, who can rapidly solve any issues which require manual intervention.

“Thanks to Flow, we can enter information in Magento directly or via the website and it goes straight though into EXO, or the other way around. It’s completely seamless and synchronises every two minutes, which is close enough to real time. Nothing needs to be updated manually, so the system eliminates what would otherwise be a lot of tedious work,” says Greville.

Not only does the Flow integration deliver exactly what is required, she adds, but the project was also delivered very close to the estimated price. “Flow is a trusted partner which has, over the course of a relationship which goes back almost ten years, always met our expectations,” she concludes.

FURTHER READING


About This Vendor


More Case Studies

EMD_Giltrap_Flow_Software

How Flow drove easier automotive ERP upgrade

July 12, 2017 | Flow Software
Middleware allows EMD to focus on own systems, leaving existing integrations intact…
Stevenson Group truck

Concrete results for construction leader’s ERP upgrade

February 8, 2017 | Flow Software
Stevenson Group looks to Flow Software for smoothly integrated operations…
Recreational Services

Christchurch parks get greener with data automation

September 19, 2016 | Flow Software
Winning a tender to provide full facilities maintenance services for Christchurch City Council has had an added benefit for Recreational Services…
Flow Wineworks

NZ wine industry embraces automation

April 15, 2016 | Flow Software
WineWorks and Sacred Hill lead the way with supply chain integration…
Tegal chicken

Tegel chooses Flow for rapid systems integration

January 27, 2016 | Flow Software
When New Zealand’s premier poultry producer sought a better way to perform systems integrations, it found the ideal solution in Flow Software…


Follow iStart to keep up to date with the latest news and views...