You can add or update supplier (also known as vendor) product codes and prices for many parts at once by importing a CSV file. Supplier prices sit alongside the main part cost and markup, and you can store prices from several suppliers against the same part. You can also download a supplier's current prices to check them or to use as the file for your next update.
Click here to see what plans include advanced parts management
Click here to see what plans include advanced parts management
Plan name | Client region | Included in plan |
Legacy Plans | All | No |
Go Paperless | UK | Yes |
Customer Journey | UK | Yes |
Automation | UK | Yes |
All-in-One | US | Yes |
Customer Journey | US | Yes |
Field Automation | US | Yes |
How to access supplier prices tools
âĄď¸ Go to your Profile icon â Choose Settings â Locate Parts and stock in the Categories menu â Click View next to Parts â Click Advanced options at the bottom of the parts list
Preparing your supplier price CSV file
Your file needs columns to identify the existing part, plus the supplier product code and price you want to add or update. Parts must already exist in your parts list before you can import supplier prices for them.
You must use Part name and Manufacturer part number to identify each part. Find out more about how Commusoft matches parts.
Field Name | Purpose | Requirements |
Part Name* | Identifies the part to update. | Mandatory. Must match an existing Part Name in your database. |
Manufacturer part number | Second identifier to match the part. | Mandatory. Must match an existing Manufacturer part number in your database. |
Supplier product code | The supplier's unique code for this part. | Alphanumeric. Can be left blank if not required. |
Supplier price | The supplier's specific cost for this part. | Must be a number (e.g., 10.50). No symbols. |
The Part ID is not used to match parts when importing supplier product codes and prices.
Your supplier may be able to provide a parts list to get you started. Reach out to your supplier's account manager to request this. You'll need to tidy any spreadsheet you receive so the data is clean and ready for a successful import.
To use the supplier integrations, supplier product codes and prices are required. Find out more about the Wolseley and City Plumbing integrations.
How to import your supplier price CSV file
You can upload a CSV file to add supplier product codes and prices to your existing parts, or to update the supplier prices and product codes you already have.
Click Advanced options to expand the section.
In the 'Add/update supplier prices' area, select the supplier you want to update from the Please enter supplier name dropdown.
The supplier must already exist in your Commusoft account. Find out more about creating suppliers.
Tick the box Check the box if the CSV file has a title in the first row if your spreadsheet has column headers.
Click Upload CSV to add/update your parts list and select your file.
Check the columns are matched to the correct Commusoft fields, then click Save to begin the import.
Once the import is complete, a notification will let you know if it was successful or if it failed.
If the import fails, the notification will include a report file to download. Review this file to see which rows require attention, resolve the errors in your CSV, and retry the import.
How to download your supplier prices
You can download a CSV spreadsheet of your parts and their prices for a chosen supplier. This is useful for checking your prices, or as the file to edit and re-upload for a bulk update.
Click Advanced options to expand the section.
In the 'Download your supplier prices' area, select a supplier from the Please enter supplier name dropdown.
Click Download excel.
The file will be downloaded to your browser's download location.
You can download one supplier at a time.
Only parts with a supplier product code and/or price stored against them are included in the download.
Common questions
Do supplier prices have their own markup?
Do supplier prices have their own markup?
No. When you use a supplier-specific price for a part, for example when adding it to a job or order, the main Markup percentage set for that part is applied.
Why would I download supplier prices?
Why would I download supplier prices?
It gives you a correctly formatted file for a bulk supplier price update. Download the file, make your price changes, then re-upload it using the 'Add/update supplier prices' tool.
Example use cases
đĄ Annual supplier price update
đĄ Annual supplier price update
Your main supplier sends you their new price list. You select that supplier in the 'Add/update supplier prices' tool and upload the new file to update all your supplier-specific costs for that supplier, without affecting your main markup.
Related articles
Walkthrough
Watch a walkthrough on adding and updating supplier prices.