20 votes
Accepted

Delete multiple products in Magento

The fastest way to do it is to run this query directly. DELETE FROM `catalog_product_entity` WHERE `sku` IN ('SKU1', 'SKU2', ...., 'SKU1000'); Everything should cascade nicely. attribute values ...
user avatar
  • 196k
19 votes

Delete multiple products in Magento

All due respect to Marius, but please don't interact with the database directly if it's at all avoidable. Maybe the related tables will be updated automatically, if your release of Magento and all ...
user avatar
  • 1,131
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

Magento 2: How to get data from controller to block/view

One approach is to use the registry so in your controller class you put it in the registry, and then in your block you can retrieve it. <?php namespace <Vendor>\<ModuleName>\...
user avatar
  • 3,210
7 votes

Delete multiple products in Magento

You can do it programmatically. Create a skustodelete.csv listing all skus to be deleted and after that here is the code to proceed further require_once 'app/Mage.php'; Mage :: app("default")-...
user avatar
  • 493
6 votes
Accepted

Magento dataflow profile export - duplicate sku´s

Fix from above comment worked. Try this: https://github.com/baconl/Magento-1.9.2.X-duplicate-sku-export-fix Its a temporary fix until the magento core team fixes it, – baconl
user avatar
  • 141
5 votes

Importing Images via CSV in Magento

If you want to import images into Magento, use ImportExport with the following sample CSV: sku,_media_image,_media_attribute_id,_media_is_disabled,_media_position,_media_lable,image,small_image,...
user avatar
4 votes

Import Customer Address

For people using a Dataflow Profile to import customer addresses, don't forget to add the country code (billing_country or shipping_country) and a post code (billing_postcode or shipping_postcode). ...
user avatar
4 votes

Delete multiple products in Magento

Kevin S, you can delete product by csv file. Just follow the billow step Step 1 : Create a csv file and past the skus which you want to delete from system. Give the file name as skus.csv Step 2 :...
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 ...
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. ...
user avatar
4 votes
Accepted

How to create a custom import in Magento 2

You can create a custom import with Magento 2. You can based on the CatalogImportExport or CustomerImportExport Magento module which is based on the ImportExport Magento module as a reference. ...
user avatar
3 votes

Getting Fatal Error from Cron php script but runs 100% in browser

When you running this script via cron - first you must change directory to script directory, so yoou must do cd /home/#######/public_html/custom_scripts/ first and then run script so cron command must ...
user avatar
  • 77
3 votes

Importing Images via CSV in Magento

Generally you create a new product with images, export using dataflow and check the way images are displayed. copy that way and it will work. generally-> _media_attribute_id – this is the attribute ...
user avatar
  • 989
3 votes

Delete multiple products in Magento

The none code way In the admin section under Manage Products would will find a grid with all your products. There is a column called SKU. Here you can filter your products based on the value. Then ...
user avatar
3 votes

DataFlow Export Duplicate SKUs in SKU Field

When you update to Magento 1.9.2.X you will have this problem. If u use the app/code/core/Mage/Catalog/Model/Convert/Parser/Products.php from a older version of magento it will fix your problem. You ...
user avatar
  • 183
3 votes
Accepted

exporting with dataflow

The created_at is a system field, like entity_id and a few others. See app/code/core/Mage/Catalog/Model/Convert/Parser/Product.php, more specifically in the constructor: public function __construct() ...
user avatar
  • 1,216
3 votes

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

I had this very same issue when I started to convert/migrate and old Zencart to Magento. I wrote a little script that kept the originl id's and sorted them back into Magento. You my want to have a ...
user avatar
3 votes

How to Create Magento Dataflow advanced profiles during extension installation in Magento 1.9.x?

This can be done using a data installer. To learn more about the basics of those please check out this Inchoo Article. Now for the business end of the data installer; we create a new file in the ...
user avatar
  • 37.4k
2 votes

Dataflow/Magmi/Pricing - How to set "use config" for certain fields?

you can add following columns to your CSV file while importing through Magmi/Magento dataflow. For Apply Map msrp_enabled and value for this column for "Use Config" should be set to 2 Display ...
user avatar
  • 356
2 votes

Creating a New, Custom Filter for Dataflow Exports

This is how I eventually solved my problem: class Mage_Mymodule_Model_Catalog_Convert_Adapter_Product extends Mage_Catalog_Model_Convert_Adapter_Product { /** * Load product collection ...
user avatar
  • 2,957
2 votes
Accepted

dataflow advanced profiles export with custom decimal separator

You can't just add arbitrary attributes in the XML declaration; there has to be PHP which processes them. You need to rewrite the Mage_Dataflow_Model_Convert_Parser_Csv::getCsvString() method to ...
user avatar
  • 16.6k
2 votes

Export Categories with their ids to another installation

The only way to do this is by exporting the relevant category tables and importing them in your new database. I wouldn't recommend this practice, however. Magento is very finicky about its database ...
user avatar
  • 841
2 votes

What is the most common process for importing the products?

Magmi has a learning curve, but once you adjust it's hard to use anything else. It's made for developers; you've been forewarned. http://sourceforge.net/projects/magmi/
user avatar
  • 21
2 votes
Accepted

Dataflow export product entity_id

Ok i did this on magento 1.6.2 (it may be different in your version, but likely not) Firstly edit: app/code/core/Mage/Catalog/Model/Convert/Parser/Product.php find: if (in_array($field, ...
user avatar
2 votes
Accepted

Import Product Image Sort Order Value Using Magmi Or Other Import Tool

The image processor is required if you wish to import images against your products. This plugin has several advanced features that are explained below. This document refers to Image Attributes ...
user avatar
  • 7,199
2 votes

Bulk item delete via csv

I don't believe dataflow will let you delete product - but you could go that route to set specified products to "Disabled". You could then filter products by status and batch delete them via admin -...
user avatar
2 votes

After Importing Products, Products are not editable and also not visible

I've found the solution. I took the link of a not shown product guided by this: If your products are showing in the database, so try to do the following: Go to catalog -> manage products. Your ...
user avatar
  • 151
2 votes

Magento Export/Import billing_vat

You have to modify app/code/core/Mage/Customer/etc/config.xml and to add in node <customer_dataflow> this: <vat_id> <billing>1</billing> <...
user avatar
  • 2,770
2 votes

Magento Dataflow import issues german

As @Thomas already points correctly. Create a export and fill as much fields as possible. Magento import will also complain about some required fields at the moment. The first row needs to contain ...
user avatar
  • 2,948

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