Psytanium

i already started sppc. its easy but it need a new documentation. i prefer it because it could be compatible with "quick update" addon and "specials by category" addon.

hello, any answer what to use on osc 2.3.4 ?

I have osc 2.3.4 , what sppc whould i use ? i can find 2.3.3.4 or 2.3.4 BS

@@raiwa do you know another addon that add similar products automatically, defined by some approaches like same category or similar price ?

Hello, can I know how this addon works ? I know it show other related products on a product info page. But does it do this automatically or I should relate the products to each others manually ?

Hello, I have the addon Wish List revision 4 for osCommerce 2.3 installed on my osc2.3.4 But when I click the Add to wishlist button in my product_info page, it redirect me the wishlist page without adding the product to the list. Any idea what could it be ? Thank you

does this plugin support Arabic titles for products ?

Hello, I have this addon installed on osc 2.3.4, I added a product that have arabic title in this category http://www.macrotronics.net/index.php/books-arabic-c-211_443_446 The product URL is broken, but when I turn off the SEO url 5 module, the product URL works fine. Any suggestions ? Current options: Enable SEO URLs 5? true Enable the cache? true Enable multi language support? true Output W3C valid URLs? true Info Select your chosen cache system? file Set the number of days to store the cache. 7 Choose the uri format standard Info Choose how your product link text is made up p Filter Short Words 1 Info Add category parent to beginning of category uris? true Remove all non-alphanumeric characters? true Add cPath to product URLs? false Info Enter special character conversions. (Better to use the file based character conversions) Turn performance reporting on true/false. false Turn variable reporting on true/false. false Force www.mysite.com/ when www.mysite.com/index.php true

Hello, I'm looking for an addon to add multi vendors, each vendor have his own access, catalog, reports, etc.. goes this addon help ? or it is just for multiple shipping ? demo links broken.

what version can use to my osc 2.3.4 ? SPPC 2.3.4 BS GOLD ? or v2_3_3_4_revised ?

probably i found a problem in the file admin/customers_group.php , you must replace $contents[] = array('align' => 'center', 'text' => tep_draw_button(IMAGE_EDIT, 'document', tep_href_link(FILENAME_CUSTOMERS_GROUPS, tep_get_all_get_params(array('cID', 'action')) . 'cID=' . $cInfo->categories_group_id . '&action=edit')) . tep_draw_button(IMAGE_DELETE, 'trash', tep_href_link(FILENAME_CUSTOMERS_GROUPS, tep_get_all_get_params(array('cID', 'action')) . 'cID=' . $cInfo->categories_group_id . '&action=confirm'))); with: $contents[] = array('align' => 'center', 'text' => tep_draw_button(IMAGE_EDIT, 'document', tep_href_link(FILENAME_CUSTOMERS_GROUPS, tep_get_all_get_params(array('cID', 'action')) . 'cID=' . $cInfo->customers_group_id . '&action=edit')) . tep_draw_button(IMAGE_DELETE, 'trash', tep_href_link(FILENAME_CUSTOMERS_GROUPS, tep_get_all_get_params(array('cID', 'action')) . 'cID=' . $cInfo->customers_group_id . '&action=confirm'))); or else i'm not able to delete a customer group. let me know if i'm going wrong. thx

@@kymation if i add it as a value it will appear in the front end filter, then i will have: Show All None value1 value2... now i can exclude a product from the filter. what do you think ?

