Jump to content
Latest News: (loading..)
14steve14

Batch update orders and print invoices

Recommended Posts

HHHHEEEEEELLLLLLPPPPPPPP

I have spend ages searching through the apps site and got absolutely nowhere. Can someone point me in the direction of an addon that will allow me to batch update order status's, send an email to the customer, and then be able to print the selected invoices or packing slips.

I have found several, but nothing that has been updated since something like 2008. I dont mind updating code if needed, if I can. Are others using anything to do this task, and if so what are they using. Any help greatly received.

I am using the BS version of osc but I dont think that will make too much difference as this is something in the admin.


REMEMBER BACKUP, BACKUP AND BACKUP

 

Find information about the bootstrap community version here

 

Make it idiot proof and someone will make a better idiot.

Share this post


Link to post
Share on other sites

The basis as I see it (have a new page for this, removed from the usual admin/orders.php page);

It would be similar to orders.php, main differences;

add in a tickbox on each order line

at the bottom add in a dropdown for order statuses
at the bottom add in some buttons;

[batch invoices] {opens new window with invoices ready to print}
[batch packing slips] {opens new window with packing slips ready to print}
[update order status] {links to dropdown selection}

Keeps the engineering to a minimum but does what you want...
and can be extended in the future, fairly easily.

Only drawback would be this;

If you want to update a bunch of statuses AND print off invoices AND print off Slips...
It would be a click on each button.

Edited by burt

This is a signature that appears on all my posts.  
IF YOU MAKE A POST REQUESTING HELP...please state the exact version
of osCommerce that you are using. THANKS

 
Get the latest current code (community-supported responsive 2.3.4.1BS Edge) here

 

Share this post


Link to post
Share on other sites

I currently have batchprint_noPDF with tickboxes that allows for statuschange and another update-o-matic that takes a list of order ids, status update and comment to email to every order listed.

For me it is not a problem as I print the order for orderpicking first, put them in order processing status - people just get the status update. At that time I don't know yet if there is a problem or not with the order, so I rather not add any message.

The list of order ids in the update-matic is the same list I use to generate the shipping labels (for belgian and dutch posl), so the email basically says, shipping with xyz soon, and give tracking instructions for the specific carrier.

And for DPD I have a nice csv upload that @burt provided that takes care of the emailing too


KEEP CALM AND CARRY ON
FYI Upgrade to the highest PHP version you can( PHP 5.5/5.6 or 7.1  and get big performance improvements for free)

But be aware php 5.5 is more strict about things.
UTF8-without BOM, no extra spaces allowed at the beginning or end of your php file, or your redirects wont work.
No double declarations of functions allowed - used to slip through the cracks ...

 

Find the most frequent unique errors to fix:

grep "PHP" php_error_log.txt | sed "s/^.* PHP/PHP/g" |grep "line" |sort | uniq -c | sort -r > counterrors.txt

Share this post


Link to post
Share on other sites

As a FYI, i have added a field to the order table to keep track if the order has been printed or not.


KEEP CALM AND CARRY ON
FYI Upgrade to the highest PHP version you can( PHP 5.5/5.6 or 7.1  and get big performance improvements for free)

But be aware php 5.5 is more strict about things.
UTF8-without BOM, no extra spaces allowed at the beginning or end of your php file, or your redirects wont work.
No double declarations of functions allowed - used to slip through the cracks ...

 

Find the most frequent unique errors to fix:

grep "PHP" php_error_log.txt | sed "s/^.* PHP/PHP/g" |grep "line" |sort | uniq -c | sort -r > counterrors.txt

Share this post


Link to post
Share on other sites

Sorted thanks to help from Gary. Much appreciated.


REMEMBER BACKUP, BACKUP AND BACKUP

 

Find information about the bootstrap community version here

 

Make it idiot proof and someone will make a better idiot.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×