msExportOrdersExcel

Exporting minishop orders to Excel
Packages
27
Downloads
2 947
Usually answers within a few days
Автор дополнения
Packages
27
Downloads
2 947
Usually answers within a few days
Version 1.0.8-pl
Release date 10.31.2018
Downloads 44
Views 501
Warning! This component requires PHP version 5.4 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

1.0.8-pl

  • Исправлена передачи переменной $row с записью

1.0.7-pl

  • Исправлена перезапись модифицировнных профилей выгрузки

1.0.6-pl

  • Добавлена информация в обработчик о записи

1.0.5-pl

  • Исправлена ошибка в профиле выгрузки

1.0.4-pl

  • Добавлена возможность для авторизированных пользователей фронтенда скачивать свои заказа по нажатию на кнопку "Скачать заказы в XLS"

1.0.3-beta

  • Добавлена set_time_limit(100) для увеличения времени исполнения скрипта если на хостинге возможно это сделать

1.0.2-beta

  • Иcправление для подключения процессоров только из папки core

1.0.1-beta

  • Поддержка английского языка

1.0.0-beta

  • New build script.