I modified the files admin/includes/modules/products_specifications_input.php I added under if ($values_data['specification_value'] != '') { this line $values_select_array[0] = array('id' => '0', 'text' => 'None'); Seems working fine. Now by default, I have 'None' as a first option in the backend, without any changes in the front end. But i need the author advice, I'm afraid this will lead to some problems. Do you think this is safe ?

i solved my previous problems, i was trying to combine this addon with product specifications, friendly currency and quick price update... in case someone have problems with this combination.

installed and working fine, except 1 thing, how can i turn off the price (other than retail) ? if i empty the text field content of price, the product price become zero. it should display the price of retail instead. I'm using quick price update for 2.3.3.2 and thank you @@greasemonkey for all the good work for this community.

I managed to make this addon work allover my website, but i'm helpless with 1 file (whats new slider). I really appreciate some help here. <?php $products_newproducts_query = tep_db_query("select distinct pd.products_id, pd.products_name, pd.products_description, p.products_date_added, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_available, p.fr_currencies_id from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by p.products_date_added DESC, pd.products_name limit ".MAX_RANDOM_SELECT_NEW.""); if (tep_db_num_rows($products_newproducts_query) > 0) { ?> <div class="container main_product_slider slider_newproducts"> <h2><?php echo MENU_TEXT_NEW_PRODUCTS; ?></h2> <div class="carousel es-carousel-wrapper style0"> <div class="es-carousel"> <div class="row"> <div class="product_outer"> <!-- products output cycle --> <?php while ($newproducts = tep_db_fetch_array($products_newproducts_query)) { $newproducts['specials_new_products_price'] = tep_get_products_special_price($newproducts['products_id']); if (tep_not_null($newproducts['specials_new_products_price'])) { $newproducts_price = '<span class="old">' . $currencies->display_price($newproducts['products_price'], tep_get_tax_rate($newproducts['products_tax_class_id']), $newproducts['fr_currencies_id']) . '</span><span class="new">' .$currencies->display_price($newproducts['specials_new_products_price'], tep_get_tax_rate($newproducts['products_tax_class_id']), $newproducts['fr_currencies_id']).'</span>'; $sticker_sale = STICKER_SALE; } else { $newproducts_price = $currencies->display_price($newproducts['products_price'], tep_get_tax_rate($newproducts['products_tax_class_id']), $newproducts['fr_currencies_id']); $sticker_sale = ''; } $newproducts_price = '<div class="product-price">'.$newproducts_price.'</div>'; $realpath = DIR_FS_CATALOG.'/images/'. $newproducts['products_image']; /* if product has options */ $current_product = $newproducts['products_id']; $products_attributes_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$current_product . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "'"); $products_attributes = tep_db_fetch_array($products_attributes_query); if ($products_attributes['total'] > 0) { $sticker_options = STICKER_OPTION; } else { $sticker_options = ''; } $rating = rating_output($current_product); /* if product has options */ /* if product has big img */ $products_new_added_big_img_query = tep_db_query("select distinct pi.image, pi.products_id from " . TABLE_PRODUCTS_IMAGES . " pi where pi.products_id = '$current_product' order by pi.id ASC "); /* if product has big img */ $product_date = $newproducts['products_date_available']; if (tep_not_null($product_date) && $product_date >= DAYS_QTY) { $sticker_new = STICKER_NEW; } else { $sticker_new = ''; } ?> <!-- original product view --> <div class="span3 product"> <div class="product-image-wrapper"> <!-- stickers --> <?php echo $sticker_sale.$sticker_options.$sticker_new; ?> <!-- stickers --> <a href="<?php echo tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $newproducts["products_id"]) ;?>"> <?php if(file_exists($realpath)) { echo tep_image(DIR_WS_IMAGES . $newproducts['products_image'], $newproducts['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT); } else { ?> <img src="<?php echo DC_IMAGES.'empty.gif'; ?>" alt=""> <?php } ?> </a> </div> <div class="wrapper-hover"> <div class="product-name"> <a href="<?php echo tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $newproducts["products_id"]) ;?>"> <?php echo trimmed_text($newproducts['products_name'] , 50) ?> </a> </div> <div class="wrapper"> <?php echo $newproducts_price; ?> <div class="product-tocart"> <a href="<?php echo tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $newproducts['products_id']) ?>"><i class="icon-basket"></i></a> </div> </div> </div> </div> <!-- original product view --> <!-- rollover product view --> <div class="preview hidden-tablet hidden-phone"> <div class="wrapper"> <!-- product has some previews --> <?php if (ROLLOVER_EFFECT !== 'simple') { if (tep_db_num_rows($products_new_added_big_img_query) > 1) { ?> <div class="col-1"> <!-- previews output --> <!-- stickers --> <?php echo $sticker_sale.$sticker_options.$sticker_new; ?> <!-- stickers --> <?php while ($products_new_added_big_img = tep_db_fetch_array($products_new_added_big_img_query)) { ?> <a href="<?php echo tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $newproducts["products_id"]) ;?>" class="image" data-rel="<?php echo tep_href_link(DIR_WS_IMAGES . $products_new_added_big_img['image'], $products_new_added_big_img['products_name']); ?>"> <?php echo tep_image(DIR_WS_IMAGES . $products_new_added_big_img['image'], $products_new_added_big_img['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'class="thumb"'); ?> </a> <?php } ?> <!-- previews output --> </div> <?php } } ?> <!-- product has some previews --> <?php $products_new_added_big_img_query1 = tep_db_query("select distinct pi.image, pi.products_id from " . TABLE_PRODUCTS_IMAGES . " pi where pi.products_id = '$current_product' order by pi.id ASC "); $products_new_added_big_img = tep_db_fetch_array($products_new_added_big_img_query1); ?> <!-- stickers --> <?php echo $sticker_sale.$sticker_options.$sticker_new; ?> <!-- stickers --> <div class="col-2"> <div class="big_image"> <a href="<?php echo tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $newproducts["products_id"]) ;?>"> <?php if (tep_db_num_rows($products_new_added_big_img_query) > 0) { echo tep_image(DIR_WS_IMAGES . $products_new_added_big_img['image'], $products_new_added_big_img['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT); } else { echo tep_image(DIR_WS_IMAGES . $newproducts['products_image'], $newproducts['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT); } ?> </a> </div> <div class="wrapper-hover"> <div class="product-name"> <a href="<?php echo tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $newproducts["products_id"]) ;?>"> <?php echo trimmed_text($newproducts['products_name'] , 50) ?> </a> </div> <div class="wrapper"> <?php echo $newproducts_price; ?> <div class="product-tocart"> <a href="<?php echo tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $newproducts['products_id']) ?>"><i class="icon-basket"></i></a> </div> </div> <?php echo $rating; ?> </div> </div> </div> </div> <!-- rollover product view --> <?php } ?> <!-- products output cycle --> </div> </div> </div> </div> </div> <?php } ?>

