In addition to Unimarket allowing suppliers to manually key in pricing information and responses to questions on a bid request, they can also upload pricing and responses via a CSV file.
Uploading Pricing
To upload Pricing, select Quotes on the left panel > click View Bid Requests.
The Bid Requests screen will populate to select desired bid under column Bid Request Name.
The desired bid screen will appear > click Sections tab > select Upload Pricing > the Upload Pricing pop-up box will appear to click Export Items to download a CSV file with all of the items needing to be entered on this Bid Request.
- Open the CSV file and populate the empty columns, and save it. See the list below for information regarding the fields that are mandatory.
- Select Browse to upload the CSV file directly if no images are used or create a ZIP file containing the CSV file and all the images referenced in the IMAGE_FILE column. Images larger than 640x480 pixels shrink automatically. The maximum zip file size is 10Mb.
- Once the file has uploaded, click OK.
- When the supplier has answered each line and ready to continue, click Continue.
At any time, suppliers can save response in progress, by clicking Save at the bottom of any tab.
The customer will not be able to view your quote until published by selecting Publish on the Publish tab.
Upload Question Responses
To upload Question Responses, select Quotes on the left panel > click View Bid Requests.
The Bid Requests screen will populate to select desired bid under column Bid Request Name.
The desired bid screen will appear > click Sections tab > select Upload Question Responses > the Upload Question Responses pop-up box will appear to click Export Questions to download a CSV file with all of the items needing to be entered on this Bid Request.
- Open the CSV file and populate the empty columns, and save it. See the list below for information regarding the fields that are mandatory.
- Select Browse to upload the CSV file directly if no images are used or create a ZIP file containing the CSV file and all the images referenced in the IMAGE_FILE column. Images larger than 640x480 pixels shrink automatically. The maximum zip file size is 10Mb.
- Once the file has uploaded, click OK.
- When the supplier has answered each line and ready to continue, click Continue.
At any time, suppliers can save response in progress, by clicking Save at the bottom of any tab.
The customer will not be able to view your quote until published by selecting Publish on the Publish tab.
The following table explains the categories in the Pricing Upload template:
| Column | Description | Mandatory? |
| Section | This explains which section the product belongs to in the quote. The Section will be automatically populated for you. | Y |
| Line | This explains which line the product appears as in its section. The Line will be automatically populated for you. | Y |
| Requirement | This will be the name or description of the quoted product or service. The Requirement will be automatically populated for you. | Y |
| Delivery Date | The date the product will be delivered to the customer. | N |
| Allow Substitute | Whether or not the customer will allow a substitute product in the place of the described product. | Y |
| Base Required | Whether or not the customer demands you quote the original product when supplying a substitute. | Y |
| Type | Used to describe whether the product is a base product or a substitute. Use SUB or BASE in this field. All substitute files must be in the line directly below their base product. | Y |
| Name | Name of the product. | Y |
| Description | A short description of the product. | Y |
| Quantity | How many of the product you will be supplying. | Y |
| UOM | Unit of Measure. (i.e. EA = each) | Y |
| Unit Price | The price you will supply the product for. | Y |
| Note | Any additional notes you would like to include. | N |
| Manufacturer Part ID | Any necessary part IDs from the manufacturer. A part number or SKU will often go here. | N |
| Category Code | The UNSPSC code category for that product. | N |
| Image File | URL for your image or file extension is attached to upload in the zip file. | N |