

jacven
Members-
Content count
112 -
Joined
-
Last visited
Everything posted by jacven
-
Hello all, At the sitemap_seo_page_control.php I have some custom pages, they are not checked to be excluded, and they are not shown in the front-end What could be wrong? Thank you.
-
Hello, Can anyone please help me adding a custom field to this contribution? Quick Price Updates. I have the RSS field added to the products and would like to have this at the Quick P U Thank you.
-
Hello, thanks for this great contribution. I have successfully installed it but I would like to know how to change the aspect. It is currently setup as drop down list, I would like to have it as the category box. I went to the setup in admin where you in maximum value, but when I changed that it disappeared. Can anyone please help me? Thank you.
-
[Contrib] Manufacturers Multilanguage
jacven replied to wheeloftime's topic in General Add-Ons Support
Hello thanks for this contribution. Does anyone know what should I do if I only need to have the multilanguage for manufacturers? Thank you -
hello to all, I have seen a couple of these contribs but is there a way to enable or disable them from the admin? thanks.
-
hello thank you, can you tell me how? thanks.
-
Hello, great contribution, has anyone made work an extra field to show in invoice.php at the administrator? I have added code in this forum, but nothing happens. Thanks in advanced.
-
anyone please?
-
hello I have a store, and for some specific products I need to have two payment options, one is with CC and the other is with cash on delivery. I have installed SPPC but it is not what I am looking for. Thanks in advanced.
-
Thank you it worked like a charm.
-
Hello, is it possible? I need to specify a Bank Transfer Module for each language that I have configured in our store. Thank you.
-
Hello thank you, I will give it a try, right now.
-
Hello, I really don't know where to start to setup this, or what contribution would help me to achieve this: Scenario 1: If product is shipped to one specific country, UPS won't be an option for selection Scenario 2: If shop amount is greater than $ 2000 only UPS will be available Scenario 3: If total weight is greater than 30 pounds, UPS will show I really hope that you can guide me on this because I am totally lost. Thank you.
-
hello I need to add the product module to the front page of featured products, can anyone help me? Thanks.
-
Hello all, thanks for this great contrib, but I need to know how is it possible to add customer details, such as email address and phone number in the same order email? THanks,
-
Hello all, thanks for this great contrib, but I need to know how is it possible to add customer details, such as email address and phone number in the same order email? THanks,
-
hello all the products_listing_status tinyint(2) I change it to varchar(50) I need to find out where in the code it says to insert the data with tinyint(2) thanks
-
Thanks Bertsu for posting this question. I am also looking for someone that can build a custom gateway for my store.
-
Please help me integrating my store with local gateway provider
jacven replied to jacven's topic in Other
I deleted by mistake a PM from someone that offered some certain amount of money install this script for me. I need to catch up on that, thx. -
Hello all, I am used only to integrate with 2CO or PayPal, but recently a friend of mine needs to integrate with a local provider in my country (Venezuela) So, this provider has sent to me couple of instructions, something like this: http://www.xxx/xxx/A_merc.jsp? invoiceNumber=$valor1&totalAmount=$valor2 But where should I edit in my store this to point to the gateway? Thanks.
-
Please help me integrating my store with local gateway provider
jacven replied to jacven's topic in Other
Hello, thx for your reply, now, I have seen many modules, but is there anything in a module where I can define where the variables should go to a specifi link? Thanks. -
Hello everyone, please help me this code, I need to also do a query from Specials, It's actually working, but it's taking too long to display them. I tried with a new_products.php and it worked so here it's the new_products.php code with an extra query for specials that works for me <?php /* $Id: new_products.php,v 1.34 2003/06/09 22:49:58 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ ?> <!-- new_products //--> <?php $info_box_contents = array(); $info_box_contents[] = array('text' => sprintf(TABLE_HEADING_NEW_PRODUCTS, strftime('%B'))); new contentBoxHeading($info_box_contents); if ( (!isset($new_products_category_id)) || ($new_products_category_id == '0') ) { // get rid of the join with specials $new_products_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, p.products_price as products_price from " . TABLE_PRODUCTS . " p where products_status = '1' order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS); } else { $new_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, p.products_price as products_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . (int)$new_products_category_id . "' and p.products_status = '1' order by p.products_date_added desc limit ". MAX_DISPLAY_NEW_PRODUCTS); } if (($no_of_new_products = tep_db_num_rows($new_products_query)) > 0) { while ($_new_products = tep_db_fetch_array($new_products_query)) { $new_products[] = $_new_products; $list_of_prdct_ids[] = $_new_products['products_id']; } $select_list_of_prdct_ids = "products_id = '".$list_of_prdct_ids[0]."' "; if ($no_of_new_products > 1) { for ($n = 1; $n < count($list_of_prdct_ids); $n++) { $select_list_of_prdct_ids .= "or products_id = '".$list_of_prdct_ids[$n]."' "; } } // an extra query is now used for all the specials $specials_query = tep_db_query("select products_id, specials_new_products_price from specials where (".$select_list_of_prdct_ids.") and status = '1' "); while ($specials_array = tep_db_fetch_array($specials_query)) { $new_s_prices[] = array ('products_id' => $specials_array['products_id'], 'specials_new_products_price' => $specials_array['specials_new_products_price']); } // replace products_price with the specials_new_products_price if(!empty($new_s_prices)) { for ($x = 0; $x < $no_of_new_products; $x++) { for ($i = 0; $i < count($new_s_prices); $i++) { if( $new_products[$x]['products_id'] == $new_s_prices[$i]['products_id'] ) { $new_products[$x]['products_price'] = $new_s_prices[$i]['specials_new_products_price']; } } } } // // end if(!empty($new_s_prices) $row = 0; $col = 0; $info_box_contents = array(); // while ($new_products = tep_db_fetch_array($new_products_query)) { for ($x = 0; $x < $no_of_new_products; $x++) { $new_products[$x]['products_name'] = tep_get_products_name($new_products[$x]['products_id']); $info_box_contents[$row][$col] = array('align' => 'center', 'params' => 'class="smallText" width="33%" valign="top"', 'text' => '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products[$x]['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $new_products[$x]['products_image'], $new_products[$x]['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products[$x]['products_id']) . '">' . $new_products[$x]['products_name'] . '</a><br>' . $currencies->display_price($new_products[$x]['products_price'], tep_get_tax_rate($new_products[$x]['products_tax_class_id']))); $col ++; if ($col > 2) { $col = 0; $row ++; } } // end for ($x = 0; $x < $no_of_new_products; $x++) } // end if (($no_of_new_products = tep_db_num_rows($new_products_query)) > 0) new contentBox($info_box_contents); ?> <!-- new_products_eof //--> What I need is to have that same extra query in new_products.php I need to adapt to /includes/modules/featured.php <?php /* osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2002 osCommerce Released under the GNU General Public License Featured Products V1.1 Displays a list of featured products, selected from admin For use as an Infobox instead of the "New Products" Infobox */ ?> <!-- featured_products //--> <?php if(FEATURED_PRODUCTS_DISPLAY == 'true') { $featured_products_category_id = $new_products_category_id; $cat_name_query = tep_db_query("select categories_name from " . TABLE_CATEGORIES_DESCRIPTION . " where categories_id = '" . $featured_products_category_id . "' limit 1"); $cat_name_fetch = tep_db_fetch_array($cat_name_query); $cat_name = $cat_name_fetch['categories_name']; $info_box_contents = array(); if ( (!isset($featured_products_category_id)) || ($featured_products_category_id == '0') ) { $info_box_contents[] = array('align' => 'left', 'text' => '<a class="headerNavigation" href="' . tep_href_link(FILENAME_FEATURED_PRODUCTS) . '">' . TABLE_HEADING_FEATURED_PRODUCTS . '</a>'); list($usec, $sec) = explode(' ', microtime()); srand( (float) $sec + ((float) $usec * 100000) ); $mtm= rand(); $featured_products_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price, p.products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id left join " . TABLE_FEATURED . " f on p.products_id = f.products_id where p.products_status = '1' and f.status = '1' order by rand($mtm) DESC limit " . MAX_DISPLAY_FEATURED_PRODUCTS); } else { $info_box_contents[] = array('align' => 'left', 'text' => sprintf(TABLE_HEADING_FEATURED_PRODUCTS_CATEGORY, $cat_name)); $subcategories_array = array(); tep_get_subcategories($subcategories_array, $featured_products_category_id); $featured_products_category_id_list = tep_array_values_to_string($subcategories_array); if ($featured_products_category_id_list == '') { $featured_products_category_id_list .= $featured_products_category_id; } else { $featured_products_category_id_list .= ',' . $featured_products_category_id; } $featured_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price, p.products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c using(products_id) left join " . TABLE_CATEGORIES . " c using(categories_id) left join " . TABLE_FEATURED . " f on p.products_id = f.products_id left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where c.parent_id = '" . $featured_products_category_id . "' and p.products_status = '1' and f.status = '1' order by rand() DESC limit " . MAX_DISPLAY_FEATURED_PRODUCTS); } $row = 0; $col = 0; $num = 0; while ($featured_products = tep_db_fetch_array($featured_products_query)) { $num ++; if ($num == 1) { new contentBoxHeading($info_box_contents); } $featured_products['products_name'] = tep_get_products_name($featured_products['products_id']); if($featured_products['specstat']) { $info_box_contents[$row][$col] = array('align' => 'center', 'params' => 'class="smallText" width="33%" valign="top"', 'text' => '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $featured_products['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $featured_products['products_image'], $featured_products['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $featured_products['products_id']) . '">' . $featured_products['products_name'] . '</a><br><s>' . $currencies->display_price($featured_products['products_price'], tep_get_tax_rate($featured_products['products_tax_class_id'])) . '</s><br><span class="productSpecialPrice">' . $currencies->display_price($featured_products['specials_new_products_price'], tep_get_tax_rate($featured_products['products_tax_class_id'])) . '</span>'); } else { $info_box_contents[$row][$col] = array('align' => 'center', 'params' => 'class="smallText" width="33%" valign="top"', 'text' => '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $featured_products['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $featured_products['products_image'], $featured_products['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $featured_products['products_id']) . '">' . $featured_products['products_name'] . '</a><br>' . $currencies->display_price($featured_products['products_price'], tep_get_tax_rate($featured_products['products_tax_class_id']))); } $col ++; if ($col > 2) { $col = 0; $row ++; } } if($num) { new contentBox($info_box_contents); } } else // If it's disabled, then include the original New Products box { // include (DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); // disable for dont show if desactive the feature module include (DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); } if ($num == 0) { include (DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); } ?> <!-- featured_products_eof //-->
-
Please I need help with this version "Easy Populate 2.8-MS2" I am trying to populate my SPECIALS. I was able to import all my 4k records with no problems, when I try populate also 4k SPECIAL prices it only imports 20 or 30% of them, no error message is displayed but I dont understand why it is not populating all of them. Does anyone knows something about this? Best regards, JC
-
Hi, I have installed two contributions to my store. 1. Photo Gallery 1.0 http://www.oscommerce.com/community/contri.../search,gallery 2. Ultimate SEO URLs http://www.oscommerce.com/community/contri...ch,ultimate+seo Right before installing 2nd one photo galleries were working great but now after activating 2nd contr it is not working. If I click on a product where it says "Click to view photo gallery" it opens up the popup page with the 1rst pic My URL would be something like this http://mysite.com/catalog/seo-url-bla-bla-bla.html there I have this menu 1 2 3 4 5 6 7 8 9 | Next > When I click on number 2, img does not show up and get this url http://mysite.com/catalog/popup_image.php?...popup_image.php Can anyone help me out with this? Really appreciate it. Thanks
-
hi, i'm new at oscommerce, installed, configured, and it's now running. I downloaded easy populate latest version. downloaded from admin, "Complete tab-delimited .txt file to edit" checked in excel, but i would like to delete some information, and put the data I want, i tried just cleaning to cells, uploaded but doesn't work. any help? thanks