Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Anchor
topofpage
topofpage

Excerpt

In this article, you will learn how to upload the Vendor Availability File into your Komet Sales account.

Tip

User Roles: Administrator, Inventory, Procurement User, and Sales Manager.

Table of Contents

Table of Contents
minLevel1
maxLevel2
outlinefalse
excludeTable of Contents
typelist
printablefalse

Understand the Vendor Availability File
Anchor
understand-vendor-availability
understand-vendor-availability

The Komet Sales app allows vendors to easily upload their product availability using a CSV File Extension, which is called the Vendor Availability File.

Info
  • Any other File Extension, such as XLS, XLSX, or XML, will not work.

  • The file format order should be as follows: vendorId, productDescription, availableFrom, quantityUnits, unitType, postHarvest, category, color, unitCost, stems/Bunch, tag; and the comma should separate each data point.

  • Start placing all the products in Column A, beginning from the first row and going down.

To learn more about the required format information, read the following:

  • vendorId. A unique identifier Komet assigns to each vendor company in your account, used to share availability inventoryThis is actually the MainVendorID, an internal and unique ID provided by Komet's Support Team that users cannot access directly.

  • productDescription. A concise and understandable product description that covers what is and its features.

  • availableFrom (yyyy-mm-dd). The estimated date of shipment based on the selected "Available From" option for the product, either from the Vendor or the Warehouse.

  • quantityUnits. The number of units available.

  • unitType. The product's unit type can be either Stem or Bunch, with the first letter capitalized.

  • postHarvest (optional). The name or postharvest number of the product.

  • category. The name of the class, type, or condition of a product.

  • color. The name of the Color of the product.

  • unitCost. The price of producing a single unit of the product.

  • stems/Bunch (optional). The number of stems included in one bunch of the product.

  • tag (optional). A word or phrase that helps to locate it easily.

Now that you have all the necessary data, here's an example of how to enter the product information line in the file

111,Roses Bicolor Free Spirit 40 Cm,2023-10-3,100,Bunch,ph1,Roses,Bicolor,1.1,,TAG-BFS

Info

To skip optional data, add an extra comma to move on. In the previous example, we left out stems/Bunch info, resulting in a double comma between unitCost (1.1) and tag (TAG-BFS).

Back to top


Upload the Vendor Availability File

To upload the Vendor Availability File, do the following instructions:

  1. Go to Inventory and select the Add Inventory tab.

  2. Select the Vendor Units Availability link.
    You must enable the Vendor Availability option to view the Vendor Units Availability link.

  1. Download a sample of the CSV file from the here link.

  2. Add the products per line to the file, separating each product data by a comma (,).
    To know how, read the https://kometsales.atlassian.net/wiki/spaces/KB/pages/3340261/Upload+the+Vendor+Availability+File#Understand-the-Vendor-Availability-File-%5BinlineExtension%5D section.

  3. Drag and drop your file into the designated box or click to upload.

Vendor availability file.gif
Info
  • After importing your CSV file, you will receive an email notification. If there are any errors, you'll get the attached CSV file with details you need to correct to upload again.

  • Once the file was successfully uploaded, you can set the Product Mapping and the Product Pack Default Information from Vendor Units Availability > Staging Area linkand select Confirm products button.

Back to top


Filter by label (Content by label)
showLabelsfalse
max5
titleRelated Articles
cqllabel in ( "vendor-availability" , "vendor-availability-pricing" , "vendor-availability-shortcuts" )