24 votes

Export file problem in Magento 2.3

If your var/importexportxxx file is blank try; php bin/magento queue:consumers:start exportProcessor https://github.com/magento/magento2/issues/23450
Andrew Taylor's user avatar
19 votes
Accepted

Read input csv file and convert it to array

In your controller file that $postUrl points to: protected $csv; public function __construct( \Magento\Framework\File\Csv $csv ) { $this->csv = $csv; } //The function name should match ...
PY Yick's user avatar
  • 2,695
18 votes
Accepted

import custom csv to custom table- magento 2

note: I get crystal clear explanation of custom import option from this link Please first download the whole zip file from this github link then change the module name as per your requirement. Just ...
Bilal Usean's user avatar
  • 9,837
14 votes
Accepted

ImportExport problem with new destructor of Varien_Image_Adapter_Gd2 in 1.9.2.0

That looks like they tried to make sure to destroy the image resource, but instead introduced a memory leak. I cannot think of a valid reason for this code, to be honest, but I can explain what has ...
Fabian Schmengler's user avatar
12 votes

Export file problem in Magento 2.3

You have to run cron by command line as mentioned here: php bin/magento cron:run https://github.com/magento/magento2/issues/23450#issuecomment-507581035 Then refresh the export page and you ...
Shafeel Sha's user avatar
  • 1,377
11 votes
Accepted

Magento 2 CSV Import: Not possible to import disabled products?

Found it: The column is actually still there, but is titled product_online (the attribute status has not changed though)
Fabian Schmengler's user avatar
8 votes

custom attributes in separate coloumn while export? - Magento 2.0.8

I found a free Magento 2 extension from BSS Commerce which helped me work around this: https://bsscommerce.com/blog/how-to-export-custom-product-attributes-in-magento-2/ https://bsscommerce.com/...
thaddeusmt's user avatar
  • 1,365
8 votes

import custom csv to custom table- magento 2

I would suggest to extend the Magento 2's default import functionality. To do that register a new module (lets say "Custom Import" for now) Create a module.xml file at app/code/Foo/...
Atish Goswami's user avatar
8 votes
Accepted

How to get order shipping address data

The problem is that $order is not set or it's no object (of type Mage_Sales_Model_Order). Also order with downloadable products have no shipping address. Edit: For the updated questions ... make ...
sv3n's user avatar
  • 11.6k
7 votes
Accepted

Magento 2 : Customer import not working and gives "Import successfully done"

Make sure you have reindexed all the indexes or your customer grid would not show imported customers. Use following command. php bin/magento indexer:reindex EDIT : Note that if you're only not able ...
Vivek Kumar's user avatar
  • 4,904
6 votes

ImportExport problem with new destructor of Varien_Image_Adapter_Gd2 in 1.9.2.0

