jrvs

Well... I have what it seems a 100 yr old problem with advanced_search_results.php - posted the following - 2011: $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 http://scientiis.com/biotech/catalog/index.php $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. Celia Jarvis

It's a miracle! Eternally grateful!

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.

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.

Hi: Easypopulate.php // for the separate prices per customer module $ll=1; if (isset($v_customer_price_1)){ if (($v_customer_group_id_1 == '') AND ($v_customer_price_1 != '')) { echo "<font color=red>ERROR - v_customer_group_id and v_customer_price must occur in pairs</font>"; die(); } golfpros - Aug 8 2003, 10:00 PM Post #30 Michael Gilliam http://www.oscommerce.com/forums/index.php?sho...32993&st=20 … So I replaced the isset function (which seems to be saying I have data in the $v_customer_price_1 field ) with the following inequality: if ($v_customer_price_1 !=''){ Try: if (($v_customer_group_id_1 != '') AND ($v_customer_price_1 != '')) { Check your sql fields to match - I would also check the SPPC contribution

Hi JR: I would read again the "Easypopulate Manual" – at some point the (very mean) person advises: It doesn't work! First, look for really obvious problems with your file. 1. Did you download a file via EasyPopulate first? If not, do that now. 2. Compare the file you're trying to upload to the file you downloaded. Look for missing fields. Ignore the quotes, EP won't care about missing quotes. Open it in a text editor instead of excel. (Jrvs = I copy all from the text file and then I paste it in Excel – is easier to read). Look for odd characters that shouldn't be there. Second, simplify 1. Try uploading the file you just downloaded. If this doesn't work, you've got basic problems, hit the forum and describe your errors. Please search for your error message first, if there is no fix, then post a very specific problem report. (Jrvs = right…. like someone is gonna answer!). Don't just tell me "It's broken", or I'm likely to say, "Well, fix it!" 8-) 2. If you can upload the unmodified downloaded file, then try adding just one product to it, and upload that. Keep it simple, no fancy stuff in the descriptions or anything. ------------------ "column count does not match' usually means the number of fields and the number of values are different. " Check mysql and see if all the fields match exactly those of your EP spreadsheet This is what I did to upload 15K products – Master/Slaves. I used EP v2.76c – because I prefer not to touch the configure.php DIR_FS_DOCUMENT_ROOT . $tempdir . Then I customized EP v.276c according to my needs. Do a test file and populate it with 2 or 3 products Save your Excel file as .txt (e.g. Eptesting-1.txt) Upload the text file using FTP to your /temp directory – (the "Upload EP File" option didn’t work well for me, but the "Split EP File" worked great. In admin/catalog/easypopulate Click on Import from Temp Dir (temp/) and type the name of the txt file (e.g. Eptesting-1.txt) How many prods do you have? Don't forget to back up your files. Best of luck.

The problem may be that you have white spaces in the fields = v_attribute_options_id_1 1 replace space with "_" v_attribute_options_id_1_1

INSERT INTO products_groups VALUES ( 0, 0.0000, 40 ) You have v_customer_price_1 0.000 There is probably a formula that calls for > 0 Change v_customer_price_1 for a value of 1 or above and see what happens.

This article may help - http://htmlfixit.com/cgi-tutes/tutorial_My...Value_Count.php

Install - http://www.oscommerce.com/community/contributions,500 I used = choosealogin 17 May 2006 DOCUMENTATION -------------- Detailed manuals can be found here: 1. /docs/1readmeFIRST.txt (includes "quick" installation and configuration notes) 2. /docs/Easypopulate_Manual.* (complete manual in various formats) Please do read the manuals carefully. Its worth the time!

Quote from jbrolin: "……The next and biggest problem I had lies in the server I use had "Register globals off" which caused form post and other variables to come back empty…." http://www.oscommerce.com/forums/index.php?sho...ot+easypopulate I personally used EP_v2_76c_MS2 = choosealogin 17 May 2006 because – "…There is mass confusion below. Some versions have mods for other contributions hardcoded in and it's not clear to a new user which version will be appropriate for their needs. Please consider before choosing a version of EP if you have particular needs for extra fields and functions, and read the descriptions of each EP contribution to pick one that will work for YOU…." Customize products_id fields to your extra_product_model = - Reliablesol - http://www.oscommerce.com/forums/lofiversion/i...t67284-950.html I used for the products_description - contribution http://www.oscommerce.com/community/contributions,1717 by Toby Catlin 19 Oct 2004 "… This file tells you how to add a custom extra field to the products description table rather than the products table. It is slightly more complicated as it must deal with multi languages…." Hope it helps…. "Easy Populate – not so easy!"

In Word select the product_description column Find and Replace: Find ^p (for paragraph) and Replace with <br> Copy and paste the column in Excel.

You could add additional fields – there are at least two contributions that I know: http://www.oscommerce.com/community/contributions,1717 and http://www.oscommerce.com/community/contributions,1310

I used "New Fields with Easy Populate" Toby Catlin 19 Oct 2004 - http://www.oscommerce.com/community/contributions,1717 You can also try http://www.oscommerce.com/community/contributions,1717

