We love to play matchmaker 💕 if it makes your job nice and easy!  (Your love life? Well, we can’t make any promises there. 😍 ) We’ve put together a list of  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 order).

 Columns with an asterisk (*) serve as the unique identifier value for the table and 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.

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

Table Details

Database Column: id *
Admin Area field: ID

Database Column: categoryname
Admin Area field: Category Name

Database Column: categoryorder
Admin Area field: Category Order

Database Column: categorytype
Admin Area field: Category Type

Database Column: lastmodified
Admin Area field: Last Modified

Database Column: lastmodby
Admin Area field: Last Mod By

return to 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

Table Details

Database Column: id *
Admin Area Field: ID
Page Location: Details

Database Column: articlebody
Admin Area Field: Article Body
Page Location: Details

Database Column: articlecaption
Admin Area Field: Article Caption
Page Location: Details

Database Column: articletitle
Admin Area Field: Article Title
Page Location: Details

Database Column: categoryid
Admin Area Field: Category ID
Page Location: Details

Database Column: custom_metatags_override
Admin Area Field: Meta Tags Override (Override meta information with custom HTML)
Page Location: Search Engine Optimization

Database Column: lastmodby
Admin Area Field: Last Mod By
Page Location: Search Engine Optimization

Database Column: lastmodified
Admin Area Field: Last Modified
Page Location: Search Engine Optimization

Database Column: metatag_description
Admin Area Field: Meta Tag Description
Page Location: Search Engine Optimization

Database Column: metatag_keywords
Admin Area Field: Meta Tag Keywords
Page Location: Search Engine Optimization

Database Column: metatag_title
Admin Area Field: Meta Tag Title
Page Location: Search Engine Optimization

Database Column: pagename
Admin Area Field: Page Name
Page Location: Details

Database Column: spotkey
Admin Area Field: Spot Key
Page Location: Details

return to 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

Table Details

Database Column: id_back_in_stock_requests
Admin Area Field: ID

Database Column: emailaddress
Admin Area Field: Email Address

Database Column: productcode
Admin Area Field: Product Code

Database Column: sent_email
Admin Area Field: Email Address

Database Column: date_requested
Admin Area Field: Date Requested

return to 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

Table Details

Database Column: categoryid *
Admin Area Field: ID
Page Location: Basic Category Info

Database Column: parentid
Admin Area Field: Subcategory of [ID value]
Page Location: Basic Category Info

Database Column: categoryname
Admin Area Field: Category Name
Page Location: Basic Category Info

Database Column: categoryorder
Admin Area Field: Display Order
Page Location: Advanced Info > Category Display

Database Column: categoryvisible
Admin Area Field: Show in Menu
Page Location: Basic Category Info

Database Column: alternateurl
Admin Area Field: Alternate URL
Page Location: Advanced Info > Misc

Database Column: lastmodified
Admin Area Field: "Modified:"
Page Location: [footer]

Database Column: category_displaymode
Admin Area Field: Product Display Mode
Page Location: Advanced Info > Product Display [non-responsive template]

Database Column: subcategory_displaymode1
Admin Area Field: SubCategory Display Mode 1
Page Location: Advanced Info > Subcategory Display [non-responsive template]

Database Column: subcategory_displaymode2
Admin Area Field: SubCategory Display Mode 2
Page Location: Advanced Info > Subcategory Display

Database Column: display_columns
Admin Area Field: Display Columns
Page Location: Advanced Info > Product Display [non-responsive template]

Database Column: display_rows
Admin Area Field: Display Rows
Page Location: Advanced Info > Product Display

Database Column: display_showlistprice
Admin Area Field: Show List Price
Page Location: Advanced Info > Product Display 

Database Column: display_showsaleprice
Admin Area Field: Show Sale Price
Page Location: Advanced Info > Product Display 

Database Column: display_showyousave
Admin Area Field: Show You Save
Page Location: Advanced Info > Product Display 

Database Column: display_showdescriptionshort
Admin Area Field: Show Description Short
Page Location: Advanced Info > Product Display

Database Column: display_showdescription
Admin Area Field: Show Description
Page Location: Advanced Info > Product Display 

Database Column: display_showstockstatus
Admin Area Field: Show Stock Status
Page Location: Advanced Info > Product Display 

Database Column: display_showavailability
Admin Area Field: Show Availability
Page Location: Advanced Info > Product Display 

Database Column: display_featuredproductsonly
Admin Area Field: Display Featured Products Only
Page Location: Advanced Info > Product Display

Database Column: subcategory_displaymode2_columns
Admin Area Field: [no longer used]
Page Location: N/A

Database Column: rootid
Admin Area Field: [the ID value of the highest-level parent category]
Page Location: N/A

Database Column: metatag_title
Admin Area Field: Meta Tag Title
Page Location: Advanced Info > Search Engine Optimization 

Database Column: metatag_description
Admin Area Field: Meta Tag Description
Page Location: Advanced Info > Search Engine Optimization

Database Column: default_sortby
Admin Area Field: Default Sort By
Page Location: Advanced Info > Product Display

Database Column: link_title_tag
Admin Area Field: Category URL Text
Page Location: Advanced Info > Search Engine Optimization 

Database Column: lastmodby
Admin Area Field: "by"
Page Location: [footer]

Database Column: category_graphic_placement
Admin Area Field: Category Graphic Placement
Page Location: Advanced Info > Category Display

Database Column: subcategory_displaycolumns
Admin Area Field: Subcategory Display Columns
Page Location: Advanced Info > Subcategory Display [non-responsive template]

Database Column: filtercategory
Admin Area Field: Filter Category
Page Location: Advanced Info > Misc

Database Column: auto_maintained_optioncatid
Admin Area Field: [the ID value of an option category marked as Include in Search Refinement]
Page Location: N/A

Database Column: auto_maintained_optionid
Admin Area Field: [the ID value(s) of any option(s) assigned to the auto_maintained_optioncatid]
Page Location: N/A

Database Column: private_section_customers_only
Admin Area Field: Private Section Customers Only
Page Location: Advanced Info > Misc

Database Column: categorydescriptionshort
Admin Area Field: Category Description Short
Page Location: Advanced Info > Category Descriptions

Database Column: categorydescription
Admin Area Field: Category Description
Page Location: Advanced Info > Category Descriptions 

Database Column: metatag_keywords
Admin Area Field: Meta Tag Keywords
Page Location: Advanced Info > Search Engine Optimization

Database Column: categorydescription_belowproducts
Admin Area Field: Secondary Description (Below Products)
Page Location: Advanced Info > Category Descriptions

Database Column: custom_where_clause
Admin Area Field: Custom SQL Filter
Page Location: Advanced Info > Misc 

Database Column: custom_metatags_override
Admin Area Field: Meta Override (Override meta information with custom HTML)
Page Location: Advanced Info > Search Engine Optimization

Database Column: alternateurl_opennewwindow
Admin Area Field: Alternate URL Popup
Page Location: Advanced Info > Misc

Database Column: hidden
Admin Area Field: Hide Category
Page Location: Basic Category Info

Database Column: display_showpoints
Admin Area Field: Show Reward Points
Page Location: Advanced Info > Product Display 

Database Column: vcompareoptout
Admin Area Field: Product Comparison Opt-Out
Page Location: Advanced Info > Misc

Database Column: breadcrumb
Admin Area Field: Subcategory of [Category Name value]
Page Location: Basic Category Info

Database Column: photoseed
Admin Area Field: [automatically-generated query string that forces a file update]
Page Location: N/A 

