In addition to manually keying in pricing and responses on a bid request, Unimarket allows suppliers to upload this information in bulk via CSV files, streamlining the submission process for large bids.
Prerequisites
Audience: Supplier (Responding to a Bid)
Intent: Upload pricing and/or answers to bid requests in bulk.
Access: You must have already accepted the bid invitation and be on the Create Quote screen.
Uploading Pricing
This process covers submitting price quotes and product details for the bid's line items.
Select Quotes on the left panel.
Click View Bid Requests.
The Bid Requests screen will populate; select the desired bid under the column Bid Request Name.
Select the Sections tab.
Click Upload Pricing. A pop-up box will appear.
Select Export Items to download the CSV file template.
Open the file and insert applicable information, referring to the template specifications below.
Note: The first three columns (SECTION, LINE, REQUIREMENT) will be automatically populated for you and should not be altered.
Upon completion, save the file as a CSV.
To Upload:
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.
Note: Images larger than 640x480 pixels shrink automatically. The maximum zip file size is 10MB.
Once the file has uploaded, click OK.
Pricing Upload Template Fields
| Column Name | Description | Mandatory |
|---|---|---|
| SECTION | Explains which section the product belongs to in the quote (Auto-populated). | Y |
| LINE | Explains which line the product appears as in its section (Auto-populated). | Y |
| REQUIREMENT | The name or description of the quoted product or service (Auto-populated). | 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 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. 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_OF_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 if attached to upload in the zip file. | N |
Uploading Question Responses
This process covers submitting narrative, date, number, or selection responses to questions included in the bid request.
Select Quotes on the left panel.
Click View Bid Requests.
The Bid Requests screen will populate; select the desired bid under the column Bid Request Name.
Select the Sections tab.
Click Upload Question Responses. A pop-up box will appear.
Click Export Questions to download the CSV file template.
Open the file and insert applicable information in all required fields.
Upon completion, save the file as a CSV.
Note: The maximum file size for the CSV is 50MB.
Select Browse to upload the CSV file.
Once the file has uploaded, click OK.
Upload Question Responses Template Fields
| Column Name | Description | Mandatory |
|---|---|---|
| LINE_NUMBER | The designated line number. | N |
| SECTION | The name of the section the customer assigned. | N |
| MANDATORY | Status selected by customer. | N |
| REQUIREMENT | Statement/Question from customer. | N |
| DESCRIPTION | Additional information from customer. | N |
| QUESTION_DATA_TYPE | Statement/Question type. | N |
| RESPONSE | Suppliers answers to the statement/question. | Y |
| COMMENT | Additional information supplier would like to provide. | Y |
Finalizing the Submission
When the supplier has answered each line and is ready to continue, click Continue (or select the Publish tab).
At any time, suppliers can save their response in progress by clicking Save at the bottom of any tab.
The customer will not be able to view your quote until you select Publish on the Publish tab.