Deutsch Français Italiano

Order Export CSV

Inhaltsverzeichnis

Introduction

PepperShop Plus offers order export in XML format via Business Connector / Caller. This is especially recommended for ERP system connections. However, if you need tabular data, a CSV export (character separated data) is ideal. The shop offers a simple CSV export that reads all data within a time interval (ideal for Excel or LibreOffice / OpenOffice.org).

Installation

System Requirements

To use this module, a PhPepperShop Plus from version 5 is required.

Copy and Upload Files

The module essentially consists of two files that must be copied into your installed PepperShop. First, extract the provided ZIP archive. It contains the following directory.

{shopdir}/shop/Admin/bestellung_export_csv.php
{shopdir}/shop/Admin/bestellung_export_csv_config.def.php

The files can be easily uploaded to the web server via (S)FTP or SCP. The placeholder {shopdir} stands for the shop directory on the web server, where the file index.php together with the file README.txt can be found.

Commissioning

The module is immediately usable in the standard configuration after copying the module files.

Configuration

In the shop administration, click on the menu ‘Import/Export’ and then on the newly appeared module ‘Order Export CSV’.

In the subsequently displayed mask, you essentially see two window parts:

  • Export: Start of data export according to date specifications and configuration specified below (date values in format DD.MM.YYYY). The target format has UTF-8 character encoding.

  • Configuration:

    • Export articles: One article is exported per line in the CSV – the order data is thus multiple
    • Export customers: Additional columns per order with customer data are exported
    • Export delivery addresses: Additional columns for the different delivery addresses are exported
    • Orders with status “Pending”: You should actually never set a checkmark here, unless you know what you are doing. Orders that are actually still locked for processing by third-party systems are then also exported – e.g. because a payment validation is still running.

Adjust Exportable Columns

Figure 1: Module Administration Mask

Adjustments to the exported data are made here: {shop_verzeichnis}/shop/Admin/bestellung_export_csv.php

// Order data
$export_arr['bestellung'] = array(
    // 'Versandart' => 'versandart',
    'Bestellungs_Nr' => 'Bestellungs_Nr',
    'Rechnungs_Nr' => 'Rechnungs_Nr',
    // 'Versandland' => 'Versandland',
    'Abgeschlossen_am' => 'abgeschlossen_am',
    // 'Waehrung' => 'Waehrung',
    // 'Rechnungsbetrag' => 'Rechnungsbetrag', // Invoice amount in
    // foreign currency rounded!
    // 'Rechnungsbetrag_Basis' => 'Rechnungsbetrag', // Invoice amount in
    // base currency and
    // unrounded!
);
// Customer data
// (only relevant if ['global']['kunden_exportieren'] = true)
$export_arr['kunde'] = array(
    'Kunden_Nr' => 'Kunden_Nr',
    'Sprache' => 'locale',
    'Anrede' => 'Anrede',
    'Vorname' => 'Vorname',
    'Nachname' => 'Nachname',
    'Firma' => 'Firma',
    'Abteilung' => 'Abteilung',
    'Strasse' => 'Strasse',
    'Hausnummer' => 'Hausnummer',
    'Postfach' => 'Postfach',
    'PLZ' => 'PLZ',
    'Ort' => 'Ort',
    // 'Land' => 'Land',
    // 'Land_id' => 'land_id',
    // 'Tel' => 'Tel',
    // 'Fax' => 'Fax',
    // 'Handy' => 'Handy',
    'Email' => 'Email',
);
// Data of different delivery addresses
// (only relevant if ['global']['lieferadr_exportieren'] = true)
$export_arr['lieferadresse'] = array(
    'Anrede' => 'Anrede',
    'Vorname' => 'Vorname',
    'Nachname' => 'Nachname',
    'Firma' => 'Firma',
    'Abteilung' => 'Abteilung',
    'Strasse' => 'Strasse',
    'Hausnummer' => 'Hausnummer',
    'Postfach' => 'Postfach',
    'PLZ' => 'PLZ',
    'Ort' => 'Ort'
);
// Article data in orders
// (only relevant if ['global']['artikel_exportieren'] = true)
$export_arr['artikel'] = array(
    // 'Artikel_ID' => 'Artikel_ID',
    'Artikel_Nr' => 'Artikel_Nr',
    'Name' => 'Name',
    'Anzahl' => 'Anzahl',
    // 'Einzelpreis' => 'einzelpreis', // in base currency, unrounded
    // 'Einzelgesamtpreis' => 'einzelgesamtpreis', // Base currency, no round
    // 'MwSt-Satz' => 'MwSt_Satz',
    // 'Zusatzfeld_1' => 'Zusatzfeld_1',
    // 'Zusatzfeld_2' => 'Zusatzfeld_2',
    // 'Zusatzfeld_3' => 'Zusatzfeld_3',
    // 'Zusatzfeld_4' => 'Zusatzfeld_4',
    // 'Zusatzfeld_5' => 'Zusatzfeld_5',
    // 'Zusatzfeld_6' => 'Zusatzfeld_6',
    // 'Zusatzfeld_7' => 'Zusatzfeld_7',
    // 'Zusatzfeld_8' => 'Zusatzfeld_8',
    // 'Zusatzfeld_9' => 'Zusatzfeld_9',
    // 'Zusatzfeld_10' => 'Zusatzfeld_10',

);

Further Help

Do you have questions or need assistance? Do you have special requirements or desire a custom solution for your system? Our support team is happy to help. Support services are charged based on time and material at CHF 195.- / hour. Here is how to reach us:

Other Useful Pages

🌶️
🔥
🌶️