[Margin Report add on Error Message (Help I'm lost)]

Hi Guys usually I can sort out my own errors but this one has me lost or maybe i'm having a blond day.

I've add the Margin Report Contribution to be OSC website (www.hiroboy.com) but get this error when trying to load the report

Thanks in advance for any advise

Steve H

 

Margin Report

Show:

1054 - Unknown column 'p.products_id' in 'on clause'

 

select count(*) as total from products p, products_to_categories p2c, categories c, products_description pd left join specials s on p.products_id = s.products_id where pd.language_id = '1' and p.products_id = pd.products_id and p2c.products_id = p.products_id and c.categories_id = p2c.categories_id

 

[TEP STOP]

[Stock Viewer - How to modify]

Many Thanks :)

[Stock Viewer - How to modify]

I have been using the "osCommerce Stock Viewer"

http://www.oscommerce.com/community/contributions,3317/

for some time now and it's very handy for Stock Checking and also working out total stock held etc.

 

But I would like it to output a field for manufacturers name, so when pasted into Excel, I could sort by Manufacture, which makes stock checking much easier.

 

This is the code as it stands, any help would be great.

 

<?
echo "<tr><td><b>". 'Products ID' . "</b></td>
<td><b>" . 'Products Name' . "</b></td>
<td><b>" . 'Products Model' . "</b></td>
<td><b>" . 'Products Status' . "</b></td>
<td><b>" . 'Products Qty' . "</b></td>
<td><b>" . 'Products Price' . "</b></td>
</tr><tr>";
$result = mysql_query("SELECT * FROM products, products_description WHERE products.products_id = products_description.products_id and products_description.language_id = '" . $languages_id . "' ORDER BY products_description.products_name");
if ($row = mysql_fetch_array($result)) {
	do {
		echo "<td class='infoBoxContents'> ".$row["products_id"]."</td>\n";
		echo "<td class='infoBoxContents'>".$row["products_name"]."</td>\n";
		echo "<td class='infoBoxContents'>".$row["products_model"]."</td>\n";
		echo "<td class='infoBoxContents'>".$row["products_status"]."</td>\n";
	echo "<td class='infoBoxContents'>".$row["products_quantity"]."</td>\n";
	echo "<td class='infoBoxContents'>".$row["products_price"]."</td>\n";
		echo "</tr>\n";
	}
	while($row = mysql_fetch_array($result));
}
echo "</table>\n";
?>

[Wishlist 2.0 Support Thread]

Just install Wishlist

and added the Admin "stats_wishlists.php"

But when run I get

Parse error: syntax error, unexpected T_REQUIRE in /home/hiro/public_html/catalog/admin/stats_wishlists.php on line 1

 

This is the "stats_wishlists.php" file contents.

 

<?php
/*
 $Id: stats_wishlists.php,v 1.00 2005/06/15

 Aaron Hiatt [email protected]
 http://www.scaredrabbit.com

 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com

 Copyright (c) 2003 osCommerce

 Released under the GNU General Public License
*/

define('HEADING_TITLE', 'Customer Wishlists');

define('TABLE_HEADING_NUMBER', 'Rank');
define('TABLE_HEADING_CUSTOMERS', 'Customers');
define('TABLE_HEADING_CUSTOMERS_COMPANY', 'Company');
define('TABLE_HEADING_CUSTOMERS_WISHLIST', 'Wishlist Products');
define('TABLE_HEADING_CUSTOMERS_GROUP_NAME', 'Price Level');
?>

 

I can't see what is wrong, any help would be great

Thanks

 

 

Anyone ?

[[Contribution] Ultimate SEO URLs - by Chemo]

I have just installed U SEO urls

and now seem to have a problem which I don't understand

the main page loads OK

http://www.hiroboy.com/catalog/

But when clicking on any product, I get the following browser error

The page isn't redirecting properly

 

Firefox has detected that the server is redirecting the request for this address in a way that will never complete.

 

* This problem can sometimes be caused by disabling or refusing to accept

cookies.

 

I have removed it for now till I can find out what is happening.

 

Thanks in advance

[Wishlist 2.0 Support Thread]

Just install Wishlist

and added the Admin "stats_wishlists.php"

But when run I get

Parse error: syntax error, unexpected T_REQUIRE in /home/hiro/public_html/catalog/admin/stats_wishlists.php on line 1

 

This is the "stats_wishlists.php" file contents.

 

<?php
/*
 $Id: stats_wishlists.php,v 1.00 2005/06/15

 Aaron Hiatt [email protected]
 http://www.scaredrabbit.com

 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com

 Copyright (c) 2003 osCommerce

 Released under the GNU General Public License
*/

define('HEADING_TITLE', 'Customer Wishlists');

define('TABLE_HEADING_NUMBER', 'Rank');
define('TABLE_HEADING_CUSTOMERS', 'Customers');
define('TABLE_HEADING_CUSTOMERS_COMPANY', 'Company');
define('TABLE_HEADING_CUSTOMERS_WISHLIST', 'Wishlist Products');
define('TABLE_HEADING_CUSTOMERS_GROUP_NAME', 'Price Level');
?>

 

I can't see what is wrong, any help would be great

Thanks

[Stock Status in Product Listing]

Thanks that worked perfect :)

[Stock Status in Product Listing]

I have installed this contrubution and it has been working great, But I would like it to display the

"Out Of Stock"

Button in the listing as well.

Now being a newbie, I'm unsure how to change the following to display the button.

 

case 'PRODUCT_LIST_BUY_NOW':
		$lc_align = 'center';
		if ((STOCK_CHECK == 'true')&&(tep_get_products_stock($listing['products_id']) < 1)) {
		  $lc_text = ' ';
		} else {
		  $lc_text = '<a href="' . tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $listing['products_id']) . '">' . tep_image_button('button_buy_now.gif', IMAGE_BUTTON_BUY_NOW) . '</a> ';
		}

 

I'm sure somehow you can get it to display the button here instead of the empty text

 

 if ((STOCK_CHECK == 'true')&&(tep_get_products_stock($listing['products_id']) < 1)) {
		  $lc_text = ' ';

 

Any help would be greatfull recieved.

[Order cannot shown in Admin]

Found the answer now :

http://www.oscommerce.com/forums/index.php?showtopic=196613

[Order cannot shown in Admin]

I have the very same problem at the moment and would also love to know the answer.

I have spent hours searching and still found no answer yet :(