WooCommerce WISO My Office API / Interface

API für Shop-System und Warenwirtschaft

WISO MeinBüro Schnittstelle zu WooCommerce

YouTube

By loading the video, you agree to YouTube's privacy policy.
Learn more

Load video

The interface between WooCommerce and WISO MyOffice has the task of importing orders from the shop into the merchandise management system of WISO MyOffice with a click. Save time and effort and let our script do the work. 

The interface performs the following tasks:

  • Matching of existing purchase orders (can be set separately depending on status)
  • Transfer of new orders from WooCommerce to WISO MyOffice
  • Export articles from WISO MyOffice to WooCommerce
  • Import articles from WooCommerce to WISO MyOffice
  • Update prices from WISO MyOffice to WooCommerce
  • Update stock from WISO MyOffice to WooCommerce

You can also find detailed instructions on the Buhl Data website.

What does the optional set-up service include?

We make sure that the synchronization between WISO and WooCommerce runs properly. We do this in the following steps:

  1. Installation of the interface in the WooCommerce shop via a temporary admin account.
  2. Setup of the interface options individually for the customer
  3. Einrichtung der Verbindung in WISO MeinBüro mit dem WooCommerce Shop  (über AnyDesk)
  4. Configuration of the interface in WISO MyOffice
  5. Performing a test order and adjusting the import

Here you come to the furnishing service

⚠️ Detailed instructions can also be found here on the Buhl Data page!

In order for order matching to take place between WISO MyOffice and WooCommerce, the plugin must be set up on WordPress and the connection between WISO MyOffice and WP must be established in the Ecommerce settings.

  1. Install the WISO MyOffice plugin in your WordPress installation in the usual manner and enter the License key to access the interface information that you can then use to set up WISO MyOffice:
     
  2. After activating the license you get access to the settings:



  3. Select which purchase orders are to be imported (example):

  4. Now call up the e-commerce settings in WISO MyOffice:

  5. Please enter the path, that you have displayed in WordPress. Forgive no Password.
      
  6. Save the settings.

For a correct procedure, please note:

  • The article numbers in WooCommerce must match the WISO MyOffice article numbers. This is the only way to ensure a smooth transfer of orders!
20.10.2022, Version 3.8.0
  • NEW: Bei der Bestellung werden nun auch Versand-Email Adresse und Versand-Telefonnummer gesendet
  • NEW: Übertragen von Pfand-Werten, die in WooCommerce als \"Gebühr\" gespeichert werden
  • FIX: Fehlerkorrekturen bei Variantenprodukten
09.08.2022, Version 3.7.9
  • NEW: Auslesen der EU VAT ID und Übertragung mit dem Abruf der Bestellungen in die Kundendatei (nur wenn MarketPress installiert und aktiv ist)
  • FIX: Ändern der Standardanrede - wird nichts gewählt, bleibt diese leer (nur mit Germanized oder Marketpress verfügbar)
22.07.2022, Version 3.7.8
  • FIX: Korrektur bei der Fehlermeldung in orgaMAX/MeinBüro, falls keine Verbindung zum Lizenzserver besteht oder die Lizenz abgelaufen ist
  • FIX: Max. Datum für die Abfrage kann nun auch leer bleiben
  • FIX: Beim Export von Artikeln werden nun Werte zu den Spalten post_modified und post_modified_gmt hinzugefügt, um kompatibel mit der SQL Option NO_ZERO_DATE zu sein
  • CHANGE: Verschieben einer MwSt. Option in den Reiter \"Steuern\"
16.05.2022, Version 3.7.7
  • Korrektur: Beim Synchronisieren der Preise werden Angebots-Preise nun entfernt, da sie nicht mehr aktuell sind
  • Korrekturen bei den Versandkosten bei gemischten Warenkörben: Nun lässt sich über eine Option in den Einstellungen anpassen, ob Versandkosten gemischt oder nach dem höchsten MwSt.-Satz berechnet werden sollen
  • Neue Einstellung, mit der eine abweichende MwSt generell gesendet werden kann. Dies ist vor allem in grenzübergreifenden Gebieten manchmal notwendig, wenn der interne Steuersatz anders ist als der ausländische. Nur im Bedarfsfall aktivieren!
  • Hinzufügen eines Logs für jede Aktion, die von orgaMAX ausgeht, das in den erweiterten Einstellungen aktiviert werden kann
