Questions tagged [export]

Denotes questions related to export in Magento.

154 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
4
votes
0answers
134 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
2answers
445 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 ...
2
votes
0answers
53 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" ...
2
votes
0answers
34 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 ...
2
votes
1answer
62 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
143 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 , ...
2
votes
0answers
111 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
80 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
154 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
191 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
632 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
320 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
344 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
241 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
94 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
648 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
129 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 ...
1
vote
0answers
32 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
179 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
92 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
59 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
398 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
71 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
1answer
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 ...
1
vote
0answers
75 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
126 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
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!
1
vote
0answers
125 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
203 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
0answers
171 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 ...
1
vote
1answer
86 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
151 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
29 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
277 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
82 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
374 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/...
1
vote
0answers
97 views

Entity Type : Categories is missing from dropdown (Export - Data Flow Profile) Magento 1.9

i just want to export all categories , the issue is when i use export DataFlow Profiles, i Just See in Entity type Customers & Products, there is no Categories option in Dropdown, anyone please ...
1
vote
0answers
387 views

Magento 2 add custom columns in export

I created some columns in sales order grid like product SKUS, It is visible in grid column as well, But while I am export using export button, CSV return blank columns for SKUS. Any one have idea ...
1
vote
0answers
129 views

How to Import new categories and products from one site to another without overriding the existing

I want to export the categories from live site and import into the development site in Magento. I have followed the method to import through the default import/export via dataprofiles but it ...
1
vote
0answers
193 views

not getting associated product's sku in export CSV Magento 1.9.2

I am trying to get associated product's Sku of configurable products in exported CSV file but not getting. Here is my Action XML in "Dataflow-Advanced profiles" - <action type="catalog/...
1
vote
3answers
644 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 ...
1
vote
1answer
776 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 ...
1
vote
1answer
454 views

Magento export mysql result to csv

I am trying to run two mysql queries and export the results into a CSV. My issue is the second query I have is being written to a new row instead of just onto the same rows that the result from the ...