Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [dataflow]

Questions about the (deprecated) import and export feature: dataflow and dataflow advanced profiles

Filter by
Sorted by
Tagged with
19 votes
12 answers
13k views

What is the most common process for importing the products?

What is the most common process for importing products? Does everyone use the product import/export tool? The CSV file format is not something that the client is likely to fill in and if they try it ...
stewrat's user avatar
  • 301
16 votes
5 answers
26k views

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

I want to import all the categories in magento using CSV file, I tried to do using extension http://www.magentoworks.net/importexport-magento-category-extension/ it works but i want to do it using ...
Swetha's user avatar
  • 707
13 votes
9 answers
29k views

Delete multiple products in Magento

Is there any way to delete multiple products by filtering with SKU? I have around 1000 products that I want to delete.
Kevin S's user avatar
  • 169
8 votes
3 answers
20k views

Skipping import row, required field "sku" is not defined

During article import of a custom import profile (Dataflow - Profiles) I get this error for all rows: Skipping import row, required field "sku" is not defined. I have mapped "sku" => "artnr" (Field ...
PiTheNumber's user avatar
  • 3,234
7 votes
3 answers
19k views

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

I am looking for the right flow of data of how Magento wants me to do it. I have some data which I want to pass to the view. How do I do this the right way? I saw the following answer for Magento 1.x ...
Akif's user avatar
  • 1,541
7 votes
1 answer
10k views

What is the difference between Import/Export vs Dataflow

So, I'm using Magento 1.6.2.0 on a project and I'm seeing I have options for import, export, and dataflow profiles. In previous versions I've used the interface has been like the dataflow profiles. ...
BVBAccelerate's user avatar
6 votes
1 answer
2k views

Filling fields forms in backend from two different tables

Currently, we have several forms that allow to edit/delete information, each one loading the data from one particular table. But what I want is to be able to load on the Form.php information from ...
Yaroslav's user avatar
  • 752
6 votes
0 answers
154 views

Magento 1.9x - Include Dataflow Profile Functionality for Import operation into my custom module

I have created custom module for import operation by uploading csv, xls and ods files. It is working good, but now i need to include Dataflow Profile Functionality into my module. That means I have a ...
Priya Ponnusamy's user avatar
4 votes
3 answers
5k views

Magento dataflow profile export - duplicate sku´s

after I updated my magento store to the latest version 1.9.2.1 I get into trouble regarding to the export of products with the dafalow profile export. With every export I got duplicate entries in my ...
Kevin's user avatar
  • 141
4 votes
2 answers
11k views

Importing Images via CSV in Magento

I am running Magento 1.9.0.1 and am having really bad issues with the Product Images showing on import via CSV. I have been researching this issue for 3 days with no luck. When I upload an image ...
Thatius's user avatar
  • 41
4 votes
2 answers
7k views

Import Customer Address

Magento's default customer import doesn't import customer address.All other info except address is getting imported. CSV header, website email,group_id,prefix,firstname,middlename,lastname,suffix,...
blakcaps's user avatar
  • 1,965
4 votes
1 answer
2k views

Importing product weights when multiple rows in CSV per product

Currently, practically every Magento import is yielding a frustrating experience in this particular project. Most product data is already in the system, configurables setup, each with all their ...
zigojacko's user avatar
  • 1,754
3 votes
2 answers
8k views

Magento Table Creation Using ORM Method

I'm trying to create a new table in the Magento database using Magento's *Varien_Db_Ddl_Table*. Using fresh Magento 1.7.0.2 CE install for this. I'm at a loss for syntax though. I'm trying to create ...
Jongosi's user avatar
  • 1,511
3 votes
2 answers
232 views

What is necessity of two separate database table for grid and normal

In Magento CE 1.7.0.2 in database there are two separate tables for example In case of order, data store in sales_flat_order and sales_flat_order_grid tables but if you see column then ...
Sandesh's user avatar
  • 1,649
3 votes
2 answers
7k views

Is it possible to get the QuoteId that was used once an OrderId has been created

I'm tracking customer movements through the order process by using their QuoteId Mage::helper('checkout/cart')->getQuote() - which is created as soon as a customer ads a product to the cart, ...
James's user avatar
  • 458
3 votes
1 answer
1k views

DataFlow Export Duplicate SKUs in SKU Field

I use the DataFlow Import/Export on a daily basis for updating product information. Last week we upgraded to the new 1.9.2 from 1.9.1 and besides the many other issues this upgrade has caused, now I ...
Nick Piro's user avatar
3 votes
2 answers
10k views

Importing and mapping custom data with dataflow

I want to parse a csv, map the fields, and do perform some custom logic with the imported data, but I can't seem to figure out the Profile Actions XML. The XML currently looks like this, along with ...
Erfan's user avatar
  • 3,117
3 votes
1 answer
862 views

Override Adminhtml importexport dataflow Profile Controller

I'm trying to override ProfileController located in app/code/core/Mage/Adminhtml/controllers/System/Convert/ProfileController.php I created a new module to handle that as following : app/etc/...
m.hyari's user avatar
  • 31
3 votes
1 answer
286 views

Magento Export/Import billing_vat

When I use dataflow profiles to export customers the exported CSV-file does not contain the customers billing_vat field. I only get the taxvat field. I believe I have to modify the parser to include ...
Nicolai Olesen's user avatar
3 votes
2 answers
8k views

Importing Product attribute values, an alternative method?

By default, when importing products into magento via csv file, and you want to provide values for attributes for those products, you have to enter the attribute codes in the first line of the csv file,...
user2231688's user avatar
3 votes
1 answer
628 views

What is the alternative way of DataFlow module for Magento2

Lot's of extension uses DataFlow module of Magento1 for data mapping and export/import product. Is there any way to handle data mapping in Magento2 for importing product?
Sohel Rana's user avatar
  • 35.9k
3 votes
0 answers
1k views

Magento dataflow profile - import products error - Please set available and/or protected paths list(s) before validation. [closed]

I tried to save the dataflow profile import products but i can't. I just receive the error "Please set available and/or protected paths list(s) before validation" After some code investigation i can ...
Haijerome's user avatar
  • 2,211
3 votes
2 answers
2k views

customer dataflow advanced profile export retrieve field updated_at in xml action with map name doesn't work

I am trying to export customers and want to export also the field updated_at which is in the table customer_adress_entity. As in the advanced profile dataflow export there is no choice to choose ...
caro's user avatar
  • 39
2 votes
4 answers
4k views

Bulk item delete via csv

i am a newbie in magento so dont know much about coding and scrippts, my problem is i have list of SKU's which are end of line now and has been replaced with new products. i want to delete them so i ...
shafiq's user avatar
  • 295
2 votes
2 answers
2k views

How to import products very fast into my site from csv file

I am beginner of Magento.. I have a CSV data sheet file that contains a lot of products. When I try to run using Dataflow, it takes too much time to import products from CSV into my store.. Do you ...
Joey River's user avatar
2 votes
1 answer
533 views

exporting with dataflow [closed]

I am trying to export products with dataflow -Profiles and want to export the field created_at which is in the table catalog_product_entity. The created_at drop down option from field mapping, In ...
Yehuda Schwartz's user avatar
2 votes
2 answers
685 views

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

I'm trying to update pricing for 2k+ items in our store. The problem: When done with the import, each product is setting the wrong values for both: "Apply MAP" - (defaulting to No) "Display Actual ...
naga's user avatar
  • 31
2 votes
1 answer
1k views

Unable To Save Or Run Import/Export Dataflow Profiles

I have recently started experiencing issues when saving or running any dataflow profiles in Magento. When trying to do so I get the following error message: Please set available and/or protected ...
Ryan Copeland's user avatar
2 votes
1 answer
1k views

Creating a New, Custom Filter for Dataflow Exports

I am trying to add some custom filters to the Dataflow export in Magento. First up, is exporting products with no images. I created app/code/local/Mage/Mycompany/Model/Catalog/Convert/Adapter/Product....
Tyler V.'s user avatar
  • 2,987
2 votes
1 answer
978 views

Dataflow - Profiles : How to check failed products in import all product

I have created CSV file and run profile. Some products failed due to image not found issue. I want to find out which products have failed in the process. Are there anyway to echo sku for failed ...
cha's user avatar
  • 341
2 votes
1 answer
215 views

Magento 1: how to use the DataFlow import view with a custom import?

So I have a custom module that imports entities from various sources (CSV, XML, API). At the moment, it's working perfectly fine, however I would like to improve user experience with the module by ...
Raphael at Digital Pianism's user avatar
2 votes
1 answer
2k views

Dataflow Batch UTF-8 Conversion

Magento comes with the Mage_Dataflow_Model_Batch_Abstract class, which has this method: /** * Set batch data * automatic convert to serialize data * * @param mixed $data * @return ...
Tyler V.'s user avatar
  • 2,987
2 votes
2 answers
229 views

Event is not firing up after the 2-3 hour long import process

I again ran into a weird issue. I have registered an observer for an event that is firing up when the Advance data flow profile finishes its execution completely. I have checked this successfully when ...
Ravi Soni's user avatar
  • 1,515
2 votes
0 answers
797 views

Custom csv import using data flow profile not working in magento-1.9.3.1

I want to custom import csv in a model using data flow profile. For that i have followed below steps : 1) Created a customimport.csv under var/import 2) Under admin > system >Import/Export >...
Manashvi Birla's user avatar
2 votes
1 answer
1k views

How to import configurable products?

We have imported the simple product using system -> Import/Export -> Dataflow profile -> Import All Products We want to associate this product with configurable product. How we will ...
Kishor Hase's user avatar
2 votes
0 answers
164 views

Unusual CSVs Showing Up in Var/Export [closed]

Recently, we noticed there are 4 files being constantly exported to var/export. It contains what appears to be billing/payment info for customers - even though our Magento store doesn't store any ...
Terry2015's user avatar
2 votes
1 answer
934 views

1.9.0.1 dataflow import customers. Different results when ran from browser or shell

I'm magrating to Magento, and I have a large amount of customers to import. I am using the dataflow profiles because more fields are available. The problem of importing dozens of thousands of ...
Calman's user avatar
  • 21
2 votes
1 answer
327 views

Import Products Dataflow Profile - 500 server error in console

I've successfully exported my products. I made a few changes to the file (new sku, new product name), saved the file with a new filename and want to import the csv file. This is what it shows my on ...
Tom's user avatar
  • 143
2 votes
1 answer
916 views

Import Product Data w/ CSV from command line (not dataflow)

I've updated a development version of my store to 1.9.2.4 from 1.7.0.2. I noticed that a plugin I used to handle inventory updates from the command line no longer works. I have over 15K products and ...
csm232s's user avatar
  • 121
1 vote
2 answers
7k views

How to create a custom import in Magento 2

We need to create a custom data import in Magento 2. In Magento 1 we used to use the Dataflow model to implement our custom imports. In Magento 2 there are no 'advanced profiles' but an 'Import' ...
PauGNU's user avatar
  • 722
1 vote
1 answer
5k views

Export Product CSV with Tier Price

I would like to create a CSV with product default data and also tier price. Is it possible to use DataFlow ? In alternative I would like to use a custom script with direct query to DB, can you help ...
Fra's user avatar
  • 6,985
1 vote
1 answer
565 views

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

Can anyone please tell me How to Create New Magento Dataflow advanced profiles during extension installation in Magento 1.9.x?
Magento Team's user avatar
1 vote
2 answers
4k views

Migrating All Product Images in Magento from PNGs to JPEGs

As we have found our website is using PNG images and has page sizes ranging from 1 MB up to 2 MB sometimes, I did a comparison using small images.. and have found PNG size is 36 KB, while JPEGs with ...
Oleg Smirnov's user avatar
1 vote
2 answers
1k views

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

its me again. My question was not solved yesterday after working a lot of hours figuring it out i could import products without errors. But the new error now is, those imported products are shown ...
Orion's user avatar
  • 151
1 vote
1 answer
2k views

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

I am looking to import multiple product images into Magento using Magmi, however I cant seem to find a way to import the product image sort order attribute along with the image. Does anybody know the ...
Ryan Copeland's user avatar
1 vote
1 answer
1k views

dataflow advanced profiles export with custom decimal separator

I need to change dot to comma on product price when I export using dataflown advanced profile. I tried this way: ... <action type="dataflow/convert_parser_csv" method="parse"> <var name=...
Eduardo's user avatar
  • 895
1 vote
1 answer
685 views

Import legacy data into Magento (Historic customer records)

I would like to ask for some advice on the best way to import historic customer data including usernames & passwords into Magento. The legacy data contains some 3 million records so we imagine it ...
user1704524's user avatar
  • 2,483
1 vote
3 answers
9k views

Dataflow advanced export filter by category

I want to filter the exported products by category, but what I have isn't working: <action type="catalog/convert_adapter_product" method="load"> <var name="store"><![CDATA[0]]>&...
localhost's user avatar
  • 131
1 vote
2 answers
698 views

"Image does not exist" Error when doing a Dataflow - Profiles import

Magento 1.9.1. --) Magento 1.9.4 I am setting up a newer version of our store on a different hosting account. I need to export PRODUCTS. I have tried to do a regular EXPORT and IMPORT but that just ...
Allysin's user avatar
  • 260
1 vote
1 answer
252 views

Product Export - Dataflow Profiles takes to 500 error page

I'm trying to export products from Magento 1.8.1.0 but when I go to the following location, it just comes with a 500 page error straight away. System > Import / Export > Dataflow - Profiles I ...
Callam Warner-Billington's user avatar