Configure the Matrix Loader
Use the Matrix Loader to efficiently add, edit, and migrate fields, field options, rules, and layouts in CPQ. Upload CSV files, validate configurations, and streamline bulk updates or environment migrations with error-handling and verification support.
The Matrix Loader is the most efficient means of adding and editing fields, field options, rules, and layouts, particularly when the number of elements gets large. When using the Matrix Loader, administrators define their configuration elements in a spreadsheet file. This spreadsheet artifact provides a backup of data in CPQ; it also facilitates fast test-to-production migration processes.
Here is a quick tutorial on how to use the Matrix Loader.
- Click Matrix Loader in the navigation pane.
- On the page that opens, export sample files in the upload formats that are accepted by the Matrix Loader: fields, field options, rules, and tables. Each sample file demonstrates a broad range of the features of the upload format.
- Drag, or use the file browser to select the CSV files you intend to upload.
We discuss the formats of these CSV files in the following articles:
- Matrix Loader CSV fields and field options upload and export
- Matrix Loader: CSV rules upload
- Matrix Loader: CSV table upload
Queued files are displayed. If necessary, add more files or delete files, and then click Next.
- The Matrix Loader guesses at the contents of each file according to keywords in the file titles. Confirm that the Matrix Loader guessed the upload file types correctly. If necessary, make corrections.
The Matrix Loader performs the uploads in the sequence necessary to ensure all elements are uploaded correctly. Click Import.
- Confirm that all the uploads succeeded. Most errors originate in a mistake or mismatch in an upload file. When all uploads have succeeded, click Continue.
- In the appropriate administration areas (fields and rules, if you uploaded these files), check and confirm the elements that were created as a result of this Matrix Loader upload.