TIPS & KNOWLEDGE BASE

E-COMMERCE SPECIALISTS SINCE 1996

Export Sebenza Ratings & Reviews

Estimated reading time: 1 minute

An example query to export Sebenza Ultimate Product Reviews & Ratings for import into GD Ratings & Reviews.

This example assumes a working knowledge of phpMyAdmin, MySQL databases and SQL queries, use at your own risk.

SELECT 
s01_SS_REVIEWS_reviews.title AS TITLE, 
s01_SS_REVIEWS_reviews.rating AS RATING,
s01_SS_REVIEWS_reviews.review AS SUMMARY,
s01_Products.code AS PRODUCT_CODE,
s01_SS_REVIEWS_reviews.approved AS APPROVED,
s01_SS_REVIEWS_reviews.dyn_time AS CREATED_AT,
s01_SS_REVIEWS_reviews.name AS USER_NICKNAME,
s01_SS_REVIEWS_reviews.email AS USER_EMAIL,
CONCAT_WS(
', ',
IF(s01_SS_REVIEWS_reviews.city = '', NULL, s01_SS_REVIEWS_reviews.city), 
IF(s01_SS_REVIEWS_reviews.state = '', NULL, s01_SS_REVIEWS_reviews.state),
IF(s01_SS_REVIEWS_reviews.cntry = '', NULL, s01_SS_REVIEWS_reviews.cntry)
) AS USER_LOCATION
FROM s01_SS_REVIEWS_reviews
LEFT JOIN s01_Products
ON s01_SS_REVIEWS_reviews.product_id = s01_Products.id
WHERE s01_Products.id IS NOT NULL

** Have questions or need assistance with your Miva store? Contact us today!

Leave a Reply

Your email address will not be published. Required fields are marked *