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.
Do NOT set this field equal to the name of another Order Manager
field name, such as SKU. |
| 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). |