Questions tagged [export]

Denotes questions related to export in Magento.

Filter by
Sorted by
Tagged with
0
votes
1answer
592 views

Magento 2 Export Single Entry in CSV

While exporting (CSV) data from admin grid, if I select single entry, even though it is exporting entire sheet. I am not able to export single entry.using below code. Please suggest something. <?...
2
votes
2answers
450 views

How can i export fields like category name not category id via Dateflow-profiles export

I need to get my all products category name, actually dataflow profiles return category id only, how can i get category name not category id.
0
votes
1answer
113 views

After updating magento to 1.9.3.1 my site has error in export products

While exporting products i am getting blank section in entity attributes section as per in screenshot and getting below error in error log file: PHP Fatal error: Class ...
1
vote
1answer
222 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 ...
8
votes
4answers
388 views

State of the Art in Magento 2 Product Imports

Now that Magento 2's been out for a year plus -- what's "state of the art" in getting product information into the system? i.e. Are people still writing one-off import scripts? Is the native import/...
0
votes
0answers
53 views

Category name in dataflow

I am exporting my products for a Google Shopping feed and i need to get the category names in the CSV file. Is there any way to do this with dataflow profiles? Magento 1.9
0
votes
1answer
59 views

Magento2 - Multistore/domain export one website import in fresh install

I was wondering if it is possible to export a whole website (Including blocks, widgets, products, etc. which are enabled for that specific website) Lets say you have a multistore/domain setup which ...
0
votes
0answers
1k views

Magento2 - How to export order grid data programmatically?

I want to export my order grid's data programmatically. I am calling the execute method of /vendor/magento/module-ui/Controller/Adminhtml/Export/GridToCsv.php by passing necessary parameters, like ...
0
votes
1answer
93 views

How to export a specific order in Magento 1

