Importing Packing Information

This allows you to import which sales orders have been packed. It will pack the whole sales order (everything that has been picked). This does not deal with Cartons.

Formatting the Data

You must create a CSV file formatted in a way that Fishbowl knows what to do with the data. This is easiest to do with a spreadsheet program.

When the pricing data is Exported it will be formatted according to the table below. If you are Importing the data file must be formatted according to the table below.

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 Packing file.

Creating a CSV file

In order to import your data, you must first create a comma separated values (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.

• The data is formatted properly (see the first section)
• The file must contain column names in the first row, using the column names in the table above.
• Commas are used to separate fields
• Text values are surrounded by double quotes