Jump to content
Sign in to follow this  
puddled

Multiple order update

Recommended Posts

Just released to the contributions section is a multiple order update tool.

 

This mod allows for the updating of several orders status in one go.

 

Also has the facility to bring up specific orders to allow printing of invoices / packing slips, without having to go through each individual order process in turn.

 

This package is still in beta, but has been tested with MS1 and CVS2.2, being created with the latest snapshot (11/04/2003)

 

Very simple to install, with only one line of code added to the customers box on the admin side.

 

http://www.oscommerce.com/community/contributions,1152


Instant idiot......Just add mud !!

Share this post


Link to post
Share on other sites

Thanks for this, if i can get it going it will be a life saver :)

 

Im running a pre. nov. 1st snapshot (october 29th, i think) so wasn't relly expecting it to work, but it almost does, so i thought it was worth asking here for ideas.

 

Initially i got an error regarding an IP address table being missing, so i just removed this from the query and it seems to work just fine, except for that i can select multiple orders and choose the status update etc. but when i press the 'submit query' button nothing happens, it is as if no information is being submitted.

 

The page all looks ok, this is the bottom of the page where the submit button resides, does this look in order?

 

1.jpg

 

Any help greatly appreciated.

 

Cheers

 

Matt

www.consoleplus.co.uk

Share this post


Link to post
Share on other sites

Yes,

 

Thats how the page should look.

 

If you can load the page, do a view source and copy the page soure onto a text file, and email it to me, I will have a look at it for you.

 

email to dave@pudlded.co.uk


Instant idiot......Just add mud !!

Share this post


Link to post
Share on other sites

David-

 

This looks to be a very cool module. I just downloaded and installed your module, but I am getting this error:

 

1054 - Unknown column 'o.ip_address' in 'field list'



select o.ip_address, o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from orders o left join orders_total ot on (o.orders_id = ot.orders_id), orders_status s where o.orders_status = s.orders_status_id and s.language_id = '1' and ot.class = 'ot_total' order by o.orders_id DESC limit 0, 20

 

From what I can see the sql statement is looking for the ip_address field in the orders table. I am testing on the latest CVS of OsC and don't see an ip_address field. Is this a bug, or am I missing something?

 

TIA!

-Jack


jackhandy - http://jackhandy.com

Share this post


Link to post
Share on other sites

Found a problem that might be the cause this for me and consoleplus,

the file orders_editable.php has reference to this file:-

 

<script language="javascript" src="includes/menu.js"></script>

 

Maybe i'm being stupid but I can't find this in my snapshot anyone have it in a later one I only have general.js.

 

Any ideas?

Share this post


Link to post
Share on other sites

