Fishbowl Text

Importing Orders from a Shopping Cart
Fishbowl Inventory has the ability to import order information from a
shopping cart. By mapping an export from an online shopping cart to the
fields in this import a new sales order with the information contained within
the import file will be created in Fishbowl Inventory.
Customers
By default, Fishbowl Inventory will import the order using a genericcustomer name like 'Online Customer.' To use a separate customer for each
order, you can create an 'SCImportCustomers' system property and set the
value to true. You can also specify the customer name by creating a
'GenericSCCustomer' system property and setting the value to the desired
customer name.
Payments
By default, Fishbowl Inventory will import a payment for all orders that have
thePaymentProcess flag set to TRUE. If you would like to turn off this
function for any reason, such as if the payments are processed into the
Accounting System another way, you can create an 'SCImportPayments'
system property and set the value to false.
Order Prefixes
By default, Fishbowl Inventory will not prefix the orders imported from a
shopping cart. Instead, it will import the ordernumber as it appears in the
file. If you would like to add a prefix to the order number, in cases where
two shopping carts may be entering the same order numbers, you can do so
by creating a 'SCPrefixOrders' system property and set the value to true.
You can also add a 'GenericPrefix' property and set the value to what you
want the prefix to be. The default is 'SC-'.
A note about shipping:A note about shipping:
A shipping line item will be created with the total amount of shipping on the
order. This line item will be created using the Default Shipping Part that can
be specified on the Shipping tab of the Sales Order Module Options. If no
shipping part is selected, then a miscellaneous line item will be created.
A note about tax rates:
A tax line item will be created for the"Total Tax" amount of the order being
imported. It will be created using the Default Flat Tax that can be set in the
Tax Rate modules Module Options. If no default tax has been set, a
miscellaneous line item will be created instead.

Formatting the Data
This information can be modified in any spreadsheet program. The table
below describes the columns that exist within the imported file.Each line item contains the full order data, and a single line item.
All columns listed below must be in the file. Columns with the
Required flag require a value in the column.
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 Generic Shopping Cart import file:
Column Name

TypeDescription

Text

The Order Number. This field
will be used as the sales order
number in Fishbowl Inventory.
Required

OrderDate

Numeric

This date will be used to set the
Order Date and the Fulfillment
Date inside of Fishbowl
Inventory.
Required

OrderTax

Numeric

The total tax for the order.

OrderShipping

Numeric

The total shipping amount for
the order.Numeric

The total handling amount for
the order. A Misc. Sale item will
be created for this amount.

Numeric

The total discount amount for
the order. A Misc. Credit item
will be created for this amount.

Text

Notes about the order. Anything
here will be placed in the SO
Notes field in Fishbowl.

OrderNumber

OrderHandling

OrderDiscount

OrderNote

The shipping method...