Skip to main content
Mezzo

Setting up your business · For contractors

Import a price list from a spreadsheet

Bring a supplier’s price list or another quoting tool’s export into your price book from an Excel or CSV file. You check the columns and see a preview before anything is saved.

You’ll be asked to sign in first.

Import

  1. On Price book, find Import from a spreadsheet and choose an Excel or CSV file. For Excel, Mezzo reads the first sheet. Open it
  2. Check Which column is which? Mezzo guesses; fix any it got wrong. Name and Price are required; the rest (Description, Kind, Unit, Your cost, Taxable, SKU / part number) are optional.
  3. Set Kind when not given for rows with no kind, and If an item already exists to Update it or Leave it alone.
  4. Read the preview: how many items are ready, which rows will be skipped and why, and the first few items.
  5. Choose Import (number) items. You see how many were new, updated or left alone.

Questions

How does it know an item already exists?

By SKU when the row has one; otherwise by the same name.

What files work?

An .xlsx file up to 2 MB, or a CSV. An old .xls file must be saved again as .xlsx or CSV first. Up to 5,000 rows at a time.

Words used here

Price book
Your saved labor rates, materials, packages and fees, reused when you build a quote. The AI quote draft only uses your prices.
Sales tax
Tax on taxable quote and invoice lines. You keep a rule per state; Connecticut’s 6.35% is offered as a starting point.

Did this help?

Related

  • Build your price book · Save the rates, parts, services and fees you quote again and again, so a quote is built by searching instead of typing. Your costs and margins stay private.
  • Keep a materials catalog with your markup · List the materials you buy with your cost and supplier, and let Mezzo work out the client price from your markup. The markup never shows to customers.
  • Export your business data · Download your customers, jobs, invoices or job payments as spreadsheets to keep, to move, or to give your accountant.
  • Your customer list · Everyone you do work for in one list, with each customer’s jobs, quotes, invoices, leads and service plans, house by house. Add people by hand or import them.
  • Upload your insurance certificate and share it · Every business needs a general liability insurance certificate, at least $20,000 per occurrence, checked by Mezzo, to quote. Once it is checked you can send anyone a two-week link to it.
Import a price list from a spreadsheet · Help · Mezzo