Order Tracker New Contrib....

[Guest]

hi

 

thats a useful addon, moreover one suggestion!

is it possible to build by products like a orders_tracking_products.php ?

[chrish123]

Hi, has anyone figured out the bug in where no orders for today have been placed, so the field should be 0 but instead is something like £34,242!?

[pdcelec]

Installed this on 2.3.1 and I am getting this error

 

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rib ' and date_purchased >= '2011-1-01 00:00:00' and date_purchased <= '2011-12-' at line 1

select count(*) as count from orders where customers_state = 'Ma'rib ' and date_purchased >= '2011-1-01 00:00:00' and date_purchased <= '2011-12-31 11:59:59' 

[lorem_ipsum]

Hi,

 

I had the same problem.

The problem is around the customers_state, if u have some states with 1 quote, the sql request sux.

You need to add addslashes function for the variable $customers_location['zone_name'].

 

 

In the file order_tracking.php line 1028

 

Change :

 

    $location_pending_query = tep_db_query("select count(*) as count from " . TABLE_ORDERS . " where customers_state = '". $customers_location['zone_name'] ." ' and date_purchased >= '$year-$startmonth-01 00:00:00' and date_purchased <= '$year-$endmonth-31 11:59:59' ");

 

 

With :

 

  $location_pending_query = tep_db_query("select count(*) as count from " . TABLE_ORDERS . " where customers_state = '". addslashes($customers_location['zone_name']) ." ' and date_purchased >= '$year-$startmonth-01 00:00:00' and date_purchased <= '$year-$endmonth-31 11:59:59' ");

 

Godd luck

[♥stubbsy]

Hi,

 

I'm trying to get the Orders by Zone file to order by count (number of orders) but whatever I try doesnt work.

 

I've tried adding ORDER BY count DESC to the query but no luck. I cant see why it wouldnt work.

 

$location_pending_query = tep_db_query("select count(*) as count from " . TABLE_ORDERS . " where customers_state = '". $customers_location['zone_name'] ." ' and date_purchased >= '$year-$startmonth-01 00:00:00' and date_purchased <= '$year-$endmonth-31 11:59:59' ORDER BY count DESC");

 

any ideas?

 

Thanks

 

Dave

[japanlover]

Hello,

 

I installed the contrib on 2.3.1 and it seems it is working flawless (hope it will ^_^ ), but since I use it for zones other than US, I get some "xxx" and the end of the ZIP codes. In Italy we got 5 digits for ZIP so I wonder if it is possible to have the code fully shown, since it is a major requirement for me to know what I ship to specific ZIPs.

 

Thank you.

[operaguy59]

I have installed Order Tracker V3.0 and am having trouble formatting the reports.php file. Has anyone been able to successfully edit this file?

[Guest]

Hi is this forum still active as installed the add on and love but just want to change the date format under sales summary from mm-dd to dd-mm

 

Any ideas any one

 

Thank you

 

Ian

[Carlitos12]

hello I have follow all the instructions, but I get this error:

Deprecated: mysql_query(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in C:\xampp\htdocs\oscommerce-2.3.3.4\catalog\admin\orders_tracking.php on line 193

Warning: mysql_query(): Access denied for user ''@'localhost' (using password: NO) in C:\xampp\htdocs\oscommerce-2.3.3.4\catalog\admin\orders_tracking.php on line 193

Warning: mysql_query(): A link to the server could not be established in C:\xampp\htdocs\oscommerce-2.3.3.4\catalog\admin\orders_tracking.php on line 193
Query failed : Access denied for user ''@'localhost' (using password: NO)      Help me please.  thanks

[♥frankl]

@Carlitos12

Replace instances of mysql_query with tep_db_query

That may not be the only thing wrong with the code in this contribution though.

Edited September 7, 2017 by frankl

[Carlitos]

Thank you. It worked. I Think I installed the old version.

But with this version : oscom-order-tracking-v3-0-for-oscommerce-v2-3-usXv7-1TOfJ    It works