Questions tagged [export]

Denotes questions related to export in Magento.

163 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
4
votes
2answers
2k 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 ...
4
votes
0answers
174 views

Advanced Pricing Import Export issue

I am having an issue with the Advanced Pricing import. I am importing a new pricing file and I selected Replace as the action, but it is not replacing the file. There are 9,219 line items in the file ...
3
votes
0answers
72 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" ...
3
votes
0answers
43 views

How is generated default meta_titles?

I need to export all the meta_title used for each products, categories and brands. Magento automatically generates the meta_title when they are not set in the admin meta_title field. I would like to ...
3
votes
0answers
183 views

Magento 2 - Configurable product with multiple price attributes

I'm facing a dead-end with my configurable product and my simple products. Right now, i am struggling setting up my configuration prices in a way that make sense for my products. Since Magento 2 , ...
3
votes
2answers
505 views

Magento 2 SALES Order and REPORT Orders Export data qis inconsistent

Two different operating places in the background. Choose the same time (one day) for testing. The output is different. SALES Order count is same as my database query result. This is SALES Orders ...
3
votes
0answers
178 views

Data value is appearing instead of data label in grid export

I have an options array in below format. array (size=3) 0 => array (size=2) 'value' => string 'one' (length=3) 'label' => string 'Number One' (length=10) 1 => ...
2
votes
0answers
69 views

Magento 2 Export all coupon codes in the XML format

Like sitemaps, I wanted to export/ get all active coupon code/ cart rule in XML format. Please guide me how to do it?
2
votes
1answer
79 views

Add product custom attribute to order export?

Anyone has any clue on how to add custom product attribute to order export? Cant realy show any code, cause I have only been googling so far, as I have no clue on how to handle something like this. ...
2
votes
0answers
142 views

Export csv Not working for the custom attributes customer grid Magento2

Below showing code is my customer_listing.xml, export csv not working when selected checkbox's export from grid. <listing xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:...
2
votes
0answers
17 views

During Magento 2.1.12 Product Export,some attribute values for english store missing

There are 2700 products on the site & lots of product custom attributes.I've 2 stores "default" & "english" & when I'm exporting products then getting empty values for the store "english" ...
2
votes
0answers
100 views

Magento 2 add country field in order export

I need to add counrty field in order export Magento 2. Means when I click in export and csv or xml and Export button expected data with country name also. Thanks
2
votes
0answers
210 views

Magento 2: Export Order Shipping Address As Separate Fields

When I export orders as a csv file from Magento 2 admin, the shipping address is exported as a single field in the csv file, i.e. there is a column called "shipping address" with the entire address in ...
2
votes
0answers
203 views

Admin Grid (UI Component) - Remove columns from export in magento2

I know there is a way to remove columns from export in magento1 through "is_system" config attribute in UI component. What's the solution in magento2??
2
votes
0answers
657 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. ...
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.
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 ...
2
votes
1answer
374 views

Export Magento 2 configurations from local Dev to Staging server

I installed Magento 2 locally using composer on MAMP. I developed my custom theme and configured the shop in Magento admin. How do I transfer all my configurations to the Staging server? In Drupal 8 ...
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,...
2
votes
0answers
2k views

How to Move Products, Attributes, Images, and Customers From One Magento Installation to Another

I have Magento 1.9.2.1 installed and I also installed a test Magento installation in a subdomain. Basically, the theme I have installed on my current Magento installation was designed for an older ...
2
votes
0answers
244 views

Error when exporting customer grid to csv "cannot define correlation name 'billing_street_first_line' more than once

EDIT: So I have narrowed it down to the fact that Magento does not like the JOIN when I am adding it to the collection. Is there anyway to make it so it doesnt duplicate the correlation name or ...
2
votes
1answer
95 views

Order Export issues on Chrome

Magento 1.6.2.0. When exporting Orders from the grid view in magento, as CSV, the name of the file downloaded is appended with -, attachment. This seems at the minute to be only happening in Chrome. ...
2
votes
0answers
688 views

API to automatically import Woocommerce orders to Magento

I'm looking for the best way to automatically import orders from a Woocommerce shop to Magento. Do you guys have any ideas how to do that ? CSV auto export/import ?
1
vote
1answer
13 views

Magento 1.9 - After Export Products, Category few columns values like 000,000,000

