The system allows you to upload your Vendor's Availability by using an CSV file. This article explains how to do it.
CSV Format
Please remember to save and upload the file in CSV format. Using other format such as xls, xlsx or XML won't work. Each piece of data must be separated by a comma. 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.
Instructions
In order to sell vendor availability items, it is necessary to upload the availabilityusing a Comma Separated Values (CSV) file. To do so, follow these instructions:
The system has an option to auto-allocate products on purchase orders linked to Prebooks with Vendor Availability products. The system takes into consideration the available items based on the ship date established in the purchase order to make the allocation. Future Salesorders are excluded from this Vendor Availability auto allocation process.