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!