I am using wordpress-ecommerce wordpress plugin for my very own online ordering bakeshop (http://www.kingsbakery.mpkproducts.com/)

I'm not going the way in which how clients made a purchase. I would like similar order form such as this (https://www.ssfamousdeli.com/order_ship.aspx).

I operate a custom query in Mysql and that i are only able to retrieve the merchandise title and outline. I personally use this sql statement:

$sql = "SELECT * FROM wp_posts WHERE 
        post_type like 'wpsc_product' AND
        post_status like 'publish' 
        ORDER BY ID Asc";

$query = mysql_query($sql);

I only hold on there coz I'm not sure how you can join wordpress_postmeta to choose the cost.

Help. Thanks

$sql = "SELECT wp_p.*, wp_pm.meta_value FROM wp_posts wp_p, wp_postmeta wp_pm WHERE 
        wp_p.post_type like 'wpsc_product' AND
        wp_p.post_status like 'publish' AND
        wp_p.ID = wp_pm.post_id
        wp_pm.key = 'Price' --This should be the meta key
        ORDER BY wp_p.ID Asc";

$query = mysql_query($sql);

Hope this is of help.