I have been searching for a couple of days now for a resolution to this issue, and while I find a few references to it in google, nothing really defines the entire process.
I have a MySql table called 'product_distribution'
When a customer orders a product, all pertinent information is recorded in the table
Periodically the admin needs to 'Process' these records
I can do a query to extract the product order information from the product_distribution table and the shipping address from the members table, but I need to output it in a special format.
The result of processing the records needs to be to send the product distribution center a listing in the correct format to print on an avery 5160 sheet of labels, which is 3 across and 10 up... Pretty standard format.
Standard formatting of the information in a columnar format in tables seemed to me to be an easy solution, but appears to be too volatile, and not near exacting enough.
Researching leads me to believe that producing a PDF formatted to the 5160 label sheet would probably be the most reasonable solution..
Then several hours of researching uncovered several possible options to accomplish that, but still nothing firm and complete enough for me to complete that phase of the project...
Any Suggestions / Solutions / Direction / ....
Thank you in advance.