tgely Posted September 25, 2011 Share Posted September 25, 2011 i installed mp v2.1 but I think there is missing one file in the packet: catalog/includes/modules/boxes/bm_best_sellers.php Thanks for note! bm_best_sellers.zip Quote osCommerce based shop owner with minimal design and focused on background works. When the less is more.Email managment with tracking pixel, package managment for shipping, stock management, warehouse managment with bar code reader, parcel shops management on 3000 pickup points without local store. Link to comment Share on other sites More sharing options...
tgely Posted September 25, 2011 Share Posted September 25, 2011 i forgot to mention that i'm stucked while merging the file catalog/product_info.php here are the two files, who can do this? I'm trying since days without any succes Hi, We need to do new module for it. As soon as possible I will do it in extras. The tab page navigation not fix yet. Regards Gergely Quote osCommerce based shop owner with minimal design and focused on background works. When the less is more.Email managment with tracking pixel, package managment for shipping, stock management, warehouse managment with bar code reader, parcel shops management on 3000 pickup points without local store. Link to comment Share on other sites More sharing options...
univer Posted September 26, 2011 Share Posted September 26, 2011 @Gergely ok, I already did answer in the other topic i'll wait for your further info thanks (also for sending missing file) Quote Link to comment Share on other sites More sharing options...
dspeak Posted October 14, 2011 Share Posted October 14, 2011 I am back at trying to get this to work. I am going to take 1 problem at a time. Is there anyway to change the drop down qty box on the master to a qty input box? Quote Link to comment Share on other sites More sharing options...
dspeak Posted October 14, 2011 Share Posted October 14, 2011 Let me rephrase the 1st problem I am having. When I go to product_info.php?products_id=xx, I have the text_quantity drop down box and limited to 20. Can I change this drop down box to a input box? Also when I am on the individual product page and enter a number in the drop down box, it will not update the shopping cart. Please help, I really like this contribution. Quote Link to comment Share on other sites More sharing options...
dspeak Posted October 16, 2011 Share Posted October 16, 2011 Anyone, please!!! Quote Link to comment Share on other sites More sharing options...
tgely Posted October 16, 2011 Share Posted October 16, 2011 (edited) Anyone, please!!! Hi, maybe reverse this: To use a checkbox in includes/modules/master_listing.php change $lc_text = tep_draw_input_field('Qty_ProdId_' . $listing['products_id'], '0', 'size="4"'); to $lc_text = tep_draw_input_field('Qty_ProdId_' . $listing['products_id'], '1', false); but this will not enough. At this moment v2.3.1 version use drop down. Look at Master Products pervious version for osCommerce 2.2 core. I will do admin switch for it in future. Edited October 16, 2011 by Gergely Quote osCommerce based shop owner with minimal design and focused on background works. When the less is more.Email managment with tracking pixel, package managment for shipping, stock management, warehouse managment with bar code reader, parcel shops management on 3000 pickup points without local store. Link to comment Share on other sites More sharing options...
dspeak Posted October 16, 2011 Share Posted October 16, 2011 thank you. I don't have a problem if the product is a master or slave. The problem arises when a product that is not assigned as a slave is chosen. The drop down menu limits the customer to only 20. I sell parts for farmers. A few of my products, the customer may order 20, 40 or sometimes as many as 500. Quote Link to comment Share on other sites More sharing options...
dspeak Posted October 17, 2011 Share Posted October 17, 2011 I am sure with all the great programmers out there, that someone can step up to the plate and figure out how to change the drop down box to a input box. Please someone. This is a wonderful contribution, and this is all that is needed to make it perfect. Quote Link to comment Share on other sites More sharing options...
kplace Posted October 23, 2011 Share Posted October 23, 2011 I was wondering if anyone else is having the same problem that I am. I have installed Master Products for V2.3 and I can assign a product as a master, but if I need to edit the product, I am not able to save it. I get redirected to the categories page and the changes are not saved. Attached is my categories.php page. categories.php Quote Link to comment Share on other sites More sharing options...
tgely Posted October 23, 2011 Share Posted October 23, 2011 I was wondering if anyone else is having the same problem that I am. I have installed Master Products for V2.3 and I can assign a product as a master, but if I need to edit the product, I am not able to save it. I get redirected to the categories page and the changes are not saved. Attached is my categories.php page. Hi try to close elseif branch: // BOF: Availability + Warranty if (isset($HTTP_POST_VARS['availability_id_out_of_stock_image']) && tep_not_null($HTTP_POST_VARS['availability_id_out_of_stock_image']) && ($HTTP_POST_VARS['availability_id_out_of_stock_image'] != 'none')) { $sql_data_array['availability_id_out_of_stock_image'] = tep_db_prepare_input($HTTP_POST_VARS['availability_id_out_of_stock_image']); } elseif (isset($HTTP_POST_VARS['availability_id_in_stock_image']) && tep_not_null($HTTP_POST_VARS['availability_id_in_stock_image']) && ($HTTP_POST_VARS['availability_id_in_stock_image'] != 'none')) { $sql_data_array['availability_id_in_stock_image'] = tep_db_prepare_input($HTTP_POST_VARS['availability_id_in_stock_image']); } elseif (isset($HTTP_POST_VARS['availability_id_in_stock2_image']) && tep_not_null($HTTP_POST_VARS['availability_id_in_stock2_image']) && ($HTTP_POST_VARS['availability_id_in_stock2_image'] != 'none')) { $sql_data_array['availability_id_in_stock2_image'] = tep_db_prepare_input($HTTP_POST_VARS['availability_id_in_stock2_image']); } elseif (isset($HTTP_POST_VARS['availability_id_in_stock3_image']) && tep_not_null($HTTP_POST_VARS['availability_id_in_stock3_image']) && ($HTTP_POST_VARS['availability_id_in_stock3_image'] != 'none')) { $sql_data_array['availability_id_in_stock3_image'] = tep_db_prepare_input($HTTP_POST_VARS['availability_id_in_stock3_image']); } elseif (isset($HTTP_POST_VARS['availability_id_in_stock_special_image']) && tep_not_null($HTTP_POST_VARS['availability_id_in_stock_special_image']) && ($HTTP_POST_VARS['availability_id_in_stock_special_image'] != 'none')) { $sql_data_array['availability_id_in_stock_special_image'] = tep_db_prepare_input($HTTP_POST_VARS['availability_id_in_stock_special_image']); // EOF: Availability add after { Quote osCommerce based shop owner with minimal design and focused on background works. When the less is more.Email managment with tracking pixel, package managment for shipping, stock management, warehouse managment with bar code reader, parcel shops management on 3000 pickup points without local store. Link to comment Share on other sites More sharing options...
kplace Posted October 24, 2011 Share Posted October 24, 2011 Thank you for the reply. I uninstalled Master Products and Reinstalled it and now it works perfect. Quote Link to comment Share on other sites More sharing options...
dspeak Posted October 26, 2011 Share Posted October 26, 2011 Does anyone know where the code is that controls the qty drop down box for the master product and for product_info. I am going to try and change this so it is a text input box. Quote Link to comment Share on other sites More sharing options...
tgely Posted October 27, 2011 Share Posted October 27, 2011 try a simple html php mixed code. <input name="Qty_ProdId_<?php echo $product_info['products_id']; ?>" type="text" size="30" maxlength="30"> its all. Quote osCommerce based shop owner with minimal design and focused on background works. When the less is more.Email managment with tracking pixel, package managment for shipping, stock management, warehouse managment with bar code reader, parcel shops management on 3000 pickup points without local store. Link to comment Share on other sites More sharing options...
jrvs Posted October 28, 2011 Share Posted October 28, 2011 Posted 17 February 2004, 17:38 In catalog/advanced_search_result.php change: $where_str = " where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id "; to: $where_str = " where p.products_status = '1' and p.products_master = '0' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id "; This only works if the Master has the search term - a better solution is to have the result return the Master if the search term is found within the Slave - something I shall get around to I am sure. Matti Ressler ----- I need to modify the $where_str code so that so that it searches all the slaves products_id and displays the master. Currently is either all slaves or only the masters (p.products_master = 0). Perhaps: $where_str = " where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id "; if (isset($HTTP_GET_VARS['products_master_status'] == 0) && (isset($HTTP_GET_VARS ['products_master'] != 0))) { $where_str .= " or p.products_master = '" . (int)$HTTP_GET_VARS['products_id'] . "'"; } Parse error: syntax error, unexpected T_IS_EQUAL, expecting ',' or ')' I would greatly appreciate your assistance – struggling for a couple of years with this issue. Quote Link to comment Share on other sites More sharing options...
tgely Posted October 28, 2011 Share Posted October 28, 2011 I would greatly appreciate your assistance – struggling for a couple of years with this issue. Hi, Could you put here the full query string? (try to use database logging and select the main query string) Quote osCommerce based shop owner with minimal design and focused on background works. When the less is more.Email managment with tracking pixel, package managment for shipping, stock management, warehouse managment with bar code reader, parcel shops management on 3000 pickup points without local store. Link to comment Share on other sites More sharing options...
jrvs Posted October 29, 2011 Share Posted October 29, 2011 Thank you so much for your reply. $Id: advanced_search_result.php,v 1.72 2003/06/23 Advanced_search_results.php is such an odd document. The $select, $from and $where_str statements are separated in portions. I know that the issue lies solely in: $where_str = " where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id "; The above displays all slaves – which sometimes are over 20 slaves per master. See Scientiis.com $where_str = " where p.products_status = '1' and p.products_master = '0' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id "; The above displays the master, but does not search the slaves. Searching for a slave model gives " There is no product that matches the search criteria." Maybe if I could adapt somehow the following: // Master Products $master_prod = tep_db_query("select products_master, products_master_status from " . TABLE_PRODUCTS . " where products_id = '" . $products_master['products_id'] . "'"); $master_prod_values = tep_db_fetch_array($master_prod); if (($master_prod_values['products_master_status'] == 0) && ($master_prod_values['products_master'] != 0)) { $str_selected_values = $master_prod_values['products_master']; } else { $str_selected_values = $products_master['products_id']; } Tried adapting the following, but received errors if (isset($HTTP_GET_VARS['manufacturers_id']) && tep_not_null($HTTP_GET_VARS['manufacturers_id'])) { $where_str .= " and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'"; } There is also this function in /includes/functions/general.php // Master Products function tep_get_products_master_status($product_id) { $product_query = tep_db_query("select products_master_status from " . TABLE_PRODUCTS . " where products_id = '" . (int)$product_id . "'"); $product = tep_db_fetch_array($product_query); return $product['products_master_status']; } // Master Products EOF By the way, I'm not a programmer. Thank you again. Quote Link to comment Share on other sites More sharing options...
tgely Posted October 30, 2011 Share Posted October 30, 2011 Hi, if I understand the question is that search all master products which has slave product with search key. The results contain master products or single products only. The slaves are not listing. This process need subqueries. Here is a simple sql code where searching for price in osCommerce v2.3.1 core: SELECT * FROM `products` WHERE products_master_status = '1' and products_id in(SELECT replace(replace(replace(products_master, "_ ", ""), " ", ", "), "_", "") FROM `products` WHERE products_price = '824' and products_master_status = '0') The results give only masters. At this model searching for single master products. The master products only single (_ xxxx _) and not multiply (like _ xxxx yyyy fff _) The problem is that how can search masters but there are a lot of events. Quote osCommerce based shop owner with minimal design and focused on background works. When the less is more.Email managment with tracking pixel, package managment for shipping, stock management, warehouse managment with bar code reader, parcel shops management on 3000 pickup points without local store. Link to comment Share on other sites More sharing options...
dspeak Posted October 31, 2011 Share Posted October 31, 2011 try a simple html php mixed code. <input name="Qty_ProdId_<?php echo $product_info['products_id']; ?>" type="text" size="30" maxlength="30"> its all. I assume this would be in the product_info.php file. Would you suggest I add this in addition to code that is there or replace the dropdown code with this. Sorry to be such a bother. Quote Link to comment Share on other sites More sharing options...
tgely Posted October 31, 2011 Share Posted October 31, 2011 (edited) Hi, change: echo TEXT_QUANTITY . ' ' . tep_draw_pull_down_menu('Qty_ProdId_' . $product_info['products_id'], $qty_array, MASTER_PRODUCT_DEFAULT_QUANTITY); to: echo tep_draw_input_field('Qty_ProdId_' . $product_info['products_id'], '0', 'size="4"'); look at master_listing.php case 'MASTER_LIST_BUY_NOW': $list_box_contents .= '<td' . (($slave_id == $listing['products_id']) ? ' class="slave" align="center">' : ' align="center">'); if ((STOCK_CHECK == 'true')&&(tep_get_products_stock($listing['products_id']) < 1)) { // $list_box_contents .= TEXT_STOCK; $list_box_contents .= '<small> use here go-ahead sales enhance</small>'; } elseif ((STOCK_CHECK == 'false')&&(tep_get_products_stock($listing['products_id']) < 1)) { $qty_array = array(); for ($i=0; $ns = 20, $i <= $ns; $i++) { $qty_array[] = array('id' => $i, 'text' => $i); } // $list_box_contents .= tep_draw_input_field('Qty_ProdId_' . $listing['products_id'], '0', 'size="4"'); $list_box_contents .= tep_draw_pull_down_menu('Qty_ProdId_' . $listing['products_id'], $qty_array); } else { $quantity = tep_get_products_stock($listing['products_id']); $qty_array = array(); for ($i=0; $ns = (($quantity < 20) ? $quantity : 20), $i <= $ns; $i++) { $qty_array[] = array('id' => $i, 'text' => $i); } // $list_box_contents .= tep_draw_input_field('Qty_ProdId_' . $listing['products_id'], '0', 'size="4"'); $list_box_contents .= tep_draw_pull_down_menu('Qty_ProdId_' . $listing['products_id'], $qty_array); } $list_box_contents .= '</td>'; break; where you can switch on simple input field Edited October 31, 2011 by Gergely Quote osCommerce based shop owner with minimal design and focused on background works. When the less is more.Email managment with tracking pixel, package managment for shipping, stock management, warehouse managment with bar code reader, parcel shops management on 3000 pickup points without local store. Link to comment Share on other sites More sharing options...
dspeak Posted October 31, 2011 Share Posted October 31, 2011 Thank, I must run home now, but I will give it a try this evening. I really appreciate your help. Some day I would like to buy you a beer, of coffee whichever you prefer. Quote Link to comment Share on other sites More sharing options...
dspeak Posted November 1, 2011 Share Posted November 1, 2011 Thanks Gergely, I looked at the code last night, I am using RC2. I see some similarity in the code, but just can't quite get it all figured out. I will play with it some, hopefully I can get this working soon. Quote Link to comment Share on other sites More sharing options...
dspeak Posted November 1, 2011 Share Posted November 1, 2011 I messed up, was looking at the wrong master_listing file. Quote Link to comment Share on other sites More sharing options...
Millie Posted November 15, 2011 Share Posted November 15, 2011 Is there a contribution for adding extra fields known to work with Master Products on version 2.3x? I started installing Extra Product Fields for 2.31 v1.1 and upon reaching install steps for admin/ categories.php I think it may be beyond my skill level to merge. If anyone has had success with that contribution and would share the code they ended up with I might be able to sort it out or, I'd appreciate hearing of success with any other contributions. Quote Link to comment Share on other sites More sharing options...
diro5 Posted November 20, 2011 Share Posted November 20, 2011 Hi, i get stuck. If a customer puts a slave into the shopping cart, the master is added too. I can´t find out how to stop this. If a slave is selected, only the slave should be put into the shopping cart. Has anyone a tip for me? Thanks a lot Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.