LeeFoster Posted March 23, 2017 Share Posted March 23, 2017 Hi, I am looking for an addon that will allow me to create parent and child products and allow stock levels to be set against them. An example of this is below Parent product is HTISP01 Child Product 1 is HTISP01-425-87-P92 Child Product 2 is HTISP01-450-87-P92 Child Product 3 is HTISP01-450-110-P92 Parent product will always show as long as there is one child product in stock. Child product will be selected via radio button. Does anyone know of addon that does this? Thanks Child Product 1 is HTISP01-425-87-P92 Quote Link to comment Share on other sites More sharing options...
ArtcoInc Posted March 23, 2017 Share Posted March 23, 2017 @@LeeFoster Are you looking to have a bundle, or an attribute? A bundle might consist of two or more products, bundled together as a single part number. An attribute might consist of a single product, but available in different sizes and/or colors. Malcolm Quote Link to comment Share on other sites More sharing options...
LeeFoster Posted March 23, 2017 Author Share Posted March 23, 2017 @@ArtcoInc It's a little more complicated than that. The parent product is based on the design on the product, it then has various options - weight, flex, curve - I want to be able to track stock based on all attributes. Weights might be 425, 450, 475 Flex might be 87, 105, 110 Curve might be p92, p88, p106 So something might be available in 425-105-P92 but not 425-87-P92 So something might be available in a certain weight and curve but not in a flex. Quote Link to comment Share on other sites More sharing options...
ArtcoInc Posted March 23, 2017 Share Posted March 23, 2017 @@LeeFoster So, these are attributes. Just like a T-shirt might be available in different sizes and colors, but not all sizes may be available in all colors. Right? Malcolm Quote Link to comment Share on other sites More sharing options...
LeeFoster Posted March 23, 2017 Author Share Posted March 23, 2017 Technically yes but I need to be able to offer stock control on all attributes base on the one above it. Quote Link to comment Share on other sites More sharing options...
♥14steve14 Posted March 24, 2017 Share Posted March 24, 2017 The addon QTPro allows stock control on attributes, and there are others in the addon area, but whether they will do exactly as you require you will have to find out. There are also some master products addons that allow one product to be sold with other items to make a package of parts, but whether they can control stock I have no idea. Quote REMEMBER BACKUP, BACKUP AND BACKUP Link to comment Share on other sites More sharing options...
LeeFoster Posted March 24, 2017 Author Share Posted March 24, 2017 I have QTpro installed and it does allow stock control on attributes but it doesn't do it in the way that I need. I have downloaded the master products addon to try but not installed it yet. Quote Link to comment Share on other sites More sharing options...
greasemonkey Posted March 25, 2017 Share Posted March 25, 2017 @@LeeFoster presuming you are using the bootstrap community version... have you tried master/slave http://www.oscommerce.com/forums/topic/407753-master-products-lite-for-osc-234-bs-gold/ I have the same issue wit qtpro and was looking to test this in the near future Quote Link to comment Share on other sites More sharing options...
LeeFoster Posted March 25, 2017 Author Share Posted March 25, 2017 @@greasemonkey I've tried to install that addon but I'm not able to because I have the modular product page installed. Quote Link to comment Share on other sites More sharing options...
greasemonkey Posted March 25, 2017 Share Posted March 25, 2017 @@LeeFoster I haven't look at this in detail... but should be easy enough to move whatever content is edited in product_info to a content module. Quote Link to comment Share on other sites More sharing options...
LeeFoster Posted March 26, 2017 Author Share Posted March 26, 2017 This is the section of changes I am not able to do, if anyone is more familiar with it. --------------------------------------------------------------------------- 20.) - catalog/product_info.php --------------------------------------------------------------------------- FIND: require(DIR_WS_INCLUDES . 'template_top.php'); ADD RIGHT AFTER IT: // Master Products $master_status_query = tep_db_query("select products_id, products_master_status, products_master from " . TABLE_PRODUCTS . " where products_status = '1' and products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "'"); $master_check = tep_db_fetch_array($master_status_query); if ($master_check['products_master_status'] > 0 || $master_check['products_master'] == 0) { // this modify!! echo tep_draw_form('buy_now_', tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action')) . 'action=add_slave', 'NONSSL')); } else { echo tep_draw_form('cart_quantity', tep_href_link(FILENAME_PRODUCT_INFO, tep_get_all_get_params(array('action')) . 'action=add_product')); } // Master Products EOF FIND: $product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); REPLACE WITH: //Master Products // $product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); $product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_master_status, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); //Master Products EOF FIND: <?php echo tep_draw_form('cart_quantity', tep_href_link(FILENAME_PRODUCT_INFO, tep_get_all_get_params(array('action')). 'action=add_product', 'NONSSL'), 'post', 'class="form-horizontal" role="form"'); ?> REPLACE WITH: <?php //echo tep_draw_form('cart_quantity', tep_href_link(FILENAME_PRODUCT_INFO, tep_get_all_get_params(array('action')). 'action=add_product', 'NONSSL'), 'post', 'class="form-horizontal" role="form"'); ?> 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.