How to Export, Update, and Upload Enriched Asset Lists
Learn efficient methods to export, update, and upload enriched asset lists for streamlined asset management.
Introduction
In the renewal workflow, once an Asset List is created, it is typically shared with the customer for validation. Customers may review the list and suggest updates such as removing assets, modifying quantities, or adding comments.
Instead of manually updating these changes in the system, Partner Renewal Workspace (PrW) provides the Enriched Asset List capability, allowing you to update Asset List Items in bulk using an Excel file.
This feature is available across both:
- Maintenance Contract renewals
- Subscription renewal workflows
In this article, you’ll learn how to export an Asset List, update it offline, and upload it back into PrW to automatically apply changes. By the end of this article, you will understand:
- How to export an Asset List for customer validation
- Which fields can be updated in the exported file
- How to upload the updated (enriched) file back into PrW
- How the system processes and reflects these updates
By the end, you’ll understand how the IC Console acts as your main workspace for managing assigned contracts before you move into asset list creation.
Previous step: Review Asset Lists and prepare them for customer validation
Next step: How to create vendor price requests to get vendor quote
Key Terms
| Term | Definition |
|---|---|
| Renewal |
In the VAR ecosystem, Renewal refers to the process of extending a maintenance contract to continue service coverage for hardware or software. This typically involves reviewing expiring contracts, creating asset lists for customers to approve, preparing a list of assets/services to be priced, and initiating the quoting process for services like: Cisco SmartNet maintenance contracts Managed service subscriptions etc.
The renewal process ensures uninterrupted service and allows for co-terming, identifying potential product upgrades, or requesting a change in service levels. |
| Asset List | A grouped list of contract or subscription items prepared for customer validation and renewal |
| Asset List Items | Individual line items (products, services, subscriptions) within an Asset List |
| Enriched Asset List | An Asset List that has been exported, updated externally, and re-uploaded to update item-level data |
| PRW Template | A predefined Excel format used to export and import Asset List data |
| Renewal Engineer | User responsible for preparing Asset Lists, validating with customers, and initiating pricing |
Table of Contents
| No. | Section | Description |
|---|---|---|
| 1 | Exporting Asset List | Downloading Asset List for customer review |
| 2 | Updating the Asset List in Excel | Making allowed changes in the file |
| 3 | Uploading Enriched Asset List | Importing updated file into PrW |
| 4 | Understanding System Processing | How updates are applied |
| 5 | Best Practices | Tips to avoid errors |
1. Exporting the Asset List
To begin the enrichment process, you first need to export the Asset List.
Steps:
- Navigate to the Asset List Console
- Select the required Asset List (only one at a time)
- Click Export Asset List
- Choose the appropriate template (if prompted)
- Download the Excel file

What happens next:
- The Asset List is exported in a structured Excel format
- This file can now be shared with the customer or internal stakeholders
2. Updating the Asset List in Excel
Once exported, the file can be reviewed and updated offline.
Typical updates include:
- Marking items as Do Not Renew
- Updating renewal decisions
- Adding comments or notes
- Adjusting fields provided for customer input


Important Guidelines:
- Only update editable columns defined in the template
-
Do NOT:
- Modify or delete system columns (such as internal IDs)
- Rename columns
- Add or remove rows
Why this matters:
The system uses internal identifiers in the file to correctly map updates back to Asset List Items.
3. Uploading the Enriched Asset List
After updates are completed, the file can be uploaded back into PrW.
Steps:
- Navigate to the Asset List Console
- Select the same Asset List
- Click Upload Enriched AL
- Upload the updated Excel file
- Confirm the upload


After upload:
- The system processes the file
- Asset List Items are updated automatically
- Click Show AL Items to verify the updated data
4. Understanding System Processing
Once the file is uploaded, PrW processes the updates in one of the following ways:
Successful Update
- All records are updated successfully
- A success message is displayed
Partial Success
- Some records are updated, others fail
- You can review logs to identify issues
Failed Update
- No records are updated due to errors
- Check system logs for details
Background Processing
- For large files, updates may be processed asynchronously
- You may receive a notification once processing is complete

5. How this fits in the Renewal Workflow
The Enriched Asset List step is typically used during customer validation.
Workflow Position:
- Used after grouping IC items into Asset Lists
- Helps refine renewal scope before pricing
In Subscription Renewals:
- Used after preparing subscription items for validation
- Helps align renewal decisions across subscription services
6. Best Practices
To ensure smooth processing:
- Always use the exported template for updates
- Validate entries before uploading (especially picklist values)
- Avoid modifying file structure
- Upload the file against the correct Asset List
- Use Show AL Items to confirm updates
Conclusion
The Enriched Asset List feature helps streamline the renewal process by enabling bulk updates based on customer feedback.
By eliminating manual updates and ensuring data consistency, it allows Renewal Engineers to:
- Process customer feedback faster
- Reduce errors
- Prepare accurate data for pricing and quoting
Related Articles
In this article
- Introduction
- Key Terms
- Table of Contents
- 1. Exporting the Asset List
- 2. Updating the Asset List in Excel
- 3. Uploading the Enriched Asset List
- 4. Understanding System Processing
- Successful Update
- Partial Success
- Failed Update
- Background Processing
- 5. How this fits in the Renewal Workflow
- Workflow Position:
- In Subscription Renewals:
- 6. Best Practices
- Conclusion
- Related Articles