Legacy Fishbowl CSV Import & Export Reference
Fishbowl’s legacy CSV API moves data in and out of Fishbowl by named operation.
Each operation has an API name — the exact string you pass to the CSV call
(for example FB.importCSV("ImportAddInventory", csv)) — and Fishbowl publishes
per-type instructions describing the column layout.
The names below are the operations registered by the Fishbowl client
(ImportExportConfig, 2026.04). The Instructions links go to Fishbowl’s own
documentation, which is the authoritative source for each type’s columns; see
Fishbowl’s Imports and Exports
overview for the full picture. The
Data Import module
can also import files whose headers do not match the Fishbowl format.
Imports
Section titled “Imports”| API name | Description | Instructions |
|---|---|---|
ImportAddInventory |
Add inventory; the quantity increases (not adjusts) existing inventory. | Instructions |
ImportAssociatedPricing |
Associated pricing. | Instructions |
ImportAssociatedPricingType |
Associated pricing types. | Instructions |
ImportBillOfMaterials |
A bill of materials. | Instructions |
ImportBillOfMaterialsDetails |
Details for a bill of materials. | Instructions |
ImportBillOfMaterialsInstructions |
Instruction steps for a bill of materials. | Instructions |
ImportCarriers |
Carriers. | Instructions |
ImportCountryAndState |
Country and state information. | Instructions |
ImportCurrency |
Currency conversion information. | Instructions |
ImportCustomFieldData |
Custom field data. | Instructions |
ImportCustomFieldLists |
Custom field lists. | Instructions |
ImportCustomFields |
Custom fields. | Instructions |
ImportCustomerGroupRelations |
Customer group relations. | Instructions |
ImportCustomerParts |
Customer part numbers. | Instructions |
ImportCustomers |
Customers. | Instructions |
ImportCycleCountData |
Perform a cycle count. | Instructions |
ImportDefaultLocations |
Part default locations. | Instructions |
ImportDiscounts |
Discounts. | Instructions |
ImportGenericShoppingCart |
Information from a generic shopping cart. | Instructions |
ImportInventoryMove |
Perform an inventory move. | Instructions |
ImportKitItems |
Kit items. | Instructions |
ImportLocations |
Locations and location groups. | Instructions |
ImportMemoData |
Memo data information. | Instructions |
ImportMivaShoppingCart |
Information from a MIVA shopping cart. | Instructions |
ImportOSCommerceShoppingCart |
Information from an OS Commerce shopping cart. | Instructions |
ImportPackingData |
Orders that have been packed. | Instructions |
ImportPart |
Parts. | Instructions |
ImportPartAndProductRenaming |
Part and product names. | Instructions |
ImportPartAndQuantity |
Basic part information and quantity. | Instructions |
ImportPartCost |
Part average costs. | Instructions |
ImportPartProductAndVendorPricing |
Part, product, and vendor pricing. | Instructions |
ImportPartStandardCost |
Part standard costs. | Instructions |
ImportPartUnitsOfMeasure |
Part units of measure. | Instructions |
ImportPaymentData |
Payments. | Instructions |
ImportPaymentTerms |
Payment terms. | Instructions |
ImportPickingData |
Orders that have been picked. | Instructions |
ImportPricingRules |
Pricing rules. | Instructions |
ImportProduct |
Products. | Instructions |
ImportProductPricing |
Prices for products. | Instructions |
ImportProductTree |
Products and their product tree categories. | Instructions |
ImportProductTreeCategories |
Product tree categories. | Instructions |
ImportPurchaseOrder |
Purchase orders. | Instructions |
ImportQuickBooksClass |
QuickBooks classes. | Instructions |
ImportReceivingData |
What needs to be received from outstanding purchase orders. | Instructions |
ImportReorderLevels |
Reorder levels. | Instructions |
ImportSalesOrder |
Sales orders. | Instructions |
ImportSalesOrderDetails |
Changes to sales order details. | Instructions |
ImportScrapData |
Details of inventory that has been scrapped. | Instructions |
ImportShipCartonTracking |
Ship carton tracking information. | Instructions |
ImportShippingData |
Orders that have been shipped. | Instructions |
ImportTaxRates |
Tax rates. | Instructions |
ImportTransferOrder |
Transfer orders. | Instructions |
ImportUnitOfMeasureConversions |
Unit of measure conversions. | Instructions |
ImportUnitsOfMeasure |
Units of measure. | Instructions |
ImportUsers |
Users. | Instructions |
ImportVendorCostRules |
Vendor cost rules. | Instructions |
ImportVendorParts |
Vendor part information. | Instructions |
ImportVendors |
Vendors. | Instructions |
ImportWorkOrderSteps |
Work order instruction steps. | Instructions |
ImportYahooShoppingCart |
Information from a Yahoo shopping cart. | Instructions |
Exports
Section titled “Exports”| API name | Description | Instructions |
|---|---|---|
ExportAssociatedPricing |
Associated pricing. | Instructions |
ExportAssociatedPricingType |
Associated pricing types. | Instructions |
ExportBillOfMaterials |
A bill of materials. | Instructions |
ExportBillOfMaterialsDetails |
Details for a bill of materials. | Instructions |
ExportBillOfMaterialsInstructions |
Instruction steps for a bill of materials. | Instructions |
ExportCarriers |
Carriers. | Instructions |
ExportCountryAndState |
Country and state information. | Instructions |
ExportCurrency |
Currency conversion information. | Instructions |
ExportCustomFieldLists |
Custom field lists. | Instructions |
ExportCustomFields |
Custom fields. | Instructions |
ExportCustomerGroupRelations |
Customer group relations. | Instructions |
ExportCustomerParts |
Customer part numbers. | Instructions |
ExportCustomers |
Customers. | Instructions |
ExportCycleCountData |
Cycle count data. | Instructions |
ExportDefaultLocations |
Part default locations. | Instructions |
ExportDiscounts |
Discounts. | Instructions |
ExportEDIShipping |
An EDI Shipping 856SOPI file. | Instructions |
ExportInventoryQuantities |
Current inventory quantities. | Instructions |
ExportKitItems |
Kit items. | Instructions |
ExportLocations |
Locations and location groups. | Instructions |
ExportMemoData |
Memo data information. | Instructions |
ExportPart |
Parts. | Instructions |
ExportPartAndProductRenaming |
Part and product names. | Instructions |
ExportPartCost |
Part average costs. | Instructions |
ExportPartProductAndVendorPricing |
Part, product, and vendor pricing. | Instructions |
ExportPartStandardCost |
Part standard costs. | Instructions |
ExportPartUnitsOfMeasure |
Part units of measure. | Instructions |
ExportPaymentData |
Payments. | Instructions |
ExportPaymentTerms |
Payment terms. | Instructions |
ExportPricingRules |
Pricing rules. | Instructions |
ExportProduct |
Products. | Instructions |
ExportProductPricing |
Prices for products. | Instructions |
ExportProductTree |
Products and their product tree categories. | Instructions |
ExportProductTreeCategories |
Product tree categories. | Instructions |
ExportPurchaseOrder |
Purchase orders. | Instructions |
ExportPurchaseOrderAsSalesOrder |
A purchase order that can be imported as a sales order. | Instructions |
ExportPurchaseOrderLineItems |
Purchase order line items. | Instructions |
ExportQuickBooksClass |
QuickBooks classes. | Instructions |
ExportReceivingData |
A record of outstanding receiving. | Instructions |
ExportReorderLevels |
Reorder levels. | Instructions |
ExportSalesOrder |
Sales orders. | Instructions |
ExportSalesOrderDetails |
Sales order details. | Instructions |
ExportShipCarton |
Ship carton information. | Instructions |
ExportShipCartonTracking |
Ship carton tracking information. | Instructions |
ExportTagInformation |
Inventory tags (an internal number grouping similar items). | Instructions |
ExportTaxRates |
Tax rates. | Instructions |
ExportTransferOrder |
Transfer orders. | Instructions |
ExportUnitOfMeasureConversions |
Unit of measure conversions. | Instructions |
ExportUnitsOfMeasure |
Units of measure. | Instructions |
ExportUsers |
Users. | Instructions |
ExportVendorCostRules |
Vendor cost rules. | Instructions |
ExportVendorParts |
Vendor part information. | Instructions |
ExportVendors |
Vendors. | Instructions |
ExportWorkOrderSteps |
Work order instruction steps. | Instructions |