23 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
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 ...
user avatar
  • 2,635
18 votes
Accepted

Is there a way to export all categories into a csv?

You could write this one pretty easily. Create a PHP file called something like export.php. <?php require("app/Mage.php"); // load the main Mage file Mage::app(); // not run() ...
user avatar
  • 2,825
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 ...
user avatar
  • 9,549
17 votes
Accepted

What is the difference between Import/Export vs Dataflow

In short: Don't use Dataflow for anything, it's deprecated. Yoav Kutner once (2011) said that Dataflow is not usable, and that was the reason they added ImportExport in Magento 1.5. The main ...
user avatar
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 ...
user avatar
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)
user avatar
11 votes
Accepted

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 ...
user avatar
  • 1,372
10 votes
Accepted

How to get last created product id?

you can try like below with latest created_at $collection = Mage::getModel('catalog/product') ->getCollection() ->addAttributeToSort('...
user avatar
  • 3,985
8 votes
Accepted

Avs FastSimpleImport - Import all images

There are two options for this. It's more comfortable to use nested arrays (see http://avstudnitz.github.io/AvS_FastSimpleImport/options.html: "Support Nested Arrays for Import"), you can then use ...
user avatar
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/...
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 ...
user avatar
  • 11.5k
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 ...
user avatar
  • 4,585
6 votes

How to get last created product id?

Try this: $collection = Mage::getResourceModel('catalog/product_collection'); $collection->addAttributeToSort('entity_id', 'DESC'); $collection->setPage(1,1); //set a limit to 1 so the query ...
user avatar
  • 195k
6 votes
Accepted

Magento products not showing up after import

I'm not 100 sure but I think it has something to do with the status or visibility or the product. In the products grid, when retrieving the collection there are 2 inner joins for selecting the status ...
user avatar
  • 195k
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() { /...
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 ...
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 ...
user avatar
  • 493
6 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/...
user avatar
  • 1,287
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" ...
user avatar
5 votes
Accepted

Imported products from magento 1.7 site are not visible on magento 1.8 site

In Admin Panel, i) Goto Manage Products ii) Then Select the products which are not displaying in the frontend iii) Then Select the Update Attributes in the Action iv) Then Add those products to ...
user avatar
  • 1,339
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.
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 ...
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/...
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-...
user avatar
  • 197
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.
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('\...
user avatar
  • 322
4 votes

Are there any csv import logs kept?

If you look at the file Mage_ImportExport_Model_Abstract you will see that it has a method addLogComment. Now what this does is add log information at some time during the import and export process, ...
user avatar
4 votes
Accepted

How to export all the products that are not assigned to any category?

// First You need to get the collection of all product based on the category array having products. $collection = Mage::getModel('catalog/product') ->...
user avatar
  • 4,780
4 votes
Accepted

Upgrade from Magento 1.5 to 1.9

We don't know how your database looks. Modules could have put extra keys, dependencies, etc. I would suggest using a clean install like you are doing and you are going to have to debug these errors. ...
user avatar
  • 3,363

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