This update allows you the opportunity to do a mass update of information relating to products. 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.
Fishbowl can update several pieces of information for each product. Each row must have the ProductNumber field which corresponds to the product number field used within Fishbowl. This is used to find the product to update. If there is an error on any line of the update file, the entire update will fail allowing you to easily fix the problem and rerun the update.
The CSV file may have more or less columns in it than the ones listed below. All extra fields will be ignored. Only required fields need to be included.
All fields will be one of two types:
| Column Name | Type | Description |
| PartNumber | Text (70 chars) |
The part number. The part for an existing product will not change. Required |
| ProductNumber | Text (70 chars) |
The product number. Required |
| ProductDescription | Text (252 chars) |
A description for the product. |
| ProductDetails | Text (no limit) |
A longer description for the product. |
| UOM | Text (10 chars) |
The unit of measurement for the product. It must match an existing UOM abbreviation in Fishbowl. Product will default to part UOM if left blank. |
| Price | Numeric | The price to sell the product for. Zero is an acceptable price. |
| Class | Text | Default class for the Product |
| Active | Text | Whether the product is active (true) or inactive (false). |
| Taxable | Text | Whether the product is taxable (true) or inactive (false). |
| ComboBox | Text | Whether the product shows on SO drop-down filter (true) or not (false). |
| AllowUOM | Text | Whether the product can be sold in a different UOM on the sales order (true) or not (false). |
| ProductURL | Text | The URL for the product. |
| ProductPictureURL | Text | Contains a URL reference to the picture to be uploaded to the product.
The URL reference must begin with "file://", followed by either "localhost" or the IP address
of the computer where the picture is stored, followed by the file path. Example: file://localhost/C:/Users/Pictures/Saved Pictures/image.jpg |
| ProductUPC | Text (31 chars) |
The UPC code for the product. |
| ProductSKU | Text (31 chars) |
The SKU for the product. |
| ProductSOItemType | Text | The product's default sales order item type. It must be one of the following: Sale Drop Ship Credit Return Shipping Defaults to Sale if left blank. |
| IncomeAccount | Text | The income account for the product. |
| Weight | Numeric | The weight of the product. |
| WeightUOM | Text | The weight UOM code of the product. |
| Width | Numeric | The width of the product. |
| Height | Numeric | The height of the product. |
| Length | Numeric | The length of the product. |
| SizeUOM | Text | The size UOM code of the product. |
| Default | Text | Whether the product is the default (true) or not (false). |
| AlertNote | Text | The alert note for the product. |
| CartonCount | Numeric | The quantity per carton. |
| CartonType | Text | The name of the carton type. |
| CF- | Text (30 chars) |
The product's custom field value. The name of this column is CF- followed by the name of the custom field. There is one custom field column for each of the product's custom fields. |
In order to import your data, you must first export it to a CSV text file. All major spreadsheet programs can export data in this format. If you do not know how to export your data to a CSV file, please refer to the documentation of your spreadsheet program.
When exporting to CSV format, make sure to verify the following: