Compare upate file and update xls file
$30-250 USD
Pagado a la entrega
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
Nº del proyecto: #6117889
Sobre el proyecto
7 freelancers están ofertando un promedio de $154 por este trabajo
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...
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
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 Más