Visit the site
Visit the siteDet Gamle Apotek
Det Gamle Apotek is one of the largest retail xmas item selling company in Denmark and other European countries.With this new Drupal 7 based website they wanted to have real time store update facility from their existing ERP System.So our challenge was to integrate ERP in to Drupal Commerce.
About the project
This project was a challenging one for us.As we haven't worked before with ERP integration to a CMS.But we accepted this challenge.Main
requirement was this ERP integration.It is a bidirectional integration through a database.If I explain this integration to you,
MySQL <----> eCommerce Website <-----> | PHP Script running as a bridge | <----> SQL Server <----> ERP
Front-End
Customer wanted to have desktop website in and easy navigation through out the website.We only had their Logo and based on that logo we decided the colors for website.We made website layouts for customer and created Drupal theme in the beginning.
Back-End
We stick to Drupal admin panel but customer doesn't want to use it.Let me explain the reason.Customer wanted to upload almost everything from ERP system and it should update real time to website.Including Categories, Products, Users accounts, User Profiles, Images, Stocks so on.We made all these things to update from ERP.As I have described above this was a bidirectional integration we made a setup to send Order details (including line item details), customer details back to ERP system on the fly.To get done this we made a PHP script which act as a bridge between website and ERP system.
If you are wondering about product images we had to write an image processing script to do this.Which can read image folder and process it to correct sizes for Drupal.Also it can save images in to correct places in Drupal folder structure.
Here are some of the important requirements of this website
- Drupal based eCommerce website
- Integrate Drupal Commerce in to their ERP system
- Update Categories, Products, Users accounts, User Profiles, Images, Stocks every night
- Export Order details (including line item details), customer details real time to their ERP system
- Advanced product filtering option for customers
- Online Payment Gateway integration
- Shipping management.They wanted to have many different shipping methods based on Country, Currency type, GLS Europe, DHL and weight
- Multilingual
- Multi-currency
- Coupon and Discount
- Security
- SEO
Why Drupal was chosen
Almost more than 5 years we are working with Drupal and our first concern was we need to go with Drupal.There were many reason for selecting Drupal.
- We have a high skilled Drupal Development team
- Drupal Commerce is one of the fast growing and highly customizable eCommerce platform
- 1000's of Modules
- This store has more than 20000 products and needs to update daily so strong CMS was required
- Drupal is the best open source CMS
- Security
- Extensive Support through Drupal Community
- Best thing is it's Free
Technical Specifications
Drupal Commerce
Drupal Commerce is most important and valued module in this project.We are using Payment, Stock, Shipping, Google Analytics, Address book, Address Field, Commerce Cart Expiration, Coupon, Email, Extra Panes, UI and Flat Rate.
Views
This powerful module we used all over the website.
Auto Assign Role
Purpose is to provide an automatic assignment of roles when a new account is created
CKEditor
We used this and grant customer to edit basic pages as they wish without having any programming knowledge
Internationalization
This module allowed us to extends Drupal support for multilingual features
Coupon and Discount
The purpose o g Coupon and Discount is obvious.We wanted to add coupon and discount features to website
Date
Provides date and time fields available also date popup feature
ePay
This is the module we used to connect to ePay payment gateway
Honeypot
We used this module to Mitigates spam form submissions
Entity API
Allowed to work with any entity type and to provide entities
HTML Mail
Enables HTML in system emails
Meta tags (quick)
This module used for Search Engine Optimization (SEO)
Login Destination
Using this we were able to customize the destination that the user is redirected to after login
Menu translation
Supports translatable custom menu items
reCAPTCHA
Uses the reCAPTCHA web service to improve the CAPTCHA system
Rules
React on events and conditionally evaluate actions
Shipping
Implement handling of shipping costs in Drupal Commerce
Variable
We used this module to get Information about variables and basic variable API
GLS Shipping Method (Custom)
This is a custom written module to handle GLS Europe shipping quotes.
Apart from these modules we have written some of our own modules as well.
