{"id":402,"date":"2011-11-01T17:46:32","date_gmt":"2011-11-01T17:46:32","guid":{"rendered":"http:\/\/www.sitekickr.com\/blog\/?p=402"},"modified":"2011-11-01T17:46:50","modified_gmt":"2011-11-01T17:46:50","slug":"wp-ecommerce-product-review","status":"publish","type":"post","link":"https:\/\/www.sitekickr.com\/blog\/wp-ecommerce-product-review\/","title":{"rendered":"WP e-Commerce Product Reviews"},"content":{"rendered":"

WP e-Commerce<\/em>  is a pretty full featured WordPress plugin for creating an online store. But, if you're reading this post, you already know about WP-ecommerce, and are more interested in extending it's product review capabilities. Currently, a user can assign a star rating to any given WP-eCommerce product, but what about an actual review?<\/p>\n

While I've implemented solutions in the past, they were highly customized, so I will instead give a high level overview of the process I used to add product reviews to the existing star rating system:<\/p>\n

    \n
  1. Add another column to the existing wp_wpsc_product_rating database table for the actual product review.\n

    \t\talter table wp_wpsc_product_rating add column review text after rated;<\/code>
    \n\t\t <\/li>\n

  2. Create your own form for submitting a product rating and a review. This should be placed in the wpsc-single_product.php
    \n\t\ttemplate.
    \n\t\t <\/li>\n
  3. Create the form processing script, which creates a new record in the wp_wpsc_product_rating table. The SQL might look something like:\n

    \t\tINSERT INTO wp_wpsc_product_rating
    \n\t\t        (
    \n\t\t            ipnum,
    \n\t\t            productid,
    \n\t\t            rated,
    \n\t\t            review,
    \n\t\t            time
    \n\t\t        )
    \n\t\t        VALUES
    \n\t\t        (
    \n\t\t        '{$_SERVER['REMOTE_ADDR']}',
    \n\t\t        {$_REQUEST['productid']},
    \n\t\t        {$_REQUEST['rated']},
    \n\t\t        '{$_REQUEST['review']}',       
    \n\t\t        UNIX_TIMESTAMP()
    \n\t\t        );<\/code>
    \n\t\t <\/li>\n<\/ol>\n

    With this procedure, you will tie into the existing WP e-Commerce rating system, creating a more seamless integration with the product.<\/p>\n","protected":false},"excerpt":{"rendered":"

    WP e-Commerce  is a pretty full featured WordPress plugin for creating an online store. But, if you're reading this post, you already know about WP-ecommerce,…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"amp_status":""},"categories":[103],"tags":[135],"_links":{"self":[{"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/posts\/402"}],"collection":[{"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/comments?post=402"}],"version-history":[{"count":2,"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/posts\/402\/revisions"}],"predecessor-version":[{"id":404,"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/posts\/402\/revisions\/404"}],"wp:attachment":[{"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/media?parent=402"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/categories?post=402"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sitekickr.com\/blog\/wp-json\/wp\/v2\/tags?post=402"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}