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
- On Price book, find Import from a spreadsheet and choose an Excel or CSV file. For Excel, Mezzo reads the first sheet. Open it
- 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.
- Set Kind when not given for rows with no kind, and If an item already exists to Update it or Leave it alone.
- Read the preview: how many items are ready, which rows will be skipped and why, and the first few items.
- 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.