Daemonj Posted July 9, 2003 Posted July 9, 2003 Are you using the Gift Voucher / Discout Coupon contribution? "Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein
Guest Posted July 9, 2003 Posted July 9, 2003 Is the orders_status_id for the Pending status in the orders_status table set to 1? Nope - they go 1, 2, 3 then 99999 for paypal.
Guest Posted July 9, 2003 Posted July 9, 2003 Are you using the Gift Voucher / Discout Coupon contribution? No, but I do have Paypal IPN
Daemonj Posted July 10, 2003 Posted July 10, 2003 Well, if the records in the orders table all have an orders_status greater than 0 and all of the records in the orders_status table have an id greater than 0, your orders should be appearing on the orders page. Just for grins, have you tried pressing F5 (refresh) when on the orders pages to ensure that you are not seeing a cached version? "Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein
rag Posted July 31, 2003 Posted July 31, 2003 I've been through this thread and the other http://www.oscommerce.com/forums/viewtopic.php?t=41103 I've implemented the fixes pressed F5 and still get nothing in Admin/Customers/Orders I've placed several orders and can search by the Admin/Customers/Orders/Order ID: text field. This shows the order details fine except the Status drop down list is blank. Does that mean anything? Also my orders_status table has only three fields: orders_status_id int(11) notnull default 1 language_id orders_status_name plus there are no records to browse. Thanks in Advance, Rob
Daemonj Posted July 31, 2003 Posted July 31, 2003 If there are no records to browse in the orders_status table then that is your problem. Execute the following in a PHPMyAdmin SQL window and it should resolve your problem. INSERT INTO orders_status VALUES ( '1', '1', 'Pending'), ( '1', '2', 'Offen'), ( '1', '3', 'Pendiente'), ( '2', '1', 'Processing'), ( '2', '2', 'In Bearbeitung'), ( '2', '3', 'Proceso'), ( '3', '1', 'Delivered'), ( '3', '2', 'Versendet'), ( '3', '3', 'Entregado'); "Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein
rag Posted August 1, 2003 Posted August 1, 2003 Jim, Wow, thanks for that! Now the Orders show lots of information. One last question (I hope), When I click on a name in the Admin/Customers/Orders page it will highlight 3 or 4 adjacent rows which for instance are: Customers Order Total Date Purchased Status Action Rob Glaesemann $7,524.00 05/07/2003 07:55:39 Pending Rob Glaesemann $684.00 05/07/2003 07:55:39 Pending Rob Glaesemann $7,524.00 05/07/2003 07:55:39 Pending Rob Glaesemann $3,762.00 05/07/2003 07:55:39 Pending If I click the EDIT button I get an itemised invoice which at the very bottom of the page I get the above $'s broken down. Sub-Total: $7,524.00 10: $684.00 Total: $7,524.00 Customer Discount: $3,762.00 I want to only have 1 entry on the first orders.php viewing showing only the total like: Rob Glaesemann $7,524.00 05/07/2003 07:55:39 Pending I'm Web Master for The Music Place and the bricks & morter employees need to learn how to use OSC, I just find that the above is a little confusing for the uninitiated. Thanks for your time and patience, Rob
Daemonj Posted August 1, 2003 Posted August 1, 2003 Glad to be of help Rob :) Regarding the multiple order display - I have never heard of that happening. The rows are color-barred (i.e. like the green, white, green, white accounting sheets). Are you taking those colors as being highlighted by chance? That is the only thing that I can think of from the top of my head. Have you made any modifications to the orders.php page? I assume not but I have to ask. ;) "Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein
rag Posted August 1, 2003 Posted August 1, 2003 Jim, The rows are color-barred (i.e. like the green, white, green, white accounting sheets). Are you taking those colors as being highlighted by chance? No, the highlighted colour is a slightly darker blue for all rows in question. Maybe my style sheet is corrupted? Shall I look in the orders.php and look for a CSS class in the TD? orders.php has this style a lot " <td class="dataTableContent" " Also I've uploaded a fresh copy of the orders.php. Thanks, Rob
Daemonj Posted August 1, 2003 Posted August 1, 2003 It sounds like the stylesheet is correct but it would not hurt to verify that the entries are correct. Especially if you have made an edits to it. The only other thing would be to view the source of the orders page and see which rows are set as being selected based upon the class assigned to the <tr> tag. "Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein
rag Posted August 1, 2003 Posted August 1, 2003 They are all following this format: <tr class="dataTableRowSelected" <td class="dataTableContent" <tr class="dataTableRowSelected" onmouseover="this.style.cursor='hand'" onclick="document.location.href='http://musicplace.com.au/admin/orders.php?page=1&oID=13&action=edit'"> <td class="dataTableContent"><a href="http://musicplace.com.au/admin/orders.php?page=1&oID=13&action=edit"><img src="images/icons/preview.gif" border="0" alt="Preview" title=" Preview "></a> Frank Sergi</td> <td class="dataTableContent" align="right">$23.25</td> <td class="dataTableContent" align="center">07/31/2003 21:47:56</td> <td class="dataTableContent" align="right">Pending</td> <td class="dataTableContent" align="right"><img src="images/icon_arrow_right.gif" border="0" alt=""> </td> </tr>
Daemonj Posted August 1, 2003 Posted August 1, 2003 It sounds like something is wrong with the loop in your orders.php file. The row that is selected should be <tr id="defaultSelected" class="dataTableRowSelected" while all of the other rows should be <tr class="dataTableRow" Here is a thought since you were having troubles with your orders to begin with - in PHPMyAdmin, browse the orders table and verify that orders do not share the same id. If they do then that is the problem. "Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein
rag Posted August 1, 2003 Posted August 1, 2003 Jim, Do you ever sleep? In Australia I'm just getting ready...Ok now back to business. orders_id is fine 1 through 13. Shall I hunt down a fresh orders.php and upload? I just hope any contributions haven't hacked into it. I tried to keep detailed notes but... Rob
Daemonj Posted August 1, 2003 Posted August 1, 2003 Jim, Do you ever sleep? In Australia I'm just getting ready Not enough according to my wife. ;) It is about 9am where I am (Central Standard Time in the US). We have dreams of visiting Australia - maybe in a few years (hopefully). orders_id is fine 1 through 13. Shall I hunt down a fresh orders.php and upload? I just hope any contributions haven't hacked into it. I tried to keep detailed notes but... Rob What version of osC are you running and what version of orders.php do you have? I could send you a copy of mine. Just be sure that you make a backup of your current file. Then you could use a file comparison program (e.g. Beyond Compare) to see if there are any differences. "Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein
rag Posted August 1, 2003 Posted August 1, 2003 I'm running oscommerce-2.2ms1 and is this what you mean for orders.php: /* $Id: orders.php,v 1.107 2003/02/06 17:37:08 thomasamoulton Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2002 osCommerce Released under the GNU General Public License */ Also, I'll PM you my details so you can look at the Admin (if you have time)
rag Posted August 1, 2003 Posted August 1, 2003 Woops, Actually I did back up all hacked files and orders.php was one of them. I installed the PURCHASEORDER contribution and with all this stuffing around I got a bit out whack. Anyway the original file orders.php with purchaseorder hack is from $Id: orders.php,v 1.103 2002/11/01 05:55:36 hpdl Exp $ I'm back to that one now. I've tried both 2002/11/01 and 2003/02/06 of which neither work properly. Way off topic now: Is it worth updating to 2.2ms2? If so is it heaps of work?
Daemonj Posted August 1, 2003 Posted August 1, 2003 Yep, that is the information that I needed. Make a copy of your admin/orders.php file and I will send you a copy of mine. My version is a bit newer but should still work with your MS1. I will send it via PM. "Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein
rag Posted August 1, 2003 Posted August 1, 2003 Jim, I GOT IT. You were right, it was in the for loop. I downloaded the latest OSC MS2 and Beyond Compaired and even though my code isn't up to scratch (obviously) I could see that the for loop that writes the orders was different. So I gambled on the new code and it look like I won. Woopie!! Thanks again for all your help it was priceless. Rob
Daemonj Posted August 1, 2003 Posted August 1, 2003 I am glad that I was able to help out. :) "Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.