Set up Product Data Imports from Suppliers 2
Closed
Midland, Ontario, Canada
Project
Academic experience
120 hours per learner
Learner
Canada
Advanced level
Project scope
Categories
Data analysis Website development Information technology Software development DatabasesSkills
automotive industry mysql file transfer protocol (ftp) sql (programming language) application programming interface (api) php (scripting language)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.
- 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
- 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.