Project Description:
We require a programmer to assist in work on our database export. We currently use 3 processes to update our database.
Process 1 consists of extracting data from CSV files that our located on our servers. We will choose which CSV file to work from (we have 3 seperate files to extract details from), then we will choose which category we want to extract.
Process 2 will then cross reference the items in the extracted CSV to our database to see if the item already exists by way of part number. If the product exists then it will drop it from the CSV and the output file will have all the new products that do not exist.
Process 3 will allow us to insert the newly created file into the category of choice.
We need to combine the first 2 processes. Then on the same page we need the have the function to choose which category to insert this into which will be a separate process after the exported file has been examined, edited and approved.
This is an oscommerce base store.
Additional Project Description:
12/05/2012 at 18:41 EST
We also require a login screen for this newly created section.