With the interface Billbee Importer you can import orders from the merchandise management system Billbee to Xentral. The importer works exactly like an interface to an online store.
-
Import sales orders
-
Feedback of the order status to Billbee
-
Feedback of stock figures to Billbee
You can enter the user name and the API password in the interface settings. The account to which the username belongs must be an administrator in Billbee. The API password can be found in Billbee under Settings → System → Billbee API.
Go to Administration > Shop Interface > Overview > NEW to create a new shop and select the Billbee module.
After you have selected Billbee, you can enter the necessary data for the connection of the two systems in the next step. This is the username with which you you log in to Billbee and the API password that was assigned in Billbee for the the API.
Once the data has been entered, you can check the connection between the two systems using the Check Connection button on the right side of the screen.
As soon as the connection is successful, you will receive the message "success". If the connection is not established successfully, a message will inform you of the cause.
In this section, you'll get information about the available settings of the shop interface.
After accessing the settings of the Billbee interface, you'll see the Details > Interface tab.
Settings:
-
Denomination - freely selectable name for the shop (is shown in the products and in the import menu)
-
Active - set the check mark to activate the interface. Interfaces that you do not need anymore can be set to inactive.
-
Project - link the shop to a particular project. In the project, you can define the logistics-related settings.
-
Pick-up mode - You can import according to specified status (in some shops).
-
Start of the interface - Orders from before the defined start date will not be fetched.
-
Import mode - Defines how orders are fetched from the shop:
-
Demo (for testing) - the order status in the store is not changed over, no articles or stock numbers are transferred.
-
Manual (with import center) - the orders are only picked up when the Pick up orders button is clicked.
-
Automatically (via process starter) - the orders are picked up automatically by the store on a regular basis. The Shopimporter process starter is required for this.
-
-
Only 1 order per request - only 1 order per request is transferred from the store.
-
Orders in intermediate table - when picking up the orders, the orders are not created directly, but are first saved in an intermediate table for review. Here you can decide which requests should be created and which should be imported later. This option is only valid for the automatic import mode. The manual one always includes the intermediate table, regardless of this option.
-
Limit number of fetch - possibility to limit incoming requests at once. If nothing (0) is entered, the default limit of 100 applies.
-
Tracking in log file - logs data while working with the shop interface for later troubleshooting in case of errors.
-
User name - the account used for the connection must have administrator privileges in Billbee.
-
API password - enter the Billbee API password here that you have retrieved in an earlier step.
-
Pending status ID - the ID of the pending status; you get this information in your Billbee shop.
-
In processing status ID - the ID of the in processing status; you get this information in your Billbee shop.
-
Sent status ID - the ID of the sent status; you get this information in your Billbee shop.
Actions:
-
Test connection - Check if the connection to Billbee is functioning. Be aware that the connection will fail if the shop is in waiting mode.
-
Get orders - Fetches the orders from your shop. This is only needed if the import mode of the interface has been set to manual.
Note
The status codes for "order pending", "order in processing", "order completed" must be unique; the same status must not be used in several instances.
-
Shop import intermediate table - jumps to the intermediate table of orders from the shop. The intermediate table is only filled in manual mode and only when the option "orders in intermediate table" has been selected.
In the intermediate table, in the left column, you select between Import, Trash, and Later:
-
Import - order is immediately imported
-
Trash - order is put into the trash bin and cannot be imported again.
-
Later - order can be imported at a later time.
-
When you click on Check connection (Details → Interface) the interface imports all shipping service providers (carriers) that are available in Billbee. In addition mapping with carriers, xentral now also has a mapping for the product. So the shipping providers are displayed and additionally the respective product ID.
Afterwards, the created shipping types must be mapped to the corresponding shipping types in the "Shipping types" tab. More information about the shipping type mapping can be found here. This mapping must be done in each created Billbee interface. There is a new mapping field with the name "Product Outbound". Here you can enter the product ID for the shipping method.
It is necessary that the mapping is done in each Billbee interface so that the feedback of the tracking number of dispatched orders used can be returned to Billbee.
If the shipping provider data changes on the part of Billbee, the data can be updated at any time by clicking the "Check connection" button. button.
In the log file of the store interface, any error messages regarding the shipping type mapping are listed. The message "Carriers have not yet been retrieved from the store" will occur if the carriers have not yet been added using the Check Connection button.
For more information about the usage of Smarty, refer to Smarty for shop importer.
Refer to the article about Online shops to learn more about:
-
Importing products
-
Exporting products
-
Synching stock numbers
In Billbee there are different status messages with associated IDs. By the Billbee ID in the store settings, you can define which type of orders should be addressed via the interface.
To find out which Billbee IDs are hidden behind the status names, you have to use the console of your browser in the Billbee backend. With a Right click → Examine item this can be opened.
The IDs determined must then be entered in the store settings.
Billbee is not an online shop after all, but the settings of the Billbee importer work analoguous to the Xentral shop importers. Refer to the Online shops article for more information about importing orders.