Database Migration and Salesforce Integration for Tobacco Wholesaler

Boosting reliability to support BTL marketing efforts

Client and Project Goals

The client is a leading tobacco wholesaler in the US with 100k+ orders per month. The client was looking for a team to ensure continuous improvement and tech support of their website and the eCommerce solution it incorporated, and fix critical bugs which impeded their BTL marketing efforts.

Challenge

The less powerful technologies such as CoffeeScript and jQuery as well as outdated documentation and partially its absence posed the biggest challenge. They complicated the refactoring of the legacy code and slowed down the progress.

Solution

The product in the spotlight automates the processing of orders placed via the website and other interactions with the company’s clients. The AIS Novations team developed and implemented a solution that connects it with Demandware (Salesforce), a cloud-based CRM with no need to take care of servers, databases, and their administration. A custom script automatically adds all auctions won to Demandware. Our development team performed database migration from mlab to MongoDB Atlas to ensure the reliability and safety of data, and regulate the backup and storage of copies. We wrote scripts to replace manual sequential change of configurations for client’s services with an automated password reset every quarter.

We used the Kanban methodology: it is best suited for the technical support project that presupposes a multitude of bug fixes and urgent tasks.

AIS Team
2Developers
1Project Manager
1Account Manager
Customer location: USA
Project duration: 2+ years
Languages
JavaScriptCoffeeScript
Frameworks
Express
Industry
E-commerce, Retail & Wholesale
Web- and application server
Amazon
Services
Web DevelopmentDatabase migration
Miscellaneous
SSHSFTPUbuntu(Linux)MongoDB

Results

After solid bug-fixing, code refactoring, database migration, partial functional improvements, the client enjoys a reliable product. The AIS team helped mitigate several critical financial risks previously caused by corrupt promo code application procedures. The client utilizes the web solution to facilitate BTL sales promotion through promo codes, bonus buys, and other techniques. The client trusted the AIS team with further technical support and continuous improvements of this product, and our collaboration continues on this and other projects.

Other projects