Importing Orders from an OSCommerce Shopping Cart

Fishbowl Inventory has the ability to import order information from an OSCommerce shopping cart. The CSV file can be exported from OSCommerce and then imported into Fishbowl. This will create a new sales order with the information contained within the import file.

Customers
By default, Fishbowl Inventory will import the order using a generic customer name like 'OSCommerce Shopping Cart.' 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 an 'OSCommerceSCCustomer' system property and setting the value to the desired customer name.

Payments
By default, Fishbowl Inventory will import a payment for all orders. 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 order number 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 an 'OSCommercePrefix' property and set the value to what you want the prefix to be. The default is 'OSC-'.

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

The CSV file can be modified in any spreadsheet program. The table below describes the columns that exist within the exported file. Not all of the columns are used by Fishbowl Inventory.

Each line item contains the full order data, and a single line item.

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 OSCommerce order file:

Column Name	Type	Description
OrderID	Text	The Order ID inside of OSCommerce. This field will be used as the sales order number in Fishbowl Inventory.
CustomerName	Text	The name of the customer for the order. This should match a customer name inside of Fishbowl Inventory. This is also the bill to name.
Address	Text	The customer's bill to address.
City	Text	The customer's bill to city.
State	Text	The customer's bill to state full name (Utah instead of UT).
Zip	Text	The customer's bill to zip code.
Country	Text	The customer's bill to country.
Email	Text	Not used by default. If the SCImportCustomers system property is set to true, it will import this field as the customer's default ship to email contact.
Phone	Text	Not used by default. If the SCImportCustomers system property is set to true, it will import this field as the customer's default ship to main contact.
ShipName	Text	The name of the person that the order is being shipped to.
ShipAddress	Text	The address the order is being shipped to.
ShipCity	Text	The ship to city.
ShipState	Text	The ship to state full name (Utah instead of UT).
ShipZip	Text	The ship to zip code.
ShipCountry	Text	The ship to country.
PaymentMethod	Text	The payment method used for the order. If this does not match a known Fishbowl Inventory payment type, it will import the payment as a 'Generic Card' payment.
AuthNumber	Text	The authorization number for the payment.
Total	Numeric	The total amount of the order.
Date	Text	The date of the order.
StateTax	Numeric	The total State Tax for the order.
CountryTax	Numeric	The total Country Tax for the order.
Shipping	Numeric	The total Shipping amount for the order.
Handling	Text	The total handling amount for the order.
Discounts	Text	Not used by Fishbowl Inventory.
AddInfo	Text	Not used by Fishbowl Inventory.
Shipping Method	Text	The method in which the order is shipped. This should match a Carrier in Fishbowl Inventory.
ProductID	Text	The Product ID in OSCommerce. This should match a Product Number in Fishbowl Inventory.
ProductName	Text	Not used by Fishbowl Inventory. The line item description is populated from the Product Description field in the database.
ProductPrice	Numeric	The price of the product.
Quantity	Text	The quantity of the product. All line items imported from OSCommerce use the Each UOM.
Options	Text	Not used by Fishbowl Inventory.