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
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 ...
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() ...
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 ...
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 ...
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 ...
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)
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 ...
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('...
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 ...
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/...
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 ...
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 ...
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 ...
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 ...
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()
{
/...
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 ...
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 ...
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/...
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" ...
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 ...
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.
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 ...
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/...
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-...
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.
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('\...
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, ...
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')
->...
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. ...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
importexport × 435magento2 × 140
import × 114
magento-1.9 × 105
csv × 69
export × 65
product × 33
database × 30
magento-1.8 × 24
dataflow × 21
product-images × 19
magento-2.1 × 17
product-attribute × 17
configurable-product × 16
customer × 15
import-products × 15
magento2.3 × 13
magento-1.7 × 13
magento-1 × 13
attributes × 11
image × 11
avs-fastsimpleimport × 11
error × 10
php × 9
magmi × 9