Order Tracker New Contrib....

[kwala]

Hi everybody,

I'm using MS1 and when I tried to use that contribution, I got this:

 

 

Warning: main(../../../config.php): failed to open stream: No such file or directory in /Myurl/includes/application_top.php on line 26

 

Warning: main(../../../config.php): failed to open stream: No such file or directory in /Myurl/includes/application_top.php on line 26

 

Fatal error: main(): Failed opening required '../../../config.php' (include_path='.:/usr/local/lib/php') in /Myurl/includes/application_top.php on line 26

 

 

anyone have any idea what's that and how to fix it ?

 

Thanks :)

[offerandsell]

I installed the latest Version in an nearly new osc.

And I got this error ...

 

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

Parse error: parse error, unexpected ';', expecting ')' in /usr/local/etc/httpd/vhtdocs/offeran/eshop/catalog/admin/includes/boxes/reports.php on line 31

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

 

Here is my reports.php

 

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

<?php

/*

$Id: reports.php,v 1.5 2003/07/09 01:18:53 hpdl Exp $

 

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Copyright © 2002 osCommerce

 

Released under the GNU General Public License

*/

?>

<!-- reports //-->

<tr>

<td>

<?php

$heading = array();

$contents = array();

 

$heading[] = array('text' => BOX_HEADING_REPORTS,

'link' => tep_href_link(FILENAME_STATS_PRODUCTS_VIEWED, 'selected_box=reports'));

 

