The database should allow :
1) Import of external database e.g. models ( brand/model/capacity/year)
2) Manually adding simple products ( product ID + product category name - assigned to the given : brand / model / capacity / year.
One product can match dozens or even hundreds of models (successive years of production, models, brands, etc.)
3) Export all products to Excel in the format: product ID/category name/brand/model/capacity/year
The most important thing is to make it as easy as possible to add new products which are tens of thousands and each of them fits sometimes to 1 sometimes to 400 models. Often it is e.g. the same model/the same brand/the same capacity/ but year 90..91..92..93... etc which after export should be placed on separate lines, but when entering them it would be good to specify e.g. from - to .
4) The possibility of preparing an export of the entire list as well as a list of specific IDs.
I ask for a quote and a time limit offer.