Guides / Rates
Export your rates
The same workbook, with your own rates already in it. It is how you edit hundreds of rates without doing it one card at a time, and how you keep a copy before a price rise.
What you need first
- Rates already in Casework, typed or imported
- Owner access. The Pricing tab is owner-only, and so is this download
By the end of this guide you have a spreadsheet of every rate Casework holds for your shop. It is one press, and it reads nothing but your own workspace.
Press Export current rates
Read what came out
The same three sheets as the template, filled in: Shop rates, Ballpark and Catalogue. Every column still carries its note in row 2, and the key columns are filled in rather than blank.
A value your shop has not set comes out as an empty cell, not a zero.
Edit it in the spreadsheet
This is the point of the export. A catalogue of several hundred rates is a morning of clicking in a browser and ten minutes of find-and-replace in a spreadsheet.
Leave the Key columns alone on rows that already have one. On a row you add yourself, leave the key blank and Casework fills it in.
Import it back
Import a workbook, pick the edited file, read the preview, press Apply these rates. See Import a workbook.
Export before you change anything
An import replaces your rungs and your catalogue with what the file holds, so an export taken first is the way back. It is also worth having as a dated copy of what you were charging before a price rise, because Casework keeps the current rates rather than a history of them.
What happens next
If you would rather not touch a spreadsheet at all, every rate is editable in the product: Type your rungs by hand.
