new

msExportOrdersExcel

Exporting minishop orders to Excel
Packages
16
Downloads
1 201
Автор дополнения
Packages
16
Downloads
1 201
Usually answers in a week
Version 3.0.16-beta
Release date 01.08.2023
Downloads 148
Views 1 570
Warning! This component requires PHP version 5.6 or higher! If your site uses PHP less than required, the installation of this package could break it.
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

3.0.9-beta

  • Баг с выгрузкой товаров