Supplier price lists
In short
This is where wholesalers' price lists come together: prices, stock in their warehouses and delivery times. The program reads the suppliers' files, recognises the brand and part number and shows every offer for the same part side by side, cheapest first.
Why it matters
- Find quickly who has a part and at what price, without opening suppliers' websites.
- See the purchase price in euros even when the list is in zlotys or crowns.
- Send your prices and stock to sales channels and the online shop.
Who can
Reception, sales, finance, purchasing and the branch manager can view offers. Sources, loads, rates and brands: purchasing and the branch manager. No button means no permission: ask your administrator.
How to do it
- Find a part. "Search offers" tab → type the part number in any spelling (
0986494294,0 986 494 294), the EAN or the supplier code → suppliers' offers with unit price and lead time. - Connect a supplier. "Sources" tab → "New source" → code and name → price list format (a ready-made one or "custom", which opens the builder from a sample file) → how it arrives (manual, FTP, SFTP, link) and schedule. "Check the connection" signs in to the server and shows which files it sees (nothing is downloaded); saving a new server or password runs the check by itself, and if it fails you see why and "Save without checking". The same applies to the supplier API (Auto Partner).
- Upload a price list by hand. Open the source → "Upload files" → pick the files → "Send for processing".
- Check a load. "Loads" tab: how many offers, new, changed, gone and parsing errors.
- Set an exchange rate. On the "Sources" tab, in "Exchange rates to euro", choose the currency, enter how many euros one unit is worth and save — prices are recalculated.
- Match brands. "Brands" tab: brand spellings the program did not recognise — pick an existing brand or create a new one. The decision applies to all price lists. A new brand also appears in the stock brand reference ("Product catalogue → Reference data → Brands") if you may manage the product catalogue. Price-list brands with a TecDoc number get there on their own, together with their other spellings; a price list never renames a brand in the stock reference.
- Resolve product card discrepancies. "Loads" tab → "Cards" column → in the window, the list "the card says one thing, the price list another" (weight, dimensions, an EAN already on another product). On each row: "Take from price list", "Move EAN here" or "Keep as is". The decision is remembered; "Search the web" helps to check by brand and article or by EAN.
- Photos from the price list. In the format builder, the column with photo links ("Foto", "Image", "Zdjęcie"…) goes to the "Photo (link)" field by itself; up to three columns: "Photo 2", "Photo 3"; a cell may hold several links separated by ";". Photos are downloaded in the background for the products linked to the offer; a new upload adds only new links. Progress and errors: "Product catalogue → Data quality → Photo".
- Product type. The type column ("Tipo pieza", "Familia", "Rodzaj towaru"…) goes to the "Product type" field. It fills an empty card type from the product types list (the same spelling, ignoring case, is the same type), and a markup rule "by type" also applies to on-order goods.
- Name the people responsible for the price list. Open the source → "General" → "Responsible for the price list". If a load fails, is waiting for review (quarantine), stock has not been updated for a long time or new brands appear in the queue, they see a badge on "Price lists" and, at the top of the screen, a "Needs attention" list. "Acknowledged" removes the badge; if things get worse (for example, more new brands), the alert comes back. If nobody is selected, everyone who manages price lists sees the alert. "Stock outdated after, days" — after how many days without new stock to send an alert; from then on the source's offers are not sold (they are left out of the search, "What to order" and channel exports) and the source list shows "Stock outdated". Once a file with stock arrives, they are sold again.
- Fetch stock and prices at different times. Open the source → "Retrieval and schedule" → "Own schedule for the files of the set". For example, stock every 60 minutes and prices at 06:00 and 14:00. Each file is fetched on its own schedule; the program takes the other files of the set from the last load. "Same as main" follows the general schedule.
- Link an item to a product by hand. Open the source → "Manual matching": these are the items the program did not recognise by brand and number. "Link to product" → find the product → "Link". The link works right away and on every future load. For many items use "Upload a file": download the template, fill in the supplier code and the EAN (or brand and article), check and apply.
- Do not order what the supplier does not have. Open the source → "General" → "Do not order items out of stock". Then lines the supplier has no stock for are not sent in the API order (the program shows which were not sent), and in "What to order" the "On order from" mark for that supplier becomes "out of stock" and is not used in the order.
- Do not load what you do not need. Open the source → "Load rules" → "Do not load": brands; "no originals" or "originals only"; discontinued items (a custom price-list field and its values, for example "EOL"); a minimum price; items already present in another source of the same supplier; individual "brand + number" items, one by one or from a file. Rules apply from the next load, full or partial: an item dropped by a rule becomes unavailable. In "Loads", under the number of offers you see "not loaded: N"; hover to see which rule. "Present in another source" means the item is there with stock or "on request". The "discontinued" and "discount group" fields are custom price-list fields: map them to columns in the "Parsing profile".
- Adjust quantity and price. On the same tab, "Quantity and price adjustments". "Stock factor" 0.5 takes half of the stock (rounded down); offers show the quantity with "≈" and the supplier rating says "Stock not exact". "Price factor" applies to the whole list. "Discount group": choose the custom price-list field with the group and fill in the group table (code → multiplier, for example A1 → 0.62) by hand or from a file; a group missing from the table uses the "Multiplier for unknown groups". The list price before adjustments is shown in the offer. After changing the price factor or the groups, the next load may go to review (price jump): check it and press "Apply anyway".
- Lead times by weekday and order time. Source → "Supplier warehouses" → "Lead times by weekday and order time": the cut-off time (for example, 14:00) and, for each day, how many days to add to the warehouse lead time in working days, when ordering before and after it. By default, after the cut-off +1 working day: Friday after 14:00 — prepared on Monday; weekends and national holidays are skipped automatically. The time is in the time zone of the organisation's branch. The adjusted lead time shows in "Sourcing", "What to order" and the supplier order ("order before 14:00 — arrives Thu, 19/11"), in channel exports and on the website. In an export file the lead time is as of the moment the file was generated.
Common messages
- "Quarantine" on a load — the file looks wrong (far fewer rows, price jumps, many errors). Previous prices are untouched. Check the file; if it is right, press "Apply anyway".
- Fetch error under a source (e.g. "folder not found" or "wrong login") — check the address, folder and access at the supplier, then press "Fetch now".
- Parsing errors — click the number in the "Errors" column to see the file line and the reason.
- "Needs attention" at the top of the screen — alerts about sources: a failed load, quarantine, outdated stock, new brands. A failure or quarantine clears once a load is applied: the next correct file or "Apply anyway" on the "Loads" tab (after checking the file). New brands clear once matched on the "Brands" tab; outdated stock — with a fresh stock file.
Questions and answers
What format is accepted for a price list? An Excel sheet (XLSX) or a delimited text file (CSV, TXT); the program unpacks ZIP and GZ archives by itself. The columns are mapped by the price list format, a ready-made one or your own, set up from a sample file.
What happens to items missing from the new price list? It depends on the source setting "The price list arrives": "Complete — missing items become unavailable", with their stock set to zero; "Changes only" — items not in the file stay as they were.
Can I change when a price list goes into quarantine? Yes: "Sources" tab → click the source → the "Protection against faulty price lists (quarantine)" block: "Fewer rows, %" (30 by default), "Parsing errors, %" (5) and the pair "Price jump, %" (50) and "…for this share of items, %" (20).
Why does a price list item have no product card? It is set by the source setting "Product cards are created": "When the product is needed", "Never — manually only", "For selected brands" or "Immediately for all identified". Only someone with permission to manage the product catalogue can choose the last two options.
Who finds out that a price list did not load? The people responsible for the price list set in the source — they see a badge on "Price lists". If there are none, everyone who manages price lists. The same failure does not repeat as new alerts: it stays one alert until it is fixed.
How do I link a price list item to a product if the program did not recognise it? Source → "Manual matching" → "Link to product". The link is remembered: on the next loads the item goes straight to that product.
Where next
- Product card → "Suppliers" tab: offers for that product.
- "Markups" — how the selling price is derived from the purchase price.
- Customer card → "Sales channels": sending prices and stock to that customer.