WooCommerce WISO My Office API / Interface

API für Shop-System und Warenwirtschaft

WISO MeinBüro Schnittstelle zu WooCommerce

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!
YouTube

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

Load video

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. are the created invoices returned to WooCommerce (e.g. as PDF) and attached to the order?

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?

This is the shipping item in 99% of the cases. Right-click on the "unknown" item in the order details and assign it once to one of your shipping items. In the future, the shipping price that the customer has seen in their WooCommerce order and paid, if applicable, will always be applied.

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".

Lizenz erwerben

 

Product is provided via download
✅ The purchase of a license authorizes use on one (1) domain
✅ An active, non-cancelled license is required for use, continuous updates and support (cancellation in the account at least 48 hours before expiry).

  • Annual payment for updates & support

Buy excluding 19% VAT.

Opinions