Summary of Outstanding Orders - Help Please

[Mort-lemur]

Hi,

 

I seem to be getting in a position where I am getting confused over customers orders and where I stand with satisfying the orders.

 

Is there a way that I can view all the items from orders which have not be raised to status of in-pack,despatched or delivered (ie orders that are status "processing"?

 

I know I can look at individual invoices, but this is very time consuming - I really need something that will do this for me at the press of a button or two.

 

Many Thanks

[♥mdtaylorlrim]

Hi,

 

I seem to be getting in a position where I am getting confused over customers orders and where I stand with satisfying the orders.

 

Is there a way that I can view all the items from orders which have not be raised to status of in-pack,despatched or delivered (ie orders that are status "processing"?

 

I know I can look at individual invoices, but this is very time consuming - I really need something that will do this for me at the press of a button or two.

 

Many Thanks

On the entry page in the admin section it displays a list of the most recent customers that registered, and the most recent order changes. It only defaults to a few so I changed it to 20, then 30, then 50, then 100... So far I am holding good with 100 orders listed. The shipper is able to pack and ship out fast enough that the last 100 about covers the in process orders with the new orders placed so I can see them all. A quick jump into the Administration -> Customers -> orders allows me to see all of them if there are some not listed. It would be an easy edit to sort these into status.

 

 

It is a simple edit the files in /admin/includes/languages/english/modules/index to show the number that you want to see on the admin/index page..

 

If it does not suit your needs I'm sure there is an add on or two that would help you out.

[Mort-lemur]

Hi,

 

Thanks for your answer.

 

Im OK with the order side of things - its the actual items on the outstanding orders that I want to display quickly.

 

So that when I speak to my suppliers I have a single sheet with all the outstanding items on it.

 

As soon as I receive from the suppliers I change the status to "in-pack" hence I only want to display items where the order status is "Processing" ie. outstanding from my suppliers.

 

Thanks

[♥mdtaylorlrim]

It would be a simple thing to take the orders.php file and edit it to display only those orders with a status NOT 'Delivered' or whatever you use to signify a completed,delivered sale. Name is pending.php or whatever you want. Even put a drop down with all the status' you have in your file so that you can select to see orders with whatever status you select.

 

I'd be really surprised that someone has not already done that in one of the reports add ons.

[♥mdtaylorlrim]

It would be a simple thing to take the orders.php file and edit it to display only those orders with a status NOT 'Delivered' or whatever you use to signify a completed,delivered sale. Name is pending.php or whatever you want. Even put a drop down with all the status' you have in your file so that you can select to see orders with whatever status you select.

 

I'd be really surprised that someone has not already done that in one of the reports add ons.

Duh...it already is... can't you simply select the order status at the top of the page to see the orders you want?

[Mort-lemur]

Duh...it already is... can't you simply select the order status at the top of the page to see the orders you want?

 

Hi Yes - that show ORDERS - But what I need is to show the actual ITEMS on the orders, so I dont have to open each individual order and write a list myself.

 

I have managed to get part way there with the Orderlist 5.1 contribution - but it provides a bit too much data for my needs, so I will have a go at modifying the code myself - which is bound to end in disaster as I am by no means a php expert.

 

What would be ideal would be a selection box at the top of the "Best Products Purchased" screen so that I could select and show the items that were ordered but with a status of "Processing" - That would give a nice easy list.

 

Thanks

[Mort-lemur]

Hi Again,

 

Well that was easier than I thought! - maybe I'm starting to understand things ?, Just commented out the lines of data that I did not want from orderlist.php (from the wonderful Orderlist 5.1 contribution) and I can now produce printable lists by date / status / customer showing what they have actually ordered - all on one nice neat screen.

 

Many Thanks

[Mort-lemur]

Hi Again,

 

Well that was easier than I thought! - maybe I'm starting to understand things ?, Just commented out the lines of data that I did not want from orderlist.php (from the wonderful Orderlist 5.1 contribution) and I can now produce printable lists by date / status / customer showing what they have actually ordered - all on one nice neat screen.

 

Many Thanks

 

Ok I spoke too soon. When trying to click product links in the order list I now get the following messages:

 

Warning: reset() [function.reset]: Passed variable is not an array or object in /home/xxxxxx/public_html/xxxxxx/includes/classes/object_info.php on line 17

 

Warning: Variable passed to each() is not an array or object in /home/xxxxxx/public_html/xxxxxx/includes/classes/object_info.php on line 18

 

The code for that section looks like this:

 

  class objectInfo {

// class constructor
   function objectInfo($object_array) {
      reset($object_array);
       while (list($key, $value) = each($object_array)) {
       $this->$key = tep_db_prepare_input($value);
     }
   }
 }

 

This is more of an annoyance than anything, but I would like to get it sorted.

 

Thanks

[Mort-lemur]

Anyone ?

[♥mdtaylorlrim]

Anyone ?

Ok, this will probably do what you are trying to do, in a little different way. You will have to add your formatting code and any additional columns, but it may give you a starting point.

 

Around line 415 of the orders.php find and make these edits.

 

               <td class="dataTableContent" align="right"><?php echo strip_tags($orders['order_total']); ?></td>
               <td class="dataTableContent" align="center"><?php echo tep_datetime_short($orders['date_purchased']); ?></td>
               <td class="dataTableContent" align="right"><?php echo $orders['orders_status_name']; ?></td>
               <td class="dataTableContent" align="right"><?php if (isset($oInfo) && is_object($oInfo) && ($orders['orders_id'] == $oInfo->orders_id)) { echo tep_image(DIR_WS_IMAGES . 'icon_arrow_right.gif', ''); } else { echo '<a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID')) . 'oID=' . $orders['orders_id']) . '">' . tep_image(DIR_WS_IMAGES . 'icon_info.gif', IMAGE_ICON_INFO) . '</a>'; } ?> </td>
             </tr>
