An application for exporting minishop2 orders to XLS, XLSX, CSV.

Download sample order export

Export button

After installation, you will have a button for exporting.

Export Console

When you export, the console starts to inform you about the export process

Exported file

This is how the exported file looks.

System Settings

The following options are available
Automatically download after export
msexportordersexcel_download
Yes

File name
msexportordersexcel_filename
Export orders% d.% m.% Y

Source to save default files
msexportordersexcel_source_default
is installed automatically after installation

Enable date formatting
msexportordersexcel_date_process
Yes

Date format
msexportordersexcel_date_format
d.m.Y H: i: s

Tab name
msexportordersexcel_tab
Export orders

Managing Export Profiles

The system uses profiles configured through the ExportUsers component. In total, there are two orders.json and ordersproducts.json

core/components/msexportordersexcel/profiles/orders.json
core/components/msexportordersexcel/profiles/ordersproducts.json

If you have enough knowledge then you can try to modify them manually.
To understand how the structure of the profile is structured, you need to review the ExportUsers

After making changes to the profile, you need to run the script in the console:

/* @var msExportOrdersExcel $msExportOrdersExcel */
$msExportOrdersExcel = $modx->getService ('msExportOrdersExcel', 'msExportOrdersExcel', MODX_CORE_PATH. 'components/msexportordersexcel/model/');
$msExportOrdersExcel->importConfigs();

Attention!!! If you manually modify the profile, you will often violate the export process. So do not forget to backup profiles

By default, the fields are unloaded:
Order

num, createdon, cost, cart_cost, weight, comment, Status.name, Payment.name, Delivery.name, Address.receiver, Address.phone, Address.country, Address.index, Address.region, Address.city , Address.metro, Address.street, Address.building, Address.room, Address.comment

Goods

name, count, price, weight, cost, options (json format)

For options, there is a separate handler
core/components/msexportordersexcel/custom/handlerfields/msoptions.class.php

Video instruction

By expanding the fields through the component ExportUsers

Look