Jobber Price List Missing Costs: Audit and Fix

If a Jobber price list is missing unit costs, audit the catalog before applying any cost-based markup. Export Products & Services, separate blank and zero costs from positive costs, then decide which rows need material costs and which are intentionally price-only. A cost correction does not automatically mean a selling-price change.

Why does a Jobber price list have prices but no costs?

Jobber stores a unit price for what the customer pays and, on select plans, a unit cost for what the item costs the shop. Its Products & Services guide says unit cost and markup fields are plan-dependent. A catalog can therefore be useful for quoting while having no cost data to support a cost-based pricing rule.

There are several ordinary causes. A shop may have imported a spreadsheet containing only names and unit prices. Staff may have created items directly from quotes without entering cost. An integration may expose the selling price while omitting the internal cost. Or a service may be priced as a flat fee while labor expense is recorded elsewhere. Do not treat every blank as the same problem.

Distinguish three states: a blank cost means no value was supplied; a zero cost means a recorded value of $0; and a positive cost can support markup math. A $0 cost on a truck-stock part is worth investigating. A $0 cost on a trip-charge line can be intentional if its labor and vehicle costs are accounted for through other records. The article's worked numbers are examples, not observed Jobber account data.

How do you audit missing costs in Jobber?

In Jobber, open Settings → Products & Services and export the list to CSV. Jobber says an export with fewer than 50 items downloads directly; larger exports arrive by email, and lists above 1,500 items are split into files of no more than 1,500 rows each. Gather every file before counting. If your plan does not expose a Unit Cost column, confirm plan access before interpreting the absence as zero cost.

Keep the original export untouched. In a working copy, count active products separately from services, then classify each cost cell as blank, zero, or positive. Filter zero-price rows too: a costed item with a zero selling price is a different problem. Preserve names, categories, tax status, and active status so you can later reconcile any edit against the baseline. The Jobber CSV update guide covers the file mechanics; this audit answers which costs actually need attention.

Worked example, not a benchmark: a 200-item export has the following cost coverage. The 52 rows with blank or zero cost are a review queue, not 52 errors. A technician may have intentionally priced some service rows without a unit cost.

Which zero-cost items should stay at zero?

Ask what the row represents before adding a number. Material part: enter the actual landed material cost from a current invoice, including any freight you intentionally assign to the item. Labor-only service: first decide whether labor is costed in the line item or through timesheets. Flat fee: identify what costs the fee is meant to recover and where those costs are recorded. Discount or credit: it may be a deliberate price adjustment, not a purchased input.

Jobber's job-costing guide warns that labor can be counted twice when it sits in both a line item's cost and timesheet or expense entries. Jobber recommends using product line-item costs for materials and recording labor through timesheets for job profitability. That accounting choice affects the quote-level cost fields you should populate. It does not mean a labor-only service is free to deliver.

Make a brief decision note for each exception: “material cost required,” “labor tracked in timesheets,” “manual flat fee,” or “retire duplicate.” A cost field is an input to pricing and job-cost reports. Filling every blank with a guessed number merely converts missing data into misleading data. If a product has no reliable invoice yet, keep its approved manual selling price and flag it for review rather than applying a cost-derived rule.

What happens to markup when you add a missing cost?

Adding cost can change the displayed markup without changing the unit price. Jobber says its CSV import recalculates markup when a unit cost or unit price changes on eligible plans; if cost is added but price is not changed, the selling price stays put. That is useful for preserving an approved rate, but the new margin may reveal that rate is too low. Markup and margin use different denominators: markup divides by cost; gross margin divides by price.

The next table is a material-only worked example, not a target margin recommendation. It assumes these costs were verified from supplier invoices and excludes labor, overhead, tax, and payment fees. The final column shows the price for an illustrative 50% material gross margin, calculated as verified cost ÷ 0.50. Whether to change the actual customer price is a separate business decision.

For the contactor, ($90 − $48) ÷ $90 = 46.67%. A $96 price gives ($96 − $48) ÷ $96 = 50%. The circulator already meets the illustrative target and needs no price change. The control board needs $600 to reach that same material-only margin. A contractor may choose a different outcome because installed labor, local competition, warranties, and overhead also matter. Use the margin and markup calculator with your own costs and target.

