Part and Service details can be uploaded via the Requestor role from a .xlsx, .xls, or .csv file to populate the fields of a new cart.
Updated May 19, 2023
Please note that only one cart may be uploaded at a time. This feature supports “I Will Place the Order” and “Buyer Will Place the Order” types. Orders that need to be placed via a Punchout are not eligible to have a cart imported.
On the Dashboard, select +Cart to the right of the My Carts:
Prendio will generate a new manual cart. Import Cart Items can be selected in the top left:
A screen will appear to enable selecting a .xlsx, .xls, or .csv file to import to Prendio:
A template for the cart can be downloaded in the top left:
When completing the template to be uploaded, please do not fill in columns that are not applicable for the cart (ex. Accounting Segments not used by the company should be left blank, a part number for service lines should be left blank, etc).
Please also make sure that any suppliers match the global catalog name exactly in Prendio (ex. BioLegend, Inc. in Prendio should be listed as BioLegend, Inc. on the template with the exact spelling and punctuation). If supplier names do not match, this may delay the order from being processed.
Areas to complete on the template include (Areas in bold and marked with a * are required fields) :
Supplier*, Part Number, Description*, PO Qty, U/M, Currency, Project, Department, GL Account, PO Unit Price, Need By Date, Notes To Supplier, Notes To Internal Buyer, Website (required for new suppliers in Prendio)
Once a . xlsx, .xls, or .csv file is prepared, it can be uploaded to the screen (Select file or drag and drop to the screen). Once uploaded, the cart details will display:
Select to the left the row that will serve as the header and click on Next:
The next screen will provide an opportunity to match each column with the appropriate segment/selection. Once the columns have been matched, select Next:
The final screen will display all part and service lines in the cart with the appropriate columns matched to the correct segments/selections.
Verify all information is correct. Corrections may be made by clicking into each cell and adjusting as needed. If any rows should be left out of the cart, check off the row on the left and select Discard selected rows:
Select Save once complete. A message will appear in case errors are detected:
If errors are detected, select Cancel. Errors may be shown by selecting Show only rows with errors:
Errors will appear with the column highlighted in red:
In the example below, the Need By Date is listed in the incorrect format:
Adjustments to any errors can be made in the cell:
As errors are corrected, they will disappear from the error list:
Once errors have been cleared, select Save. A message will indicate that the import was successful and results may be downloaded:
Once any errors have been corrected, a window appears and a copy of the corrected cart details will be available for download. Users can download this file for future use and import if needed. Close once all set.
Once complete, all part and service lines from the import will populate into the cart and be separated by supplier:
Keep in mind to select the Order Type at the top as well as other appropriate selections/adjustments:
Review the cart and make any final adjustments. Submit Cart once all set. Once submitted, the approval window will appear. If multiple suppliers were used in the cart they will be separated into separate orders:
Submit on the bottom right of the approval window once set. Prendio will return to the Dashboard and cart details can been seen in the My Orders section:
Related Help Docs: Creating an Order with a Manual or Custom Cart