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
The pseudo warehouse numbers currently do not work in all interfaces.
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
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.
Report only numbers from the main warehouse
L:Hauptlager
Report only the numbers from warehouse location HL001A
LP:HL001A
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
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.
The above formulas you can also store in the store interface. Use the following path: Administration > Shop interface > Select interface > Settings > Product import / export area.
Note
Until version 21.1 it's via Administration > Online shops/marketplaces > Select interface → Settings > Product import / export area.
In the Details tab in the Settings sub-tab, you will find this overview of the item import/export:
The formulas can be created directly in the product. Navigate to
Master data > Product > Select product > Details > Online shop options
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.
In the store interface it currently does not work if there is a zero at the end of the formula and this then also takes effect due to the condition.
Example:
LP_Lagerplatz1 - OFFEN > 9 | LP_Lagerplatz1 - OFFEN ; 0
If here the stock minus open is smaller than 9 and therefore the 0 is reported, instead simply the sellable total stock is reported, if the formula is so deposited in the interface.
Alternative for the deposit in the interface is to simply "reverse" the formula, i.e. deposit it as follows, then it works correctly:
LP_Lagerplatz1 - OFFEN < 9 | 0 ; LP_Lagerplatz1 - OFFEN