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.

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.

Results

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.

The Brief

Globe Equipment

15K Product Catalog sync program that runs nightly.

Website

globeequipment.com

Launch Date

2020-12-01


Gallery