Questions tagged [export]

Denotes questions related to export in Magento.

4
votes
0answers
125 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 ...
2
votes
0answers
32 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
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
138 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
176 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
611 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
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.
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
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
239 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
0answers
632 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
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
0answers
66 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
0answers
44 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) ...
1
vote
0answers
20 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
330 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
0answers
124 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 , ...
1
vote
0answers
49 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
0answers
95 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:...
1
vote
0answers
113 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
170 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
72 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
1
vote
0answers
141 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
0answers
28 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
241 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
68 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
362 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
90 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
358 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
186 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
0answers
1k views

Magento 2 Product Export Problems “Please correct the data sent value”

Magento 2 Version 2.1.1 - I am intermittently getting the error "Please correct the data sent value." when trying to export product. Test results: Full Export no filter = Fail Filter by Country ...
1
vote
0answers
85 views

Expoarting all products from backend

We have more than 40,000 products with attributes.When i tried to export from backend it throws an error 502 gateway error.Can you please suggest me one solution
1
vote
0answers
114 views

Magento 1.9.2.4 not exporting simple products

I've run into a weird issue where my Magento site (1.9.2.4) isn't exporting all my products. It successfully exports all my configurables, but that's it - none of the simple products contained within/...
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
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 ...
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
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 ...
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 ...
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
0answers
39 views

Export and Import Location

Someone knows the location of the files important for Export and import? Like for an example: mywebsite/app/.... Because I want to repair it, because files are missing and I don't know where to put ...
1
vote
0answers
321 views

Magento csv export and then to MySQL database

I am trying to export the products to a csv file. System-Import/Export-Dataflow profiles- Export All Products, The data transfer method is set Local/Remote Server, the type is Local Server, Path is ...
1
vote
0answers
2k views

magento 1.9 export all products not work

i try to export all products by using magento default "Export All Products" data profile, but it not works, when i click "Run Profile in Popup" it just loads a while and then displays Starting ...
1
vote
0answers
200 views

How to modify the export function to keep formula

I need to make a website that allow export to .csv with formula, so that my customer can edit that .csv file I'm going to use PHPExcel https://github.com/PHPOffice/PHPExcel as a library to do the ...
0
votes
0answers
18 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
7 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
19 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
27 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 ...