Pseudo Warehouse Numbers Formulas – Xentral help center

Framework for pseudo warehouse numbers

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.

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

Only report stock from the main warehouse :

L:Hauptlager

Only report stock from warehouse location HL001A

LP:HL001A

Example: Restriction to project/warehouse

This example is useful in case you want to report different stock depending on a project. This can be required if you sell your items on multiple online shops and want to display different stock information on each of these platforms.

Only report stock reserved in the Shopify project:

RES:PR:SHOPIFY

Only report stock available (meaning: not reserved) in the B2C project:

OFFEN:PR:B2C

Only report stock that is reserved in the main warehouse:

RES:L:Hauptlager

Only report stock available (meaning: not reserved) in the main warehouse:

OFFEN:L:Hauptlager

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

Available variables and 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
Project: PR:project abbreviation

The following operators are available:

```
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 > 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.

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