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

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 the 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 moreMagento2: Fastest Way to Import / Update Product Prices in Bulk

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

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 moreHow to fix the issue: Product images missing in backend but not in the frontend

Updating product prices in Magento in an easier & faster way

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 moreUpdating product prices in Magento in an easier & faster way

How to import product images from external URL in Magento

Introduction Generally, we import the product images by copying all the images to /media/import folder, adding image path relative to /media/import in CSV corresponding to the product SKUs and running the import profile. Sometimes you may need to import images from external URL and this is the case when you are using third-party web services …

Read moreHow to import product images from external URL in Magento