5 votes
Accepted

Magento 2: Unable to import products due to Invalid URL Key Error

Issue may be in your category url column. In my case there were two consecutive commas in category URL.
user avatar
5 votes
Accepted

tax_class_name in product import won't change to none

Insted of writeing 0 into column please write "None" . it will work fine becouse magento 2 not accepting numberic value while we importing using CSV.
user avatar
3 votes
Accepted

Magento 2 csv product import : How to escape commas in category name

To get the import to work I've resorted to exporting the csv using pipe (| ) separated fields in OpenOffice for Mac. You will need to change the Field separator from comma to pipe on the import page ...
user avatar
  • 173
3 votes

import products using fast_simple_import

Refer below for steps to import products in magento 1 version https://www.magestore.com/manage-magento-online-store/magento-import-products You may refer to good extensions for product import like ...
user avatar
  • 325
3 votes
Accepted

Need csv format for size and color Configurable product Magento2?

Follow the below magento 2 official document to import configurable product. https://docs.magento.com/m2/ce/user_guide/system/data-transfer-configurable-products.html Sample CSV file download from ...
user avatar
  • 253
3 votes
Accepted

Magento 2- How to Import cross sell products with CSV?

You can use crosssell_skus column in your CSV file. You need to provide list of SKUs separated by comma for that column.
user avatar
3 votes

How to import multiple images for a single SKU

Okay, it appears that you don't add a new row for each additional image you want to add. Instead, you add an extra column called additional_images. And insert the following: image02.jpg,image03.jpg
user avatar
  • 2,500
2 votes
Accepted

Products not importing via CSV - Magento 2.2.3

Managed to fix this. The issue was my excel not saving the document properly to UTF8 (Comma Delimited). I had to open the .csv using notepad and resaving it into UTF 8 that way.
user avatar
  • 69
1 vote

Need csv format for size and color Configurable product Magento2?

First Solution : Please go through this csv format for size and color Configurable product Magento2.Set size,color variation as attached image Second Solution Go through that link and read this blog ...
user avatar
  • 1,597
1 vote
Accepted

Magento 2 : Configurable product import issue with option group attribute value

I have solved this issue by changing in following file. app\code\Custom\Attribute\Model\Config\Source\Options.php <?php /** * Copyright © Blackbeard, Inc. All rights reserved. * See COPYING....
user avatar
1 vote
Accepted

Magento 1 Update product categories to multiple root categories programmatically

You need to load the product in the context of the website ID to save the category for that product (against that store). Something like $allStores = Mage::app()->getStores(); foreach ($allStores ...
user avatar
1 vote
Accepted

Bulk Products import are not showing on front end

You have flat catalog enabled? If yes, disable if first and then run full reindex and flush cache and check if it is showing on front-end. If it will show then enable flat catalog again and do full re-...
user avatar
1 vote

On Import, why did Magento delete products?

It seems to count all the products which were deleted to be replaced by new data as "deleted here". Leads me to a new bonus question
user avatar
  • 14.4k
1 vote

Magento2.2 product import using Magmi

Is Magmi import is compatible with Magento2.2? -> Yes Is it compatible with grouped and simple products import? -> Yes Where I can find the Latest version of Magmi? -> https://github.com/...
user avatar
  • 6,063
1 vote

Magento 2 - Import custom product attributes through csv, can I import them using individual columns?

You can use Magento default Import Export available at (System > Data Transfer > Import/Export). Yes you need to specify all inside "additional_attributes" like "gift_wrapping_available=Use config,...
user avatar
1 vote
Accepted

Magento2 : Unable to serialize value while importing product description from CSV for configurable products

This error is due The store views code that I have added in my CSV files are in wrong order or doesn't match with the store view codes presented. Please try exporting the file and reimporing that file ...
user avatar
1 vote

Exporting / importing products

I think the problem with just catalog* is that the Magento catalog uses EAV and needs other tables like eav_attribute_*. The other possible issue with DB dumping just catalog tables from 2.1 and ...
user avatar
1 vote

How to Import Product Meta Title for Multi Store Website in magento 2

Use following fields in CSV and import again. sku,store_view_code,attribute_set_code,product_type,meta_title
user avatar
1 vote

Is it necessary to upload product images into the "media/import" folder before importing products from 1.9.1 to 1.9.4?

You can import images at any time simply by using an import csv that has 4 columns sku, base_image, small_image, thumbnail_image Images can be pre-uploaded into the import folder if you have FTP ...
user avatar
  • 320
1 vote

How to import downlodable product on different store using csv in magento2

When it comes to downloadable products and their import, the only difference they have from simple products in terms of attributes is the attribute downloadable_links. The structure of the attribute ...
user avatar
1 vote
Accepted

Is it possible to import decimal quantity while products imports for some of the products magento 2?

Yes, you can do it. in your product import CSV file, you can set is_qty_decimal to 1 and set your qty as the decimal. While from the backend you can do it from Advanced Inventory
user avatar
  • 17.6k
1 vote

Magento2.3 and Magmi

-> If Your magmi folder on magentoRoot/pub then registration.php <?php require_once BP . "/pub/magmi/plugins/inc/magmi_datasource.php"; require_once BP . "/pub/magmi/integration/...
user avatar
  • 6,063
1 vote

Magento2.3 and Magmi

You can include magmi file in your controller like Below: require_once(dirname(__FILE__) . "/../../../../../magmi/inc/magmi_defs.php"); require_once(dirname(__FILE__) . "/../../../../../magmi/...
user avatar
1 vote
Accepted

Attributes error on importing Magento 2 products

All date attributes need to be imported in the following format YYYY-mm-dd.
user avatar
  • 205
1 vote

images not imported through csv in magento 1.9

The correct path to place images in is media/import for images by default. First move all the images from your var/media/import to the above. Secondly remove the trailing / from your image names and ...
user avatar
  • 1,180
1 vote

Import default value in import product price

You need to leave one blank column to import default value. Your final csv like this: No | store | sku | price 1 MYSKU 15 2 au MYSKU 20 3 us MYSKU 30 4 ca MYSJU ...
user avatar
  • 21.7k
1 vote
Accepted

Getting an error while importing products on Magento from my other store

According to the errors and accounting for the headers in the .CSV file, the attribute set names listed on rows 2, 5, 6, 9, 12, 15, 18, 21, etc. are not present in the target Magento instance (or do ...
user avatar
1 vote

What is the best way to transfer data of Magento 2? + error "Unable to unserialize value."

Easy Steps: Backup your database Compress all file Migrate all to new server Import the database Open local.xml location : app/etc/local.xml Change following line 43 to 46, That is related to ...
user avatar
1 vote

Need Clarity on Bulk import methods in Magento

Option 1: Import Export when you export products using this option, the header columns name in csv will be same as attribute codes. you cannot change. also when you importing products using this ...
user avatar
1 vote
Accepted

Magento 2 - product image in product description page is incorrect

Follow the below instructions to regenerate all the catalog images. Admin -> System -> Cache Management -> Flush Catalog Images Cache (bottom of the page) Above one remove the cache folder from ...
user avatar
  • 9,549

Only top scored, non community-wiki answers of a minimum length are eligible