Jump to content



Photo
- - - - -

Additional Orders Info


  • Please log in to reply
74 replies to this topic

#1 ONLINE   Jack_mcs

Jack_mcs
  • Members
  • 26,414 posts
  • Real Name:Jack York
  • Gender:Male
  • Location:Michigan

Posted 20 September 2008 - 02:51

This contribution consists of code that has been around for several years and some of my own code. I thought uploading it as a contribution might be helpful to others, so here it is.

It adds the following to the shops orders section, making it much easier to check the orders at a glance.

Orders list page:
Orders ID

Orders list page - right column:
Shipping Method
Comments
Products Ordered
Other Orders

Orders edit, Invoice and packing Slip pages:
Customers ID
Order ID
Date & Time
Shipping Method

Invoice page:
Option in admin->Shipping/Packaging to display comments

Packing Slip page:
Option in admin->Shipping/Packaging to display comments
Option in admin->Shipping/Packaging to display signatures

Jack

Edited by Jack_mcs, 20 September 2008 - 02:54.


#2   Nathali

Nathali
  • Members
  • 368 posts
  • Real Name:Nathali
  • Gender:Female

Posted 06 October 2008 - 10:25

This contribution consists of code that has been around for several years and some of my own code. I thought uploading it as a contribution might be helpful to others, so here it is.

It adds the following to the shops orders section, making it much easier to check the orders at a glance.

Orders list page:
Orders ID

Orders list page - right column:
Shipping Method
Comments
Products Ordered
Other Orders

Orders edit, Invoice and packing Slip pages:
Customers ID
Order ID
Date & Time
Shipping Method

Invoice page:
Option in admin->Shipping/Packaging to display comments

Packing Slip page:
Option in admin->Shipping/Packaging to display comments
Option in admin->Shipping/Packaging to display signatures

Jack

Hi Jack..!

Could you please post a snapshot ?

Thanks,

Best regards,
Nathali
Best Regards,
Nathali

#3 ONLINE   Jack_mcs

Jack_mcs
  • Members
  • 26,414 posts
  • Real Name:Jack York
  • Gender:Male
  • Location:Michigan

Posted 08 October 2008 - 01:56

A new version has been uploaded with the following changes:

-> Added code to highlight selected payment methods
-> Added code to show completed orders as well as the total number of orders
-> Added screenshots

Jack

#4   acidrush

acidrush
  • Members
  • 22 posts
  • Real Name:acid

Posted 18 October 2008 - 23:02

This is a good contribution!

But i have a litlle problem.

When i try import he sql I get this message:

Hiba

SQL-kérés: Dokumentáció

INSERT INTO configuration( configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added, use_function )
VALUES (
'', 'Show Orders Comments - Invoice', 'SHOW_ORDERS_COMMENTS_INVOICE', 'true', 'Display the orders comments on the Invoice<br>(true=on false=off)', '7', '13', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now( ) , NULL
);

MySQL jelzi: Dokumentáció
#1366 - Incorrect integer value: '' for column 'configuration_id' at row 1


I'm newbie and i cant figure what is the problem.

Please help me if you can!

Sorry for my english

Thanks a lot......

#5 ONLINE   Jack_mcs

Jack_mcs
  • Members
  • 26,414 posts
  • Real Name:Jack York
  • Gender:Male
  • Location:Michigan

Posted 19 October 2008 - 02:05

