Null Values, CCur, and Type mismatch: '[string]'
 

The StoreFront database must have values in fields that are intended for numeric use. If you do not wish to use a particular function or if it does not apply to you, use a zero or another appropriate value. These fields cannot be left blank.

Common places that are overlooked in the design of StoreFront sites are the shipping, handling, and value-based shipping fields. When you encounter an error referring to "Type Mismatch" or "CCur", review the settings in your Web Manager and Product Manager for blank numeric fields, especially in the shipping setup. Be especially careful when entering data directly into a table of the database: default value settings in Access and SQL Server are not always honored when data is being input directly by a user. Therefore, always put at least a space in empty fields.