The review screen is the last step before anything reaches your inventory. It shows every row the sheet contained, what each one would do, and anything worth a second look. See Importing a Vendor Price Sheet for the steps before this one.

At the top it tells you in plain words what the rules will do, for example "Cost from dealer cost plus the surcharge column. Retail from MAP, rounded up to the next .99." If that is not what you want, click Change columns and pick again.

**New products and ones you already have**

Manifold matches each row against your inventory by barcode first, then part number, then brand and part number. Rows marked New would create a product. Rows showing a product code are ones you already carry, and the old cost and price are shown underneath the new ones so you can see what would change.

Occasionally a row says "Several match". That happens when more than one of your products shares a barcode. Manifold will not guess which one you meant, so that row is left unmatched for you to sort out.

A row may also say "Looks like" and offer one of your products. That is a part number close to one you already carry but not the same, for example a vendor prefix you never kept, or a variant letter on the end. Manifold never acts on a guess like that. It gives you a dropdown: pick the product it means, or choose "It is new" and it will be created. Whichever you pick is remembered, so changing the rules and re-reading the sheet does not ask you again.

Close never means close enough on the numbers. A part number whose digits differ is always a different product, so a 12 inch sub is never offered as a match for a 10 inch one.

**Rows that need a look**

Most rows import quietly. Manifold only flags the ones worth checking, and it says why, next to the row number it came from so you can find it on the original sheet. Typical flags:

  • A barcode that fails its check digit, which means it is simply wrong on the sheet. This happens more often than you would expect.
  • A cost above the price, which would have you selling at a loss.
  • A price well out of line with the rest of its section.

Rows with a real problem are never ticked for you. Use the filter at the top to show just "Needs a look".

**Correcting a value**

Any value can be edited. Type over the cost, price, description or barcode and click Save changes. Your correction is what gets imported.

What the sheet said is always kept and shown underneath your correction, so you can still see what the vendor sent. A correction also changes what the Change column reports, because it measures against the figure that is actually going to be imported. Clearing a box puts the vendor value back. Corrections survive changing the rules and re-reading the sheet, so you can fix a few rows and still switch from MAP to MSRP afterwards without losing your work.

A correction is checked before it is accepted: a barcode has to be a real barcode, and a price has to be a price.

Each row also has its own low stock and max stock boxes. A vendor sheet says nothing about how many of something you keep on the shelf, and neither does a category, so these are yours to type where you want them. Leaving one blank means zero on a product the import creates, which is what a product you do not want the Restock Assistant chasing looks like. They are never written to a product you already have unless you tick the matching box below.

You can drag the edge of any column heading to give it more room, and double-click an edge to put one column back.

**Choosing what to import**

Tick rows individually, or use Select every clean row, Select the new products, or Select the existing ones. Those three act on the rows your filter is showing, and each says how many that is. Your selection builds up as you move between filters and sections, and Clear all starts over.

For products you already have, you choose what gets updated. Cost, retail price, the name, the MAP and the barcode are ticked for you. MAP is the only one of those that is not really yours: the manufacturer publishes it and changes it with each book, so a newer sheet is simply the better answer. The rest are not: the description and the category where the product has none, the minimum sell price, the dealer price, and the low and max stock levels. Anything you leave unticked is never written to a product you already carry. You have tuned those numbers over time and a vendor sheet has no business resetting them.

Two of them are careful on purpose. A barcode you already have is never overwritten, because if you corrected one against the box you know something the vendor sheet does not. And the name only fills in products whose name today is just their part number, which is what a catalog brought over from an older system usually looks like. A name you typed yourself is never replaced, and your part numbers are never rewritten at all.

**When it is a vendor's new price list**

Importing a sheet from a vendor you have imported before is the common case after the first time, and the question then is not what is on the sheet but what changed. The filter at the top has a "Price changed" option listing only the rows where this sheet would move a price you already have, with the count beside it. The heading tells you how many went up and how many went down.

Those rows show a Change column: what the cost would do and what the retail would do, in dollars and in percent, up in amber and down in green. Cost and retail are shown separately because a vendor can raise one without the other, and a cost rise you are not passing on is the one worth catching.

Sort by "Biggest change, by percent" or "by dollars" to bring the real movers to the top instead of reading a nine hundred row book in page order. A five dollar rise matters more on a twenty dollar part than on a nine hundred dollar amplifier, which is the difference between those two sorts.

"Select everything that changed" then ticks exactly those rows, so you can import the repricing and leave everything else alone.

Every change counts, including a single penny. Nothing is hidden for being small.

**Undoing an import**

Open the sheet from Inventory, Vendor Price Sheets and click Undo This Import. Every price goes back exactly as it was, and products the import created are removed.

Anything sold, ordered or counted since the import is left alone and listed for you, so nothing you have used disappears. Past invoices are never changed: a line keeps the price it was sold at.