Skip to content

Suppliers

  • Suppliers

  • Viewing the supplier register

  • Reading a supplier's record

  • Managing a supplier's qualification file

  • Reviewing documents uploaded by suppliers

  • Suspend, exclude or reinstate a supplier

  • Configure categories, document types and requirements

  • Create a price list and submit a version on the supplier's behalf

  • Reviewing a price list version line by line

  • From decision to active price list: effective date, units, and publication

All modules

Create a price list and submit a version on the supplier's behalf

Suppliers · 8 of 10 · 6 min read

A price list collects a supplier's prices in a given currency. Each submission from the supplier becomes a new version of the price list. From this page you create a price list and submit a version on the supplier's behalf, for example when they send you the file by email instead of uploading it from the portal.

How price lists and versions work

A supplier has one price list per currency. The page subtitle summarises this: “One per supplier and currency; every submission is a version.” A submitted version can no longer be edited: to correct it, a new submission is required.

Usually it is the supplier who submits versions from the portal. There they map the file's columns, read the outcome of each row, and can withdraw a submission as long as it has not been decided. Submit a version on their behalf only when the file reaches you another way, for example by email.

Each submitted version goes through review. Unchanged rows are accepted immediately. The others remain pending until someone accepts or rejects them.

Open the price list index

The index shows all supplier price lists, sorted by name.

  1. Open Suppliers › Price lists.

The list of supplier price lists

The index has these columns:

  • Name: the name of the price list, for example Cheese and dairy.
  • Supplier: the price list's supplier, for example Caseificio Colle Alto.
  • Availability: the organisational units for which the price list applies, either Every unit or Some units.
  • Effective version: the number and effective date of the current version, for example v2. If no version is in effect, the column is empty.
  • Status: Effective if the price list has a version in effect.

To search for a price list use the Search… field. To filter the index use the Status filter, with the options Submitted, Under review, Resolved and Effective.

Create a price list

Create a price list when a supplier sends you prices for the first time. The dialog described below has no currency selector.

Before you start: the supplier must already be in the register, meaning they must be a contact marked as a supplier.

Note: on desktop the New price list button only appears when the price list index is empty. On a phone screen it is always visible.

  1. In Suppliers › Price lists press New price list.
  2. Fill in the fields in the dialog.
  3. Press Save.

The dialog has these fields. They are the same as in the Edit price list dialog.

  • Supplier: the supplier contact to whom the price list belongs. The field is required.
  • Name: the name of the price list, for example Cheese and dairy. The field is required.
  • Active: indicates whether the price list is in use. It is active by default.

To close the dialog without saving press Cancel.

Open a price list and edit it

The page for a price list shows its versions, the units it applies to, and the submission section.

  1. In Suppliers › Price lists click on the price list, for example Cheese and dairy.

The Cheese and dairy price list page with the Versions section

The header shows the supplier and availability, for example Caseificio Colle Alto and Some units. The Available to section lists the organisational units: in the demo Cheese and dairy applies only to the Restaurant.

The Versions section has one row per version, from the most recent. Each row shows:

  • the number, for example v2;
  • the type, for example Full list;
  • the name of the submitted file, with the date and time of submission;
  • the Valid from;
  • the variation count: new rows (+), changed (~), removed (−) and unchanged (=);
  • the status, for example Effective or Superseded.

In the demo, v2 of Cheese and dairy is Effective and v1 is Superseded.

To change the supplier, the name, or the active status of the price list:

  1. Press Edit. The Edit price list dialog opens.

The Edit dialog for the Cheese and dairy price list

  1. Change the Supplier, Name or Active fields.
  2. Press Save.

Full list or increment: which to choose

The version type determines what happens to items that are not in the file.

  • Full list (missing articles are removed): the file replaces the entire price list. Items missing from the file become Removed.
  • Increment (only the lines sent change): only the rows present in the file change. The others remain unchanged. You can choose this only if the price list has an effective or superseded base version.

If the supplier sends you their entire catalogue, choose Full list (missing articles are removed). If the supplier sends you only the prices that are changing or new items, choose Increment (only the lines sent change). If the supplier has removed items from their offer, choose Full list (missing articles are removed): with an increment, the removed items would remain in the price list.

If the price list has an effective or superseded base version, the default is an increment. Otherwise the default is a full list.

Submit a version on the supplier's behalf

The submission is done in the Submit a version on the supplier's behalf section, at the bottom of the price list page. It takes two steps: first you choose the file, then you map the columns.

Before you start: you need the price list file in CSV, Excel (.xlsx) or OpenDocument (.ods) format.

  1. Open the price list, for example Cheese and dairy from Caseificio Colle Alto.
  2. In Price list file choose the file, for example listino-colle-alto-inverno.csv. The system reads the file and shows its columns.
  3. If the file has more than one sheet, in Sheet choose the sheet to read.
  4. Choose the version type: Full list (missing articles are removed) or Increment (only the lines sent change).
  5. In Valid from enter the date from which the new prices apply.
  6. Map the file's columns to the price list fields.
  7. If needed, write the Notes for the review.
  8. Press Submit version.

The section accepts CSV, Excel (.xlsx) and OpenDocument (.ods) files. Sheet appears only for files with multiple sheets. An increment requires an effective or superseded base version; without a base, use a full list. Notes for the review is optional.

Important: Submit version remains disabled until you map a column to every required field.

Tip: the column mapping is remembered for each supplier. On the next submission from the same supplier the columns are already mapped.

What happens after submission

After Submit version the section clears and the new version appears in the Versions section.

The system compares each row with the base version and classifies it as New, Changed, Removed or Unchanged. It maps each row to a catalogue item by searching first for the barcode, then our code, then the codes previously used by the supplier. Rows it cannot map are marked Not mapped.

Unchanged rows are accepted immediately. The others must be reviewed in Suppliers › Review queue. When no lines remain pending, the system checks Valid from. If the date has arrived, the version becomes Effective immediately; a future date leaves it Resolved until the nightly check. If no lines were accepted, the version is rejected when its effective date is checked. When the version becomes effective, the previous one becomes Superseded.

← Previous

Configure categories, document types and requirements

Next →

Reviewing a price list version line by line

On this page

Book a demo

See it on your company, not on a slide deck.

In 30 minutes we map the software you use today.We show you how much work and how much margin Archimedes gives back.

Show me on my business →
No commitmentReply within one working day