CSV Imports and Exports

From Fishbowl

(Redirected from CSV Import)
Jump to: navigation, search

Fishbowl can import and export information through Comma Separated Values (CSV) files. CSV files can be viewed and edited in spreadsheet applications like Microsoft Excel, or in any text editor.

The Small.Schedule.png Schedule module allows imports or exports to run automatically.


Using CSV imports and exports
Jump to top of page

The list of imports and exports, along with the corresponding documentation, can be found in the Fishbowl Client. The following steps outline the basic use of imports/exports:

  1. Click the File Menu at the top-left of the Fishbowl Client and choose Import or Export.
    Import Menu.png
  2. Select an import/export from the list. The list can be filtered by typing the first few letters of an import/export. A brief description of the selected import is given in the lower pane.
    Import List.png
  3. Click Next to read the instructions for an import/export. A template can be saved by clicking the Export Template button.
    Import Instructions.png
  4. Click Next to choose the file to be imported/exported.
    Import File.png
  5. Click Finish to complete the import/export.

Jump to top of page

Fishbowl provides two ways to create CSV templates that contain the column headers or the actual data as well.

CSV import tips
Jump to top of page

List of imports and exports
Jump to top of page

Below is a list of CSV imports and exports available in Fishbowl. Click the Instructions link to see the instructions for each CSV. These instructions are also included in the Fishbowl Client.

Name Description Instructions
Add Inventory Import to Add inventory. The quantity in the import will increase (not adjust) existing inventory. Import Instructions
Associated Pricing Import/Export Associated Pricing. Import/Export Instructions
Associated Pricing Type Import/Export Associated Pricing Types. Import/Export Instructions
Bill of Materials Import/Export Bills of Materials. Import/Export Instructions
Carriers Import/Export Carriers. Import/Export Instructions
Country And State Import/Export Country and State information. Import/Export Instructions
Custom Field Data Import/Export Custom Field data information. Import/Export Instructions
Custom Field Lists Import/Export Custom Field list definitions. Import/Export Instructions
Custom Fields Import/Export Custom Field definitions. Import/Export Instructions
Customer Group Relations Import/Export Customer Group Relations. Import/Export Instructions
Customer Parts Import/Export Customer Part Numbers. Import/Export Instructions
Customers Import/Export Customers. Import/Export Instructions
Cycle Count Data Import/Export to perform a Cycle count. Import/Export Instructions
Default Locations Import/Export Part default locations. Import/Export Instructions
Discounts Import/Export Discounts. Import/Export Instructions
EDI Shipping Export an EDI Shipping 856SOPI file. Export Instructions
Generic Shopping Cart Import information from a generic shopping cart. Import Instructions
Inventory Move Import to perform an Inventory move. Import Instructions
Inventory Quantities Export current inventory quantities. Export Instructions
Kit Items Import/Export Kit Items. Import/Export Instructions
Locations Import/Export Locations and Location Groups. Import/Export Instructions
MIVA Shopping Cart Import information from a MIVA shopping cart. Import Instructions
OS Commerce Shopping Cart Import information from an OS Commerce shopping cart. Import Instructions
Packing Data Import orders that have been Packed. Import Instructions
Part Import/Export Parts. Import/Export Instructions
Part and Product Renaming Import/Export Part and Product names. Import/Export Instructions
Part Cost Import/Export part Average costs. Import Instructions - Export Instructions
Part, Product, and Vendor Pricing Import/Export part, product and vendor pricing. Import Instructions - Export Instructions
Part Standard Cost Import/Export part Standard Costs. Import/Export Instructions
Part Units of Measure Import/Export part Units of Measure. Import Instructions - Export Instructions
Payment Data Import/Export Payments. Import/Export Instructions
Payment Terms Import/Export Payment Terms. Import/Export Instructions
Picking Data Import orders that have been Picked. Import Instructions
Pipeline Accounts Export customers that can be imported into Fishbowl Pipeline. Export Instructions
Pricing Rules Import/Export Pricing Rules. Import/Export Instructions
Product Import/Export Products. Import/Export Instructions
Product Pricing Export prices for current Products. Export Instructions
Product Tree Import/Export products and the corresponding Product Tree Categories. Import/Export Instructions
Product Tree Categories Import/Export Product Tree Categories. Import/Export Instructions
Purchase Order Import/Export Purchase Orders. Import/Export Instructions
Purchase Order As Sales Order Export a Purchase Order that can be imported as a Sales Order. Export Instructions
Purchase Order Line Items Export Purchase Order Line Items. Export Instructions
Receiving Data Import/Export a record of what needs to be received from outstanding purchase orders. Import Instructions - Export Instructions
Reorder Levels Import/Export Reorder Levels. Import/Export Instructions
Sales Order Import/Export Sales Orders. Import Instructions - Export Instructions
Scrap Data Import details of inventory that has been scrapped. Import Instructions
Ship Carton Export ship carton information. Export Instructions
Ship Carton Tracking Import/Export ship carton tracking information. Import/Export Instructions
Shipping Data Import orders that have been Shipped. Import Instructions
Tag Information Export inventory tags. A tag is an internal number used to group similar items together. Export Instructions
Tax Rates Import/Export Tax Rates. Import/Export Instructions
Unit of Measure Conversions Import/Export Unit of Measure Conversions. Import/Export Instructions
Units of Measure Import/Export Units of Measure. Import/Export Instructions
Users Import/Export Users. Import/Export Instructions
Vendor Cost Rules Import/Export Vendor Cost Rules. Import/Export Instructions
Vendor Pricing Import Vendor last cost information. Import Instructions
Vendors Import/Export Vendors. Import/Export Instructions
Yahoo Shopping Cart Import information from a Yahoo Shopping Cart. Import Instructions

Suggested order of CSV imports
Jump to top of page

Below is the suggested order of importing (or manually entering) data into Fishbowl when creating a new database:

  1. Units of Measure
  2. Unit of Measure Conversions
  3. Location Groups/Locations
  4. User/User Rights
  5. Payment Terms
  6. Carriers
  7. Custom Fields
  8. Vendors*
  9. Tax Rates
  10. Customers*
  11. Customer Group Relations
  12. Part, Product, and Vendor Pricing*
  13. Kit Items
  14. Default Locations
  15. Add Inventory*
  16. Bill of Materials*
  17. Product Tree Categories
  18. Product Tree
  19. Pricing Rules
  20. Sales Orders
  21. Purchase Orders

* These items may be imported from QuickBooks via the Accounting Configuration Wizard.

Personal tools
Other Pages