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
- Articles
- Back_In_Stock_Requests
- Categories
- Categories_Products_Link
- Customers
- Customers_Groups
- Discounts
- Discounts_ApplyTo
- ExchangeRates
- GiftCardDetails
- GiftCards
- IP_Address_Security_Rules
- KitLnks
- Kits
- OptionCategories
- Options
- OrderDetails
- Orders
- PageText
- Payment_Log
- PO_Items
- POs
- Product_Keys
- Products
- Recurring
- Reviews
- ReviewsHelpful
- RMA_Items
- RMAs
- SearchTerms
- ShippingMethods_Flat
- States_Provinces
- Stock_History
- Tax
- TrackingNumbers
- VendorRules
- Vendors
- Warehouses
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
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
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
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
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
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
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
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]
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
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
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
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
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
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
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
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
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
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]
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
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
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
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]
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
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"
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
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
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
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
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
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
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
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
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
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
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
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
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
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
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
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
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
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
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
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
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
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
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
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
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
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
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
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
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
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
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
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]
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
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]
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
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
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
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
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
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
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
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
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
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
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
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]
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
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
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
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
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
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
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
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"