↑↓ selectEnter openEsc close

    1. Elbuz

    How to transfer availability from a separate stock file into the main price list

    20 min readUpdated

    Elbuz moves stock, quantities and prices from a supplier's separate stock file into their main price list, finding the same products by barcode, SKU or name on every import.

    When you need this:

    • A large price list plus a short stock file — availability moves over on its own.
    • SKUs differ between the files — confirm such pairs once; they then apply automatically.
    • Only availability is needed — clear the price transfer; only status and quantity move.
    • The supplier writes “on order” or “5+” — availability rules turn this into your status.

    Where to start: select the main source and click “Add” in the list of price lists.

    What a stock price list can do

    When stock gets into the main price list

    This is the most important and least obvious part of the topic. You see one setting — a checkbox on a column — but the result depends on which price list you are importing right now.

    In these two cases the program runs different functions with different logic.

    The two points where stock gets into the main price list
    The stock price list is importedThe main price list's links areremovedCascade: pairs are searched forfrom scratchChecked columns go to the mainprice listMain price list products without apair — “Out of stock”, if at least onepair existsThree checkboxes: delete or copywhat wasn't foundThe main price list is importedPairs are not searched forValues flow through the existingpairsProducts without a pair — “Out ofstock”, if at least one pair existsThe checkboxes are not applied

    The stock price list is imported. The program first removes all previous links from the main price list, then searches for pairs from scratch — from manual to automatic — and transfers the checked columns' values for the pairs it found.

    Then the main price list's products left without a pair get “Out of stock” — if at least one pair was found.

    At the end, the three checkboxes of the “Stock” section are applied. Each step writes its own line to the log, so you can follow a stock price list step by step.

    The main price list is imported. If it has an enabled stock price list, at the end of the run values flow from the stock list into the main price list's products — but pairs are not searched for. The existing ones are used.

    After the transfer, the main price list's products without a pair get “Out of stock” — if at least one pair exists. The three checkboxes are not applied.

    This part writes the line “Copying values from the stock price list to the main one: rows updated” with a number to the log. For such a price list, the base catalog matching operation adds the lines “Search for products in the linked “Stock” price list” and “Total items found”.

    The same condition works in opposite ways in these two mechanisms.

    Say the main price list has an active availability rule with the “Set this status for all products” checkbox. When the stock list is imported, this rule replaces the reset status: the main price list's products without a pair get the status from the rule. When the main price list is imported, the same rule cancels the reset altogether.

    The riskiest part: the availability reset

    After searching for pairs, the program sets “Out of stock” and a quantity of zero for the main price list's products that got no pair. This only happens when “Stock status” is among the checked columns — which is always the case with default settings — and only if at least one pair was found.

    The idea is clear: availability comes from the stock price list, and whatever isn't in it can't be treated as available.

    A main price list product for which the cascade found no pair becomes unavailable — even if it is in the stock file but written differently.

    If no pairs were found at all, the main price list's availability stays as it was. The reset is written straight into the main price list's data, not into a temporary copy. So a that stops the stock list run won't restore the main price list's availability.

    So run the first import of a new stock price list like this: import it, check “Total items found” in the log, and only then start the catalog update. Until the update runs, the storefront keeps showing the old data.

    How to create a stock price list

    In the header of the left panel of the source list, click “Add”. The menu shows the item Stock price list for “‹source name›” — but only when a main source that doesn't have a stock price list yet is selected in the list.

    If the stock price list itself is selected, or nothing is, the item isn't there: you can't add a stock list to a stock list.

    The Add menu in the price list window with the stock price list item for the selected main source
    1Stock price list item
    2Selected main source row
    1. The stock price list item appears only because a main source is selected in the list.
    2. This selected source row is the one substituted into the dialog as the parent.

    The item opens the “New stock price list” dialog with two fields: “Parent source” (filled in with the parent's name, can't be changed) and “Name”, prefilled with “Stock”. Confirming creates the source and opens its card.

    The New stock price list dialog with the parent source and name fields
    1Parent source
    2Name
    1. The parent source field is filled with the main source name and cannot be changed.
    2. The name field is prefilled with the default name; an empty name blocks confirmation.

    There is no three-step wizard here. You add a regular new source with a wizard that asks for the supplier and the way to get the file, and shows the column layout.

    A stock price list is created in one click and appears empty: you set the file, how to get it and the column addresses by hand on its card. The ways to get the file are the same as for a regular source and are set up the same way (connecting a supplier source).

    An empty “Name” field simply blocks confirming the dialog: the button doesn't respond, and no message appears.

    A main source can have only one stock price list. Once it has one, the Stock price list for “…” item no longer appears in the “Add” menu for that source. Connect a second availability file from the same supplier through the existing stock price list.

    What the program sets up on its own

    A stock price list isn't created the same way as a regular source. Along with the row in the list, the program does a few things you didn't ask for, and all of them are needed.

    • Checks three fields for transfer. The “Copy value to main price list” checkbox is set on exactly “Price”, “RRP” and “Stock status”. Without any setup, all you need is to specify which file columns hold them.
    • Adds the operation “Matching products from the linked price list with the products of the main price list”. This operation is disabled globally, so regular price lists don't have it, but here it is active right away.
    • Removes two operations from the pipeline: “Matching products from the price list with the products of the base catalog” and “Determine product categories”. A stock price list isn't checked against your catalog — it only works with the main price list. “Repricing” stays: it comes before the transfer to the main price list.
    • Uses its own set of matching types — five exact types instead of the usual ones. They are covered in the article on auto-matching rules, section “Stock price list”.

    The stock price list itself calculates the price from the stock file. It gets the same set of markup types as a regular source and reprices the price before it goes to the main price list. The main price list doesn't reprice the transferred price again.

    So the column's exchange rate and the pricing rules for the price from the stock file are set on the stock price list's card: the currency in the “Price” column settings, the markup in its markup types.

    Stock price lists created before 31.10.2026 stay without “Repricing” and without markup types — the update doesn't change them.

    If the supplier's stock file has prices in a foreign currency or without your markup, add “Repricing” to the stock price list's operation list, before “Matching products from the linked price list with the products of the main price list”. Also add the markup types you need, at least “Price + exchange rate”. Then import the stock price list again.

    If the file only has availability, you don't need repricing, and in a new stock price list you can remove it from the operation list.

    The “Apply markup to products” wand button keeps the transferred price. After its repricing, it transfers the price and RRP from the active stock price list into the main price list again — from the columns marked “Copy value to main price list”.

    It works both ways: the wand on the main price list takes the stock price list's current prices, and the wand on the stock price list reprices its price and immediately puts the new one into the main list.

    The wand doesn't transfer availability — only a stock price list import updates it. If the main price list has a formula for the “Price” field, it runs after the transfer and recalculates the transferred price.

    What is transferred to the main price list

    Only what is marked with the “Copy value to main price list” checkbox is transferred. The checkbox is in the field grid on the stock price list's card, in the “Columns” section, and it shows up only on a stock price list's card — a regular source has no such column.

    If the source is set up by sheets, the same column is in the “Import from sheets” window.

    In the field grid it is a separate checkbox column, the third one — right after the “Column address” column. One grid row = one system field: the field name on the left, then its column address in the file, then the transfer checkbox.

    Three fields are already checked when the list is created. You can check any other — name, manufacturer, full description, photo — but four fields carry more with them than the label says:

    Checked fieldWhat moves with it
    “Stock status”The status, its color and image, the status name and the quantity. So quantity is transferred automatically, there's no need to check it separately
    “Manufacturer”The manufacturer name and its link to your manufacturer directory
    “Price”The price choice priority in the main price list is reset to zero, so that price choice recalculates it during the catalog update
    “Photo”The main price list's photos are deleted completely and inserted again only for matched products

    If no column is checked, the operation runs and does nothing. Silently: there will be no message on screen and no matching line in the log.

    Why a stock price list needs its own availability rules

    In the stock file, availability is written in the supplier's words: “yes”, “no”, “5+”, “on order”, “ожидается”. Availability rules turn this into your status, and this is where they belong: on the stock price list's card, “Availability” tab, not on the main price list's card.

    The reason is the order of operations. After the program removes two operations and adds its own, the stock price list pipeline looks like this:

    1. Remove products that are on the ignore list
    2. Distribute products across base catalog categories
    3. Apply text autocorrect rules
    4. Search for a product manufacturer
    5. Auto-replacement of product values based on regular expressions
    6. Create main products for option products
    7. Determine product availability
    8. Repricing
    9. Applying formulas to fields
    10. Matching products from the linked price list with the products of the main price list
    11. Saving values from fields to attributes

    Availability detection comes before the transfer. First the text from the file becomes your status inside the stock price list, and only then the finished status goes to the main price list. The order of operations as a mechanism is covered in a separate article; here only this fact matters.

    The consultant can show which availability rules apply during the catalog update right now (disable a product without a price list, enable a found one, days of relevance, deletion) and whether any price list has its own settings.

    Use the “Which price is chosen and stock from several price lists” hint in the price lists window — it also shows where each rule is changed.

    How pairs are found: a seven-step cascade

    When a stock price list is imported, the program goes through the steps one by one, and each next step only takes the main price list's products that don't have a pair yet. First come, first served — you can't reorder the steps, the order is built into the program.

    The cascade has no “this much alike” threshold: either the value matches, or you confirm the pair.

    StepWhat is comparedWhen it runs
    Manually matched productsPairs from the directory that you confirmedAlways, first
    “Search by EAN barcode”Barcode, exact matchIf the type is in the price list's list
    “Search by supplier SKU”Supplier SKU, exact matchIf the type is in the price list's list
    “Search by MPN + name”MPN and name togetherIf the type is in the price list's list
    “Search by name”Name, exact matchIf the type is in the price list's list
    “Search by MPN”MPN, exact matchIf the type is in the price list's list
    Four substring typesThe name or SKU of one price list inside the value of the otherAfter the exact types, if you added them

    The five exact types work out of the box — they are already in a new stock price list's list. The four substring types are added by hand in the “Matching types” window.

    For a stock price list, the window offers exactly these nine types. The usual types that check a price list against the base catalog aren't there. There's nothing to configure in them either: the fields and conditions are built into the program, you can only add a type to the list or remove it.

    Each step writes two things to the run log: the type name and the line “Total items found” with a number. At the end comes the same “Total items found” with the total for all steps.

    If it's zeros everywhere, the files have no common key: the supplier writes the SKU differently in the two files.

    Then you'll have to confirm the by hand. How to read the log and its numbers: source run log.

    How to confirm pairs manually in the “Product Matching” window

    The “Product Matching” window, opened for a stock price list, works differently than for a regular price list: on the right, instead of your catalog, is the main price list.

    The labels show this — the program explains the layout right in the window: “On the left — products of the linked price list, on the right — products of the main price list to match against.”

    The layout is two panels with a splitter, and each panel's header has a row counter.

    • Left panel — “List of new products from the linked price list”: stock file rows that don't have a pair yet. Zero in its counter means there's nothing left to confirm.
    • Right panel — “List of found products from the main price list”: candidates from the main price list for the product selected on the left. Rows already matched aren't shown in either panel.
    • If smart search found no candidates, the hint “No similar products were found in the main price list” appears next to the right panel's counter. The “Show all products” button turns off auto-selection and lets you search by hand.

    A pair is created with the “Match” button in the candidate's row. The confirmation dialog is called “Product Matching” and shows the two products side by side: “Product from linked price list” and “Product from main price list”. Confirming writes the pair to the directory, marks both rows as linked, and adds a log line with both product names.

    If you click “Match” without selecting a row on the right, the program says: “To match products, select a product from the main price list!” Select a row in the right panel and click “Match” again.

    The linking button itself has a separate access right — the “Button "Match product"” access block of the “Product Matching” window. Without this right, the window has no matching buttons at all, only the two lists.

    You can break a pair from either side — from the stock price list product or from the main price list product. The directory row is deleted, and the link marks are cleared from both products.

    Pairs outlive the price list rows themselves. The directory stores product fingerprints, not row numbers, so reimporting the file doesn't lose the pair: after a new import it is applied again, as the first step of the cascade. Along with the pair, the SKU and name of both products at the moment of linking are saved.

    How to remove or add products without a pair: three checkboxes

    On the stock price list's card, in the “Products” section, there's a “Stock” subheading with a “for stock price lists” chip. Below it are three checkboxes, all three cleared by default. Their labels call your stock price list the “secondary price list”.

    The checkboxes are stacked in the same order as in the table below: first the one about the secondary price list, then two about the main one. The labels are long and similar — the only difference is which of the two price lists keeps the products, so read them to the end, not by the first words.

    CheckboxWhat it does
    “Only keep items found in the main price list in the secondary price list”Rows without a pair are deleted from the stock price list. There's no protection against over-deletion: if the cascade found nothing, the stock price list is emptied
    “In the main price list, keep only those items found in the secondary price list”Rows without a pair are deleted from the main price list. The only checkbox with protection: the program first checks that at least one pair was found, and only then deletes
    “Copy products from the secondary price list to the main one if they were not found in the main one”Stock rows without a pair are added to the main price list as new products, then the main price list's product count is recalculated. The log gets the line “Total products copied to the main price list:” with a number
    The checkboxes are checked one by one, top to bottom: deletion from the main price list runs before copying, so copied products aren't affected by it
    yesyesnonoyesnoyesnoPair search for the stock price list isdone“In the main price list, keep onlythose items…” on?At least one pair found?Rows without a pair are deletedfrom the main price list“Copy products from the secondaryprice list…” on?Stock rows without a pair are addedto the main price list as newproducts“Only keep items found in the mainprice list…” on?Rows without a pair are deletedfrom the stock price listThe run continues
    • Start or end
    • Action or result
    • Decision: the path depends on the answer

    A typical stock price list does without these checkboxes: its job is to bring availability, not to change the assortment.

    The “Stock” section exists only on the stock price list's card. The main price list's card doesn't have it — there's no point looking for the checkboxes there.

    Import order, viewing and deletion

    A stock price list only makes sense after the main one, and the program enforces this on its own. The “Import all sources” button goes through three stages in a fixed order: main price lists first, then stock price lists, then site parsers. The same order applies to single-thread import.

    One more detail of the same order: if you have the automatic catalog update after price list import turned on, then after a stock price list import the update runs for the main price list, not for the child one. The program finds the parent on its own.

    This is correct — stock price list products don't go to the catalog; the main price list's products go there, with availability already pulled in.

    Where stock price list products are visible

    On the stock price list's own card, “Products” tab — everything is there. But in the general product list of all price lists they are hidden by default: child source rows are filtered out.

    You turn this on with the system setting “Show from “Stock” price lists”, described as “The general list includes products from price lists of the “Stock” type.”

    The system setting that controls showing stock price list products in the general product list
    1Setting toggle
    1. While the toggle is off, products of stock price lists are not shown in the general product list of all price lists.

    What happens on deletion

    Deleting a main source also deletes its stock price lists — all of them, together with the files and cloud copies. You don't need to clean up the child source separately.

    Manually confirmed pairs are deleted together with the price list — both when you delete the main price list and when you delete only the stock price list.

    Scenarios

    Your first stock price list

    What to do: go through the list in order — from creation to the first catalog update.

    Your first stock price list

    Result: the main price list's availability is updated from the stock file, and you start the catalog update only after checking the pairs.

    Transfer only availability and keep the price from the main price list

    What to turn on: on the stock price list's card, “Columns” section, clear the “Copy value to main price list” checkbox on the “Price” and “RRP” fields, keep it on “Stock status” and set its column address. The rules that turn the file's text into your status go on the stock price list's “Availability” tab.

    Result: for main price list products with a pair, the stock status, its color, image, name and quantity are transferred.

    What won’t happen: the main price list's price and RRP stay as they came from its file, and the price choice priority isn't reset — that only happens when “Price” is checked.

    SKUs in the two files don't always match

    What to turn on: open the “Product Matching” window for the stock price list and confirm pairs with the “Match” button. If the name or SKU of one file is contained in the value of the other, add the substring types you need in the “Matching types” window.

    Result: a confirmed pair is applied as the first step of the cascade on every stock price list import. Substring types run after the exact ones, in the order they appear in the price list's list.

    What won’t happen: the program won't create pairs by similarity, and substring types don't run until they are in the stock price list's list.

    The main price list should keep only products that are in the stock file

    What to turn on: on the stock price list's card, “Stock” subheading, the “In the main price list, keep only those items found in the secondary price list” checkbox.

    Result: after the pair search, rows without a pair are deleted from the main price list.

    What won’t happen: if no pair was found, nothing is deleted from the main price list.

    The stock file has products that aren't in the main price list, and you need them

    What to turn on: on the stock price list's card, “Stock” subheading, the “Copy products from the secondary price list to the main one if they were not found in the main one” checkbox.

    Result: stock rows without a pair are added to the main price list as new products, the main price list's product count is recalculated, and the log gets the line “Total products copied to the main price list:” with a number.

    What won’t happen: if there's nothing to copy, there's no log line. If the previous checkbox is also on, it doesn't delete the copied products: deletion runs before copying (diagram in the checkboxes section).

    What to do when availability isn't transferred

    What you seeWhyWhat to do
    The “Add” button menu has no Stock price list for “…” item The item appears only when a main source is selected; it isn't there for a stock price list or when nothing is selected Click the main source row in the left panel and open “Add” again (how to create)
    The “New stock price list” dialog doesn't close after you confirm An empty “Name” field blocks confirmation, and no message is shown Enter a name; the default is “Stock” (how to create)
    “Total items found: 0” in the log at every step There's no common key: the SKU or barcode is written differently in the two files, and exact types only work on a full match Check the stock price list's column addresses; then confirm pairs manually or add a substring type (cascade)
    The log has neither a “Matching type…” line nor “Total items found” No column in the stock price list is marked with the “Copy value to main price list” checkbox — the operation exits without doing anything, silently Stock price list card → “Columns” → check at least “Stock status” (what is transferred)
    After the stock import, some main price list products became “Out of stock” Main price list products for which the cascade found no pair get “Out of stock”: either they aren't in the stock file, or the key is written differently in the two files Don't start the catalog update until you've confirmed pairs manually or added a substring type (availability reset)
    “To match products, select a product from the main price list!” No row is selected in the right panel — “List of found products from the main price list” Select a row on the right, in the “List of found products from the main price list” (manual pairs)
    “To match products, please select a product from the price list!” No row is selected in the left panel — “List of new products from the linked price list” Select a row on the left (manual pairs)
    “No similar products were found in the main price list” Smart search found no candidates for the selected stock product Click “Show all products” and find the pair by hand (manual pairs)
    The main price list shrank: some products disappeared The “In the main price list, keep only those items found in the secondary price list” checkbox is on This is how the checkbox is meant to work. If you don't need it, clear it and reimport the main price list (three checkboxes)
    “Total products copied to the main price list:” and a number The “Copy products from the secondary price list to the main one if they were not found in the main one” checkbox is on: unmatched stock rows were added as new products The checkbox is working normally. If products without a price appeared in the main price list, clear this checkbox (three checkboxes)
    Photos of the main price list's products disappeared The “Photo” column is checked in the stock price list: the main price list's photos are deleted completely and inserted again only for matched products Clear the checkbox on the “Photo” column and reimport the main price list (what is transferred)
    A main source is selected, but the “Add” menu still has no Stock price list for “…” item This source already has a stock price list, and a second one can't be created for the same source Open the existing stock price list under this source and set it up (how to create)
    Stock price list products aren't visible in the general product list of all price lists The “Show from “Stock” price lists” system setting is off by default Turn on the setting, or view the products on the stock price list's own card (where products are visible)

    FAQ

    How is a stock price list different from a regular source?

    It works only with its supplier's main price list: it matches its products against it and transfers the checked columns. It isn't checked against the base catalog and reprices the file price with its own markup types before the transfer. More: what the program sets up on its own.

    What does a stock price list transfer by default?

    “Price”, “RRP” and “Stock status”, and along with the status — the quantity. You only need to specify which stock file columns hold these values.

    How many stock price lists can one source have?

    One. Once a source has a stock price list, the “Add” menu has no item for a second one.

    What happens to confirmed pairs if I reimport the file?

    Nothing — they are applied again, as the first step of the cascade: the pair directory stores product fingerprints, not row numbers. You can break a pair manually from either side.

    Can the program match similar products automatically?

    No. The cascade works on an exact match or on one value being contained in another. Confirm the pairs it didn't find in the “Product Matching” window.

    Where to find it and who has access

    This feature has no window of its own: a stock price list lives in the same list of sources as regular price lists, just indented under its main source. The program says so right above the list: “Stock price lists are indented under their parent source; create them via “Add” with a source selected.”

    Menu
    Directories → Processing price lists → List of price lists
    Creating
    select the main source → “Add” → Stock price list for “‹source name›”
    Manual pairs
    select the stock price list → “Product Matching” in the header of the right panel
    Other entry points
    the same link in the toolbar of the “Products” tab
    Matching types
    Directories → Processing price lists → Matching types
    Access right
    the “List of price lists” window; the column checkbox and the three checkboxes are separate blocks of the “Import settings” and “Products” tabs
    Prepare
    a main price list imported at least once; the stock file, and knowing where it holds the stock and the SKU

    A stock price list row has the badge “Прайс остатки”, and if you leave the name field for the list empty, it shows up in the list as “Stock”. The manual matching window isn't in the menu at all — it only opens from other windows.

    Related topics

    Was this article helpful?

    Missing a feature? Tell us.

    We will add it for free if other users need it too.

    If only you need it, we will agree on it separately.

    Article contents

    Suggest an improvement

    Try Elbuz free