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 ...
- 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 ...
- 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 ...
- 3,544
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>\...
- 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")-...
- 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
- 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,...
- 3,544
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). ...
- 255
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 :...
- 1,592
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,786
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.
...
- 64.9k
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.
...
- 2,906
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 ...
- 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 ...
- 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 ...
- 27k
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 ...
- 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()
...
- 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 ...
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 ...
- 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 ...
- 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 ...
- 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 ...
- 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 ...
- 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/
- 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, ...
- 624
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 ...
- 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 -...
- 1,403
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 ...
- 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>
<...
- 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 ...
- 2,948
Only top scored, non community-wiki answers of a minimum length are eligible