Another challenge was to sync our database with the bluelink ERP database. Bluelink is a third party ERP system which was also being used for numed sales orders. So keeping both the databases in synchronization so that data stays updated in both the systems was a big challenge.   To synchronize the data between bluelink and Numed Database , we created auto shoot schedulers which used to compare the data and sync it accordingly. We also used replication to keep the data the same in the tables.

Another challenge was to manage the pricing of an item w.r.t the customer. There were two kinds of pricing , one was general pricing and another was specific to customers as well. So managing that one was a challenge for us. We created a separate Database schema to manage the customer specific pricing and comparing it to the standard pricing of the customer is new.

The End product is a full fledged ecommerce system which has a wide category of smoking related products and associated accessories. Since the number of products were huge , a well planned efficient searching system was kept in place which lets companies search the products without any hassle. This application provided a very smooth way of doing transitions as there were online transactions and the credit limit system for the customers.