Questions tagged [export]

Denotes questions related to export in Magento.

Filter by
Sorted by
Tagged with
1
vote
1answer
156 views

Exporting over 30k products to .csv

I need to get a .csv file of all products (over 30000) from a Magento 2 store. Problem is when I start the export from backend, Magento dies after a few minutes and throws 500 error. Any idea how can ...
1
vote
1answer
231 views

Export products using cron job Magento 2.1.x

I need to export products several times a day using cron job. I have little experience with Magento 2.1 and I don't know how to develop the script. I hope you can help me. Thank you.
1
vote
1answer
986 views

Magento 1.9 - Catalog -> Manage Products not Exporting All Products To CSV

I am having an issue where exporting products under Catalog -> Manage Products in the admin panel is not exporting the entire product collection to a CSV. It is only exporting a small number of ...
0
votes
1answer
510 views

Export then import products with images to different server

I only have admin panel access to magento 2 site. I need to export all products to a new site on different hosting where I have full access. I ran a product export but the image URLs are local paths ...
0
votes
2answers
2k views

Entire database is not exporting from phpmyadmin in Xampp

The database is not exporting completely from phpmyadmin in my local server xampp. Please tell me the way to export the entire database.
1
vote
2answers
105 views

Export products by name

I am usign Magento 1.7. I have a store with thousands of products, but I only need to keep some of them. I have a list of the names of the products that I need to keep. Which is the best way to only ...
2
votes
1answer
91 views

invalid backend model specified: giftcards/product_additionalprice in magento 1.8

I am using Magento 1.8 and trying to export all producta in System->Import/Export->Dataflow - Profiles. In Profiles i choose Export All Products and Run Profile. But it shows error as below ...
0
votes
1answer
607 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. <?...
1
vote
1answer
229 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 ...
2
votes
0answers
662 views

Magento 2 Export Button CSV and XML Catalog Product Problem

I added Export Button to the grid catalog but still the following problem appears : Exception #0 (Magento\Framework\Exception\LocalizedException): A joined field with this alias is already declared. ...
8
votes
4answers
392 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
59 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
63 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
2k 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 ...
2
votes
2answers
495 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
96 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('...
0
votes
1answer
906 views

CSV export in product grid not exporting all the records

I have overridden Mage_Adminhtml_Block_Catalog_Product_Grid and added the export functionality like below : protected function _prepareColumns() { $this->addExportType('*/*/exportCsv', Mage::...
1
vote
1answer
502 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 ...
4
votes
1answer
2k views

How can i run system->import/export->export by Command ssh

I get no valid data send error during product export via system->import/export->export. Actually this because of time out error. How can run this export by command ssh.
4
votes
4answers
2k views

Magento 2: how can I remove columns in exported csv from order grid?

I want remove columns while exporting order grid data in magento 2. I google it but didn't find solution. Like I want to remove these fields from exported csv. Payment Method Total Refunded Customer ...
1
vote
1answer
2k 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 ...
1
vote
1answer
166 views

Magento to QuickBooks Integration

Looking to export invoices from magento and import them into QuickBooks. It doesn't matter which version of QB but please reference Magento 1.9 solutions, if possible. Has anyone built a module for ...
-1
votes
1answer
436 views

Products Export Not working | Both Default export and Custom Script export

I can't able to export my products both using default export and custom script export of product, Actually my site consists 1 lakh products, how can i export my products. error : Fatal error: ...
3
votes
1answer
166 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/...
-1
votes
1answer
234 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
107 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
59 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
59 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. ...
6
votes
1answer
5k views

Magento 2 - How can I import / export categories from M2 to M2?

I'd like to import and export using two Magento 2, among two environments. I know that I can't do it natively, so how can I do using MySQL or some free tool?
0
votes
1answer
147 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 ...
1
vote
3answers
291 views

Product Export Show Error

How to download csv in my local system....? controller.php public function exportmeAction(){ try{ $products = Mage::getModel("catalog/product")->getCollection(); $products-&...
2
votes
1answer
933 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
529 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
531 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
1
vote
1answer
219 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 ...
0
votes
1answer
621 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
2k 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
268 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)...
0
votes
2answers
588 views

Unable to export product CSV “No valid data sent”

I am trying to export products using System -> Import/Export -> Export After selecting Export Settings and click on Continue, I am getting No valid data sent. Looking in the system.log It is showing: ...
1
vote
1answer
88 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
394 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
158 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 ...
0
votes
1answer
1k 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. ...
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
328 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.
0
votes
1answer
122 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 2 3 4 5 9