I still have the same problem, i found a few small errors in the code, but upon fixing them i still have the same result :(

 

Not sure about the menu.js, probably just a reference to some navigation code that was left in the code, i don;t think it causes our problem, but you never know! will take another look later today.

 

Cheers

 

Matt

Share this post


Link to post
Share on other sites

Has anyone made any progress on this?

 

I have so many orders coming in it takes me all day to print them and change status.

Share this post


Link to post
Share on other sites

I took the page and and ran "convert to xhtml" in dreamweaver mx and after that the page is working. There seem to be some fatal mistakes on the html forms.


"Use no way as way, have no limitation as limitation." - Bruce Lee

Share this post


Link to post
Share on other sites

I tried that mazza did not work for me.

 

What snapshot are you using?

 

After looking at this over and over again I just can't see why it would work on a Ms1 but not on an earlier version. They are not that far apart.

 

I would understand if it came up with TEP errors, but this says nothing it just doesn't work.

 

Can anyone shed light on the differences between Ms1 and older snapshots that might cause this mod problems.

 

Please :wink:

 

Nev

Share this post


Link to post
Share on other sites

After some searching through the code, I found why the submit button is not functioning. Around line 418 of orders_editable.php you'll find this:

 

<tr>

               <td colspan="6"><table border="0" width="100%" cellspacing="0" cellpadding="2">

                 <tr>

                   <td class="smallText" valign="top"><?php echo $orders_split->display_count($orders_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, $HTTP_GET_VARS['page'], TEXT_DISPLAY_NUMBER_OF_ORDERS); ?></td>

                   <td class="smallText" align="right"><?php echo $orders_split->display_links($orders_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $HTTP_GET_VARS['page'], tep_get_all_get_params(array('page', 'oID', 'action'))); ?></td>

                 </tr>

               </table></td>

             </tr>

 

Grab that code and move it about eleven lines down, just below this:

 

<td class="smallText" align="right"><?php echo HEADING_TITLE_STATUS . ' ' . tep_draw_pull_down_menu('new_status', $orders_statuses, '', ''); ?></td>

             </td>

             <td><input type=submit vlaue="edit Orders"></td>

             </tr>

 

That should fix the problem. The reason this is done, is that the section of code that was moved had a "</form>" tag in it, which it's supposed to, but caused the submit button to do nothing.

 

Also:

Make sure you've deleted the three references to o.ip_address.

Share this post


Link to post
Share on other sites

Excellent leolll & radders it's fixed.

 

Weird that it worked with a newer snapshot though don't you think?

 

Only things to sort out now:- No email is sent to customer when changing order status and the invoices not being put into one html file, to print all at once.

 

Any ideas??

 

Thanks for your hard work guys. :)

 

Nev

Share this post


Link to post
Share on other sites

Yes I agree thatose things are what is needed. On the printing I thought of using the option to print all linked pages that you get from the normal print menu. When I tried that though it printed the list of orders rather than the javascript pop-ups. Maybe if the links were made without javascript and the return option was removed it would print all orders.

Sorry I'm not explaining this very well.

Share this post


Link to post
Share on other sites

Yes, the auto email would be very useful. As would a small box to enter comments.

 

Thanks for this mod.

Share this post


Link to post
Share on other sites

I've discovered how to mass print these things cleanly from the print window.

 

What you have to do is delete the javascript and the javascript part of the link and add a target="_blank"

 

then when you goto print you click print all linked documents and your invoices should all print out nice and neatly.

 

I can post code if someone would like.


Assault

If you want to find it you'll have to google "Assault T-Shirts" because posting my damn url in my signature is against the forum rules.

T-Shirts with an edge

Powered by OSCommerce + about 20 different custom addons and some Wordpress

Share this post


Link to post
Share on other sites

right around line 70 delete all the javascript code, my code looks like this after:

 

  <a href="<?php echo tep_href_link('invoice.php?oID=' .$option[$p]); ?>"target="_blank">Print Invoice for order # <? echo $option[$p]; ?></a><BR>


Assault

If you want to find it you'll have to google "Assault T-Shirts" because posting my damn url in my signature is against the forum rules.

T-Shirts with an edge

Powered by OSCommerce + about 20 different custom addons and some Wordpress

Share this post


Link to post
Share on other sites

yeah that works really well. Thanks.

 

Does anyone know how to email the customers on the multi status changes or even how to begin?

 

Nev

Share this post


Link to post
Share on other sites

Where are you getting the option to print all linked documents? So far I can only print one at a time.


"If you rundown your shadow, you will never catch it"

Bob Marley

Share this post


Link to post
Share on other sites

It is a checkbox in the bottom left hand corner of the print widow put up by Internet Explorer

Share this post


Link to post
Share on other sites

Sorry for the stupid question but what I can't find is the bit of code that calls the javascript popup in the first place. What file is it in? I was looking in orders_editable.php but it isn't there.

Share this post


Link to post
Share on other sites

No its around line 70 on edit_orders.php in your admin folder this is the page that creates the popup.

 

On my computer the print all linked documents is on the options page(second page) of the print window on the left.

 

Nev

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
Sign in to follow this  

×