I have a 7000+ product csv excel file that contains product info from various(5+) dropshippers. Many of the products have been discontinued and need to be removed from the site. My dropshippers provide current csv excel files. I need to reconcile the information without losing the info in the current csv excel file being used. Project consists of editing the current csv file to edit items no longer available and also creating a second csv file with the items that are not currently on the site and need to be added. Please see attached files as a reference. The 2006 file has the products currently on the site, the 2007 file is the file with currently available items. There is one item in common.. the code. (Note in examples that the code in the 2006 file has three letters in front of it... very easy to remove to reconcile the files and then needs to be added back.) For items no longer available, need to change Orderable to "No" and replace the headline with "Discontinued please make another selection". I am sure this can easily be done quickly with an excel formula. Bid is to do the work and provide me with the formula / teach me how to update. Bid is to reconcile all data files. I have already divided up the main data file into subsections based on dropshipper and downloaded the new dropship files... eliminating products I don't need.
1. Reconcile all data files with current inventory by changing Orderable to "No" and replacing Headline with "Discontinued..."
2. Give me the formula / teach me to reconcile two excel documents with one thing in common (code).
3. Create second file for each dropshipper with products that need to be added.
Will be working with FOUR dropshippers and files. Not all products from dropshippers are on site or will be added... just camping related products.
Please only bid if you can do the work. I am having to repost as previous bidders did not accept the job in a timely manner.
16 freelancere byder i gennemsnit $54 på dette job
I can write you a script that will update your list automatically everyday. I can even have it all automated. Ive done it many times before, so long as your dropshippers provide you with live xml or csv feeds.
I suspect you are having to repost your project several times since the price band selected for this class of project in perhaps not adequate. Please see PMB for details of our proposal. Ajay
i able to do the work in four days i am expert to do this work before and i had an idea to this work bysimplest way if you are intersted .i do the job....