<?php
// this is the edits for adding products purchased to each line item
$order_detail_query_raw  = "select products_name,products_price from orders_products where orders_id = '" . $oInfo->orders_id . "'" ;
$orders_detail_query = tep_db_query($order_detail_query_raw);
while ($details =  tep_db_fetch_array($orders_detail_query)) {
echo "<tr><td>" . $details['products_name'] . "<td>" . $details['products_price'] . "</td></tr>";
}
// end of product detail
?>

[♥mdtaylorlrim]

Small correction...

 

$order_detail_query_raw  = "select products_name,products_price from orders_products where orders_id = '" . $oInfo->orders_id . "'" ;

 

This line should be...

 

$order_detail_query_raw  = "select products_name,products_price from orders_products where orders_id = '" . $orders['orders_id'] . "'" ;

[BertaRecchia]

It looks like this contribution is not made for V.2.2 RC2. There is not orderlist.php in the catalog/admin/include/languages/english

I only have orders.php and order_status.php.

 

Can I make it work somehow?

 

Thanks.

[Mort-lemur]

It looks like this contribution is not made for V.2.2 RC2. There is not orderlist.php in the catalog/admin/include/languages/english

I only have orders.php and order_status.php.

 

Can I make it work somehow?

 

Thanks.

 

Hi,

 

Not sure I understand your problem - but orderlist.php is one of the new files in the orderlist contribution.

 

Thanks

[BertaRecchia]

1-Well, I read somewhere that this addon is not for my version of oscommerce which is 2.2 RC2

2-I guess I just downloaded the last package which includes only some new instructions. I thought that orderlist.php was supposed to be a basic file in cart. I just went to the older downloads and saw the orderlist.php to install.

 

It's always good to upload the full packages where there's an update.

 

Let me give it a try and see what happens. I'm not a pro at coding :)

 

Thanks.!

[BertaRecchia]

Ok I dowloaded New_Improved_Orderlist5d-LatestComments.zip and reading the install.txt I'm a bit confused

 

