Base data exchange. Files Eksel

Given

Two files Eksel from suppliers.
They need to download, process.

You need a database, which will store the table data:
Name, group, subgroup, weight, price, dimensions, legal document, vendor.

Name – it needs to recognize.(it is not always spelled out), if you can't identify, be placed in a separate group.

Group – the group of products under which are to be uploaded data in a ready-eksel
Subgroup in one group of products may be sub-groups (may not be), but are uploaded in the same file.
Weight – the weight of the goods. He is often in tons, have to convert to kilograms and record.
Price – you need to write the current price of the provider if one of the providers lower the price, then put it. Need to do mass
edit the prices as a price list and one category.
Dimensions – see convert to mm.
Regulatory document series or GOST, which produce the goods. Upload don't need in the finished file.
Supplier – file from which the downloaded data.

Everything must yield to the edit,
Some data may be missing – insertion manually.

Goods can be added from suppliers – add.

With the next update (download price) – must be updated pictures.

And plus the ability to export data in 1C 7.7. (optional). You can make a project without it.