I'm using this query, and i get a duplicate special product. $listing_sql .= "p.products_id, p.products_model, p.fr_currencies_id, p.manufacturers_id, m.manufacturers_name, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id join " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c on p.products_id = p2c.products_id " . $sql_array['from'] . " where p.products_status = '1' and pd.language_id = '" . (int) $languages_id . "' " . $sql_array['where'] . " "; anyway to remove the duplicate ?

I don't know why tax is not included. using 2.3.4BT the Configuration, My Store, Display prices with taxes is True Retail is set to Show prices with taxes When I logout, the price show with taxes I checked the tax zone, all countries I noticed when I remove this code from includes/functions/general.php the tax is included. if (!isset($_SESSION['sppc_customer_group_tax_exempt'])) { $customer_group_tax_exempt = '0'; } else { $customer_group_tax_exempt = $_SESSION['sppc_customer_group_tax_exempt']; } Any idea please ?

@@raiwa thanks. its working now.

Hello, I'm trying to install this addon on a 2.3.4 BT, but I couldnt find the following to replace: in includes/functions/general.php my function read like this: // Redirect to another page or site function tep_redirect($url) { if ( (strstr($url, "\n") != false) || (strstr($url, "\r") != false) ) { tep_redirect(tep_href_link(FILENAME_DEFAULT, '', 'NONSSL', false)); } if ( (ENABLE_SSL == true) && (getenv('HTTPS') == 'on') ) { // We are loading an SSL page if (substr($url, 0, strlen(HTTP_SERVER . DIR_WS_HTTP_CATALOG)) == HTTP_SERVER . DIR_WS_HTTP_CATALOG) { // NONSSL url $url = HTTPS_SERVER . DIR_WS_HTTPS_CATALOG . substr($url, strlen(HTTP_SERVER . DIR_WS_HTTP_CATALOG)); // Change it to SSL } } if ( strpos($url, '&') !== false ) { $url = str_replace('&', '&', $url); } header('Location: ' . $url); tep_exit(); } and in includes/application_top.php my function read like this: // set php_self in the local scope $req = parse_url($HTTP_SERVER_VARS['SCRIPT_NAME']); $PHP_SELF = substr($req['path'], ($request_type == 'NONSSL') ? strlen(DIR_WS_HTTP_CATALOG) : strlen(DIR_WS_HTTPS_CATALOG)); if ($request_type == 'NONSSL') { define('DIR_WS_CATALOG', DIR_WS_HTTP_CATALOG); } else { define('DIR_WS_CATALOG', DIR_WS_HTTPS_CATALOG); } in includes/modules/product_listing.php my function read like this: tep_href_link($PHP_SELF, tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $listing['products_id']);

are you going to release new modified version soon ?

