Engrana manual

Contents › Settings

Reference data

In short

The program's shared lists: "Work types", "Tax rates", "Units of measure", "Collections" and "Marketplaces", for the administrator. "Product categories" and "Brands" are in "Product catalogue → Reference data"; how to use them is below. Documents keep the values as of when they were created, so editing a list does not change estimates or invoices already issued.

Why it matters

  • Work in an estimate is picked from a list with a ready price or time: less typing and fewer mistakes.
  • A new tax rate is entered in advance and takes effect on its own on the right date.

Who can

Only the administrator of the whole installation.

How to do it

  1. Work types. If empty, "Starter set" loads a ready list. Your own: "+ Work type": code, name, category and "How the price is calculated": "Time × branch hourly rate" (estimated time) or "Fixed price". The name is in Spanish: it is printed on the estimate and invoice; "Name translation for staff" (Russian, English, Polish) is how the job appears in lists and appointments. Many jobs at once: "Import", a file with columns code, name, name_ru, name_en, name_pl, category, pricing, standard_hours, fixed_price. "Download template" in the import window gives a ready set of 223 workshop jobs with translations: load it as is or edit it first.
  2. Tax rates. "New rate version" → rate in % and "Valid from". The old version stays for past documents.
  3. Units of measure. Unit names in the interface languages.
  4. Product categories. The category tree and attributes for product cards. «Replace the tree» (for the installation administrator): first load the new tree with «Import categories», then tick only its sections — everything else is treated as the old tree (if all sections are ticked, no old tree is left and the replacement is refused), and for each old category with products or links the program suggests a new last-level one: by its products' kinds («kind → category» rule) or by name. Check and change if needed (or «No category»), then «Apply the replacement»: «kind → category» rules, marketplace links, storefront publication and collections move to the new categories at once, products are moved in the background (progress shows in the window whenever it is opened; «Stop» and, if some products were not moved, «Continue moving») and the old categories are archived. Old categories' attributes are not copied: product values stay free and bind to the new category's attribute with the same name.
  5. Brands. The brand list: name, full name, TecDoc number, "original" (vehicle maker) and every spelling of the brand ("Bosch", "BOSCH PL", "Robert Bosch" are one brand). In the product card the brand is picked from the list; next to it you see "in the brand list" or "not in the brand list". New brand: "New brand", or "Add brand" right in the card; if a similar brand already exists, the program offers to pick it. Duplicate: open the brand → "Merge into another brand": products and spellings move to the main brand. The whole list can be loaded with "Import" from a file of your previous program.
  6. Brands not in the list. "Brands" → "Not in the list": spellings on products that are not in the brand list. Click "This is BOSCH" (a similar brand), "Another brand…" or "Add brand" — the products are linked automatically. Under each spelling there are up to five cards (part number and name) and "All cards". Supplier spellings "OE VW", "OE BMW" are car-maker parts: "Fix: VW, original" sets the make as the brand and quality "O — original" (if not set); "BOS - BOSCH", "S - SASIC" carry the supplier's code in front: "Fix: BOSCH". New product and price-list uploads recognise these spellings on their own.

