Jump to content

VJ

Members
  • Content count

    170
  • Joined

  • Last visited

Everything posted by VJ

  1. Find the following line in /catalog/product_info.php, $products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pa.options_id = '" . (int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)$languages_id . "'"); and replace it with something similar to, $products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pa.options_id = '" . (int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)$languages_id . "' order by pa.price_prefix, pa.options_values_price, pov.products_options_values_name"); depending on how exactly you'd like to order your atttibute choices. HTH, VJ
  2. VJ

    LINK STATUS PROBLEM

    Hello, If you don't find any link status text in the dropdown choices, you probably use a different default language (other than English). To fix this, update your database using the following sql: INSERT INTO links_status VALUES ( '1', 'N', 'Pending'); INSERT INTO links_status VALUES ( '2', 'N', 'Approved'); INSERT INTO links_status VALUES ( '3', 'N', 'Disabled'); where, N = your default language ID. If you intend to use more than one language in your store admin, repeat this for each language ID. HTH, VJ
  3. Oops! :o You probably use a pre-MS2 osC version. This script is developed for MS2, but there's no reason why you can't get it working in MS1 (with a few alterations). You can find hints in previous threads (in this post) from folks who've managed to get it done. Good luck :). VJ
  4. You probably have a problem with your default language id. Check if it shows the right value. VJ
  5. Actually, there is no seperate sql file. The sql information gets updated when you run the /catalog/links_setup.php script. HTH, VJ
  6. Well, the idea is to look for the missing functions in the newer osc MS2 version, and copy them over to your MS1 setup. Just give it a shot :). VJ
  7. Hello, Try copying the file /catalog/includes/functions/validations.php to /admin/includes/functions/ directory, and include the following line somewhere in your /admin/includes/application_top.php: // Include validation functions (right now only email address) require(DIR_WS_FUNCTIONS . 'validations.php'); HTH, VJ
  8. Hello, I'm afraid you have added the links code a couple of lines off-target. Here's the step where you've erred. ------------------------------------ /catalog/redirect.php ------------------------------------ after this, (around line 30) case 'manufacturer': if (isset($HTTP_GET_VARS['manufacturers_id']) && tep_not_null($HTTP_GET_VARS['manufacturers_id'])) { $manufacturer_query = tep_db_query("select manufacturers_url from " . TABLE_MANUFACTURERS_INFO . " where manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' and languages_id = '" . (int)$languages_id . "'"); if (tep_db_num_rows($manufacturer_query)) { // url exists in selected language $manufacturer = tep_db_fetch_array($manufacturer_query); if (tep_not_null($manufacturer['manufacturers_url'])) { tep_db_query("update " . TABLE_MANUFACTURERS_INFO . " set url_clicked = url_clicked+1, date_last_click = now() where manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' and languages_id = '" . (int)$languages_id . "'"); tep_redirect($manufacturer['manufacturers_url']); } } else { // no url exists for the selected language, lets use the default language then $manufacturer_query = tep_db_query("select mi.languages_id, mi.manufacturers_url from " . TABLE_MANUFACTURERS_INFO . " mi, " . TABLE_LANGUAGES . " l where mi.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' and mi.languages_id = l.languages_id and l.code = '" . DEFAULT_LANGUAGE . "'"); if (tep_db_num_rows($manufacturer_query)) { $manufacturer = tep_db_fetch_array($manufacturer_query); if (tep_not_null($manufacturer['manufacturers_url'])) { tep_db_query("update " . TABLE_MANUFACTURERS_INFO . " set url_clicked = url_clicked+1, date_last_click = now() where manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' and languages_id = '" . (int)$manufacturer['languages_id'] . "'"); tep_redirect($manufacturer['manufacturers_url']); } } } } break; add, // VJ Links Manager v1.00 begin case 'links': require(DIR_WS_FUNCTIONS . 'links.php'); $links_query = tep_db_query("select links_url from " . TABLE_LINKS . " where links_id = '" . (int)$HTTP_GET_VARS['goto'] . "'"); if (tep_db_num_rows($links_query)) { $link = tep_db_fetch_array($links_query); tep_update_links_click_count($HTTP_GET_VARS['goto']); tep_redirect($link['links_url']); } break; // VJ Links Manager v1.00 end HTH, VJ
  9. Hello, You have probably failed to update your /catalog/admin/includes/database_tables.php file. Add this to the end, // VJ Links Manager v1.00 begin define('TABLE_LINK_CATEGORIES', 'link_categories'); define('TABLE_LINK_CATEGORIES_DESCRIPTION', 'link_categories_description'); define('TABLE_LINKS', 'links'); define('TABLE_LINKS_DESCRIPTION', 'links_description'); define('TABLE_LINKS_TO_LINK_CATEGORIES', 'links_to_link_categories'); define('TABLE_LINKS_STATUS', 'links_status'); // VJ Links Manager v1.00 end HTH, VJ
  10. Please refer to my posts (in this same thread) on Nov. 21, 23 for clues. HTH, VJ
  11. This is actually what makes the difference! The file /admin/includes/classes/upload.php (that contains the class - upload) exists in MS2, but not MS1. I think you can get around this error, by copying this file (upload.php) from an MS2 package, to your MS1 setup. You'll also have to "include" (or "require") this file. You can do this by adding the following line in admin/links_categories.php: require(DIR_WS_CLASSES . 'upload.php'); HTH, VJ
  12. VJ

    Using Ezpopulate with Excel csv

    I'm sure there's an option to export an Excel csv file as tab-delimited. Or, you could try to alter the following code in admin/easypopulate.php (to use a comma), and give it a shot. // **** Field Separator **** // change this if you can't use the default of tabs // Tab is the default, comma and semicolon are commonly supported by various progs // Remember, if your descriptions contain this character, you will confuse EP! global $separator; $separator = "\t"; // tab is default //$separator = ","; // comma //$separator = ";"; // semi-colon //$separator = "~"; // tilde //$separator = "-"; // dash //$separator = "*"; // splat HTH, VJ
  13. I've managed to get this mod to function, in my MS1 setup, by making a simple change. Just comment out this line in admin/easypopulate.php. require(includes/database_tables.php); I haven't tested this extensively, but it should be worth giving a try :). As for header tags, this new EP version retains the ability to handle data for Linda's Header Tag Controller, from previous versions. You just have to follow the manual and make some minor changes. HTH, VJ
  14. I just looked at the 1readmeFIRST.txt, and this is what I found: 3. For adding link to the Admin, edit file admin/includes/boxes/catalog.php by adding this line: '<a href="' . tep_href_link('easypopulate.php', '', 'NONSSL') . '" class="menuBoxContentLink">Easy Populate</a><br>'. After: '<a href="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_CATALOG_CATEGORIES_PRODUCTS_ATTRIBUTES . '</a><br>' . By the way, which version of EP do you use? HTH, VJ
  15. This program is now available for download, as a contribution, here. Support for this program will continue in this thread. VJ
  16. VJ

    Master Products - MS2

    Thank you. I'll give it a try again. VJ
  17. VJ

    Master Products - MS2

    I'm afraid I get the exact same error too. I tried this on a MS2 setup. VJ
  18. I've been getting feedback from folks who have a lot of product attributes, that leads to the tab-delim file exceeding 256 columns (which is the max. column limit for most worksheet programs). I've now added an option to download only selected product attribute options. For example, if you have the options - Colour, Size, Model, you'll now be able to select any particular option(s) to download (say, Colour and Model). Look out for this configuration directive line, in easypopulate.php and make necessary changes: global $attribute_options_select; //$attribute_options_select = array('Size', 'Model'); You can download the latest easypopulate.php, here. Keep your feedback coming, and thanks to all folks who've offered ideas/feedback :-). VJ
  19. Well, it turned out to be quite easy, in the end. Just comment out this line in easypopulate.php, and it works just fine in MS1 :). require(includes/database_tables.php); // comment this line VJ
  20. Hello Don, 1. This is not really a limitation of this code, but you could try my latest code update, which has this option to handle just the product models and attributes. That would probably save a few columns. If you still have excess columns, you could try to hack the code to make it handle 1 language or 1 attrib set, at a time (just a thought!). 2. Well, attributes are not actually assigned to every single product. Attributes are assigned to a product, only if the corresponding value price cell contains a "non-empty" value. Otherwise, the attribute options/values are listed beside each product, but are not assigned to them. If you think your tab-delimited file is messed up in any way, you could email it to me (just make sure you zip or tgz it... I'm on a slow dial-up :(). HTH, VJ
  21. Yes, I'm working towards acheiving something similar... download products from MS1, and upload to MS2. I'll post my progress on this thread.... stay tuned! VJ
  22. I've now added an option to download and handle just the product model/attributes. You can download the updated easypopulate.php file, here. The code is almost out of beta stage now, and should be ready to be added in the contribs section, in a few days (just needs a bit more cleaning up and testing). Thanks for all your feedback and comments :). VJ
  23. Yes. Here's a simple example. These are the fields you would require, to add an option (Size), with 2 values (Small, Medium). 1. v_attribute_options_id_1 -> this field contains the attribute option id (make sure you don't use an id that already exists in the database) where, "1" is a count, which starts from 1 and increments by 1. 2. v_attribute_options_name_1_1 -> contains the option name (eg: Size) where, the first "1" is the corresponding options count (you would use v_attribute_options_name_2_1, for v_attribute_options_id_2) and, the second "1" is the language id 3. v_attribute_values_id_1_1 -> contains attribute option value id (again make sure you don't use an existing id) where, first "1" is the option id, this value is linked with and, second "1" is a count (starting from 1, and incrementing by 1) 4. v_attribute_values_price_1_1 -> contains price difference for option value with suffix 1_1 (this is a signed value, you may use '-' or '+' before the price value) 5. v_attribute_values_name_1_1_1 -> contains attrib option value name (eg: Small) where, first and second 1's are the corresponding option value suffixes and, third "1" is the language id So, basically this is how your table would look: v_attribute_options_id_1 => 1 v_attribute_options_name_1_1 => Size (assuming "1" is the language id for English, in your store) v_attribute_values_id_1_1 => 1 v_attribute_values_price_1_1 => -20.00 v_attribute_values_name_1_1_1 => Small v_attribute_values_id_1_2 => 2 v_attribute_values_price_1_2 => 0.00 v_attribute_values_name_1_2_1 => Medium (again, assuming "1" for English) HTH, VJ
  24. I haven't worked on a diff file for the changes, as of yet. You can try this, though.... 1. Download my easypopulate.php, here. 2. You can identify my code additions - they're all within these tags "// VJ product attribs begin" and "// VJ product attribs end" (there should be 3 sets of them). 3. Now, paste them exactly in their corresponding positions, in your already modified easypopulate.php file. Please make sure if I have replaced any existing code. And in any case, BACKUP your existing file. HTH, VJ
×