Questions tagged [export]

Denotes questions related to export in Magento.

167 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
0
votes
0answers
20 views

What does the following fatal error mean please when I try to export products to a CSV file?

The below comes up when I use the admin panel system and currently on Magention version 1.9.1.0 Open Source Fatal error: Unsupported operand types in /home/fxxxxs/public_html/app/code/core/Mage/...
0
votes
1answer
41 views

Magento 2: PHP script exporting to csv will not export values for Backorders

I'm using Magento 2 as PIM for other shop solution. I need to export the backorders value once per hour until we have made an API. The script below works fine, but values for 'backorders' are not ...
0
votes
0answers
17 views

Exporting Products with their website specific attributes

I have a product that has Tax Class "Taxable Goods" on one website A but has Tax Class "None" on a website B. When I export it it comes out with 'tax_class_name' as 'Taxable Goods'. I was expecting ...
0
votes
0answers
65 views

Sync/Export orders to google spreadsheet

Can anyone help with a solution through script or extension to automatically export/sync data to google spreadsheets such that whenever an order is placed, it instantly adds the data to the sheets on ...
0
votes
0answers
29 views

Export Csv Content Magento 2

Is there any way to export the values of "Description" for Default Store View into a csv ? I run a export but it is showing only the Description content of the Default Scope . Im able to see the ...
0
votes
0answers
17 views

Attribute collection for orders export

I was trying to implement a way to export Orders from the System->Export backend page but I can't understand where I can find the attribute collection for the orders. I followed the answer on this ...
0
votes
0answers
66 views

Export All Products From Magento to XML File

I'm trying to export all our listed products from our magento site to an XML file - appears the only option via admin site is to do this via CSV - this comes out unreadable. Can you advise?
0
votes
0answers
40 views

No valid data sent magento product export

Trying to export products from Magento using system import-export function and getting the error no valid data sent Initially, I was trying to export a few thousand products I then tried to export ...
0
votes
1answer
107 views

Magento 2:- How to add order export feature to seller dashboard?

I'm using Marketplace and there is separate dashboard for each seller from where seller can manage their sections e.g-products,stores,orders etc. for now,on order grid seller can't export the order ...
0
votes
0answers
43 views

How to export all attributes ad its options to Maganto 2 store by using magento 2 connector with Akeneo PIM?

In PIM akeneo dasboard, after exporting products with all attributes and its options, Magento 2 store is not receiving all the attributes options. I have already set all the setting: 1)in PIM ...
0
votes
1answer
36 views

Add 'Select All' option to Export screen in Magento 2 admin

In Magento admin, under System > Export the user can select individual attributes to be excluded from the export. I'd like to add a 'Select all' link that would select all options. This question was ...
0
votes
0answers
135 views

How to add new column in order csv export

I am trying to add a new field called quantity to the order csv export, but I am not able to do it. With all the other fields that get exported, I want another column called quantity which shows the ...
0
votes
1answer
473 views

Custom Product export in Magento 1

I want to Product export. But I need Only data which I need. For example, I need not "gift_message_available" attribute value. So Please tell me what I should I have created the profile. but When I ...
0
votes
1answer
36 views

Display Multidimensional Array of Custom Options from order

I created a script to export order information into a CSV but I'm unsure on how to display the contents of the array. What I'm trying to do is capture the custom options selected for a given order and ...
0
votes
0answers
106 views

How to migrate categories from Magento 1.9.1 to 1.9.4? Also - Will EXPORT of products and customers work?

Magento 1.9.1 to Magento 1.9.4 We are setting up again and I can't figure out how to migrate categories from our old (live) Magento 1.9.1 site to the new 1.9.4? Is there a way to do that? I will ...
0
votes
0answers
118 views

CSV Export missing the custom column field added by renderer magento

