Skip to main content
Developers Academy Community Sign in

Avocadostore

  • Updated

Legacy module

The module described in this article has been marked as a legacy module. This means the following:

  • We don't create new features for this module or fix any bugs.

  • The module is not available anymore in Xentral instances (demo or licensed) created after 28-Sep-2022. If you as a new user have special requirements that could only be fulfilled by this module, please contact our customer support team to discuss a solution.

For more information, see also Why is Xentral deprecating some modules (Legacy modules) and what does this mean for you?

Avocadostore interface

From Xentral, required data can be reported to the Avocadostore. For this purpose reports (SQL database queries) can be created in Xentral for stock figures tracking numbers, which can automatically be imported into the Avocadostore backend.

Features

  • Using a CSV of orders from the Avocadostore backend via Voucher Importer Create orders in Xentral

  • Generate reports on stock numbers and tracking numbers in Xentral

  • Provide URL of these reports for shipment data import from Avocadostore

Create orders via voucher importer

In the Avocadostore backend you can export a CSV file with the current orders. This CSV file can then be imported into Xentral via the document importer and and create orders.

The important thing here is the conversion to the correct CSV format - the headings must match the Xentral variable names for the corresponding content. These can be found in the "Formats" tab in the Voucher Importer itself.

Further information can be found here: Receipts Importer.

Variables

Useful variables for document import can be:

  • voucher_voucher_nr ⇒ voucher number in Xentral - if it should be assigned automatically automatically: use the word NEW

  • beleg_internet ⇒ order number from the store

  • voucher_date ⇒ voucher date

  • voucher_name ⇒ name of the customer (billing address)

  • voucher_customer_number ⇒ voucher number in Xentral - if it should be assigned automatically automatically: use the word NEW

  • beleg_strasse ⇒ Street incl. house number of the customer (billing address)

  • document_address_addition ⇒ address addition of the customer (billing address)

  • voucher_location ⇒ location of the customer (billing address)

  • voucher_plz ⇒ zip code of the customer (billing address)

  • voucher_country ⇒ country of the customer (billing address)

  • voucher_delivery_name ⇒ name (different delivery address)

  • voucher_delivery_street ⇒ street (different delivery address)

  • document_delivery_address_addition ⇒ address_addition (different delivery address)

  • voucher_delivery_place ⇒ place (different delivery address)

  • beleg_lieferplz ⇒ Postal code (different delivery address)

  • beleg_lieferland ⇒ Country (different delivery address)

  • item_number ⇒ item number for position

  • item_description ⇒ item description for position

  • article_quantity ⇒ article quantity for position

  • article_currency ⇒ article currency for position

  • item_price ⇒ item-VK for position

  • article_umsatzsteuer ⇒ sales tax: leave blank or normal or increased as word

Create reports

You can find all existing reports for the Avocadostore Importer under Reports.

Reports URL

Once the reports are created, you can create a URL for each report in the tab "Transfer" tab to create a URL for the report.

Avocadostore-1.png

Note

If the URL is not accepted becauso of the length, on the Internet there are so-called "URL Shortener" services.

Import at Avocadostore

In the "Imports" tab, you can set up an automatic import using the URL from Xentral.

Note

If you have any questions about the import setup in Avocadostore, please directly contact the Avocadostore support to get a qualified information.

Import offers

Avocadostore-2.png

Import shipping data

Avocadostore-3.png

Related articles

Visit the Academy - you'll find videos for most topics