Database Column: subcategory_displaymode1_responsive
Admin Area Field: SubCategory Display Mode 1
Page Location: Advanced Info > Subcategory Display [responsive template

Database Column: subcategory_displaycolumns_responsive
Admin Area Field: Display Columns, Responsive
Page Location: Advanced Info > Subcategory Display [responsive template

Database Column: category_displaymode_responsive
Admin Area Field: Product Display Mode
Page Location: Advanced Info > Product Display [responsive template]

Database Column: display_columns_responsive
Admin Area Field: Display Columns, Responsive
Page Location: Advanced Info > Product Display [responsive template]

return to 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

Table Details

Database Column: id
Admin Area Field: N/A

Database Column: categoryid
Admin Area Field: [ID value of the category]

Database Column: auto_maintenance_column
Admin Area Field: N/A

return to 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

Table Details

Database Column: customerid [cannot be imported]
Admin Area Field: ID
Page Location: Basic Customer Info

Database Column: accesskey
Admin Area Field: Access Key
Page Location: Basic Customer Info

Database Column: firstname
Admin Area Field: First Name
Page Location: Basic Customer Info

Database Column: lastname
Admin Area Field: Last Name
Page Location: Basic Customer Info

Database Column: companyname
Admin Area Field: Company Name
Page Location: Basic Customer Info

Database Column: billingaddress1
Admin Area Field: Address Line 1
Page Location: Basic Customer Info

Database Column: billingaddress2
Admin Area Field: Address Line 2
Page Location: Basic Customer Info

Database Column: city
Admin Area Field: City
Page Location: Basic Customer Info

Database Column: state
Admin Area Field: State or Province
Page Location: Basic Customer Info 

Database Column: postalcode
Admin Area Field: Postal Code
Page Location: Basic Customer Info

Database Column: country
Admin Area Field: Country
Page Location: Basic Customer Info 

Database Column: phonenumber
Admin Area Field: Phone Number
Page Location: Basic Customer Info

Database Column: faxnumber
Admin Area Field: Fax Number
Page Location: Basic Customer Info

Database Column: emailaddress *
Admin Area Field: E-mail Address
Page Location: Basic Customer Info

Database Column: paysstatetax
Admin Area Field: Pays State Tax
Page Location: Special Privileges

Database Column: taxid
Admin Area Field: Tax ID
Page Location: Optional Fields

Database Column: emailsubscriber
Admin Area Field: Email Subscriber
Page Location: Optional Fields 

Database Column: catalogsubscriber
Admin Area Field: Catalog Subscriber
Page Location: Optional Fields

Database Column: lastmodified
Admin Area Field: Last Modified
Page Location: Newsletter Subscriptions & Interests

Database Column: percentdiscount
Admin Area Field: Percent Discount
Page Location: Special Privileges

Database Column: websiteaddress
Admin Area Field: Website Address
Page Location: Basic Customer Info

Database Column: discountlevel
Admin Area Field: Pricing Discount Level
Page Location: Special Privileges

Database Column: customertype
Admin Area Field: [used for ROI tracking - do not import]
Page Location: N/A

Database Column: lastmodby
Admin Area Field: LastModBy
Page Location: Newsletter Subscriptions & Interests

Database Column: customer_isanonymous
Admin Area Field: Customer Is Anonymous
Page Location: Optional Fields

Database Column: issuperadmin
Admin Area Field: IsSuperAdmin
Page Location: Special Privileges

Database Column: news1
Admin Area Field: Newsletter 1
Page Location: Newsletter Subscriptions & Interests

Database Column: news2
Admin Area Field: Newsletter 2
Page Location: Newsletter Subscriptions & Interests

Database Column: news3
Admin Area Field: Newsletter 3
Page Location: Newsletter Subscriptions & Interests

Database Column: news4
Admin Area Field: Newsletter 4
Page Location: Newsletter Subscriptions & Interests

Database Column: news5
Admin Area Field: Newsletter 5
Page Location: Newsletter Subscriptions & Interests

Database Column: news6
Admin Area Field: Newsletter 6
Page Location: Newsletter Subscriptions & Interests

Database Column: news7
Admin Area Field: Newsletter 7
Page Location: Newsletter Subscriptions & Interests

Database Column: news8
Admin Area Field: Newsletter 8
Page Location: Newsletter Subscriptions & Interests

Database Column: news9
Admin Area Field: Newsletter 9
Page Location: Newsletter Subscriptions & Interests

Database Column: news10
Admin Area Field: Newsletter 10
Page Location: Newsletter Subscriptions & Interests

Database Column: news11
Admin Area Field: Newsletter 11
Page Location: Newsletter Subscriptions & Interests

Database Column: news12
Admin Area Field: Newsletter 12
Page Location: Newsletter Subscriptions & Interests

Database Column: news13
Admin Area Field: Newsletter 13
Page Location: Newsletter Subscriptions & Interests

Database Column: news14
Admin Area Field: Newsletter 14
Page Location: Newsletter Subscriptions & Interests

Database Column: news15
Admin Area Field: Newsletter 15
Page Location: Newsletter Subscriptions & Interests

Database Column: news16
Admin Area Field: Newsletter 16
Page Location: Newsletter Subscriptions & Interests

Database Column: news17
Admin Area Field: Newsletter 17
Page Location: Newsletter Subscriptions & Interests

Database Column: news18
Admin Area Field: Newsletter 18
Page Location: Newsletter Subscriptions & Interests

Database Column: news19
Admin Area Field: Newsletter 19
Page Location: Newsletter Subscriptions & Interests

Database Column: news20
Admin Area Field: Newsletter 20
Page Location: Newsletter Subscriptions & Interests 

Database Column: allow_access_to_private_sections
Admin Area Field: Allow Access To Private_Sections
Page Location: Special Privileges

Database Column: customer_notes
Admin Area Field: Notes
Page Location: Basic Customer Info

Database Column: salesrep_customerid
Admin Area Field: Sales Rep
Page Location: Basic Customer Info

Database Column: id_customers_groups ID
Admin Area Field: Customers Groups
Page Location: Optional Fields

Database Column: custom_field_custom1
Admin Area Field: Custom Field 1:
Page Location: Custom Fields

Database Column: custom_field_custom2
Admin Area Field: Custom Field 2:
Page Location: Custom Fields

Database Column: custom_field_custom3
Admin Area Field: Custom Field 3:
Page Location: Custom Fields

Database Column: custom_field_custom4
Admin Area Field: Custom Field 4:
Page Location: Custom Fields

Database Column: custom_field_custom5
Admin Area Field: Custom Field 5:
Page Location: Custom Fields

Database Column: removed_from_rewards
Admin Area Field: Removed From Rewards
Page Location: Special Privileges

return to 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

Table Details

Database Column: id_customers_groups
Admin Area Field: ID

Database Column: group_title
Admin Area Field: Group Title

Database Column: lastmodified
Admin Area Field: Last Modified

Database Column: lastmodby
Admin Area Field: Last Mod By

return to 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

Table Details

Database Column: discountautoid *
Admin Area Field: ID
Page Location: Basic Discount Info

Database Column: name
Admin Area Field: Discount Name
Page Location: Basic Discount Info

Database Column: minqty
Admin Area Field: Minimum Quantity
Page Location: Advanced Info

Database Column: maxqty
Admin Area Field: Maximum Quantity
Page Location: Advanced Info

Database Column: discounttype
Admin Area Field: Discount Type
Page Location: Basic Discount Info

Database Column: discountvalue
Admin Area Field: Discount Value
Page Location: Basic Discount Info

Database Column: lastmodified
Admin Area Field: "Modified:"
Page Location: [footer]

Database Column: span
Admin Area Field: Span (ie Buy 10 of any product)
Page Location: Advanced Info

Database Column: begindate
Admin Area Field: Begin Date
Page Location: Advanced Info

Database Column: enddate
Admin Area Field: End Date
Page Location: Advanced Info

Database Column: minorderprice
Admin Area Field: Min Order Price
Page Location: Advanced Info

Database Column: maxorderprice
Admin Area Field: Max Order Price
Page Location: Advanced Info

Database Column: apply_to_all_orders
Admin Area Field: [no longer used]
Page Location: N/A

Database Column: lastmodby
Admin Area Field: "by"
Page Location: [footer]

Database Column: couponcode
Admin Area Field: Coupon Code
Page Location: Basic Discount Info

Database Column: onetimeuse
Admin Area Field: [no longer used]
Page Location: N/A

Database Column: cannot_use_with_any_other
Admin Area Field: Cannot Be Used With Another Coupon
Page Location: Basic Discount Info

Database Column: taxable_discountaftertax
Admin Area Field: [no longer used]
Page Location: N/A

Database Column: couponusage
Admin Area Field: Coupon Usage
Page Location: Basic Discount Info

return to 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

Table Details

Database Column: syncid *
Admin Area Field: N/A

Database Column: discountautoid
Admin Area Field: [ID value of the discount]

Database Column: productcode
Admin Area Field: [Code value of the product]

Database Column: categoryid
Admin Area Field: [ID value of the category]

return to 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

Table Details

Database Column: er_id
Admin Area Field: ID
Wizard Field: N/A

Database Column: currency
Admin Area Field: Name
Wizard Field: Currency Name

Database Column: symbol
Admin Area Field: Symbol
Wizard Field: Currency Symbol

Database Column: exchangerate
Admin Area Field: Exchange Rate
Wizard Field: Exchange Rate

Database Column: isdefault
Admin Area Field: Set As Default
Wizard Field: Default?

Database Column: lastmodified
Admin Area Field: "Modified:"
Wizard Field: [footer]

Database Column: lastmodby
Admin Area Field: "by"
Wizard Field: [footer]

Database Column: paypal_currencycode
Admin Area Field: PayPal Currency Code
Wizard Field: N/A

return to 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

Table Details

Database Column: giftcarddetailsid *
Admin Area Field: [ID value of the gift certificate]

Database Column: giftcardid
Admin Area Field: N/A

Database Column: sendmethod
Admin Area Field: [shopper Send Via Email / Send Via Print selection on storefront order form]

Database Column: emailaddresses
Admin Area Field: [Email Addresses of Recipients: (separate by commas) value on storefront order form]

Database Column: toname
Admin Area Field: [To: (Optional) value on storefront order form]

Database Column: fromname
Admin Area Field: [From: (Optional) value on storefront order form]

Database Column: gifttraknumber
Admin Area Field: [Gift Trak Number value on order detail record]

Database Column: message
Admin Area Field: [Message: (Optional) value on storefront order form]

return to 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

Table Details

Database Column: giftcardid *
Admin Area Field: ID

Database Column: giftamount
Admin Area Field: Gift Amount

Database Column: giftamountleft
Admin Area Field: Gift Amount Left

Database Column: datecreated
Admin Area Field: Date Created

Database Column: byorderid
Admin Area Field: Generated By Order ID

Database Column: lastmodified
Admin Area Field: "Modified:"

Database Column: customerid
Admin Area Field: Assigned To Customer ID active Active

Database Column: lastmodby
Admin Area Field: "by"

return to 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

Table Details

Database Column: id
Admin Area Field: ID

Database Column: allow_or_block
Admin Area Field: Allow Or Block

Database Column: applies_to_admin_area_only
Admin Area Field: Applies To Admin Area Only

Database Column: lastmodified
Admin Area Field: Last Modified

Database Column: lastmodby
Admin Area Field: Last Mod By

Database Column: ip_range_begin
Admin Area Field: IP Range Begin

Database Column: ip_range_end
Admin Area Field: IP Range End

return to 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

Table Details

Database Column: kitlnk_id *
Admin Area Field: ID

Database Column: kit_id
Admin Area Field: Kit ID

Database Column: kitlnk_productcode
Admin Area Field: KitLnk Product Code

Database Column: kitlnk_optionid
Admin Area Field: KitLnkOption ID

Database Column: kitlnk_qty
Admin Area Field: KitLnk Qty

Database Column: lastmodified
Admin Area Field: Last Modified

Database Column: lastmodby
Admin Area Field: Last Mod By

Database Column: kitlnk_pricediff
Admin Area Field: KitLnk Price Diff

return to 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

Table Details

Database Column: kit_id *
Admin Area: ID

Database Column: kit_type
Admin Area: Kit Type

Database Column: kit_productcode
Admin Area: Kit Product Code

Database Column: kit_isproductcode
Admin Area: Kit Is Product Code

Database Column: kit_qty
Admin Area: Kit Qty

Database Column: lastmodified
Admin Area: Last Modified

Database Column: lastmodby
Admin Area: Last Mod By

Database Column: kit_orderby
Admin Area: N/A

return to 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

Table Details

Database Column: id *
Admin Area Field: ID

Database Column: headinggroup
Admin Area Field: Group Heading

Database Column: optioncategoriesdesc
Admin Area Field: Option Category Description

Database Column: isrequired
Admin Area Field: Required

Database Column: displaytype
Admin Area Field: Display Type

Database Column: arrangeoptioncategoriesby
Admin Area Field: Display Order

Database Column: lastmodified
Admin Area Field: "Modified:"

Database Column: lastmodby
Admin Area Field: "by"

Database Column: hide_optioncategoriesdesc
Admin Area Field: Hide Category Description 

Database Column: include_in_search_refinement
Admin Area Field: Include in Search Refinement

Database Column: aboutoptioncategories
Admin Area Field: About Option Category

Database Column: use_google_size
Admin Area Field: Use as Google Size

Database Column: use_google_color
Admin Area Field: Use as Google Color

Database Column: use_google_material
Admin Area Field: Use as Google Material

Database Column: use_google_pattern
Admin Area Field: Use as Google Pattern

return to 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

Table Details

Database Column: id *
Admin Area Field: ID
Page Location: Basic Info

Database Column: optioncatid
Admin Area Field: Option Category
Page Location: Basic Info

Database Column: replacesoptionid
Admin Area Field: Replaces Option ID
Page Location: Legacy Volusion Settings

Database Column: optionsdesc
Admin Area Field: Option Description
Page Location: Basic Info

Database Column: pricediff
Admin Area Field: Price Diff
Page Location: Basic Info

Database Column: productweight
Admin Area Field: Additional Weight
Page Location: Advanced Info

Database Column: recurringpricediff
Admin Area Field: Recurring Price Diff
Page Location: Advanced Info

Database Column: jumptoproductcode
Admin Area Field: Jump To Product Code
Page Location: Advanced Info

Database Column: novalue
Admin Area Field: No Value
Page Location: Advanced Info

Database Column: arrangeoptionsby
Admin Area Field: Display Order
Page Location: Advanced Info

Database Column: defaultselected
Admin Area Field: Default Selected
Page Location: Legacy Volusion Settings

Database Column: textbox_size
Admin Area Field: Textbox Length
Page Location: Advanced Info

Database Column: textbox_rows
Admin Area Field: Textbox Rows
Page Location: Advanced Info

Database Column: validate_regexpression
Admin Area Field: Validate Reg Expression
Page Location: Legacy Volusion Settings

Database Column: validate_errormessage
Admin Area Field: Validate Error Message
Page Location: Legacy Volusion Settings

Database Column: validate_optionid
Admin Area Field: Validate Option ID
Page Location: Legacy Volusion Settings

Database Column: validate_optioncatid
Admin Area Field: Validate Option Cat ID
Page Location: Legacy Volusion Settings

Database Column: lastmodified
Admin Area Field: Last Modified
Page Location: Legacy Volusion Settings

Database Column: isproductcode
Admin Area Field: Is Product Code
Page Location: Advanced Info

Database Column: vendorpricediff
Admin Area Field: Vendor Price Diff
Page Location: Advanced Info

Database Column: only_available_with_optionids
Admin Area Field: Only Available With Option ID(s)
Page Location: Legacy Volusion Settings

Database Column: not_available_with_optionids
Admin Area Field: Not Available With Option ID(s)
Page Location: Legacy Volusion Settings

Database Column: isproductprice
Admin Area Field: Is Product Price
Page Location: Legacy Volusion Settings

Database Column: isproductquantity
Admin Area Field: Use as Product Qty
Page Location: Advanced Info

Database Column: isfixedshippingcost
Admin Area Field: [no longer used]
Page Location: N/A

Database Column: isproductcode_qty
Admin Area Field: Is Product Code Qty
Page Location: Advanced Info

Database Column: setupcostdiff
Admin Area Field: Setup Cost Diff
Page Location: Advanced Info

Database Column: lastmodby
Admin Area Field: Last Mod By
Page Location: Legacy Volusion Settings

Database Column: optionsdesc_sidenote
Admin Area Field: Option Side Note
Page Location: Advanced Info

Database Column: textbox_max_length
Admin Area Field: Textbox Character Limit
Page Location: Advanced Info

Database Column: fixedshippingcost
Admin Area Field: Additional Shipping Cost
Page Location: Advanced Info

Database Column: applytoproductcodes
Admin Area Field: Apply To Product Codes
Page Location: Basic Info

return to 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

Table Details

Database Column: orderdetailid *
Admin Area Field: ID
Page Location: Details

Database Column: orderid
Admin Area Field: OrderID
Page Location: Details

Database Column: productcode
Admin Area Field: Product Code
Page Location: Details

Database Column: productname
Admin Area Field: Product Name
Page Location: Details

Database Column: quantity
Admin Area Field: Quantity
Page Location: Details

Database Column: downloadfile
Admin Area Field: Download File
Page Location: Details

Database Column: productprice
Admin Area Field: Product Price
Page Location: Details

Database Column: totalprice
Admin Area Field: Total Price
Page Location: Details

Database Column: shipped
Admin Area Field: Shipped
Page Location: Status

Database Column: shipdate
Admin Area Field: Ship Date
Page Location: Status

Database Column: gifttraknumber
Admin Area Field: Gift Trak Number
Page Location: Details

Database Column: locked
Admin Area Field: Locked
Page Location: Status

Database Column: onorder_qty
Admin Area Field: On Order
Page Location: Qty On Order

Database Column: giftwrap
Admin Area Field: Gift Wrap
Page Location: Details

Database Column: giftwrapnote
Admin Area Field: Gift Wrap Note
Page Location: Details

Database Column: giftwrapcost
Admin Area Field: Gift Wrap Cost
Page Location: Details

Database Column: lastmodified
Admin Area Field: Last Modified
Page Location: Details

Database Column: optionids
Admin Area Field: Option IDs
Page Location: Details

Database Column: rma_number
Admin Area Field: RMA Number
Page Location: Status

Database Column: rmai_id
Admin Area Field: RMAI ID
Page Location: Status

Database Column: returned
Admin Area Field: Returned
Page Location: Status

Database Column: returned_date
Admin Area Field: Returned Date
Page Location: Status

Database Column: product_keys_shipped
Admin Area Field: Product Keys Shipped
Page Location: Status

Database Column: iskitid
Admin Area Field: Is Kit ID
Page Location: Details

Database Column: kitid
Admin Area Field: Kit ID
Page Location: Details

Database Column: fixed_shippingcost
Admin Area Field: Fixed Shipping Cost
Page Location: Details 

Database Column: fixed_shippingcost_outside_localregion
Admin Area Field: Fixed Shipping Cost Outside Local Region
Page Location: Details

Database Column: optionid
Admin Area Field: Option ID
Page Location: Details

Database Column: warehouses
Admin Area Field: Warehouse(s)
Page Location: Details

Database Column: productweight
Admin Area Field: Product Weight
Page Location: Details

Database Column: affiliate_commissionable_value
Admin Area Field: Affiliate Commissionable Value
Page Location: Details 

Database Column: customlineitem
Admin Area Field: Custom Line Item
Page Location: Details

Database Column: taxableproduct
Admin Area Field: Taxable Product
Page Location: Details

Database Column: freeshippingitem
Admin Area Field: Free Shipping Item
Page Location: Details

Database Column: productnote
Admin Area Field: Product Note
Page Location: Details

Database Column: qtyonbackorder
Admin Area Field: Qty On Backorder
Page Location: On Order

Database Column: qtyonhold
Admin Area Field: Qty On Hold
Page Location: On Order

Database Column: qtyshipped
Admin Area Field: Qty Shipped
Page Location: On Order

Database Column: autodropship
Admin Area Field: Auto Drop Ship
Page Location: On Order

Database Column: lastmodby
Admin Area Field: Last Mod By
Page Location: Details

Database Column: vendor_price
Admin Area Field: Vendor Price
Page Location: Details

Database Column: categoryid
Admin Area Field: [no longer used]
Page Location: N/A

Database Column: options
Admin Area Field: Options
Page Location: Details

Database Column: qtyonpackingslip
Admin Area Field: [same as Quantity]
Page Location: N/A

Database Column: couponcode
Admin Area Field: [Coupon Code value of discount]
Page Location: Marketing > Coupons/Discounts > # > Basic Discount Info

Database Column: discountautoid
Admin Area Field: [no longer used]
Page Location: N/A

Database Column: discounttype
Admin Area Field: [Discount Type value of discount]
Page Location: Marketing > Coupons/Discounts > # > Basic Discount Info

Database Column: discountvalue
Admin Area Field: [Discount Value value of discount]
Page Location: Marketing > Coupons/Discounts > # > Basic Discount Info

Database Column: vat_percentage
Admin Area Field: [VAT Percentage value of product]
Page Location: Inventory > Products > # > Advanced Info > Misc

Database Column: reward_points_given_for_purchase
Admin Area Field: [Reward Points Given For Purchase value of product]
Page Location: Inventory > Products > # > Advanced Info > Pricing

Database Column: length
Admin Area Field: [no longer used]
Page Location: N/A

Database Column: width
Admin Area Field: [no longer used]
Page Location: N/A

Database Column: height
Admin Area Field: [no longer used]
Page Location: N/A

Database Column: ships_by_itself
Admin Area Field: [no longer used]
Page Location: N/A

Database Column: package_type
Admin Area Field: [no longer used]
Page Location: N/A

Database Column: oversized
Admin Area Field: [no longer used]
Page Location: N/A

Database Column: additional_handling_indicator
Admin Area Field: [no longer used]
Page Location: N/A

Database Column: orderdetailid_third_party
Admin Area Field: [no longer used]
Page Location: N/A

Database Column: orderdetailid_third_party_link
Admin Area Field: [no longer used]
Page Location: N/A

return to 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

Table Details

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

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

return to Contents

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

PageText

Admin Area URL: /admin/PageText.asp?Section=All
Admin Area click path
: Design > Page Text > List All Records
Alternative click path
: N/A
Available for export
: yes
Available for import
: yes

Table Details

Database Column: id *
Admin Area Field: ID

Database Column: text
Admin Area Field: PageText

return to 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

Table Details

Database Column: pay_id *
Admin Area Field: N/A

Database Column: pay_paymentmethodid
Admin Area Field: [ID value of payment method (/admin/TableViewer.asp?table=paymentmethods)

Admin Area Field: pay_transid
Admin Area Field: TransID

Admin Area Field: pay_authcode
Admin Area Field: AuthCode

Database Column: pay_avs_response
Admin Area Field: AVS

Database Column: pay_cvv2_response
Admin Area Field: CVV2

Database Column: pay_result
Admin Area Field: Payment Type

Database Column: pay_amount
Admin Area Field: Payment Amount

Database Column: pay_orderid
Admin Area Field: [Order ID value of order]

Database Column: pay_authdate
Admin Area Field: Payment Date

Database Column: pay_details
Admin Area Field: Paid Via

Database Column: deleted
Admin Area Field: N/A

Database Column: pay_exclude_from_total_due
Admin Area Field: N/A

Database Column: pay_parent_transid
Admin Area Field: N/A

Database Column: third_party_field1
Admin Area Field: N/A

Database Column: pciaas_recurringtransaction
Admin Area Field: N/A

Database Column: pciaas_transactionid
Admin Area Field: N/A

return to 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

Table Details

Database Column: poi_id *
Admin Area Field: ID

Database Column: po_num
Admin Area Field: PO Num

Database Column: poi_productcode
Admin Area Field: Product Code

Database Column: poi_vendor_partno
Admin Area Field: Vendor Part #

Database Column: poi_productname
Admin Area Field: Product Name

Database Column: poi_quantity
Admin Area Field: Quantity

Database Column: poi_vendorprice
Admin Area Field: Vendor Price Ea.

Database Column: lastmodified
Admin Area Field: Last Modified

Database Column: lastmodby
Admin Area Field: Last Mod By

Database Column: poi_qtyreceived
Admin Area Field: Qty Received

Database Column: poi_shippingcost
Admin Area Field: Shipping Cost Ea.

Database Column: poi_orderdetailid
Admin Area Field: Order Detail ID

Database Column: poi_options
Admin Area Field: Product Options

return to 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

Table Details

Database Column: po_num *
Admin Area Field: PO Num
Wizard Field: N/A

Database Column: po_date
Admin Area Field: PO Date
Wizard Field: Date Created:

Database Column: vendor_id
Admin Area Field: Vendor ID
Wizard Field: N/A

Database Column: vendor_title
Admin Area Field: Vendor Title
Wizard Field: Vendor Title:

Database Column: vendor_address
Admin Area Field: Vendor Address
Wizard Field: From / Vendor:

Database Column: vendor_po_sendvia
Admin Area Field: Vendor PO Send Via
Wizard Field: Send Via:

Database Column: vendor_po_template
Admin Area Field: Vendor PO Template
Wizard Field: Build PO using template:

Database Column: vendor_emailaddress
Admin Area Field: Vendor Email Address
Wizard Field: Email Address:

Database Column: vendor_email_subject
Admin Area Field: Vendor Email Subject
Wizard Field: Subject: (if sending via e-mail)

Database Column: vendor_faxnumber
Admin Area Field: Vendor Fax Number
Wizard Field: Fax Number:

Database Column: vendor_po_shipto
Admin Area Field: Vendor PO Ship To
Wizard Field: Ship To:

Database Column: vendor_po_shipvia
Admin Area Field: Vendor PO Ship Via
Wizard Field: Ship Via:

Database Column: rvendor_po_terms
Admin Area Field: Vendor PO Terms
Wizard Field: Terms:

Database Column: vendor_po_duedate
Admin Area Field: Vendor PO Due Date
Wizard Field: Due Date:

Database Column: vendor_po_fob
Admin Area Field: Vendor PO FOB
Wizard Field: FOB:

Database Column: vendor_po_notes
Admin Area Field: Vendor PO Notes
Wizard Field: Notes:

Database Column: vendor_po_signedby
Admin Area Field: Vendor PO Signed By
Wizard Field: Signed By:

Database Column: po_shippingcost
Admin Area Field: PO Shipping Cost
Wizard Field: Shipping Cost:

Database Column: po_status
Admin Area Field: PO Status
Wizard Field: N/A

Database Column: lastmodified
Admin Area Field: N/A
Wizard Field: N/A

Database Column: customer_orderid
Admin Area Field: Customer Order ID
Wizard Field: Customer OrderID:

Database Column: lastmodby
Admin Area Field: N/A
Wizard Field: N/A

Database Column: po_vendor_invoice_num
Admin Area Field: [no longer used]
Wizard Field: N/A

Database Column: po_vendor_invoice_date
Admin Area Field: [no longer used]
Wizard Field: N/A

Database Column: vendor_contacts
Admin Area Field: Vendor Contacts
Wizard Field: N/A

return to 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

Table Details

Database Column: pkey_id *
Admin Area Field: ID

Database Column: pkey_keytype
Admin Area Field: PKey KeyType

Database Column: pkey_allowreuse
Admin Area Field: PKey AllowReuse

Database Column: pkey_used
Admin Area Field: PKey Used

Database Column: pkey_dateadded
Admin Area Field: PKey DateAdded

Database Column: pkey_email_template
Admin Area Field: PKey Email Template

Database Column: pkey_email_subject
Admin Area Field: PKey Email Subject

Database Column: lastmodified
Admin Area Field: Last Modified

Database Column: pkey_originalorderid
Admin Area Field: PKey Original Order ID

Database Column: pkey_originalorderdetailid
Admin Area Field: PKey Original Order Detail ID

Database Column: lastmodby
Admin Area Field: Last Mod By

Database Column: pkey_email_body
Admin Area Field: PKey Email Body

return to 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

Table Details

Database Column: productcode *
Admin Area Field: Code
Page Location: Basic Info

Database Column: vendor_partno
Admin Area Field: Vendor Part #
Page Location: Advanced Info > Vendors

Database Column: productname
Admin Area Field: Name
Page Location: Basic Info

Database Column: displaybegindate
Admin Area Field: Display Begin Date
Page Location: Advanced Info > Product Display

Database Column: displayenddate
Admin Area Field: Display End Date
Page Location: Advanced Info > Product Display

Database Column: hideproduct
Admin Area Field: Hide Product
Page Location: Advanced Info > Product Display

Database Column: stockstatus
Admin Area Field: Stock Status
Page Location: Advanced Info > Stock

Database Column: lastmodified
Admin Area Field: "Modified:"
Page Location: [footer]

Database Column: options_cloned_from
Admin Area Field: Use Same Options As ProductCode
Page Location: Advanced Info > Misc

Database Column: photos_cloned_from
Admin Area Field: Use Same Photos As ProductCode
Page Location: Advanced Info > Misc

Database Column: share_stockstatus_with
Admin Area Field: Link Stock Status with Product Code
Page Location: Advanced Info > Stock

Database Column: lastmodby
Admin Area Field: "by"
Page Location: [footer]

Database Column: ischildofproductcode
Admin Area Field: Parent Product Code
Page Location: Advanced Info > Misc

Database Column: ischildofproductcode_productid
Admin Area Field: [no longer used]
Page Location: N/A

Database Column: options_cloned_from_productid
Admin Area Field: [no longer used]
Page Location: N/A

Database Column: photos_cloned_from_productid
Admin Area Field: [no longer used]
Page Location: N/A

Database Column: share_stockstatus_with_productid
Admin Area Field: [no longer used]
Page Location: N/A

Database Column: productpopularity
Admin Area Field: Product Popularity
Page Location: Advanced Info > Misc

Database Column: homepage_section
Admin Area Field: Feature Product on the Homepage
Page Location: Advanced Info > Product Display

Database Column: autodropship
Admin Area Field: Auto Drop Ship
Page Location: Advanced Info > Vendors

Database Column: donotallowbackorders
Admin Area Field: Do Not Allow Backorders
Page Location: Advanced Info > Stock

Database Column: warehouselocation
Admin Area Field: Warehouse Location
Page Location: Advanced Info > Shipping

Database Column: warehouseaisle
Admin Area Field: Aisle
Page Location: Advanced Info > Shipping

Database Column: warehousebin
Admin Area Field: Bin
Page Location: Advanced Info > Shipping

Database Column: warehousecustom
Admin Area Field: Custom
Page Location: Advanced Info > Shipping

Database Column: upc_code
Admin Area Field: UPC Code
Page Location: Advanced Info > Vendors

Database Column: productkeywords
Admin Area Field: Additional Product Keyword(s)
Page Location: Advanced Info > Misc

Database Column: productnameshort
Admin Area Field: Product URL Text
Page Location: Advanced Info > Search Engine Optimization

Database Column: productweight
Admin Area Field: Weight
Page Location: Basic Info

Database Column: freeshippingitem
Admin Area Field: Free Shipping Item
Page Location: Advanced Info > Shipping

Database Column: minqty
Admin Area Field: Min. Order Quantity
Page Location: Advanced Info > Misc

Database Column: maxqty
Admin Area Field: Max Qty
Page Location: Advanced Info > Misc

Database Column: recurringstartprice
Admin Area Field: Promotional Starting Price
Page Location: Advanced Info > Recurring Pricing

Database Column: recurringstartduration
Admin Area Field: Starting Price Duration (in Months)
Page Location: Advanced Info > Recurring Pricing

Database Column: recurringprice
Admin Area Field: Recurring Price
Page Location: Advanced Info > Recurring Pricing

Database Column: recurringhowoften
Admin Area Field: Recurring Frequency (in Months)
Page Location: Advanced Info > Recurring Pricing

Database Column: recurringduration
Admin Area Field: Recurring Duration (months)
Page Location: Advanced Info > Recurring Pricing

Database Column: allowpriceedit
Admin Area Field: Allow Price Edit
Page Location: Advanced Info > Misc

Database Column: productprice
Admin Area Field: Price
Page Location: Basic Info

Database Column: listprice
Admin Area Field: List Price
Page Location: Advanced Info > Pricing

Database Column: saleprice
Admin Area Field: Sale Price
Page Location: Advanced Info > Pricing

Database Column: taxableproduct
Admin Area Field: Taxable Product
Page Location: Advanced Info > Pricing

Database Column: selectedoptionids
Admin Area Field: Set Default Option
Page Location: Advanced Info > Misc

Database Column: giftwrapcost
Admin Area Field: Gift Wrap Cost
Page Location: Advanced Info > Pricing

Database Column: downloadfile
Admin Area Field: Download Filename
Page Location: Advanced Info > Misc

Database Column: availability
Admin Area Field: Availability
Page Location: Advanced Info > Shipping

Database Column: metatag_title
Admin Area Field: Meta Tag Title
Page Location: Advanced Info > Search Engine Optimization

Database Column: metatag_description
Admin Area Field: Meta Tag Description
Page Location: Advanced Info > Search Engine Optimization

Database Column: discountedprice_level1
Admin Area Field: Discounted Price Level 1
Page Location: Advanced Info > Pricing Levels

Database Column: discountedprice_level2
Admin Area Field: Discounted Price Level 2
Page Location: Advanced Info > Pricing Levels

Database Column: discountedprice_level3
Admin Area Field: Discounted Price Level 3
Page Location: Advanced Info > Pricing Levels

Database Column: discountedprice_level4
Admin Area Field: Discounted Price Level 4
Page Location: Advanced Info > Pricing Levels

Database Column: discountedprice_level5
Admin Area Field: Discounted Price Level 5
Page Location: Advanced Info > Pricing Levels

Database Column: photo_subtext
Admin Area Field: Photo Caption Text
Page Location: Advanced Info > Product Descriptions

Database Column: photo_alttext
Admin Area Field: Photo Alt Text
Page Location: Advanced Info > Search Engine Optimization

Database Column: discountedrecurringprice_level1
Admin Area Field: Recurring Price Level 1
Page Location: Advanced Info > Pricing Levels

Database Column: discountedrecurringprice_level2
Admin Area Field: Recurring Price Level 2
Page Location: Advanced Info > Pricing Levels

Database Column: discountedrecurringprice_level3
Admin Area Field: Recurring Price Level 3
Page Location: Advanced Info > Pricing Levels

Database Column: discountedrecurringprice_level4
Admin Area Field: Recurring Price Level 4
Page Location: Advanced Info > Pricing Levels

Database Column: discountedrecurringprice_level5
Admin Area Field: Recurring Price Level 5
Page Location: Advanced Info > Pricing Levels

Database Column: fixed_shippingcost
Admin Area Field: Fixed Shipping Cost
Page Location: Advanced Info > Shipping

Database Column: fixed_shippingcost_outside_localregion
Admin Area Field: Fixed Shipping Cost (Outside Local Region)
Page Location: Advanced Info > Shipping

Database Column: uses_product_keytypes
Admin Area Field: Uses Product Key Type(s)
Page Location: Advanced Info > Misc

Database Column: price_subtext
Admin Area Field: Price Sub Text
Page Location: Advanced Info > Product Display

Database Column: price_subtext_short
Admin Area Field: List Price Description Text
Page Location: Advanced Info > Product Display

Database Column: listprice_name
Admin Area Field: List Price Name
Page Location: Advanced Info > Product Display

Database Column: productprice_name
Admin Area Field: Product Price Name
Page Location: Advanced Info > Product Display

Database Column: saleprice_name
Admin Area Field: Sale Price Name
Page Location: Advanced Info > Product Display

Database Column: hide_yousave
Admin Area Field: Hide "You Save" Feature
Page Location: Advanced Info > Product Display

Database Column: hide_freeaccessories
Admin Area Field: Hide Free Accessories
Page Location: Advanced Info > Product Display

Database Column: setupcost
Admin Area Field: Setup Cost
Page Location: Advanced Info > Pricing

Database Column: setupcost_name
Admin Area Field: Setup Cost Name
Page Location: Advanced Info > Product Display

Database Column: discountedsetupcost_level1
Admin Area Field: Discounted Setup Cost Level 1
Page Location: Advanced Info > Pricing Levels

Database Column: discountedsetupcost_level2
Admin Area Field: Discounted Setup Cost Level 2
Page Location: Advanced Info > Pricing Levels

Database Column: discountedsetupcost_level3
Admin Area Field: Discounted Setup Cost Level 3
Page Location: Advanced Info > Pricing Levels

Database Column: discountedsetupcost_level4
Admin Area Field: Discounted Setup Cost Level 4
Page Location: Advanced Info > Pricing Levels

Database Column: discountedsetupcost_level5
Admin Area Field: Discounted Setup Cost Level 5
Page Location: Advanced Info > Pricing Levels

Database Column: setupcost_title
Admin Area Field: Setup Cost Title
Page Location: Advanced Info > Pricing

Database Column: stockreorderqty
Admin Area Field: Stock Re-Order Qty
Page Location: Advanced Info > Stock

Database Column: warehouses
Admin Area Field: Warehouse ID(s)
Page Location: Advanced Info > Shipping

Database Column: affiliate_commissionable_value
Admin Area Field: Affiliate Commissionable Value
Page Location: Advanced Info > Misc

Database Column: addtocartbtn_replacement_text
Admin Area Field: "Add to Cart" Button Replacement Text
Page Location: Advanced Info > Product Display

Database Column: book_isbn
Admin Area Field: Book ISBN
Page Location: Advanced Info > Vendors

Database Column: productcondition
Admin Area Field: Product Condition
Page Location: Advanced Info > 3rd Party Integrations

Database Column: estship_ground
Admin Area Field: Estimated Shipping - Ground
Page Location: Advanced Info > 3rd Party Integrations

Database Column: estship_2ndday
Admin Area Field: Estimated Shipping - 2nd Day
Page Location: Advanced Info > 3rd Party Integrations

Database Column: estship_overnight
Admin Area Field: Estimated Shipping - Overnight
Page Location: Advanced Info > 3rd Party Integrations

Database Column: customfield1
Admin Area Field: Custom Field 1
Page Location: Advanced Info > Custom Fields

Database Column: customfield2
Admin Area Field: Custom Field 2
Page Location: Advanced Info > Custom Fields

Database Column: customfield3
Admin Area Field: Custom Field 3
Page Location: Advanced Info > Custom Fields

Database Column: customfield4
Admin Area Field: Custom Field 4
Page Location: Advanced Info > Custom Fields

Database Column: customfield5
Admin Area Field: Custom Field 5
Page Location: Advanced Info > Custom Fields

Database Column: shoppingdotcom_category
Admin Area Field: Shopping.com Category
Page Location: Advanced Info > 3rd Party Integrations

Database Column: yahoo_category
Admin Area Field: Yahoo! Shopping Category
Page Location: Advanced Info > 3rd Party Integrations

Database Column: yahoo_medium
Admin Area Field: Yahoo! Shopping Medium
Page Location: Advanced Info > 3rd Party Integrations

Database Column: productmanufacturer
Admin Area Field: Manufacturer
Page Location: Advanced Info > Misc

Database Column: hide_when_outofstock
Admin Area Field: Hide When Out Of Stock
Page Location: Advanced Info > Product Display

Database Column: stocklowqtyalarm
Admin Area Field: Stock Low Qty Alarm
Page Location: Advanced Info > Stock

Database Column: addtopo_now
Admin Area Field: Add To PO Now
Page Location: Advanced Info > Vendors

Database Column: lastpo_qty
Admin Area Field: Last PO Qty
Page Location: Advanced Info > Vendors

Database Column: lastpo_date
Admin Area Field: Last PO Date
Page Location: Advanced Info > Vendors

Database Column: howtogetsaleprice
Admin Area Field: Require Action for Sale Price
Page Location: Advanced Info > Pricing

Database Column: inv_verify_qtyonhand
Admin Area Field: Verify Qty On-Hand (Internal Use)
Page Location: Advanced Info > Stock

Database Column: inv_lastverified
Admin Area Field: Qty Last Verified
Page Location: Advanced Info > Stock

Database Column: enablemultichildaddtocart
Admin Area Field: Enable Multi Child Add To Cart
Page Location: Advanced Info > Product Display

Database Column: vendor_price
Admin Area Field: Vendor Price
Page Location: Advanced Info > Vendors

Database Column: enableoptions_inventorycontrol
Admin Area Field: Enable Options Inventory Control Grid
Page Location: Basic Info

Database Column: photourl_small
Admin Area Field: Photo URL Small
Page Location: Advanced Info > Misc

Database Column: photourl_large
Admin Area Field: Photo URL Large
Page Location: Advanced Info > Misc

Database Column: private_section_customers_only
Admin Area Field: Private Section Customers Only
Page Location: Advanced Info > Product Display

Database Column: quickbooks_item_accnt
Admin Area Field: Quickbooks Item Accnt
Page Location: Advanced Info > 3rd Party Integrations

Database Column: quickbooks_item_assetaccnt
Admin Area Field: Quickbooks Item Asset Accnt
Page Location: Advanced Info > 3rd Party Integrations

Database Column: quickbooks_item_cogsaccnt
Admin Area Field: Quickbooks Item COGS Accnt
Page Location: Advanced Info > 3rd Party Integrations

Database Column: vat_percentage
Admin Area Field: VAT Percentage
Page Location: Advanced Info > Pricing

Database Column: recurring_pricing_text
Admin Area Field: Recurring Pricing Text
Page Location: Advanced Info > Recurring Pricing

Database Column: google_product_type
Admin Area Field: Google Product Type
Page Location: Advanced Info > 3rd Party Integrations

Database Column: length
Admin Area Field: Length (in)
Page Location: Advanced Info > Shipping

Database Column: width
Admin Area Field: Width (in)
Page Location: Advanced Info > Shipping

Database Column: height
Admin Area Field: Height (in)
Page Location: Advanced Info > Shipping

Database Column: ships_by_itself
Admin Area Field: Ships By Itself
Page Location: Advanced Info > Shipping

Database Column: package_type
Admin Area Field: Package Type
Page Location: Advanced Info > Shipping

Database Column: oversized
Admin Area Field: UPS Large Package
Page Location: Advanced Info > Shipping

Database Column: additional_handling_indicator
Admin Area Field: UPS Additional Handling Indicator
Page Location: Advanced Info > Shipping

Database Column: reward_points_given_for_purchase
Admin Area Field: Reward Points Given For Purchase
Page Location: Advanced Info > Misc

Database Column: productdescriptionshort
Admin Area Field: Product Description Short
Page Location: Advanced Info > Product Descriptions

Database Column: productdescription
Admin Area Field: Description
Page Location: Basic Info

Database Column: productfeatures
Admin Area Field: Features
Page Location: Advanced Info > Product Descriptions

Database Column: techspecs
Admin Area Field: Technical Specs
Page Location: Advanced Info > Product Descriptions

Database Column: extinfo
Admin Area Field: Extended Information
Page Location: Advanced Info > Product Descriptions

Database Column: orderfinished_note
Admin Area Field: Order Finished Note
Page Location: Advanced Info > Product Display

Database Column: metatag_keywords
Admin Area Field: Meta Tag Keywords
Page Location: Advanced Info > Search Engine Optimization

Database Column: productdescription_abovepricing
Admin Area Field: Product Description Above Pricing
Page Location: Advanced Info > Product Descriptions

Database Column: custom_metatags_override
Admin Area Field: Meta Tags Override (Override meta information with custom HTML)
Page Location: Advanced Info > Search Engine Optimization

Admin Area Field: Database Column: numproductssharingstock
Admin Area Field: [count of products using this Code value in Link Stock Status with Product Code field - cannot be imported]
Page Location: N/A

Database Column: ean
Admin Area Field: EAN Code
Page Location: Advanced Info > Vendors

Database Column: photoseed
Admin Area Field: [automatically-generated query string that forces a file update - cannot be imported]
Page Location: N/A

Database Column: google_product_category
Admin Area Field: Google Product Type
Page Location: Advanced Info > 3rd Party Integrations

Database Column: google_size
Admin Area Field: Google Size
Page Location: Advanced Info > 3rd Party Integrations

Database Column: google_color
Admin Area Field: Google Color
Page Location: Advanced Info > 3rd Party Integrations

Database Column: google_gender
Admin Area Field: Google Gender
Page Location: Advanced Info > 3rd Party Integrations

Database Column: google_age_group
Admin Area Field: Google Age Group
Page Location: Advanced Info > 3rd Party Integrations

Database Column: google_availability
Admin Area Field: Google Availability
Page Location: Advanced Info > 3rd Party Integrations

Database Column: google_pattern
Admin Area Field: Google Pattern
Page Location: Advanced Info > 3rd Party Integrations

Database Column: google_material
Admin Area Field: Google Material
Page Location: Advanced Info > 3rd Party Integrations

Database Column: estdaystoship
Admin Area Field: Estimated Days to Ship
Page Location: Advanced Info > Shipping

Database Column: google_unique_identifier_exists
Admin Area Field: Google Unique Product
Page Location: Advanced Info > 3rd Party Integrations

Database Column: google_adult_product
Admin Area Field: Google Adult Product
Page Location: Advanced Info > 3rd Party Integrations

Database Column: google_sizetype
Admin Area Field: Google Size Type
Page Location: Advanced Info > 3rd Party Integrations

Database Column: google_sizesystem
Admin Area Field: Google Size System
Page Location: Advanced Info > 3rd Party Integrations

Database Column: categoryids
Admin Area Field: Categories
Page Location: Basic Info

Database Column: optionids
Admin Area Field: Options
Page Location: Basic Info

Database Column: accessories
Admin Area Field: Add Accessories
Page Location: Advanced Info > Misc

Database Column: freeaccessories
Admin Area Field: Include Free Accessories
Page Location: Advanced Info > Misc

Database Column: producturl
Admin Area Field: [the URL of the storefront product page - cannot be imported]
Page Location: N/A

Database Column: photourl
Admin Area Field: [the URL of the main storefront product photo - cannot be imported]
Page Location: N/A

Database Column: categorytree
Admin Area Field: [the categories and subcategories the product is assigned to - cannot be imported]
Page Location: N/A

return to 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

Table Details

Database Table: id *
Admin Area Field: ID

Database Table: originalorderid
Admin Area Field: Original Order ID

Database Table: startdate
Admin Area Field: Start Date

Database Table: enddate
Admin Area Field: End Date

Database Table: recurringprice
Admin Area Field: Recurring Price

Database Table: howoften
Admin Area Field: How Often

Database Table: lastpaid
Admin Area Field: Last Paid

Database Table: active
Admin Area Field: Active

Database Table: lastmodified
Admin Area Field: Last Modified

Database Table: originalorderdetailid
Admin Area Field: Original Order ID

Database Table: recurring_note
Admin Area Field: Recurring Note

Database Table: delay_charge_until
Admin Area Field: Delay Charge Until

Database Table: isstartprice
Admin Area Field: N/A

Database Table: lastmodby
Admin Area Field: Last Mod By

return to 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

Table Details

Database Column: reviewid *
Admin Area Field: ID

Database Column: lastmodified
Admin Area Field: Last Modified

Database Column: productcode
Admin Area Field: Product Code

Database Column: reviewtitle
Admin Area Field: Review Title

Database Column: rate
Admin Area Field: Rate

Database Column: customerid
Admin Area Field: Customer ID

Database Column: yeshelpful
Admin Area Field: Yes Helpful

Database Column: nothelpful
Admin Area Field: Not Helpful

Database Column: name
Admin Area Field: Name

Database Column: location
Admin Area Field: Location

Database Column: active
Admin Area Field: Active

Database Column: lastmodby
Admin Area Field: Mod By

Database Column: reviewdescription
Admin Area Field: Review Description

return to 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

Table Details

Database Column: id *
Admin Area Field: N/A

Database Column: customerid
Admin Area Field: [ID value of the customer]

Database Column: reviewid
Admin Area Field: [ID value of the review]

Database Column: lastmodified
Admin Area Field: [Last Modified value of the review]

return to 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

Table Details

Database Column: rmai_id *
Admin Area Field: ID

Database Column: rma_number
Admin Area Field: RMA Number

Database Column: rmai_orderdetailid
Admin Area Field: RMAI Order Detail ID

Database Column: lastmodified
Admin Area Field: Last Modified

Database Column: lastmodby
Admin Area Field: Last Mod By

Database Column: rmai_quantity
Admin Area Field: Quantity Requested for Return

Database Column: rmai_qtyreceived_sellable
Admin Area Field: Qty Received: Sellable

Database Column: rmai_qtyreceived_damaged
Admin Area Field: Qty Received: Damaged

Database Column: rmai_lostvalue
Admin Area Field: Lost Value

Database Column: rmai_refundtype
Admin Area Field: [designation of whether the RMA is for a refund or an exchange]

Database Column: rmai_exchange_orderid
Admin Area Field: [the Order ID value of the exchange order]

return to 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

Table Details

Database Column: rma_number *
Admin Area Field: RMA Number

Database Column: rma_date_requested
Admin Area Field: Date Requested

Database Column: rma_orderid
Admin Area Field: Order ID

Database Column: rma_status
Admin Area Field: RMA Status

Database Column: lastmodified
Admin Area Field: Last Modified

Database Column: lastmodby
Admin Area Field: Last Mod By

Database Column: rma_deadline
Admin Area Field: RMA Deadline

Database Column: rma_notes
Admin Area Field: RMA Notes

return to 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

Table Details

Database Column: id
Admin Area Field: N/A

Database Column: searchterm
Admin Area Field: Search Term

Database Column: ipaddress
Admin Area Field: N/A

Database Column: lastmodified
Admin Area Field: Last Modified

return to 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

Table Details

Database Column: id_shippingmethods_flat
Admin Area Field: ID

Database Column: name
Admin Area Field: Name

Database Column: applyto_states
Admin Area Field: Apply To States

Database Column: cost_base_rate
Admin Area Field: Cost Base Rate

Database Column: cost_per_pound
Admin Area Field: Cost Per Pound

Database Column: lastmodified
Admin Area Field: Last Modified

Database Column: lastmodby
Admin Area Field: Last Mod By

return to 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

Table Details

Database Column: country_id
Admin Area Field: Country ID

Database Column: state_id
Admin Area Field: State ID

Database Column: state_name
Admin Area Field: State Name

Database Column: state_code
Admin Area Field: State Code

Database Column: state_islocalregion
Admin Area Field: State Is Local Region

Database Column: lastmodified
Admin Area Field: Last Modified

Database Column: lastmodby
Admin Area Field: Last Mod By

return to 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

Table Details

Database Column: id
Admin Area Field: Stock History

Database Column: previous_stock
Admin Area Field: Previous Stock

Database Column: new_stock
Admin Area Field: New Stock

Database Column: event
Admin Area Field: Event

Database Column: eventid
Admin Area Field: EventID

Database Column: lastmodified
Admin Area Field: Last Modified

Database Column: lastmodby
Admin Area Field: Last Mod By

return to 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

Table Details

Database Column: taxid *
Admin Area Field: ID
Page Location: Details
Wizard Field: N/A

Database Column: taxstateshort
Admin Area Field: Tax State SHORT
Page Location: Ship To Location
Wizard Field: Tax State Short

Database Column: taxstatelong
Admin Area Field: Tax State LONG
Page Location: Ship To Location
Wizard Field: Tax State Long

Database Column: taxcountry
Admin Area Field: Tax Country
Page Location: Ship To Location
Wizard Field: Region Country

Database Column: lastmodified
Admin Area Field: Last Modified
Page Location: Tax Rates (up to 3 separate taxes)
Wizard Field: N/A

Database Column: lastmodby
Admin Area Field: Last Mod By
Page Location: Tax Rates (up to 3 separate taxes)
Wizard Field: N/A

Database Column: tax1_title
Admin Area Field: Tax 1 Title
Page Location: Tax Rates (up to 3 separate taxes)
Wizard Field: Base Tax Title

Database Column: tax2_title
Admin Area Field: Tax 2 Title
Page Location: Tax Rates (up to 3 separate taxes)
Wizard Field: Second Tax Title

Database Column: tax3_title
Admin Area Field: Tax 3 Title
Page Location: Tax Rates (up to 3 separate taxes)
Wizard Field: Third Tax Title

Database Column: tax1_percent
Admin Area Field: Tax 1 Percent
Page Location: Tax Rates (up to 3 separate taxes)
Wizard Field: (Base Tax) Rate

Database Column: tax2_percent
Admin Area Field: Tax 2 Percent
Page Location: Tax Rates (up to 3 separate taxes)
Wizard Field: (Second Tax) Rate

Database Column: tax3_percent
Admin Area Field: Tax 3 Percent
Page Location: Tax Rates (up to 3 separate taxes)
Wizard Field: (Third Tax) Rate

Database Column: taxpostalcode
Admin Area Field: (optional) Tax Postal Code
Page Location: Ship To Location
Wizard Field: Region Postal Code

Database Column: taxdefault
Admin Area Field: Tax Default
Page Location: Details
Wizard Field: Default rate for VAT / GST rate?

Database Column: isvat
Admin Area Field: Is VAT
Page Location: Tax Rates (up to 3 separate taxes)
Wizard Field: Tax rate for VAT /GST ?

Database Column: tax2_includeprevious
Admin Area Field: Tax 2 Include Previous
Page Location: Tax Rates (up to 3 separate taxes)
Wizard Field: [drop-down menu of Second Tax Title & Rate]

Database Column: tax3_includeprevious
Admin Area Field: Tax 3 Include Previous
Page Location: Tax Rates (up to 3 separate taxes)
Wizard Field: [drop-down menu of Third Tax Title & Rate]

Database Column: tax1_ignorenotaxrules
Admin Area Field: Tax 1 Ignore No Tax Rules
Page Location: Tax Rates (up to 3 separate taxes)
Wizard Field: Apply to non-taxable items and customers [Base Tax Title & Rate]

Database Column: tax2_ignorenotaxrules
Admin Area Field: Tax 2 Ignore No Tax Rules
Page Location: Tax Rates (up to 3 separate taxes)
Wizard Field: Apply to non-taxable items and customers [Second Tax Title & Rate]

Database Column: tax3_ignorenotaxrules
Admin Area Field: Tax 3 Ignore No Tax Rules
Page Location: Tax Rates (up to 3 separate taxes)
Wizard Field: Apply to non-taxable items and customers [Third Tax Title & Rate]

return to 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

Table Details

Database Column: trackingnumber *
Admin Area Field: Tracking #
Page Location: Orders > Orders > # > Tracking

Database Column: gateway
Admin Area Field: Gateway
Page Location: Orders > Orders > # > Tracking

Database Column: shipdate
Admin Area Field: Ship Date
Page Location: Orders > Orders > # > Tracking

Database Column: orderid
Admin Area Field: Order
Page Location: Orders > Orders > #

Database Column: shipment_cost
Admin Area Field: Cost
Page Location: Orders > Orders > # > Tracking

Database Column: shippingmethodid
Admin Area Field: Shipping Method
Page Location: Orders > Orders > # > Tracking

Database Column: package
Admin Area Field: Shipping Method
Page Location: Orders > Orders > # > Tracking

Database Column: form
Admin Area Field: [no longer used]
Page Location: N/A

return to 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

Table Details

Database Column: vr_id *
Admin Area Field: ID
Wizard Field: N/A

Database Column: vendor_id
Admin Area Field: Vendor ID
Wizard Field: Vendor ID

Database Column: vr_productcode
Admin Area Field: VR Product Code
Wizard Field: N/A

Database Column: vr_minqty
Admin Area Field: VR Min Qty
Wizard Field: Min Qty

Database Column: vr_maxqty
Admin Area Field: VR MaxQty
Wizard Field: Max Qty

Database Column: vr_price
Admin Area Field: VR Price
Wizard Field: Price

Database Column: vr_partno
Admin Area Field: VR PartNo
Wizard Field: Vendor PartNo

Database Column: vr_deactivate_until
Admin Area Field: N/A
Wizard Field: Deactivate Until

Database Column: lastmodified
Admin Area Field: Last Modified
Wizard Field: N/A

Database Column: lastmodby
Admin Area Field: Last Modified
Wizard Field: N/A

return to 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

Table Details

Database Column: vendor_id *
Admin Area Field: ID

Database Column: vendor_title
Admin Area Field: Vendor Name

Database Column: vendor_address
Admin Area Field: Vendor Address

Database Column: vendor_po_sendvia
Admin Area Field: PO Send Via

Database Column: vendor_po_template
Admin Area Field: PO Template

Database Column: vendor_emailaddress
Admin Area Field: Vendor Email Address

Database Column: vendor_email_subject
Admin Area Field: Vendor Email Subject

Database Column: vendor_faxnumber
Admin Area Field: Vendor Fax Number

Database Column: vendor_po_shipto
Admin Area Field: Ship To

Database Column: vendor_po_shipvia
Admin Area Field: Ship Via

Database Column: vendor_po_terms
Admin Area Field: PO Terms

Database Column: vendor_po_duedate
Admin Area Field: PO Due Date

Database Column: vendor_po_fob
Admin Area Field: FOB Notes

Database Column: vendor_po_notes
Admin Area Field: PO Notes

Database Column: vendor_po_signedby
Admin Area Field: PO Signed By

Database Column: lastmodified
Admin Area Field: Last Modified

Database Column: lastmodby
Admin Area Field: Last Mod By

Database Column: allows_dropshipping
Admin Area Field: Allows Drop Shipping

Database Column: active
Admin Area Field: Active

Database Column: vendor_contacts
Admin Area Field: Additional Contacts

return to 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

Table Details

Database Column: id_warehouses
Admin Area Field: ID

Database Column: warehouse_name
Admin Area Field: Warehouse Name

Database Column: country
Admin Area Field: Country

Database Column: state
Admin Area Field: State or Province

Database Column: postalcode
Admin Area Field: Postal Code

Database Column: lastmodified
Admin Area Field: "Modified:"

Database Column: lastmodby
Admin Area Field: "by"

return to Contents

Did this answer your question?