Unparalleled Experience By Integrating Magento 2 With MySQL Using DCKAP Integrator.
About CyM Distributors
CyM Distributors is emerging as one of the biggest and constantly growing aftermarket auto parts wholesalers, situated in Puerto Rico. They have been serving the local as well as the Caribbean market since the year 1987. CyM Distributors has more than 100,000 S.K.U. ‘s available in their repository for original and replacement parts. They serve parts for Jeep, Korean and Japanese cars in their large facilities.
Currently, CyM Distributors import directly from the best parts manufacturers from a host of locations. These span over Japan, Korea, Taiwan, Peru, China, Spain, the USA, Italy, and other places with the primary objective of supplying a huge variety of quality part products for different clients in Puerto Rico as well as the Caribbean. With DCKAP on board, they were able to fulfill a host of eCommerce requirements and grow their business on the online front.
- UI and UX Enhancements
- Magento 2 Implementation
- Integration w/ DCKAP Integrator
The Integral Transformation
Instead of using an external platform/tool, CyM has directly been syncing their data using MySQL and were on the lookout for something that would solve their purpose of providing inputs and receiving outputs to a motor or automotive wiring diagram provider by analyzing their API.
They were also looking to implement a multiple invoice payment feature with 30-60 and 60-90 days options. Apart from syncing the products, they also wanted to sync the categories. And lastly, CyM required the addition of language inputs for English and Spanish (product titles, descriptions, etc.)
This is where DCKAP came into the picture, and a Magento 2 website was created. We understood all the requirements of CyM and started to work on the deliverables as per what they needed. Every requirement was implemented, and their website was revamped.
Augmented Online Experience
A good website elevates a business and helps the audience in perceiving the brand better. This, in turn, plays a significant role in increasing the lead flow, so it is essential to make sure that the website’s user experience is not just smooth but is also catchy.
- Grab the user’s attention through varied details in the design
- Easily convey the product, service, or solution provided by the company
- Create an uncomplicated visual that’s comfortably visible to the eye.
- Provide ease by not directing the users through challenging navigations and category pages
- Effortlessly search what the consumers are looking for in the website
Magento 2 + MySQL: Business Requirements
In order to successfully mitigate the above-mentioned challenges, the transfer should cater to all data standards of MySQL and Magento 2. The client wanted to automate all eCommerce data transfer from Magento 2 to MySQL. From a broader perspective, CYM Distributors wanted a middleman to setup bi-directional communication between both platforms and ensure that they talk to each other constantly.
Effortless Experience with DCKAP Integrator
To provide access to more robust features, CyM was integrated with DCKAP Integrator. These features helped in adding value to the overall user experience. Thus, allowing both B2B/B2C customers to shop with ease. The key features integrated with DCKAP Integrator have been mentioned below:
– Invoice payment sync without any delay
– Syncing of price rules
– Category sync through DCKAP Integrator
– Year, make, and model feature
– Purchase History
– Customer account creation
After the client shared their pain points with our solution specialist team, they had only one solution to offer that vanquishes all the business challenges they faced. And with no surprise, it was Magento 2 MySQL integration. Our expert analysts highlighted the easier solution it provides, to hit the database and make data update through CRUD operation directly in order to:
- Save a considerable chunk of time by skipping the need to create and/or call ERP API (Direct database calls doesn’t require API as a gateway)
- The source of truth for business data is MySQL database, so direct update to database eliminates dual work
The client liked this suggestion and immediately gave the green light for kickstarting Magento 2 MySQL Integration. DCKAP Integrator experts soon began with the integration setup and rolled out the following integration pipes:
- CYM Product Updates: MySQL > Magento 2
- CYM Customer Registration: Magento 2 > MySQL
- CYM Order Status: MySQL > Magento 2
- CYM New Orders: Magento 2 > MySQL
- CYM Product Details: MySQL > Magento 2
- CYM Inventory: MySQL > Magento 2
Other Integrations and Extensions
Using extensions, be it a third party or your very own extension that fulfills the requirements of an eCommerce store, tends to add greater value to the performance of the store. The advancement in technology has made the eCommerce space more competitive than ever before, so, in order to stand out, we tend to rely on these extensions to improve the functionalities of the online store.
- Motor API
- Google Maps API
- DCKAP Quick Order
- DCKAP Mega Search
Embracing B2B eCommerce
B2B eCommerce business seems to be increasing more in number than in previous years. Apart from their offline business, B2B merchants have now started to opt for an eCommerce business. The developers at DCKAP have implemented a number of B2B features for CyM, the list of key features has been mentioned below.
- Multi-Language Support
- Motor/Automotive Wiring Diagrams
- Quick Order
- Synonym Search
- Invoice Payments
- Sub Account Limit
- Save My Cart
- Multiple Shopping List Option
- Memo Request
- Search History
- Alternate Items
- New Arrivals Menu
- Special Products Menu
- Buy Again Menu
- Rules Based Pricing
- Customers’ Product Number