jka

Just checked. The 2 lines that caught my attention was as follows ... 1. 302 GET index.php?-a=basket 4663ms 2. 200 GET index.php?-a=basket 4585ms Both point at the same IPAddress:443. Then then rest of the page rendered. When I check for shipping options/prices, the same happens again when the page reloads.

I have been noticing some delay when the ViewCart pages '?basket... renders. The main home page, product pages etc render within secs. However the whole view cart, secure checkout is a bit slow. Anything I can do? We do use different shipping options to check for rates. Is this the one slowing up the system, when its initially loading trying to get rates from everywhere?

Thanks. Fixed it now.

Thanks & Thanks to you BSmither. It works great. I did this for the multiple products in an order and it works great. <td> {foreach $order.inventory as $prod} <div class = row> {$prod.product_code} {/foreach} </div> </td>

BSmither, On a different note, I have possibly figured out how to add a line on the un-settled orders to also show 'product_code'. The product code is is in _order_inventory table. Here is a code from /admin-folder/sources/dashboard.index.inc.php. If we can add code to also get data from the order_inventory table, we will be able to then display the Product_Code for each order in the dashboard. ## Pending Orders Tab $page = (isset($_GET['orders'])) ? $_GET['orders'] : 1; $unsettled_count = $GLOBALS['db']->count('CubeCart_order_summary', 'cart_order_id', array('status' => array(1, 2))); $results_per_page = 25; $unsettled_orders = $GLOBALS['db']->select('CubeCart_order_summary', array('cart_order_id', 'name', 'first_name', 'last_name', 'order_date', 'customer_id', 'total', 'status'), 'status IN (1,2) OR `dashboard` = 1', '`dashboard` DESC, `status` DESC,`order_date` ASC', $results_per_page, $page);

BSmither, You are correct. I added a Debug line to get formatDispatchDate() to make sure the function was working while we were experimenting.

Here is the code insert .... that works .. // Courier Tracking URLs if (!empty($order['ship_method'])) { // Load the module $method = str_replace(' ', '_', $order['ship_method']); $ship_class = CC_ROOT_DIR.'/modules/shipping/'.$method.'/'.'shipping.class.php'; if (file_exists($ship_class)) { include $ship_class; if (class_exists($method) && method_exists((string)$method, 'tracking')) { $shipping = new $method(false); $url = $shipping->tracking($order['ship_tracking']); $url = (empty($url) && filter_var($order['ship_tracking'], FILTER_VALIDATE_URL)) ? $order['ship_tracking'] : $url; $delivery = array( 'url' => $url, 'method' => $order['ship_method'], 'product' => $order['ship_product'], 'tracking' => $order['ship_tracking'], 'date' => (!empty($order['ship_date']) && $order['ship_date']!=='0000-00-00') ? formatDispatchDate($order['ship_date']) : '' ); } unset($ship_class); } else { $delivery = array( 'url' => filter_var($order['ship_tracking'], FILTER_VALIDATE_URL) ? $order['ship_tracking'] : '', 'method' => $order['ship_method'], 'product' => $order['ship_product'], 'tracking' => $order['ship_tracking'], 'date' => (!empty($order['ship_date']) && $order['ship_date']!=='0000-00-00') ? formatDispatchDate($order['ship_date']) : '' ); } if (empty($delivery['date'])) $delivery = array( 'method' => $order['ship_method'], 'product' => $order['ship_product'], 'tracking' => $order['ship_tracking'], 'date' => (!empty($order['ship_date']) && $order['ship_date']!=='0000-00-00') ? formatDispatchDate($order['ship_date']) : '' ); if (empty($delivery['date']) && empty($delivery['url']) && empty($delivery['tracking'])) $delivery = false; } else { $delivery = false; } $GLOBALS['smarty']->assign('DELIVERY', $delivery);

Hello BSmither, Thanks for pointing me in the right direction. It was due to the IF condition, it was not setting the $delivery. I added another condition and I can now see Ship Date in the Order Page. It does not however display Shipping Method yet. Thats next.

So the formatDispatchDate works ... I just added another debug line right after the date .. [1] The ship_method exists at line 2350[2] 2017-07-10[3] The date argument is at 410: 2017-07-10[4] The format to use is at 419: %b %d %Y[5] Returning from formatDispatchDate at 420 with: Jul 10 2017[6] Jul 10 2017[7] The delivery date is at line 2399 . After poking around a bit, the $delivery array is not getting populated.

