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 more

Magento2: Fastest Way to Import / Update Product Prices in Bulk

Updating product prices in Magento 2

Overview As you know our Magento1 version of the script “Updating product prices in Magento in an easier & faster way” was a massive hit. And we are back with a similar script for Magento 2 which helps you to update the product prices in bulk – probably the easiest and fastest way possible. Let’s …

Read more

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 more

How to fix the issue: Product images missing in backend but not in the frontend

Introduction Recently I have to fix a strange issue for one of my clients. The issue was that product images were missing from ‘Images’ tab of product edit form (as depicted below), though they were displaying fine in the frontend. After going through the table relationship for catalog product images (as shown below), it was …

Read more

Updating product prices in Magento in an easier & faster way

Updating product prices in Magento 2

Introduction Product prices can be updated via default import profile though but this is very slow and requires lots of CSV fields(besides sku & price) for updating. Today I am going to talk about updating product prices just by using CSV with two fields: sku & price(new) which is very fast enough even for thousands …

Read more