Questions tagged [export]

Denotes questions related to export in Magento.

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
135 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
271 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
719 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
454 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
465 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
207 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
538 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
237 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
519 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
79 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
335 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
154 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
848 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
305 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
110 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
318 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
356 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
739 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
74 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
500 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
197 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
553 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
152 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
1answer
230 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
569 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
1answer
213 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
891 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
2k 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
635 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....
0
votes
1answer
735 views

Exporting Full Custom Grid Data

Trying to export the full grid data of a custom module. The function itself works but there's a limit of 20 (well a limit of how many rows are visible on the page). I need to export the full data from ...
2
votes
2answers
2k views

Programmatically Export Sales order customer details to excel format

I tried to export sales order customer details, its working fine, but i want customer country code(country name) not id. below i mention my full code. <?php require_once("app/Mage.php"); Mage::app(...
4
votes
2answers
622 views

How to add Select All option in Export Settings of Magento 2

I want to export one attribute of product. For this I have to select all other attributes one by one for excluding. Can anyone please tell me How can I add the Select All option to select all the ...
1
vote
1answer
477 views

How to export CMS Page data in Magento 2

I have added a custom attribute to CMS Page in magento 2. Can anyone please guide me How can I Export the value of that attribute of each CMS page through Custom Module? Thanks
2
votes
2answers
2k views

Export products by category name instead of category id

How can i export my products by category name instead of category id,
2
votes
0answers
1k views

Magento 2 admin customer grid export to csv with custom fields

I need to modify the columns in the customer csv file generated by the Ui module in magento 2. The problem is that the csv file is generated in a generic class of Ui Module, and not from the customer ...
1
vote
0answers
71 views

Exporting Multiselect Attribute not working properly in magento

I am facing one issue that is....I have one product in which I have one multi select attribute & I have selected 2 values in that. Now when I am exporting that product from System -> Import/Export ...
1
vote
0answers
253 views

Magento Bug :: Import stuck

I have try to import values of attributes, in my excel contains 60 of records, but only 43 records imported, what about my remaining values.
1
vote
1answer
57 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
517 views

Custom admin grid Excel XML export - result contains no rows data, only columns names

I created custom admin grid in my module. And CSV Export for it works fine, but Excel XML Export does not contain any rows data <?xml version="1.0"?> <?mso-application progid="Excel.Sheet"?&...
0
votes
1answer
39 views

What are the possibilities of error for not Export and Import [duplicate]

I have a problem of export and import in my site, error are : system - import/export - export : http://i.stack.imgur.com/C5y2X.png system - import/export - dataflow profiles - export all ...
2
votes
2answers
3k views

How can i solve 500 Internal Server Error during only product export [closed]

I try to export my whole products, i get 500 Internal Server Error during only product export. Export : Export Error : Note : When i try to export minimum of products like 100's of products, ...