Compare upate file and update xls file

Cancelled Posted Jun 26, 2014 Paid on delivery
Cancelled Paid on delivery

Scope

Create a stand alone program that make all modifications for me without me having to have any interaction other than giving file names. No loading of additional programs or manual manipulation of files. I have an e-commerce site using creloaded 6.5. All the data is in various tables that I can export to xls or csv.

These are the Source Tables

categories

categories_description

manufacturers

manufacturers_info

products

products_description

products_to_category

products_extra_fields

I get an update file from my supplier called dealer.txt. I need the following done

1- delete any items that have a 0 cost

2- if a part already exists then update that field with the information from the [url removed, login to view]

3- read the name of the category name and put in the field a pre-assigned category number from the existing table

4- Same for manufacturers

5- if a product from [url removed, login to view] is not found then it must be added to the products and associated files (that means its a new item than was not found in the existing table)

6- if category or manufacturer is not found then a new one of each must be created in the associated table.

Once this is all done I should have an XLS file with the given structure and the records updated in this file from the [url removed, login to view] file.

I have just over 4000 items at the moment to process.

I can send sample files upon request

I am using a MAC using OSX 10.9.3

Data Entry Excel

Project ID: #6117889

About the project

7 proposals Remote project Active Jun 26, 2014

7 freelancers are bidding on average $154 for this job

expertatwork

hey Oshoot, please provide the samples, we like to have a look, please reply, thanks !

$55 USD in 1 day
(145 Reviews)
5.8
Harunorrashed86

A proposal has not yet been provided

$55 USD in 3 days
(33 Reviews)
4.4
taimsolution

Hi, I have already done this task before for manipulating excel based on database input. You can see it in my project done. let me know if you are interested...

$222 USD in 3 days
(1 Review)
2.2
alampk110

Hello sir how are you?I see your project i will completed this but first u tell me how can i started thanx reply plz

$155 USD in 3 days
(0 Reviews)
0.0
nayasuka

A proposal has not yet been provided

$200 USD in 5 days
(0 Reviews)
0.0
deservetoearn

Excel user since 1996, high proficiency, accuracy and data entry; it is my day job. My speed in Excel is enhanced by knowing almost all of the keystroke/hotkeys (well beyond Ctrl+C). This keeps my hands away from the More

$155 USD in 3 days
(0 Reviews)
0.0