c
APE Logo

A.P.E. Auto Parts One of “The Most” popular product/portal for the auto-parts industry in USA.
The front-end shopping cart feature to purchase auto parts online.

Challenges we Faced

In order to develop a dynamic system, it was challenging for us to normalize the database in such a way that the results are achieved without compromising the system's efficacy and storage is optimized. It is a good practice to access system requirements and optimize the performance of the database system according to the requirements.

  • Import functionality to import thousands of parts in one instance and stored using CSV.
  • Designing and Development of a flawless admin panel for multiple vendors in centralized database

Business Problem

The auto parts industry has several parts as well as vendors and manufacturers. In order to keep track of the parts, it is important to have a centralized system that can store and sort the data based on various criteria suitable for each vendor and wholesales customer.

  1. A comprehensive database for auto parts in USA
  2. Wholesaler website of auto parts

Consumers/Users of app

The vendors and manufacturers of over 4000 auto industry parts are the users of the website.
Function: retailers of auto parts, auto parts inventory management staff
Industry: e-commerce, Auto parts, Inventory management

Business Benefits

The Users can easily search part numbers of any part type, year, make, model, and attributes like volumes.
It has strong CSV import functionality to import thousands of parts in one instance. The admin the panel is well tested to manage the parts from different vendors in a centralized database.

  1. A comprehensive database of auto parts for US retailers.
  2. One click import for large auto parts.
  3. Online auto parts inventory management system.

Solution

We proposed a system with the seamless back-end vendor based inventory management and automatic import of products into the database.
Technology Used: PHP, Drupal, MySQL, Apache, Ajax, Jquery, VPS Hosting

Cool Feature
Seamless back-end vendor based inventory management
automatic import of products into the database.
The front-end shopping cart feature to purchase auto parts online

Special Architecture/design Features:
Users can easily search parts by

  • numbers
  • type
  • year of manufacture
  • make
  • model
  • other attributes like volumes