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:
<?php $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.
<?php $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.