↑↓ selectEnter openEsc close

    1. Elbuz

    How to run multiple stores from one catalog

    5 min readUpdated

    Elbuz runs several websites from one catalog: each store has its own assortment, prices and stock, and the website export takes only its products.

    When you need this:

    • Your second website sells part of the range — the store gets its own assortment, and only its products are exported.
    • Websites have different prices — price, RRP, cost price and stock are set per store.
    • Storefronts are split by section or supplier — the store's assortment builds itself by category or supplier.
    • A product is in the catalog but not on the website — per-store checks show where it dropped out.

    Where to start: add a second store with the checklist.

    What Elbuz can do with multiple stores

    What a store is and what gets linked to it

    One row in the directory is one store. The row itself holds little: name, description, website link, address with coordinates, sort order and three flags — “Active”, “Main” and “Export to website”.

    What makes a store matter is not these fields but what is assigned to it. Five kinds of records are linked:

    • products — and with them their own price, RRP, cost price, stock status and quantity for this particular store;
    • categories — edited in the category card, “Stores” block;
    • contacts — edited in the contact card;
    • manufacturers — added by the app to all active stores and not editable by hand anywhere;
    • articles — filled in automatically, with no separate screen.

    Warehouses also belong to a store, but that is a separate topic — you won't need it here.

    With one active store, the app writes no links at all. This is neither an optimization nor a coincidence: every place where a link could appear — creating a category, manufacturer or contact, importing a price list, importing a file, adding products in bulk via — has the same condition: “more than one store”.

    So in an account with one storefront, the is empty even with a catalog of a hundred thousand items — and that is the correct state.

    Filtering by store isn't applied anywhere either, so everything works as if stores didn't exist.

    This leads to the cheapest trap in the topic: if you have one store and select it in an export template, the file comes out empty. Not because something broke, but because the store's assortment is empty and there is nothing to select.

    How to add, edit and delete a store

    The window is a grid of twelve columns and a toolbar with two buttons and a menu. There is no separate store card in the directory: you edit everything right in the cells by double-clicking, and changes are saved at once, without a “Save” button. A page holds 25 rows; sorting and a filter row are available.

    Columns: “Active”, “Main”, “Store name”, “Description”, “Website URL”, “Export to website”, “Latitude”, “Longitude”, “Address”, “Sort order”, ID and UUID. The last two are read-only.

    Creating a store

    The “Add” button inserts a row at the top of the grid, puts the cursor straight into “Store name” and fills in a temporary name like “New store #3”. Only the name is taken from the form: a new store gets “Active” and “Export to website” turned on, and “Main” turned off.

    A new store is created with a full copy of the catalog. At creation, the app runs five queries in a row that copy into it all the account's products, categories, contacts, manufacturers and articles. On a demo database with 126,934 products that is 144,375 rows in one synchronous step — the window just waits, with no progress indicator.

    So right after creation the second store contains exactly the same as the first. Then you either narrow its assortment by hand or rebuild it — by category or by supplier, as described below.

    If creation is interrupted, the store is either created completely or not created at all. How to tell which — in the section “What to do when a store isn't created”.

    “Main”

    There is always exactly one in the app. As soon as you select the “Main” checkbox for one store, it is cleared from all the others — without a question or a confirmation.

    This matters beyond looks: the main store's price, availability and quantity are the same fields shown in the base catalog columns.

    Deleting

    The “Delete” button shows a list of what will be deleted, with IDs and names. There are two cases where the app refuses:

    • the store is marked as “Main” — make another store main first;
    • the store has ID = 1 — this row can never be deleted, whatever its flags.

    In all other cases the store disappears together with all its links: products, categories, contacts, manufacturers and articles. And a product's link to a store also carries the price, RRP, cost price and stock for that store. There is no Trash, and nothing can undo the deletion.

    Export templates that had this store selected do not switch to the whole catalog after deletion: they export nothing and write a red line about the deleted store to the log. Select another store or “All stores” in those templates.

    Menu

    A three-line icon with the tooltip “Additional operations”. It holds three items: “Refresh”, “Clear filter” and “Assign products to stores” — the window's main operation, covered in How to build a store's assortment.

    The additional operations menu of the Stores window with three items
    1Assign products to stores
    1. Assign products to stores — the main operation of the window is hidden in this menu.

    How to see a store's assortment in the category tree

    is turned on in Account → System settings → Catalog → “Data processing rules”, with the “Multiple stores mode” switch. It is off by default, and the hint in the app says it plainly: “With a single store it only complicates the interface.”

    What changes when it is on:

    • the stores themselves become the top level of the category tree — active ones only;
    • categories sit under their store;
    • clicking a store node or any category inside its branch shows only that store's products in the grid.

    What does not change and is not filtered by store:

    • the tree root — it still shows all products of the account;
    • price, availability and quantity in the base catalog columns — these are the product's own fields, that is, the main store's data, not the store you picked in the tree;
    • contacts, documents, price lists and directories — their windows have no filtering by store;
    • the base catalog has no matrices by store: only by warehouse, attribute and supplier.

    Here is how it looks: at the tree root, store rows stand in place of the usual root categories, each with its own category structure inside, and a category assigned to two stores appears in both branches. Click a store — you see its whole assortment; click a category inside a branch — only its products in that store.

    There is no separate store switcher in the interface either — store selection lives only in the category tree and only in this mode.

    What is set per store and what for the whole account

    The store itself holds exactly what you see in the grid: name, description, “Website URL”, address, latitude, longitude, sort order and three flags. A store keeps no currency, no language, no storefront template and no settings.

    Three things are set globally, with one value for the whole account:

    • “Multiple stores mode” — off by default;
    • “New product store membership follows categories” — off by default;
    • how per-store stock behaves during a — the “Stores” section in the base catalog update settings.

    Price, RRP, cost price, stock status and quantity, on the other hand, are each store's own, and they live in the product card, “Stores” block.

    Scenarios

    Two websites from one catalog

    Task: run a second online store from the same catalog, each website with its own range.

    What to do: go through the checklist.

    Second store step by step

    The last step is not a formality: before the start, the app doesn't check whether the selected store has even one product, and you'll see the empty file before any warning.

    Result: each export template sends to its file or website only the products of the store selected in it. Price, availability and quantity can be set separately for each store in the product card, “Stores” block. You don't have to turn on multiple stores mode for this: it only shows stores as the top level of the category tree.

    One store

    Task: one storefront, and the store's assortment is empty.

    What to do: nothing. With one active store, the app creates no product–store links at all, and filtering by store isn't applied anywhere.

    Result: everything works as if stores didn't exist. Don't select this single store in an export template: its assortment is empty, and the file will come out empty.

    Scenarios for storefronts split by section, by supplier or managed on the website are in How to build a store's assortment.

    What to do when a store isn't created or deleted

    Symptom, cause and what to do
    What you seeWhyWhat to do
    “Store not created: copying the catalog into the new store failed, changes were rolled back.” An error occurred while copying the catalog, and the app rolled everything back, including the store row Don't clean anything up — click “Add” again
    “Status: … Error: …” after “Add”, and the new row is gone The server's response didn't arrive; whether the store got created is unknown Click “Refresh” in the menu. If the store is in the list, it was created completely; clicking “Add” again would add one more, again with a copy of the catalog
    “Deletion failed” You are deleting the main store or the store with ID = 1. The app doesn't name the reason Make another store main and try again; the row with ID = 1 can never be deleted (deleting)
    “Select a row!” You clicked “Delete” without selecting a row Click the store's row and try again
    The “Main” checkbox disappeared from a store Another store was marked as main: there is always one main store, and the checkbox is cleared from the rest without a question Select the checkbox for the store whose prices should be in the base catalog columns (main store)

    FAQ

    Can I delete a store and bring it back?

    No: there is no Trash, and all of the store's links, prices and stock disappear with it. The store with ID = 1 can't be deleted at all, and the main store can't be deleted until you make another one main (deleting).

    Can I give a store its own currency, language or design?

    No. A store is an assortment plus a few fields: name, description, website link, address, sort order and three flags. Currency, language, design and SEO are not set here (what is set).

    How do I see how many stores a product is in?

    The base catalog has no column or matrix by store. You can see the assortment in the product card, “Stores” block, or in the category tree in multiple stores mode.

    A product is in the catalog but not on the website. Where do I start?

    With the “Store” field in the export template: the selected store lets through only products from its assortment. Then six more checks in order: A product is in the catalog but not on the website.

    The new store's assortment is a full copy of the first one. How do I narrow it?

    Set stores in category cards and run “Assign products to stores”, or mark the store in supplier cards: How to build a store's assortment.

    Where to find it and who has access

    Menu
    Directories → Base product catalog → Shops
    Other ways in
    the “Stores” shortcut on the desktop; document list → menu → “Dictionaries” → “Stores”
    Access right
    the “Stores” window; adding, deleting and assigning are separate block permissions
    Prepare
    a decision on how to split the range — by catalog category or by supplier

    The block permissions are called “Button "Add Store"”, “Button "Delete Store"” and “Operation "Distribute products across stores"”. Without the right to the “Stores” window itself, no action in the directory works: not the list, not creating, not assigning.

    Ctrl + K search won't find the window: it searches products, contacts and documents, but not app windows.

    The Stores window: toolbar with Add, Delete and additional operations, and the grid with store columns
    1Add button
    2Main column
    3Export to website column
    1. Add button — creates a new store; use it with care.
    2. Main column — marks the default store.
    3. Export to website column — controls whether the store's products are exported to the site.

    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