Try changing the part that reads
VALUES (
'', 'Show Orders Comments
to
VALUES (
NULL, 'Show Orders Comments

Jack

#6   acidrush

acidrush
  • Members
  • 22 posts
  • Real Name:acid

Posted 19 October 2008 - 07:21

Try changing the part that reads

VALUES (
'', 'Show Orders Comments
to
VALUES (
NULL, 'Show Orders Comments

Jack


Thanks alot!

This is solve my problem! /biggrin.gif' class='bbc_emoticon' alt=':D' />


Great contribution!

#7 ONLINE   Jack_mcs

Jack_mcs
  • Members
  • 26,414 posts
  • Real Name:Jack York
  • Gender:Male
  • Location:Michigan

Posted 05 February 2009 - 03:11

A new version has been uploaded and contains these changes:

-> Changed mysql file to be strict-mode compatible
-> Changed code for comments to only show those meant to be seen by the customer
-> Added code to display other orders for Purchased Without Account orders

Jack

#8   piltri

piltri
  • Members
  • 11 posts
  • Real Name:Piltriano

Posted 14 February 2009 - 08:25

Sorry but i dont find where

Invoice page:
Option in admin->Shipping/Packaging to display comments

Packing Slip page:
Option in admin->Shipping/Packaging to display comments
Option in admin->Shipping/Packaging to display signatures


it works but i dont find where are this options. During the instalation i had not any error (I thnik /rolleyes.gif' class='bbc_emoticon' alt=':rolleyes:' /> )

Thanks.

#9 ONLINE   Jack_mcs

Jack_mcs
  • Members
  • 26,414 posts
  • Real Name:Jack York
  • Gender:Male
  • Location:Michigan

Posted 15 February 2009 - 01:36

Did you run the mysql file?

Jack

#10   piltri

piltri
  • Members
  • 11 posts
  • Real Name:Piltriano

Posted 15 February 2009 - 21:08

Yes.

This sql, acording AdditionalOrdersInfo_V_1.2

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added, use_function)
VALUES (NULL,'Show Orders Comments - Invoice', 'SHOW_ORDERS_COMMENTS_INVOICE', 'true', 'Display the orders comments on the Invoice<br>(true=on false=off)', '7', '43', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now(), NULL);
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added, use_function)
VALUES (NULL,'Show Orders Comments - Packing Slip', 'SHOW_ORDERS_COMMENTS_PACKING_SLIP', 'true', 'Display the orders comments on the Packing Slip<br>(true=on false=off)', '7', '44', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now(), NULL);
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added, use_function)
VALUES (NULL,'Show Packing Slip Signatures', 'SHOW_PACKING_SLIP_SIGNATURES', 'true', 'Add lines for Signatures on the packing slip<br>(true=on false=off)', '7', '45', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now(), NULL);
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added, use_function)
VALUES (NULL, 'Show Orders Status Check', 'SHOW_ORDERS_STATUS_CHECK', 'Delivered', 'Set Orders Status name used in your shop to indicate a completed order. A comma separated list may be used if more than one name is used.', '7', '46', NULL, now(), NULL);
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added, use_function)
VALUES (NULL, 'Show Orders Highlight Payment', 'SHOW_ORDERS_HIGHLIGHT_PAYMENT', 'Cash on Delivery', 'Set the payment method that should be highlighted. Leave blank for none or use a comma separated list to mark more than one.', '7', '47', NULL, now(), NULL);


but i dont see nothing new in anywhere accordin the configuration.

Thanks.

#11 ONLINE   Jack_mcs

Jack_mcs
  • Members
  • 26,414 posts
  • Real Name:Jack York
  • Gender:Male
  • Location:Michigan

Posted 15 February 2009 - 21:33

Then your Shipping/Packaging section in admin must use a non-standard ID. The only way you can tell where it is woud be to look in the database.

Jack

#12   piltri

piltri
  • Members
  • 11 posts
  • Real Name:Piltriano

Posted 16 February 2009 - 10:22

Ok.

I dont know if may iadmin is or not standartd but i'll try to right.

Could you please post a snapshot where is the correct?

And, whre i can put the new comments?. I had a true the display but i dont know whre i put it.

Thanks.

Edited by piltri, 16 February 2009 - 10:34.


#13 ONLINE   Jack_mcs

Jack_mcs
  • Members
  • 26,414 posts
  • Real Name:Jack York
  • Gender:Male
  • Location:Michigan

Posted 16 February 2009 - 13:38

Go to admin.
In the left column, click on the Configuration group.
In that group, click on the Shipping/Packaging link.

Jack

#14   piltri

piltri
  • Members
  • 11 posts
  • Real Name:Piltriano

Posted 18 February 2009 - 20:03

Thanks. I ''ll try it.

#15   Desertsky

Desertsky
  • Members
  • 120 posts
  • Real Name:Paul Mcintosh

Posted 04 April 2009 - 09:37

I am looking for a contribution, or instructions, for putting the shipping method on the packing slip. This one seems to indicate that but is not real clear. Can you help?

#16 ONLINE   Jack_mcs

Jack_mcs
  • Members
  • 26,414 posts
  • Real Name:Jack York
  • Gender:Male
  • Location:Michigan

Posted 04 April 2009 - 11:53

Yes, it does that.

Jack

#17   i2Paq

i2Paq
  • Members
  • 257 posts
  • Real Name:Norman

Posted 09 June 2009 - 17:31

Jack,

Thanks for great contrib, again.

Just a short question or 2:
1. When it says *comments it just means that there are comment with this order.
It will not show them below the word *comments?

If not, I have the comments-at-a-glance contri installed AND the order-at-a-glance but this gives me some more info.

2. What does this mean:

Other Orders: 1
Completed: 0
Totaling: €106.95

