Hot answers tagged

23 votes

Export file problem in Magento 2.3

If your var/importexportxxx file is blank try; php bin/magento queue:consumers:start exportProcessor https://github.com/magento/magento2/issues/23450
user avatar
18 votes
Accepted

Is there a way to export all categories into a csv?

You could write this one pretty easily. Create a PHP file called something like export.php. <?php require("app/Mage.php"); // load the main Mage file Mage::app(); // not run() ...
user avatar
  • 2,826
18 votes
Accepted

import custom csv to custom table- magento 2

note: I get crystal clear explanation of custom import option from this link Please first download the whole zip file from this github link then change the module name as per your requirement. Just ...
user avatar
  • 9,479
15 votes

Adding images with CSV import

First you have to upload alll the images you want to import in the media/import/yourimagesfolder/ The in the CSV columns for image, thumbnail and small_image your image path should look like this /...
user avatar
  • 415
15 votes

Magento 2.3.2 Product Export Message: "Message is added to queue, wait to get your file soon"

Run this command then check in admin php bin/magento queue:consumers:start exportProcessor you will get download option
user avatar
  • 3,039
13 votes
Accepted

Export my custom grid data's in Xls

Try this below code: $this->addExportType('*/*/exportExcel', Mage::helper('{module}')->__('Excel')); public function exportExcelAction() { $fileName = 'excel_name.xls'; $content ...
user avatar
  • 1,778
13 votes
Accepted

How to add export functionality in Magento 2 new grid system

You can use sales/orders grid as example. exportButton ui component responsable for UI <exportButton name="export_button"> <argument name="data" xsi:type="array"> ...
user avatar
  • 20.1k
11 votes
Accepted

Admin Grid - Remove columns from export

Got it, if set is_system true for a column, it will not be exported.So $this->addColumn('customer_name', array( 'header' => Mage::helper('sales')->__('Customer'), 'index' ...
user avatar
11 votes
Accepted

Export file problem in Magento 2.3

You have to run cron by command line as mentioned here: php bin/magento cron:run https://github.com/magento/magento2/issues/23450#issuecomment-507581035 Then refresh the export page and you ...
user avatar
  • 1,372
11 votes
Accepted

Magento 2.3.2 Product Export Message: "Message is added to queue, wait to get your file soon"

Try to fix Following way.. Open below file vendor/magento/module-import-export/Controller/Adminhtml/Export/Export.php and replace below function public function execute() { if ($this->...
user avatar
  • 5,094
10 votes

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

To add SKUs Column in order Ui grid. You need to modify below files. TO add column, add below code in your module [vendor]/[module]/view/adminhtml/ui_component/sales_order_grid.xml <?xml ...
user avatar
8 votes

import custom csv to custom table- magento 2

I would suggest to extend the Magento 2's default import functionality. To do that register a new module (lets say "Custom Import" for now) Create a module.xml file at app/code/Foo/...
user avatar
8 votes
Accepted

Magento2: Export grid data in xls format

1) Add Below code in ("app/code/NameSpace/Module/view/adminhtml/ui_component/") listing xml file between <listingToolbar></listingToolbar> tags <exportButton class="Magento\Ui\...
user avatar
  • 1,075
7 votes
Accepted

How to keep products synchronized in two shops

(Reading the comments, it seems that you're trying to create a way to easily and reliably synchronize your production database to your staging site. Perhaps you could update the question to make this ...
user avatar
  • 757
6 votes
Accepted

Change increment customer ID from 1 to 00001 with zero padding

I would strongly advise against altering core tables or their auto increment. Instead translate it when retrieved for export/import using str_pad or sprintf i.e.: $id = 1; $exportId = str_pad($id, 5, ...
user avatar
6 votes

Magento Export All Invoice In PDF

You can make a quick standalone script and run the following: $collection = Mage::getResourceModel('sales/order_invoice_collection'); $pdf = Mage::getModel('sales/order_pdf_invoice')->getPdf($...
user avatar
  • 2,803
6 votes

custom attributes in separate coloumn while export? - Magento 2.0.8

All custom attributes get appeared under "additional_attributes" header in the export separated by a comma (,). I am using Magento 2.0.7. To make these attributes occupy a separate cell, we can add ...
user avatar
  • 483
6 votes

custom attributes in separate coloumn while export? - Magento 2.0.8

I found a free Magento 2 extension from BSS Commerce which helped me work around this: https://bsscommerce.com/blog/how-to-export-custom-product-attributes-in-magento-2/ https://bsscommerce.com/...
user avatar
  • 1,277
6 votes

Export functionality of Custom UI grid in Magento 2 not working

I have found the issue, Inside columns tag, you need to have selectionsColumn . <columns name="custom_order_grid_data_columns"> <selectionsColumn name="ids"> <argument name="...
user avatar
  • 617
6 votes
Accepted

Magento 2 - Script for exporting orders

You can create a stand alone page on root of the magento folder and proceed in this manner : <?php use Magento\Framework\App\Bootstrap; require __DIR__ . '/app/bootstrap.php'; $orderData = ...
user avatar
6 votes

State of the Art in Magento 2 Product Imports

I don't think there is such a thing as "state of the art" import tool for M2 at the moment. But I can say since 2.1.4 (afaik) we have been using the native importer for products and for our use cases ...
user avatar
6 votes

I want to add my custom entity for export Magento 2

This is possible by following the below steps; Include export.xml in your module etc directory with a content similar to the below; <config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" ...
user avatar
6 votes
Accepted

Export Product Sku and Product_Url in magento2

I got reference for the answer from this answer and I add addition part to show url_key column, please try this sql query : SELECT e.entity_id AS 'id', v1.value AS 'name', v0.value AS '...
user avatar
  • 1,323
6 votes

How to keep products synchronized in two shops

We've got a similar setup and scenario. We went with a database level sync of product based tables. It works by dumping and importing tables. The copy site is down for about 15 mins in early hours. ...
user avatar
6 votes

How to keep products synchronized in two shops

not sure how your copy store works, but you can use many options: Magento Sync Products paid extension Odoo connector Example free connector/ Odoo bridge Example Webkul paid extension Magmi Magento ...
user avatar
  • 3,722
5 votes

Adding a column to export but hiding from the grid?

You can use set column_css_class and header_css_class as no-display to the column you want to hide. This will hide your column from the admin grid. However, this column will be present in the exported ...
user avatar
5 votes

Order Item get price of selected custom option

You can try code given below. It works for me hope also help you. $options = $item->getBuyRequest()->getData('options'); $totalCustomOptionPrice = 0; foreach ($options as $key => $value) { ...
user avatar
5 votes

custom attributes in separate coloumn while export? - Magento 2.0.8

Solution : For this Need to do some changes in vendor\magento\module-catalog-import-export\Model\Export\Product.php file or override same model file in your custom module . In vendor\magento\module-...
user avatar
  • 197
5 votes
Accepted

Export all customers to CSV

For this you can create your php script, create one php file on root directory of your website and use following code.for ex: if file name is exportCustomer.php and your url is like http://...
user avatar
5 votes
Accepted

Magento2 - How to Export mysql database without products,orders and customers data?

Please find the below list of table related to product, order review and customer. Or you can run the below query for remove the data from the table by taking the database backup. SET ...
user avatar
  • 1,038

Only top scored, non community-wiki answers of a minimum length are eligible