04.04.2022, Version 3.7.6
  • NEU: Unterstützung für geteilte Versandsteuern bei Benutzung von Germanized hinzugefügt. Hier werden die Versandkosten als doppelte Position übertragen und tragen dabei jeweils anteilig den normalen als auch den reduzierten Steuersatz.
  • FIX: Korrektur für Artikel mit 0% MwSt. Satz. Änderung des Ausgabeformats von Float auf String
21.02.2022, Version 3.7.5
  • - KORREKTUR: Gratis-Artikel werden mit dem Steuersatz des Produktes exportiert (vorher wurden Gratis-Artikel mit 0% Steuersatz exportiert, was zu Buchungsproblemen mit falschen Konten führte)
  • - NEU: Option zur Aktivierung und Deaktivierung der Übertragung der Bestellnummer in Individuelles Feld. Standard = Aktiviert.
13.01.2022, Version 3.7.4
  • - Fix: Doppelsynchronisation bestellen mit \"WooCommerce Sequential Order Numbers PRO\" hinzufügen
10.01.2022, Version 3.7.3
  • - NEU: Kompatibilität mit \"Germanized for WooCommerce\" Plugin
06.01.2022, Version 3.7.2
  • - NEU: Kompatibilität und Einstellungen mit \"WooCommerce Sequential Order Numbers PRO\" hinzufügen
04.01.2022, Version 3.7.1
  • - NEU: Kompatibilität und Einstellungen mit \"WooCommerce Sequential Order Numbers\" hinzufügen
08.12.2021, Version 3.7.0
  • - FIX: Optimierung der SQL Queries für Abruf von Bestellungen: Vor allem bei zahlreichen Bestellungen konnte der Prozess sehr langsam werden. Durch die Optimierung wurden Abfragen vorher gebündelt
26.11.2021, Version 3.6.2
  • - FIX: Optimisation of database queries
15.10.2021, Version 3.6.1
  • - FIX: Anmerkungen wurden beim Export zu WooCommerce nicht als Produkt-Titel übertragen
  • - NEU: Integration zweier Hooks, die nach Import ausgeführt werden können: after_product_import_zu_shop (läuft nach jedem importierten Produkt ab) und after_products_import_zu_shop (läuft einmalig, nachdem alle Produkte importiert wurden)n
11.10.2021, Version 3.6.0
  • - FIX: Correction of stock updates for variant products
09.08.2021, Version 3.5.2
  • - FIX: Optimisation of database queries
12.07.2021, Version 3.5.1
  • - FIX: Correction output format with thousands separator
01.07.2021, Version 3.5
  • - New: Optimising the database query
  • - New: Compatibility with \"WooCommerce TM Extra Product Options\"
14.04.2021, Version 3.4
  • New: Ensuring functionality with active license
30.03.2021, Version 3.3.8
  • Fix: Replace country codes in purchase orders for correct display on the invoice
  • Fix: Creation of a new hook for extended compatibility with the WPML add-on
19.03.2021, Version 3.3.7
  • Fix: Fixing problems where orders could not be processed further
  • Fix: compatibility of the shipping tax calculation with different plugins
  • New: You can now decide whether the shipping text should be taken from the WooCommerce order or from the WaWi system. For this purpose, the new tab \"Shipping\" was added in the settings
02.03.2021, Version 3.3.6
  • NEW: Compatibility with 3rd party plugin B2Bking and fee handling. Here, for certain customer groups, VAT is not shown at the position, but only at the end. With this update, the VAT is also taken over.
10.02.2021, Version 3.3.5
  • FIX: Corrections for orders to third countries that do not include VAT
  • Optimization of a request function, with which price updates now run faster
  • UPDATE: Order status is now updated via WordPress hooks, enables execution of additional WordPress-based processes.
  • NEW: Transmission of the order number in individual field 1 of the order
26.01.2021, Version 3.3.4
  • FIX: Recognition of correct tax rates for variations
  • FIX: Increased compatibility with encrypted Germanized strings
  • FIX: Purchase orders in recycle bin are not transferred during purchase order import
12.01.2021, Version 3.3.3
  • - Optimization: Increase MySQL server string concatenation length (group_concat_max_len) to be able to receive content after longer descriptive texts
07.01.2021, Version 3.3.2
  • - Fix: Optimization of the synchronization process, now also more than 700 products can be adjusted in stock in one run
14.12.2020, Version 3.3.1
  • FIX: Check for Germanized improved
  • FIX: Folder names corrected