Thanks again!

Edited by i2Paq, 09 June 2009 - 17:32.

Norman in 't Veldt

Moderator
osCommerce The Netherlands

#18 ONLINE   Jack_mcs

Jack_mcs
  • Members
  • 26,414 posts
  • Real Name:Jack York
  • Gender:Male
  • Location:Michigan

Posted 09 June 2009 - 17:48

Jack,

Thanks for great contrib, again.

Just a short question or 2:
1. When it says *comments it just means that there are comment with this order.
It will not show them below the word *comments?

If not, I have the comments-at-a-glance contri installed AND the order-at-a-glance but this gives me some more info.

2. What does this mean:

Other Orders: 1
Completed: 0
Totaling: €106.95

Thanks again!

1 - The comments is just an indicator showing that there are comments in the order. The next version will show the comment (or part of it).

2 - Other Orders: 1 - one other order has been made by this customer
Completed: 0 - should be the number of completed orders. I'll have to check this since it used to work but I see now it doesn't.
Totaling: €106.95 - total of all orders by this customer.

Jack

#19   i2Paq

i2Paq
  • Members
  • 257 posts
  • Real Name:Norman

Posted 09 June 2009 - 18:30

1 - The comments is just an indicator showing that there are comments in the order. The next version will show the comment (or part of it).

2 - Other Orders: 1 - one other order has been made by this customer
Completed: 0 - should be the number of completed orders. I'll have to check this since it used to work but I see now it doesn't.
Totaling: €106.95 - total of all orders by this customer.

Jack


OK, thanks for you answer.

If you could fix the Completed part then I will hand you a fix to make your contribution fully Multilingual in the orders.php.
The others will follow shortly /cool.gif' class='bbc_emoticon' alt='B)' />

4) Add the following to the end of the admin/includes/languages/english/orders.php
file before the last ?>. Also add it to any other language file you use.

/*** BOF: Additional Orders Info ***/
define('TEXT_INFO_SEE_OTHER_ORDERS', 'Click to see other orders');
define('TEXT_INFO_SHIPPING_METHOD', 'Ship by: ');
define('TEXT_INFO_OTHER_ORDERS', '<b>Other Orders:</b>&nbsp;%s<br>&nbsp;<b>Completed:</b> %s<br>&nbsp;<b>Totaling:</b> %s');
define('TEXT_INFO_PRODUCTS_ORDERED', 'Products Ordered: ');
define('TEXT_INFO_CUSTOMER_NUMBER', 'Customernumber: ');
define('TEXT_INFO_ORDER_NUMBER', 'Ordernumber: ');
define('TEXT_INFO_DATE_TIME', 'Order Date and Time: ');
/*** EOF: Additional Orders Info ***/


and:

FINE (around line 93)

<td><table border="0" cellspacing="0" cellpadding="2">

INSERT AFTER:

/*** BOF: Additional Orders Info ***/
?>
<!-- Customers ID# // -->
<tr>
<td class="main"><b><?php echo TEXT_INFO_CUSTOMER_NUMBER; ?></b></td>
<td class="main"><?php echo $the_customers_id; ?></td>
</tr>
<!-- add Order # // -->
<tr>
<td class="main"><b><?php echo TEXT_INFO_ORDER_NUMBER; ?></b></td>
<td class="main"><?php echo tep_db_input($oID); ?></td>
</tr>
<!-- add date/time // -->
<tr>
<td class="main"><b><?php echo TEXT_INFO_DATE_TIME; ?></b></td>
<td class="main"><?php echo tep_datetime_short($order->info['date_purchased']); ?></td>
</tr>
<tr>
<td class="main"><b><?php echo TEXT_INFO_SHIPPING_METHOD; ?></b></td>
<td class="main"><?php echo tep_get_orders_shipping_method($oID); ?></td>
</tr>
<?php
/*** EOF: Additional Orders Info ***/



Hope you like this /smile.gif' class='bbc_emoticon' alt=':)' />

Edited by i2Paq, 09 June 2009 - 18:31.

Norman in 't Veldt

Moderator
osCommerce The Netherlands

#20 ONLINE   Jack_mcs

Jack_mcs
  • Members
  • 26,414 posts
  • Real Name:Jack York
  • Gender:Male
  • Location:Michigan

Posted 22 June 2009 - 16:32

A new version has been uploaded with these changes:

-> Added code to display part of the comments in the side panel
-> Added code to display a warning if the billing and shipping address do not match
-> Fixed other orders section to display accurately
-> Moved the options in admin to the configuration section

Jack