How should you correct the costs without overwriting prices?

Start with one category and a handful of representative rows. Record the original unit price and cost, the proposed cost, and the invoice or supplier sheet that supports it. For a small set, edit the eligible items in Jobber's Products & Services screen and verify what the quote picker shows. For a larger set on a plan that permits it, prepare a CSV from Jobber's sample headings and test a small import before updating the rest.

Jobber's CSV instructions say Unit Cost is available on select plans, each import is limited to 2.5 MB, and Unit Cost and Unit Price cells must be numbers without dollar signs. The “Update existing items” option can overwrite several fields, including price. Keep your approved Unit Price cells unchanged when you intend a cost-only correction; compare the import preview and a post-import export. If the account's QuickBooks connection controls the item list, check the legacy versus new QuickBooks ownership guide before using CSV. The source of truth depends on the integration version.

How does Pricebookr handle price-only Jobber imports?

Pricebookr's current catalog has a “No cost data” filter for items carrying a unit price without cost. It imports the price Jobber supplied and keeps that entered price as a manual price. When Jobber supplies no internal unit cost on a later import, Pricebookr does not erase a cost already entered locally. Cost-based markup and margin rules skip zero-cost items instead of producing a $0 selling price; the rules run reports skipped items so the owner can review them.

That creates two deliberate paths. If you have verified costs, enter them, preview the markup schedule on the catalog, and apply it only to eligible items you mean to move onto the schedule. If you do not have costs, use a price percentage or dollar adjustment and preview the before-and-after prices. The Jobber connection screen describes both choices. A cost entered after import does not by itself authorize replacing a hand-set price.

Pricebookr can maintain the master price book and preview which synced prices changed before an explicit push back to Jobber. A pricebook must be marked for Jobber sync, and pushing is a paid feature. For the broader CSV-versus-mapped workflow, see the Jobber price list sync guide. This is catalog maintenance, not an automatic repair of every blank cost in Jobber.

What is the safest order for a cost cleanup?

1. Export every Products & Services file and keep a dated untouched copy.
2. Count blank, zero, and positive costs; separate products from services.
3. Decide which costs belong on items and which labor is already tracked through timesheets.
4. Verify proposed material costs against current invoices; keep unsupported rows in review.
5. Test cost-only changes on a small set, then compare unit prices before and after.
6. Review margin and markup, choose any selling-price changes separately, and preview a sample quote.

A supplier increase is a good reason to rerun this audit. A complete cost column is not the goal; a defensible cost policy is. The material-cost increase guide covers the next decision once the inputs are reliable.

FAQ

Does a blank unit cost in Jobber mean the item is free?

No. A blank cost means the saved list does not supply that number; the shop may still pay for the part or labor. Check a current supplier invoice for products and the job-cost method for services. Keep an approved unit price in place until you can verify the missing input.

Will adding a unit cost in Jobber raise the unit price?

Not necessarily. Jobber says that when its CSV import updates cost without updating unit price on an eligible plan, the unit price remains the same and markup is recalculated. Confirm the result in your own account after a small test. A desired price increase is a separate edit.

Should labor cost go on every service line?

No. Jobber warns that labor in both a line item's cost and timesheets or expenses can double-count job cost. Decide where labor is recorded for your shop before filling service costs. A service can have a customer price while its labor cost is captured through timesheets instead of the saved item.

Can a cost-based markup rule price an item with zero cost?

A cost-based rule has no useful input when cost is zero: multiplying zero by any markup still gives zero. Pricebookr skips zero-cost items for its cost-derived rules, preserving the existing selling price for review. Use a verified cost before moving the item onto a cost-based schedule, or change its manual price deliberately.

How many rows should I test before a full Jobber CSV update?

There is no universal safe number. Start with a small set that includes a product, a service, a zero-cost row, and an item whose price must remain manual. Export again and compare price, cost, category, tax status, and active status before expanding. Jobber's per-import file limit is 2.5 MB.