Cartridge Database (cross-referencing)

Cancelled Posted Jan 24, 2012 Paid on delivery
Cancelled Paid on delivery

Hello,

We have 5 859 cartridges and 12 288 printer-models. These are populated in an Excel-spreadsheet (see attached file).

The first blade called "categories" contains the list of the printer-models. The second blade called "products" contains the list of the products.

As you can see from the spreadsheet, each printer-model has a unique "category_id". And every product has a unique "model". Your assignment will be to use the unique product-model to look up (from a webbsite which I will provide for you) which printer-models the specific product fits to, and then look up what their corresponding category-id in our spreadsheet is. These category-ids then needs to be inputed with comma-separation for the specific product in the spreadsheet.

All the input will be in the "Products"-blade. The "Categories"-blade is only needed to look up what category-id the printer-models have.

To give you an example what the steps are:

1. Get a product-model from the spreadsheet. We will take the first one: BU-100CL

2. Go to the website and look up which printer-models it fits to. In this case it fits the following printers:

Brother DCP 9040CN, Brother DCP 9042CDN, Brother DCP 9045CDN, Brother DCP 9045CN, Brother HL 4040CN, Brother HL 4050CDN, Brother HL 4070CDW, Brother MFC 9440CDN, Brother MFC 9440CN, Brother MFC 9450CDN, Brother MFC 9840CDW,

3. Go to the spreadsheet under the blade "Categories" and look up what category-id these printer-models have. In this case the category-ids are the following: 511,512,514,346,347,348,349,786,787,788,803

4. Go to the "Products"-blade and input the category-ids under the column "categories" with this exact format: 511,512,514,346,347,348,349,786,787,788,803

This needs to be done 5 859 times (the amount of products there is).

It's is very important that the amount of rows in the spreadsheet is untouched. Your assignment is not to remove anything, only to add data to the "categories"-column under the "Products"-blade.

Payment will be guaranteed upon completion and after verification of data integrity.

Regards,

Data Entry Data Processing Excel

Project ID: #1407117

About the project

Remote project Active Jan 24, 2012