Questions tagged [export]

Denotes questions related to export in Magento.

Filter by
Sorted by
Tagged with
0
votes
4answers
736 views

Export Products on a Category

Is there a way that I can export all products on a certain category via CSV or excel file?
0
votes
0answers
23 views

Export all product using custom script in Magento 1.9 [duplicate]

I have an export my all product with all data in the Magento 1.9, Using the custom script so how can I? Please suggest. Thanks.
1
vote
2answers
2k views

How can I export the product image URLs?

How can I export the product image URLs from Magento 1.9? I've used the import/export tool in Magento 1.9. The resulting CSV file contains no product image URLs.
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,...
0
votes
1answer
895 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 ...
3
votes
3answers
11k views

import custom csv to custom table- magento 2

My requirement is import custom csv file to custom table. please share hints and key points to achieve this? Thanks.
2
votes
1answer
109 views

Magento 2 : Currency Symbol missing when exporting Saler Order Grid

I am exporting Magento 2.1.9 Saler Order Grid to CSV and XML formats using the provided buttons. But when I open the file in Excel the currency symbol is missing in Grand Total (Base) and Grand Total (...
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 ...
2
votes
2answers
1k views

Magento 2 How to do export products csv & xml from admin end?

I would like to implement export catalog products functionality from admin end from custom module. I have followed below steps for displaying export button at admin end catalog > products but unable ...
0
votes
2answers
1k views

Magento2: Need help to create custom export

I'm creating a custom module(multi-vendor) where i need to create one feature where admin can export the product details(CSV) data along with vendor details (which is assigned to some specific product)...
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,
1
vote
1answer
26 views

Exporting products description (HTML) and short description (HTML)

I need to export these 2 products columns: description (HTML) and short description (HTML) to a CSV. So far I've been using the dataflow profile system with a personal columns mapping but I cannot ...
2
votes
1answer
700 views

Export file problem in magento 2.3.2

Error: "Message is added to queue, wait to get your file soon" enter code here Open admin panel/system/Data Transfer/Export After that select all export setting and click the continue button. When ...
1
vote
1answer
232 views

Can't Export Customers Error Please correct the data sent value

Magento 2.2.7 Trying to export customers and get the error, Please correct the data sent value. Exception log says, main.CRITICAL: Notice: Undefined offset: 14 in /home/public_html/vendor/...
1
vote
1answer
169 views

After updating from community version 2.3.1 to 2.3.2, unable to export products

After updating from version 2.3.1 to 2.3.2 community edition, I can not export products. The usual method - system - export, select entity type products, CSV format, fields enclosure checked, gives ...
0
votes
0answers
14 views

Determine which product has Enable RMA set to NO

I set one of my products "Enable RMA" to 'no'. I don't remember which one. How can I find it? I thought to do a product export and then find the column for the Enable RMA attribute. But it seems ...
1
vote
2answers
622 views

GrandTotal(excl. tax) and Payment Method in Admin >> Sales >> Invoice grid

I have Magento CE 1.9.2.1 installed in my site. Now I want to also include custom made columns "Grandtotal Excl. Tax" and "Payment method" to my Admin >> Sales >> Invoice grid and also include those ...
1
vote
3answers
656 views

Products Direct Export Not Working

How can I solve direct export error. My store consisting 20k products and I know it's huge. How can I solve this export error? max_execution_time : 99999999; max_input_time : 16000; memory_limit ...
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 ...
0
votes
1answer
94 views

MySQL Query for an export of all products?

Is there any way to find out a MySQL query that would give the same results as exporting all shop products? The reason I need this. When trying to export, I get the error Message is added to ...
0
votes
0answers
26 views

Add custom column to grid that can be exported

I want to add a column to sales order invoice grid, that should be exported as it is shown in the grid.The column is a calculated column, based on the row data, so there is no explicit database entry ...
0
votes
0answers
17 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/...
1
vote
1answer
88 views

How to override definition.xml file in Magento 2?

I am developing an extension to add another export format option in order toolbar in export button dropdown. What I found yet is that there are two options here (Sales Order Toolbar) right now: a) ...
0
votes
2answers
38 views

Magento 2 - Admin grid and export use different timezone

I'm using Magento 2. So, I created a Adminhtml data grid in a custom module. The problem is that the data grid doesn't match the exported data. I've set the timezone, but it seems data grid and ...
0
votes
1answer
33 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
2answers
329 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 ...
2
votes
1answer
1k views

