Please note: Depending on your country and on your selected xentral package, the availability of modules and features differs  thus, the features described in this article might not be part of the xentral product you are using.
Contents
Framework for pseudo warehouse numbers
Starting with version 19.3, transmitted warehouse numbers can be determined by a framework of rules. This opens up the possibility of filling online stores or marketplaces with a flexibly calculated pseudo warehouse number per item.
Note that the pseudo warehouse numbers currently do not work in all interfaces. You can find out for which stores the function is available in the section Shop functions.
Create formulas
You can specify several conditions. At first, the system checks if there is a formula in the item and if the condition is met. If not, the system checks if there is a formula in the store settings and the condition is met. If this is not the case either, the default procedure is used.
The processing sequence is as follows:
 Formula exists in item and is applied, other formulas are ignored
 Formula exists in store settings and is applied, other formulas are ignored
 Application of standard procedure
Example
The following example illustrates how frameworks are set up:
LP_HL001A  OFFEN > 10 AND L_Hauptlager > 20  L_Hauptlager;
LP_HL001B  RES > 10  LP_HL001B;
5
This example uses three different formulas separated by a ; (semicolon). If a  (pipe character) exists, the value before  is used as condition and the value after it as formula.
If no pipe character exists, this is used as if the first 2 conditions above are not met. Consequently, 5 is reported to the store as pseudo warehouse stock.
Example: Restriction to warehouse/warehouse location
Report only numbers from the main warehouse
L:Hauptlager
Report only the numbers from warehouse location HL001A
LP:HL001A
Example: Easy operation and calculation
IF more than 200 pieces stock in the main warehouse → Report the stock of the main warehouse.
OTHERWISE report the stock of the main warehouse + stock of the replenishment warehouse.
L:Hauptlager > 200  L:Hauptlager ; L:Nachschublager + L:Hauptlager
Here the semicolon separates the two values of the preceding condition to be returned, comparable to
IF main warehouse > 200
THEN main warehouse
OTHERWISE main warehouse + replenishment warehouse
Variables/Operators
You can use the following variables:
 Number of reserved items from orders → RES/RESERVED
 Number of items from open orders → OPEN
 Warehouse location → LP_short designation or LP: short designation
 Warehouse → L_designation or L:designation
You can use the following operators:

AND

OR

<

>

<=

>=

"="

<> bzw. !=

"+"

""
You cannot use brackets. For prioritization you work "from top to bottom".
Important: You must always place a space before and after the minus or operator so that the string is not interpreted as a warehouse location.
Application: Store formula in store interface
The above formulas you can also store in the store interface. Use the following path: Administration → Shop interface → Select interface → Settings → Item import/export area.
Note: Until version 21.1 it's via Administration → Online shops/marketplaces → Select interface → Settings → Item import/export area.
In the "Details" tab in the "Settings" subtab, you will find this overview of the item import/export.
Application: Store formula in item
The formulas can be created directly in the item. Navigate to
Master data → Item → Select item → Details → Online store options section.
After adjusting the formula (in the above example of the warehouse used), the "Preview" value is also updated. To update it, it is enough to click one time next to the formula input text field.
0 comments
Article is closed for comments.