{"type":"doc","content":[{"type":"paragraph","content":[{"text":"QuoteStructure can be used to add line items to a quote using Groovy code. This helps in some use cases, such as importing quote line items from an Excel file.","type":"text"}]},{"type":"paragraph","content":[{"text":"From version 2.2.0, line items added using ","type":"text"},{"text":"QuoteStructure","type":"text","marks":[{"type":"code"}]},{"text":" can be handled by the CPQ Accelerator. This section will show you how to work with ","type":"text"},{"text":"QuoteStructure","type":"text","marks":[{"type":"code"}]},{"text":" in CPQ.","type":"text"}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Utils","type":"text"}]},{"type":"paragraph","content":[{"text":"CPQ provides some public utils to make it easier to work with the ","type":"text"},{"text":"QuoteStructure","type":"text","marks":[{"type":"code"}]},{"text":":","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"void addQuoteStructure(QuoteStructure quoteStructure)","type":"text","marks":[{"type":"code"}]},{"text":" – Loads the provided quoteStructure so that the CPQ knows which line items are going to be loaded and calls ","type":"text"},{"text":"quoteProcessor.addQuoteStructure(QuoteStructure quoteStructure)","type":"text","marks":[{"type":"code"}]},{"text":" to add quoteStructure into the system.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"void addLineItem(String parentLineId, String key, List> contextParameter)","type":"text","marks":[{"type":"code"}]},{"text":" –Loads the provided line item so that the CPQ knows which line item is going to be loaded and calls ","type":"text"},{"text":"quoteProcessor.addLineItem(String parentLineId, String key, List> contextParameter)","type":"text","marks":[{"type":"code"}]},{"text":" to the add line item into the system.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"void addLineItem(String key, List> contextParameter)","type":"text","marks":[{"type":"code"}]},{"text":" – Loads the provided line item so that the CPQ knows which line item is going to be loaded and calls ","type":"text"},{"text":"quoteProcessor.addLineItem(String key, List> contextParameter)","type":"text","marks":[{"type":"code"}]},{"text":" to add the line item into the system.","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"CPQ requires QuoteStructure / Line Items added using Groovy to be loaded in the pre-phase so that the inputs and outputs are generated correctly.","type":"text"}]},{"type":"paragraph","content":[{"text":"It is recommended in the Data Processing / Query with the running phase to set it to PrePhase.","type":"text"}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Samples","type":"text"}]},{"type":"paragraph","content":[{"text":"This example shows a use case where a user uploads an Excel file with line items and adds them to a quote.","type":"text"}]},{"type":"paragraph","content":[{"text":"You need to configure a file input on the header that allows the user to upload the Excel file. You need to load the Excel only once when the user uploads it, for that use the provided library ","type":"text"},{"text":"CPQ_Inputs_Utils.Void","type":"text","marks":[{"type":"code"}]},{"text":" which removes the user input with every recalculation.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":1600,"id":"1fa9e870-bcf1-40f1-9ad4-dbfe906ee4ac","collection":"contentId-5933139508","type":"file","height":302},"marks":[{"type":"border","attrs":{"size":2,"color":"#091e4224"}}]}]},{"type":"paragraph","content":[{"text":"Result in the quote:","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":50.0},"content":[{"type":"media","attrs":{"width":581,"id":"0707d6b3-9090-43ec-8bb8-d1b468ec2809","collection":"contentId-5933139508","type":"file","height":655},"marks":[{"type":"border","attrs":{"size":2,"color":"#091e4224"}}]}]},{"type":"paragraph","content":[{"text":"Then, you need to write a library to process the Excel file and add line items using QuoteStructure. Create a library and implement it, with the ImportExcel element in the ","type":"text"},{"text":"CPQ_Header_Utils","type":"text","marks":[{"type":"code"}]},{"text":" library. Of course, you are encouraged to separate CPQ core logic and custom logic.","type":"text"}]},{"type":"codeBlock","attrs":{"language":"groovy"},"content":[{"text":"import net.pricefx.common.apibuilder.quote.QuoteStructure\n\ndef execute() {\n List rows = getExcelData()\n\n if (rows?.size() < 2) {\n return\n }\n\n QuoteStructure quoteStructure = buildQuoteStructure(rows)\n\n libs.CPQ_SharedLib.QuoteUtils.addQuoteStructure(quoteStructure)\n}\n\nprotected List getExcelData() {\n def quoteUtils = libs.CPQ_SharedLib.QuoteUtils\n String excelImportInputName = \"ImportExcel\" //Configured header input name\n String importedFileHandler = quoteUtils.getLineItemInputMap(\"ROOT\")[excelImportInputName]\n def excelData = api.parsableInputFileDataFromHandle(importedFileHandler)\n\n return excelData?.data?.Data\n}\n\nprotected QuoteStructure buildQuoteStructure(List rows) {\n int skuIndex = 0\n int colorIndex = 1\n def quoteStructure = new QuoteStructure()\n\n List rowLabels = rows[0]\n //Remove the label row\n rows = rows?.subList(1, rows?.size())\n\n String colorName = rowLabels[colorIndex]\n String colorLabel = colorName.capitalize()\n\n rows.each { List row ->\n String sku = row[skuIndex]\n String color = row[colorIndex]\n\n List inputs = [[\"name\": colorName, \"label\": colorLabel, \"value\": color]]\n quoteStructure.addPart(sku, inputs)\n }\n\n return quoteStructure\n}","type":"text"}]},{"type":"paragraph","content":[{"text":"The above logic simply reads the Excel file from the input, reads its data to build ","type":"text"},{"text":"QuoteStructure","type":"text","marks":[{"type":"code"}]},{"text":", then uses the quote utils to apply the ","type":"text"},{"text":"QuoteStructure","type":"text","marks":[{"type":"code"}]},{"text":".","type":"text"}]},{"type":"paragraph","content":[{"text":"After the logic is created, you configure it to run the library in CPQ.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":1221,"id":"e237ac22-eacf-4267-9810-8a044fb40b00","collection":"contentId-5933139508","type":"file","height":202},"marks":[{"type":"border","attrs":{"size":2,"color":"#091e4224"}}]}]},{"type":"paragraph","content":[{"text":"Now, you can upload the Excel file and recalculate it to see if the new line items from the file are added to the quote.","type":"text"}]},{"type":"mediaGroup","content":[{"type":"media","attrs":{"id":"cb09c719-a48b-4953-91e7-e8e6113ce568","collection":"contentId-5933139508","type":"file"}}]},{"type":"paragraph"}],"version":1}

Browser not supported