category wise shipping in virtuemart

Discussion in 'PHP' started by rashgang, Sep 24, 2009.

0
  1. #1
    how to add category wise shipping in virtuemart. there are many flat rate for category:) Any one please help me
     
    rashgang, Sep 24, 2009 IP
  2. newgenservices

    newgenservices Well-Known Member

    Messages:
    862
    Likes Received:
    21
    Best Answers:
    0
    Trophy Points:
    105
    Digital Goods:
    1
    #2
    I am not exactly sure of the table structure in Virtuemart. But you can probably try to fetch data by category easily if you have a table with column 'category'.

    
<?php
$query = "SELECT * FROM "products" WHERE category = 'category1'";
$result = mysql_query($query);
// Now print result using a while loop.
?>
    Code (markup):
     
    newgenservices, Sep 25, 2009 IP
  3. rashgang

    rashgang Peon

    Messages:
    12
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Hi

    Thanks for the reply

    i need to add the category falt rate and each for the shipping

    if the category is flat rate is how many products they select it will be the same it the cateogyr is each rate the price will be doubled

    example category ipod - flat rate 9.90(shipping)
    category other product - each 8.80(shipping)

    other product price must be doubled if they take 2 products from other the shipping rate must be doubles 8.8. * 8.80 like this
     
    rashgang, Sep 25, 2009 IP