Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [export]

Denotes questions related to export in Magento.

1
vote
1answer
729 views

How can i solve the error : PHP Strict Standards: Declaration of CustomImportExport_Export::export()

I get error during export product, Error : (error_log) [15-Jul-2016 12:24:04 UTC] PHP Strict Standards: Declaration of CustomImportExport_Export::export() should be compatible with ...
0
votes
1answer
525 views

What is the suggested value of max_execution_time and memory_limit for 20,000 products site for Bulk export

I am not able to export bulk products because time expiration. What is the suggested value to export over 20,000 products?
2
votes
0answers
370 views

How can i Update My Product Export time consuming period for Bulk export products [duplicate]

In my store nearest 16,000 products are there, when i try to export both ways import/export or dataflow both are error. But when i export minimum of data i can able to export my products, which means ...
4
votes
4answers
1k views

How can i solve - No valid data sent - Error

I am export my products after hosting its not working, but from my localhost its working fine. I can not export from import/export, am increased max_exe_time my store consist 30,000 products When ...
5
votes
4answers
4k views

Magento 2 Export & Import CMS Blocks and CMS Pages

How to Export and Import CMS Pages and Static blocks ?
1
vote
2answers
187 views

How can I export all products that have no images? [duplicate]

I need to export all products without images in my site.
1
vote
1answer
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
321 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 ...
1
vote
1answer
864 views

Export selected orders

In Magento 1 admin sales grid, there's a function to export to CSV. How can I only export selected orders instead of exporting ALL the orders?
2
votes
2answers
5k views

Export all customers to CSV

I need to export the following customer information from our Magento site: First name Last name Email Store ID Trying to do so via System > Import/Export > Dataflow - Profiles just times out, ...
0
votes
0answers
240 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
214 views

Export report not showing fields

I want to export order report in csv. With following content Order Date Order Day Order Id Ip Address Customer Name Customer Group Billing Name Billing Address Billing City Billing Postcode Billing ...
0
votes
1answer
295 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
105 views

Export customers error “barkeloo payment”

I'm trying to export the customers, and shows me this error: How can I fix it? any idea?
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
2answers
10k 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.
0
votes
1answer
56 views

Problem regarding import products [closed]

When I do an export of my products and open this .csv list in excel and add the new products, i always recieve a error regarding the SKU See image below.
0
votes
1answer
310 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
445 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 ...
0
votes
2answers
485 views

Why category ids filter doesn't work on product export?

In Magento v2.0.4 Admin Panel go to System > Data Transfer > Export then select Entity Type: Products. At that point the filtering grid appears. The first option is Categories corresponding to ...
0
votes
1answer
131 views

Can you export a configurable product .csv and reuse it? Not working for me

Another attempt to solve this, but it did not work. Is it possible, or not, to export a configurable product .csv and reuse it? I downloaded a different configurable product that had the exact same ...
0
votes
1answer
283 views

Problem with Cache Factory

When i will export the products, this messagens show Class Magento\Catalog\Model\Product\Image\CacheFactory does not exist in MAGENTO 2.0.2
1
vote
1answer
986 views

Magento 2 category export to CSV file

I would like to export created Magento 2 categories to CSV file and create upgrade script that imports csv file to Magento 2 just like sample data csv file.
5
votes
4answers
7k views

custom attributes in separate coloumn while export? - Magento 2.0.8