Completed that Edit for Order line ... Here is the result [0] The order data at line 2299 is: Array ( [id] => 172 .....bunch of details then ... [ship_product] => UPS Ground [ship_date] => 2017-07-06 [ship_tracking] => I added ... $GLOBALS['debug']->debugMessage($order['ship_date']);

Will do that now. By the way I added a DEBUG to display ship_date. Here goes after that ... Debug Messages:[0] The ship_method exists at line 2347[1] 2017-07-06[2] The delivery date is at line 2394 .

I completed both the edits. I am able to see the ship_date for the order in the database.

Hello BSmither, Here is the Debug results ... Debug Messages:[0] The ship_method exists at line 2347[1] The delivery date is at line 2392 . It looks like the Debug messages from functions.inc.php didnt show up

Any way I can debug for next steps. I dont remember the shipping date ever displayed in the past. By the way the ship_date looks like 2017-07-06 in the table. Is it looking elsewhere?

BSmither, One last point. I had a look at the order table using the phpadmin. The Ship_Method is very inconsistent for different orders (understandably). For UPS Expedited its says UPS_Delivery, whereas for UPS Ground its says UPS Delivery. In some cases, it also says NULL. However the sample order that i am trying to see has all the data properly in the table.

Here is the date format attached Here is a code snippet ... the question is that it is looking for /modules/shipping/'.$method.'/' shipping.class.php // Courier Tracking URLs if (!empty($order['ship_method'])) { // Load the module $method = str_replace(' ', '_', $order['ship_method']); $ship_class = CC_ROOT_DIR.'/modules/shipping/'.$method.'/'.'shipping.class.php'; if (file_exists($ship_class)) { include $ship_class; if (class_exists($method) && method_exists((string)$method, 'tracking')) { $shipping = new $method(false); $url = $shipping->tracking($order['ship_tracking']); $url = (empty($url) && filter_var($order['ship_tracking'], FILTER_VALIDATE_URL)) ? $order['ship_tracking'] : $url; $delivery = array( 'url' => $url, 'method' => $order['ship_method'], 'product' => $order['ship_product'], 'tracking' => $order['ship_tracking'], 'date' => (!empty($order['ship_date']) && $order['ship_date']!=='0000-00-00') ? formatDispatchDate($order['ship_date']) : '' ); } unset($ship_class); } else { $delivery = array( 'url' => filter_var($order['ship_tracking'], FILTER_VALIDATE_URL) ? $order['ship_tracking'] : '', 'method' => $order['ship_method'], 'product' => $order['ship_product'], 'tracking' => $order['ship_tracking'], 'date' => (!empty($order['ship_date']) && $order['ship_date']!=='0000-00-00') ? formatDispatchDate($order['ship_date']) : '' ); } if(empty($delivery['date']) && empty($delivery['url']) && empty($delivery['tracking'])) { $delivery = false; } } else { $delivery = false; } $GLOBALS['smarty']->assign('DELIVERY', $delivery);

Forgot to add ... I am using Foundation Skin cc version 6.1.4. this is to show the Customers the Delivery details under the order.

Hello bsmither, Did all of the above. (including checking db, looks good there). Here is the result from the DEBUG $DELIVERY Origin: "Smarty object" Value false I checked and the Delivery Method, etc, date exists in the order.

Hello bsmither, I knew you would come to the rescue. I use the following shipping modules and the combination work perfectly for us ... Noodleman's Link Products To Specific Shipping Services Noodlemans UPS Advanced Shipping Plugin UPS Delivery Free Shipping The orders have a ship method or we also offer free shipping. Here is a screenshot of the Delivery Tab under the order. The Shipping Method and Shipping Product were actually populated by the system when the order was placed. I added the Shipping Date. However they dont display in the Order details.

So, I did some checking. Everything is in the content.receipt.php. Its checking for "if $Delivery" I have the Dispatch Date populated etc. However nothing shows up. What is the condition for $Delivery?? How is this flag set or how is this condition checked? Thanks.

Thanks. I will poke around & see where the ?vieworder code is located.

Any guidance on how to add "Ship Date" to vieworder summary and details page? This will be nice and as part of the page.

I can actually use the "Dispatch Date" field in the Order details. I would to call it "Estimated Ship Date" and display it when the customer checks his order status. Any help on which .php I would need to modify to add and display this field? Thanks.

Thats not the most ideal way. It would be nice to add a line next to the "Order Status" line on the page which show the estimated ship date. Any ways to add a custom field in the db or use a existing one and display it on the order status page?

Folks, Any idea on how to add a Estimated Ship Date to the orders while it says "Processing". Thanks.