NOTE: If you are installing fresh you can SKIP ...... SKIP step 1 - a.) Copy ordrlist_styles.css

 

But in step 1 I have:

1 - a.) Copy "orderlist.php" at the Admin root

 

So, should I skip step 1 "copy orderlist.php" since it's a fresh install ?!

 

Also, in step 2

 

-----------------------------------------------------------------------------

2 - In /includes/application_top put line : for MS1

define('FILENAME_ORDERLIST', 'orderlist.php'); 


for MS1
//Orderlist
define('FILENAME_ORDERLIST', 'orderlist.php');


-----------------------------------------------------------------------------

 

...I'm assuming MS1 is a version of OSCommerce, so since that's not my version, should I skip those 2 lines in Step 2?

 

Thanks for your patience.

[Mort-lemur]

Hi,

 

Skip running the SQL query.

 

Do all the steps - with the exception of those marked with MS1 and any languages you dont use. (MS1 is milestone 1 release of OSC, you are using Release candidate 2 RC2 2.2a)

 

See if it works :-)

 

Thanks

[BertaRecchia]

Thanks for the directions.

 

I followed the instructions and I see the "Generate orderlist " added to the admin but when I click it I get " The requested URL /admin/FILENAME_ORDERLIST was not found on this server."

 

Also, I don't see any instructions on what to do with the images but I'm assuming they have to be copied in the same directories as they reside in the package.

 

Thanks a million!

[BertaRecchia]

It looks like more problems.

 

Under "Customers" i now have 2 instances of "orders" and my "Coupons" menu is gone.

 

I also noticed that some buttons in catalog\admin\includes\languages\english\images\buttons, like the "button_back.gif" are already there.

 

:(

[BertaRecchia]

It looks like more problems.

 

Under "Customers" i now have 2 instances of "orders" and my "Coupons" menu is gone.

 

I also noticed that some buttons in catalog\admin\includes\languages\english\images\buttons, like the "button_back.gif" are already there.

 

:(

 

Ok, I fixed the the coupon thing and the duplicate order list instance. I had to switch around the " minor importance" '</a><br>' :)

 

Clicking "Generate Order list " is still taking me to a blank page with error:

 

" The requested URL /admin/FILENAME_ORDERLIST was not found on this server."

[Mort-lemur]

Hi,

 

In your admin/imcludes/application_top.php add the following (somewhere):

 

// Orderlist
 define('FILENAME_ORDERLIST', 'orderlist.php'); 

 

Thanks

[BertaRecchia]

That's a little better.... now it opens admin/orderlist.php but it's blank :(

 

It's the same in a different browser and after clearing my cache.

 

Thanks for the help!

[Mort-lemur]

Hi,

 

Did you copy the correct orderlisy.php to the right places?

 

especially : Copy "admin/includes/languages/english/orderlist.php under "admin/includes/languages/english/orderlist.php"

 

Thanks

[BertaRecchia]

Yes, I'm following the instructions in the Orderlist 5.1a

 

I put Orderlist 5.1a\catalog\admin\includes\languages\english\orderlist.php into httpdocs/admin/includes/languages/english

I put Orderlist 5.1a\catalog\admin\orderlist.php into httpdocs/admin/

 

Can it be that I didn't copy/replace the images that were already there?

[Mort-lemur]

I don't think images would cause a blank screen to be shown.

 

Are you running on a windows server?

 

If you are being directed to orderlist.php and you are just getting a blank screen then something else is wrong, as this is a simple mod with just 2 new files and a couple of file edits.

[BertaRecchia]

It's an Apache server.

I usually get blank screens when there's a typo in the file.

 

For sake of curiosity:

 

the orderlist.php in the admin root is the one with the " $day[] = array('id' => 1, 'text' => '1');"

and

the other one has the "define('MONTH_JANUARY', 'January');" etc..

 

Right?

 

 

:blush:

 

I could really use this addon...