↑↓ selectEnter openEsc close

    1. Elbuz
    2. Whose price goes to the catalog

    Product condition: keep discounted, used and refurbished items from linking to new ones

    5 min readUpdated

    On every price list import, Elbuz detects each row's condition (new, discounted, used, refurbished) and links it only to a card in the same condition. Discounted stock won't land in a new product's card.

    When you need this:

    • The supplier writes “DISCOUNTED” in the name: neither a rule nor AI links the row to a new card.
    • The whole price list is discounted: one “Default condition” marks all rows, no words needed.
    • The feed has a condition column: it's read instead of the name.
    • You export to Google Merchant, eBay or Kaufland: condition goes into the feed itself.

    Where to start: source card → “Settings” → “Products” → “Product condition”.

    What product condition does

    How the program detects the condition of a price list row

    There are four conditions, and the set is fixed: you can't add your own, you only set up the words the program recognizes them by. A row or card without a condition counts as new.

    ConditionWhat it means
    Newa regular product; everything with no words of other conditions found is marked this way
    Discounteda new product with damaged packaging, incomplete set, or a display model
    Useda product that has been in use
    Refurbisheda product that has been restored (refurbished)

    Condition is detected on every price list import, before matching, and again with the “Start product matching” button, without re-importing the file. Changed the words? Click this button and the new rules apply to the current rows.

    The exception is the “Product condition” column mode: there, new words and the default condition only take effect from the next file import, because the button sees conditions already set in the column.

    On a price list of about 300 thousand rows, detection adds 2–2.5 seconds to the import.

    Order of checks for each row:

    1. If words are to be looked for in the “Product condition” column and it already holds a condition code (new, discounted, used, refurbished), that code is used.
    2. Words for this price list: first “New”, then “Discounted”, “Used”, “Refurbished”.
    3. Shared words in the same order.
    4. No match: the row gets the “Default condition”.

    The first match wins. The name «Відновленний, уцінка!» gives “Discounted”: discounted is checked earlier, and the misspelled «відновленний» with a double “н” doesn't match the word «відновлений».

    How to write words

    • Separate with commas (semicolons work too), case doesn't matter: «уцінка» finds «УЦІНКА».
    • A word is matched as a whole: «б/у» finds «Ноутбук Б/У», but not «Б/УП.» (no packaging).
    • * at the end marks a word stem: «уцінен*» finds «уцінений», «уцінена», «УЦІНЕНИЙ».
    • Brackets and punctuation are written as is: «(нова)» finds «Кавоварка (нова)».

    A manual condition change in the price list product grid lasts until the next file import: the program re-detects the condition of all rows every time (in “Product name” mode, also with the “Start product matching” button). To make a condition stick, set a word or a default condition.

    How to set up condition for one price list

    Where: source card → “Settings” → “Products” → “Product condition” → “Configure”.

    The subsection is collapsed. The line under its heading shows what's set: the default condition, “Product condition” column if words are to be looked for in the column, and the price list's own words. If there are no own words, the line says “shared words”.

    Products section of the source settings with the collapsed Product condition subsection
    1Product condition title
    2Summary of the rules
    3Configure button
    1. Product condition — the subsection that sets how items of this source are classified.
    2. Summary — the default condition and the first words that mark a new item.
    3. Configure — expands the subsection to edit the rules.
    FieldWhat it doesDefault
    Default conditioncondition of rows where no word was foundNew
    Where to look for words“Product name” or “Product condition” column: the column mapped to the “Product condition” field in the “Columns” sectionProduct name
    Words for this price listfour fields, one per condition; apply only to this price list and are checked before the shared onesempty
    Shared words (all price lists)four fields shared by all sources; what they hold initiallythe program's word set
    Expanded Product condition subsection with the tooltip over the words field
    1Default condition
    2Where to look for words
    3New words field
    4Help icon with tooltip
    5Shared words row
    1. Default condition — the state given to items that match no word.
    2. Where to look for words — the field in which the words are searched.
    3. New — the words of this price list that mark an item as new.
    4. Help icon — the tooltip explains matching rules and the * stem.
    5. Shared words (all price lists) — the common words used by every source.

    “Shared words” are the same for all price lists. Editing them in one source's card changes condition detection in all the others. A cleared field stays empty: the standard words don't come back on their own, and you'll have to enter them again from the table.

    The form saves itself. New settings apply on the next import; to re-detect the condition right away, click “Start product matching” in the “Product matching settings” window.

    Which words the program looks for out of the box

    ConditionDefault shared words
    New— (empty)
    Discountedуценка, уцінка, уценен*, уценён*, уцінен*, некомплект*
    Usedб/у, вживаний, вживана, вживане, вживані
    Refurbishedвосстановленн*, відновлений, відновлена, відновлене, відновлені, refurbished

    Some obvious words are left out on purpose. «б/в» caught «дуб/венге» (oak/wenge) in furniture and «насос для б/в» (a wastewater pump). The stem «відновлен*» caught «Шампунь… відновлення», and «б/у» as a stem caught «Б/УП.». If your supplier writes exactly that, add the word to “Words for this price list”, and it applies to that supplier only.

    How condition affects matching

    A price list row links only to a catalog card in the same condition. This covers every automatic path:

    PathWhat happens with different conditions
    Automatic matching types: name, SKUs, custom rule, name from other price lists, SKU in name, external link, MD5 fingerprintno pair is set; the row keeps searching or stays unmatched
    Search indexthe index returns one best candidate; if it's in another condition, the row stays unmatched, and the program doesn't look for a second candidate
    Duplicates during “Add new products”a new product isn't merged with a card in another condition
    AI matchingthe model doesn't see candidates in another condition; if none are left, the row gets “No match”
    Previously saved AI suggestionson “Apply checked” they become “No match” with the reason “Different condition (new / discounted / used) — the product was not linked.”
    Manual linksaren't checked: the program doesn't remove a pair set by an operator

    A new card created from a price list row via “Add new products” or a base catalog update gets that row's condition. So a supplier's discounted item becomes a separate “Discounted” card in the catalog, next to the new one.

    How to change a product's condition in the catalog

    In the product card, condition is the “Product condition” list in the “Inventory and logistics” section, next to “Warranty unit”. A price list import doesn't overwrite the condition of an existing card, unless updating the “Product condition” field is turned on in “Updating base catalog”.

    The «Inventory and logistics» section of the product card, with the «Product condition» list next to the warranty fields
    1Product condition list
    2Warranty unit
    1. Product condition — the list that sets whether the product is new, discounted, used or refurbished.
    2. Warranty unit — the unit in which the warranty period is meased.

    The product grid and the price list product grid have a “Product condition” column: the cell shows the label, and a click opens a list of conditions. If you don't see the column, turn it on in the grid settings. The column filter accepts a label or its first three letters or more: “Discounted”, “Dis”, “Used”, “refurb”.

    Price list products grid with the open Product condition list
    1Discounted product name
    2Product condition cell
    3Open list of conditions
    1. Name of a row marked as discounted.
    2. Product condition cell of that row.
    3. Open list with New, Discounted, Used and Refurbished.

    How condition gets into exports

    Channels accept their own condition values, and none of them has a separate “discounted” condition. The program fills in the closest value the channel accepts.

    ConditionGoogle MerchanteBayKauflandHoroshop
    NewnewNEWNEWNew
    DiscountedusedNEW_OTHERUSED___AS_NEWUsed
    UsedusedUSED_EXCELLENTUSED___GOODUsed
    RefurbishedrefurbishedSELLER_REFURBISHEDREFURBISHED___VERY_GOODRefurbished
    • Google Merchant: in the product template, the g:condition element is filled by the {xml_condition} macro. Templates with a hard-coded “new” were switched to the macro by the program. More: exporting to Google Merchant.
    • eBay, Kaufland: condition goes into the listing automatically, nothing to set up.
    • Horoshop: the template field “Состояние товара”; it's off by default, turn it on in the template. More: exporting to Horoshop.

    Scenarios

    The supplier marks discounted items with a word in the name

    Names like «Oukitel F150 16/512Gb (Уцінка)». Nothing to set up: the shared words already include «уцінка» and «уценка». After import, such a row gets “Discounted” and won't link to the new product card; “Add new products” creates a separate “Discounted” card for it.

    The supplier sells only discounted stock and marks new items with “(new)”

    In this price list's “Product condition”, set “Default condition” to “Discounted”, and in “Words for this price list”, enter «(нова), (новий), (нове), (нові)» in the “New” field. Rows with that mark become new, the rest discounted.

    The supplier's feed has a condition column

    Map the column to the “Product condition” field in the “Columns” section, and in “Where to look for words” choose “Product condition” column. The program takes the codes new, used, refurbished as is. Add the supplier's own words, such as «Б/У» or «Як новий» (like new), to “Words for this price list”.

    The card name contains «Б/У» (used), but the supplier doesn't specify condition

    The card is marked “Used”, while the price list rows are detected as new, so the rule-based pair is removed. Set this price list's “Default condition” to “Used”, and the rows will link to the cards again.

    FAQ

    Where did “Discounted” cards in my catalog come from if I never set a condition?

    During the program update, cards with shared words in their names got the matching condition automatically. The rest became “New”. You can change the condition in the card or in the product grid.

    I changed the words, but the condition of price list rows didn't change. Why?

    Condition is re-detected on import. To skip the wait, click “Start product matching”: the program re-reads the rules without re-importing the file. In “Product condition” column mode, only a new import helps (how condition is detected).

    Can I add my own condition, such as “Display model”?

    No, there are four conditions. Enter a stem such as «вітрин*» (display) in the “Discounted” words, and such an item gets “Discounted” (how to write words).

    Can I manually link a discounted item to a new card?

    Yes. Manual links aren't checked for condition, and the program doesn't remove an operator's decision (how condition affects matching).

    Why does AI say “No match” when the product is in the catalog?

    The row and the card are in different conditions: the model doesn't receive candidates in another condition. Check the “Product condition” column in the row and in the card.

    What goes to Google Merchant for a discounted item?

    “used”: Google has only three conditions, and a discounted item is sent as used (table of values).

    Where to find it and who has access

    Menu
    Directories → Processing price lists → List of price lists → source → “Settings” → “Products”
    Other entry points
    product card, “Inventory and logistics” section; the “Product condition” column in product grids
    Access right
    the “List of price lists” window, blocks “Tab "Products"” and “‘Import settings’ tab: settings”

    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