After export products, category few columns like 12,223,234,544,348,000,000,000 what is mean 000. How to view what category it is? FYI - few products assigned to more than one category like 6 or 7 ...
1
vote
1answer
29 views

How to export product Advance pricing in magento 2

how to export product Advance pricing in Magento 2 Currently, I am using profiler to export product price but I didn't get Advance pricing so how can I export Advance pricing store wise in Magento 2 ...
1
vote
0answers
19 views

Export sessions data from files to REDIS

We are moving from single server to multiple server setup for our store. The problem is that we are using file cache type and we want to preserve those sessions (long expiration, per management ...
1
vote
1answer
61 views

Export Orders Data Extension

Is there any Magento1.x Extension that allows me to export orders specification? I need to create a report with the following data: order_id (one order can have more than one product) customer_name ...
1
vote
1answer
35 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 ...
1
vote
0answers
62 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 ...
1
vote
2answers
370 views

After updating from 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 ...
1
vote
0answers
59 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
0answers
12 views

Divide orders based on order number and items ordered

I'm trying to figure out a way to do this: Compare order if it has multiple items with this same SKU it will be given a different status. for instance order : 555 has 3 items all with sku 565 < ...
1
vote
1answer
404 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
0answers
128 views

Product CSV file not exporting from admin in Magento 2

When we export Procuct Csv from admin side. Then csv not export. We get error There is no data for the export. Any one help me to solve this issue.
1
vote
1answer
108 views

Magento 2 Import/Export Options Missing

I've installed Magento 2 and under System -> Data Transfer there are no options. Do I have to enable them somehow?
1
vote
0answers
22 views

How can I import products from external programs CSV every day?

I have external "offline" program that runs database of products. I would like to create a script or something to automaticaly update product inventary. Another problem is that headers don't mach, so ...
1
vote
0answers
497 views

Magento 2.3 Ui grid not working when store column is present

I have created a custom grid using UI component. "Store" column is one of the columns. The issue is, when there is Store column, export function is not working. The error comes from the following path ...
1
vote
2answers
135 views

Export files to google drive using Magento 2 Programmatically

I want to export/transfer files to Google drive using Magento 2. Please help me out.
1
vote
0answers
105 views

Magento 1 : How to Solve 404 Error while exporting csv file on custom module

I have facing issue (404 error /page not found error) while exporting csv file in custom module from system configuration. if anyone known then please tell me how to solve this 404 error.
1
vote
1answer
169 views

Grid Row Total issue in exported CSV - Magento 2

I am facing an issue in My custom grid. I have added 'Export to CSV' in Grid and it is working fine. Issue is I have added a row total in grid but in Exported CSV, total is actually the total of all ...
1
vote
1answer
2k 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!
1
vote
0answers
135 views

Magento Bulk Import Functionality Best Approach

We are developing a multi vendor module . In this module vendor will upload an excel sheet to import simple and configurable products. I have a few questions here to proceed. I need a better approach ...
1
vote
0answers
255 views

Include discount amount on subtotal in order export file Magento 2.2.2

I would like to export sales order from sales->Orders and the column subtotal(in csv and excel file) which should include the discount amount which we have apply while purchasing the product. for ...
1
vote
1answer
100 views

Custom CSV Export - Magento 2

We need to create a custom CSV Magento 2 Export. In particular, we need to add a column (or an attribute in additional_attributes column) that indicate the attribute’s position inside the category it ...
1
vote
2answers
193 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 ...
1
vote
0answers
31 views

Automated Product Export

We use the product export data from the manual export process in a separate process that is done daily. I was wondering if it was possible to schedule this export somehow. I've done some searching on ...
1
vote
0answers
324 views

Entity attributes not listed when exporting products magento2!

I am exporting products but entity attributes list not appearing on the page. When I check in response, it is showing script but not response. <script> require([ 'mage/adminhtml/grid' ], ...
1
vote
0answers
94 views

Cannot export profile, permissions

I have an issue when I'm trying to make an export via Magento 1 profile, so it showing me an access forbidden exception: I tried to set up 777 recursively for var folder, checked user and owner group,...
1
vote
0answers
403 views

How to Filter Attribute Set, Attribute option value and filter by manufacture in product export

Change into app/code/local/Mage/ImportExport/Model/Export/Entity/Product.php on line 647 in funtion export() $collection = $this->_prepareEntityCollection(Mage::getResourceModel('catalog/...