How to
You can create many Kits at once, complete with their supplies and labour, by filling in the Kit Import Template in Excel and importing it. The spreadsheet can be filled in by anyone, including someone outside your business, and you import the finished file.
Before you start
- You need permission to import data and to edit Kits.
- Set up your Labour Roles first. Each labour row names a Role, and a name Ascora doesn't recognise is added as a new Role.
- If a Kit should use supplies already in your supplies list, have their Part Numbers to hand.
How the template is laid out
The template has three sheets. Keep the sheet names and the column headings as they are, because the import reads them by name.
Kits: one row per Kit. Supplies: one row per material in a Kit. Labour: one row per labour item in a Kit.
Kit Link on the Supplies and Labour sheets is what joins a row to its Kit. Type the Kit's Part Number from the Kits sheet. If the Kit has no Part Number, type its Description exactly as it appears on the Kits sheet. Capital letters don't matter. A row whose Kit Link matches no Kit in the same file, or that has no Kit Link, is skipped.
Import Kits
Go to Advanced > Import, click Download templates and choose Kits.
The Kits card on the same page also has a Download the Kit Import Template link.
On the Kits sheet, add one row for each Kit.
Fill in a Part Number (for example KIT-001), a Description (the Kit's name) and a Pricing Method: Sell Price of Components, Markup on Cost or Fixed Price. For Markup on Cost, enter the percentage in Markup. For Fixed Price, enter Total Ex Tax or Total Inc Tax. Category, Unit of Measurement, Account Income Code and Is Favourite are optional.
On the Supplies sheet, add one row per material, with Kit Link set to the Kit's Part Number.
Fill in the Part Number, Description and Quantity (blank means 1). If the Part Number matches a supply already in your supplies list, the Kit uses that supply and its price. If it doesn't, the row is added to the Kit as a write-in at the prices on the row: Cost Ex Tax and Sell Price.
Tip To use one of your existing supplies, copy its Part Number exactly from your supplies list. A typo creates a write-in instead.
On the Labour sheet, add one row per labour item, with Kit Link set to the Kit's Part Number.
Fill in Role, Hours and Description. Role must be filled in on every labour row. Leave Rate blank to use the Role's own hourly rate, or enter a rate to override it for this Kit.
Save the file as .xlsx.
Keep the Kit Import Template's sheet names and column headings.
Go back to Advanced > Import and, in the Kits card, click Import Kits.
Choose your file or drag it onto the window, then click Begin Import. When it finishes, click View Kits to check them under Inventory > Kits.
Example: one Kit with materials and labour
Kits sheet: Part Number KIT-001, Description Split system install, Pricing Method Sell Price of Components.
Supplies sheet: two rows, both with Kit Link KIT-001. One for the indoor and outdoor unit (Quantity 1), and one for the pipe kit (Quantity 1).
Labour sheet: one row with Kit Link KIT-001, Role Technician, Hours 4, Description Install and commission.
Re-importing a Kit replaces its contents
A Kit that already exists (matched on Part Number, or on Description when there is no Part Number) has all of its supplies and labour replaced with what is in the file. Include every line the Kit should have, not only the new ones.
Good to know
- The file imports as a whole. If any row has an error, such as a labour row with no Role, no Kits are imported. Fix the row and import the file again.
- Import a file with one or two Kits first and check them under Inventory > Kits before building the rest.
- The Import rules link on the Kits card lists these rules too.
- Import from Cavsoft on the same card reads a Cavsoft kit XML export instead. It always adds new Kits, so importing the same file twice creates the Kits twice.
Common questions
What goes in Kit Link?
The Part Number of the Kit the row belongs to, from the Kits sheet in the same file. If that Kit has no Part Number, use its Description instead.
Why is a Kit missing some of its supplies or labour after the import?
Those rows had a Kit Link that didn't match a Part Number or Description on the Kits sheet, so they were skipped. Check for spelling differences and extra characters.
The import says to check the template details and retry. What does that mean?
No Kits were found on the Kits sheet. Check the sheet is still called Kits and its column headings are unchanged.