Hello, I have a question. I applied a filter named "Generation" to the category Processors (CPU) The values are i3 / i5/ i7 When i go to the backend to edit a CPU product i can see the filter drop down with i3 selected by default. is there a way to leave a product with Null value ? because not all processors belong to i3 or i5 or i7

Hello, is it possible to add a class to the last category <li> ?? <?php /* CATEGORY NAVIGATION BAR cat_navbar.php Adapted from ul_categories and superfish jquery for OSC to CSS references: by www.niora.com/css-oscommerce.php $Id: ul_categories.php,v 1.00 2006/04/30 01:13:58 nate_02631 Exp $ Outputs the store category list as a proper unordered list, opening up possibilities to use CSS to style as drop-down/flyout, collapsable or other menu types. osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2006 Nate Welch http://www.natewelch.com Released under the GNU General Public License */ // BEGIN Configuration options // Indicates whether or not to render your entire category list or just the root categories // and the currently selected submenu tree. Rendering the full list is useful for dynamic menu // generation where you want the user to have instant access to all categories. The other option // is the default oSC behaviour, when the subcats aren't available until the parent is clicked. $show_full_tree = true; // This is the CSS *ID* you want to assign to the UL (unordered list) containing // your category menu. Used in conjuction with the CSS list you create for the menu. // This value cannot be blank. $idname_for_menu = 'sf-menu'; // see superfish.css // This is the *CLASSNAME* you want to tag a LI to indicate the selected category. // The currently selected category (and its parents, if any) will be tagged with // this class. Modify your stylesheet as appropriate. Leave blank or set to false to not assign a class. //gt $classname_for_selected = 'selected'; $classname_for_selected = 'current'; // see superfish.css // This is the *CLASSNAME* you want to tag a LI to indicate a category has subcategores. // Modify your stylesheet to draw an indicator to show the users that subcategories are // available. Leave blank or set to false to not assign a class. //gt $classname_for_parent = 'parent'; $classname_for_parent = 'current'; //see superfish.css // This is the HTML that you would like to appear before your categories menu // This is useful for reconciling tables or clearing // floats, depending on your layout needs. Leave blank for no html $before_html = '<div class="cat_navbar_bg">'; // This is the HTML that you would like to appear after your categories menu if *not* // displaying in a standard "box". This is useful for reconciling tables or clearing // floats, depending on your layout needs. $after_html = '</div> '; // END Configuration options // Global Variables $GLOBALS['this_level'] = 0; // Initialize HTML and info_box class if displaying inside a box // Generate a bulleted list (uses configuration options above) $categories_string = tep_make_catsf_ullist(); echo $before_html; echo $categories_string; echo $after_html; // Create the root unordered list function tep_make_catsf_ullist($rootcatid = 0, $maxlevel = 0){ global $idname_for_menu, $cPath_array, $show_full_tree, $languages_id; // Modify category query if not fetching all categories (limit to root cats and selected subcat tree) if (!$show_full_tree) { $parent_query = 'AND (c.parent_id = "0"'; if (isset($cPath_array)) { $cPath_array_temp = $cPath_array; foreach($cPath_array_temp AS $key => $value) { $parent_query .= ' OR c.parent_id = "'.$value.'"'; } unset($cPath_array_temp); } $parent_query .= ')'; } else { $parent_query = ''; } $result = tep_db_query('select c.categories_id, cd.categories_name, c.parent_id from ' . TABLE_CATEGORIES . ' c, ' . TABLE_CATEGORIES_DESCRIPTION . ' cd where c.categories_id = cd.categories_id and cd.language_id="' . (int)$languages_id .'" '.$parent_query.' order by sort_order, cd.categories_name'); while ($row = tep_db_fetch_array($result)) { $table[$row['parent_id']][$row['categories_id']] = $row['categories_name']; } $output .= '<ul class="'.$idname_for_menu.'">'; //gt $output .= '<ul id="'.$idname_for_menu.'">'; $output .= tep_make_catsf_ulbranch($rootcatid, $table, 0, $maxlevel); // Close off nested lists for ($nest = 0; $nest <= $GLOBALS['this_level']; $nest++) { //if you need extra links uncomment out the lines below // $output .= '</ul></li>'; // $output .=' // <li><a href=" '.tep_href_link('myextralink_1.php', '', 'NONSSL').'" >Extra Link 1</a></li> // <li><a href=" '.tep_href_link('myextralink_2.php', '', 'NONSSL').'" >Extra Link 2</a></li> // <li><a href=" '.tep_href_link('myextralink_3.php', '', 'NONSSL').'" >Extra Link 3</a></li> // '; $output .= '</ul>'; } return $output; } // Create the branches of the unordered list function tep_make_catsf_ulbranch($parcat, $table, $level, $maxlevel) { global $cPath_array, $classname_for_selected, $classname_for_parent; $list = $table[$parcat]; while(list($key,$val) = each($list)){ if ($GLOBALS['this_level'] != $level) { if ($GLOBALS['this_level'] < $level) { $output .= "\n".'<ul>'; } else { for ($nest = 1; $nest <= ($GLOBALS['this_level'] - $level); $nest++) { $output .= '</ul></li>'."\n"; } /* if ($GLOBALS['this_level'] -1 == $level) $output .= '</ul></li>'."\n"; elseif ($GLOBALS['this_level'] -2 == $level) $output .= '</ul></li></ul></li>'."\n"; elseif ($GLOBALS['this_level'] -3 == $level) $output .= '</ul></li></ul></li></ul></li>'."\n"; elseif ($GLOBALS['this_level'] -4 == $level) $output .= '</ul></li></ul></li></ul></li></ul></li>'."\n"; */ } $GLOBALS['this_level'] = $level; } if (isset($cPath_array) && in_array($key, $cPath_array) && $classname_for_selected) { $this_cat_class = ' class="'.$classname_for_selected.'"'; } else { $this_cat_class = ''; } //gt $output .= '<li class="cat_lev_'.$level.'"><a href="'; $output .= '<li class="current_'.$level.'"><a href="'; if (!$level) { unset($GLOBALS['cPath_set']); $GLOBALS['cPath_set'][0] = $key; $cPath_new = 'cPath=' . $key; } else { $GLOBALS['cPath_set'][$level] = $key; $cPath_new = 'cPath=' . implode("_", array_slice($GLOBALS['cPath_set'], 0, ($level+1))); } if (tep_has_category_subcategories($key) && $classname_for_parent) { $this_parent_class = ' class="'.$classname_for_parent.'"'; } else { $this_parent_class = ''; } $output .= tep_href_link(FILENAME_DEFAULT, $cPath_new) . '"'.$this_parent_class.'>'.$val; if (SHOW_COUNTS == 'true') { $products_in_category = tep_count_products_in_category($key); if ($products_in_category > 0) { $output .= ' (' . $products_in_category . ')'; } } $output .= '</a>'; if (!tep_has_category_subcategories($key)) { $output .= '</li>'."\n"; } if ((isset($table[$key])) AND (($maxlevel > $level + 1) OR ($maxlevel == '0'))) { $output .= tep_make_catsf_ulbranch($key,$table,$level + 1,$maxlevel); } } // End while loop return $output; } ?>

