Skip to main content

How to Upload a Product List

Easily streamline your BOM creation process by uploading product lists. Follow the steps below to bring in data from multiple sources.

Ni Nguyen avatar
Written by Ni Nguyen
Updated over a week ago

Step by Step

Step 1: Start a New BOM

  1. Click Create BOM.

  2. Enter a Project Name or select an existing one from the dropdown.

  3. Name your Bill of Materials (optional).

  4. (Optional) To add additional BOMs, click Add BOM.

  5. Click Confirm to continue.

Screenshot 2024-06-05 140233

Step 2: Import Products

  1. In the Bill of Materials tab, click Import Products.

  2. Choose your import source:

    • List of Products (quote, fixture schedule, Excel/PDF list)

    • Existing Submittal Package

    • Existing Parspec BOM

Screenshot 2024-06-05 140359-1

Step 3: Import from List of Products

  1. Choose the Section where the products should be added.

  2. Upload your file (PDF or Excel format). Supported types include:

    • Quotes

    • Fixture schedules

    • Product lists

Screenshot 2024-06-05 140805

Step 4: Map Product Details Using OCR

  1. Select Schedule and draw a large orange box around the relevant data in your document.

  2. Confirm your selection.

  3. The OCR (Optical Character Recognition) tool will extract key details:

    • Type

    • Manufacturer

    • Model Number

    • Quantity

🟧 Anything highlighted in orange is what the system identified.

Screenshot 2024-06-05 141033

Step 5: Review and Adjust Mappings

  1. Reassign or ignore column headers as needed:

    • For example, ignore Extended Cost and reassign Unit Cost.

  2. Optionally assign other columns (e.g., Submittal Notes).

  3. Click Confirm to complete the import.

Screenshot 2024-06-05 141723

💡Tips for a Smooth Workflow

  • Orange-highlighted columns indicate the data Parspec has identified.

  • Review each highlighted column to ensure the correct headers are assigned.

  • To change a header:

    • Click Select on the column.Choose the correct header from the dropdown.

  • To skip uploading a column: Click Ignore Column.

  • Once all columns are reviewed, click Confirm All to proceed with the import.

Screenshot 2024-06-05 142017

Step 6: Finalize and Manage Your BOM

  • All imported information will populate directly into your BOM tab.

  • From here, you can sort and organize your line items as needed.

  • To add more products later:

    • Return to the BOM tab.

    • Click Import Products again.

Screenshot 2024-06-05 142307

Did this answer your question?