discxpress

This is still a great contribution. I have it installed on a BS shop and it works but it needs to be updated to be responsive and bootstrap. Has anyone updated this to bootstrap?

Thanks Jack! Works like a charm.

@@Jack_mcs My site version is OSC 2.3.4bs. I use your latest version of this addon. For some reason, the manufacturer's name doesn't appear in the urls. Where should I check? Thanks

@@raiwa I tried your file and still no luck. I believe there's nothing wrong with your mod but more a problem with my site. Maybe there's a small conflict with another mod somewhere. Like a needle in a haystack. Thanks for your help.

@@raiwa Since this won't work with any shipping method while the customer is not logged in, it's becoming obvious that it has something to do with how my store is set up or it's clashing with another module. I'll investigate more. Thanks

<?php /* $Id$ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2008 osCommerce Released under the GNU General Public License */ class multi { var $code, $title, $description, $icon, $enabled; // class constructor function multi() { global $order; $this->code = 'multi'; $this->title = MODULE_SHIPPING_MULTI_TEXT_TITLE; $this->description = MODULE_SHIPPING_MULTI_TEXT_DESCRIPTION; $this->sort_order = MODULE_SHIPPING_MULTI_SORT_ORDER; $this->icon = ''; $this->tax_class = MODULE_SHIPPING_MULTI_TAX_CLASS; $this->enabled = ((MODULE_SHIPPING_MULTI_STATUS == 'True') ? true : false); if ( ($this->enabled == true) && ((int)MODULE_SHIPPING_MULTI_ZONE > 0) ) { $check_flag = false; $check_query = tep_db_query("select zone_id from " . TABLE_ZONES_TO_GEO_ZONES . " where geo_zone_id = '" . MODULE_SHIPPING_MULTI_ZONE . "' and zone_country_id = '" . $order->delivery['country']['id'] . "' order by zone_id"); while ($check = tep_db_fetch_array($check_query)) { if ($check['zone_id'] < 1) { $check_flag = true; break; } elseif ($check['zone_id'] == $order->delivery['zone_id']) { $check_flag = true; break; } } if ($check_flag == false) { $this->enabled = false; } } } // class methods function quote($method = '') { global $order, $cart; // ---------------------------------------------- $max = -9999999; $found_item = null; $extra_charge = 0; foreach($cart->shipping_array as $k => $v) { $extra_charge += $v['extra'] * $v['qty']; if($v['handling'] > $max) { $max = $v['handling']; $found_item = $v; $extra_charge -= $found_item['extra']; } } $main_charge = $found_item['handling']; $sub_charge = $extra_charge; $surcharge = $cart->surcharge_shipping; // ---------------------------------------------- $shipment = array(array('id' => 'priority', 'title' => 'Priority', 'cost' => $main_charge + $sub_charge + $surcharge + MODULE_SHIPPING_MULTI_HANDLING), array('id' => 'normal', 'title' => 'Normal', 'cost' => $main_charge + $sub_charge + $surcharge)); $this->quotes = array('id' => $this->code, 'module' => MODULE_SHIPPING_MULTI_TEXT_TITLE, 'methods' => $shipment); switch ( $method ) { case 'priority': $this->quotes['methods'] = array(array('id' => 'priority', 'title' => 'Priority', 'cost' => $main_charge + $sub_charge + $surcharge + MODULE_SHIPPING_MULTI_HANDLING)); break; case 'normal': $this->quotes['methods'] = array(array('id' => 'normal', 'title' => 'Normal', 'cost' => $main_charge + $sub_charge + $surcharge)); break; default: } if ($this->tax_class > 0) { $this->quotes['tax'] = tep_get_tax_rate($this->tax_class, $order->delivery['country']['id'], $order->delivery['zone_id']); } if (tep_not_null($this->icon)) $this->quotes['icon'] = tep_image($this->icon, $this->title); return $this->quotes; } function check() { if (!isset($this->_check)) { $check_query = tep_db_query("select configuration_value from configuration where configuration_key = 'MODULE_SHIPPING_MULTI_STATUS'"); $this->_check = tep_db_num_rows($check_query); } return $this->_check; } function install() { tep_db_query("insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Enable Multi Rate Shipping', 'MODULE_SHIPPING_MULTI_STATUS', 'True', 'Do you want to offer multi rate shipping?', '6', '0', 'tep_cfg_select_option(array(\'True\', \'False\'), ', now())"); tep_db_query("insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Handling Fee', 'MODULE_SHIPPING_MULTI_HANDLING', '0', 'Handling fee for this shipping method.', '6', '0', now())"); tep_db_query("insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added) values ('Tax Class', 'MODULE_SHIPPING_MULTI_TAX_CLASS', '0', 'Use the following tax class on the shipping fee.', '6', '0', 'tep_get_tax_class_title', 'tep_cfg_pull_down_tax_classes(', now())"); tep_db_query("insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added) values ('Shipping Zone', 'MODULE_SHIPPING_MULTI_ZONE', '0', 'If a zone is selected, only enable this shipping method for that zone.', '6', '0', 'tep_get_zone_class_title', 'tep_cfg_pull_down_zone_classes(', now())"); tep_db_query("insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Sort Order', 'MODULE_SHIPPING_MULTI_SORT_ORDER', '0', 'Sort order of display.', '6', '0', now())"); } function remove() { tep_db_query("delete from configuration where configuration_key in ('" . implode("', '", $this->keys()) . "')"); } function keys() { return array('MODULE_SHIPPING_MULTI_STATUS', 'MODULE_SHIPPING_MULTI_HANDLING', 'MODULE_SHIPPING_MULTI_TAX_CLASS', 'MODULE_SHIPPING_MULTI_ZONE', 'MODULE_SHIPPING_MULTI_SORT_ORDER'); } } Here's the file.... Also it doesn't work with any shipping module as long as the customer isn't logged in. When I select a different shipping module, the page reloads clearing out the shipping quotes and it asks me to login to redeem discount coupon. Post a clean Bootstrap shopping_cart.php file and I'll test it. Thanks

Thanks for the reply. Tell me how to locate those variables in the custom shipping module. Or what would those variables look like? I appreciate your help

@@raiwa I installed your latest upload on version 2.3.3.4BS and it works perfectly when logged in. However, for a prospective customer, when selecting a different shipping method or updating the page the shipping methods disappear. I could send you a copy of my shopping cart page for you to test or you could send me a test copy with shipping estimator code so I could test. Also, I have a custom coded shipping module which is flat rate. With that shipping module, I'm able to set shipping different rates per product. Thanks

Hello, The timezone "America/New York" is correct. I'm in the state of Georgia. Thanks

@@Dr. Rolex I apologize for dropping off. Been trying to increase organic traffic to my site. In reply to your post #45, here's the output: {"data":[["","2013","July","08","$30.82","$0.00","$0.00","$0.00","$0.00","$0.00","$0.00","$0.00"],["","2013","August","09","$0.00","$0.00","$0.00","$0.00","$0.00","$0.00","$0.00","$0.00"],["","2013","September","10","$0.00","$0.00","$0.00","$0.00","$0.00","$0.00","$0.00","$0.00"],["","2013","October","11","$0.00","$0.00","$0.00","$0.00","$0.00","$0.00","$0.00","$0.00"],["","2013","December","12","$0.00","$0.00","$0.00","$0.00","$0.00","$0.00","$0.00","$0.00"],["","2013","","$30.82","$30.82","$0.00","$0.00","$0.00","$0.00","$0.00","$0.00","$0.00"],["","2014","January","01","$0.00","$0.00","$0.00","$0.00","$0.00","$0.00","$0.00","$0.00"],["","2014","February","02","$0.00","$0.00","$0.00","$0.00","$0.00","$0.00","$0.00","$0.00"],["","2014","March","03","$222.50","$21.90","$0.00","$0.00","$0.00","$0.00","$0.00","$0.00"],["","2014","March","04","$89.43","$32.90","$0.00","$0.00","$0.00","$0.00","$0.00","$0.00"],["","2014","April","05","$453.27","$53.80","$0.00","$0.00","$0.00","$0.00","$23.54","$0.94"],["","2014","May","06","$125.23","$5.95","$0.00","$0.00","$0.00","$0.00","$0.00","$0.00"],["","2014","June","07","$0.00","$0.00","$0.00","$0.00","$0.00","$0.00","$0.00","$0.00"],["","2014","July","08","$0.00","$0.00","$0.00","$0.00","$0.00","$0.00","$0.00","$0.00"],["","2014","August","09","$0.00","$0.00","$0.00","$0.00","$0.00","$0.00","$0.00","$0.00"],["","2014","September","10","$166.88","$40.75","$0.00","$0.00","$0.00","$0.00","$0.00","$0.00"],["","2014","October","11","$446.36","$57.60","$0.00","$0.00","$0.00","$0.00","$0.00","$0.00"],["","2014","December","12","$1,958.33","$228.90","$116.41","$8.73","$0.00","$0.00","$27.38","$1.10"],["","2014","","$3,462.01","$3,462.01","$441.80","$116.41","$8.73","$0.00","$0.00","$50.92","$2.04"],["","2015","January","01","$936.46","$210.90","$140.16","$10.51","$72.00","$5.04","$29.62","$1.18"],["","2015","February","02","$1,128.62","$219.20","$18.00","$1.35","$122.75","$8.59","$0.00","$0.00"],["","2015","March","03","$2,383.82","$238.45","$236.29","$17.72","$0.00","$0.00","$242.24","$9.69"],["","2015","March","04","$2,795.28","$489.32","$191.01","$14.33","$239.02","$16.73","$21.99","$0.88"],["","2015","April","05","$6,115.92","$910.93","$193.78","$14.53","$42.81","$3.00","$203.55","$8.14"],["","2015","May","06","$2,979.23","$450.87","$229.11","$17.18","$0.00","$0.00","$53.72","$2.15"],["","2015","June","07","$1,775.47","$167.10","$1,059.59","$79.47","$16.68","$1.17","$0.00","$0.00"],["","2015","","$18,114.80","$18,114.80","$2,686.77","$2,067.95","$155.10","$493.26","$34.53","$551.12","$22.04"]]} It's still showing March twice, so I'm stumped. I'll try your mod to check the timezone and the results. Thanks for your help.

@@Dr. Rolex Thanks for the reply. As you can see, the month of March appears twice and the month of November is omitted. The stats for those months are there it's just the names are thrown off. Array ( [data] => Array ( [0] => Array ( [0] => [1] => 2013 [2] => July [3] => 08 [4] => $30.82 [5] => $0.00 [6] => $0.00 [7] => $0.00 [8] => $0.00 [9] => $0.00 [10] => $0.00 [11] => $0.00 ) [1] => Array ( [0] => [1] => 2013 [2] => August [3] => 09 [4] => $0.00 [5] => $0.00 [6] => $0.00 [7] => $0.00 [8] => $0.00 [9] => $0.00 [10] => $0.00 [11] => $0.00 ) [2] => Array ( [0] => [1] => 2013 [2] => September [3] => 10 [4] => $0.00 [5] => $0.00 [6] => $0.00 [7] => $0.00 [8] => $0.00 [9] => $0.00 [10] => $0.00 [11] => $0.00 ) [3] => Array ( [0] => [1] => 2013 [2] => October [3] => 11 [4] => $0.00 [5] => $0.00 [6] => $0.00 [7] => $0.00 [8] => $0.00 [9] => $0.00 [10] => $0.00 [11] => $0.00 ) [4] => Array ( [0] => [1] => 2013 [2] => December [3] => 12 [4] => $0.00 [5] => $0.00 [6] => $0.00 [7] => $0.00 [8] => $0.00 [9] => $0.00 [10] => $0.00 [11] => $0.00 ) [5] => Array ( [0] => [1] => 2013 [2] => [3] => $30.82 [4] => $30.82 [5] => $0.00 [6] => $0.00 [7] => $0.00 [8] => $0.00 [9] => $0.00 [10] => $0.00 [11] => $0.00 ) [6] => Array ( [0] => [1] => 2014 [2] => January [3] => 01 [4] => $0.00 [5] => $0.00 [6] => $0.00 [7] => $0.00 [8] => $0.00 [9] => $0.00 [10] => $0.00 [11] => $0.00 ) [7] => Array ( [0] => [1] => 2014 [2] => February [3] => 02 [4] => $0.00 [5] => $0.00 [6] => $0.00 [7] => $0.00 [8] => $0.00 [9] => $0.00 [10] => $0.00 [11] => $0.00 ) [8] => Array ( [0] => [1] => 2014 [2] => March [3] => 03 [4] => $222.50 [5] => $21.90 [6] => $0.00 [7] => $0.00 [8] => $0.00 [9] => $0.00 [10] => $0.00 [11] => $0.00 ) [9] => Array ( [0] => [1] => 2014 [2] => March [3] => 04 [4] => $89.43 [5] => $32.90 [6] => $0.00 [7] => $0.00 [8] => $0.00 [9] => $0.00 [10] => $0.00 [11] => $0.00 ) [10] => Array ( [0] => [1] => 2014 [2] => April [3] => 05 [4] => $453.27 [5] => $53.80 [6] => $0.00 [7] => $0.00 [8] => $0.00 [9] => $0.00 [10] => $23.54 [11] => $0.94 ) [11] => Array ( [0] => [1] => 2014 [2] => May [3] => 06 [4] => $125.23 [5] => $5.95 [6] => $0.00 [7] => $0.00 [8] => $0.00 [9] => $0.00 [10] => $0.00 [11] => $0.00 ) [12] => Array ( [0] => [1] => 2014 [2] => June [3] => 07 [4] => $0.00 [5] => $0.00 [6] => $0.00 [7] => $0.00 [8] => $0.00 [9] => $0.00 [10] => $0.00 [11] => $0.00 ) [13] => Array ( [0] => [1] => 2014 [2] => July [3] => 08 [4] => $0.00 [5] => $0.00 [6] => $0.00 [7] => $0.00 [8] => $0.00 [9] => $0.00 [10] => $0.00 [11] => $0.00 ) [14] => Array ( [0] => [1] => 2014 [2] => August [3] => 09 [4] => $0.00 [5] => $0.00 [6] => $0.00 [7] => $0.00 [8] => $0.00 [9] => $0.00 [10] => $0.00 [11] => $0.00 ) [15] => Array ( [0] => [1] => 2014 [2] => September [3] => 10 [4] => $166.88 [5] => $40.75 [6] => $0.00 [7] => $0.00 [8] => $0.00 [9] => $0.00 [10] => $0.00 [11] => $0.00 ) [16] => Array ( [0] => [1] => 2014 [2] => October [3] => 11 [4] => $446.36 [5] => $57.60 [6] => $0.00 [7] => $0.00 [8] => $0.00 [9] => $0.00 [10] => $0.00 [11] => $0.00 ) [17] => Array ( [0] => [1] => 2014 [2] => December [3] => 12 [4] => $1,958.33 [5] => $228.90 [6] => $116.41 [7] => $8.73 [8] => $0.00 [9] => $0.00 [10] => $27.38 [11] => $1.10 ) [18] => Array ( [0] => [1] => 2014 [2] => [3] => $3,462.01 [4] => $3,462.01 [5] => $441.80 [6] => $116.41 [7] => $8.73 [8] => $0.00 [9] => $0.00 [10] => $50.92 [11] => $2.04 ) [19] => Array ( [0] => [1] => 2015 [2] => January [3] => 01 [4] => $936.46 [5] => $210.90 [6] => $140.16 [7] => $10.51 [8] => $72.00 [9] => $5.04 [10] => $29.62 [11] => $1.18 ) [20] => Array ( [0] => [1] => 2015 [2] => February [3] => 02 [4] => $1,128.62 [5] => $219.20 [6] => $18.00 [7] => $1.35 [8] => $122.75 [9] => $8.59 [10] => $0.00 [11] => $0.00 ) [21] => Array ( [0] => [1] => 2015 [2] => March [3] => 03 [4] => $2,383.82 [5] => $238.45 [6] => $236.29 [7] => $17.72 [8] => $0.00 [9] => $0.00 [10] => $242.24 [11] => $9.69 ) [22] => Array ( [0] => [1] => 2015 [2] => March [3] => 04 [4] => $2,795.28 [5] => $489.32 [6] => $191.01 [7] => $14.33 [8] => $239.02 [9] => $16.73 [10] => $21.99 [11] => $0.88 ) [23] => Array ( [0] => [1] => 2015 [2] => April [3] => 05 [4] => $5,223.90 [5] => $739.12 [6] => $193.78 [7] => $14.53 [8] => $0.00 [9] => $0.00 [10] => $70.17 [11] => $2.81 ) [24] => Array ( [0] => [1] => 2015 [2] => [3] => $12,468.08 [4] => $12,468.08 [5] => $1,896.99 [6] => $779.25 [7] => $58.44 [8] => $433.77 [9] => $30.36 [10] => $364.02 [11] => $14.56 ) ) )

@@Dr. Rolex 1. $total_sales Array ( [0] => Array ( [0] => 2013 [year] => 2013 [1] => 8 [month] => 8 [2] => 4 [day] => 4 [3] => 19 [hour] => 19 [4] => 30.8200 [total] => 30.8200 ) [1] => Array ( [0] => 2014 [year] => 2014 [1] => 3 [month] => 3 [2] => 6 [day] => 6 [3] => 9 [hour] => 9 [4] => 222.4975 [total] => 222.4975 ) [2] => Array ( [0] => 2014 [year] => 2014 [1] => 4 [month] => 4 [2] => 16 [day] => 16 [3] => 7 [hour] => 7 [4] => 89.4300 [total] => 89.4300 ) [3] => Array ( [0] => 2014 [year] => 2014 [1] => 5 [month] => 5 [2] => 5 [day] => 5 [3] => 16 [hour] => 16 [4] => 453.2721 [total] => 453.2721 ) [4] => Array ( [0] => 2014 [year] => 2014 [1] => 6 [month] => 6 [2] => 9 [day] => 9 [3] => 10 [hour] => 10 [4] => 125.2300 [total] => 125.2300 ) [5] => Array ( [0] => 2014 [year] => 2014 [1] => 10 [month] => 10 [2] => 20 [day] => 20 [3] => 17 [hour] => 17 [4] => 166.8815 [total] => 166.8815 ) [6] => Array ( [0] => 2014 [year] => 2014 [1] => 11 [month] => 11 [2] => 2 [day] => 2 [3] => 13 [hour] => 13 [4] => 446.3640 [total] => 446.3640 ) [7] => Array ( [0] => 2014 [year] => 2014 [1] => 12 [month] => 12 [2] => 2 [day] => 2 [3] => 9 [hour] => 9 [4] => 1958.3319 [total] => 1958.3319 ) [8] => Array ( [0] => 2015 [year] => 2015 [1] => 1 [month] => 1 [2] => 1 [day] => 1 [3] => 16 [hour] => 16 [4] => 936.4569 [total] => 936.4569 ) [9] => Array ( [0] => 2015 [year] => 2015 [1] => 2 [month] => 2 [2] => 1 [day] => 1 [3] => 0 [hour] => 0 [4] => 1128.6179 [total] => 1128.6179 ) [10] => Array ( [0] => 2015 [year] => 2015 [1] => 3 [month] => 3 [2] => 3 [day] => 3 [3] => 3 [hour] => 3 [4] => 2383.8214 [total] => 2383.8214 ) [11] => Array ( [0] => 2015 [year] => 2015 [1] => 4 [month] => 4 [2] => 4 [day] => 4 [3] => 13 [hour] => 13 [4] => 2795.2825 [total] => 2795.2825 ) [12] => Array ( [0] => 2015 [year] => 2015 [1] => 5 [month] => 5 [2] => 1 [day] => 1 [3] => 22 [hour] => 22 [4] => 4968.0634 [total] => 4968.0634 ) )2. $total_sales_month Array ( [2013-08] => Array ( [year] => 2013 [month] => 08 [day] => 01 [hour] => 00 [total] => 0 [products_sold] => 0 ) [2013-09] => Array ( [year] => 2013 [month] => 09 [day] => 01 [hour] => 00 [total] => 0 [products_sold] => 0 ) [2013-10] => Array ( [year] => 2013 [month] => 10 [day] => 01 [hour] => 00 [total] => 0 [products_sold] => 0 ) [2013-11] => Array ( [year] => 2013 [month] => 11 [day] => 01 [hour] => 00 [total] => 0 [products_sold] => 0 ) [2013-12] => Array ( [year] => 2013 [month] => 12 [day] => 01 [hour] => 00 [total] => 0 [products_sold] => 0 ) [2014-01] => Array ( [year] => 2014 [month] => 01 [day] => 01 [hour] => 00 [total] => 0 [products_sold] => 0 ) [2014-02] => Array ( [year] => 2014 [month] => 02 [day] => 01 [hour] => 00 [total] => 0 [products_sold] => 0 ) [2014-03] => Array ( [year] => 2014 [month] => 03 [day] => 01 [hour] => 00 [total] => 0 [products_sold] => 0 ) [2014-04] => Array ( [year] => 2014 [month] => 04 [day] => 01 [hour] => 00 [total] => 0 [products_sold] => 0 ) [2014-05] => Array ( [year] => 2014 [month] => 05 [day] => 01 [hour] => 00 [total] => 0 [products_sold] => 0 ) [2014-06] => Array ( [year] => 2014 [month] => 06 [day] => 01 [hour] => 00 [total] => 0 [products_sold] => 0 ) [2014-07] => Array ( [year] => 2014 [month] => 07 [day] => 01 [hour] => 00 [total] => 0 [products_sold] => 0 ) [2014-08] => Array ( [year] => 2014 [month] => 08 [day] => 01 [hour] => 00 [total] => 0 [products_sold] => 0 ) [2014-09] => Array ( [year] => 2014 [month] => 09 [day] => 01 [hour] => 00 [total] => 0 [products_sold] => 0 ) [2014-10] => Array ( [year] => 2014 [month] => 10 [day] => 01 [hour] => 00 [total] => 0 [products_sold] => 0 ) [2014-11] => Array ( [year] => 2014 [month] => 11 [day] => 01 [hour] => 00 [total] => 0 [products_sold] => 0 ) [2014-12] => Array ( [year] => 2014 [month] => 12 [day] => 01 [hour] => 00 [total] => 0 [products_sold] => 0 ) [2015-01] => Array ( [year] => 2015 [month] => 01 [day] => 01 [hour] => 00 [total] => 0 [products_sold] => 0 ) [2015-02] => Array ( [year] => 2015 [month] => 02 [day] => 01 [hour] => 00 [total] => 0 [products_sold] => 0 ) [2015-03] => Array ( [year] => 2015 [month] => 03 [day] => 01 [hour] => 00 [total] => 0 [products_sold] => 0 ) [2015-04] => Array ( [year] => 2015 [month] => 04 [day] => 01 [hour] => 00 [total] => 0 [products_sold] => 0 ) [2015-05] => Array ( [year] => 2015 [month] => 05 [day] => 01 [hour] => 00 [total] => 0 [products_sold] => 0 ) )3. $total_sales_month Array ( [2013-08] => Array ( [year] => 2013 [month] => 08 [day] => 01 [hour] => 00 [total] => 30.8200 [products_sold] => 0 ) [2013-09] => Array ( [year] => 2013 [month] => 09 [day] => 01 [hour] => 00 [total] => 0 [products_sold] => 0 ) [2013-10] => Array ( [year] => 2013 [month] => 10 [day] => 01 [hour] => 00 [total] => 0 [products_sold] => 0 ) [2013-11] => Array ( [year] => 2013 [month] => 11 [day] => 01 [hour] => 00 [total] => 0 [products_sold] => 0 ) [2013-12] => Array ( [year] => 2013 [month] => 12 [day] => 01 [hour] => 00 [total] => 0 [products_sold] => 0 ) [2014-01] => Array ( [year] => 2014 [month] => 01 [day] => 01 [hour] => 00 [total] => 0 [products_sold] => 0 ) [2014-02] => Array ( [year] => 2014 [month] => 02 [day] => 01 [hour] => 00 [total] => 0 [products_sold] => 0 ) [2014-03] => Array ( [year] => 2014 [month] => 03 [day] => 01 [hour] => 00 [total] => 222.4975 [products_sold] => 0 ) [2014-04] => Array ( [year] => 2014 [month] => 04 [day] => 01 [hour] => 00 [total] => 89.4300 [products_sold] => 0 ) [2014-05] => Array ( [year] => 2014 [month] => 05 [day] => 01 [hour] => 00 [total] => 453.2721 [products_sold] => 0 ) [2014-06] => Array ( [year] => 2014 [month] => 06 [day] => 01 [hour] => 00 [total] => 125.2300 [products_sold] => 0 ) [2014-07] => Array ( [year] => 2014 [month] => 07 [day] => 01 [hour] => 00 [total] => 0 [products_sold] => 0 ) [2014-08] => Array ( [year] => 2014 [month] => 08 [day] => 01 [hour] => 00 [total] => 0 [products_sold] => 0 ) [2014-09] => Array ( [year] => 2014 [month] => 09 [day] => 01 [hour] => 00 [total] => 0 [products_sold] => 0 ) [2014-10] => Array ( [year] => 2014 [month] => 10 [day] => 01 [hour] => 00 [total] => 166.8815 [products_sold] => 0 ) [2014-11] => Array ( [year] => 2014 [month] => 11 [day] => 01 [hour] => 00 [total] => 446.3640 [products_sold] => 0 ) [2014-12] => Array ( [year] => 2014 [month] => 12 [day] => 01 [hour] => 00 [total] => 1958.3319 [products_sold] => 0 ) [2015-01] => Array ( [year] => 2015 [month] => 01 [day] => 01 [hour] => 00 [total] => 936.4569 [products_sold] => 0 ) [2015-02] => Array ( [year] => 2015 [month] => 02 [day] => 01 [hour] => 00 [total] => 1128.6179 [products_sold] => 0 ) [2015-03] => Array ( [year] => 2015 [month] => 03 [day] => 01 [hour] => 00 [total] => 2383.8214 [products_sold] => 0 ) [2015-04] => Array ( [year] => 2015 [month] => 04 [day] => 01 [hour] => 00 [total] => 2795.2825 [products_sold] => 0 ) [2015-05] => Array ( [year] => 2015 [month] => 05 [day] => 01 [hour] => 00 [total] => 4968.0634 [products_sold] => 0 ) )Thanks.

@@Dr. Rolex Everything checks out just fine. Each month is correct with their respective rows. Thanks

@@Dr. Rolex Thank you for helping to diagnose my issue. I think my host doesn't upgrade PHP upon request.

@@Dr. Rolex It's been a long and stressful 2 weeks but I'm back on task. I made the changes you suggested and here's the output: Array ( [data] => Array ( [0] => Array ( [0] => [1] => 2013 [2] => July [3] => 08 [4] => $30.82 [5] => $0.00 [6] => $0.00 [7] => $0.00 [8] => $0.00 [9] => $0.00 [10] => $0.00 [11] => $0.00 ) [1] => Array ( [0] => [1] => 2013 [2] => August [3] => 09 [4] => $0.00 [5] => $0.00 [6] => $0.00 [7] => $0.00 [8] => $0.00 [9] => $0.00 [10] => $0.00 [11] => $0.00 ) [2] => Array ( [0] => [1] => 2013 [2] => September [3] => 10 [4] => $0.00 [5] => $0.00 [6] => $0.00 [7] => $0.00 [8] => $0.00 [9] => $0.00 [10] => $0.00 [11] => $0.00 ) [3] => Array ( [0] => [1] => 2013 [2] => October [3] => 11 [4] => $0.00 [5] => $0.00 [6] => $0.00 [7] => $0.00 [8] => $0.00 [9] => $0.00 [10] => $0.00 [11] => $0.00 ) [4] => Array ( [0] => [1] => 2013 [2] => December [3] => 12 [4] => $0.00 [5] => $0.00 [6] => $0.00 [7] => $0.00 [8] => $0.00 [9] => $0.00 [10] => $0.00 [11] => $0.00 ) [5] => Array ( [0] => [1] => 2013 [2] => [3] => $30.82 [4] => $30.82 [5] => $0.00 [6] => $0.00 [7] => $0.00 [8] => $0.00 [9] => $0.00 [10] => $0.00 [11] => $0.00 ) [6] => Array ( [0] => [1] => 2014 [2] => January [3] => 01 [4] => $0.00 [5] => $0.00 [6] => $0.00 [7] => $0.00 [8] => $0.00 [9] => $0.00 [10] => $0.00 [11] => $0.00 ) [7] => Array ( [0] => [1] => 2014 [2] => February [3] => 02 [4] => $0.00 [5] => $0.00 [6] => $0.00 [7] => $0.00 [8] => $0.00 [9] => $0.00 [10] => $0.00 [11] => $0.00 ) [8] => Array ( [0] => [1] => 2014 [2] => March [3] => 03 [4] => $222.50 [5] => $21.90 [6] => $0.00 [7] => $0.00 [8] => $0.00 [9] => $0.00 [10] => $0.00 [11] => $0.00 ) [9] => Array ( [0] => [1] => 2014 [2] => March [3] => 04 [4] => $89.43 [5] => $32.90 [6] => $0.00 [7] => $0.00 [8] => $0.00 [9] => $0.00 [10] => $0.00 [11] => $0.00 ) [10] => Array ( [0] => [1] => 2014 [2] => April [3] => 05 [4] => $453.27 [5] => $53.80 [6] => $0.00 [7] => $0.00 [8] => $0.00 [9] => $0.00 [10] => $23.54 [11] => $0.94 ) [11] => Array ( [0] => [1] => 2014 [2] => May [3] => 06 [4] => $125.23 [5] => $5.95 [6] => $0.00 [7] => $0.00 [8] => $0.00 [9] => $0.00 [10] => $0.00 [11] => $0.00 ) [12] => Array ( [0] => [1] => 2014 [2] => June [3] => 07 [4] => $0.00 [5] => $0.00 [6] => $0.00 [7] => $0.00 [8] => $0.00 [9] => $0.00 [10] => $0.00 [11] => $0.00 ) [13] => Array ( [0] => [1] => 2014 [2] => July [3] => 08 [4] => $0.00 [5] => $0.00 [6] => $0.00 [7] => $0.00 [8] => $0.00 [9] => $0.00 [10] => $0.00 [11] => $0.00 ) [14] => Array ( [0] => [1] => 2014 [2] => August [3] => 09 [4] => $0.00 [5] => $0.00 [6] => $0.00 [7] => $0.00 [8] => $0.00 [9] => $0.00 [10] => $0.00 [11] => $0.00 ) [15] => Array ( [0] => [1] => 2014 [2] => September [3] => 10 [4] => $166.88 [5] => $40.75 [6] => $0.00 [7] => $0.00 [8] => $0.00 [9] => $0.00 [10] => $0.00 [11] => $0.00 ) [16] => Array ( [0] => [1] => 2014 [2] => October [3] => 11 [4] => $446.36 [5] => $57.60 [6] => $0.00 [7] => $0.00 [8] => $0.00 [9] => $0.00 [10] => $0.00 [11] => $0.00 ) [17] => Array ( [0] => [1] => 2014 [2] => December [3] => 12 [4] => $1,958.33 [5] => $228.90 [6] => $116.41 [7] => $8.73 [8] => $0.00 [9] => $0.00 [10] => $27.38 [11] => $1.10 ) [18] => Array ( [0] => [1] => 2014 [2] => [3] => $3,462.01 [4] => $3,462.01 [5] => $441.80 [6] => $116.41 [7] => $8.73 [8] => $0.00 [9] => $0.00 [10] => $50.92 [11] => $2.04 ) [19] => Array ( [0] => [1] => 2015 [2] => January [3] => 01 [4] => $936.46 [5] => $210.90 [6] => $140.16 [7] => $10.51 [8] => $72.00 [9] => $5.04 [10] => $29.62 [11] => $1.18 ) [20] => Array ( [0] => [1] => 2015 [2] => February [3] => 02 [4] => $1,128.62 [5] => $219.20 [6] => $18.00 [7] => $1.35 [8] => $122.75 [9] => $8.59 [10] => $0.00 [11] => $0.00 ) [21] => Array ( [0] => [1] => 2015 [2] => March [3] => 03 [4] => $2,383.82 [5] => $238.45 [6] => $236.29 [7] => $17.72 [8] => $0.00 [9] => $0.00 [10] => $242.24 [11] => $9.69 ) [22] => Array ( [0] => [1] => 2015 [2] => March [3] => 04 [4] => $2,795.28 [5] => $489.32 [6] => $191.01 [7] => $14.33 [8] => $239.02 [9] => $16.73 [10] => $21.99 [11] => $0.88 ) [23] => Array ( [0] => [1] => 2015 [2] => April [3] => 05 [4] => $3,703.38 [5] => $495.70 [6] => $71.01 [7] => $5.33 [8] => $0.00 [9] => $0.00 [10] => $70.17 [11] => $2.81 ) [24] => Array ( [0] => [1] => 2015 [2] => [3] => $10,947.56 [4] => $10,947.56 [5] => $1,653.57 [6] => $656.47 [7] => $49.24 [8] => $433.77 [9] => $30.36 [10] => $364.02 [11] => $14.56 ) ) )As you can see, the month of March appears twice and the month of November is omitted. Thanks for your help.

@@Bob Terveuren Thanks. Now I understand better. I'm in the state of Georgia and have the tax set to 7%. The module only calculates the tax based on the shipping. I'm thinking it's suppose to calculate the tax based on the sub-total and shipping. Such as the formula, tax rate * (sub-total + shipping cost) = total price including tax. @@sembrouille Thank you for this module. It helps to accomplish transparency.

@@nafri Did you find the solution to your issue? I would like to display and calculate the correct tax, also. I can't figure out the formula in the code. @@sembrouille Could you please help us to calculate and display the correct tax? It's a great module besides that minor problem.

Start date: 2013-8-1 End date: 2015-4-1 Array ( [0] => Array ( [0] => 2013 [year] => 2013 [1] => 8 [month] => 8 [2] => 4 [day] => 4 [3] => 19 [hour] => 19 [4] => 0 [total] => 0 ) [1] => Array ( [0] => 2014 [year] => 2014 [1] => 3 [month] => 3 [2] => 6 [day] => 6 [3] => 9 [hour] => 9 [4] => 0 [total] => 0 ) [2] => Array ( [0] => 2014 [year] => 2014 [1] => 4 [month] => 4 [2] => 16 [day] => 16 [3] => 7 [hour] => 7 [4] => 0 [total] => 0 ) [3] => Array ( [0] => 2014 [year] => 2014 [1] => 5 [month] => 5 [2] => 5 [day] => 5 [3] => 16 [hour] => 16 [4] => 0 [total] => 0 ) [4] => Array ( [0] => 2014 [year] => 2014 [1] => 6 [month] => 6 [2] => 9 [day] => 9 [3] => 10 [hour] => 10 [4] => 0 [total] => 0 ) [5] => Array ( [0] => 2014 [year] => 2014 [1] => 10 [month] => 10 [2] => 20 [day] => 20 [3] => 17 [hour] => 17 [4] => 0 [total] => 0 ) [6] => Array ( [0] => 2014 [year] => 2014 [1] => 11 [month] => 11 [2] => 2 [day] => 2 [3] => 13 [hour] => 13 [4] => 0 [total] => 0 ) [7] => Array ( [0] => 2014 [year] => 2014 [1] => 12 [month] => 12 [2] => 2 [day] => 2 [3] => 9 [hour] => 9 [4] => 0 [total] => 0 ) [8] => Array ( [0] => 2015 [year] => 2015 [1] => 1 [month] => 1 [2] => 1 [day] => 1 [3] => 16 [hour] => 16 [4] => 0 [total] => 0 ) [9] => Array ( [0] => 2015 [year] => 2015 [1] => 2 [month] => 2 [2] => 1 [day] => 1 [3] => 0 [hour] => 0 [4] => 0 [total] => 0 ) [10] => Array ( [0] => 2015 [year] => 2015 [1] => 3 [month] => 3 [2] => 3 [day] => 3 [3] => 3 [hour] => 3 [4] => 0 [total] => 0 ) [11] => Array ( [0] => 2015 [year] => 2015 [1] => 4 [month] => 4 [2] => 4 [day] => 4 [3] => 13 [hour] => 13 [4] => 0 [total] => 0 ) ) Array ( [2013-08] => Array ( [year] => 2013 [month] => 08 [day] => 01 [hour] => 00 [total] => 0 [products_sold] => 0 ) [2013-09] => Array ( [year] => 2013 [month] => 09 [day] => 01 [hour] => 00 [total] => 0 [products_sold] => 0 ) [2013-10] => Array ( [year] => 2013 [month] => 10 [day] => 01 [hour] => 00 [total] => 0 [products_sold] => 0 ) [2013-11] => Array ( [year] => 2013 [month] => 11 [day] => 01 [hour] => 00 [total] => 0 [products_sold] => 0 ) [2013-12] => Array ( [year] => 2013 [month] => 12 [day] => 01 [hour] => 00 [total] => 0 [products_sold] => 0 ) [2014-01] => Array ( [year] => 2014 [month] => 01 [day] => 01 [hour] => 00 [total] => 0 [products_sold] => 0 ) [2014-02] => Array ( [year] => 2014 [month] => 02 [day] => 01 [hour] => 00 [total] => 0 [products_sold] => 0 ) [2014-03] => Array ( [year] => 2014 [month] => 03 [day] => 01 [hour] => 00 [total] => 0 [products_sold] => 0 ) [2014-04] => Array ( [year] => 2014 [month] => 04 [day] => 01 [hour] => 00 [total] => 0 [products_sold] => 0 ) [2014-05] => Array ( [year] => 2014 [month] => 05 [day] => 01 [hour] => 00 [total] => 0 [products_sold] => 0 ) [2014-06] => Array ( [year] => 2014 [month] => 06 [day] => 01 [hour] => 00 [total] => 0 [products_sold] => 0 ) [2014-07] => Array ( [year] => 2014 [month] => 07 [day] => 01 [hour] => 00 [total] => 0 [products_sold] => 0 ) [2014-08] => Array ( [year] => 2014 [month] => 08 [day] => 01 [hour] => 00 [total] => 0 [products_sold] => 0 ) [2014-09] => Array ( [year] => 2014 [month] => 09 [day] => 01 [hour] => 00 [total] => 0 [products_sold] => 0 ) [2014-10] => Array ( [year] => 2014 [month] => 10 [day] => 01 [hour] => 00 [total] => 0 [products_sold] => 0 ) [2014-11] => Array ( [year] => 2014 [month] => 11 [day] => 01 [hour] => 00 [total] => 0 [products_sold] => 0 ) [2014-12] => Array ( [year] => 2014 [month] => 12 [day] => 01 [hour] => 00 [total] => 0 [products_sold] => 0 ) [2015-01] => Array ( [year] => 2015 [month] => 01 [day] => 01 [hour] => 00 [total] => 0 [products_sold] => 0 ) [2015-02] => Array ( [year] => 2015 [month] => 02 [day] => 01 [hour] => 00 [total] => 0 [products_sold] => 0 ) [2015-03] => Array ( [year] => 2015 [month] => 03 [day] => 01 [hour] => 00 [total] => 0 [products_sold] => 0 ) [2015-04] => Array ( [year] => 2015 [month] => 04 [day] => 01 [hour] => 00 [total] => 0 [products_sold] => 0 ) ) 1) Yes I did click that red button several times to clear filers. 2) PHP 5.3; mySQL 5.5 3) No structural changes. However, I did upgrade my store from OSCommerce version 2.3.3 to OSCommerce version 2.3.4 Bootstrap.

