Questions tagged [export]

Denotes questions related to export in Magento.

Filter by
Sorted by
Tagged with
3
votes
4answers
1k 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
0answers
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
156 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
430 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
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/...
-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
102 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. ...
6
votes
1answer
4k 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
141 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
281 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
810 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
490 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
501 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
217 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
578 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
249 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
553 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
82 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
376 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
157 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
969 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
321 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
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 ...
2
votes
1answer
2k views

Magento 2 - Script for exporting orders

I'm looking for a script that allows me to retrieve the list of orders for 6 months with the products sold. The csv file should look like this: Salutation,First Name,Last name,Email,Transaction Id,...
1
vote
0answers
362 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
1
vote
1answer
382 views

Magento 2 : How be able to export csv from admin as nonadministrator?

If you logged in as nonadministrator and try to export any CSV from grid level it will show access denied this issue is not there in 2.1.0 onwards but exists in 2.0.8 and below How to fix it?
0
votes
1answer
753 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 ...
0
votes
1answer
78 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
534 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
1answer
211 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 ...
1
vote
0answers
556 views

Magento2: Import Export to update multiple product attribute settings?

Can I use Magento2 's Import or Export features under Settings in the Admin to make this change: "Storefront Properties - Allow HTML tags on Storefront, change to Yes" for multiple product ...
0
votes
1answer
182 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
48 views

I want to move all my products and their attributes to my new store

What is the best way to accomplish this? Please don't just say "magmi". Additionally, my dataflow profiles do not work on my local/vagrant build. It just keeps timing out. Is there a way to do it ...
0
votes
2answers
261 views

Export products to csv/excel for comfortable view additional attributes

When I do export of products to csv all 'additional_attributes' are in one column. This is not comfortable to read for client or content manager via MsExcel for example. Need that all the custom ...
1
vote
0answers
583 views

Export group prices - CSV vs. Dataflow

We want to be able to export specific product data in MS XML Format using Dataflow. I realized it does not export group prices, whereas the CSV standard export does this. I couldn't see any option to ...
-2
votes
1answer
1k views

How to Scrape Product with category from Magento based site [closed]

I need to copy around 19000 product from site 123inkjet.com. But I have some issue , I can extract category easily. Only issue in product , I used online extractor tools like http://webscraper.io/ , ...
0
votes
2answers
242 views

Export script: walking through a product collection and get associatedProducts from grouped

Hey guys... I've been working on an export script which later on should fit for MAGMI import. It will/should include category and position (which I already worked out) and associated products of ...
0
votes
2answers
988 views

Export all categories & products then import them

I have a website with categories & products. Some of the categories & products also have images attached. I want to: Export all the categories & products. Delete all the categories & ...
0
votes
2answers
3k views

How can i increase default magento execution time in all format

I can't export my bulk products, both system->import/export->export and system->import/export->data flow-> , both process not working properly, but when i export db from my server and ...
3
votes
2answers
3k views

Export functionality of Custom UI grid in Magento 2 not working

When I tried to export data to Csv or xml from ui grid in magento2 it says: 1 exception(s): Exception #0 (Magento\Framework\Exception\LocalizedException): Invalid UI Component element name: '' I ...
0
votes
2answers
650 views

Export products from Magento 1.6 and import products in Magento 2.0.9

I need to import lots of configurable products to my new Magento 2. But if I export a CSV File and import in Magento 2 I get 1000s of errors. The File is different than a CSV I export from Magento 2....