We have three web sites which are in different languages. .com/.ie in English, .fr in French and .de in German. We need to have a database which will be able to import three product export files and then after some manipulation of the data to be able to both report on the information and also provide a file export facility.
The DB will also need to match up products which have a matching SKU and to update a field to indicate which product is available in which language (site). After the data has been matched we will need a reporting facility which will show all products, all products available in the .com/.ie site, all products on the .fr site and all products on the .de site. Therefore allowing us to report on which products have been translated into which language and which products are outstanding, and yet to be translated. Also, we will require a file export facility which can then be used to import product translations back into our web store. This export file needs to have some logic for one of the fields to include which languages the product is available in and which language we are exporting to.
We will provide examples files and a full specification to the winning bidder.
**Please note: we will only accept bids from bidders with previous access experience. The delivery time for this project is 6 days.**