Job Overview
To create a software program that is multi user over a PC network. Hosting option can be local server or cloud based. To be user friendly with a professional user interface and possibly ultimately branded with our company details and or logo.
Task Outline
To automatically collate and import data supplied from multiple tyre manufacturers and tyre wholesalers received at least once daily but sometimes up to three times on excel spreadsheets.
The data may differ in format for the same product in the description or tyre size such as 2055516 91v or 205/55/16 91v depending on the supplier and this would need to be standardised into one standard format.
All the tyres might have slightly varying descriptions as mentioned but they do have one common code that in unique to each tyre which should make unifying them into one uniform standard in the program possible.
This common code is known as the EAN or IPC code for Bridgestone/Firestone product. See the attached spreadsheet examples with sample data.
Apart from the unique code and varying descriptions and part numbers etc the progamme should also display current stock levels and prices.
Search criteria for the product would be on tyre size such as 205516, speed and load rating such as 91 and V and manufacturer such as Michelin etc. In total there are a few thousand tyres available.
End result
A software program able to display all the options of supply by the search criteria above and provide all the available sources of the tyre in terms of availability by stock level and price with best price highlighted. This will enable us to place orders either direct with the manufacturer or the wholesalers offering the best price or availability.
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive response. Thanks.