Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

BenjaminB

Members
  • Content count

    10
  • Joined

  • Last visited

Everything posted by BenjaminB

  1. Hello forum user, my question is, why does the EasyPopulate contrib uses the products_model as a required field to identify the products? Why not use the products_id? Or does anybody know which changes are needed to let this contrib use the products_id? Im building a shop for a customer, which has already entered about 400 products. Some has a product_model some dont, some use a model name like XXXXXXX, some use a model name like XXX-XXX. I was thinking to make the products_model column unique and use auto_increment where the first product is 10000. Then i would remove the products_model from the input mask in the admin area, so that it always uses the incremented value. Is this practicable? Thx in advance. Regards Benjamin. //edit: before questions come up, the customer is a reseller for various companies and uses their product model names (if they have any), thats why the product models differ so much.
  2. So i got it working, i hope i used the right approach. Here is my code: I only altered html_output.php: Line 96, from: $rewrite_page_product = short_name(constant('PRODUCT_NAME_'.$p2[1])) . '-p-' . $p2[1] . '.html'; to: // Addition to write the manufacturers name into the static link too $manufac_query = tep_db_query("SELECT " . TABLE_MANUFACTURERS . ".manufacturers_name FROM " . TABLE_MANUFACTURERS . " INNER JOIN " . TABLE_PRODUCTS . " ON " . TABLE_MANUFACTURERS . ".manufacturers_id = " . TABLE_PRODUCTS . ".manufacturers_id WHERE " . TABLE_PRODUCTS . ".products_id = " . $p2[1]); $manufac_name = ""; while ($manufac = tep_db_fetch_array($manufac_query)) { $manufac_name = $manufac['manufacturers_name']; } if ($manufac_name != '') { $rewrite_page_product = short_name($manufac_name) . "-" . short_name(constant('PRODUCT_NAME_'.$p2[1])) . '-p-' . $p2[1] . '.html'; } else { $rewrite_page_product = short_name(constant('PRODUCT_NAME_'.$p2[1])) . '-p-' . $p2[1] . '.html'; } I also did some changes to the short_name function, to replace some umlauts, but this is just for the german speaking people. I just added these lines directly after the function declaration: $str = str_replace("?", "ae", $str); $str = str_replace("?", "oe", $str); $str = str_replace("?", "ue", $str); $str = str_replace(" ", "-", $str); Im just writing this because i think i read someones post asking about this.
  3. BenjaminB

    [contribution] Simple Template System (sts)

    Sorry was my fault, i forgot the STS code in application_top.php. Now everythings works fine. Thanks to the author for a fine contrib ;)
  4. Okay i solved my problem. The cause was the Master Products contrib. Some sql queries in the index.php and advanced_search_results.php didnt requested the prducts_master and products_master_status from aboive mentioned contrib. The product_info.php had a routine which to set all get params, which set the buy_now action. This routine asked for the master and master_status. Because the queries on the other page didnt requested this db columns, this routine failed and didnt provide the products_id to the tep_href_link, which then itself failed and returned an "old-style" link without a products id. I added the columns to the queries and everything works fine now. Now onto my other "problem", how do i modify the tep_href_link, that it always (if not empty) shows the manufacturer in the link like this /manufacturer-product-p-10.html for every product? Thx in advance, regards Benjamin
  5. No sorry. But i have some snippets and some information. If i use the manufacturers dropdown, the link is like this /index.php?manufacturers_id=10 not like /xxx-m-10.html. Ive found the repsective code lines (taken from product_listing.php): I dont know where the problem is, because in this snippet the function tep_href_link is called, and this is what ive modified for SEO. The other links in the product_listing, if called with isset(manufacturers_id) are fine (the text and the image link). They come up like this /xxx-p-10.html. Only the buy_now column wont work. It does work if you just browse through the categories. Imho the Master Products contrib is part of the problem, because it modifies the buy_now column. If a product is just a master product without a price, the buy_now column just takes you to the product details. But the products id is always empty on the buy_now image. It comes up like /product_info.php?products_id=. Without the products id or the "action=buy_now&sort=2a" parameter.
  6. HTTP Server: Apache/2.0.40 (Red Hat Linux) PHP Version: 4.2.2 (Zend: 1.2.0) osCommerce Version: ms2-2 installed contribs: UltraPics - MS2 Image Addon Pack! Link: http://www.oscommerce.com/community/contributions,1642/ Master Products - MS2 Link: http://www.oscommerce.com/community/contributions,1681/ Credit Class & Gift Voucher *working* Link: http://www.oscommerce.com/community/contributions,282/ Ultimate SEO URLs Link: http://www.oscommerce.com/community/contributions,2823/ Simple Template System Link: http://www.oscommerce.com/community/contributions,1524/ Header Tags Controller Link: http://www.oscommerce.com/community/contributions,207/
  7. I've installed this: 1 Feb 2005 - Ultimate SEO URLs v2.0 Author: Chemo
  8. I have been searching through many pages of this thread for about 2 hours now, but i didnt found anything (neither did i found a edit button, to edit my previous post). i still have problems with the buy now (buy_now) button. it wont work on search results and if i use the manufacturer drop down. please help. thanks in advance. regards benjamin
  9. What steps should i do if i want the manufacturer name in the link for a product?
  10. BenjaminB

    [contribution] Simple Template System (sts)

    Hello there, i have a problem with this contrib. the sts system duplicates my html, head, body tags. heres some code: <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <html dir="LTR" lang="de"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <title>osCommerce</title> <base href="http://www.leuchtenzentrale.de/catalog/"> <link rel="stylesheet" type="text/css" href="stylesheet.css"> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0"> <!-- header //--> <!-- Page layout by Simple Template System (STS) v2.01 on osCommerce 2.2-MS2 - http://www.diamondsea.com/sts/ --> <!-- Using Template File [includes/sts_template.html) --> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <title>osCommerce</title><base href="http://www.leuchtenzentrale.de/catalog/"> <!-- start get_javascript(applicationtop2header) //--> <!-- end get_javascript(applicationtop2header) //--> <link rel="stylesheet" type="text/css" href="stylesheet.css"> </head> <body> Ive seen this problem in this thread around page 5 or so, but this was ages ago (v1.3) and didnt helped me. i didnt got anything useful with this forums' search engine. can anyone please help me. thx in advance. regards benjamin
×