Because my grid has a problem when join table, so I used renderer to show data like this 'brand' => array( 'header' => Mage::helper('advr')->__('Brand'), '...
0
votes
2answers
452 views

export problem in magento 1.9

when i try to export my data from system>import/export>export when i select the product option and press on continue its start processing and after 120 sec it's show a error page that 500-internal ...
0
votes
1answer
767 views

Product export download is not working in magento 2.1.15

I am using AWS server. I tried to export the product from the back-end. But while downloading it showing Failed- Server Unreachable in chrome browser. Is that related to owner permission issue? ...
0
votes
1answer
31 views

How to export openERP invoices to Magento?

I successfully connected openERP to Magento. Now I am getting all the orders in openERP as sales orders, which we added in Mageno. Now I created invoices for that orders but how to export that ...
0
votes
1answer
126 views

Hide columns under condition when exporting csv

Fyi, I did read from another similar post where I came to a good solution (Setting is system true will prevent it from getting exported). However, my problem is I would like to have two type of csv ...
0
votes
1answer
93 views

Export magento orders per product

I need to export magento orders per product ( I want to get all the orders for a specific product) How could I do it?
0
votes
1answer
27 views

Exporting Orders with Full Details

I want to export all the orders till date (without using extension) with Following Details - Name - E-mail - Phone Can someone guide me on DB query to export the same? Default export in panel only ...
0
votes
1answer
34 views

How to export customer data programatically?

I need to export customer data programatically once in a day. I'm using php script to write the export functionality. I used, $bootstrap = Bootstrap::create(BP, $_SERVER); $objectManager = $bootstrap-...
0
votes
1answer
296 views

Grid csv/excel export not working

I currently can't export anything in the grids for products, clients and newsletters in my computer (and from another computer in another state). It downloads properly from my phone. When I click ...
0
votes
1answer
171 views

Magento 2export customer grid in excel format

How to export customer grid in excel format magento 2.
0
votes
1answer
337 views

Invalid UI Component element name: Export button not working?

I have created grid using ui component. <container name="page_listing_top"> <exportButton name="export_button"> <argument name="data" xsi:type="array"> <...
0
votes
1answer
725 views

Add custom column to the Order Grid for export

I want to add some custom field like sku to add in order grid to export along with the order. I follow this link Add custom product attribute to Order Grid to do this, but this didn't work in this ...
0
votes
1answer
118 views

product export from magento 1.9.3 no longer possible

I started with a magento 1.9.2 installation. It was possible to import/export the products with the magento funtion export/data profile/export all products. A few weeks ago, I upgraded to magento 1....
0
votes
1answer
284 views

How to export and import categories from MySQL

I am trying to export categories and import them back to another Magento database. Therefor I exported every table related to catalog_category_... and imported them into the other database. Now I am ...
0
votes
0answers
1k views

Exporting all products in a xml file

I would like to export ALL of my products and their fields into an XML file. I tried this but didn't work. I'm using Magento 1.9.
0
votes
2answers
242 views

Permission to access customer export

What do I need to do in order to be able to export a CSV of my customers? Getting the following Forbidden Error. You don't have permission to access /index.php/brandits_admin/customer/exportCsv/...
0
votes
1answer
71 views

Custom Products Export Code working in Localhost but not working in Live site

I have code for export like sku, category id and category path name of sku, code : <?php error_reporting(E_ALL | E_STRICT); define('MAGENTO_ROOT', getcwd()); $mageFilename = MAGENTO_ROOT . '/app/...
0
votes
0answers
148 views

Getting Please fix errors and re-upload file while csv product import Magento ver. 1.9.2.1

I am getting below error while product import from admin. As there is no particular error (mostly error in csv formats) i am not able to debug. File permission of media folder In Export of Products ...
0
votes
1answer
526 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
0answers
60 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
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 ...
0
votes
1answer
922 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::...
0
votes
0answers
536 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; --...
0
votes
1answer
626 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,...
0
votes
1answer
395 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
89 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
239 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 ...
0
votes
2answers
310 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 ...
0
votes
2answers
279 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
3answers
698 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
778 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 ...
0
votes
0answers
250 views

export action in custom admin is not working

Here is my code. Grid.php protected function _prepareColumns() { $this->addExportType('*/*/exportCsv', Mage::helper('repair')->__('CSV')); $this->...
0
votes
1answer
306 views

How to export from DB Sku - Order Number - Quantity Sold?

Does anybody know how to export from PhpMyAdmin the Quantity sold by products and by Order Number ? I've already found Sku and Qty Sold in the table Sales_flat_order but I really don't know how to ...
0
votes
1answer
358 views

How to add column in orders Excel xml export?

In magento backend it is possible to export the list of the orders in Excel XML format. I would like to add columns in this file such as the company name (present in the customer address) and the ...
0
votes
2answers
468 views

Update to 1.9.2.4 breaks custom Sales Order Grid mass Action

I have added a new mass action on the sales order grid. It worked flawlessly on all 1.9.x releases up to 1.9.2.4 upgrade from 1.9.2.2 so I suspect this is now broken by the new security features that ...