Jump to content

rpain

Members
  • Content count

    12
  • Joined

  • Last visited

Profile Information

  • Real Name
    Richard Pain
  1. Yes please - I'd also be really grateful to know a solution to the printorder with pwa contribution. Thanks Richard
  2. rpain

    Bundled products

    Anyone have any idea on how to skip the preview page? I know it's in the categories.php but the again isn't everything...I know it's just a case of redirecting a form (or changing the &action= bit) somewhere but don't know exactly which one. Many thanks, Richard PS Is there any option to show the individual product attributes for the bundle sub products? - or a way round it. Sorry to nag...
  3. rpain

    Bundled products

    Is there any option to show the individual product attributes for the bundle sub products? Richard
  4. rpain

    Bundled products

    Doesn't the product value need to be a number to refer to the foreign bundles table? Richard
  5. rpain

    Bundled products

    Sorry for the last but one message. I tried this out myself and found the setting bundle to be 'yes' shows the bundle but now leaving blank removes it. I still can't change the bundle itself, though
  6. rpain

    Bundled products

    Sorry, the only other question is how I can get the bundle contents to show up in the shopping cart, invoice and the email sent to the customer? I thought that when the product is added to the orders_products table, I'd append the bundle as a string to the products_name field. I'm not sure where to look to do this, though. Firstly, which page stores the products in the database and secondly is it near the product_info page when the bundle contents are displayed? Would the best thing to do be to create a session with the bundle contents and then append it later on? Confusing... Thanks, Richard
  7. rpain

    Bundled products

    Thanks - does this mean that if I bypass the preview page and just submit to the categories page with 'action=update_product' then it should work correctly? I do agree that the preview page is a waste of time. Richard
  8. Apologies to Chandra - I hadn't read the instructions properly even though it was made very clear. What a fool! Richard
  9. rpain

    Bundled products

    Hi, Thanks for the mod - it's been a real life saver. Just one problem (and I've tried applying the mod twice both on clean installations but still have the same problem). Creating a product and bundle at the same time is fine. Updating the bundle doesn't happen at all. I've checked the database and it's fine but it won't update. I did also get this when I did a bundle change, went to the preview page and then clicked on 'back': 1064 - You have an error in your SQL syntax near 'and language_id = '1'' at line 1 SELECT products_bundles.subproduct_id, products_bundles.subproduct_qty, products_description.products_name FROM products_description INNER JOIN products_bundles ON products_bundles.subproduct_id=products_description.products_id WHERE products_bundles.bundle_id = and language_id = '1' Not sure whether this would be of any relevance. I've tried creating a product from scratch just in case is was a problem with modifying an old product but still no luck. I can post the code if that would be useful but thought I'd save space in the meantime. Many thanks, Richard
  10. Hi, Great contribution and a big help. Just a couple of problems. Both the radio buttons and the select list work fine. The checkboxes don't. The problem is that firstly the product_info page only displays one of the options and secondly it doesn't show the option name. See: http://rubidium.webfusion.co.uk/~handtec/p...&products_id=76 There should be a name to that checkbox. The shopping basket works fine, though. I reckon the problem is in this line: echo '<tr><td class="main">' . $products_options_name['products_options_name'] . ': </td><td class="main">'. $products_options_name['products_options_values_name'] ; - shouldn't there also be a name field other than $products_options_name which doesn't seem to return anything? Shouldn't the database query also include the table products_options_values which has the checkbox title in? I've double checked that the page has been merged properly. I've attached the checkbox portion below just in case... case PRODUCTS_OPTIONS_TYPE_CHECKBOX: //CLR 030714 Add logic for checkboxes $products_attribs_query = tep_db_query("select distinct patrib.options_values_id, patrib.options_values_price, patrib.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = '" . $products_options_name['products_options_id'] . "'"); $products_attribs_array = tep_db_fetch_array($products_attribs_query); echo '<tr><td class="main">' . $products_options_name['products_options_name'] . ': </td><td class="main">'. $products_options_name['products_options_values_name'] ; echo tep_draw_checkbox_field('id[' . $products_options_name['products_options_id'] . ']', $products_attribs_array['options_values_id']); echo $products_options_name['products_options_comment'] ; if ($products_attribs_array['options_values_price'] != '0') { echo '(' . $products_attribs_array['price_prefix'] . $currencies->display_price($products_attribs_array['options_values_price'], $product_info_values['products_tax_class_id']) .') '; } echo '</td></tr>'; break; Many many thanks - it's a great mod which should have been implemented in the main system Richard Pain
×