Skip to main content
OverflowAI is here! AI power for your Stack Overflow for Teams knowledge community. Learn more
25 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,705
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,987
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,395
9 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

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,395
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.7k
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
  • 5,395
6 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
  • 315
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

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
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

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,210
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
5 votes
Accepted

Import Process in Magento 2.4.6 Interfering with Each Other (Magento 2.4.6 )

This is default Magento bug and they are working on it, I have found temporarily solution for it, Increase the batch size of the default import to avoid interfering with each other. Default batch size ...
Mohammad Bharmal's user avatar
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,987
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
Accepted

Use Default Value automatically unchecked for all the fields of store when importing products

With the default ImportExport CSV format you can set store specific values for single attributes if and only if you also import the default values. Example: sku, _store, name , meta_title xxx,...
Fabian Schmengler's user avatar
4 votes
Accepted

Product import successful but not showing on frontend

Use following command for reindexing: php bin/magento indexer:reindex
Waqar's user avatar
  • 974
4 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 ...
Richard's user avatar
  • 193
4 votes
Accepted

How can Export Categories with product on Magento 2

By default categories export option is not available with magento 2. But you can do a trick like export a product with specific categories id. go to system -> export -> products -> then in the ...
Manthan Dave's user avatar
  • 9,826
4 votes
Accepted

Magento 2: How to import export Categories in csv via backend using Entity Type catalog_category

I have fixed issue to update the export() function code. <?php namespace Vendor\CategoryImportExport\Model\Export; use Magento\Catalog\Model\ResourceModel\Category\Collection; use Magento\...
Kirti Nariya's user avatar
  • 3,041
4 votes
Accepted

Export file problem in Magento 2.3

Replace this below code in app/code/Magento/ImportExport/Controller/Adminhtml/Export/Export.php File This code is working in my application public function execute() { if ($this->getRequest()-...
Hemant Sharma's user avatar
3 votes

Magmi alternative for Magento 2.0?

Searching around I came across this: https://github.com/tagesjump/magmi-m2 There is also some talk related to some issues on this issue: https://github.com/dweeves/magmi-git/issues/369 I hope this ...
claudiu.f.marginean's user avatar
3 votes

Magento 2 product import error

I got this solved by running the below query to the database: delete from catalog_product_entity_varchar where attribute_id=98 and value=""; where 98 is the attribute_id of url_path attribute. Hope ...
PHP Bugs's user avatar
  • 227
3 votes
Accepted

giving 777 permissions for media folder

it's not directly an entry point for attackers, but it can be a security issue when someone already has access to your server. It's pretty common to store information (stolen from the Server) ...
David Verholen's user avatar
3 votes

Magmi alternative for Magento 2.0?

Here is most alive recent project which have merged few another attempts to port Magmi for Magento 2 - https://github.com/macopedia/magmi-git Another interesting project is M2IF - Magento 2 Import ...
FireBear's user avatar
  • 2,120

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