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.
Hi, I have gone through both the files and read carefully the description. I had previously made a bid for this project, but unfortunately not the winner. I can definitely do this job. It is easy for me. Instead I c Daha Fazla
16 freelancers are bidding on average $54 for this 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
Hi, I am very keen to do your project. I have understood your project and I would be able to provide you required data. I will also provide you step by step process and formula to reconcilation of spreadsheet. looki Daha Fazla
I can accomplish the task that you have asked for. I've good work experience and knowledge in MS Excel.
Get it done [url removed, login to view] let me know if you are intrested. Thanks.
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....