Exporting/Importing Vendor Part Information

Formatting the Data

This update allows you the opportunity to do a mass update of vendor part information. You need to have the CSV file formatted in a way that Fishbowl knows what to do with the data. This is easiest to do with a spreadsheet program.

All fields will be one of two types:

Text - A textual value. May contain any character, but if it contains a line break, comma or double quote, it must be wrapped with double quotes on both ends. If a field is wrapped, all text must be inside the double quotes. Double quotes in the text value must be doubled to import properly
Numeric - A decimal number greater than or equal to zero with up to four digits after the decimal point. The number must not have thousands' separators in it - 1234.56 is a valid number, while 1,234.56 is not.

Fields of a Vendor Last Cost file.

Column Name	Type	Description
Vendor	Text (41 chars)	The name of the Vendor the following part is associated with. *Required*
FishbowlPartNumber	Text (90 chars)	The Fishbowl part number being imported. Optional when updating vendor part information, required when creating new vendor parts. This row will be skipped if the FishbowlPartNumber is blank and we cannot find the vendor part record by the VendorPartNumber.
VendorPartNumber	Text (90 chars)	The vendor part number being imported. *Required*
Cost	Numeric	The cost of the part in the vendor's currency. *Required*
UOM	Text (30 chars)	The Unit of Measure (UOM) code that Vendor offers the part in for the given cost. It defaults to "ea" (Each) if this column is not provided. If the UOM does not match up with an existing UOM in Fishbowl on Import, then nothing will be added/updated. *Optional*
LeadTime	Numeric	The Vendor's Lead Time for this Part. The default is zero for new part entries. If it is not included in the import then the lead time of existing parts will not be modified. The lead time must be zero or a positive number. *Optional*
DefaultVendor	Text	Contains either the value "true" or "false" and indicates if the vendor cost is the default for this part. *Optional*
MinQty	Numeric	The vendor's minimum order quantity for this part. The default is zero for new part entries. If it is not included in the import then the minimum quantity of existing parts will not be modified. The minimum quantity must be zero or a positive number. *Optional*

The Vendor column must be the first column. The file must contain column names in the first row, using the column names in the table above.