Good Morning All,
This is a question I touched on previously, but don't think I presented what I really need to do.
I need to get this accomplished ASAP, and really have no clue how to go about it. Would even be willing to pay someone else if they have the solution and can get it implemented.
On the membership site I've been developing, they are ordering products of various types... the orders are gathered together and fulfilled periodically (daily generally).
When the order is fulfilled, I need to print labels (30 up on an 8 1/2 x 11 sheet) Avery Labels.
Currently, I am going into mysql and doing the query to extract the pertinent information, then exporting that to an excel spread sheet, then saving the excel sheet...
Then I go to the avery.com website, and use a tool that they have that loads data from an excel spreadsheet and arranges it one field at a time onto the label format, and then it does a merge of all the data to fill all the labels in the same format.
Then you save / print the document, and it creates a .PDF which I print onto the label stock as well as save for future reference.
Long story short.... I would like to accomplish ALL of this through a PHP program, so the admin of the site would be able to run a report of orders on file, and have it produce the labels programically, as opposed to me having to manually manipulate the data to extract it.
Any Suggestions / thoughts / solutions / volunteers... LOL
Thanks in advance for your responses.