The Order Manager includes hundreds of "System Parameters" that can be used to configure the program for the way you want it to work. To change a system parameter, go to the Maintenance Menu and click the "Set System Parameters" button.
For ease of use, the system parameters are divided into "Parameter Groups" with related functions.
This group of parameters is hidden when viewing the system parameters from the maintenance menu, however, here is a list of the parameters in the Inventory Table group:
| Parameter Name | Comments |
| invActualWeightField | The Weight field is what customers see, and is used for calculating shipping charges. The ActualWeight field is for shippers and is used to calculate actual shipping costs. |
|
InvAdditionalHandlingField |
Only pertains to use with integrated UPS Shipping Software. Not for internal merchant use; will cause the merchant to be charged additional shipping fees for item if the box labeled Requires Additional Handling on the Misc. tab of the Inventory record is checked. |
|
invAlturaDontUploadField |
If the Don't sell thru Altura box on the Web fields tab of the item's Inventory record is checked, the product will not be included in the XML file that is created and exported to Altura/Shop.com when the Export Altura Product List button on the Shopping Cart Functions page is clicked. |
|
InvAmazonDontUploadField |
If the Don't Synch with Amazon box on the Web fields tab of the item's Inventory record is checked, the item will not be included when sending an inventory feed to Amazon. |
|
InvAssemblyField |
Field that is used to flag a SKU as an assembly. |
|
InvAuctionTitleField |
Contains the ebay Auction Title, if any. |
|
invAvailabilityField |
Relates to the Availability field found on the Web Fields tab of the Inventory record. (used for Yahoo!Store product uploads). |
| invBarcodeField | Name of field in Inventory table that relates to the Barcode field on the Product Info tab of the Inventory screen. |
| invBOField | Relates to the Backordered field of the inventory table. No longer used. |
| invCategoryField | Name of field in Inventory table that relates to the Category field on the Product Info tab of the Inventory screen. |
| invCodeField | This field is specific to the Yahoo product import. Yahoo has 2 fields that could potentially be used as the item SKU, ID and Code. Order Manager stores them each in their own separate fields. See invIDField. |
| invContentsField | Relates to the Contents field found on the Web Fields tab of the Inventory record. (used for Yahoo!Store product uploads). |
|
invCountryOfOriginField |
Name of field in Inventory table that relates to the Country of Origin field on the Product Info tab of the Inventory screen. Used for USPS and UPS shipments. |
|
invCreditAccountField |
Name of field in Inventory table that relates to the Credit Account field on the Product Info tab of the Inventory screen. (Refers to a QuickBooks account) |
| invCurrency1Field | Name of an available custom (user-defined) currency field. |
| invCurrency2Field | Name of an available custom (user-defined) currency field. |
| invCurrency3Field | Name of an available custom (user-defined) currency field. |
| invCurrency4Field | Name of an available custom (user-defined) currency field. |
| invCurrency5Field |
Name of an available custom (user-defined) currency field. |
| invDataBase* | Name of database where attached Inventory table (if any) is located. Must be located in same directory as store's Order Manager database. Not commonly used, legacy support for Product Manager or custom installations. |
| invDate1Field | Name of an available custom (user-defined) date field. |
| invDate2Field | Name of an available custom (user-defined) date field. |
| invDate3Field | Name of an available custom (user-defined) date field. |
| invDate4Field | Name of an available custom (user-defined) date field. |
| invDate5Field | Name of an available custom (user-defined) date field. |
| invDateEditedField | Reflects the date that the inventory record was last modified by the Import Inventory process (includes records created during order import) and when the Save button is clicked on the Inventory record. Found on Desc./Notes tab of the Inventory record. |
| invDebitAccountField | If a value is entered for the Credit Account field on the Inventory record (see invCreditAccountField), this field is automatically set to the Accounts Receivable account identified within the Accounting Export Setup interface. |
|
InvDefaultBoxField |
Relates to the Default box for packing this product field on the Misc. tab of the Inventory record. |
|
invDescField |
Relates to the Description field on the Desc./Notes tab of the inventory record. |
|
InvDontSellField |
Relates to the Not for sale (part) field on the Product Info tab of the Inventory record. |
|
invDroppedField |
Relates to the Discontinued check box on the Product Info tab of the Inventory record. |
| invDropShipField | Field in inventory table; if True [-1], the item is drop shipped by your supplier, rather than from the merchant's stock. |
| invEditTypeField | Refers to the type of edit that was last performed against an inventory record during inventory import process. Can be seen at the bottom of the Desc./Notes tab on the Inventory record. |
| invEmailBCCField | Relates to the Email BCC field on the Product Info tab of the Inventory record. |
|
invFooterField |
Relates to the Footer field on the Web Fields tab of the Inventory record. |
| invFulfillmentCenterField | Relates to the Fulfillment Center field on the Product Info tab of the Inventory record. |
| invHeaderField | Relates to the Header field on the Web Fields tab of the Inventory record. |
| invHeadlineField | Relates to the Headline field on the Web Fields tab of the Inventory record. |
|
InvHeightField |
Relates to the Height field on the Misc. tab of the Inventory record. |
|
invIDField |
This field is was originally specific to the Yahoo product import. Yahoo has 2 fields that could potentially be used as the item SKU, ID and Code. Order Manager stores them each in their own separate fields regardless of which field is chosen to represent the Order Manager SKU. See invCODEField. This field is also utilized to store the ID from Viking Coders Inventory Manager when products are imported from Miva Merchant using that module. |
| invIgnoreInventoryField | Relates to the Ignore QOH checkbox on the Product Info tab of the Inventory record. |
|
invIgnoreQOHonWebField |
Relates to the Ignore QOH on Websites checkbox on the Web Fields tab of the Inventory record. |
|
invIgnoreSingleUnitSKUField |
This field stores the value from the option radio buttons in the lower left section of the Inventory form and is used to determine which SKU gets placed on purchase orders when you have a singleunit/multiunit SKU relationship. |
| invImageField | Relates to the Image field on the Web Fields tab of the Inventory record. |
| invInteger1Field | Name of an available custom (user-defined) integer field. |
| invInteger2Field | Name of an available custom (user-defined) integer field. |
| invInteger3Field | Name of an available custom (user-defined) integer field. |
| invInteger4Field | Name of an available custom (user-defined) integer field. |
| invInteger5Field | Name of an available custom (user-defined) integer field. |
|
InvIsABoxField |
Relates to the Boxes radio buttons on the Misc. tab of the Inventory record. |
|
invItemNameField |
Relates to the Item Name field on the Product Info tab of the Inventory record. |
| invKitField | Field that is used to flag a SKU as a kit part. |
|
InvLengthField |
Relates to the Length field on the Misc. tab of the Inventory record. |
|
invLocationField |
Relates to the Storage Location field on the Product Info tab of the Inventory record. |
| invLotQuantityField | Relates to the Quantity in this SKU field of the Product Info tab of the Inventory record. Must have a value set in the Single Unit SKU field to use this field. |
|
InvMessageField |
Relates to the Unique message for this product field on the Misc. tab of the Inventory record. The message can be created by editing the record and typing in the message, unlike Standard Messages 1-3. |
|
InvNoBoxNeededField |
Relates to the No Box Required field on the Misc. tab of the Inventory record. |
|
invNoFulfillmentField |
Relates to the Don't do fulfillment check box on the Product Info tab of the Inventory record. |
|
InvNoLayawayField |
Relates to the No Layaways check box on the Product Info tab of the Inventory record. |
|
invNotesField |
No longer used. |
|
InvOldSKUField |
Relates to the Replaces this old SKU field on the Alternate Barcodes & SKUs tab of the Inventory record. |
|
invOpStringField |
A string of options created during the BuildSubSku process and utilized when working with a Miva Merchant cart using Viking Coders Inventory Manager. |
| invOptionFlagField | Custom feature. Not for general use. |
| invPackSeparatelyField | Relates to the Pack Separately check box on the Misc. tab of the Inventory record. |
| invParentSKUField | Name of field in Inventory table that is used to flag a SKU as a parent SKU. |
| invPathField | Relates to the Path field on the Web fields tab and the Image field on the Image tab of the Inventory screen. |
| invPrice10Field | Relates to the Price level fields on the Pricing tab of the Inventory record. (Maximum of 10) |
| invPrice2Field | Relates to the Price level fields on the Pricing tab of the Inventory record. (Maximum of 10) |
| invPrice3Field | Relates to the Price level fields on the Pricing tab of the Inventory record. (Maximum of 10) |
| invPrice4Field | Relates to the Price level fields on the Pricing tab of the Inventory record. (Maximum of 10) |
| invPrice5Field | Relates to the Price level fields on the Pricing tab of the Inventory record. (Maximum of 10). |
| invPrice6Field | Relates to the Price level fields on the Pricing tab of the Inventory record. (Maximum of 10) |
| invPrice7Field | Relates to the Price level fields on the Pricing tab of the Inventory record. (Maximum of 10) |
| invPrice8Field | Relates to the Price level fields on the Pricing tab of the Inventory record. (Maximum of 10) |
| invPrice9Field | Relates to the Price level fields on the Pricing tab of the Inventory record. (Maximum of 10) |
| invPriceField | Relates to the Price level fields on the Pricing tab of the Inventory record. (Maximum of 10) |
| invQOHField | Relates to the # on Hand field of the Product Info tab of the Inventory record. |
| invReorderField | Relates to the Reorder Point check box on the Product Info tab of the Inventory record. |
| invReorderQuantityField | Relates to the Reorder Quantity field on the Product Info tab of the Inventory record. |
|
InvRetailPriceField |
Relates to the Suggested Retail Price field on the Product Info tab of the Inventory record. |
|
invSaleOn10Field |
Relates to the On Sale check boxes on the Pricing tab of the Inventory record. |
| invSaleOn2Field | Relates to the On Sale check boxes on the Pricing tab of the Inventory record. |
| invSaleOn3Field | Relates to the On Sale check boxes on the Pricing tab of the Inventory record. |
| invSaleOn4Field | Relates to the On Sale check boxes on the Pricing tab of the Inventory record. |
| invSaleOn5Field | Relates to the On Sale check boxes on the Pricing tab of the Inventory record. |
| invSaleOn6Field | Relates to the On Sale check boxes on the Pricing tab of the Inventory record. |
| invSaleOn7Field | Relates to the On Sale check boxes on the Pricing tab of the Inventory record. |
| invSaleOn8Field | Relates to the On Sale check boxes on the Pricing tab of the Inventory record. |
| invSaleOn9Field | Relates to the On Sale check boxes on the Pricing tab of the Inventory record. |
| invSaleOnField | Relates to the On Sale check boxes on the Pricing tab of the Inventory record. |
| invSalePrice10Field | Relates to the Sale Price fields on the Pricing tab of the Inventory record. |
| invSalePrice2Field | Relates to the Sale Price fields on the Pricing tab of the Inventory record. |
| invSalePrice3Field | Relates to the Sale Price fields on the Pricing tab of the Inventory record. |
| invSalePrice4Field | Relates to the Sale Price fields on the Pricing tab of the Inventory record. |
| invSalePrice5Field | Relates to the Sale Price fields on the Pricing tab of the Inventory record. |
| invSalePrice6Field | Relates to the Sale Price fields on the Pricing tab of the Inventory record. |
| invSalePrice7Field | Relates to the Sale Price fields on the Pricing tab of the Inventory record. |
| invSalePrice8Field | Relates to the Sale Price fields on the Pricing tab of the Inventory record. |
| invSalePrice9Field | Relates to the Sale Price fields on the Pricing tab of the Inventory record. |
| invSalePriceField | Relates to the Sale Price fields on the Pricing tab of the Inventory record. |
| invSingleUnitSKUField | Relates to the Single Unit SKU field on the Product Info tab of the Inventory record. |
| invSKUField | Relates to the Local SKU field of the Inventory screen. |
| invSKUTypeField | Name of field in Inventory table. (0=Normal, 1=Parent, 2=Sub-SKU) |
|
InvSoldNotReceivedField |
Relates to the Sold not Rec'd check box on the Product Info tab of the Inventory record. |
|
InvStandardMessage1Field |
Relates to Standard Messages 1-3 that can be seen on the Misc. tab of the Inventory record, but are created via the Maintenance Menu>Inventory & Suppliers>Standard Messages>Go. |
|
InvStandardMessage2Field |
Relates to Standard Messages 1-3 that can be seen on the Misc. tab of the Inventory record, but are created via the Maintenance Menu>Inventory & Suppliers>Standard Messages>Go. |
|
InvStandardMessage3Field |
Relates to Standard Messages 1-3 that can be seen on the Misc. tab of the Inventory record, but are created via the Maintenance Menu>Inventory & Suppliers>Standard Messages>Go. |
|
invSupplierDataBase* |
Name of database where attached Inventory Suppliers table is located (legacy custom installations only). Must be located in same directory as store's Order Manager database. Not commonly used. |
| invSupplierTableName* | Name of attached table to use for Inventory Suppliers information. (legacy custom installations only). |
| invTableName* | Name of attached table to use for Inventory information (legacy custom installations) |
| invTaxableField | Relates to the Taxable checkbox on the Product Info tab of the Inventory record. |
| invText1Field | Name of an available custom (user-defined) text field. |
| invText2Field | Name of an available custom (user-defined) text field. |
| invText3Field | Name of an available custom (user-defined) text field. |
| invText4Field | Name of an available custom (user-defined) text field. |
| invText5Field | Name of an available custom (user-defined) text field. |
| invThumbnailField | Relates to the Thumbnail field on the Web Fields tab of the Inventory record. |
|
InvUseSerialNumbersField |
Relates to the Use Serial #s checkbox on the Product Info tab of the Inventory record. |
|
InvWeightField |
Name of field in Inventory table. The Weight field is what customers see, and is used for calculating shipping charges. The ActualWeight field is for shippers and is used to calculate actual shipping costs. |
|
InvWidthField |
Relates to the Width field on the Misc. tab of the Inventory record. |
|
invYahooDontUpload |
Item will not be included when sending inventory synchronization information to Yahoo! |
| UpdateExternalProductTable* | If TRUE, and you are using an external table for your product data, the Order Manager will attempt to add new fields to your table as needed for full Order Manager compatibility. Set to False if the Order Manager cannot add fields to your external table. (legacy product support or custom installations only). |
Updated: 1/26/10