I created a button to export a specific order from admin. This button apper on each order. Then i created a function that look like this: public function expButtonAction() { Mage::app('...
1
vote
1answer
454 views

Magento export mysql result to csv

I am trying to run two mysql queries and export the results into a CSV. My issue is the second query I have is being written to a new row instead of just onto the same rows that the result from the ...
1
vote
0answers
1k views

Magento 2 Product Export Problems “Please correct the data sent value”

Magento 2 Version 2.1.1 - I am intermittently getting the error "Please correct the data sent value." when trying to export product. Test results: Full Export no filter = Fail Filter by Country ...
3
votes
1answer
172 views

What is the best approach to mass updating prices?

What is the best approach to mass updating prices? We need to batch update pricing for almost 200 products in our catalog and would prefer to learn a more efficient method than individually editing ...
3
votes
1answer
154 views

Magento 1.9 - The export error after customizing grid on shipment page

I got a issue about export our shipment information. Before i start with this issue, i add the "shipping method"column, is called customizing column, on shipment grid! Like this, app/code/core/...
2
votes
1answer
985 views

Magento Export All Invoice In PDF

My accountant asked me an export of all my invoices at PDF (33972 invoice :/) . Is there a way to do it automatically ? Thanks
-1
votes
1answer
229 views

No Valid Data Send Error - During export products via System->import/Export->Export

I get error like "No Valid Data Send Error" during export products via System->import/Export->Export. Actually this is memory problem may be, how can i solve this error. Note : Duplicate Finder - ...
1
vote
0answers
98 views

Expoarting all products from backend

We have more than 40,000 products with attributes.When i tried to export from backend it throws an error 502 gateway error.Can you please suggest me one solution
1
vote
0answers
115 views

Magento 1.9.2.4 not exporting simple products

I've run into a weird issue where my Magento site (1.9.2.4) isn't exporting all my products. It successfully exports all my configurables, but that's it - none of the simple products contained within/...
1
vote
1answer
1k views

An error saying “You cannot define a correlation name 'payment' more than once” while taking export

I am trying to take an export of the orders in the magento backend but I am getting this error. Can anyone let me know How can I resolve this? a:5:{i:0;s:61:"You cannot define a correlation name '...
0
votes
1answer
57 views

Export customers to CSV with Store Name

I'm using this code to export customers to CSV. I would like to add an extra column that is the STORE NAME, and not the ID. "store_id" works but only shows the ID (a number). I would like to show the ...
0
votes
1answer
49 views

Administrator configuration menu limited. Can't uncheck “Use system value” case

I just updated magento to version 2.1.4 and this type of bug show off right after the update. (cf. screen) This error happens on every "Store View" form. Can you help me ?
0
votes
2answers
102 views

Magento 1.7 - Export New Orders in Observer

Every 30min I want to export all NEW orders, I don't want to re-export orders I've already done. Later I'm going to access these files to import into a third party program through FTP automatically. ...
1
vote
1answer
59 views

identifying index tables in Magento (1.4) and can they be skipped on export and rebuilt

I am familiar with the core data tables for products and categories, i.e. catalog_category_entity_.. and catalog_product_entity_.. I know also that there are some tables that flatten indexes and this ...
0
votes
1answer
938 views

“Product with specified super products SKU not found in rows:…” when reimporting just exported products to empty database

I exported all my single and configurable products to .csv and emptied my database of all products afterwards. I am now trying to reimport those same products using the just created .csv file. ...
0
votes
1answer
138 views

Automatically Export Sales

I'm running Magento 1.7 and am looking to set up a Cronjob (Very little experience with this) to export my sales orders every 30min and place them in a folder on my desktop. I only know how to ...
1
vote
0answers
1k views

Magento 2 exporting issue

I try to export my products in Magento 2.1.3. When i select to export products and csv files format and i press continue, a receive this message: Please correct the data sent value. And if i check ...
3
votes
2answers
5k views

Export Orders from Magento MySQL DB without Magento

I have an old Magento database file, but the files associated with it are gone. The database file is for Magento 7.02 I need to export the orders with the line items and a description of the item ...
1
vote
1answer
216 views

Can't find Magento attributes for Custom Export module

Downloaded and installed the Custom Export module from Connect, and works fine. However I want to add some include some more fields in the exported CSV. Currently, the template CSV file looks like ...
2
votes
1answer
782 views

How to remove export option?

By default, magento provides two options CSV and XML file format for the export. So how can I keep one of them for export in ui component based listing ?
0
votes
0answers
483 views

magento 2: cleaning customer and order info

I know a solution was posted for this in magento 1: Clearing Magento after testing I altered this to work for M2 tables, are there any tables I am missing? Magento 2 SQL SET FOREIGN_KEY_CHECKS=0; --...
1
vote
1answer
494 views

How to export store's csv that Excel will read properly?

In Sales > Orders when I export csv and open it in excel some characters are not encoded properly. e.g: ü is exported as: ü etc. Do suggest some solution to this problem. Thanks
3
votes
1answer
720 views

Export Related Products in Magento

I am using Magento 1.9.0.1 and i want to export the products along with the related products in the csv.In the magento export sheet i am not getting the related products column. I had googled but not ...
0
votes
1answer
572 views

How to set collection as content in csv file export

I am using magento 2.1 version. I am working to built export csv functionality on frontend. I am using below code: public function __construct( \Magento\Framework\App\Action\Context $context,...
4
votes
1answer
1k views

Admin Grid - Remove columns from export

I am in a situation, where I need to display an email_address1 in grid, and during export have to use other one (email_address2). For this I have added two columns in grid, with email_address1 is ...
2
votes
2answers
247 views

While Exporting CSV from Sales > Order Grid, I am getting error - “You cannot define a correlation name 'order' more than once”

When I try to export csv in Sales > Order Grid, I am getting You cannot define a correlation name 'order' more than once Trace: #0 /www/Myproject/htdocs/lib/Varien/Db/Select.php(281)...
1
vote
1answer
549 views

CDATA Issue when Filtering by Category using Advanced Profiles

Can you somehow indicate exact match within the "Character Data Block"? I'm trying to isolate ONLY products from Category (ID:4) but when I use (4) in the "Character Data Block" for Variable "Filter/...
1
vote
1answer
80 views

Call admin export product csv from code / URL

I'm looking for a way to call the magento export (System->Import/Export->Export) product export from an URL for a 3rd party system. So I want something like https://my.domain.com/bla/blub/export.php?...
0
votes
1answer
371 views

Export order from remote server

I need to export order form magento with remote scripts. When I work in local I use: require_once("/app/Mage.php"); Mage::init(); // Set an Admin Session Mage::app()->setCurrentStore(...
0
votes
1answer
155 views

Which is the best module to import/export automatically with cron

I am looking for a module which can permit me import & export by creating or updating if exist already : - product - customer - stock - attributes of product (import only) - categories (import ...
1
vote
0answers
14 views

During importing a previous export of products Configurable products don't have simple products any more

I exported all products and then cleared all products. When I try to import the same products, I can do this, but configurable products don't have th associated simple products any more. What happens ...
2
votes
0answers
320 views

add export functionality in custom grid (not ui grid ) Magento2

I have created a custom admin grid using 2 tables and that is working fine. This is not a UI grid, but a grid same as Magento 1. Please suggest me, how can I add a export feature in that.
1
vote
0answers
353 views

Magento 2 downloadable file in backend

I'm encountering a problem when using the native export module in admin. I'm using an admin account with a specific role that can only access to catalog and system / export If my first action is to ...
1
vote
0answers
1k views

Export my products for Facebook products feed

Is there a way to export my products from a certain category to create a CSV file to import into our Facebook page products? Results need to look like this
0
votes
1answer
751 views

Magento 2 Order Collection + Customer Collection

I want to make a PHP file to get Orders and Customers from a Magento 2 based webshop (like exporting). I have a full code for Magento 1, but for M2 I have tried a lot of things. I also needed this ...
1
vote
3answers
2k views

Export all product from dataflow- profile in magento [duplicate]

I want to export all product from with the help of dataflow profile in Magento. In my site I have 3000+ products. When I export product data from dataflow profile, it opens the new window and after 1 ...
0
votes
1answer
878 views

WooCommerce product&category import to Magento

I want migrate all product and category data from WooCoomerce to Magento. I have an woocommerce .csv export file, which contains all of necessary data. How can I convert this csv file to magento ...
0
votes
1answer
177 views

Export CSV in Shipping Rates doesn't work

I have Magento 2.1.1 in production mode. I go to: Stores -> Configuration -> Sales -> Shipping Methods. When I try to export the CSV example to upload the rathes, the system after 10 seconds ...
0
votes
1answer
77 views

Export Products, 1.9.2.4 not valid data - Media.phtml

I am trying to export products using Magento, i choose export, products and returns with empty attributes list, and i click continue it says Not Valid Data.... i have checked log and it says: 2016-...
0
votes
1answer
524 views

Custom csv export - customers

how can I add custom csv customer export and export only email and customer group? I need put this code to the own module.
0
votes
2answers
1k views

Export Products screen is not showing all attributes

We have a site running Magento ver. 1.7.0.2. On the Export admin screen, it used to show all the available product attributes on the screen like in the screenshot below however now it only shows up ...
0
votes
1answer
208 views

How do I export users and products from a Magento website from inside a module?

I am developing a Marketing(mostly email) extension for Magento, which requires that the users and products be imported into another third-party tool. How do I export this data from Magento to send it ...