Bulk Add Tasks and Products to Projects

Modified on Thu, 22 Aug at 1:27 PM

If your project can't be templated or requires a large number of lines items you can bulk import product and task lines via a .csv spreadsheet.  This is also useful where you use an external system or software to calculate your quote 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
PhaseAssign an existing or new phase to the line item


Add or Edit a project, click Actions 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
PhaseAssign an existing or new phase to the line item


Add or Edit a project, click Actions and click the Bulk Add Tasks.

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.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article