Back
Categories
Back

    Categories

      View All

      How do I import Items from a file?

      Items are used when you’re billing for goods or products sold to your Clients. If you have a lot of Items and want to save some time, you can import your list of Items in bulk instead.

      With the CSV Import, you can specify the name, description and rate you would like each Item to be created under. To import your file in, use these steps:

      1. Click on the gear icon in the top left corner
      2. Click on Items & Services
      3. Click on the Import Items buttonImport items button at top of page.
      4. Click on Choose File…
      5. Select your CSV
      6. Match the fields to the columns from your file using the dropdown (e.g., Name should match to the column in your file that is also labelled as Name)Fields to map over for items in your csv file.
      7. Click on Import Items
      8. New Items will be added and you can start invoicing with them.

      FAQs

      How are duplicate Items handled?

      Item names must be unique, so if the name is taken, you can either:


      Why did I get an error uploading my file?

      The CSV file may be invalid depending on the error:

      • The CSV file itself is corrupt - ensure it's re-saved in .csv format
      • The first row needs to be a header row - this is not imported in but used for matching fields (if headers are missing, the first row is skipped)
      • There are invalid formats in the file (e.g., commas instead of decimals)
      • Names cannot exceed 50 characters
      • There are unsupported characters like commas and other UTF-8 characters in the file
      • There are empty cells in the file (right click and select Delete to clear out empty cells)
      • The file is larger than 2MB - try splitting it into two or more CSVs instead

      Support Categories