Import Product Reviews in Magento via SQL

Import Product Reviews/Ratings in Magento

Customers are more likely to make purchasing decisions when they see a product that has good reviews.Also, some search engines give sites with product reviews a higher ranking than those without. Since Magento doesn’t support default functionality for importing product reviews, we came up with a quick approach using SQL. Database Schema for Product Reviews …

Read moreImport Product Reviews in Magento via SQL

How to Use Customer Group in Magento?

Having an online store requires consistent correspondence, communication, and association with your clients. However, consider the possibility that you extend your business and begin teaming up widely with new partners. Or then again maybe you need to offer them some kind of special condition when purchasing a product from your online store? Provided that this …

Read moreHow to Use Customer Group in Magento?

Best Resources to Help You Learn Magento

Learning Magento may seem like a laborious task at first, but when you know the right resources and the right places to head to, it may not be that difficult to master the platform. Magento is one of the biggest e-commerce platforms and it powers some of the biggest websites on the internet. Even small …

Read moreBest Resources to Help You Learn Magento

MySQL Issue: Table storage engine for ‘catalog_product_relation’ doesn’t have this option

When you export the Magento database dump from MySQL 5.5.x and try to import in MySQL 5.7.x, You are likely to face an error: ERROR 1031 (HY000) at line 3002: Table storage engine for ‘catalog_product_relation’ doesn’t have this option PROBLEM This is probably due to the table option that you have in your CREATE TABLE …

Read moreMySQL Issue: Table storage engine for ‘catalog_product_relation’ doesn’t have this option