We require a talented PHP / SQL code writer to create an admin page on our site that takes the details of orders from an xls file and then places the data into a database whilst also creating a printable page designed to print onto an Avery label sheet.
We use paypal and googlecheckouts to take payments for orders of our products and we would like to be able to integrate the payments from ebay via paypal into our system to cut down on the time taken to write the customers details on envelopes. To do this we will download the days transactions from paypal as an xls file. We then want a page on our admin section of our website on which will be an upload and browse box thing to allow us to upload the xls file. The code will then extract the customers details and put them into our order database and at the same time create a html page in a new window or tab which will form the same layout as the Avery Labels word doc. templates, with each label containing a customers order details - their name, address and product.
We will then want a button on this page which we can click to send the page to the printer where the page will be printed onto Avery Label sheets. If you are unfamiliar with Avery Labels go to [url removed, login to view] and look at the blank label templates. We require a page creating that will print 8 Labels per A4 sheet.
We already have an existing order database and the orders will be added to this database and marked as being from "ebay" and "dispatched".
We actually need the upload function and the creation of the labels to be two seperate functions.
We want the upload of the data from the xls file to occur and the data stored in our database of orders using one page, and then we require a seperate page with functions that allow us to view orders from a selected date period and possible by status. On this page will be the option to click a check button next to each order, or to click a check button at the top to select all new orders, and then options to create the labels and print them for the selected orders, and then options to file the orders as dispatched or cancelled. Selecting one of these and clicking a button will then update the database to show the orders new status.