@@Dr. Rolex setlocale(LC_ALL, array('en_US.UTF-8', 'en_US.UTF8', 'enu_usa')); define('DATE_FORMAT_SHORT', '%m/%d/%Y'); // this is used for strftime() define('DATE_FORMAT_LONG', '%A %d %B, %Y'); // this is used for strftime() define('DATE_FORMAT', 'm/d/Y'); // this is used for date() define('PHP_DATE_TIME_FORMAT', 'm/d/Y H:i:s'); // this is used for date() define('DATE_TIME_FORMAT', DATE_FORMAT_SHORT . ' %H:%M:%S'); define('JQUERY_DATEPICKER_I18N_CODE', ''); // leave empty for en_US; see http://jqueryui.com/demos/datepicker/#localization define('JQUERY_DATEPICKER_FORMAT', 'mm/dd/yy'); // see http://docs.jquery.com/UI/Datepicker/formatDate

Yes the statistics are shifted one month. It names March twice and omits November all together. The sales numbers are correct. However, it seems the tax is not calculated after the 8th of the month. It shows that I collected tax on the 8th while I know I didn't collect any taxes that day. The taxes shown on the 8th are suppose to be for the 25th of April. However, if I filter it by day, the correct taxes are shown but the wrong month is shown. Maybe it's because February has only 28 days and skew data for subsequent months. This add-on is great. And I really appreciate the work you put into it. If that issue is resolved, it would be even greater. I would be more than happy to test your corrections if you allow it.