re: Easypopulate 2.76d Multilanguage categories_name The multilanguage modifications are set to go. :rolleyes: Downloads perfectly the existing db, 4 categories, 2 languages: categories_name_1_1 categories_name_x_y (where x = cat level, and y = language id) | v_products_model | v_products_id | v_products_image | v_products_name_1 | v_products_description_1 | v_products_url_1 | v_products_name_3 | v_products_description_3 | v_products_url_3 | v_products_price | v_products_weight | v_date_avail | v_date_added | v_products_quantity | v_products_master | v_products_master_status | v_products_listing_status | v_manufacturers_name | v_categories_name_1_1 | v_categories_name_2_1 | v_categories_name_3_1 | v_categories_name_1_3 | v_categories_name_2_3 | v_categories_name_3_3 | v_tax_class_title | v_status | EOREOR | E-3115-25- | 348 | Biochem/E-3115-25.jpeg | GenePure HiRes Agarose | GenePure HiRes Agarose is specifically | | GenePure HiRes - Agarosa de Alta Resolución | GenePure HiRes Agarose is specifically | | 0 | | | | 1 | 0 | 1 | 1 | GenePure | Laboratory | Electrophoresis & Blotting | Agarose | Laboratorio | Electrophoresis y Transferencia | Agarosa | --none-- | Active | EOREOR Now, uploading is another saga………… :( - Categories do not appear in Admin/Catalog - Products appear in phpmysql - Good - Products_info page displays the right product in 2 languages (Master Products not working though – maybe because of the product_to_category malfunctioning - I guess) - Not getting errors while uploading: ------------------------------------------- Easy Populate 2.76d-MS2 - Default Language : English(1) File uploaded. Temporary filename: /tmp/phpgWaqDS User filename: EP2007Jun15-short-4.txt Size: 3267 | E-3115-25- | | Biochem/E- | GenePure H | GenePure H | | GenePure H | GenePure H | | 0 | | 6/8/2007 | 6/8/2007 | | 0 | 1 | 1 | GenePure | Laboratory | Electropho | Agarose | Laboratori | Electropho | Agarosa | --none-- | Active Updated | E-3115-25 | | Biochem/pi | GenePure H | 25g | | GenePure A | 25g | | 125 | | 6/8/2007 | 6/8/2007 | | 314 | 0 | 0 | GenePure | Laboratory | Electropho | Agarose | Laboratori | Electropho | Agarosa | --none-- | Active Updated | E-3115-125 | | Biochem/pi | GenePure H | 125g | | GenePure A | 125g | | 350 | | 6/8/2007 | 6/8/2007 | | 314 | 0 | 0 | GenePure | Laboratory | Electropho | Agarose | Laboratori | Electropho | Agarosa | --none-- | Active Updated | E-3115-500 | | Biochem/pi | GenePure H | 500g | | GenePure A | 500g | | 1105 | | 6/8/2007 | 6/8/2007 | | 314 | 0 | 0 | GenePure | Laboratory | Electropho | Agarose | Laboratori | Electropho | Agarosa | --none-- | Active Updated | | | | | | | | | | | | | | | | | | | | | | | | | | No products_model field in record. This line was not imported ------------------------------------------- What is the $sql_filter; at the end of this code: ".TABLE_PRODUCTS_TO_CATEGORIES." as ptoc WHERE p.products_id = ptoc.products_id AND ptoc.categories_id = subc.categories_id " . $sql_filter; Your comments would be greatly appreciated.

Surfalot.... I hear you are the Man! The problem with multilanguage categories_name has been ignored for many years. I have searched exhaustively every oscommerce forum. An easypopulate contribution to insert multiple languages for the categories_name is absolutely vital for any international (multilanguage) site. Now, the code for the categories_name is already set. All that is needed is to include the code for the language id where appropriate. VJ’s nomenclature for attributes would be ideal: v_attribute_options_name_x_y (where x = options count, and y = language id) ......... categories_name_x_y Probably simple for those who know! I have 15K (masters/slaves) products to upload, 4 levels of categories, 2 languages. Please, do your magic.........

I have searched exhaustively every oscommerce forum - including CRE. An easypopulate contribution to insert multiple languages for the categories_name is absolutely vital for any international (multilanguage) site. Now, the code for the categories_name is already set. All that is needed is to include the code for the language id where appropriate. VJ’s nomenclature for attributes would be ideal: v_attribute_options_name_x_y (where x = options count, and y = language id) ......... categories_name_x_y I have 15K (masters and slaves) products to upload, 4 levels of categories, 2 languages. Unfortunately, I'm not a programmer.

Need urgent help with this statement - Im getting a parse error - <td class="pageHeading" align="center" valign="top"><?php if ($product_info['products_price'] > 0) { echo $products_price : TEXT_BUTTON_CONTACT_US; } else { ($product_master['products_price'] > 0) echo $products_price : ''; } ?></td> Many thanks.

The popup window will not work for multiple languages. How can I get this to work? Thanks.

I used - Removing buy button on some items http://www.oscommerce.com/forums/lofiversion/i...php/t72191.html Made some changes to resolve add to cart button in the reviews and new product files and multiple languages. Let me know if still interested.