Questions tagged [dataflow]

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

Filter by
Sorted by
Tagged with
19
votes
12answers
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 ...
15
votes
5answers
24k 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 ...
12
votes
6answers
24k 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.
8
votes
3answers
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 ...
7
votes
1answer
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. ...
6
votes
2answers
12k 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 ...
5
votes
1answer
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 ...
5
votes
0answers
140 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 ...
4
votes
3answers
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 ...
4
votes
2answers
10k 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 ...
4
votes
2answers
6k 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,...
4
votes
1answer
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 ...
3
votes
2answers
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 ...
3
votes
2answers
169 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 ...
3
votes
2answers
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, ...
3
votes
1answer
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 ...
3
votes
1answer
839 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/...
3
votes
1answer
274 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 ...
3
votes
2answers
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,...
3
votes
1answer
589 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?
3
votes
0answers
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 ...
3
votes
2answers
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 ...
2
votes
4answers
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 ...
2
votes
2answers
1k 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 ...
2
votes
1answer
501 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 ...
2
votes
2answers
639 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 ...
2
votes
2answers
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 ...
2
votes
1answer
959 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 ...
2
votes
1answer
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....
2
votes
1answer
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 ...
2
votes
1answer
171 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 ...
2
votes
1answer
1k 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 ...
2
votes
2answers
221 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 ...
2
votes
0answers
630 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 >...
2
votes
1answer
789 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 ...
2
votes
1answer
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 ...
2
votes
0answers
162 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 ...
2
votes
1answer
894 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 ...
2
votes
1answer
271 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 ...
1
vote
1answer
4k 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' ...
1
vote
1answer
4k 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 ...
1
vote
1answer
410 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?
1
vote
2answers
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 ...
1
vote
1answer
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 ...
1
vote
1answer
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=...
1
vote
1answer
609 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 ...
1
vote
3answers
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]]>&...
1
vote
2answers
3k 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 ...
1
vote
2answers
374 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 ...
1
vote
1answer
234 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 ...