if ($selected_box == 'reports') {

$contents[] = array('text' => '<a href="' . tep_href_link(FILENAME_STATS_PRODUCTS_VIEWED, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_PRODUCTS_VIEWED . '</a><br>' .

'<a href="' . tep_href_link(FILENAME_STATS_PRODUCTS_PURCHASED, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_PRODUCTS_PURCHASED . '</a><br>' .

'<a href="' . tep_href_link(FILENAME_STATS_CUSTOMERS, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_ORDERS_TOTAL . '</a><br>' .

'<a href="' . tep_href_link(FILENAME_STATS_ORDERS_TRACKING_COUNTRIES, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_ORDERS_TRACKING_COUNTRIES . '</a><br>' .

'<a href="' . tep_href_link(FILENAME_STATS_ORDERS_TRACKING_ZONES, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_ORDERS_TRACKING_ZONES . '</a><br>' .

'<a href="' . tep_href_link(FILENAME_STATS_ORDERS_TRACKING, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_ORDERS_TRACKING . '</a><br>' .

'<a href="' . tep_href_link(FILENAME_STATS_STATUS_TRACKING, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_STATUS_TRACKING . '</a><br>' .

'<a href="' . tep_href_link(FILENAME_STATS_ORDERS_TRACKING_POSTCODES, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_ORDERS_TRACKING_POSTCODES . '</a>';

}

 

$box = new box;

echo $box->menuBox($heading, $contents);

?>

</td>

</tr>

<!-- reports_eof //-->

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

 

Anyone an idea what`s wrong ???

 

Thanx for your answer ...

 

Greetz

Michael

[Guest]

Wow.... Been a few years since ive seen this.

Jcall - I was reading the old post and about a year ago you ask me what does the Close Ratio mean. well after a few years i will anwser you. lol lol :blush: :blush: :blush: :blush: :blush: :blush:

 

the Close Ratio is the percent of buyers. so, if i had 10 new sign ups and 2 ppl bought somthing then my close ratio is = 20%

 

 

I have not been around for a while. been off in the jungle. and now im back!!!!

[Guest]

@Kwala - MS1 is not tested with this contribution. Sorry.

 

@Michael - it looks you're missing a close-paren. Change this:

'<a href="' . tep_href_link(FILENAME_STATS_ORDERS_TRACKING_POSTCODES, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_ORDERS_TRACKING_POSTCODES . '</a>';

 

to this:

'<a href="' . tep_href_link(FILENAME_STATS_ORDERS_TRACKING_POSTCODES, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_ORDERS_TRACKING_POSTCODES . '</a>');

 

@Jello - good to see you back!

 

-jared

[Guest]

Hi Guys

 

 

I am trying to do two things with the orders_tracking contribution,

the first is to have a drop down menu or a fix so it only calculates despatched orders

and despatced reapeat customers

the second is that each month has the repeat customers like the year total, so comparisions can be made.

I can work on the later but I am a little stuck on the former. If anyone can do one, or the other or both would be very very greatfulll.

 

Many thanks

 

Peter

[Guest]

Having said that I am not sure I can do either :(

[Guest]

Having said that I am not sure I can do either :(

 

 

Can anyone help, I'm getting desperate

thanks!

 

Peter

[jetski]

Just installed Order Tracker v2.8b and I get this error:

Parse error: parse error in G:\inetpub\vhosts\xxx.com\httpdocs\catalog\admin\includes\boxes\reports.php on line 32

 

here is the Report.php file:

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

<?php

/*

$Id: reports.php,v 1.5 2003/07/09 01:18:53 hpdl Exp $

 

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Copyright © 2002 osCommerce

 

Released under the GNU General Public License

*/

?>

<!-- reports //-->

<tr>

<td>

<?php

$heading = array();

$contents = array();

 

$heading[] = array('text' => BOX_HEADING_REPORTS,

'link' => tep_href_link(FILENAME_STATS_PRODUCTS_VIEWED, 'selected_box=reports'));

 

if ($selected_box == 'reports') {

$contents[] = array('text' => '<a href="' . tep_href_link(FILENAME_STATS_PRODUCTS_VIEWED, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_PRODUCTS_VIEWED . '</a><br>' .

'<a href="' . tep_href_link(FILENAME_STATS_PRODUCTS_PURCHASED, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_PRODUCTS_PURCHASED . '</a><br>' .

'<a href="' . tep_href_link(FILENAME_STATS_CUSTOMERS, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_ORDERS_TOTAL . '</a>');'<a href="' . tep_href_link(FILENAME_STATS_ORDERS_TRACKING, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_ORDERS_TRACKING . '</a><br>' .

'<a href="' . tep_href_link(FILENAME_STATS_ORDERS_TRACKING_COUNTRIES, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_ORDERS_TRACKING_COUNTRIES . '</a><br>' .

'<a href="' . tep_href_link(FILENAME_STATS_ORDERS_TRACKING_ZONES, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_ORDERS_TRACKING_ZONES . '</a><br>' .

'<a href="' . tep_href_link(FILENAME_STATS_STATUS_TRACKING, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_STATUS_TRACKING . '</a><br>' .

'<a href="' . tep_href_link(FILENAME_STATS_ORDERS_TRACKING_POSTCODES, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_ORDERS_TRACKING_POSTCODES . '</a><br>' .

 

}

 

$box = new box;

echo $box->menuBox($heading, $contents);

?>

</td>

</tr>

<!-- reports_eof //-->

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

 

Any help Please!!!!

[jetski]

Just installed Order Tracker v2.8b and I get this error:

Parse error: parse error in G:\inetpub\vhosts\xxx.com\httpdocs\catalog\admin\includes\boxes\reports.php on line 32

 

here is the Report.php file:

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

<?php

/*

$Id: reports.php,v 1.5 2003/07/09 01:18:53 hpdl Exp $

 

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Copyright ? 2002 osCommerce

 

Released under the GNU General Public License

*/

?>

<!-- reports //-->

<tr>

<td>

<?php

$heading = array();

$contents = array();

 

$heading[] = array('text' => BOX_HEADING_REPORTS,

'link' => tep_href_link(FILENAME_STATS_PRODUCTS_VIEWED, 'selected_box=reports'));

 

if ($selected_box == 'reports') {

$contents[] = array('text' => '<a href="' . tep_href_link(FILENAME_STATS_PRODUCTS_VIEWED, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_PRODUCTS_VIEWED . '</a><br>' .

'<a href="' . tep_href_link(FILENAME_STATS_PRODUCTS_PURCHASED, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_PRODUCTS_PURCHASED . '</a><br>' .

'<a href="' . tep_href_link(FILENAME_STATS_CUSTOMERS, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_ORDERS_TOTAL . '</a>');'<a href="' . tep_href_link(FILENAME_STATS_ORDERS_TRACKING, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_ORDERS_TRACKING . '</a><br>' .

'<a href="' . tep_href_link(FILENAME_STATS_ORDERS_TRACKING_COUNTRIES, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_ORDERS_TRACKING_COUNTRIES . '</a><br>' .

'<a href="' . tep_href_link(FILENAME_STATS_ORDERS_TRACKING_ZONES, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_ORDERS_TRACKING_ZONES . '</a><br>' .

'<a href="' . tep_href_link(FILENAME_STATS_STATUS_TRACKING, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_STATUS_TRACKING . '</a><br>' .

'<a href="' . tep_href_link(FILENAME_STATS_ORDERS_TRACKING_POSTCODES, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_ORDERS_TRACKING_POSTCODES . '</a><br>' .

 

}

 

$box = new box;

echo $box->menuBox($heading, $contents);

?>

</td>

</tr>

<!-- reports_eof //-->

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

 

Any help Please!!!!

 

 

ok, just fixed the problem with the parse error, here is the working code:

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

<?php

/*

$Id: reports.php,v 1.5 2003/07/09 01:18:53 hpdl Exp $

 

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Copyright © 2002 osCommerce

 

Released under the GNU General Public License

*/

?>

<!-- reports //-->

<tr>

<td>

<?php

$heading = array();

$contents = array();

 

$heading[] = array('text' => BOX_HEADING_REPORTS,

'link' => tep_href_link(FILENAME_STATS_PRODUCTS_VIEWED, 'selected_box=reports'));

 

if ($selected_box == 'reports') {

$contents[] = array('text' => '<a href="' . tep_href_link(FILENAME_STATS_ORDERS_TRACKING_COUNTRIES, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_ORDERS_TRACKING_COUNTRIES . '</a><br>' .

'<a href="' . tep_href_link(FILENAME_STATS_ORDERS_TRACKING_ZONES, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_ORDERS_TRACKING_ZONES . '</a><br>' .

'<a href="' . tep_href_link(FILENAME_STATS_STATUS_TRACKING, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_STATUS_TRACKING . '</a><br>' .

'<a href="' . tep_href_link(FILENAME_STATS_ORDERS_TRACKING_POSTCODES, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_ORDERS_TRACKING_POSTCODES . '</a><br>' .

'<a href="' . tep_href_link(FILENAME_STATS_PRODUCTS_VIEWED, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_PRODUCTS_VIEWED . '</a><br>' .

'<a href="' . tep_href_link(FILENAME_STATS_PRODUCTS_PURCHASED, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_PRODUCTS_PURCHASED . '</a><br>' .

'<a href="' . tep_href_link(FILENAME_STATS_CUSTOMERS, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_ORDERS_TOTAL . '</a>');

}

 

$box = new box;

echo $box->menuBox($heading, $contents);

?>

</td>

</tr>

<!-- reports_eof //-->

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

[Guest]

Peter - - what do you mean by despatched orders? Would you like the stats to only include orders that you've shipped? If so, then it would be possible to do. The difficulty would depend on which order status number you are using for "Shipped" or "Dispatched" and whether or not there are other status codes that have higher numbers.

 

What are the status numbers associated with your order statuses?

 

-jared

[rubygirl]

Is it possible to have the daily order totals only rely on the date purchased instead of sequential order #s? the program works wonderfully until an order is deleted ... then the totals are off. Currently this is what happens.

 

Lets say you have 3 orders today. Order #s are:

 

1111,1113,1114

 

the program calculates correctly that there are 3 orders - then it takes the 3 and subtracts it from the largest order id. Then it takes the order totals from 1112, 1113, and 1114. However since there is no 1112 order - 1111 is now not included in the order totals for today. So if the totals could be calculated only with the order_total from the date_purchased table - that would - I think - fix this problem

 

anyone have any idea on how to change this up?

 

thanks!

[TADD]

Hi, I would like to project the sales for the YEAR alongside the already existing projection for the MONTH. So I edited the following code (quick fix). But this bases the projection only on the existing month's average sales. How can I get the code to base the projection on the year-to-date average sales?

 

File: admin/orders_tracking.php

 

Before:

 

<td class="messageStackError" align=right><?php echo $store_currency_symbol . $projected_total ?></TD>

<td class="dataTableContent" align=right> </TD>

 

After:

 

<td class="messageStackError" align=right><?php echo $store_currency_symbol . $projected_total ?></TD>

<td class="dataTableContent" align=right><?php echo $store_currency_symbol . $daily_total * 365 ?></TD>

 

Thanks,

 

TADD

[candleman]

Just installed this great contrib...v2.8b. All seems to work but the track by zone. I get the following error when I click on that link in admin.

 

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 'Aosta ' and date_purchased >= '2007-1-01 00:00:00' and date_purchased <= '2007-1' at line 1

select count(*) as count from orders where customers_state = 'Val d'Aosta ' and date_purchased >= '2007-1-01 00:00:00' and date_purchased <= '2007-12-31 11:59:59'

 

I noticed in the forums someone had a similar problem and was told the latest version should have addressed it. Not sure what to do since I have the latest version.

 

Thanks

[surfinagain]

Hi, I would like to project the sales for the YEAR alongside the already existing projection for the MONTH. So I edited the following code (quick fix). But this bases the projection only on the existing month's average sales. How can I get the code to base the projection on the year-to-date average sales?

 

File: admin/orders_tracking.php

 

Before:

After:

Thanks,

 

TADD

 

I am having the same problem and this after I just upgraded to the lastest 2.9 version. please help!

[robin30]

hi all,

 

Love this contribution.

 

I just have 1 little small problem,lol

 

when I click on order tracking i get this error message:

 

1054 - Unknown column 'p.products_cost' in 'field list'

select p.products_id, p.products_quantity, p.products_cost, p.products_price from products p where p.products_quantity > '0' and p.products_quantity < '500'

 

i got mysql 5.

 

but when search in orders_tracking.php can't find it.

 

Hope somebody can help.

 

Thanks in advance.

 

Robin

[Silverado05]

Just installed this great contrib...v2.8b. All seems to work but the track by zone. I get the following error when I click on that link in admin.

 

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 'Aosta ' and date_purchased >= '2007-1-01 00:00:00' and date_purchased <= '2007-1' at line 1

select count(*) as count from orders where customers_state = 'Val d'Aosta ' and date_purchased >= '2007-1-01 00:00:00' and date_purchased <= '2007-12-31 11:59:59'

 

I noticed in the forums someone had a similar problem and was told the latest version should have addressed it. Not sure what to do since I have the latest version.

 

Thanks

 

 

I am having this same problem, does anyone know of a fix for this?

[mousewebdesign]

hi all,

 

Love this contribution.

 

I just have 1 little small problem,lol

 

when I click on order tracking i get this error message:

 

1054 - Unknown column 'p.products_cost' in 'field list'

select p.products_id, p.products_quantity, p.products_cost, p.products_price from products p where p.products_quantity > '0' and p.products_quantity < '500'

 

i got mysql 5.

 

but when search in orders_tracking.php can't find it.

 

Hope somebody can help.

 

Thanks in advance.

 

Robin

 

Hi there,

 

I've got the same problem. The problem is that we don't have p.products_cost in our database, and I don't know what it does because the standard OsCommerce doesn't have this table.

 

Does anyone know If I just can delete this table? Or is it needed for this contribution?

 

Marcus

[mousewebdesign]

Hi there,

 

I've got the same problem. The problem is that we don't have p.products_cost in our database, and I don't know what it does because the standard OsCommerce doesn't have this table.

 

Does anyone know If I just can delete this table? Or is it needed for this contribution?

 

Marcus

 

Oeps,

 

nevermind, I just deleted it and everything is working fine.

 

Marcus

[PJ2006]

I've installed this and have a couple of problems:

 

When I click on Order_tracking in Admin I get:

 

1054 - Unknown column 'p.products_cost' in 'field list'

 

select p.products_id, p.products_quantity, p.products_cost, p.products_price from products p where p.products_quantity > '0' and p.products_quantity < '500'

 

[TEP STOP]

 

Also all of the tables are missing proper headings i.e.

 

HEADING_TITLE

 

HEADING_SELECT_YEAR HEADING_SELECT_MONTH

 

 

 

HEADING_COUNTRY HEADING_ORDER_COUNT HEADING_ORDER_VALUE HEADING_PCT_BY_VALUE

 

for the Orders_by_Country report

 

Any ideas what I've done wrong.

 

I've installed version 2.9b

 

By the way I do think it's a great contrib, should probably have said that first!

 

Thanks

 

Lotti

[PJ2006]

Oeps,

 

nevermind, I just deleted it and everything is working fine.

 

Marcus

What did you delete to get this working? I'm still struggling, I'd rather not have to uninstall it all

[PJ2006]

What did you delete to get this working? I'm still struggling, I'd rather not have to uninstall it all

 

Can anyone tell me how to get this contribution working, I see I'm not alone with this problem and guess many more will run into it - could someone give the solution?

[PJ2006]

Can anyone tell me how to get this contribution working, I see I'm not alone with this problem and guess many more will run into it - could someone give the solution?

For anyone else tat hits this here is the fix:

 

in admin\orders_tracking.php

 

replace the following line:

 

 $cost_query_raw = "select p.products_id, p.products_quantity, p.products_cost, p.products_price from " . TABLE_PRODUCTS . "

 

with

 

$cost_query_raw = "select p.products_id, p.products_quantity, p.products_price from " . TABLE_PRODUCTS . "

 

My remaining problem is that all the rport titles are in spanish or something - can anyone help me with that?

[kmb40]

For anyone else tat hits this here is the fix:

 

in admin\orders_tracking.php

 

replace the following line:

 

 $cost_query_raw = "select p.products_id, p.products_quantity, p.products_cost, p.products_price from " . TABLE_PRODUCTS . "

 

with

 

$cost_query_raw = "select p.products_id, p.products_quantity, p.products_price from " . TABLE_PRODUCTS . "

 

My remaining problem is that all the rport titles are in spanish or something - can anyone help me with that?

 

Looks like the package labeled "small bug fixed" on 18 Oct 2007 by tomcat, which says it contains the complete package, contains Espanol language files in the English language folder instead of English files. To correct the problem, gather the the package entitled "v2.9a" on 18 Oct 2007.

 

Drill down to "orders_tracking_2.9a\admin\includes\languages\english" copy all of the files in this directory and overwrite the files in the same directory from package "2.9b".

[TracyS]

Just installed this contribution and it is awesome!

 

I'm hoping the creators might be willing to help me tackle a customization as it appears they have the knowledge on how to do this :blush:

 

I have the "How did you hear about us" contribution installed. I need to pull a custom report for this:

 

I need to know how many customers signed up under each of the "referral" options during a specific time period, how many of those new customers ordered and the total $ amount of those orders as well as how many customers with that particular referral name placed a repeat order and the total $ of those orders.

 

So something like:

Date From Dropdown Date To Dropdown Submit Button

 

Table columns of:

 

Referral Source Name | # New Customers | # Orders from those new customers | Total of those Orders $ | # Orders Repeat Customers | Total of those Orders

 

I realize this is for a different contribution - but it would appear some of what I need exists in this contribution as you've figured out how to get 1st time orders and repeat orders information. Also - a layout similar to the status_tracking would be great as we could have the Referral Source Name in place of the Order Status.

 

I'm just not sure how to code this, and I'm hoping someone here also uses the "How did you hear about us" contribution and has already done something similar.

 

If it's helpful - there are the following database tables and rows

 

sources

sources_id

sources_name

 

sources_other

customers_id

sources_other_name

 

customers_info

customers_info_source_id (same as sources_id)

customers_info_id (same as customers_id)

 

So - in order to get the sources_name from the database, you have to first match the customers_id to the customers_info_id to see what the customers_info_source_id is - then match that to the sources_id

 

If the sources_id = '9999' then that means they checked the "Other" option and the sources name has to be pulled from the sources_other table as sources_other_name.

 

The admin/includes/general.php file has this in it:

// rmh referral
 function tep_get_sources_name($source_id, $customers_id) {

if ($source_id == '9999') {
  $sources_query = tep_db_query("select sources_other_name as sources_name from " . TABLE_SOURCES_OTHER . " where customers_id = '" . (int)$customers_id . "'");
} else {
  $sources_query = tep_db_query("select sources_name from " . TABLE_SOURCES . " where sources_id = '" . (int)$source_id . "'");
}

if (!tep_db_num_rows($sources_query)) {
  if ($source_id == '9999') {
	return TEXT_OTHER;
  } else {
	return TEXT_NONE;
  }
} else {
  $sources = tep_db_fetch_array($sources_query);
  return $sources['sources_name'];
}
 }
//EOF rmh referral

 

Anybody game for helping me figure out how to do this? :blush:

 

Thanks in advance!

[Tommunich]

Great Contribution, thanks a lot!

 

Only in Step 5 in the install.txt there ist the SQL command

 

ALTER TABLE orders ADD INDEX (customers_postcode), ADD INDEX (customers_postcode);

 

Twice an Index on customers_postcode, could this be right?

 

Greets,

Thomas