Exporting/Importing Associated Pricing Information

Fishbowl has two features that are closely tied together: the ability to export Associated Pricing information and the ability to import that same type of data. You could use the Export feature to create a file containing your Associated Pricing information. You could then send that file to a franchise who could Import it into their version of Fishbowl updating their Associated Pricing information. An Import will update any Associated Pricings having the same name as those in the import file.

When importing, it assumes that Associated Pricing Type and the Product ID are unique which is not enforced by Fishbowl. This means that when importing, the first Associated Pricing / Product ID definition whose name matches AssocPriceType and ProductID will be the one that is updated. All subsequent imports with the same AssocPriceType and ProductID will be modified with the later data.

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 Associated 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 an Associated Pricing file.

All columns must exist. The file must contain column names in the first row, using the column names in the table above.