Bring prices in from Excel

Import prices reads your price list from an Excel workbook, a CSV file or rows pasted from a spreadsheet, matches each row to your tags and library parts, shows price now and after, and sets them all as one edit. Export prices writes the same columns back out.

If your prices are already in a spreadsheet, you do not have to type them. Import prices reads the sheet, matches each row to what your library has, and shows you every change before anything is stored.

Open it

  • In the Library, click Import prices… in the toolbar.
  • In Settings › Company, on the Tags card, click Import prices….

Both open the same dialog. It has three steps: the file, the columns, and the match.

Step 1: The file

  • Click Choose a file… and pick an Excel workbook (.xlsx or .xls) or a .csv file.
  • Or select the rows in your spreadsheet, copy them, click in the box and paste. That needs no file at all.

Step 2: The columns

Kredna shows the first rows of the sheet with a list above each column. It guesses which column is which from the header words and from the numbers. Change what it got wrong.

  • Name and Price are needed.
  • Unit, Code or SKU, Category and Vendor or note help when the sheet has them.
  • If the workbook has several worksheets, pick the one with the prices.
  • Headers are in says which row holds the column headers. Pick another row if a title sits above them, or No header row if the first row is already a price.

Prices are read as they are written: $1,234.50, 1234.5, 1.234,50 or 2.00/LF. A blank price, or one Kredna cannot read, is listed and left not set. It is never stored as zero.

Kredna remembers your columns on this computer, so next month's sheet is already set up.

Step 3: The match

Each row is matched in this order:

  1. A tag with the same name. Case, spacing and punctuation do not count, so "5/8 Type X" finds the tag 5/8" Type X.
  2. Library parts with that name that carry their own price. Parts with the same name and unit are set together.
  3. A library item with that name. The price goes to its part that carries its own price.

Every row shows what it applies to, the price now and the price after. The Match column says:

  • Matched: it goes to something you already have.
  • New: nothing has that name, so a new tag is made.
  • Ambiguous: it matches more than one thing, or its unit needs a choice. It is left out until you pick.
  • Skipped: it has no name, no price, a price of zero, or you left it out.

Click a row's Applies to to point it at something else, to Make a new tag, or to Skip this row. Click a column header to sort, and use the row of buttons above the table to see only the Matched, New, Ambiguous or Skipped rows. To change many rows at once, select them and right-click.

If your sheet lists many names your library does not have, Skip the new names leaves them all out in one click.

When the units differ

If your sheet says one unit and the price is kept per another, the Unit column flags it.

  • Where Kredna knows the conversion, it converts and shows it. A price of $2,400.00 per TON becomes $1.20 per LB.
  • Where it does not, such as a sheet priced per SHEET against a tag per SF, the row waits. Click the Unit cell and choose: use the number as it is, make the tag per the sheet's unit, or skip the row.

Kredna never guesses how many square feet are in a sheet or how many pieces are in a box.

Apply

Click the button at the bottom right, which says how many prices it will set. Everything is stored as one edit, and a note says what happened, such as "212 prices set: 180 tags, 32 parts · 14 rows skipped". Undo on that note puts everything back.

A code and a vendor go into a tag's note when the tag has none.

Jobs are not touched

Importing changes your company's prices: tags and library parts. A job keeps the prices it was made with. To bring the new prices into a job, open it and use Update from library in Pricing, which shows every change first.

Export prices

Export prices… sits beside Import prices. It writes every tag and every library part that carries its own price to an Excel workbook or a CSV file, with the same columns Import reads.

  1. Click Export prices… and save the file.
  2. Change the prices in your spreadsheet. Leave the other columns as they are.
  3. Bring it back with Import prices….

Every row finds what it came from. Rows you did not change say Already this price and nothing moves; only the prices you edited are set.

Where parts share a name but carry different prices, the export lists each one by its item, as "Item › Part", so each comes back to the right place.

Something here doesn't match what you see in the app? Tell us at support@kredna.com.