Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

jrvs

Members
  • Posts

    25
  • Joined

  • Last visited

About jrvs

  • Birthday 01/01/2007

Profile Information

  • Real Name
    Jarvis
  • Location
    Maryland

Recent Profile Visitors

6,461 profile views

jrvs's Achievements

  1. 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
  2. It's a miracle! Eternally grateful!
  3. 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.
  4. 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.
  5. 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
  6. 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.
  7. 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
  8. 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.
  9. This article may help - http://htmlfixit.com/cgi-tutes/tutorial_My...Value_Count.php
  10. 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!
  11. 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!"
  12. 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.
  13. 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
  14. 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
×
×
  • Create New...