App: Product Information Manager for 15K Products
Challenge
With the plethra of Kitchen equipment available, this distributor needed to sync an external catalog with thousands of products. Manually importing catalog changes, price updates and inventory is the challenge.
Services
Custom Applications
Technology
BigCommerce, PHP
Timeline
2 Months
Launched: 01 Dec 2020
Strategy
Collect the data source, a CSV spreadsheet generated daily, and translate each row to a Product or Variation. Mapping the unique data columns to the BigCommerce catalog fields, we focused on 30+ fields within the BigCommerce product.
Other types of information had to be extracted to create Custom Fields, Shipping requirements, and Price Lists per product. Using a server with PHP and MySQL database, our programming is set to sync products nightly.
Solution
Thru the process we discovered how to best fit Globe's specific catalog requirements to the BigCommerce product framework. The client has been recieving large catalog updated nightly without direct intervention.
KPI
15K+ Products Syncing Nightly
Testimonial
This program has allowed us to source thousands of products and automatically import them into our store. ~Brian