Questions tagged [dataflow]
Questions about the (deprecated) import and export feature: dataflow and dataflow advanced profiles
108 questions
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 ...
- 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 ...
- 707
13
votes
9
answers
30k
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.
- 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 ...
- 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 ...
- 1,551
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. ...
- 133
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 ...
- 752
6
votes
0
answers
155
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 ...
- 735
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 ...
- 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 ...
- 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,...
- 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 ...
- 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 ...
- 1,531
3
votes
2
answers
240
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 ...
- 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, ...
- 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 ...
- 31
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 ...
- 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/...
- 31
3
votes
1
answer
289
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
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,...
- 31
3
votes
1
answer
629
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?
- 36.1k
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 ...
- 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 ...
- 39
2
votes
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' ...
- 732
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 ...
- 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 ...
- 95
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 ...
- 1,152
2
votes
2
answers
686
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 ...
- 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 ...
- 788
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....
- 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 ...
- 341
2
votes
1
answer
217
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
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 ...
- 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 ...
- 1,515
2
votes
0
answers
799
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 >...
- 8,853
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 ...
- 928
2
votes
1
answer
2k
views
how to give download link to var/export/export_customers.csv?
Normally after successful running export customers data flow profiles its saving data to var/export folder, but I want to download that file to desktop.
Can you give any suggestions?
- 2,023
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 ...
- 21
2
votes
1
answer
939
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 ...
- 21
2
votes
1
answer
330
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 ...
- 143
2
votes
1
answer
919
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 ...
- 121
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 ...
- 6,985
1
vote
1
answer
570
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?
- 749
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 ...
- 11
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 ...
- 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 ...
- 788
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=...
- 895
1
vote
1
answer
700
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 ...
- 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]]>&...
- 131
1
vote
2
answers
709
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 ...
- 280