Price list rules map a supplier's stock notation — pluses, asterisks, “3 и более”, English words, a flag in another column — to your statuses. Write a rule once; every import applies it.
When you need this:
- Pluses or asterisks instead of stock — a rule sets “In stock” and a quantity.
- No stock in the file, yet everything is delivered — one rule sets a status for all of it.
- Only products in stock — the rest are removed on import.
- Stock shows only in another column — the rule reads that column.
Where to start: open the price list card's “Availability” tab and see what the supplier sent.
What price list rules can do
- Translate the supplier's notation — a comma-separated list, matched partially or exactly.
- Catch numbers — a “from — to” range, and a quantity taken from the text or set by you.
- Read another column — quantity, delivery time, warehouse, manufacturer.
- Set a status for the whole price list or keep only the statuses you need in it.
- Recalculate without an import — with a button, on rows already loaded.
How to write a rule for the supplier's notation
A rule is a row on the “Availability” tab: a list of notations from the supplier's file and the status that matches them. Rules do most of the work: global keywords are the same for everyone, but every supplier has its own format.
Add a rule with the “Add” button in the tab's top bar: it lists your statuses as colored chips — pick one. Below the divider are two more items: “Add new availability status” (asks for a name and creates the status; an empty name gives a red “You must enter a stock status name!”) and “Manage availability statuses” — the same directory window.
1
Status chips2
Add new availability status3
Manage availability statuses- Status chips: the chosen status becomes the status of the new rule.
- Creates a new availability status without leaving the price list card.
- Opens the directory of availability statuses.
List of values
The main column of a rule is “Availability values from the price list”. Enter notations there separated by commas or semicolons; spaces at the edges are trimmed, so “1, 2, 3” and “1;2;3” give the same result.
Here's how it looks in real price lists from the demo database:
- one supplier marks stock with asterisks — the rule catches “*, **, ***, ****, *****”;
- another uses pluses: “+, +/-”;
- a third writes numbers and a phrase: “1, 2, 3 и более”;
- a fourth uses words in two languages: “В наличии, В наявності, Доступно”;
- a fifth writes in English: “limited, yes”.
In new rules, the “Partial word match” switch is on — unlike statuses, where it's off. So the rule fires even when your notation simply occurs inside a value. That's exactly what you want for asterisks and pluses; for a short word like “yes”, probably not.
The app treats two notations in a special way: “{EMPTY}” and “{ПУСТО}”. A rule with such a value catches rows where the stock column is empty or equals zero. Write them literally, in capital letters and in curly braces — otherwise they're ordinary text that isn't in the file.
Exceptions
The “Exceptions” column is filled in the same way, with commas or semicolons, and works differently depending on the switch next to it.
Exceptions behave as exceptions only when “Partial word match” is on. With the switch off, the app requires the value to equal what's written in the exceptions — so the rule fires on them exactly, not on everything else. If you need exceptions, keep partial word match on.
Numbers and quantity
Besides a list of notations, a rule can catch numbers. The “from” and “to” columns in the “Filter” group set a range: the value from the file is reduced to a number (spaces, “>”, “<”, and “=” are dropped) and checked against it. If you fill in only “to”, “from” becomes one automatically.
Two more columns decide what to do with the quantity:
- “Detect quantity” (on in new rules) — the number from the notation goes into the product quantity. “>3 pcs” gives 3, and “3 и более” gives 3 too; if the rule has “Add quantity” set, it's added to this number.
- “Add quantity” — a number added on top. If “Detect quantity” is off, the quantity equals just this number: use this for flag-style price lists that show “+” instead of a stock count, where the real quantity can't be known.
Neither column applies when the “Quantity” field address is specified in the “Columns” section: then the quantity is taken from the file.
The group also has “Delivery cost”: its value is written to the products the rule matched. The “%”, “*”, and “+/-” columns in the “Markup/Discount” group tie a markup to the stock status — an “on order” product can sell at a different percentage than one in the warehouse. Markups are covered in the article on pricing rules.
How to narrow a rule and set the order
Source field and filters
Sometimes a price list has no stock column, but stock can be inferred from another column: quantity, delivery time, warehouse. For this, a rule has the “Source field” column — a button with a list of the price list's product columns. Choose a column, and the rule looks for its notations there instead of in the stock column.
Next to it is the “Manufacturer” column: the rule is narrowed to products of one manufacturer from the directory.
More complex conditions are built in the “Import rules” card under the grid — a condition builder that can check any column of the price list product: contains, equals, begins with, greater than, less than, empty. The app restates the condition in plain language right away, so you can see exactly what you got.
The builder belongs to the selected row of the rules grid. Click another row, and the condition reloads from it. If no row is selected, the “Save” button in the builder does nothing and says nothing: first the row, then the condition.
1
Empty condition builder2
Clear All3
Save- Empty builder: build a condition over the price list product columns here.
- Clears the condition.
- Saves the condition; works only for a selected rule row.
Rule order
Rules are processed by the “Rule order” column, from the smallest number to the largest; rules with the same number run in the order they were created. The first rule a price list row matches closes that row to the rest — no later rule and no global keyword will overwrite it.
In practice, this means narrow rules go higher and broad ones lower. If a partial-match rule for “>” comes first, it takes “>3 pcs” and “>100” alike, leaving nothing for the rule meant for large stock.
The “Active” column turns a rule off without deleting it. A disabled rule takes no part in anything — handy when a supplier temporarily changes its format.
1
Availability values from the price list2
Partial word match3
Only import products with this status- Comma-separated spellings of the availability value as it appears in the supplier file.
- Partial word match: the rule fires when the value contains the word.
- Rows with other statuses are dropped from the price list.
Two switches that change what's in the price list
Most rule columns affect the status of a single row. Two affect the whole price list, and their consequences don't show right away.
“Set this status for all products” does exactly what it says: every product in the price list gets one status, and the other rules don't run. Along with the status, the whole price list also gets this rule's “Add quantity” — even if the quantity column in the file is specified.
This checkbox is for suppliers whose file has no stock at all, with an agreement that they'll deliver everything. If the rules “don't work” even though they look right, check whether this checkbox is on somewhere in this price list.
“Only import products with this status” works differently: rows with other statuses are removed from the price list, along with rows that haven't been assigned a status yet (see the fourth step of the decision order). It makes sense: why keep ten thousand items the supplier doesn't have? But you need to understand the consequence.
A product cut from the price list by this checkbox disappears from more than just the supplier's product list.
During the next it gets no offer from this price list — and if no other supplier offers it and the update settings have stock status updating on, the catalog sets it to “Out of stock”. That's what the complaint “the product was in the file, but it's not in the app” looks like.
Don't count on a broken setting leaving the price list untouched. If nothing was recognized, the app gives all rows the first status of type “In stock”, and the checkbox then removes everything that doesn't have its status.
So if the checkbox is set only in a rule with a different status — say, “Preorder” — the price list is emptied completely. It survives only when that status of type “In stock” is among the statuses with the checkbox.
Recalculate stock without waiting for an import
You change rules, but the price list is imported on schedule in the morning. To see the result now, the “Availability” tab's top bar has the “Determine availability for products” button: it runs the whole decision order on this price list's rows that are already loaded. The file isn't reloaded — it uses the data already in the price list.
While the recalculation runs, the button is locked and the message “Processing data, please wait” stays on screen. When it's done, “Operation completed successfully” appears and the price list's product grid is reloaded.
“Operation completed successfully” always appears — when statuses were assigned, when there are no rules, and when the column address isn't specified. The message means the operation reached the end, not that it changed anything. Check the result in the status column among the price list's products.
During a regular price list import, this same step runs automatically, as a separate operation in the overall chain — you can see it in the list of import operations.
Scenarios
The supplier uses pluses and asterisks instead of a stock count
Setup. On the “Availability” tab of the price list card, add a rule with the “In stock” status and “+, *, **, ***” in the “Availability values from the price list” column. Turn off “Detect quantity” and enter in “Add quantity” the number you consider the nominal stock.
Result. Rows with these notations get the “In stock” status, and the quantity equals the number from “Add quantity”. Rows that matched no rule are picked up by the global status keywords.
What won't happen. If the “Quantity” field address is specified in the “Columns” section, the number from “Add quantity” isn't written: the quantity is taken from the file.
The supplier doesn't state stock but delivers everything on order
Setup. One rule with the “Preorder” status and the “Set this status for all products” checkbox. If needed, a number in “Add quantity”.
Result. Every row in the price list gets “Preorder”, and the quantity is the number from this rule's “Add quantity”.
What won't happen. The other rules of the price list and the global keywords don't run. The quantity from the file isn't kept even when the “Quantity” column is specified: the rule overwrites it.
You only need products the supplier has in the price list
Setup. In the rule with the “In stock” status, the “Only import products with this status” checkbox.
Result. During import, rows with other statuses are removed from the price list along with unrecognized ones. At the next base catalog update, these products get no offer from this price list, and if nobody else offers them and stock status is on in the update, they become “Out of stock”.
What won't happen. If neither the rules nor the global keywords recognized a single row, unrecognized rows aren't removed: they all get the status of type “In stock”.
Stock can only be seen from another price list column
Setup. In the rule, use the “Source field” column: choose the price list product column where the supplier writes the stock flag, and enter that column's notations in “Availability values from the price list”.
Result. The rule looks for its notations in the selected column, not in the stock column. A filled-in “Source field” by itself tells the app there's somewhere to get stock from, so the whole price list won't get “In stock” by default.
What won't happen. Global status keywords don't read the other column: rows that didn't match the rule are checked only against the stock column.
What to do when a rule didn't work
| What you see | Why | What to do |
|---|---|---|
| Some products were recognized, the rest became “Out of stock” | If at least one row was recognized, the rest get a status of type “Out of stock” | Add the missing notations to the rule or to the status keywords (list of values) |
| The product is in the supplier's file, but not in the price list | “Only import products with this status” is on — rows with other statuses are removed | Clear the checkbox in the rule if you need all products (about the two switches) |
| “Operation completed successfully”, but the statuses stayed the same | The message means the operation reached the end, not that it changed anything: there are no rules, they're disabled, or the column isn't specified | Check the rules' “Active” column and the column address (stock recalculation) |
| “Processing data, please wait” stays on screen and doesn't go away | The recalculation is still running, or the request broke off | Wait; if the connection dropped, refresh the window and click “Determine availability for products” again |
| You click “Save” in the “Import rules” card — nothing happens | The rule row the condition belongs to isn't selected | Click a row in the rules grid, then save the condition (about filters) |
| “You must enter a stock status name!” | The name field in the “Adding a new stock status” dialog is empty | Enter a name — for example, “Pre-order 10 days” |
| “You do not have permission for this operation” — and the new rule or status row doesn't stay in the grid | No right to edit price lists | Ask the owner to grant access (who has access) |
FAQ
There are fewer products in the price list after the import. Where did they go?
Most likely, one of the rules has “Only import products with this status” on: rows with other statuses are removed from the price list. Clear the checkbox if you need all items (about the two switches).
How do I keep out-of-stock products from being imported from a price list?
Turn on “Only import products with this status” in the “In stock” rule and, if needed, in the “Preorder” rule too. The checkboxes add up: rows with any checked status remain. There's no “do not import” checkbox.
Are rules applied all at once or one by one?
One by one, by “Rule order”. The first rule a row matches closes it to the rest (rule order).
Do the warehouse and “Quantity field type” affect the status?
No. Both fields are in the “Availability” section of the price list card, but they play no part in determining statuses: “Quantity field type” is needed for demand analysis.
I changed a rule — why does the catalog show the old status?
Rules work within the price list. Stock is transferred to the catalog by the base catalog update; until it runs, products keep their previous status.
Where it is and who has access
- Rules
- List of price lists → price list card → “Availability” tab
- Access right
- the “Availability” tab of the price lists window; changing rules requires the right to edit price lists
- Prepare
- the address of the “Stock status (from price list)” column and an imported file
The “Availability” tab is second to last, before “Log”; it takes a second to load the first time. Access is granted separately: a manager can see supplier products without the rules. Without the right to edit price lists, rules aren't saved: “You do not have permission for this operation”. Where stock comes from when no column is set is covered in the general article.
See what the supplier sent
Before writing rules, open the “Availability” tab and read the hint “Availability values from the price list:” — the app collects every distinct notation found in this price list there. A long list is collapsed; expand it with the “Show more” button.
Write rules from this list, not from memory or from what the supplier tells you: it shows “3 и более”, “*****”, “limited”, and empty values. The demo database has over three hundred such notations; the most common are “3 и более” (about 12,000 rows), “true” (9,000), “1” (6,000), and “*” (5,600).
1
Availability values received from the file- Availability values actually received from the supplier file: write the rules based on this list.
Related topics
- To understand the overall decision order and how stock reaches the catalog — Stock in a supplier price list.
- If the same notations repeat across many suppliers — status keywords.
- If an “on order” product needs a different markup — Pricing rules.
- If stock arrives in a separate file — Stock price list.
