Set up Product Data Imports from Suppliers 2

Closed
Part Shops Canada Ltd.
Midland, Ontario, Canada
Richard Gastmeier
President
(129)
5
Project
Academic experience
120 hours per learner
Learner
Canada
Advanced level

Project scope

Categories
Data analysis Website development Information technology Software development Databases
Skills
automotive industry mysql file transfer protocol (ftp) sql (programming language) application programming interface (api) php (scripting language)
Details

Set up scheduled importation and processing of product data/updates generated by various suppliers and automotive industry data banks, using either supplier APIs or CSV files via FTP downloads.

Deliverables
  • Set up of API connections where applicable
  • Set up PHP scripts and scheduled tasks to import API data to MySQL tables
  • Set up scheduled tasks to download csv files from supplier servers and import to MySQL
  • Match and normalize data from differnent suppliers into common product tables
  • Create calculated fields in SQL tables using imported and inputted data.
  • Set up scheduled tasks to export csv files for import to company ERP
Mentorship
  • Documentation is available for any applicable supplier APIs.
  • The project has been partially completed, so there are some PHP scripts and related SQL tables that have been created. These may need modification for correct operation and for use on a different server environment than they were originally developed on.
  • Full project scope documentation, field mapping and formula information provided.

About the company

Company
Midland, Ontario, Canada
2 - 10 employees
Retail, Automotive, Consumer goods & services, Marketing & advertising, Publishing & printing

We operate multiple blog and ecommerce sites in various recreational vehicle, automotive, and outdoor lifestyle niches, including RV Travel Life, This Old Campsite, Marine Part Shop, Powersports Part Shop and The Truck Part Shop.