@@Dr. Rolex I installed this on OSC version 2.3.4 Bootstrap and I will admit my store has +150K products. The only problem I see so far is the current month isn't displayed properly. Instead of displaying April is showing March.

Hello @@burt or whomever can give insight, Excuse me if this seems off topic. I have been researching long-tailed keywords and how to apply them to my seo efforts. From what I gathered, long-tailed keywords are less competitive and gives an opportunity to rank higher in the search engine results for them. Also, they are keyword phrases ranging 3 to 6 keywords. I would like advice on how to use Header Tags Reloaded to properly apply long-tailed keywords. Should they be used as an alternate Title or Mini Description? If anyone has used long-tailed keywords please share. Thanks.

Hello, I just installed this add-on for 2.3.3.4 BS version. It seems to be working just fine. I have one question. Would it be better if the customers aren't added to the customers table until after an order was placed? My reason for the question is it runs a high risk of duplicate entries if the customer abandon the cart then return later to complete the order. Forgive me if this has been answered already.

Jack, I'm glad I found this addon. It will be a great tool once I fully understand it's workings. Where's 'not_for_use.php'? It was not in the uploads. I encounter this in admin on view_counter_color.php at the bottom when I try to go to the next page. Also, can I view the visitors on my site in real time? If so, where? Thanks for your time.

@@geoffreywalton My shop version is 2.3.4 BS. I was trying to delete over 5000 occurrences of duplicate product names. It would be tedious to delete them one by one. Can you suggest an SQL statement that will find and list duplicate product names in phpmyadmin that will accomplish this? Thanks for your time and assistance