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.
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;
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
Report only the numbers from warehouse location 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
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:
<> 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 > 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:
Application: Store formula in product
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.