About

Come and browse our site for one of the largest selections of exquisite wines, spirits and accessories in New York and the tri-state area.

Challenge

The Web and physical stores inventory are both based on the same set of databases in a Windows SQL service. Item information and attributes need to update simultaneously to the online store and physical stores every single day. Synchronize should not bring many impacts to online frontend performance as it is a frequent routine. How to integrate system between windows SQL service with physical stores pos and online store become a importance question for this wine seller.

Solution

Use a separated cronjob triggered process connect to Windows SQL service in certain time of a day and generate import script in advance. Handle information with validation and correction before importing to Magento. With this solution the calculation in Magento part has minimize so as the performance impact. After order been place, inventory changes store in a dedicate record and update in batch in certain period of time. Customers enjoy a smoothly shopping experience and store owner also enjoy the benefit of automation without manual merchandising too much.

Services

• Frontend Development
• Backend Development
• System Integration
• SEO strategy practice