Having the same problems with my Magento 1.9.2.0... I only get this to work by changing Varien_Image_Adapter_Gd2 in /lib/Varien/Image/Adapter/Gd2.php as follows: public function __construct() { /...
dkr's user avatar
  • 61
6 votes
Accepted

Change all short_description field as empty

go to Admin > catalog > products select all products select action as update attributes you have to check short description checkbox with empty text there. save. please select short ...
Denish Vachhani's user avatar
6 votes

custom attributes in separate coloumn while export? - Magento 2.0.8

All custom attributes get appeared under "additional_attributes" header in the export separated by a comma (,). I am using Magento 2.0.7. To make these attributes occupy a separate cell, we can add ...
Kumar A.'s user avatar
  • 493
6 votes

I want to add my custom entity for export Magento 2

This is possible by following the below steps; Include export.xml in your module etc directory with a content similar to the below; <config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" ...
Olubajo Bolaji's user avatar
5 votes
Accepted

Import of product via CSV (need to update, not replace, not append)

You should use the "append" mode, but exclude everything from your CSV file which is already in the shop, i.e. the images. Only include the data you want to update and the SKU.
Andreas von Studnitz's user avatar
5 votes

ImportExport problem with new destructor of Varien_Image_Adapter_Gd2 in 1.9.2.0

It was part of fixing security issues with unserialize. Magic methods like __destruct have inherent issues with serialization. We have seen exploits proposed that were using serialization and ...
Piotr Kaminski's user avatar
5 votes

ImportExport problem with new destructor of Varien_Image_Adapter_Gd2 in 1.9.2.0

So I did raise a bug with Magento including a "solution" that should deal with the memory usage issues in the image import process. The solution can be found on github under https://github.com/...
David Manners's user avatar
5 votes

custom attributes in separate coloumn while export? - Magento 2.0.8

Solution : For this Need to do some changes in vendor\magento\module-catalog-import-export\Model\Export\Product.php file or override same model file in your custom module . In vendor\magento\module-...
Lucky's user avatar
  • 305
5 votes

Do you have to use additional_attributes in Magento 2 product import or can you still create a separate field?

Yes, for custom attributes you have to use the additional_attributes column. Unfortunately you cannot add columns to the CSV anymore.
Fabian Schmengler's user avatar
5 votes

Read input csv file and convert it to array

This it the controller file to save/read imported CSV data: <?php namespace VendorName\ModuleName\Controller\Adminhtml\Pincode\Import; use Magento\Framework\App\Filesystem\DirectoryList; class ...
Ronak Chauhan's user avatar
5 votes
Accepted

Programmatically Update products attribute by sku for all store view

You can used below code to update product attributes for all store Added $ for obj $objectManager = \Magento\Framework\App\ObjectManager::getInstance(); $storeManager = $objectManager->create('\...
Nidhi's user avatar
  • 322
4 votes

Please help. After I upload the products file,I got the error: Image file was not found

See the following issues Magento image size Images size should be less than 2 MB (since in most cases Magento does not upload bigger images). Spaces in image names Check if in image names there ...
Supravat Mondal's user avatar
4 votes

Import & Export all categories using csv file (without extension)

If you want to import all categories and products to your website,just follow the following instructions. Create all categories and create one product in your website, After this, export that data ...
Teja Bhagavan Kollepara's user avatar
4 votes
Accepted

Import & Export all categories using csv file (without extension)

Not using any extensions is limiting you, but you could use Import/Export with products because missing categories will be created when you import products. Afterwards, delete the created products. ...
Fabian Schmengler's user avatar
4 votes

Magento does not display all imported products within the categories

Possible causes for products that do not appear on the frontend (I include those that you already ruled out for sake of completeness): the products' "visibility" attribute might be set to "Not ...
Fabian Schmengler's user avatar
4 votes

Change all short_description field as empty

A ways,You can do this by code Write a php shell script at you magento root dir. Using this script update this field vaue to blank. require_once "app/Mage.php"; umask(0); Mage::app('admin'); $...
Amit Bera's user avatar
  • 76.7k
4 votes
Accepted

import/export error - magento 2.0.1

First time I had success because I set Allowed Error Counts to 10 while importing. My CSV file has only one row so it skipped the one error, Updated the details except image. Second time I got an ...
Bilal Usean's user avatar
  • 9,837
4 votes

custom attributes in separate coloumn while export? - Magento 2.0.8

This formula works in Excel, assuming no values have commas. =IFERROR(LEFT(RIGHT(H5, SUM(LEN(H5)-FIND("material=", H5)- LEN("material="), 1)), IFERROR(FIND(",", RIGHT(H5, SUM(LEN(H5)-FIND("material=",...
Pizza and Coke's user avatar
4 votes

Magmi alternative for Magento 2.0?

You can always try the native import/export interface. Tools like Magmi (directly writing sql) will suffer in the long run, because import not imports a bit differently (repository->save() instead of ...
Nils Preuß's user avatar
4 votes

Product Type is invalid or not supported even when uploading the CSV magento exported

When exporting products in Magento, "Bundle" and "Downloadable" products can't be re-imported using the default importer (Or data flow) so these could be what is throwing the error message. If you are ...
Matt Antley's user avatar
  • 1,180

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