Importing Orders from a MIVA Shopping Cart

Fishbowl Inventory has the ability to import order information from a MIVA shopping cart. The orders.dat file can be exported from MIVA 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 'MIVA 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 a 'MIVASCCustomer' 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 the PROCESSED flag set to 1. 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 a 'MIVAPrefix' property and set the value to what you want the prefix to be. The default is 'MSC-'.

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 order.dat file is exported from MIVA as a tab delimited file. This information 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 a MIVA order.dat file:

Column Name	Type	Description
ORDER_ID	Text	The Order ID inside of MIVA. This field will be used as the sales order number in Fishbowl Inventory.
PROCESSED	Numeric	If this is set to 1, Fishbowl Inventory will create a payment for this order by default.
ORDER_DATE	Numeric	This date will be used to set the Order Date and the Fulfillment Date inside of Fishbowl Inventory.
ORDER_TIME	Text	Not used by Fishbowl Inventory.
SHIP_FNAME	Text	The first name of the person the order is being shipped to. This will be combined with the SHIP_LNAME and the SHIP_ADDR fields to create the ship to address.
SHIP_LNAME	Text	The last name of the person the order is being shipped to. This will be combined with the SHIP_FNAME and the SHIP_ADDR fields to create the ship to address.
SHIP_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.
SHIP_COMP	Text	Not used by Fishbowl Inventory.
SHIP_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.
SHIP_FAX	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 fax contact.
SHIP_ADDR	Text	This is the ship to street address for the order. It will be combined with the SHIP_FNAME and the SHIP_LNAME to create the ship to address field.
SHIP_ADDR2	Text	Not used by Fishbowl Inventory.
SHIP_CITY	Text	The ship to city.
SHIP_STATE	Text	The ship to state.
SHIP_ZIP	Text	The ship to zip code.
SHIP_CNTRY	Text	The ship to country code.
BILL_FNAME	Text	The first name of the person the order is being billed to. This will be combined with the BILL_LNAME and the BILL_ADDR fields to create the bill to address.
BILL_LNAME	Text	The last name of the person the order is being billed to. This will be combined with the BILL_FNAME and the BILL_ADDR fields to create the bill to address.
BILL_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 bill to email contact.
BILL_COMP	Text	Not used by Fishbowl Inventory.
BILL_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 bill to main contact.
BILL_FAX	Text	Not used by default. If the SCImportCustomers system property is set to true, it will import this field as the customer's default bill to fax contact.
BILL_ADDR	Text	This is the bill to street address for the order. It will be combined with the BILL_FNAME and the BILL_LNAME to create the bill to address field.
BILL_ADDR2	Text	Not used by Fishbowl Inventory.
BILL_CITY	Text	The bill to city.
BILL_STATE	Text	The bill to state.
BILL_ZIP	Text	The bill to zip code.
BILL_CNTRY	Text	The bill to country code.
PROD_CODE	Text	This is the product code inside of MIVA. This should match up with the Product Number in Fishbowl.
PROD_NAME	Text	Not used by Fishbowl Inventory. The line item description is populated from the Product Description field in the database.
PROD_UPSLD	Text	Not used by Fishbowl Inventory.
PROD_PRICE	Numeric	The price of the product.
PROD_QUANT	Numeric	The quantity of the product. All line items imported from MIVA use the Each UOM.
PROD_ATTR	Text	Not used by Fishbowl Inventory.
PROD_OPT	Text	Not used by Fishbowl Inventory.
OPT_PRICE	Numeric	Not used by Fishbowl Inventory.
ORDER_TAX	Numeric	The total tax for the order.
ORDER_SHIP	Numeric	The total shipping amount for the order.
SHIP_METHOD	Text	The sales order carrier.
ORDER_TOTL	Numeric	The total amount for the order. This is not imported because it is calculated it inside of Fishbowl.