Material Costing
      Back to home
      1. LearnCQ
      2. QuoteCQ
      3. Material Costing

      QuoteCQ: How to Import manual pricing

      Whether it's for the whole BOM or for a single line, you can add your prices manually and easy

      Import pricing file

      You can upload a file to add pricing information for multiple lines on your BOM. This can be done multiple times on the same BOM or lines, for instance, if you receive pricing from multiple suppliers.

      1. Download the template: On the Material Costing tab, click Actions > Manual Price > Template
        1. The file is protected. Please unprotect the file first and enter the pricing details.
        2. Please do not modify the pre-populated cells in the template or else you will receive an error when importing into CalcuQuote.
        3. After inputting the pricing details, save the Excel file.Enter pricing file is protected. Please unprotect the file first and enter the pricing details.

      2. Import back into CalcuQuote: Navigate back to the Material Costing tab and import using Actions > Manual Price > Import:

      3.  

        Choose the saved file and click 'Import Pricing.' Once choosing your file, the system will clarify your separator. The system allows for both commas and periods. After selecting, click Import pricing to add it to the system.

      How to import multiple pricing for the same line

      • Please notice that Column A of the template is hidden.
      • That column contains the LineItemID, which CalcuQuote uses to identify the correct Line Item.
      • To add multiple pricing for the same line:
        • Display the Column A.
        • Copy the LineItemID of the line you want to price and paste it into a new empty line.
        • Copy all the pre-populated information and copy it in the new line.
        • Enter the pricing in that new line.

      Do you need to add pricing for a single line?