short description what I done: create product attribute set (Chennai) create 21 new product attributes assign to Chennai attribute set set value to attribute while create product export (System->...
0
votes
4answers
728 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
1answer
649 views

Export Particular order information

I try to export particular order information in csv format but i can't able to download. What mistake i done here? observer.php public function adminhtmlWidgetContainerHtmlBefore($event) { ...
4
votes
5answers
10k 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 ...
1
vote
1answer
945 views

export/import categories

Hi guys I would like to export categories from one of my magento installations and import it into another: version for the export is 1.9.2.1 and 1.9.2.4 for the import, so should have pretty much ...
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 ...
0
votes
1answer
131 views

Export Products Error - Entity is unknown

I tried to export my products with images but i am getting the error "Entity is unknown" occurs. Someone knows how to export manually or how to solve this?
3
votes
3answers
1k views

run sql query and save result in csv

I want to run a sql query in a PHP file and save the result in a csv file (inkl. header). Unfortunately I don't get it done. It looks like I can't use mysql_* on the result. Does anyone know how to ...
0
votes
2answers
680 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
1answer
162 views

How do I modify the code in this extension to run the export function via cron after each order

I am currently using the Bulk Import+Export Orders to CSV extension that is available at: https://www.magentocommerce.com/magento-connect/bulk-import-export-orders-to-csv.html The main function that ...
1
vote
1answer
596 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 ...
0
votes
1answer
320 views

How can I set continuous customer ids for guests and registered customers?

I have a client which uses a ERP System to handle all Magento orders. For this reason I have created a module which exports all orders as a csv file. In Addition the ERP System of my client expect a ...
0
votes
1answer
42 views

Magento Database import to new Database

trying to dump my cms_block and cms_page tables to new working Database. I get the Duplicate Entry for Primary Key ...what is the best way to go about this? when I export tables from old db I have ...
1
vote
2answers
394 views

Column not found: 1054 Unknown column 'sales_bestsellers_aggregated_daily.period' in 'field list'

I am getting error Column not found: 1054 Unknown column 'sales_bestsellers_aggregated_daily.period' in 'field list' when I am trying to export the bestsellers report. a:5:{i:0;s:114:"SQLSTATE[42S22]:...
0
votes
2answers
1k views

Issue in Exporting CSV file from a custom module

I have a custom module in admin panel,when I click at "Export" button following function is called. CSV is being exported and downloaded correctly, in CSV one column is having id's instead of value ...
0
votes
1answer
199 views

Magento export order information

I need to export email adresses and phone numbers, in all my 65000 orders. Is this possible?
0
votes
1answer
737 views

Export catalog_tables from phpMyAdmin?

I have installed fresh Magento and have backup old public_html files.But I forget export products from Magento admin. How can I export catalog tables from myphpadmin section ? I still backup old ...
3
votes
2answers
5k views

Export Orders from Magento MySQL DB without Magento

I have an old Magento database file, but the files associated with it are gone. The database file is for Magento 7.02 I need to export the orders with the line items and a description of the item ...
0
votes
1answer
832 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 ...
0
votes
2answers
1k views

Magento export products in Excel format without third party library

I am using Magento CE-1.9.2.x in my website. Now I want Catalog >> Manage Products >> Actions select box to include the Export Products to XLS option, with only a custom controller and ...
1
vote
1answer
701 views

Magento All Product Export dataflow error

I am trying to export products in Magento 1.9.1 using dataflow profiles, but it stops at "Warning: Please do not close the window during importing/exporting data". This is the error I get: Fatal ...
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 ...
0
votes
1answer
1k views

Store product export csv file in var/importexport folder

I want to store the product export csv file on a folder while generating from the admin panel. Right now its only directly downloadable from the admin panel, but I want to store that file in a ...
0
votes
1answer
1k views

How can I set up a tax rate for all countries?

I want to sell my products in every country in the world for a fixed tax rate on all my products. How can I do this?
0
votes
1answer
37 views

Export multiple tierprices of single product

I'm export/importing products including the tier price to a CSV file: foreach($products as $productid) { $existingTierPrice = $product ->load($productid)->tier_price; foreach($...
1
vote
1answer
268 views

How can i Import Magento Site All category? [closed]

I export all category with tree path my Magento site using following script: //Import Magento All category script define('MAGENTO', realpath(dirname(__FILE__))); require_once MAGENTO . '/app/Mage....
1
vote
1answer
41 views

Export customers from a Mondo shop to Magento?

Is there a way to import Mondo customer data including passwords into Magento? I seachred the net for a while but came up with nothing.