Export File Column Name Equivalence to Admin Area Field Names

This article contains information about how column names of database export files (available at Inventory > Import / Export for qualifying plans) correspond to field names visible in your Admin Area. On Admin Area pages with multiple sections, you will also find field location details. The columns are arranged in their order of appearance in the export files, unless otherwise noted (for large tables, we have also provided the column names in alphabetical arrangement).

Columns with an asterisk (*) serve as the unique identifier value for the table. They are required for successful import. The presence of the pound symbol (#) in a URL or click path indicates a placeholder for an ID number or alphanumeric ID code.

Table of Contents

Choose the name of a database table to view more information:


ArticleCategories

Admin Area URL: /admin/AdminDetails_Generic.asp?table=ArticleCategories&ID=#

Admin Area click path: Design > Site Content > View List > Filter: Article Categories > #

Alternative click path: N/A

Available for export: yes

Available for import: yes

Database ColumnAdmin Area Field
id * ID
categoryname Category Name
categoryorder Category Order
categorytype Category Type
lastmodified Last Modified
lastmodby Last Mod By

Return to Table of Contents


Articles

Admin Area URL: /admin/AdminDetails_Generic.asp?table=Articles&ID=#

Admin Area click path: Design > Site Content > #

Alternative click path: N/A

Available for export: yes

Available for import: yes

Database ColumnAdmin Area FieldPage Location
id * ID Details
articlebody Article Body Details
articlecaption Article Caption Details
articletitle Article Title Details
categoryid Category ID Details
custom_metatags_override Meta Tags Override (Override meta information with custom HTML) Search Engine Optimization
lastmodby Last Mod By Search Engine Optimization
lastmodified Last Modified Search Engine Optimization
metatag_description Meta Tag Description Search Engine Optimization
metatag_keywords Meta Tag Keywords Search Engine Optimization
metatag_title Meta Tag Title Search Engine Optimization
pagename Page Name Details
spotkey Spot Key Details

Return to Table of Contents


Back_In_Stock_Requests

Admin Area URL: /admin/TableViewer.asp?table=Back_In_Stock_Requests

Admin Area click path: Marketing > In-stock Requests

Alternative click path: N/A

Available for export: yes

Available for import: no

Database ColumnAdmin Area Field
id_back_in_stock_requests ID
emailaddress Email Address
productcode Product Code
sent_email Email Address
date_requested Date Requested

Return to Table of Contents


Categories

Admin Area URL: /admin/AdminDetails_Generic.asp?table=Catgories&ID=#

Admin Area click path: Inventory > Categories > hover > Edit

Alternative click path: N/A

Available for export: yes

Available for import: yes

-- EXPORT ORDER --
Database ColumnAdmin Area FieldPage Location
categoryid * ID Basic Category Info
parentid Subcategory of [ID value] Basic Category Info
categoryname Category Name Basic Category Info
categoryorder Display Order Advanced Info > Category Display
categoryvisible Show in Menu Basic Category Info
alternateurl Alternate URL Advanced Info > Misc
lastmodified "Modified:" [footer]
category_displaymode Product Display Mode Advanced Info > Product Display [non-responsive template]
subcategory_displaymode1 SubCategory Display Mode 1 Advanced Info > Subcategory Display [non-responsive template]
subcategory_displaymode2 SubCategory Display Mode 2 Advanced Info > Subcategory Display
display_columns Display Columns Advanced Info > Product Display [non-responsive template]
display_rows Display Rows Advanced Info > Product Display
display_showlistprice Show List Price Advanced Info > Product Display
display_showsaleprice Show Sale Price Advanced Info > Product Display
display_showyousave Show You Save Advanced Info > Product Display
display_showdescriptionshort Show Description Short Advanced Info > Product Display
display_showdescription Show Description Advanced Info > Product Display
display_showstockstatus Show Stock Status Advanced Info > Product Display
display_showavailability Show Availability Advanced Info > Product Display
display_featuredproductsonly Display Featured Products Only Advanced Info > Product Display
subcategory_displaymode2_columns [no longer used] N/A
rootid [the ID value of the highest-level parent category] N/A
metatag_title Meta Tag Title Advanced Info > Search Engine Optimization
metatag_description Meta Tag Description Advanced Info > Search Engine Optimization
default_sortby Default Sort By Advanced Info > Product Display
link_title_tag Category URL Text Advanced Info > Search Engine Optimization
lastmodby "by" [footer]
category_graphic_placement Gategory Graphic Placement Advanced Info > Category Display
subcategory_displaycolumns Subcategory Display Columns Advanced Info > Subcategory Display [non-responsive template]
filtercategory Filter Category Advanced Info > Misc
auto_maintained_optioncatid [the ID value of an option category marked as Include in Search Refinement] N/A
auto_maintained_optionid [the ID value(s) of any option(s) assigned to the auto_maintained_optioncatid] N/A
private_section_customers_only Private Section Customers Only Advanced Info > Misc
categorydescriptionshort Category Description Short Advanced Info > Category Descriptions
categorydescription Category Description Advanced Info > Category Descriptions
metatag_keywords Meta Tag Keywords Advanced Info > Search Engine Optimization
categorydescription_belowproducts Secondary Description (Below Products) Advanced Info > Category Descriptions
custom_where_clause Custom SQL Filter Advanced Info > Misc
custom_metatags_override Meta Override (Override meta information with custom HTML) Advanced Info > Search Engine Optimization
alternateurl_opennewwindow Alternate URL Popup Advanced Info > Misc
hidden Hide Category Basic Category Info
display_showpoints Show Reward Points Advanced Info > Product Display
vcompareoptout Product Comparison Opt-Out Advanced Info > Misc
breadcrumb Subcategory of [Category Name value] Basic Category Info
photoseed [automatically-generated query string that forces a file update] N/A
subcategory_displaymode1_responsive SubCategory Display Mode 1 Advanced Info > Subcategory Display [responsive template]
subcategory_displaycolumns_responsive Display Columns, Responsive Advanced Info > Subcategory Display [responsive template]
category_displaymode_responsive Product Display Mode Advanced Info > Product Display [responsive template]
display_columns_responsive Display Columns, Responsive Advanced Info > Product Display [responsive template]



-- ALPHABETICAL ORDER --
Database ColumnAdmin Area FieldPage Location
alternateurl Alternate URL Advanced Info > Misc
alternateurl_opennewwindow Alternate URL Popup Advanced Info > Misc
auto_maintained_optioncatid [the ID value of an option category marked as Include in Search Refinement] N/A
auto_maintained_optionid [the ID value(s) of any option(s) assigned to the auto_maintained_optioncatid] N/A
breadcrumb Subcategory of [Category Name value] Basic Category Info
category_displaymode Product Display Mode Advanced Info > Product Display [non-responsive template]
category_displaymode_responsive Product Display Mode Advanced Info > Product Display [responsive template]
category_graphic_placement Gategory Graphic Placement Advanced Info > Category Display
categorydescription Category Description Advanced Info > Category Descriptions
categorydescription_belowproducts Secondary Description (Below Products) Advanced Info > Category Descriptions
categorydescriptionshort Category Description Short Advanced Info > Category Descriptions
categoryid * ID Basic Category Info
categoryname Category Name Basic Category Info
categoryorder Display Order Advanced Info > Category Display
categoryvisible Show in Menu Basic Category Info
custom_metatags_override Meta Override (Override meta information with custom HTML) Advanced Info > Search Engine Optimization
custom_where_clause Custom SQL Filter Advanced Info > Misc
default_sortby Default Sort By Advanced Info > Product Display
display_columns Display Columns Advanced Info > Product Display [non-responsive template]
display_columns_responsive Display Columns, Responsive Advanced Info > Product Display [responsive template]
display_featuredproductsonly Display Featured Products Only Advanced Info > Product Display
display_rows Display Rows Advanced Info > Product Display
display_showavailability Show Availability Advanced Info > Product Display
display_showdescription Show Description Advanced Info > Product Display
display_showdescriptionshort Show Description Short Advanced Info > Product Display
display_showlistprice Show List Price Advanced Info > Product Display
display_showpoints Show Reward Points Advanced Info > Product Display
display_showsaleprice Show Sale Price Advanced Info > Product Display
display_showstockstatus Show Stock Status Advanced Info > Product Display
display_showyousave Show You Save Advanced Info > Product Display
filtercategory Filter Category Advanced Info > Misc
hidden Hide Category Basic Category Info
lastmodby "by" [footer]
lastmodified "Modified:" [footer]
link_title_tag Category URL Text Advanced Info > Search Engine Optimization
metatag_description Meta Tag Description Advanced Info > Search Engine Optimization
metatag_keywords Meta Tag Keywords Advanced Info > Search Engine Optimization
metatag_title Meta Tag Title Advanced Info > Search Engine Optimization
parentid Subcategory of [ID value] Basic Category Info
photoseed [automatically-generated query string that forces a file update] N/A
private_section_customers_only Private Section Customers Only Advanced Info > Misc
rootid [the ID value of the highest-level parent category] N/A
subcategory_displaycolumns Subcategory Display Columns Advanced Info > Subcategory Display [non-responsive template]
subcategory_displaycolumns_responsive Display Columns, Responsive Advanced Info > Subcategory Display [responsive template]
subcategory_displaymode1 SubCategory Display Mode 1 Advanced Info > Subcategory Display [non-responsive template]
subcategory_displaymode1_responsive SubCategory Display Mode 1 Advanced Info > Subcategory Display [responsive template]
subcategory_displaymode2 SubCategory Display Mode 2 Advanced Info > Subcategory Display
subcategory_displaymode2_columns [no longer used] N/A
vcompareoptout Product Comparison Opt-Out Advanced Info > Misc

Return to Table of Contents


Categories_Products_Link

Admin Area URL: N/A

Admin Area click path: N/A

Alternative click path: N/A

Available for export: yes

Available for import: no

Database ColumnAdmin Area Field
id N/A
categoryid [ID value of the category]
auto_maintenance_column N/A

Return to Table of Contents


Customers

Admin Area URL: /admin/AdminDetails_Generic.asp?table=Customers&ID=#

Admin Area click path: Customers > Accounts > #

Alternative click path: N/A

Available for export: yes

Available for import: yes

-- EXPORT ORDER --
Database ColumnAdmin Area FieldPage Location

customerid [cannot be imported]

ID Basic Customer Info
accesskey Access Key Basic Customer Info
firstname First Name Basic Customer Info
lastname Last Name Basic Customer Info
companyname Company Name Basic Customer Info
billingaddress1 Address Line 1 Basic Customer Info
billingaddress2 Address Line 2 Basic Customer Info
city City Basic Customer Info
state State or Province Basic Customer Info
postalcode Postal Code Basic Customer Info
country Country Basic Customer Info
phonenumber Phone Number Basic Customer Info
faxnumber Fax Number Basic Customer Info
emailaddress * E-mail Address Basic Customer Info
paysstatetax Pays State Tax Special Privileges
taxid Tax ID Optional Fields
emailsubscriber Email Subscriber Optional Fields
catalogsubscriber Catalog Subscriber Optional Fields
lastmodified Last Modified Newsletter Subscriptions & Interests
percentdiscount Percent Discount Special Privileges
websiteaddress Website Address Basic Customer Info
discountlevel Pricing Discount Level Special Privileges
customertype [used for ROI tracking - do not import] N/A
lastmodby LastModBy Newsletter Subscriptions & Interests
customer_isanonymous Customer Is Anonymous Optional Fields
issuperadmin IsSuperAdmin Special Privileges
news1 Newsletter 1 Newsletter Subscriptions & Interests
news2 Newsletter 2 Newsletter Subscriptions & Interests
news3 Newsletter 3 Newsletter Subscriptions & Interests
news4 Newsletter 4 Newsletter Subscriptions & Interests
news5 Newsletter 5 Newsletter Subscriptions & Interests
news6 Newsletter 6 Newsletter Subscriptions & Interests
news7 Newsletter 7 Newsletter Subscriptions & Interests
news8 Newsletter 8 Newsletter Subscriptions & Interests
news9 Newsletter 9 Newsletter Subscriptions & Interests
news10 Newsletter 10 Newsletter Subscriptions & Interests
news11 Newsletter 11 Newsletter Subscriptions & Interests
news12 Newsletter 12 Newsletter Subscriptions & Interests
news13 Newsletter 13 Newsletter Subscriptions & Interests
news14 Newsletter 14 Newsletter Subscriptions & Interests
news15 Newsletter 15 Newsletter Subscriptions & Interests
news16 Newsletter 16 Newsletter Subscriptions & Interests
news17 Newsletter 17 Newsletter Subscriptions & Interests
news18 Newsletter 18 Newsletter Subscriptions & Interests
news19 Newsletter 19 Newsletter Subscriptions & Interests
news20 Newsletter 20 Newsletter Subscriptions & Interests
allow_access_to_private_sections Allow Access To Private_Sections Special Privileges
customer_notes Notes Basic Customer Info
salesrep_customerid Sales Rep Basic Customer Info
id_customers_groups ID Customers Groups Optional Fields
custom_field_custom1 Custom Field 1: Custom Fields
custom_field_custom2 Custom Field 2: Custom Fields
custom_field_custom3 Custom Field 3: Custom Fields
custom_field_custom4 Custom Field 4: Custom Fields
custom_field_custom5 Custom Field 5: Custom Fields
removed_from_rewards Removed From Rewards Special Privileges



-- ALPHABETICAL ORDER --
Database ColumnAdmin Area FieldPage Location
accesskey Access Key Basic Customer Info
allow_access_to_private_sections Allow Access To Private_Sections Special Privileges
billingaddress1 Address Line 1 Basic Customer Info
billingaddress2 Address Line 2 Basic Customer Info
catalogsubscriber Catalog Subscriber Optional Fields
city City Basic Customer Info
companyname Company Name Basic Customer Info
country Country Basic Customer Info
custom_field_custom1 Custom Field 1: Custom Fields
custom_field_custom2 Custom Field 2: Custom Fields
custom_field_custom3 Custom Field 3: Custom Fields
custom_field_custom4 Custom Field 4: Custom Fields
custom_field_custom5 Custom Field 5: Custom Fields
customer_isanonymous Customer Is Anonymous Optional Fields
customer_notes Notes Basic Customer Info
customerid [cannot be imported] ID Basic Customer Info
customertype [used for ROI tracking - do not import] N/A
discountlevel Pricing Discount Level Special Privileges
emailaddress * E-mail Address Basic Customer Info
emailsubscriber Email Subscriber Optional Fields
faxnumber Fax Number Basic Customer Info
firstname First Name Basic Customer Info
id_customers_groups ID Customers Groups Optional Fields
issuperadmin IsSuperAdmin Special Privileges
lastmodby LastModBy Newsletter Subscriptions & Interests
lastmodified Last Modified Newsletter Subscriptions & Interests
lastname Last Name Basic Customer Info
news1 Newsletter 1 Newsletter Subscriptions & Interests
news2 Newsletter 2 Newsletter Subscriptions & Interests
news3 Newsletter 3 Newsletter Subscriptions & Interests
news4 Newsletter 4 Newsletter Subscriptions & Interests
news5 Newsletter 5 Newsletter Subscriptions & Interests
news6 Newsletter 6 Newsletter Subscriptions & Interests
news7 Newsletter 7 Newsletter Subscriptions & Interests
news8 Newsletter 8 Newsletter Subscriptions & Interests
news9 Newsletter 9 Newsletter Subscriptions & Interests
news10 Newsletter 10 Newsletter Subscriptions & Interests
news11 Newsletter 11 Newsletter Subscriptions & Interests
news12 Newsletter 12 Newsletter Subscriptions & Interests
news13 Newsletter 13 Newsletter Subscriptions & Interests
news14 Newsletter 14 Newsletter Subscriptions & Interests
news15 Newsletter 15 Newsletter Subscriptions & Interests
news16 Newsletter 16 Newsletter Subscriptions & Interests
news17 Newsletter 17 Newsletter Subscriptions & Interests
news18 Newsletter 18 Newsletter Subscriptions & Interests
news19 Newsletter 19 Newsletter Subscriptions & Interests
news20 Newsletter 20 Newsletter Subscriptions & Interests
paysstatetax Pays State Tax Special Privileges
percentdiscount Percent Discount Special Privileges
phonenumber Phone Number Basic Customer Info
postalcode Postal Code Basic Customer Info
removed_from_rewards Removed From Rewards Special Privileges
salesrep_customerid Sales Rep Basic Customer Info
state State or Province Basic Customer Info
taxid Tax ID Optional Fields
websiteaddress Website Address Basic Customer Info

Return to Table of Contents


Customers_Groups

Admin Area URL: /admin/AdminDetails_Generic.asp?table=Customers_Groups&ID=#

Admin Area click path: Customers > Accounts > # > Optional Fields > ID Customers Groups > View All > #

Alternative click path: N/A

Available for export: yes

Available for import: no

Database ColumnAdmin Area Field
id_customers_groups ID
group_title Group Title
lastmodified Last Modified
lastmodby Last Mod By

Return to Table of Contents


Discounts

Admin Area URL: /admin/AdminDetails_Generic.asp?table=Discounts&ID=#

Admin Area click path: Marketing > Coupons/Discounts > #

Alternative click path: N/A

Available for export: yes

Available for import: yes

-- EXPORT ORDER --
Database ColumnAdmin Area FieldPage Location
discountautoid * ID Basic Discount Info
name Discount Name Basic Discount Info
minqty Minimum Quantity Advanced Info
maxqty Maximum Quantity Advanced Info
discounttype Discount Type Basic Discount Info
discountvalue Discount Value Basic Discount Info
lastmodified "Modified:" [footer]
span Span (ie Buy 10 of any product) Advanced Info
begindate Begin Date Advanced Info
enddate End Date Advanced Info
minorderprice Min Order Price Advanced Info
maxorderprice Max Order Price Advanced Info
apply_to_all_orders [no longer used] N/A
lastmodby "by" [footer]
couponcode Coupon Code Basic Discount Info
onetimeuse [no longer used] N/A
cannot_use_with_any_other Cannot Be Used With Another Coupon Basic Discount Info
taxable_discountaftertax [no longer used] N/A
couponusage Coupon Usage Basic Discount Info



-- ALPHABETICAL ORDER --
Database ColumnAdmin Area FieldPage Location
apply_to_all_orders [no longer used] N/A
begindate Begin Date Advanced Info
cannot_use_with_any_other Cannot Be Used With Another Coupon Basic Discount Info
couponcode Coupon Code Basic Discount Info
couponusage Coupon Usage Basic Discount Info
discountautoid * ID Basic Discount Info
discounttype Discount Type Basic Discount Info
discountvalue Discount Value Basic Discount Info
enddate End Date Advanced Info
lastmodby "by" [footer]
lastmodified "Modified:" [footer]
maxorderprice Max Order Price Advanced Info
maxqty Maximum Quantity Advanced Info
minorderprice Min Order Price Advanced Info
minqty Minimum Quantity Advanced Info
name Discount Name Basic Discount Info
onetimeuse [no longer used] N/A
span Span (ie Buy 10 of any product) Advanced Info
taxable_discountaftertax [no longer used] N/A

Return to Table of Contents


Discounts_ApplyTo

Admin Area URL: N/A

Admin Area click path: N/A

Alternative click path: N/A

Available for export: yes

Available for import: yes

Database ColumnAdmin Area Field
syncid * N/A
discountautoid [ID value of the discount]
productcode [Code value of the product]
categoryid [ID value of the category]

Return to Table of Contents


ExchangeRates

Admin Area URL: /admin/AdminDetails_Generic.asp?table=ExchangeRates&ID=#

Admin Area click path: N/A

Alternative click path: Settings > Currency > Edit (/admin/wizard2.asp?type=currency)

Available for export: yes

Available for import: no

Database ColumnAdmin Area FieldWizard Field
er_id ID N/A
currency Name Currency Name
symbol Symbol Currency Symbol
exchangerate Exchange Rate Exchange Rate
isdefault Set As Default Default?
lastmodified "Modified:" [footer]
lastmodby "by" [footer]
paypal_currencycode PayPal Currency Code N/A

Return to Table of Contents


GiftCardDetails

Admin Area URL: N/A

Admin Area click path: N/A

Alternative click path: N/A

Available for export: yes

Available for import: yes

Database ColumnAdmin Area Field
giftcarddetailsid * [ID value of the gift certificate]
giftcardid N/A
sendmethod [shopper Send Via Email / Send Via Print selection on storefront order form]
emailaddresses [Email Addresses of Recipients: (separate by commas) value on storefront order form]
toname [To: (Optional) value on storefront order form]
fromname [From: (Optional) value on storefront order form]
gifttraknumber [Gift Trak Number value on order detail record]
message [Message: (Optional) value on storefront order form]

Return to Table of Contents


GiftCards

Admin Area URL: /admin/AdminDetails_Generic.asp?table=GiftCards&ID=#

Admin Area click path: Marketing > Gift Certficates > #

Alternative click path: N/A

Available for export: yes

Available for import: yes

Database ColumnAdmin Area Field
giftcardid * ID
giftamount Gift Amount
giftamountleft Gift Amount Left
datecreated Date Created
byorderid Generated By Order ID
lastmodified "Modified:"
customerid Assigned To Customer ID
active Active
lastmodby "by"

Return to Table of Contents


IP_Address_Security_Rules

Admin Area URL: /admin/AdminDetails_Generic.asp?table=IP_Address_Security_Rules&ID=#

Admin Area click path: Settings > IP Firewall > #

Alternative click path: N/A

Available for export: yes

Available for import: no

Database ColumnAdmin Area Field
id ID
allow_or_block Allow Or Block
applies_to_admin_area_only Applies To Admin Area Only
lastmodified Last Modified
lastmodby Last Mod By
ip_range_begin IP Range Begin
ip_range_end IP Range End

Return to Table of Contents


KitLnks

Admin Area URL: /admin/AdminDetails_Generic.asp?table=KitLnks&ID=#

Admin Area click path: N/A

Alternative click path: N/A

Available for export: yes

Available for import: yes

Database ColumnAdmin Area Field
kitlnk_id * ID
kit_id Kit ID
kitlnk_productcode KitLnk Product Code
kitlnk_optionid KitLnk Option ID
kitlnk_qty KitLnk Qty
lastmodified Last Modified
lastmodby Last Mod By
kitlnk_pricediff KitLnk Price Diff

Return to Table of Contents


Kits

Admin Area URL: /admin/AdminDetails_Generic.asp?table=Kits&ID=#

Admin Area click path: N/A

Alternative click path: N/A

Available for export: yes

Available for import: yes

Database ColumnAdmin Area Field
kit_id * ID
kit_type Kit Type
kit_productcode Kit Product Code
kit_isproductcode Kit Is Product Code
kit_qty Kit Qty
lastmodified Last Modified
lastmodby Last Mod By
kit_orderby N/A

Return to Table of Contents


OptionCategories

Admin Area URL: /admin/AdminDetails_Generic.asp?table=OptionCategories&ID=#

Admin Area click path: Inventory > Options > Filter: Option Categories > #

Alternative click path: N/A

Available for export: yes

Available for import: yes

Database ColumnAdmin Area Field
id * ID
headinggroup Group Heading
optioncategoriesdesc Option Category Description
isrequired Required
displaytype Display Type
arrangeoptioncategoriesby Display Order
lastmodified "Modified:"
lastmodby "by"
hide_optioncategoriesdesc Hide Category Description
include_in_search_refinement Include in Search Refinement
aboutoptioncategories About Option Category
use_google_size Use as Google Size
use_google_color Use as Google Color
use_google_material Use as Google Material
use_google_pattern Use as Google Pattern

Return to Table of Contents


Options

Admin Area URL: /admin/AdminDetails_Generic.asp?table=Options&ID=#

Admin Area click path: Inventory > Options > #

Alternative click path: N/A

Available for export: yes

Available for import: yes

-- EXPORT ORDER --
Database ColumnAdmin Area FieldPage Location
id * ID Basic Info
optioncatid Option Category Basic Info
replacesoptionid Replaces Option ID Legacy Volusion Settings
optionsdesc Option Description Basic Info
pricediff Price Diff Basic Info
productweight Additional Weight Advanced Info
recurringpricediff Recurring Price Diff Advanced Info
jumptoproductcode Jump To Product Code Advanced Info
novalue No Value Advanced Info
arrangeoptionsby Display Order Advanced Info
defaultselected Default Selected Legacy Volusion Settings
textbox_size Textbox Length Advanced Info
textbox_rows Textbox Rows Advanced Info
validate_regexpression Validate Reg Expression Legacy Volusion Settings
validate_errormessage Validate Error Message Legacy Volusion Settings
validate_optionid Validate Option ID Legacy Volusion Settings
validate_optioncatid Validate Option Cat ID Legacy Volusion Settings
lastmodified Last Modified Legacy Volusion Settings
isproductcode Is Product Code Advanced Info
vendorpricediff Vendor Price Diff Advanced Info
only_available_with_optionids Only Available With Option ID(s) Legacy Volusion Settings
not_available_with_optionids Not Available With Option ID(s) Legacy Volusion Settings
isproductprice Is Product Price Legacy Volusion Settings
isproductquantity Use as Product Qty Advanced Info
isfixedshippingcost [no longer used] N/A
isproductcode_qty Is Product Code Qty Advanced Info
setupcostdiff Setup Cost Diff Advanced Info
lastmodby Last Mod By Legacy Volusion Settings
optionsdesc_sidenote Option Side Note Advanced Info
textbox_max_length Textbox Character Limit Advanced Info
fixedshippingcost Additional Shipping Cost Advanced Info
applytoproductcodes Apply To Product Codes Basic Info



-- ALPHABETICAL ORDER --
Database ColumnAdmin Area FieldPage Location
applytoproductcodes Apply To Product Codes Basic Info
arrangeoptionsby Display Order Advanced Info
defaultselected Default Selected Legacy Volusion Settings
fixedshippingcost Additional Shipping Cost Advanced Info
id * ID Basic Info
isfixedshippingcost [no longer used] N/A
isproductcode Is Product Code Advanced Info
isproductcode_qty Is Product Code Qty Advanced Info
isproductprice Is Product Price Legacy Volusion Settings
isproductquantity Use as Product Qty Advanced Info
jumptoproductcode Jump To Product Code Advanced Info
lastmodby Last Mod By Legacy Volusion Settings
lastmodified Last Modified Legacy Volusion Settings
not_available_with_optionids Not Available With Option ID(s) Legacy Volusion Settings
novalue No Value Advanced Info
only_available_with_optionids Only Available With Option ID(s) Legacy Volusion Settings
optioncatid Option Category Basic Info
optionsdesc Option Description Basic Info
optionsdesc_sidenote Option Side Note Advanced Info
pricediff Price Diff Basic Info
productweight Additional Weight Advanced Info
recurringpricediff Recurring Price Diff Advanced Info
replacesoptionid Replaces Option ID Legacy Volusion Settings
setupcostdiff Setup Cost Diff Advanced Info
textbox_max_length Textbox Character Limit Advanced Info
textbox_rows Textbox Rows Advanced Info
textbox_size Textbox Length Advanced Info
validate_errormessage Validate Error Message Legacy Volusion Settings
validate_optioncatid Validate Option Cat ID Legacy Volusion Settings
validate_optionid Validate Option ID Legacy Volusion Settings
validate_regexpression Validate Reg Expression Legacy Volusion Settings
vendorpricediff Vendor Price Diff Advanced Info

Return to Table of Contents


OrderDetails

Admin Area URL: /admin/AdminDetails_Generic.asp?table=OrderDetails&ID=#

Admin Area click path: Orders > Process Orders > # > Details > Products > Edit > View > #

Alternative click path: N/A

Available for export: yes

Available for import: yes

-- EXPORT ORDER --
Database ColumnAdmin Area FieldPage Location
orderdetailid * ID Details
orderid OrderID Details
productcode Product Code Details
productname Product Name Details
quantity Quantity Details
downloadfile Download File Details
productprice Product Price Details
totalprice Total Price Details
shipped Shipped Status
shipdate Ship Date Status
gifttraknumber Gift Trak Number Details
locked Locked Status
onorder_qty On Order Qty On Order
giftwrap Gift Wrap Details
giftwrapnote Gift Wrap Note Details
giftwrapcost Gift Wrap Cost Details
lastmodified Last Modified Details
optionids Option IDs Details
rma_number RMA Number Status
rmai_id RMAI ID Status
returned Returned Status
returned_date Returned Date Status
product_keys_shipped Product Keys Shipped Status
iskitid Is Kit ID Details
kitid Kit ID Details
fixed_shippingcost Fixed Shipping Cost Details
fixed_shippingcost_outside_localregion Fixed Shipping Cost Outside Local Region Details
optionid Option ID Details
warehouses Warehouse(s) Details
productweight Product Weight Details
affiliate_commissionable_value Affiliate Commissionable Value Details
customlineitem Custom Line Item Details
taxableproduct Taxable Product Details
freeshippingitem Free Shipping Item Details
productnote Product Note Details
qtyonbackorder Qty On Backorder On Order
qtyonhold Qty On Hold On Order
qtyshipped Qty Shipped On Order
autodropship Auto Drop Ship On Order
lastmodby Last Mod By Details
vendor_price Vendor Price Details
categoryid [no longer used] N/A
options Options Details
qtyonpackingslip [same as Quantity] N/A
couponcode [Coupon Code value of discount] Marketing > Coupons/Discounts > # > Basic Discount Info
discountautoid [no longer used] N/A
discounttype [Discount Type value of discount] Marketing > Coupons/Discounts > # > Basic Discount Info
discountvalue [Discount Value value of discount] Marketing > Coupons/Discounts > # > Basic Discount Info
vat_percentage [VAT Percentage value of product] Inventory > Products > # > Advanced Info > Misc
reward_points_given_for_purchase [Reward Points Given For Purchase value of product] Inventory > Products > # > Advanced Info > Pricing
length [no longer used] N/A
width [no longer used] N/A
height [no longer used] N/A
ships_by_itself [no longer used] N/A
package_type [no longer used] N/A
oversized [no longer used] N/A
additional_handling_indicator [no longer used] N/A
orderdetailid_third_party [no longer used] N/A
orderdetailid_third_party_link [no longer used] N/A



-- ALPHABETICAL ORDER --
Database ColumnAdmin Area FieldPage Location
additional_handling_indicator [no longer used] N/A
affiliate_commissionable_value Affiliate Commissionable Value Details
autodropship Auto Drop Ship On Order
categoryid [no longer used] N/A
couponcode [Coupon Code value of discount] Marketing > Coupons/Discounts > # > Basic Discount Info
customlineitem Custom Line Item Details
discountautoid [no longer used] N/A
discounttype [Discount Type value of discount] Marketing > Coupons/Discounts > # > Basic Discount Info
discountvalue [Discount Value value of discount] Marketing > Coupons/Discounts > # > Basic Discount Info
downloadfile Download File Details
gifttraknumber Gift Trak Number Details
giftwrap Gift Wrap Details
giftwrapcost Gift Wrap Cost Details
giftwrapnote Gift Wrap Note Details
fixed_shippingcost Fixed Shipping Cost Details
fixed_shippingcost_outside_localregion Fixed Shipping Cost Outside Local Region Details
freeshippingitem Free Shipping Item Details
height [no longer used] N/A
iskitid Is Kit ID Details
kitid Kit ID Details
lastmodby Last Mod By Details
lastmodified Last Modified Details
length [no longer used] N/A
locked Locked Status
onorder_qty On Order Qty On Order
optionid Option ID Details
optionids Option IDs Details
options Options Details
orderdetailid * ID Details
orderdetailid_third_party [no longer used] N/A
orderdetailid_third_party_link [no longer used] N/A
orderid OrderID Details
oversized [no longer used] N/A
package_type [no longer used] N/A
product_keys_shipped Product Keys Shipped Status
productcode Product Code Details
productname Product Name Details
productnote Product Note Details
productprice Product Price Details
productweight Product Weight Details
qtyonbackorder Qty On Backorder On Order
qtyonhold Qty On Hold On Order
qtyonpackingslip [same as Quantity] N/A
qtyshipped Qty Shipped On Order
quantity Quantity Details
returned Returned Status
returned_date Returned Date Status
reward_points_given_for_purchase [Reward Points Given For Purchase value of product] Inventory > Products > # > Advanced Info > Pricing
rma_number RMA Number Status
rmai_id RMAI ID Status
shipdate Ship Date Status
shipped Shipped Status
ships_by_itself [no longer used] N/A
taxableproduct Taxable Product Details
totalprice Total Price Details
vat_percentage [VAT Percentage value of product] Inventory > Products > # > Advanced Info > Misc
vendor_price Vendor Price Details
warehouses Warehouse(s) Details
width [no longer used] N/A

Return to Table of Contents


Orders

Admin Area URL: /admin/AdminDetails_ProcessOrder.asp?table=Orders&ID=#

Admin Area click path: Orders > Process Orders > #

Alternative click path: N/A

Available for export: yes

Available for import: yes

This table pulls data from numerous other tables. Most values displayed in the order processing wizard cannot be edited directly. We have included only the column names below.

-- EXPORT ORDER --
Database ColumnAdmin Area Field
orderid * -
customerid -
billingcompanyname -
billingfirstname -
billinglastname -
billingaddress1 -
billingaddress2 -
billingcity -
billingstate -
billingpostalcode -
billingcountry -
billingphonenumber -
shipcompanyname -
shipfirstname -
shiplastname -
shipaddress1 -
shipaddress2 -
shipcity -
shipstate -
shippostalcode -
shipcountry -
shipphonenumber -
shipfaxnumber -
shippingmethodid -
totalshippingcost -
salestaxrate -
paymentamount -
paymentmethodid -
cardholdersname -
creditcardexpdate -
creditcardauthorizationnumber -
creditcardtransactionid -
bankname -
routingnumber -
accountnumber -
accounttype -
micr -
checknumber -
ponum -
giftcardidused -
isagift -
locked -
shipped -
vendorid -
orderdate -
creditcardauthorizationdate -
shipdate -
paymentdeclined -
customer_ipaddress -
lastmodified -
avs -
cashtender -
billingfaxnumber -
cvv2_response -
orderstatus -
affiliate_commissionable_value -
processed_autoevents -
lastmodby -
shipping_locked -
printed -
total_payment_received -
total_payment_authorized -
batchnumber -
tax1_title -
tax2_title -
tax3_title -
salestaxrate1 -
salestaxrate2 -
salestaxrate3 -
salestax1 -
salestax2 -
salestax3 -
creditcardissuedate -
creditcardissuenumber -
ordernotes -
order_comments -
salesrep_customerid -
order_entry_system -
shipresidential -
stock_priority -
custom_field_custom1 -
custom_field_custom2 -
custom_field_custom3 -
custom_field_custom4 -
custom_field_custom5 -
orderid_third_party -
addressvalidated -
cc_last4 -
dv_creditcardnumber -
taxrate_isvat -
tax2_includeprevious -
tax3_includeprevious -
tax1_ignorenotaxrules -
tax2_ignorenotaxrules -
tax3_ignorenotaxrules -
giftwrapnote -
authhash -
pciaas_cardid -
pciaas_maskedcardref -
sorderid -
cancelreason -
canceldate -
isgtsorder -
initiallyshippeddate -
orderid_third_party_link -
orderdateutc -



-- ALPHABETICAL ORDER --
Database ColumnAdmin Area Field
accountnumber -
accounttype -
addressvalidated -
affiliate_commissionable_value -
authhash -
avs -
bankname -
batchnumber -
billingaddress1 -
billingaddress2 -
billingcity -
billingcompanyname -
billingcountry -
billingfaxnumber -
billingfirstname -
billinglastname -
billingphonenumber -
billingpostalcode -
billingstate -
canceldate -
cancelreason -
cardholdersname -
cashtender -
cc_last4 -
checknumber -
creditcardauthorizationdate -
creditcardauthorizationnumber -
creditcardexpdate -
creditcardissuedate -
creditcardissuenumber -
creditcardtransactionid -
custom_field_custom1 -
custom_field_custom2 -
custom_field_custom3 -
custom_field_custom4 -
custom_field_custom5 -
customer_ipaddress -
customerid -
cvv2_response -
dv_creditcardnumber -
giftcardidused -
giftwrapnote -
initiallyshippeddate -
isagift -
isgtsorder -
lastmodby -
lastmodified -
locked -
micr -
order_comments -
order_entry_system -
orderdate -
orderdateutc -
orderid * -
orderid_third_party -
orderid_third_party_link -
ordernotes -
orderstatus -
paymentamount -
paymentdeclined -
paymentmethodid -
pciaas_cardid -
pciaas_maskedcardref -
ponum -
printed -
processed_autoevents -
routingnumber -
salesrep_customerid -
salestax1 -
salestax2 -
salestax3 -
salestaxrate -
salestaxrate1 -
salestaxrate2 -
salestaxrate3 -
shipaddress1 -
shipaddress2 -
shipcity -
shipcompanyname -
shipcountry -
shipdate -
shipfaxnumber -
shipfirstname -
shiplastname -
shipped -
shipphonenumber -
shipping_locked -
shippingmethodid -
shippostalcode -
shipresidential -
shipstate -
sorderid -
stock_priority -
tax1_ignorenotaxrules -
tax1_title -
tax2_ignorenotaxrules -
tax2_includeprevious -
tax2_title -
tax3_ignorenotaxrules -
tax3_includeprevious -
tax3_title -
taxrate_isvat -
total_payment_authorized -
total_payment_received -
totalshippingcost -
vendorid -

Return to Table of Contents


PageText

Admin Area URL: /admin/PageText.asp?Section=All

Admin Area click path: Design > Site Content > Article Group: PageText > List All Records

Alternative click path: N/A

Available for export: yes

Available for import: yes

Database ColumnAdmin Area Field
id * ID
text PageText

Return to Table of Contents


Payment_Log

Admin Area URL: N/A

Admin Area click path: N/A

Alternative click path: Orders > Process Orders > # > Payments > Payment Log

Available for export: yes

Available for import: yes

Database ColumnAdmin Area Field
pay_id * N/A
pay_paymentmethodid [ID value of payment method (/admin/TableViewer.asp?table=paymentmethods)]
pay_transid TransID
pay_authcode AuthCode
pay_avs_response AVS
pay_cvv2_response CVV2
pay_result Payment Type
pay_amount Payment Amount
pay_orderid [Order ID value of order]
pay_authdate Payment Date
pay_details Paid Via
deleted N/A
pay_exclude_from_total_due N/A
pay_parent_transid N/A
third_party_field1 N/A
pciaas_recurringtransaction N/A
pciaas_transactionid N/A

Return to Table of Contents


PO_Items

Admin Area URL: /admin/AdminDetails_Generic.asp?table=PO_Items&ID=#

Admin Area click path: Inventory > Purchase Orders > Filter: PO Items > #

Alternative click path: N/A

Available for export: yes

Available for import: yes

Database ColumnAdmin Area Field
poi_id * ID
po_num PO Num
poi_productcode Product Code
poi_vendor_partno Vendor Part #
poi_productname Product Name
poi_quantity Quantity
poi_vendorprice Vendor Price Ea.
lastmodified Last Modified
lastmodby Last Mod By
poi_qtyreceived Qty Received
poi_shippingcost Shipping Cost Ea.
poi_orderdetailid Order Detail ID
poi_options Product Options

Return to Table of Contents


POs

Admin Area URL: /admin/AdminDetails_Generic.asp?table=POs&ID=#

Admin Area click path: N/A

Alternative click path: Inventory > Purchase Orders > # > Edit (/admin/pages_vendor_po.asp?PO_Num=#&Edit=Y)

Available for export: yes

Available for import: yes

-- EXPORT ORDER --
Database ColumnAdmin Area FieldWizard Field
po_num * PO Num N/A
po_date PO Date Date Created:
vendor_id Vendor ID N/A
vendor_title Vendor Title Vendor Title:
vendor_address Vendor Address From / Vendor:
vendor_po_sendvia Vendor PO Send Via Send Via:
vendor_po_template Vendor PO Template Build PO using template:
vendor_emailaddress Vendor Email Address Email Address:
vendor_email_subject Vendor Email Subject Subject: (if sending via e-mail)
vendor_faxnumber Vendor Fax Number Fax Number:
vendor_po_shipto Vendor PO Ship To Ship To:
vendor_po_shipvia Vendor PO Ship Via Ship Via:
rvendor_po_terms Vendor PO Terms Terms:
vendor_po_duedate Vendor PO Due Date Due Date:
vendor_po_fob Vendor PO FOB FOB:
vendor_po_notes Vendor PO Notes Notes:
vendor_po_signedby Vendor PO Signed By Signed By:
po_shippingcost PO Shipping Cost Shipping Cost:
po_status PO Status N/A
lastmodified N/A N/A
customer_orderid Customer Order ID Customer OrderID:
lastmodby N/A N/A
po_vendor_invoice_num [no longer used] N/A
po_vendor_invoice_date [no longer used] N/A
vendor_contacts Vendor Contacts N/A



-- ALPHABETICAL ORDER --
Database ColumnAdmin Area FieldWizard Field
customer_orderid Customer Order ID Customer OrderID:
lastmodby N/A N/A
lastmodified N/A N/A
po_date PO Date Date Created:
po_num * PO Num N/A
po_shippingcost PO Shipping Cost Shipping Cost:
po_status PO Status N/A
po_vendor_invoice_date [no longer used] N/A
po_vendor_invoice_num [no longer used] N/A
vendor_address Vendor Address From / Vendor:
vendor_contacts Vendor Contacts N/A
vendor_email_subject Vendor Email Subject Subject: (if sending via e-mail)
vendor_emailaddress Vendor Email Address Email Address:
vendor_faxnumber Vendor Fax Number Fax Number:
vendor_id Vendor ID N/A
vendor_po_duedate Vendor PO Due Date Due Date:
vendor_po_fob Vendor PO FOB FOB:
vendor_po_notes Vendor PO Notes Notes:
vendor_po_sendvia Vendor PO Send Via Send Via:
vendor_po_shipto Vendor PO Ship To Ship To:
vendor_po_shipvia Vendor PO Ship Via Ship Via:
vendor_po_signedby Vendor PO Signed By Signed By:
vendor_po_template Vendor PO Template Build PO using template:
vendor_po_terms Vendor PO Terms Terms:
vendor_title Vendor Title Vendor Title:

Return to Table of Contents


Product_Keys

Admin Area URL: /admin/AdminDetails_Generic.asp?table=Product_Keys&ID=#

Admin Area click path: Inventory > Product Key Distribution > #

Alternative click path: N/A

Available for export: yes

Available for import: yes

Database ColumnAdmin Area Field
pkey_id * ID
pkey_keytype PKey KeyType
pkey_allowreuse PKey AllowReuse
pkey_used PKey Used
pkey_dateadded PKey DateAdded
pkey_email_template PKey Email Template
pkey_email_subject PKey Email Subject
lastmodified Last Modified
pkey_originalorderid PKey Original Order ID
pkey_originalorderdetailid PKey Original Order Detail ID
lastmodby Last Mod By
pkey_email_body PKey Email Body

Return to Table of Contents


Products

Admin Area URL: /admin/AdminDetails_Generic.asp?table=Products_Joined&ID=#

Admin Area click path: Inventory > Products > #

Alternative click path: N/A

Available for export: yes

Available for import: yes

-- EXPORT ORDER --
Database ColumnAdmin Area FieldPage Location
productcode * Code Basic Info
vendor_partno Vendor Part # Advanced Info > Vendors
productname Name Basic Info
displaybegindate Display Begin Date Advanced Info > Product Display
displayenddate Display End Date Advanced Info > Product Display
hideproduct Hide Product Advanced Info > Product Display
stockstatus Stock Status Advanced Info > Stock
lastmodified "Modified:" [footer]
options_cloned_from Use Same Options As ProductCode Advanced Info > Misc
photos_cloned_from Use Same Photos As ProductCode Advanced Info > Misc
share_stockstatus_with Link Stock Status with Product Code Advanced Info > Stock
lastmodby "by" [footer]
ischildofproductcode Parent Product Code Advanced Info > Misc
ischildofproductcode_productid [no longer used] N/A
options_cloned_from_productid [no longer used] N/A
photos_cloned_from_productid [no longer used] N/A
share_stockstatus_with_productid [no longer used] N/A
productpopularity Product Popularity Advanced Info > Misc
homepage_section Feature Product on the Homepage Advanced Info > Product Display
autodropship Auto Drop Ship Advanced Info > Vendors
donotallowbackorders Do Not Allow Backorders Advanced Info > Stock
warehouselocation Warehouse Location Advanced Info > Shipping
warehouseaisle Aisle Advanced Info > Shipping
warehousebin Bin Advanced Info > Shipping
warehousecustom Custom Advanced Info > Shipping
upc_code UPC Code Advanced Info > Vendors
productkeywords Additional Product Keyword(s) Advanced Info > Misc
productnameshort Product URL Text Advanced Info > Search Engine Optimization
productweight Weight Basic Info
freeshippingitem Free Shipping Item Advanced Info > Shipping
minqty Min. Order Quantity Advanced Info > Misc
maxqty Max Qty Advanced Info > Misc
recurringstartprice Promotional Starting Price Advanced Info > Recurring Pricing
recurringstartduration Starting Price Duration (in Months) Advanced Info > Recurring Pricing
recurringprice Recurring Price Advanced Info > Recurring Pricing
recurringhowoften Recurring Frequency (in Months) Advanced Info > Recurring Pricing
recurringduration Recurring Duration (months) Advanced Info > Recurring Pricing
allowpriceedit Allow Price Edit Advanced Info > Misc
productprice Price Basic Info
listprice List Price Advanced Info > Pricing
saleprice Sale Price Advanced Info > Pricing
taxableproduct Taxable Product Advanced Info > Pricing
selectedoptionids Set Default Option Advanced Info > Misc
giftwrapcost Gift Wrap Cost Advanced Info > Pricing
downloadfile Download Filename Advanced Info > Misc
availability Availability Advanced Info > Shipping
metatag_title Meta Tag Title Advanced Info > Search Engine Optimization
metatag_description Meta Tag Description Advanced Info > Search Engine Optimization
discountedprice_level1 Discounted Price Level 1 Advanced Info > Pricing Levels
discountedprice_level2 Discounted Price Level 2 Advanced Info > Pricing Levels
discountedprice_level3 Discounted Price Level 3 Advanced Info > Pricing Levels
discountedprice_level4 Discounted Price Level 4 Advanced Info > Pricing Levels
discountedprice_level5 Discounted Price Level 5 Advanced Info > Pricing Levels
photo_subtext Photo Caption Text Advanced Info > Product Descriptions
photo_alttext Photo Alt Text Advanced Info > Search Engine Optimization
discountedrecurringprice_level1 Recurring Price Level 1 Advanced Info > Pricing Levels
discountedrecurringprice_level2 Recurring Price Level 2 Advanced Info > Pricing Levels
discountedrecurringprice_level3 Recurring Price Level 3 Advanced Info > Pricing Levels
discountedrecurringprice_level4 Recurring Price Level 4 Advanced Info > Pricing Levels
discountedrecurringprice_level5 Recurring Price Level 5 Advanced Info > Pricing Levels
fixed_shippingcost Fixed Shipping Cost Advanced Info > Shipping
fixed_shippingcost_outside_localregion Fixed Shipping Cost (Outside Local Region) Advanced Info > Shipping
uses_product_keytypes Uses Product Key Type(s) Advanced Info > Misc
price_subtext Price Sub Text Advanced Info > Product Display
price_subtext_short List Price Description Text Advanced Info > Product Display
listprice_name List Price Name Advanced Info > Product Display
productprice_name Product Price Name Advanced Info > Product Display
saleprice_name Sale Price Name Advanced Info > Product Display
hide_yousave Hide "You Save" Feature Advanced Info > Product Display
hide_freeaccessories Hide Free Accessories Advanced Info > Product Display
setupcost Setup Cost Advanced Info > Pricing
setupcost_name Setup Cost Name Advanced Info > Product Display
discountedsetupcost_level1 Discounted Setup Cost Level 1 Advanced Info > Pricing Levels
discountedsetupcost_level2 Discounted Setup Cost Level 2 Advanced Info > Pricing Levels
discountedsetupcost_level3 Discounted Setup Cost Level 3 Advanced Info > Pricing Levels
discountedsetupcost_level4 Discounted Setup Cost Level 4 Advanced Info > Pricing Levels
discountedsetupcost_level5 Discounted Setup Cost Level 5 Advanced Info > Pricing Levels
setupcost_title Setup Cost Title Advanced Info > Pricing
stockreorderqty Stock Re-Order Qty Advanced Info > Stock
warehouses Warehouse ID(s) Advanced Info > Shipping
affiliate_commissionable_value Affiliate Commissionable Value Advanced Info > Misc
addtocartbtn_replacement_text "Add to Cart" Button Replacement Text Advanced Info > Product Display
book_isbn Book ISBN Advanced Info > Vendors
productcondition Product Condition Advanced Info > 3rd Party Integrations
estship_ground Estimated Shipping - Ground Advanced Info > 3rd Party Integrations
estship_2ndday Estimated Shipping - 2nd Day Advanced Info > 3rd Party Integrations
estship_overnight Estimated Shipping - Overnight Advanced Info > 3rd Party Integrations
customfield1 Custom Field 1 Advanced Info > Custom Fields
customfield2 Custom Field 2 Advanced Info > Custom Fields
customfield3 Custom Field 3 Advanced Info > Custom Fields
customfield4 Custom Field 4 Advanced Info > Custom Fields
customfield5 Custom Field 5 Advanced Info > Custom Fields
shoppingdotcom_category Shopping.com Category Advanced Info > 3rd Party Integrations
yahoo_category Yahoo! Shopping Category Advanced Info > 3rd Party Integrations
yahoo_medium Yahoo! Shopping Medium Advanced Info > 3rd Party Integrations
productmanufacturer Manufacturer Advanced Info > Misc
hide_when_outofstock Hide When Out Of Stock Advanced Info > Product Display
stocklowqtyalarm Stock Low Qty Alarm Advanced Info > Stock
addtopo_now Add To PO Now Advanced Info > Vendors
lastpo_qty Last PO Qty Advanced Info > Vendors
lastpo_date Last PO Date Advanced Info > Vendors
howtogetsaleprice Require Action for Sale Price Advanced Info > Pricing
inv_verify_qtyonhand Verify Qty On-Hand (Internal Use) Advanced Info > Stock
inv_lastverified Qty Last Verified Advanced Info > Stock
enablemultichildaddtocart Enable Multi Child Add To Cart Advanced Info > Product Display
vendor_price Vendor Price Advanced Info > Vendors
enableoptions_inventorycontrol Enable Options Inventory Control Grid Basic Info
photourl_small Photo URL Small Advanced Info > Misc
photourl_large Photo URL Large Advanced Info > Misc
private_section_customers_only Private Section Customers Only Advanced Info > Product Display
quickbooks_item_accnt Quickbooks Item Accnt Advanced Info > 3rd Party Integrations
quickbooks_item_assetaccnt Quickbooks Item Asset Accnt Advanced Info > 3rd Party Integrations
quickbooks_item_cogsaccnt Quickbooks Item COGS Accnt Advanced Info > 3rd Party Integrations
vat_percentage VAT Percentage Advanced Info > Pricing
recurring_pricing_text Recurring Pricing Text Advanced Info > Recurring Pricing
google_product_type Google Product Type Advanced Info > 3rd Party Integrations
length Length (in) Advanced Info > Shipping
width Width (in) Advanced Info > Shipping
height Height (in) Advanced Info > Shipping
ships_by_itself Ships By Itself Advanced Info > Shipping
package_type Package Type Advanced Info > Shipping
oversized UPS Large Package Advanced Info > Shipping
additional_handling_indicator UPS Additional Handling Indicator Advanced Info > Shipping
reward_points_given_for_purchase Reward Points Given For Purchase Advanced Info > Misc
productdescriptionshort Product Description Short Advanced Info > Product Descriptions
productdescription Description Basic Info
productfeatures Features Advanced Info > Product Descriptions
techspecs Technical Specs Advanced Info > Product Descriptions
extinfo Extended Information Advanced Info > Product Descriptions
orderfinished_note Order Finished Note Advanced Info > Product Display
metatag_keywords Meta Tag Keywords Advanced Info > Search Engine Optimization
productdescription_abovepricing Product Description Above Pricing Advanced Info > Product Descriptions
custom_metatags_override Meta Tags Override (Override meta information with custom HTML) Advanced Info > Search Engine Optimization
numproductssharingstock [count of products using this Code value in Link Stock Status with Product Code field - cannot be imported] N/A
ean EAN Code Advanced Info > Vendors
photoseed [automatically-generated query string that forces a file update - cannot be imported] N/A
google_product_category Google Product Type Advanced Info > 3rd Party Integrations
google_size Google Size Advanced Info > 3rd Party Integrations
google_color Google Color Advanced Info > 3rd Party Integrations
google_gender Google Gender Advanced Info > 3rd Party Integrations
google_age_group Google Age Group Advanced Info > 3rd Party Integrations
google_availability Google Availability Advanced Info > 3rd Party Integrations
google_pattern Google Pattern Advanced Info > 3rd Party Integrations
google_material Google Material Advanced Info > 3rd Party Integrations
estdaystoship Estimated Days to Ship Advanced Info > Shipping
google_unique_identifier_exists Google Unique Product Advanced Info > 3rd Party Integrations
google_adult_product Google Adult Product Advanced Info > 3rd Party Integrations
google_sizetype Google Size Type Advanced Info > 3rd Party Integrations
google_sizesystem Google Size System Advanced Info > 3rd Party Integrations
categoryids Categories Basic Info
optionids Options Basic Info
accessories Add Accessories Advanced Info > Misc
freeaccessories Include Free Accessories Advanced Info > Misc
producturl [the URL of the storefront product page - cannot be imported] N/A
photourl [the URL of the main storefront product photo - cannot be imported] N/A
categorytree [the categories and subcategories the product is assigned to - cannot be imported] N/A



-- ALPHABETICAL ORDER --
Database ColumnAdmin Area FieldPage Location
accessories Add Accessories Advanced Info > Misc
additional_handling_indicator UPS Additional Handling Indicator Advanced Info > Shipping
addtocartbtn_replacement_text "Add to Cart" Button Replacement Text Advanced Info > Product Display
addtopo_now Add To PO Now Advanced Info > Vendors
affiliate_commissionable_value Affiliate Commissionable Value Advanced Info > Misc
allowpriceedit Allow Price Edit Advanced Info > Misc
autodropship Auto Drop Ship Advanced Info > Vendors
availability Availability Advanced Info > Shipping
book_isbn Book ISBN Advanced Info > Vendors
categoryids Categories Basic Info
categorytree [the categories and subcategories the product is assigned to - cannot be imported] N/A
custom_metatags_override Meta Tags Override (Override meta information with custom HTML) Advanced Info > Search Engine Optimization
customfield1 Custom Field 1 Advanced Info > Custom Fields
customfield2 Custom Field 2 Advanced Info > Custom Fields
customfield3 Custom Field 3 Advanced Info > Custom Fields
customfield4 Custom Field 4 Advanced Info > Custom Fields
customfield5 Custom Field 5 Advanced Info > Custom Fields
discountedprice_level1 Discounted Price Level 1 Advanced Info > Pricing Levels
discountedprice_level2 Discounted Price Level 2 Advanced Info > Pricing Levels
discountedprice_level3 Discounted Price Level 3 Advanced Info > Pricing Levels
discountedprice_level4 Discounted Price Level 4 Advanced Info > Pricing Levels
discountedprice_level5 Discounted Price Level 5 Advanced Info > Pricing Levels
discountedrecurringprice_level1 Recurring Price Level 1 Advanced Info > Pricing Levels
discountedrecurringprice_level2 Recurring Price Level 2 Advanced Info > Pricing Levels
discountedrecurringprice_level3 Recurring Price Level 3 Advanced Info > Pricing Levels
discountedrecurringprice_level4 Recurring Price Level 4 Advanced Info > Pricing Levels
discountedrecurringprice_level5 Recurring Price Level 5 Advanced Info > Pricing Levels
discountedsetupcost_level1 Discounted Setup Cost Level 1 Advanced Info > Pricing Levels
discountedsetupcost_level2 Discounted Setup Cost Level 2 Advanced Info > Pricing Levels
discountedsetupcost_level3 Discounted Setup Cost Level 3 Advanced Info > Pricing Levels
discountedsetupcost_level4 Discounted Setup Cost Level 4 Advanced Info > Pricing Levels
discountedsetupcost_level5 Discounted Setup Cost Level 5 Advanced Info > Pricing Levels
displaybegindate Display Begin Date Advanced Info > Product Display
displayenddate Display End Date Advanced Info > Product Display
donotallowbackorders Do Not Allow Backorders Advanced Info > Stock
downloadfile Download Filename Advanced Info > Misc
ean EAN Code Advanced Info > Vendors
enablemultichildaddtocart Enable Multi Child Add To Cart Advanced Info > Product Display
enableoptions_inventorycontrol Enable Options Inventory Control Grid Basic Info
estdaystoship Estimated Days to Ship Advanced Info > Shipping
estship_2ndday Estimated Shipping - 2nd Day Advanced Info > 3rd Party Integrations
estship_ground Estimated Shipping - Ground Advanced Info > 3rd Party Integrations
estship_overnight Estimated Shipping - Overnight Advanced Info > 3rd Party Integrations
extinfo Extended Information Advanced Info > Product Descriptions
fixed_shippingcost Fixed Shipping Cost Advanced Info > Shipping
fixed_shippingcost_outside_localregion Fixed Shipping Cost (Outside Local Region) Advanced Info > Shipping
freeaccessories Include Free Accessories Advanced Info > Misc
freeshippingitem Free Shipping Item Advanced Info > Shipping
giftwrapcost Gift Wrap Cost Advanced Info > Pricing
google_adult_product Google Adult Product Advanced Info > 3rd Party Integrations
google_age_group Google Age Group Advanced Info > 3rd Party Integrations
google_availability Google Availability Advanced Info > 3rd Party Integrations
google_color Google Color Advanced Info > 3rd Party Integrations
google_material Google Material Advanced Info > 3rd Party Integrations
google_gender Google Gender Advanced Info > 3rd Party Integrations
google_pattern Google Pattern Advanced Info > 3rd Party Integrations
google_product_category Google Product Type Advanced Info > 3rd Party Integrations
google_product_type Google Product Type Advanced Info > 3rd Party Integrations
google_size Google Size Advanced Info > 3rd Party Integrations
google_sizesystem Google Size System Advanced Info > 3rd Party Integrations
google_sizetype Google Size Type Advanced Info > 3rd Party Integrations
google_unique_identifier_exists Google Unique Product Advanced Info > 3rd Party Integrations
height Height (in) Advanced Info > Shipping
hide_freeaccessories Hide Free Accessories Advanced Info > Product Display
hide_when_outofstock Hide When Out Of Stock Advanced Info > Product Display
hide_yousave Hide "You Save" Feature Advanced Info > Product Display
hideproduct Hide Product Advanced Info > Product Display
homepage_section Feature Product on the Homepage Advanced Info > Product Display
howtogetsaleprice Require Action for Sale Price Advanced Info > Pricing
inv_lastverified Qty Last Verified Advanced Info > Stock
inv_verify_qtyonhand Verify Qty On-Hand (Internal Use) Advanced Info > Stock
ischildofproductcode Parent Product Code Advanced Info > Misc
ischildofproductcode_productid [no longer used] N/A
lastmodby "by" [footer]
lastmodified "Modified:" [footer]
lastpo_date Last PO Date Advanced Info > Vendors
lastpo_qty Last PO Qty Advanced Info > Vendors
length Length (in) Advanced Info > Shipping
listprice List Price Advanced Info > Pricing
listprice_name List Price Name Advanced Info > Product Display
maxqty Max Qty Advanced Info > Misc
metatag_description Meta Tag Description Advanced Info > Search Engine Optimization
metatag_keywords Meta Tag Keywords Advanced Info > Search Engine Optimization
metatag_title Meta Tag Title Advanced Info > Search Engine Optimization
minqty Min. Order Quantity Advanced Info > Misc
numproductssharingstock [count of products using this Code value in Link Stock Status with Product Code field - cannot be imported] N/A
optionids Options Basic Info
options_cloned_from Use Same Options As ProductCode Advanced Info > Misc
options_cloned_from_productid [no longer used] N/A
orderfinished_note Order Finished Note Advanced Info > Product Display
oversized UPS Large Package Advanced Info > Shipping
package_type Package Type Advanced Info > Shipping
photo_alttext Photo Alt Text Advanced Info > Search Engine Optimization
photo_subtext Photo Caption Text Advanced Info > Product Descriptions
photos_cloned_from Use Same Photos As ProductCode Advanced Info > Misc
photos_cloned_from_productid [no longer used] N/A
photoseed [automatically-generated query string that forces a file update - cannot be imported] N/A
photourl [the URL of the main storefront product photo - cannot be imported] N/A
photourl_large Photo URL Large Advanced Info > Misc
photourl_small Photo URL Small Advanced Info > Misc
price_subtext Price Sub Text Advanced Info > Product Display
price_subtext_short List Price Description Text Advanced Info > Product Display
private_section_customers_only Private Section Customers Only Advanced Info > Product Display
productcode * Code Basic Info
productcondition Product Condition Advanced Info > 3rd Party Integrations
productdescription Description Basic Info
productdescription_abovepricing Product Description Above Pricing Advanced Info > Product Descriptions
productdescriptionshort Product Description Short Advanced Info > Product Descriptions
productfeatures Features Advanced Info > Product Descriptions
productkeywords Additional Product Keyword(s) Advanced Info > Misc
productmanufacturer Manufacturer Advanced Info > Misc
productname Name Basic Info
productnameshort Product URL Text Advanced Info > Search Engine Optimization
productpopularity Product Popularity Advanced Info > Misc
productprice Price Basic Info
productprice_name Product Price Name Advanced Info > Product Display
producturl [the URL of the storefront product page - cannot be imported] N/A
productweight Weight Basic Info
quickbooks_item_accnt Quickbooks Item Accnt Advanced Info > 3rd Party Integrations
quickbooks_item_assetaccnt Quickbooks Item Asset Accnt Advanced Info > 3rd Party Integrations
quickbooks_item_cogsaccnt Quickbooks Item COGS Accnt Advanced Info > 3rd Party Integrations
recurring_pricing_text Recurring Pricing Text Advanced Info > Recurring Pricing
recurringduration Recurring Duration (months) Advanced Info > Recurring Pricing
recurringhowoften Recurring Frequency (in Months) Advanced Info > Recurring Pricing
recurringprice Recurring Price Advanced Info > Recurring Pricing
recurringstartduration Starting Price Duration (in Months) Advanced Info > Recurring Pricing
recurringstartprice Promotional Starting Price Advanced Info > Recurring Pricing
reward_points_given_for_purchase Reward Points Given For Purchase Advanced Info > Misc
saleprice Sale Price Advanced Info > Pricing
saleprice_name Sale Price Name Advanced Info > Product Display
selectedoptionids Set Default Option Advanced Info > Misc
setupcost Setup Cost Advanced Info > Pricing
setupcost_name Setup Cost Name Advanced Info > Product Display
setupcost_title Setup Cost Title Advanced Info > Pricing
share_stockstatus_with Link Stock Status with Product Code Advanced Info > Stock
share_stockstatus_with_productid [no longer used] N/A
ships_by_itself Ships By Itself Advanced Info > Shipping
shoppingdotcom_category Shopping.com Category Advanced Info > 3rd Party Integrations
stocklowqtyalarm Stock Low Qty Alarm Advanced Info > Stock
stockreorderqty Stock Re-Order Qty Advanced Info > Stock
stockstatus Stock Status Advanced Info > Stock
taxableproduct Taxable Product Advanced Info > Pricing
techspecs Technical Specs Advanced Info > Product Descriptions
upc_code UPC Code Advanced Info > Vendors
uses_product_keytypes Uses Product Key Type(s) Advanced Info > Misc
vat_percentage VAT Percentage Advanced Info > Pricing
vendor_partno Vendor Part # Advanced Info > Vendors
vendor_price Vendor Price Advanced Info > Vendors
warehouseaisle Aisle Advanced Info > Shipping
warehousebin Bin Advanced Info > Shipping
warehousecustom Custom Advanced Info > Shipping
warehouselocation Warehouse Location Advanced Info > Shipping
warehouses Warehouse ID(s) Advanced Info > Shipping
width Width (in) Advanced Info > Shipping
yahoo_category Yahoo! Shopping Category Advanced Info > 3rd Party Integrations
yahoo_medium Yahoo! Shopping Medium Advanced Info > 3rd Party Integrations

Return to Table of Contents


Recurring

Admin Area URL: /admin/AdminDetails_Generic.asp?table=Recurring&ID=#

Admin Area click path: Orders > Recurring Billing > #

Alternative click path: N/A

Available for export: yes

Available for import: yes

Database ColumnAdmin Area Field
id * ID
originalorderid Original Order ID
startdate Start Date
enddate End Date
recurringprice Recurring Price
howoften How Often
lastpaid Last Paid
active Active
lastmodified Last Modified
originalorderdetailid Original Order ID
recurring_note Recurring Note
delay_charge_until Delay Charge Until
isstartprice N/A
lastmodby Last Mod By

Return to Table of Contents


Reviews

Admin Area URL: /admin/AdminDetails_Generic.asp?table=Reviews&ID=#

Admin Area click path: Customers > Customer Reviews > #

Alternative click path: N/A

Available for export: yes

Available for import: yes

Database ColumnAdmin Area Field
reviewid * ID
lastmodified Last Modified
productcode Product Code
reviewtitle Review Title
rate Rate
customerid Customer ID
yeshelpful Yes Helpful
nothelpful Not Helpful
name Name
location Location
active Active
lastmodby Last Mod By
reviewdescription Review Description

Return to Table of Contents


ReviewsHelpful

Admin Area URL: N/A

Admin Area click path: N/A

Alternative click path: N/A

Available for export: yes

Available for import: yes

Database ColumnAdmin Area Field
id * N/A
customerid [ID value of the customer]
reviewid [ID value of the review]
lastmodified [Last Modified value of the review]

Return to Table of Contents


RMA_Items

Admin Area URL: /admin/AdminDetails_Generic.asp?table=RMA_Items&ID=#

Admin Area click path: Orders > Returns/RMAs > Filter: RMA Items > #

Alternative click path: N/A

Available for export: yes

Available for import: yes

Database ColumnAdmin Area Field
rmai_id * ID
rma_number RMA Number
rmai_orderdetailid RMAI Order Detail ID
lastmodified Last Modified
lastmodby Last Mod By
rmai_quantity Quantity Requested for Return
rmai_qtyreceived_sellable Qty Received: Sellable
rmai_qtyreceived_damaged Qty Received: Damaged
rmai_lostvalue Lost Value
rmai_refundtype [designation of whether the RMA is for a refund or an exchange]
rmai_exchange_orderid [the Order ID value of the exchange order]

Return to Table of Contents


RMAs

Admin Area URL: /admin/AdminDetails_Generic.asp?table=RMAs&ID=#

Admin Area click path: Orders > Returns/RMAs > #

Alternative click path: N/A

Available for export: yes

Available for import: yes

Database ColumnAdmin Area Field
rma_number * RMA Number
rma_date_requested Date Requested
rma_orderid Order ID
rma_status RMA Status
lastmodified Last Modified
lastmodby Last Mod By
rma_deadline RMA Deadline
rma_notes RMA Notes

Return to Table of Contents


SearchTerms

Admin Area URL: /admin/AdminDetails_Generic.asp?table=SearchTerms&ID=#

Admin Area click path: N/A

Alternative click path: Reports > Search Terms

Available for export: yes

Available for import: no

Database ColumnAdmin Area Field
id N/A
searchterm Search Term
ipaddress N/A
lastmodified Last Modified

Return to Table of Contents


ShippingMethods_Flat

Admin Area URL: /admin/AdminDetails_Generic.asp?table=ShippingMethods_Flat&ID=#

Admin Area click path: N/A

Alternative click path: N/A

Available for export: yes

Available for import: no

Database ColumnAdmin Area Field
id_shippingmethods_flat ID
name Name
applyto_states Apply To States
cost_base_rate Cost Base Rate
cost_per_pound Cost Per Pound
lastmodified Last Modified
lastmodby Last Mod By

Return to Table of Contents


States_Provinces

Admin Area URL: /admin/AdminDetails_Generic.asp?table=States_Provinces&ID=#

Admin Area click path: Settings > Shipping > Ship To Location > Edit available states/provinces > #

Alternative click path: N/A

Available for export: no

Available for import: yes

Database ColumnAdmin Area Field
country_id Country ID
state_id State ID
state_name State Name
state_code State Code
state_islocalregion State Is Local Region
lastmodified Last Modified
lastmodby Last Mod By

Return to Table of Contents


Stock_History

Admin Area URL: /admin/TableViewer.asp?Table=Stock_History_Product&ProductID=#

Admin Area click path: Inventory > Products > # > Advanced Info > Stock > Stock Status > (Hist)

Alternative click path: N/A

Available for export: yes

Available for import: no

Database ColumnAdmin Area Field
id Stock History
previous_stock Previous Stock
new_stock New Stock
event Event
eventid EventID
lastmodified Last Modified
lastmodby Last Mod By

Return to Table of Contents


Tax

Admin Area URL: /admin/AdminDetails_Generic.asp?table=Tax&ID=#

Admin Area click path: Settings > Tax > View List > #

Alternative click path: Settings > Tax > Edit (/admin/wizard2.asp?type=tax)

Available for export: yes

Available for import: yes

-- EXPORT ORDER --
Database ColumnAdmin Area FieldPage LocationWizard Field
taxid * ID Details N/A
taxstateshort Tax State SHORT Ship To Location Tax State Short
taxstatelong Tax State LONG Ship To Location Tax State Long
taxcountry Tax Country Ship To Location Region Country
lastmodified Last Modified Tax Rates (up to 3 separate taxes) N/A
lastmodby Last Mod By Tax Rates (up to 3 separate taxes) N/A
tax1_title Tax 1 Title Tax Rates (up to 3 separate taxes) Base Tax Title
tax2_title Tax 2 Title Tax Rates (up to 3 separate taxes) Second Tax Title
tax3_title Tax 3 Title Tax Rates (up to 3 separate taxes) Third Tax Title
tax1_percent Tax 1 Percent Tax Rates (up to 3 separate taxes) (Base Tax) Rate
tax2_percent Tax 2 Percent Tax Rates (up to 3 separate taxes) (Second Tax) Rate
tax3_percent Tax 3 Percent Tax Rates (up to 3 separate taxes) (Third Tax) Rate
taxpostalcode (optional) Tax Postal Code Ship To Location Region Postal Code
taxdefault Tax Default Details Default rate for VAT / GST rate?
isvat Is VAT Tax Rates (up to 3 separate taxes) Tax rate for VAT /GST ?
tax2_includeprevious Tax 2 Include Previous Tax Rates (up to 3 separate taxes) [drop-down menu of Second Tax Title & Rate]
tax3_includeprevious Tax 3 Include Previous Tax Rates (up to 3 separate taxes) [drop-down menu of Third Tax Title & Rate]
tax1_ignorenotaxrules Tax 1 Ignore No Tax Rules Tax Rates (up to 3 separate taxes) Apply to non-taxable items and customers [Base Tax Title & Rate]
tax2_ignorenotaxrules Tax 2 Ignore No Tax Rules Tax Rates (up to 3 separate taxes) Apply to non-taxable items and customers [Second Tax Title & Rate]
tax3_ignorenotaxrules Tax 3 Ignore No Tax Rules Tax Rates (up to 3 separate taxes) Apply to non-taxable items and customers [Third Tax Title & Rate]



-- ALPHABETICAL ORDER --
Database ColumnAdmin Area FieldPage LocationWizard Field
isvat Is VAT Tax Rates (up to 3 separate taxes) Tax rate for VAT /GST ?
lastmodby Last Mod By Tax Rates (up to 3 separate taxes) N/A
lastmodified Last Modified Tax Rates (up to 3 separate taxes) N/A
tax1_ignorenotaxrules Tax 1 Ignore No Tax Rules Tax Rates (up to 3 separate taxes) Apply to non-taxable items and customers [Base Tax Title & Rate]
tax1_percent Tax 1 Percent Tax Rates (up to 3 separate taxes) (Base Tax) Rate
tax1_title Tax 1 Title Tax Rates (up to 3 separate taxes) Base Tax Title
tax2_ignorenotaxrules Tax 2 Ignore No Tax Rules Tax Rates (up to 3 separate taxes) Apply to non-taxable items and customers [Second Tax Title & Rate]
tax2_includeprevious Tax 2 Include Previous Tax Rates (up to 3 separate taxes) [drop-down menu of Second Tax Title & Rate]
tax2_percent Tax 2 Percent Tax Rates (up to 3 separate taxes) (Second Tax) Rate
tax2_title Tax 2 Title Tax Rates (up to 3 separate taxes) Second Tax Title
tax3_ignorenotaxrules Tax 3 Ignore No Tax Rules Tax Rates (up to 3 separate taxes) Apply to non-taxable items and customers [Third Tax Title & Rate]
tax3_includeprevious Tax 3 Include Previous Tax Rates (up to 3 separate taxes) [drop-down menu of Third Tax Title & Rate]
tax3_percent Tax 3 Percent Tax Rates (up to 3 separate taxes) (Third Tax) Rate
tax3_title Tax 3 Title Tax Rates (up to 3 separate taxes) Third Tax Title
taxcountry Tax Country Ship To Location Region Country
taxdefault Tax Default Details Default rate for VAT / GST rate?
taxid * ID Details N/A
taxpostalcode (optional) Tax Postal Code Ship To Location Region Postal Code
taxstatelong Tax State LONG Ship To Location Tax State Long
taxstateshort Tax State SHORT Ship To Location Tax State Short

Return to Table of Contents


TrackingNumbers

Admin Area URL: N/A

Admin Area click path: N/A

Alternative click path: Orders > Process Orders > # Tracking (/admin/AdminDetails_ProcessOrder.asp? table=Orders&ID=#)

Available for export: yes

Available for import: no

Database ColumnAdmin Area FieldPage Location
trackingnumber * Tracking # Orders > Orders > # > Tracking
gateway Gateway Orders > Orders > # > Tracking
shipdate Ship Date Orders > Orders > # > Tracking
orderid Order Orders > Orders > #
shipment_cost Cost Orders > Orders > # > Tracking
shippingmethodid Shipping Method Orders > Orders > # > Tracking
package Shipping Method Orders > Orders > # > Tracking
form [no longer used] N/A

Return to Table of Contents


VendorRules

Admin Area URL: /admin/AdminDetails_Generic.asp?table=VendorRules&ID=#

Admin Area click path: N/A

Alternative click path: Inventory > Products > # > Vendor Rules (/admin/AdminDetails_Generic.asp?table=Products_Joined&ID=#)

Available for export: yes

Available for import: yes

Database ColumnAdmin Area FieldWizard Field
vr_id * ID N/A
vendor_id Vendor ID Vendor ID
vr_productcode VR Product Code N/A
vr_minqty VR Min Qty Min Qty
vr_maxqty VR MaxQty Max Qty
vr_price VR Price Price
vr_partno VR PartNo Vendor PartNo
vr_deactivate_until N/A Deactivate Until
lastmodified Last Modified N/A
lastmodby Last Modified N/A

Return to Table of Contents


Vendors

Admin Area URL: /admin/AdminDetails_Generic.asp?table=vendors&ID=#

Admin Area click path: Inventory > Vendors > #

Alternative click path: N/A

Available for export: yes

Available for import: yes

-- EXPORT ORDER --
Database ColumnAdmin Area Field
vendor_id * ID
vendor_title Vendor Name
vendor_address Vendor Address
vendor_po_sendvia PO Send Via
vendor_po_template PO Template
vendor_emailaddress Vendor Email Address
vendor_email_subject Vendor Email Subject
vendor_faxnumber Vendor Fax Number
vendor_po_shipto Ship To
vendor_po_shipvia Ship Via
vendor_po_terms PO Terms
vendor_po_duedate PO Due Date
vendor_po_fob FOB Notes
vendor_po_notes PO Notes
vendor_po_signedby PO Signed By
lastmodified Last Modified
lastmodby Last Mod By
allows_dropshipping Allows Drop Shipping
active Active
vendor_contacts Additional Contacts



-- ALPHABETICAL ORDER --
Database ColumnAdmin Area Field
active Active
allows_dropshipping Allows Drop Shipping
lastmodby Last Mod By
lastmodified Last Modified
vendor_address Vendor Address
vendor_contacts Additional Contacts
vendor_email_subject Vendor Email Subject
vendor_emailaddress Vendor Email Address
vendor_faxnumber Vendor Fax Number
vendor_id * ID
vendor_po_duedate PO Due Date
vendor_po_fob FOB Notes
vendor_po_notes PO Notes
vendor_po_sendvia PO Send Via
vendor_po_shipto Ship To
vendor_po_shipvia Ship Via
vendor_po_signedby PO Signed By
vendor_po_template PO Template
vendor_po_terms PO Terms
vendor_title Vendor Name

Return to Table of Contents


Warehouses

Admin Area URL: /admin/AdminDetails_Generic.asp?table=Warehouses&ID=#

Admin Area click path: Inventory > Warehouses > #

Alternative click path: N/A

Available for export: yes

Available for import: no

Database ColumnAdmin Area Field
id_warehouses ID
warehouse_name Warehouse Name
country Country
state State or Province
postalcode Postal Code
lastmodified "Modified:"
lastmodby "by"

Return to Table of Contents

Watch the Import / Export video series