Upload Vendor Availability Files

Owned by Former user (Deleted)
Last updated: Dec 04, 2023 by Andres Toledo
3 min read

In this article you will learn how to upload a Vendor Availability CSV file with the available items in the Vendor Portal.

If you don’t see the Vendor Availability tab, request your Company to enable this module for your farm. 

Table of Contents

Requirements

Please save and upload the file in CSV format (Comma Separated Values, not Excel). Each piece of data must be separated by a comma, and the file must contain the following mandatory values:

  • vendorId: The ID of the vendor that publishes the availability.

  • productDescription: The description of the product.

  • availableFrom (YYYY-MM-DD): The date when the Vendor will have the product available
         to be shipped.

  • quantityUnits: The number of units available.

  • unitType: The unit type. Stem or Bunch.

  • category: The name of the product category.

  • color: Color of the product.

  • unitCost: The unit cost of the product.

Back to top

Upload a CSV File

To upload a CSV file, follow the instructions below

  1. Go to Vendor Availability, and select Upload CSV.

  2. If you want a sample file, click on the "You can download the sample CSV file from here" link. This link automatically downloads a Vendor Availability CSV file sample. Since CSV files don't have column titles, you can use the information found under the CSV Format subtitle to identify what information belongs in each column. We recommend opening this file with a Text Editing program instead of Excel. 

  3. First, you must select the Upload option, as the system allows for the Vendor Availability file to behave in two different ways:

    • Overwrite previous: All vendor availability is uploaded; however, if within the same CSV file or any future CSV file, you have a product with the same product description, available from the date and post-harvest, the system will overwrite the originally uploaded amount with the latest amount uploaded. This can cause products to be oversold if, for example, 500 units were originally uploaded and sold, and then 400 units with the same criteria were uploaded afterward. The 400 will override the 500 originally uploaded, causing a 100-unit shortage or oversell. 

    • Increase availability: All vendor availability is uploaded; however, if within the same CSV file or any future CSV file, you have a product with the same product description, available from the date and post-harvest, the system will add this amount to the original or previously uploaded amount. An example of how the system will behave is if within the same CSV file or a future uploaded file that meets the criteria mentioned above, if 100 units were originally uploaded, and 200 more the last time an upload occurred, the new total amount available would be 300 units.  

  4. After creating the CSV file with your availability, drag the actual CSV file of the Vendor Availability you wish to upload into the system, or just click within the dotted area to select the file you wish to upload.

  5. Once the CSV file has been uploaded, the system will send a notification via email to the grower user who uploaded the Vendor Availability CSV file with the upload results. If the system finds an error in the file, it will send an email with the error information, and the user will have the option to correct the file and upload it again. 

  6. Finally, the items will appear in the Availability Items tab; from there, the vendor user can manage them. 

Back to top

Upload the CSV File in the Vendor Availability > Upload CSV screen.

Related Articles

Peacock