6a. Logos. In the brand card, "Upload logo" (PNG, JPEG or WebP; no SVG); "Brands" → "Without logo": parts brands without one, most products first, and "Logos as ZIP" (the file name is the brand). Vehicle maker brands do not show a logo. The logo appears on the product card and on the product page of the website.

  1. Manufacturer (GPSR). The brand card has a "Manufacturer (GPSR)" section: the manufacturer's address and contacts and, for a manufacturer outside the EU, the EU responsible person. By law these details are shown in the product offer on marketplaces and the website. The manufacturer's name is the "Full name". "Check status" helps track the work: "to check", "confirmed", "no data". The whole list with these columns loads through the same "Import"; an empty cell changes nothing, "-" clears the field.
  2. Collections. "Maintenance", "Tyres and wheels" and other top-menu entries of the website and quick filters of the "Product catalogue". A collection is built from tree nodes: a node comes with its branch below; "except" leaves the node's branch out. Products are not copied. Starter collections load with "Import collections" from docs/catalog/collections-start.csv. Which collections the website shows: "Shop" → "Collections".
  3. Marketplaces. Map the last level of our tree to a marketplace category (Allegro lists only in the last level of its tree): "Select" → suggestions from the node's Polish name and neighbouring nodes, or search. The mapping applies to every product in the node. Parameters of a mapped node: where Allegro parameter values come from when listing — category attribute, brand, part number, EAN, name or one value for all products ("Stan" — "Nowy"); for lists, which Allegro value matches ours. A parameter is shared by all categories, so it is set once. "List on Allegro" shows the required parameters without a value. The marketplace tree loads by itself once a day; "Import now" — within minutes. If the category disappears at the marketplace, the node becomes "Needs checking": choose another one. Via file — all nodes at once: "Download template" exports every last level of our tree with its current marketplace category and three "number — path" suggestions. Enter the number in the allegro_id column (or copy a whole suggestion); "-" removes the mapping, empty leaves it unchanged; the other columns are read-only. Then choose the file and click "Apply".
  4. Legal forms. S.L., GmbH, sp. z o.o. and other forms of five countries (ES, PL, DE, FR, IT) for customer and supplier cards: country, abbreviation, full name in the country's language, type (private person, sole trader, company) and whether a registration number is required. "Add form" or "Import" from a file. A form already used by cards cannot be deleted: "Archive" removes it from the choice and keeps it on the cards.
  5. Postal codes. A "postal code → place and province" list: when you type a postal code in an address, the town and province are filled in if they are empty; for a code with several places, only the one already used in cards is filled in, otherwise type the town yourself. Load it with "Import" from open data: Spain — CartoCiudad (IGN/CNIG), Poland — PRG addresses (GUGiK); put the source in the source column: it is shown in the table. "Clear" removes everything loaded for a country. The Spanish province is filled in from the first two digits of the postal code even without a file. The installation administrator prepares the file for Spain with the cartociudad_postal.py script from the Engrana source code (folder backend/scripts, Python 3.10+ required): download the CartoCiudad province archives in GeoPackage format from the CNIG download centre (centrodedescargas.cnig.es) and run python cartociudad_postal.py FOLDER -o codigos_postales_es.csv; the result is a file ready to import, one row per "code — municipality" pair, with the source "CartoCiudad © IGN/CNIG (CC BY 4.0)"; the program fills in the province from the postal code.
  6. Archive. Work types and categories are not deleted: untick "Active" and the record moves to the archive ("Show archived").

Common messages

  • "The starter set is already loaded" — nothing more will be added.
  • "no price set" — the work type has no price: it is entered in the estimate.
  • "Only with the Tyres module" — the work type is visible only when the Tyres module is enabled.

Questions and answers

Why can't a company administrator change the reference data? Work types, tax rates and units of measure are shared by the whole installation, that is, by all its companies, so only an installation-wide administrator changes them.

Can a wrong tax rate be corrected or deleted? Yes, until it takes effect: on the future version, "Delete", then create the correct one. A new rate is created in advance — from tomorrow or later: the rate in force is what price tags, the website and marketplaces are calculated with now, and a mistake would change customer prices at once. A version in force or in the past cannot be deleted; nor can a future one once documents dated from it exist (they were calculated with it). Prices entered in advance from the deleted rate's date are recalculated with the previous rate. A rate cannot be backdated. Enter rates as instructed by the gestor.

What happens when work types are imported again? A work type is matched by code: if it exists it is updated (empty cell: no change; "-": clear the field), otherwise it is created. Estimates and invoices already issued do not change.

Can a brand merge be undone? No: "Merge “…” into “…”? This cannot be undone." Products, numbers and spellings move to the main brand and the duplicate is archived. Brands with different TecDoc numbers are not merged: "The brands have a different … (… and …) — they are different brands."

Where next

  • "Companies" — the branch hourly rate.
  • The estimate in a repair order, where work types are used.