Jump to content


  • Content count

  • Joined

  • Last visited

  1. MzM

    I'm new....

    just phone UPS..they say they dnt have a code for mauritius...they told me to put any number lol.. By the way is the postal code 4 digit number ? I tried with 1000, it didn't work. Thx
  2. MzM

    I'm new....

    Thx zip code ? U mean Postal Code.. I'm from mauritius and we dont have a postal code :blink:
  3. MzM

    I'm new....

    Ah sorry ..its regarding this one: I'm with the default ups module...or should I install this one: UPS XML Thx
  4. MzM

    I'm new....

    Hi, Anyone manage to solve their problem..coz am in a similar situation. thx
  5. Thx again. I'm having problems with my mail function so i'm not able to get the incoming mail. So what do u advice me..use the default behaviour right, coz even a company can buy in retail. What is the tax id ? is it a tax id per country... :blush: . I dnt know much abt these issues..any advice or links that might help me get a better understanding..
  6. Hi JanZ, I'm a bit confused abt SPPC. well i've installed it and get it working.I've made 2 customer group; Retailer and Wholesaler. So when a customer will register for an account, he/she will be selected as retailer by default right ? If the client want to be a wholesaler..does he has to mail me a request so that i assign him to the wholesaler group ? Is this how I should be using SPPC..or did I miss something. Thx :)
  7. Hi Janz! Thx a lot. You were right..it works fine now :thumbsup: . Regarding the query for product description, it indeed seems useless, i'm having an error with it anyway, so i commented it out. By the way do u know of any nice display code for the new products. The one on my template are not giving the desired results (sorry to be off topic :blush: ) Best Regards
  8. Hi, I am having some difficulties to apply changes of SPPC to new_products.php. This file is not like the default osc file. Here's my new_products.php: <?php /* $Id: new_products.php,v 1.34 2003/06/09 22:49:58 hpdl Exp $ */ ?> <!-- new_products //--> <?php $info_box_contents = array(); $info_box_contents[] = array('text' => TABLE_HEADING_NEW_PRODUCTS); new infoBoxHeadingProduct($info_box_contents,true,true,100); // new contentBoxHeading($info_box_contents); ?> <?php if ( (!isset($new_products_category_id)) || ($new_products_category_id == '0') ) { $new_products_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id 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, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . 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); } $row = 0; $col = 0; $info_box_contents = array(); while ($new_products = tep_db_fetch_array($new_products_query)) { $new_products['products_name'] = tep_get_products_name($new_products['products_id']); $sql = 'SELECT `products_description` FROM `products_description` WHERE products_id ='.$new_products['products_id'].' && language_id='.(int)$languages_id; $description_query = tep_db_query($sql); $description = mysql_fetch_array($description_query, MYSQL_ASSOC); $description['products_description'] = substr($description['products_description'], 0, 65); $desc_len = strlen($description['products_description']); $description['products_description'][$desc_len-1] = '.'; $description['products_description'][$desc_len-2] = '.'; $description['products_description'][$desc_len-3] = '.'; if ( ($col == 1 && $row == 0) || ($col == 1 && $row == 2) ){ $info_box_contents[$row][$col] = array('align' => 'center', 'params' => 'width="1" height="100%" valign="middle"', 'text' => '<table height="115" width="100%" background="'.DIR_WS_IMAGES .'m_vert.jpg" border="0" cellspacing="0" cellpadding="0" > <tr> <td><div style="width:1px"></div></td> </tr> </table>'); } elseif (($col == 0 && $row == 1) || ($col == 2 && $row == 1)) { $info_box_contents[$row][$col] = array('align' => 'center', 'params' => 'height="1"', 'text' => '<table width="90%" background="'.DIR_WS_IMAGES .'m_horizontal.jpg" border="0" cellspacing="0" cellpadding="0" > <tr> <td></td> </tr> </table>'); } elseif ($col == 1 && $row == 1) { $info_box_contents[$row][$col] = array('align' => '', 'params' => '', 'text' => '?'); } else { $info_box_contents[$row][$col] = array('align' => 'center', 'params' => 'width="50%" class="main" valign="top"', 'text' => ' <table width=100% cellpadding=0 cellspacing=0 border=0> <tr> <td height="19px">'.$new_products['products_name'].'</td> </tr> <tr><td><table cellpadding="0" cellspacing="0" border="0" width="100%"> <tr><td> <a href="'. tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) .'">'. tep_image(DIR_WS_IMAGES . $new_products['products_image'], $new_products['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'align="center"') . ' </a> </td></tr> <tr><td> <span style="font:bold 13px Tahoma, Verdana, Arial, Helvetica, sans-serif;color:red; border-top:7px solid #ffffff; border-bottom:7px solid #ffffff;">'. $currencies->display_price($new_products['products_price'], tep_get_tax_rate($new_products['products_tax_class_id'])).' </span> </td> </tr> <tr><td colspan="2" class="main" valign="top"> <table width="90%" border="0" cellspacing="0" cellpadding="0" valign="bottom"> <tr> <td align="CENTER"> <div>'.tep_draw_form('cart_quantity', tep_href_link(FILENAME_PRODUCT_INFO, tep_get_all_get_params(array('action')) . 'action=add_product')).' <a class="buy" href="'.tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']).'" style="text-decoration:none;"> Details </a><img src="images/razdelitel.gif"> '. tep_draw_hidden_field('products_id', $new_products['products_id']) . tep_image_submit('add_to_cart.gif', IMAGE_BUTTON_IN_CART) .'</form> </div> </td> </tr> </table></form> </td></tr> </table> </td></tr> </table> </div>'); } $col ++; if ($col > 2) { $col = 0; $row ++; } }?> <div style="border-left:2px solid #96BB46;border-right:2px solid #96BB46; height:376px;"><div style="width:100%; height:3px;"></div><?php new contentBox($info_box_contents, 0);?></div> <?php new infoBoxFooterProduct(); ?> <!-- new_products_eof //--> I've tried to change it ..but it changes the original look. Thx
  9. Hi, I'm looking for manual instruction for the modifs in categories.php. Overwriting the file changes the look of my site. :huh: Thx
  10. Hi, I'm looking for discount contrib that works with SPPC. Any suggestions :rolleyes: ? Thanks
  11. MzM

    [Contribution] STS v4

    If by disabling the category box on the left colum u mean commenting/removing code in column_left.php, then thats not the soln. You should only work on the html template, if u want to remove a box, u simply remove the variable ;)
  12. MzM

    Easy Discount

    Hi, I have SPPC contrib running. Just want to know if i can use both easy discount and sppc. I really want easy discount installed... Thx
  13. Thanks for these advice, I badly need them. :thumbsup: I have only 1 month left to submit my project! I haven't so far seen the payment, shipping and security modules of osc. Perhaps I should stop adding contrib and move to these stuff...Hope that one month will be enough to cover these aspect :huh: Regards MzM
  14. Hmmm i've not think about it, just wanted to facilitate the customer..coz perhaps some wnt make the effort to login etc. But its better not to show both the prices anyway :blush: . What other contribs do u advice me to install to improve the b2b aspects. I'll try Quantity Price Breaks for SPPC. what are the other contribs for sppc ? Another point. How should paiment be dealt with wholesalers. Can large sum of money be paid via credit cards ? sorry for these questions..i'm just a confused student.. ;)
  15. Hi, Just got this contrib installed in a fresh osc. From what i've read so far is that one must register as 'wholesale' to see the wholesale price. Is there a way of displaying both the price without the need to register ? or something like an option where the visitor can choose which price to display(wholesale or retail).. :rolleyes: Thx in advance