If your project can't be templated and/or requires a large number of product or task lines, you can import these products in bulk via a .csv spreadsheet.    This is also useful where you use an external system to calculate your project costings, such as a cutting calculator etc.


Once the data has been imported in bulk, it can be managed on the project as required.


If you are experiencing errors importing your data, check here for resolutions for the most common messages or contact the WorkGuru team.


Bulk Add Products

Download the Bulk Add Product template from this page, or create your own with the following headers:

SkuProduct code (if code does not exist in the WorkGuru product list, it will be added to the project as an ad-hoc line.Required
NameProduct name (can be different from product to be specific to the project)Required
DescriptionProduct description (can be different from product to be specific to the project)
CostPriceUnit costRequired

SellPrice
Unit sell price.Required
QuantityNumber requiredRequired
BillableTRUE for billable, FALSE for non-billable.Required


Add or Edit a project from the project dashboard and click the +Bulk Add Products.

Click Choose File to select the product import template .csv file and click Save to apply.

Confirm the order of the line items imported on the project.


Bulk Add Tasks

Download the Bulk Add Task template from this page, or create your own with the following headers:

NameTask name (if task does not exist in the WorkGuru task list, it will be added to the project as an ad-hoc line.)Required
DescriptionTask description (can be different from product to be specific to the project)
CostPriceHourly cost rateRequired

SellPrice
Hourly sell rate.Required
QuantityNumber of hours requiredRequired
BillableTRUE for billable, FALSE for non-billable.Required


Add or Edit a project from the project dashboard and click the +Bulk Add Products.

Click Choose File to select the task import template .csv file and click Save to apply.

Confirm the order of the line items imported on the project.


Tips for a successful import:

  • Ensure you have included the required fields.
  • Ensure there are only numbers in the pricing columns. 
  • Pricing columns are required. If a product has no price, ensure a 0 is entered, not left blank.
  • Make sure formatting has been removed (e.g. '$') and a decimal point ('.') is used as the decimal delimiter, not a comma.
  • If you are updating products, ensure your SKU's haven't been auto-formatted by your spreadsheet application. Spreadsheet apps tend to strip away leading zeros and auto-format barcodes and dates. If a product can't be matched to an existing product by EXACTLY matching SKU's, a new product will be created.
  • Ensure columns and data doesn't have leading or trailing spaces.
  • If removing rows, ensure the row has been deleted rather than just the data it contains. Some spreadsheet apps will not remove the comma separators when deleting data instead of the row, causing an empty row (, , , , , ,) which will cause an error on import. This can easily be caught by inspecting the import template in notepad or a formatting-free text editor.