Jump to content


  • Content count

  • Joined

  • Last visited

  1. 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]
  2. Hiroboy

    Stock Viewer - How to modify

    Many Thanks :)
  3. 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"; ?>
  4. 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 I have removed it for now till I can find out what is happening. Thanks in advance
  5. Hiroboy

    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 aaron@scaredrabbit.com 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
  6. Hiroboy

    Stock Status in Product Listing

    Thanks that worked perfect :)
  7. Hiroboy

    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.
  8. Hiroboy

    Order cannot shown in Admin

    Found the answer now : http://forums.oscommerce.com/index.php?showtopic=196613
  9. Hiroboy

    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 :(