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
- 361
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 ...
- 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 ...
- 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 ...
- 65.4k
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 ...
- 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)
- 65.4k
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/...
- 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/...
- 5,481
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 ...
- 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 ...
- 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()
{
/...
- 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 ...
- 4,502
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 ...
- 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" ...
- 490
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.
- 3,649
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 ...
- 1,567
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/...
- 27.1k
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-...
- 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.
- 65.4k
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 ...
- 6,093
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('\...
- 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 ...
- 1,612
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 ...
- 3,806
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.
...
- 65.4k
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 ...
- 65.4k
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');
$...
- 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 ...
- 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=",...
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 ...
- 715
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 ...
- 1,180
Only top scored, non community-wiki answers of a minimum length are eligible