Website At 100: Wpsc Product

<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="background-color: white; color: #666666; font-family: 'Droid Sans'; font-size: 12px; line-height: 22px; margin-bottom: 18px; text-align: justify;">
Last few months I’m posted other tutorial for WP e-Commerce displaying featured products, I thought that’s the last thing they forgot to add in their Plugin built-in widgets but no, there are a lot more, I also noticed displaying best-selling products is one of the great feature and can’t be ignore, so today I’ll give you this simple snippet for displaying best-selling products in WP e-Commerce in an easy way.</div>
<h3 style="background-color: white; color: #333333; font-family: 'Droid Sans'; font-size: 16px; font-weight: 200; letter-spacing: -0.1px; line-height: 20px; margin-top: 0px; padding: 0px; text-align: justify;">
How this snippet works?</h3>
<ul style="background-color: white; color: #666666; font-family: 'Droid Sans'; font-size: 12px; line-height: 22px; list-style: square outside; margin: 20px 0px 20px 40px; padding: 0px; text-align: justify;">
<li style="list-style-position: outside; margin-bottom: 20px;">Get lists of purchased products ordered by max number of product purchased</li>
<li style="list-style-position: outside; margin-bottom: 20px;">Use <code style="font-family: monospace, monospace; font-size: 1em; white-space: pre-wrap; word-wrap: break-word;">WP_Query</code> to query those product ids, yes it’s possible since <a href="http://websiteat100.com/blog/category/wordpress/" style="-webkit-transition: background-color 0.2s ease 0s, border 0.2s ease 0s, color 0.2s ease 0s, opacity 0.2s ease-in-out 0s; color: black; line-height: inherit; text-decoration: none; transition: background-color 0.2s ease 0s, border 0.2s ease 0s, color 0.2s ease 0s, opacity 0.2s ease-in-out 0s;" title="Wordpress blog by websiteat100.com">WordPress </a>Ecommerce uses custom post-type for adding products</li>
<li style="list-style-position: outside; margin-bottom: 20px;">Use WPSC code to display product title, featured image, price or even add to add button</li>
</ul>
<div data-settings=" minimize scroll-mouseover" id="crayon-52a561db7bde4811161178" style="background-color: white; color: #666666; font-family: 'Droid Sans'; font-size: 12px; line-height: 22px; text-align: justify;">
<div data-settings=" show">
<a href="http://websiteat100.com/blog/category/php/" style="-webkit-transition: background-color 0.2s ease 0s, border 0.2s ease 0s, color 0.2s ease 0s, opacity 0.2s ease-in-out 0s; color: black; line-height: inherit; text-decoration: none; transition: background-color 0.2s ease 0s, border 0.2s ease 0s, color 0.2s ease 0s, opacity 0.2s ease-in-out 0s;" title="Php blog by websiteat100.com">PHP</a></div>
<div>
</div>
<div>
<table style="border-collapse: collapse; border-spacing: 0px;"><tbody>
<tr><td data-settings="show" style="border: none; color: #333333; font-size: 12px; line-height: 18px; padding: 9px 10px; vertical-align: top;"><div data-line="crayon-52a561db7bde4811161178-1">
1</div>
<div data-line="crayon-52a561db7bde4811161178-2">
2</div>
<div data-line="crayon-52a561db7bde4811161178-3">
3</div>
<div data-line="crayon-52a561db7bde4811161178-4">
4</div>
<div data-line="crayon-52a561db7bde4811161178-5">
5</div>
<div data-line="crayon-52a561db7bde4811161178-6">
6</div>
<div data-line="crayon-52a561db7bde4811161178-7">
7</div>
<div data-line="crayon-52a561db7bde4811161178-8">
8</div>
<div data-line="crayon-52a561db7bde4811161178-9">
9</div>
<div data-line="crayon-52a561db7bde4811161178-10">
10</div>
<div data-line="crayon-52a561db7bde4811161178-11">
11</div>
<div data-line="crayon-52a561db7bde4811161178-12">
12</div>
<div data-line="crayon-52a561db7bde4811161178-13">
13</div>
<div data-line="crayon-52a561db7bde4811161178-14">
14</div>
<div data-line="crayon-52a561db7bde4811161178-15">
15</div>
<div data-line="crayon-52a561db7bde4811161178-16">
16</div>
<div data-line="crayon-52a561db7bde4811161178-17">
17</div>
<div data-line="crayon-52a561db7bde4811161178-18">
18</div>
<div data-line="crayon-52a561db7bde4811161178-19">
19</div>
<div data-line="crayon-52a561db7bde4811161178-20">
20</div>
<div data-line="crayon-52a561db7bde4811161178-21">
21</div>
<div data-line="crayon-52a561db7bde4811161178-22">
22</div>
<div data-line="crayon-52a561db7bde4811161178-23">
23</div>
<div data-line="crayon-52a561db7bde4811161178-24">
24</div>
<div data-line="crayon-52a561db7bde4811161178-25">
25</div>
<div data-line="crayon-52a561db7bde4811161178-26">
26</div>
<div data-line="crayon-52a561db7bde4811161178-27">
27</div>
<div data-line="crayon-52a561db7bde4811161178-28">
28</div>
<div data-line="crayon-52a561db7bde4811161178-29">
29</div>
<div data-line="crayon-52a561db7bde4811161178-30">
30</div>
<div data-line="crayon-52a561db7bde4811161178-31">
31</div>
<div data-line="crayon-52a561db7bde4811161178-32">
32</div>
<div data-line="crayon-52a561db7bde4811161178-33">
33</div>
<div data-line="crayon-52a561db7bde4811161178-34">
34</div>
<div data-line="crayon-52a561db7bde4811161178-35">
35</div>
<div data-line="crayon-52a561db7bde4811161178-36">
36</div>
<div data-line="crayon-52a561db7bde4811161178-37">
37</div>
</td><td style="border: none; color: #333333; font-size: 12px; line-height: 18px; padding: 9px 10px; vertical-align: top;"><div id="crayon-52a561db7bde4811161178-1">
<?php</div>
<div id="crayon-52a561db7bde4811161178-2">
    global $wpdb;</div>
