The consolidated catalog is the working product database in Eofferix. It stores imported and manually created data: products, offers, sections, properties, prices, stock, images, descriptions, and technical identifiers.
The catalog acts as a working layer between data sources and final delivery. Sources update data according to their profile rules, and the consolidated catalog can then be exported, sent to an application, or adjusted manually where needed.
How to open the consolidated catalog
Open Consolidated catalog in the top menu. The screen shows product and offer counters, the section tree, the catalog table, and the main actions: add a source, export data, add a product manually, or open settings.
What is shown on the main screen
The section tree is on the left. It helps you open the needed catalog branch and see how many products are linked to each section. The table is on the right, with search, filters, the products/offers switch, column settings, and pagination.
Search covers the main catalog fields: ID, SKU, external code, name, supplier brand, and section. The filter button narrows the list, and the table shows only the columns enabled in the current view.
Search, filters, sorting, and table width
Global table search is useful for quick text lookup by name, SKU, external code, brand, section, and other fields available in the current view. For more precise narrowing, use the filter button next to search.
Click a column header to sort rows by that field. The arrow next to the column name shows the sort direction. Clicking again changes the direction. Headers also include controls for pinning and display behavior, so important fields can stay visible while you scroll horizontally.
Click the filter button, add a condition, then choose the field, comparison, and value. Conditions can work as a list of required rules or as alternative rules when records should match at least one condition. Match case matters for text fields where uppercase and lowercase letters should be treated differently.
The arrow button expands the table into a wider mode. Use it when you need to see more columns at once: properties, prices, stock, sources, and update dates. Clicking it again returns the standard view.
Products and offers
A product stores the general product card: name, brand, section, description, images, and properties. An offer stores a sellable variant: SKU, price, stock, availability, and other variant-level data. One product can have one or several offers.
To view sellable variants, switch the table to Offers. In this view, each row belongs to a specific offer and shows the linked product, offer name, SKU, price, stock, and update date.
Properties and columns
In addition to standard fields, the consolidated catalog can store custom properties. A property is an extra field on a product, offer, or section: material, color, delivery time, active flag, link, file, number, date, or dictionary value.
The property type affects how the field is stored and how you can work with it: text is searched as text, numbers sort and compare correctly, dates are filtered as dates, and dictionary values help avoid different spellings of the same attribute. These properties can be shown as table columns and used in filters when they are available in the selected view.
Property setup is covered separately: How to configure product, offer, and section properties. If characteristics come from a source as repeated name-value pairs, see Source characteristics for the consolidated catalog.
Sources and data origin
The Sources column shows where a record came from. It can be an import profile, a manual entry, or several sources if the record was matched with data from different places.
On the next upload, the source updates records according to the profile rules: Eofferix matches incoming data with existing products, offers, and sections. If identifiers match, the record is updated; if they do not, the next action depends on the import mode and source settings.
Prices, stock, price groups, and warehouse groups
The table usually shows the main price and available quantity, but a product card can store more values internally. This matters when the same product comes from several suppliers or channels.
A price type describes what the price means: for example purchase, retail, sale, or wholesale. A price group keeps one source or scenario separate from another, so Supplier A purchase price does not overwrite Supplier B purchase price.
A warehouse group separates stock values by supplier, warehouse, or channel. Inside the group, Eofferix can store a stock value such as available quantity. Stock rules then define which final value should be shown in the catalog and used in exports: sum, minimum, a value from a specific group, or another configured option.
For more context on when to use a consolidated catalog with price and warehouse groups, and when a regular export is enough, see Consolidated catalog or regular export.
Catalog sections
The Sections tree shows the catalog structure and the product count for each node. Clicking a section filters the table by that branch. The settings button in the tree header opens section structure management.
Sections can come from sources or be created manually. If a section is removed manually but the source keeps sending the same path and the profile is allowed to create sections, it can appear again after the next import. For stable cleanup, use section import rules and empty-section cleanup.
Main actions
The top area of the catalog contains actions for continuing work with the data:
- Add source - create a profile for loading data into the consolidated catalog.
- Export - prepare an export from the current catalog.
- Add product - create a product manually without importing it from a source.
- Settings - open consolidated catalog settings: section structure, properties, price rules, and other parameters.
How the catalog is updated
Catalog updates depend on the source profile settings. A typical flow looks like this:
- The source loads a file, API response, table, or another data set.
- Eofferix applies matching and transformation rules.
- Using the profile identifiers, the service looks for existing products, offers, and sections.
- Matched records are updated; new records are created or skipped depending on the selected import mode.
- After the upload, the consolidated catalog table shows the current data state, ready for export or delivery to an application.
It is important to separate manual edits from source-managed data. If a field is still updated by import, the next upload can replace a manual value. This behavior is configured in the source profile and import rules.
When to use the consolidated catalog
- When data comes from several suppliers or channels and must be gathered into one structure.
- When product cards and offers should be separated: general product data in one place, prices and stock in another.
- When sections, properties, prices, stock, and record origin need to be checked before export.
- When some data should be edited manually while other fields continue to update from sources.
- When the same catalog is used for several exports or applications.