Probably xe is using a new api link, i change in admin/includes/functions/localization.php this: $page = file('http://www.xe.net/ucc/convert.cgi?Amount=1&From=' . $from . '&To=' . $to); to this: $page = file('http://www.xe.com/currencyconverter/convert/?Amount=1&From='. $from . '&To=' . $to); Now its working again.

everything was working, i was receiving emails from cron on successful currencies update. but recently i'm receiving this email: Warning: file(http://www.xe.net/ucc/convert.cgi?Amount=1&From=EUR&To=USD): failed to open stream: HTTP request failed! HTTP/1.0 400 Bad Request in /home/domain/public_html/backend/includes/functions/localization.php on line 24 Warning: implode(): Invalid arguments passed in /home/domain/public_html/backend/includes/functions/localization.php on line 26 Warning: file(http://www.xe.net/ucc/convert.cgi?Amount=1&From=EUR&To=EUR): failed to open stream: HTTP request failed! HTTP/1.0 400 Bad Request in /home/domain/public_html/backend/includes/functions/localization.php on line 24 Warning: implode(): Invalid arguments passed in /home/domain/public_html/backend/includes/functions/localization.php on line 26 Currencies Update Report<br><br>Currencies for Website Title updated on Sat Jun 6 18:00:13 2015<br><br>The exchange rate for US dollar <b>WAS</b> successfully updated.<br>The exchange rate for Euro <b>WAS</b> successfully updated.<br>