Upload Vendor Availability Files

Owned by Former user (Deleted)
Last updated: Sep 05, 2024 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.

User Roles: Grower.

If you don’t see the Vendor Availability tab, ask the company who provided your account to contact us so we can 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: Total available units.

  • unitType: Unit type. Valid values: Stem or Bunch

  • category: Product category name.

  • color: Product color.

  • unitCost: Product cost per unit.

You can download a template in here:

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.

    • 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.

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

Once you upload your file, the system will add the products to your inventory and send you an email with the results. In case there are any errors, the system will send an email containing a link to review the reasons why some records were not added to Komet Sales and give you the option to correct the file and upload it again. 

After this process is completed, the products will appear in the Availability Items screen, where you can manage them. 

Back to top

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

Related Articles

Peacock