Shopping Cart
There are no more items in your cart
- Tecnoacquisti.com
- E-commerce Portfolio
Tecnoacquisti.com® has created and implemented the ecommerce of Bison Motor Parts, a reality born from the consolidated experience of Speciallabmotorcycle, a brand that for 12 years has stood out among the best Italian shops of motorcycle accessories. Thanks to this long tradition, Bison Motor Parts has developed a deep knowledge of the industry and an unparalleled passion for everything related to the world of two wheels.
More than 70,000 Motorcycle Parts
The main difficulty of the project lay in the large number of products (motorcycle parts) and their updating and association with the applications, i.e., the various vehicle models. Updating stock and prices could not in this case be handled in a classical way, requiring implementation of specially created functions, resorting to batch mode, and reviewing indexes of PrestaShop tables. Through the implementation of these technologies and optimizations, it was possible to perform the updating of the entire catalog via CSV generated by the management system, which exceeds well over 150,000 rows, in a matter of seconds.
Another challenge was the need to manage product availability in both the Europe and U.S. warehouses without resorting to additional modules to implement the problematic advanced warehouse, which is no longer available in versions after PrestaShop 1.6. And being able to avoid products in the US warehouse being exported and synchronized with the Ebay store.
More than 62,000 motorcycle models and more than 5 million applications
Thus, everything has been designed to maximize performance in queries even on the front-end side for the application/compatibility search engine. Let's talk about important numbers the catalog exceeds 70,000 products (motorcycle parts) that are associated with more than 62,000 vehicle models, an association that generates more than 5 million records. The application module was tailor-made for the project with the specific goal of adapting to the data available to the client (more than 2GB of CSV files) and, above all, with the goal of managing without affecting loading time and server hardware. Simply importing application data was a demanding and complex challenge. Importing such a large number of data, performing all the checks in order to import only the necessary ones, thus filtering out unnecessary data, processing more than 100 files with hundreds of thousands of records, required the development of very advanced procedures and techniques.
Every query and every index in the database tables, every single function required extreme attention and optimization in order to handle a database of considerable size, to be able to load products that may have even more than 1000 applications while maintaining a smooth user experience and keeping a very low TTFB. Optimization also involved the configuration of the dedicated server and MySQL database.
Over 70,000 Motorcycle Parts and nearly 6 million applications in Bison Motor Parts catalog
GraphicRaccon passionately and professionally curated the illustrations for the Bison Motor Parts categories, creating a unique and engaging visual experience. The project was an opportunity to express the team's creativity to the fullest, translating the essence of the brand into dynamic and eye-catching images.
The designed illustrations reflect the strength, precision and passion for the world of two wheels, with a design that communicates speed, power and adventure. The choice of bold colors, dominated by shades of blue and gray, and the use of bold lines and realistic textures resulted in a visual narrative that captures the spirit of Bison Motor Parts.
Every detail, from the figures of motorcyclists in action to the mechanical components, was designed to represent the brand's values, creating a visual impact that not only decorates the website, but tells a story.
GraphicRaccon 's work enabled a seamless integration of aesthetics and functionality, helping to reinforce Bison Motor Parts' identity through tailored illustrations that clearly and powerfully communicate the brand's mission.
Website: bisonmotorparts.com
PARTNER OF TECNOACQUISTI.COM
