With this interface you can connect xentral with the WordPress-based online shop WooCommerce to import orders into xentral.
-
Pick up orders and report order status back to WooCommerce
-
Transfer articles from xentral to WooCommerce
Note
Please check the feature matrix in the Online shops article to see if the features you need are supported by the shop interface.
Some features like variants, images, and free fields are currently not supported by the WooCommerce interface.
Here you can learn how to connect your WooCommerce shop to xentral.
First, you need to create a REST API account in the backend of your WooCommerce shop. You do this under Settings → Advanced → REST API → Add Key. The user should be an administrator. The xentral API requires read and write permissions in any case.
Afterwards, the API access data is generated, which you have to enter in xentral. The consumer key corresponds to the API key in xentral, the consumer secret to the API secret.
Important: You will no longer see this data once you close the page. Enter the data directly in the WooCommerce interface in xentral. You will learn how to do this in the next section.
Under Administration → Shop interface → Overview → NEW you can search for the importer for WooCommerce.
After you have selected WooCommerce, you can enter the necessary data for the connection of the two systems in the next step.
-
API Key → "Consumer Key" from the WooCommerce backend
-
API Secret → "Consumer Secret" from the WooCommerce backend
-
API URL → URL of your shop frontend
As soon as you have entered the data, you can check the connection between the two systems using the "Check Connection" button which is on the right-hand side of the screen.
If the connection was successful, you will receive the message "success". If the connection is not established successfully, you will be informed of the cause in a message.
To get started as quickly as possible, only a few settings and actions are required. Here you can find out what is necessary for a quick start with order import, stock figure reconciliation and feedback of tracking numbers.
This section explains the possible settings in the shop interface.
When you open the settings of the WooCommerce interface, you will first land in the tab Details → Interface.
Settings:
-
Demo (for testing) → The order status in the shop is not changed over, no articles or stock figures are transferred.
-
Manual (with import centre) → The jobs are only collected when the button Collect jobs is clicked
-
Automatic (via process starter) → The orders are automatically collected from the shop on a regular basis. The Shopimporter process starter is required for this.
-
Recalculate net price → The price of the individual items is calculated as if the total transferred in the API were the net price.
-
Recalculate gross price → The price of the individual items is calculated as if the total sum transferred in the API were the gross price.
-
Designation → Name freely selectable for the shop (displayed e.g. in the article and in the import menu)
-
Active → Check the box to make the interface active. You can set interfaces that are no longer required to be inactive.
-
Project → Link the shop to a project. In the project you can make the logistics settings
-
Pick-up mode → Here you have the options to pick up by status or number. The pickup mode by number is only for testing and not for regular import. For regular import please set by status
-
Import mode → Determines whether the orders are to be imported from the shop manually (at the touch of a button) or automatically
-
Only 1 order per request → Only 1 order per request is transferred from the shop
-
Orders in interim table → When the orders are collected, they are not created directly but first saved in an interim table for review. Here you can decide which orders are to be created and which are to be imported later.
-
Limit number of pick-ups → Possibility to limit incoming orders at once. If nothing (0) is entered, the default limit of 100 applies.
-
Logging in the log file →
-
Always refer to discount designation from article →
-
API Key → "Consumer Key" from the WooCommerce backend
-
API Secret → "Consumer Secret" from the WooCommerce backend
-
API URL → URL of your shop frontend
-
Status name order open → orders in this status are imported from the shop to xentral
-
Status name Order in process → The order receives this status after it has been picked up by xentral
-
Status name Order ready → the order receives this status after the order has been sent in xentral
-
Price justification basis for order import → Since it is possible that no information is provided via the API about whether the total amount is the gross or net price when importing orders from WooCommerce, you can select this with this setting.
Action:
-
Check connection → Checks the connection between both systems
-
Pick up orders → Pick up the orders from your shop
Note
Please make sure that the status messages for Status name order pending, Status name order in process, and Status name order ready are unique, that is that no status is used more than once.
-
Shop Import Intermediate Table → Opens the intermediate table for the shop orders. The intermediate table is only filled during manual import mode and when the option Orders in intermediate table is activated.
In the intermediate table you select between Import, Garbage, and Later in the left hand columns.
Import: The order is imported directly
Garbage: The order is removed into the garbage bin and cannot be imported a second time.
Later: The order can be imported at a later date or time.
-
Import old orders → Old orders will be loaded in the intermediate table. Here you can decide whether you want to import the orders or not.
You can find out more about the use of the individual actions in the section Workflows.
Information about this tab can be found here.
Information about this tab can be found here.
Information about this tab can be found here.
Information about this tab can be found here.
Information about this tab can be found here.
More information about how to use Smarty can be found here.
How you import articles from WooCommerce to Xentral is described here.
Note
In WooCommerce, SKU is used for item matching.
To transfer articles from xentral to WooCommerce, you can export all articles with a shop link or add individual articles to the transfer in the Article Transfer tab of the interface. In order for the article transfer to take place, the setting "Allow article transfer" must be set and the process starter Transfer article must be active.
More information about the article export can be found here.
More information about how to synchronize the stock numbers can be found here.
In order to import orders from WooCommerce you click on the Get Orders button in the interface.
You can transfer orders by status and number from WooCommerce.
-
by status → Fetches all orders of the specified status (see next point)
-
by number → An order number can be entered here. Important: The order number is not the same as in the order overview in WooCommerce. You can find out the number by clicking on the desired order and then taking the order number from the URL: e.g. ... wp-admin/post.php?post=105075&action=edit
Here you can specify several order statuses that are to be imported. These are then to be separated with semicolons.
-
Status name order open → orders in this status are imported from the shop to xentral
-
Status name Order in process → The order receives this status after it has been picked up by xentral
-
Status name Order ready → the order receives this status after the order has been sent in xentral
If this information does not fit, please enter the following status:
|
Zahlung ausstehend |
pending |
|
In Bearbeitung |
processing |
|
In Wartestellung |
on-hold |
|
Fertiggestellt |
completed |
|
Storniert/Abgebrochen |
cancelled |
|
Rückerstattet |
refunded |
|
Fehlgeschlagen |
failed |
It should be noted that the status of open orders and orders in process should not be identical. However, the designations here are only exemplary. The status messages of the orders must be specified as they are also used in the actual WooCommerce shop. This depends primarily on the language set.
When importing orders from WooCommerce, it is possible that no information is provided via the API about whether the total amount is the gross or net price. Therefore, the setting "Price calculation basis for order import" can be made in the interface.
-
Recalculate net price → The price of the individual items is calculated as if the total transferred in the API were the net price.
-
Recalculate gross price → The price of the individual items is calculated as if the total sum transferred in the API were the gross price.
In order to arrive at the actual item price with which WooCommerce calculates, it is therefore necessary to calculate back from the total sum of an item via the quantity to the individual costs. The calculation works more accurately via the net price because rounding does not play a role in the tax and therefore a discrepancy does not occur so quickly. If this is not possible because, for example, the shop does not return net prices via the API, then you can fall back on the gross prices.
Which option is the right one for which shop is unfortunately only known after the first order import, as it is not apparent in the shop's backend what is returned via the API and which plugin may have an effect on the feedback.
Gift cards in WooCommerce are currently not available in Xentral. Please use one of the other three available discounts products for any discount products.