Skip to main content
Who uses this: Admins — item imports run from Company Settings. Availability: All regions. Self-import is included with your subscription at no extra cost.
Importing your item list bulk-loads your products and services into FieldPulse so they’re ready to add to estimates and invoices — no need to enter each item by hand. Fill in the Mass Item Import template, verify it, and upload it.

Overview

You import your item list from Company Settings > Estimates & Invoices > Item List. FieldPulse gives you the Mass Item Import template to fill in, checks your data for errors before anything is saved, and imports the clean items into your item list.

Before you begin

Have your product and service data ready in a spreadsheet so you can copy it into the template. If you don’t have Excel, use Google Sheets instead — see How to Self-Import Data With Google Sheets. Follow these field rules so your items pass verification the first time:
  • Item names must be unique.
  • SKUs must be unique and can be alphanumeric.
  • Do not use equations in the Unit Cost or Unit Price fields — enter plain numbers.
  • Do not put spaces after the commas in the Tags field.
  • Set each item as either a Product or a Service.

Import your item list

  1. Go to Company Settings, then select Estimates & Invoices.
  2. Select Item List in the sub-header, then select Mass Import. The Item List subtab under Estimates & Invoices in Company Settings, with the Mass Import button highlighted
  3. Follow the on-screen prompts to download the Mass Item Import template. The Item Import prompt with numbered steps and buttons to download the template, verify the file for errors, and re-upload it
  4. Fill in the template, following the field rules above. Do not alter the template’s structure — keep the column headers and layout exactly as they are.
  5. Upload the completed file back into FieldPulse.
  6. Select Verify. FieldPulse checks every record, flags any errors or missing required fields in red, and shows a running count of valid vs. invalid records in the top-right corner. The verification screen flagging an invalid Cost Per Unit field in red, with the count of valid and invalid records in the top-right corner
  7. Fix the flagged fields until every record shows as Valid, then select Export to .xlsx. The verification screen with all records marked Valid and the Export to .xlsx button highlighted
  8. Re-upload the verified file with the Upload button to finish the import.
Verifying before you import means you catch bad data once, up front — instead of troubleshooting failed items across several reimports. Your item import is done when every record in the template shows as Valid, you’ve exported the verified file, and re-uploaded it — your products and services now live in your item list, ready to drop onto estimates and invoices.