export all products from magento 2 for import into magento 1.9 programatically

I have finally come to realize that Magento 2 is a way to buggy and unusable. I have 30,000 products and 1500 categories. What tables do I need to export in order to bring them in Magento 1.9? Also,...
1
vote
2answers
1k views

Bug in products export - Magento 1.9.2

I have a problem with exporting all products in magento 1.9.2.1. I want to export sku, name, price and manufacturer. It's okay but i have several lines for an unique sku. The first line shows the ...
6
votes
2answers
2k views

Magento 2 + Custom column added sku on grid not showing data in export file

I have added sku column on sales order grid using following steps, Package\Company\view\adminhtml\ui_component\sales_order_grid.xml <?xml version="1.0" encoding="UTF-8"?> <listing xmlns:...
0
votes
0answers
16 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 ...
4
votes
2answers
6k views

How to add export functionality in Magento 2 new grid system

In Magento 1 I could add export functionality to any admin grid I create by adding this $this->addExportType('*/*/exportCsv', Mage::helper('helper_alias')->__('CSV')); $this->addExportType('...
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....
1
vote
1answer
1k views

Please advise. How can I export all product images at once Magento 2.2.5?

I am having an product export issue with Magento 2.2.5. How can I download/export all of my product images (all at once)? They all are in different folders on server? Thanks!
0
votes
1answer
748 views

Export products in 3rd party system that does not share the same server

I need to export products from Magento to 3rd party CMS, let's say Wordpress. My store will look like this: I don't need to integrate systems (neither sharing sessions, nor customers) There ...
1
vote
1answer
220 views

Magento 2 admin grid first row empty issue

I have custom module and implemented custom grid. Everything working fine as expected. only issue with while export data, i am getting first row as empty. From second row on words showing column ...
0
votes
1answer
81 views

Export button in custom Grid Magento 2

I have created a custom grid and trying to add export button for it. here is the code i used in my listing.xml file. <exportButton class="Magento\Ui\Component\ExportButton"> <...
1
vote
1answer
50 views

Custom Export Report issue in Magento 2

I need to export the custom grid to the csv file. I have used the below code in my listing.xml file. <exportButton class="Magento\Ui\Component\ExportButton"> <argument name="data" ...
0
votes
0answers
24 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
1answer
679 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 ...
3
votes
0answers
60 views

Unirgy_RapidFlow export data to remote server

I want to export product/attribute data to remote server. it should create exported file to remote server. I have filled the data of my server in "[Remote Server][1]" configuration but when I "Run" ...
1
vote
0answers
36 views

Magento 2 customer export is giving me the error

I added one custom attribute with Yes/No option in customer grid and with that i'm unable to export the customer data, facing issue like below Fatal error: Uncaught Type Error: Argument 2 passed to ...
1
vote
2answers
157 views

How to transfer WooCommerce Orders to Magento in Real Time

I would like to transfer orders I get from WooCommerce into Magento. The reason is that I want to have one-click upsells/downsells and I can't find a module or anything for Magento that has this ...
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
1answer
809 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
2answers
175 views

Magento 2 Commerce cloud database export

I am new in magento commerce cloud. I need to setup the magento store in my local system. I have downloaded the files from the commerce git and it is working fine. But how can I access the database? I ...
3
votes
1answer
132 views

Magento 2 Export CSV on Sales Order Grid with Custom Fields

I succesfully added some custom fields on Sales Order Grid. If I export "Excel XML" is working fine but with "CSV" custom fields are blank. I have compared the following files: Magento\Ui\Model\...
4
votes
6answers
11k views

import/export error - magento 2.0.1

Firstly I export csv file from admin and keep only one row and delete the remaining row, after that I will change product name,category name and then import the file.I am getting the result in ...
0
votes
2answers
702 views

Error: Export orders to CSV - Correlation Name

I am getting the following error when trying to export orders to CSV but am none the wiser on how to fix it! EDIT: I am using an observer to add a Country column please see my module below, how can I ...
0
votes
2answers
954 views

Problem with quotation marks on PHP export

I could use your help once again... I'm currently building a php export to hand our products off to a comparison website. One of their requirements is that every string is wrapped in double quotes. I'...
0
votes
1answer
827 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::...