<div id="crayon-52a561db7bde4811161178-3">
</div>
<div id="crayon-52a561db7bde4811161178-4">
    // Assign table name to a variable</div>
<div id="crayon-52a561db7bde4811161178-5">
    $tbl_cart = $wpdb->prefix . ‘wpsc_cart_contents’;</div>
<div id="crayon-52a561db7bde4811161178-6">
</div>
<div id="crayon-52a561db7bde4811161178-7">
    // Select prodid field from wpsc_cart_contents table</div>
<div id="crayon-52a561db7bde4811161178-8">
    $products = $wpdb->get_results( “SELECT prodid, COUNT(prodid) as prod_num FROM $tbl_cart GROUP BY prodid ORDER BY prod_num DESC LIMIT 0, 4″ );</div>
<div id="crayon-52a561db7bde4811161178-9">
</div>
<div id="crayon-52a561db7bde4811161178-10">
    // Check if there is sold product</div>
<div id="crayon-52a561db7bde4811161178-11">
    if( $products )</div>
<div id="crayon-52a561db7bde4811161178-12">
    {</div>
<div id="crayon-52a561db7bde4811161178-13">
        $product_ids = array();</div>
<div id="crayon-52a561db7bde4811161178-14">
</div>
<div id="crayon-52a561db7bde4811161178-15">
        // Get lists of purchase product ids</div>
<div id="crayon-52a561db7bde4811161178-16">
        foreach( $products as $product )</div>
<div id="crayon-52a561db7bde4811161178-17">
            $product_ids[] = $product->prodid;</div>
<div id="crayon-52a561db7bde4811161178-18">
</div>
<div id="crayon-52a561db7bde4811161178-19">
        $args = array(</div>
<div id="crayon-52a561db7bde4811161178-20">
            ’post_type’ => ‘wpsc-product’,</div>
<div id="crayon-52a561db7bde4811161178-21">
            ’post__in’     => $product_ids</div>
<div id="crayon-52a561db7bde4811161178-22">
        );</div>
<div id="crayon-52a561db7bde4811161178-23">
</div>
<div id="crayon-52a561db7bde4811161178-24">
        $the_query = new WP_Query( $args );</div>
<div id="crayon-52a561db7bde4811161178-25">
// The Loop</div>
<div id="crayon-52a561db7bde4811161178-26">
        if ( $the_query->have_posts() ) {</div>
<div id="crayon-52a561db7bde4811161178-27">
            while ( $the_query->have_posts() ) : $the_query->the_post();</div>
<div id="crayon-52a561db7bde4811161178-28">
                // add your product code here like, product title, image, price or even add to cart button, don’t worry the wpsc code works fine in here <img alt=";)" class="wp-smiley" src="http://websiteat100.com/blog/wp-includes/images/smilies/icon_wink.gif" style="border: 0px; height: auto; margin: 0px !important; max-height: 1em; max-width: 100%; vertical-align: middle;" /></div>
<div id="crayon-52a561db7bde4811161178-29">
            endwhile;</div>
<div id="crayon-52a561db7bde4811161178-30">
        } else {</div>
<div id="crayon-52a561db7bde4811161178-31">
            _e(‘<p>No product sold yet.</p>’);</div>
<div id="crayon-52a561db7bde4811161178-32">
        }</div>
<div id="crayon-52a561db7bde4811161178-33">
</div>
<div id="crayon-52a561db7bde4811161178-34">
        /* Restore original Post Data */</div>
<div id="crayon-52a561db7bde4811161178-35">
        wp_reset_postdata();</div>
<div id="crayon-52a561db7bde4811161178-36">
    }</div>
<div id="crayon-52a561db7bde4811161178-37">
?></div>
</td></tr>
</tbody></table>
</div>
</div>
</div>

DISPLAY BEST SELLING PRODUCTS IN WP E-COMMERCE

Last few months I’m posted other tutorial for WP e-Commerce displaying featured products, I thought that’s the last thing they forgot to a...