Hello,
Thanks for the interest to quote for this job.
I’ll require massive data compilation and data entry for this job.
I’ve attached an excel file. I’ll require every tab and every field to be filled up as best as you can.
Here are the break down of all the sheets
part_brand structure id, name, description
Currently all the descriptions are empty. Please fill up the description of every entry as best as you can. Please do not plagiaries.
If you deem fit, you can add more part_brands in.
part_cat
I’ll need a short write up in the description on each entry. Please do not plagiaries.
if you deem fit, you can add new categories as you start adding parts (see later), and can’t find an appropriate category to fit that new part in.
car_brand
I’ll need a short write up in the description on each entry. Please do not plagiaries.
These are all the car brands i need. there is no need to add anymore.
car_series structure id,name,car_brand,description
This is the series of car for each car_brand. For example, Honda released the FD and FG series in 2008, and Subaru released the 2008/2009 Impreza GH series etc etc
I’ll need a short write up in the description on each entry.
car_brand will refer to the “car_brand” tab, a numerical value
car structure id,name,car_series,description
This is the car. Each car will refer to a particular series. For example, 2008 STI will refer to 2008/2009 Impreza GH series in car_series.
I’ll need a short write up in the description on each entry.
product_series structure id,name,part_brand,description
For every part_brand, some of them will have product series. For example, Cusco has the Zero2E series. However some may not.
part_brand is a numerical input that refers to the part_brand entry
I’ll need a short write up in the description on each entry.
parts structure id,name,part_cat,product_series,part_no,colors,manufacturer,description,images
This is massive. For each part brand in the above list, I’ll need you to compile and fill in the details, all in here.
part_cat will refer to the part_cat entry
product_series will refer to the product_series entry. parts may or may not belong to a series.
part_no is simply the part number that can be found with the catalogue u are compiling from.
manufacturer will refer to the part_brand.
I’ll need a short write up in the description on each entry.
Please attach any images here. Rename the files and key the file names here.
part_car structure part_id,car_id
For each part entry, they will have an application to a particular car entry.
This is where you’ll enter the relationship.
For example, part #4 will have an application for car #20.
Each part may have multiple application, so it can take more than 1 lines for each part.
Looking forward to your quote!
Thanks
