Order Invoices and Packing Slips Question

[nrg77]

Does anyone know how or know of a module out there that can print all/ or print selected invoices and packing slips on the customer's order page?

Having to click into the order and click invoice/packing slip and then click print is a lot of hassle if you get 100 orders a day. The process we run is print out all packing slips for all the current orders and hand them to the warehouse guys to process and packup the products.

Anyone?

[wolfsz]

Hi there
We don't you create a SQL report for this?
All the info you require to create a packing "report" is in the orders table. Simply use phpMyAdmin or whatever interface your host supples select the relevant fields.
To get you started here is a report
select zen_orders_products.orders_id, zen_orders_products.products_quantity, zen_orders_products.products_name
from zen_orders_products
where zen_orders.date_purchased >= '2006-02-01' and zen_orders.date_purchased <= '2006-03-31'
group by zen_orders_products.orders_id;

[nrg77]

Because this is for the employees to handle and they have not a clue what even html is let alone SQL queries.

[wolfsz]

Excuse me mate but this is a suggestion where you write a report and either you run it, train an employee to run or you integrate the report into the admin section so you can run it from there.

[Sam_uk]

nrg have you tried the SuperOrders dontrib, a great module for batch updating and also for batch printing or printing selected orders. It can do the invoices, shipping or packing labels.

[nrg77]

No, I haven't heard of that one yet. Thanks, I will look into it....

[nrg77]

After looking into it, I am not sure if its compatible with 1.3.7....

[Sam_uk]

I am using superorders with 1.37 and all is working well.
except for the emails.

[nrg77]

For me, when I use batch update status, it gives me an SQL error. Also, on the batch update page, my "comment" box to write to the customer is so narrow like one character wide. How am I suppose to see what I am typing?

If you know how to fix these two issues, please inform me.

Thanks..