08.12.2020, Version 3.3.0
  • NEW: Matching of item description and short description via selectable fields. Available are item description and notes.
  • FIX: Corrected transfers of net & gross prices
19.10.2020, Version 3.2.0
  • NEW: Matching of article description via individual fields
  • NEW: Preparation for WPML compatibility via an add-on
  • FIX: Wording in article import area
01.10.2020, Version 3.1.1
  • FIX: Variation price included / without taxes
29.09.2020, Version 3.1.0
  • FIX: Correction of stock level display in article overview
  • FIX: Display of date selector for order imports under Safari corrected
  • Fix: Corrections in the transfer of prices and quantities of variants (variable products in WooCommerce)
23.09.2020, Version 3.0.3
  • FIX: If an order does not receive any items, the script no longer aborts (\"There are no new orders available\"), but jumps to the next order and imports it.
16.09.2020, Version 3.0.2
  • Fix: Correction of the display of variant prices in the product overview page
25.08.2020, Version 3.0.1
  • Fix: Corrections in the saving process. Changes to the settings are now applied to all tabs
12.08.2020, Version 3.0.0
  • Complete revision of the user interface. Elements are now structured in tabs
  • Introduction of the matching of individual fields
  • Matching of 5 individual article fields via WooCommerce attributes
27.07.2020, Version 2.3.3
  • NEW: Tax rates can now be set for the country of origin in the settings to get correct prices when importing items. The tax rates that are maintained in WooCommerce are used.
  • NEW: Support for individual fields introduced starting with hooks, information can be customized via filters
23.07.2020, Version 2.3.2.1
  • FIX: Correction when querying articles from the shop
10.07.2020, Version 2.3.2.0
  • FIX: Correction of the calculation of vouchers
  • FIX: Limit rounding in WooCommerce to 2 decimal places.
15.06.2020, Version 2.3.1.0
  • Support for 2nd address field in WooCommerce
  • Corrections in the transfer of payment methods
11.06.2020, Version 2.3.0.0
  • Display of settings also added for shop manager role
  • If the status is changed automatically after the order import, this is now displayed in the order history.
  • Removal of the checkbox at the password field
  • small design changes
  • Adoption of the WooCommerce tax rate
07.05.2020, Version 2.2.4.1
  • Change to the function that checks open purchase orders
06.05.2020, Version 2.2.4
  • Corrections in the import process: In rare cases, orders were provided with an ambiguous status and remained as data corpses in the shop. Updates of stock levels were therefore not possible, as you always have to import open orders first.
  • Shipping costs name: By default, the shipping costs name that is set in WooCommerce is now selected. If an article is set for shipping costs in WISO MyBusiness, this designation can be used instead (for this, the origin of the designation must be set accordingly in the interface).
30.04.2020, Version 2.2.3
  • FIX: Fixed a bug where date selection did not output orders through the interface.
29.04.2020, Version 2.2.2
  • New: Support for PinPoint booking system (booking data is displayed in the order)
  • Corrections during the transfer of the warehouse stock
  • The default folder for new installations of the interface is now wp-content
30.03.2020, Version 2.2.1
  • New: Via a new setting you can now freely decide whether you want to import gross or net prices prioritized (this had become important for invoicing with some customers)
  • New: After the import has been completed, a new status can be assigned to the order (e.g. Completed).
  • Tweak: Customers of Raidboxes et al. could not run the interface, because scripts are generally prohibited in the upload folder. Via the advanced settings, the entire import script can now be moved to the wp-content folder.
02.03.2020, Version 2.2
  • Tweak: The SQL query for exporting orders has been completely revised. Orders will be fetched faster from WISO MyOffice, or several orders can be imported at the same time per call.
24.02.2020, Version 2.1.1
  • Fix: Price synchronization has been revised and is now displayed correctly in WooCommerce in the article itself as well as in the article overview.
18.02.2020, Version 2.1
  • FIX: Fixing of problems with the retrieval
  • NEW: Adding a single call-off of an order
10.02.2020, Version 2.0
  • Extensive extension for the interface
  • NEW: Export articles from WISO MyOffice to WooCommerce
  • NEW: Import articles from WooCommerce to WISO MyOffice
  • NEW: Update prices from WISO MyOffice to WooCommerce
  • NEW: Update stock from WISO MyOffice to WooCommerce
03.01.2020, Version 1.2.4
  • Error when saving the order status fixed
12/30/2019, version 1.2.3
  • FIX: Enhancement of database compatibility with MySQL
12/16/2019, version 1.2.2
  • FIX: Adjustment of the folder name of the plugin during installation. Must be \'woocommerce-wiso-zaehlpixel\'
11/27/2019, version 1.2.1
  • FIX: Corrections to the wording
11/14/2019, version 1.2
  • NEW: Query of the article description either from WISO MB or WooCommerce possible
10/22/2019, version 1.1.2
  • NEW: Addition of a new field for company name (for billing address)
10/18/2019, up to version 1.1.1
  • NEW: Addition of several new fields that can now be queried by WISO
  • FIX: Corrections in the transfer of payment options
  • NEW: Retrieval of possible separate payment costs (e.g. for cash on delivery charges)
11.10.2019, v.1.0
  • First release of the WISO MyOffice plugin for WooCommerce

1. can the status of the orders be changed after import?

Yes, since version 2.2.1 the order status can be changed to another status after pickup:

2. Werden die erstellten Rechnungen wieder an WooCommerce zurückgegeben (z.B. als PDF) und der Bestellung angehängt

No, the invoice is not transferred back to the shop by our interface. Our customers usually send these printed in the package. A summary of the order, which can also serve as an invoice, is already sent by WooCommerce via email. Some of our customers use the plugin German Market to create the PDF directly in the order process and send it to the customer in the order confirmation email.

3. is the stock always up to date? When the customer orders an item, at what point does the inventory decrease?

The stock is updated when you import orders. However, this is calculated via WISO MeinBüro, i.e. the current stock is not transmitted and then updated, but MeinBüro subtracts the items from the existing stock in its own inventory. You can, however, update the shop by entering the correct number in MeinBüro and then sending this number to the shop via the webshop update menu.

4. if I have about 300 articles, can I simply click on these articles and they will be transferred into the shop and texts, prices and photos will be transferred?

MyOffice currently only supports the export of title, text and price. When exporting products, they are set to draft in the shop. Images are currently not supported by MeinBüro, but that doesn't make sense in WooCommerce either, because: The template of your online shop works with individual image sizes. These are only calculated by a regular upload in WordPress and saved in the different variants. That means manual rework is necessary to get the best quality of the product display.

5. no articles can be exported from MyOffice to WooCommerce. The error message is that no articles can be retrieved.

For the first synchronization or export of articles, at least one article with article number must be created in WooCommerce, because MyOffice first makes a comparison of both data masters. If there are no articles, an error will be displayed.

Imported orders always have an item that could not be assigned. How to solve this?

Hierbei handelt es sich in 99% der Fälle um den Versandartikel. Klicken Sie mit der rechten Maustaste in den Details der Bestellung auf den "unbekannten" Artikel und weisen Sie ihn einmal einem Ihrer Versandartikel zu. In Zukunft wird immer der Versandpreis übernommen, den der Kunde in seiner WooCommerce-Bestellung gesehen und ggf. bezahlt hat. Hier erhalten Sie eine detailliertere Anleitung.

7. Die Zahlungsmethoden werden nicht korrekt übertragen

Wenn Zahlungsmethoden wie PayPal o.Ä. nicht korrekt übertragen werden, prüfen Sie bitte, ob diese in WISO MeinBüro in exakt dem gleichen Wortlaut angelegt wurden wie Sie diese in den WooCommerce Einstellungen unter "Zahlung" finden. Übertragen Sie den Titel der Zahlungsoption exakt so zu MeinBüro (In den Kleinstammdaten - Zahlungsoptionen).

8. Kann die gleiche Lizenz für eine Staging Website und die Live-Website verwendet werden?

Ja, das ist möglich, wenn die Staging Website auf eine der folgenden URLs läuft: 

  • localhost
  • 10.0.0.0/8
  • 172.16.0.0/12
  • 192.168.0.0/16
  • *.dev
  • .*local
  • dev.*
  • staging.*
  • staging-*.
  • *.test.
  • *.wpengine.com

9. Wie fügen wir ein Anrede-Feld zu WooCommerce hinzu, sodass dieses auch korrekt an MeinBüro übertragen wird?

Dies ist entweder per Germanized für WooCommerce oder Checkout Field Editor for WooCommerce möglich. Die genaue Anleitung erhalten Sie hier.

 

Individual fields

The following function can be used to access or change the data of individual fields:

function change_me_function_name( $individualFields, $productSku, $productId ) {
// (maybe) modify $individualFields array.
return $individualFields;
}
add_filter( 'wiso_product_individual_fields', 'change_me_function_name', 10, 3 );

This list is not exhaustive, as some problems only occur in practice. These are limitations in WISO MyOffice, not in our interface.

  • Product images cannot be transferred because WordPress goes through certain processes when uploading, for example to create several different image sizes. This must be done manually
  • When importing items from WooCommerce to MyOffice, anything transferred to the"Notes" field is truncated by MyOffice after 255 characters.
  • When importing articles from WooCommerce to MyOffice, everything that is transferred to the"Article text" field is cut off by MyOffice after 1024 characters.
  • If a voucher is declared as a value voucher, are treated incorrectly by MeinBüro in the VAT. Although the final amount on the invoice is correct, the VAT is not calculated correctly.
  • A maximum of 5 individual fields can be matched in both directions
  • Fields that do not exist in MyOffice have to be maintained manually in WooCommerce (e.g. categories, keywords, etc.).
  • Since MeinBüro does not support variants, a product of the type "Variable product" cannot be exported from MeinBüro. However, matching is still possible if the variant product is first created in WooCommerce and then imported to MeinBüro (but not the other way around). In either case, each individual variant must have its own SKU (item number) that matches the webshop ID in MyOffice. The "parent product" in WooCommerce must NOT have an article number, it only serves as a container for the individual variants.
  • Attention IONOS Customers: at IONOS WordPress installations can be installed as "Managed" or "Standard". According to customer reports, the "Managed" version seems to have problems saving the settings. Please contact your IONOS Support or change the installation to "Standard".

Licenses

Jährliche Abrechnung

29,-

exkl. MwSt. pro Monat, jährlich abgerechnet
Excluding 19% tax

Monatliche Abrechnung

49,-

exkl. MwSt. pro Monat, monatlich abgerechnet
Excluding 19% tax

Für Sie: Unser telefonischer Einrichtungsservice

What does the optional set-up service include?

We make sure that the synchronization between WISO and WooCommerce runs properly. We do this in the following steps:

  1. Installation of the interface in the WooCommerce shop via a temporary admin account.
  2. Setup of the interface options individually for the customer
  3. Einrichtung der Verbindung in WISO MeinBüro mit dem WooCommerce Shop  (über AnyDesk)
  4. Configuration of the interface in WISO MyOffice
  5. Performing a test order and adjusting the import

Hier kommen Sie zum Einrichtungsservice →

Unsere Kunden lieben unseren Service!

Susanne Vogt
Susanne Vogt
4 August, 2021.
Thank you. Everything worked great
ikutech e.K.
ikutech e.K.
23 July, 2021.
Mr. Brückmann was able to solve the problem competently and beyond his actual task. We are very satisfied with Mr. Brückmann's service / support and are happy to recommend him. 5 stars
Thomas Marx
Thomas Marx
29 April, 2021.
One is almost flashed by the clarity and conviction with which Mr Brückmann personally provides support on the phone. One call, boss on the phone, after 5 minutes everything was solved and explained. Thank you very much.
Joachim Diekhoff
Joachim Diekhoff
21 April, 2021.
Very good service I can only recommend
Cristian Iconomu
Cristian Iconomu
12 April, 2021.
No wonder Albert and his team have only 5 stars reviews. The level of professionalism and fast response, combined with the usefulness of the work they do makes them one of the rare providers of software that is worth paying for. Thanks Albert, keep up the good work 🙂
Christian Michelbach
Christian Michelbach
31 March, 2021.
Reacted very quickly and solved extremely competently. Thank you very much!
Michael Wallenta
Michael Wallenta
29 March, 2021.
I received a prompt reply to my support request. I received targeted and professional assistance in using the API interface offered for WISO MyOffice! I am completely satisfied! Thank you!
BotCake Chatbots
BotCake Chatbots
25 March, 2021.
Excellent support, questions resolved promptly. Thank you Albert and team! UPDATE: Very glad to have found their Gravity Forms Double Opt-in Addon! It has put a complete stop to spammed form entries. When I asked support about a functionality of the Addon, they said it was in the works for the next release. A couple of days later they served me with a beta that included that desired functionality. And it works to perfection! I've never been this impressed by customer service with any software provider. The service provided by Albert & John was truly extraordinary. I thought customer service was dead on the internet and it might be, but these gentlemen are the exception. Thanks guys, you're amazing!
Stefan Gehrhardt
Stefan Gehrhardt
9 March, 2021.
Mr Brückemann and his company can only be recommended! Finally, a competent, friendly support team that knows what it's talking about!