[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
Re: [ic] Upgrading production 4.6.5 to 4.8.1
Quoting Mike Heins (mheins@redhat.com):
> Quoting Mike Eheler (meheler@searchbc.com):
> > I have searched the archives of this list, and found one topic about
> > upgrading, but dealt with just default/demo catalogs.
> >
> > On our systems we have dozens of catalogs maintained by our users, and
> > we would like to provide the most seamless upgrade possible. Ideally we
> > want to completely replace our 4.6.5 server with 4.8.1, and as well
> > completely upgrade the administrative interface.
> >
> > I have done some test upgrades using very basic default installs of
> > 4.6.5's "construct" demo, and every time I did it, the store would work
> > fine, but the admin would be broken.. either the colours would only be
> > half changed, or in one test case (the one closest to an actual
> > production upgrade), all of the toolbars in the admin interface were
> > completely broken. Each bar simply had the word "line" and there were no
> > images.
> >
> > I have scoured the web for any kind of an upgrade doc from 4.6.5 to
> > 4.8.1, and have found nothing, other than a cryptic "Upgrade Guide" on
> > redhat's site, and the less-than-usefull UPGRADE file that comes with 4.8.1.
> >
> > Any help/experience notes/anything is greatly appreciated.
>
> 95% of the problems are in variable.txt and mv_metadata.asc; both of those
> might require some hand editing.
>
> The most important thing is to remove all of the old UI_* variable
> definitions (except maybe UI_TRAFFIC_STATS) from the variable.txt database
> and add the new ones.
>
> Also, you should make sure you get the new mv_metadata.asc
> file in place, though you will have to hand-edit the lines that have
> the __MVC_SOMESETTING__ things in them. You can make a blank foundation
> which has these, and figure it out from there.
I have attached to this email a sample variable.txt and mv_metadata.asc
where I have done this to port a stock 4.6.5 Construct to 4.8.1. It seems
to work pretty well.
The lines with __MVC_.*__ values I have left in with the source line
commented out, and the edited line below it.
--
Red Hat, Inc., 3005 Nichols Rd., Hamilton, OH 45013
phone +1.513.523.7621 <mheins@redhat.com>
Experience is what allows you to recognize a mistake the second
time you make it. -- unknown
code Variable pref_group
ADDRESS 123 Main St. Company
BAR_LINK_TEMPLATE <A HREF="$URL$" CLASS="barlink"><FONT COLOR="#FFFFFF">$ANCHOR$</FONT></A> Admin colors
CATALOG_STATIC No Static pages
CGI_URL /cgi-bin/construct Directories and Paths
CHECK_ACCEPTED 1 Payment
CITY Reston, VA 20190 Company
COD_ACCEPTED 0 Payment
COMPANY Construct Something Company
CONTRAST RED Template
CREDIT_CARDS_ACCEPTED visa mc discover amex Payment
DOCROOT /var/www/html Directories and Paths
EMAIL_INFO Company
EMAIL_SERVICE Company
ENCRYPTOR none Payment
FAX (703) 555-9999 Company
FFACE face="Verdana, Arial, Helvetica, sans-serif" Template
IMAGE_DIR /construct/images Directories and Paths
LOGGED_STATIC 1 Static pages
LOGO Template
MV_DEFAULT_SEARCHTYPE_DB Database
MYSQL Database
ORACLE Database
ORDER_ROUTES log main copy_user Order
ORDERS_TO Order
PGSQL Database
PHONE (703) 555-1212 Company
PO_ACCEPTED 1 Payment
POSTAL_ACCEPTED 0 Payment
SAMPLEHTML /var/www/html/construct Directories and Paths
SAMPLEURL Directories and Paths
SECURE_SERVER http://sam.heins.net Directories and Paths
SERVER_NAME sam.heins.net Directories and Paths
SMLOGO Template
SQLPASS Database
SQLUSER Database
TAXAREA VA UT OH Tax
TAXFIELD state Tax
TAXRATE VA=4.5, UT=6.25, OH=5.0 Tax
TAXSHIPPING Tax
TOLLFREE (888) 555-1212 Company
UI_TRAFFIC_STATS /home/mike/catalogs/construct/logs/usertrack Directories and Paths
UPS_COUNTRY_FIELD country Shipping
UPS_ORIGIN Shipping
UPS_POSTCODE_FIELD zip Shipping
code type width height field db name outboard options attribute label help lookup filter help_url pre_filter lookup_exclude prepend append display_filter
2ndDayAir 200 Air Shipping Rates 1
Ground 200 Ground Shipping Rates 1
NextDayAir 200 Air Shipping Rates 1
access 1
access::super select 0=No, 1=Yes
affiliate text 25 affiliate,name,url,active Affiliates Data
affiliate::affiliate text 12 Affiliate ID word
affiliate::join_date date Join date
affiliate::name text 50 Affiliate Name
affiliate::timeout text 8 Timeout delay (in seconds, 0 to disable)
affiliate::url text 70 URL Default URL to redirect to
area code
name
which_page
url
search
page
selector Category Groups/Placement
area::display_type select name=Banner Text or Name,url=URL only,icon=Icon and name, image=Image
#area::image imagedir __MVC_IMAGEDIR__/images
area::image imagedir /var/www/html/construct/images/images
area::link_template textarea 30 4 none=No link, external=External link (http://...), internal=Interchange page, simple=Simple search, complex=Complex search
area::link_type select none=No link, external=External link (http://...), internal=Interchange page, simple=Simple search, complex=Complex search
cat text code
name
page
selector
url Categories
cat::area multiple 5 area code
cat::display_type select name=Banner Text or Name,url=URL only,icon=Icon and name, image=Image
cat::link_template textarea 30 4 none=No link,
external=External link (http://...),
internal=Interchange page,
simple=Simple search,
complex=Complex search
cat::link_type select none=No link, external=External link (http://...), internal=Interchange page, simple=Simple search, complex=Complex search
cat::search textarea 50 4
country 200 International Shipping Settings
custview::userdb::dealer display =No,1=Yes Dealer
custview::userdb::email_copy display =No, 1=Yes Payment method
custview::userdb::fax_order display =Credit Card*, 1=Fax or Mail, 2=Purchase order, 3=COD Payment method
custview::userdb::mail_list display offer=Special Offers, newsletter=Newsletter, alert=Alerts and Recalls, upgrade=Upgrades null_to_space
dbconfig::mv_metadata::attribute move_combo 30 10 columns:: Spreadsheet columns Must have the key field (usually it is the first one) null_to_comma
dbconfig::mv_metadata::code hidden_text Database table
dbconfig::mv_metadata::db reverse_combo tables last_non_null
dbconfig::mv_metadata::display_filter select =Yes,
1=No Backup select If Yes, table should be checked by default in backup/download.
dbconfig::mv_metadata::field move_combo 20 10 columns:: List on select page Must have the key field (usually it is the first one) null_to_comma
dbconfig::mv_metadata::field move_combo 30 10 columns:: List on select page Must have the key field (usually it is the first one) null_to_comma
dbconfig::mv_metadata::filter multiple 5 filesafe=Safe for file name,
uc=Upper case,
nullselect=First non-null (combo box),
null_to_space=Translate null to space,
null_to_comma=Translate null to comma,
lc=Lower case,
digits_dot=Decimal number (not negative),
backslash=Remove backslashes,
namecase=Name case,
name=Turn LAST,FIRST into FIRST LAST,
digits=Digits only,
word=Word chars only (A-z0-9_),
unix=DOS to UNIX,
dos=UNIX to DOS,
mac=UNIX to MAC,
gate=Only allow if scratch set,
no_white=No whitespace,
strip=Strip leading/trailing whitespace,
sql=Escape single quotes (SQL),
text2html=Simple text to HTML,
urlencode=URL encode (%20, etc),
pagefile=Safe for Interchange page name,
entities=HTML entities (& -> &), date_change=MM/DD/YYYY to YYYYMMDD option_format
dbconfig::mv_metadata::height text 4 Select page rows Number of rows to display at selector page. digits
dbconfig::mv_metadata::help textarea 70 4 Help displays at top of page
dbconfig::mv_metadata::help_url text 70 4 Help URL links below help text
dbconfig::mv_metadata::lookup text 20
dbconfig::mv_metadata::name text 70 4 Description
dbconfig::mv_metadata::options move_combo 20 8 columns:: Fields to edit Recommended fields to display on editor screen, in order of
display. If a blank line is between them, a break line will
be put in.
dbconfig::mv_metadata::options move_combo 20 8 columns:: Fields to edit Recommended fields to display on editor screen, in order of display.
dbconfig::mv_metadata::outboard multiple 8 NONE,
Qty price;pricing:q5:rn=Qty price,
Options;options:o_enable:r=Options,
Up-sell;merchandising:upsell_to:r=Up-sell,
Cross-sell;merchandising:cross_sell:r=Cross-sell,
Promo;merchandising:featured:r=Promo,
Inventory;inventory:quantity:rn=Inventory Special display These are extra links for the item editor -- various merchandising, inventory, and pricing links. null_to_comma
dbconfig::mv_metadata::type select =No,
1=Yes Display with meta (spreadsheet) filesafe
dbconfig::mv_metadata::type select select=Select box, text=Text entry*,textarea=Textarea,combo=Combo Select, radio=Radio box, radio_nbsp=Radio (nbsp), checkbox=Check box, check_nbsp=Checkbox (nbsp), hidden_text=Hidden (show text), multiple=Multiple Select, imagedir=Image listing, date=Date selector,display=Text of option Widget type filesafe
dbconfig::mv_metadata::width text 4 digits
dbconfig::mv_metadata::width text 4 Default spreadsheet column width digits
ichelp::helptext textarea 72 15 Help Text
icmenu 1 12 50 code
mgroup
msort
next_line
page
name(30)
inactive
Interchange menus code
mgroup
msort
next_line
depends_on
page
name
inactive
icmenu::inactive yesno
inventory 25 sku,quantity sku
=Quantity info
quantity
stock_message
=Accounting info
account
cogs_account
inventory::account text 20 Sales account
inventory::cogs_account text 20 COGS Account
inventory::quantity text 8 On hand
inventory::sku text 16 SKU
inventory::stock_message select In stock,
Ships in 3-5 days,
Ships in 4-6 weeks,
Special order Out of stock message stock_message
inventory::stock_message select In stock, Ships in 3-5 days, Ships in 4-6 weeks, Special order
matrix::options::price text 12 Price digits_dot
matrix_options::options code
sku
=Option information
o_group
o_label
o_value
merchandising::banner_image text Banner image if appropriate
merchandising::banner_text text Banner text for use where appropriate.
merchandising::blurb_begin text Teaser catch line for feature display
merchandising::blurb_end text Closer end text for feature display
merchandising::cross_category select products =- none - Cross-sale category If there are no item-specific cross sells for an item, it will fall
back to a cross-category sale. Select a category for <b>this item</b>
to be cross-sold to. category
merchandising::cross_sell text 50 products Cross-sell SKUs <A HREF="admin/sku_selector?caller=item_cross&table=_UI_TABLE_&col=_UI_COLUMN_&item_id=_UI_KEY_&value=_UI_URL_VALUE_">select...</A>
merchandising::cross_sell text 50 products Cross-sell SKUs null_to_space <A HREF="admin/sku_selector?caller=item_cross&table=_UI_TABLE_&col=_UI_COLUMN_&item_id=_UI_KEY_&value=_UI_URL_VALUE_">select...</A>
merchandising::featured select =none,
specials=Specials,
new=New item,
expired=expired Promotions Selects where to feature the item for a promotion. option_format <A HREF="admin/add_meta_option?item_id=_UI_TABLE_::_UI_COLUMN_&ui_return_to=admin/item&ui_return_to=ui_return_table=products">add...</A>
merchandising::finish_date date End date
merchandising::sku text products sku
merchandising::start_date date Start date date_change
merchandising::timed_promotion select =No,
1=Yes Timed? <B>Yes</B> if the promotion is timed with the start and end dates.
merchandising::upsell_to text 50 products Up-sell SKUs <A HREF="admin/sku_selector?caller=item_up&table=_UI_TABLE_&col=_UI_COLUMN_&item_id=_UI_KEY_&value=_UI_URL_VALUE_">select...</A>
metaconfig::mv_metadata::append textarea 60 5 Append HTML <SMALL>HTML to be appended to the widget.
Will substitute in the macros _UI_TABLE_, _UI_COLUMN_,
_UI_KEY, and _UI_VALUE_, and will resolve relative links
with absolute links.</SMALL>
metaconfig::mv_metadata::attribute text 20 Column name Do not set this.
metaconfig::mv_metadata::code text 30 Table::Column Table::Column to be operated on.
metaconfig::mv_metadata::db combo tables Lookup Table Table for an external lookup. nullselect
metaconfig::mv_metadata::field move_combo 20 10 columns:: Field for lookup Can be two comma separated fields, in which case second is used as the label text. Both must be in the same table.
metaconfig::mv_metadata::filter move_combo 30 1 filters Filter(s) Filters which can transform or constrain your data. Some widgets
require filters.
metaconfig::mv_metadata::height text 4 Height SIZE for SELECT<BR>
ROWS for TEXTAREA<BR> digits
metaconfig::mv_metadata::help textarea 70 4 Help This help text. textarea_get textarea_put
metaconfig::mv_metadata::help_url text 70 4 Help URL A URL which will provide more help
metaconfig::mv_metadata::lookup text 20 Lookup select <SMALL>Whether lookup is performed to get options for a select type.
If nothing is in the <B>field</B>, then used as the name of the field to lookup
in. Use <B>Lookup Table</B> if you want to look up in a different table.</SMALL>
metaconfig::mv_metadata::lookup_exclude text 20 Lookup exclude <B>ADVANCED</B>: regular expression that excludes certain keys from the lookup.
metaconfig::mv_metadata::name text 20 Variable name Normally left empty, changes variable name to send in form.
metaconfig::mv_metadata::options textarea 20 8 Options Options for SELECT/COMBO types (if lookup, prepended). Entered in the
interchange option format:<P>
<blockquote>
value=label*</blockquote> option_format
metaconfig::mv_metadata::outboard text 30 Directory Select directory for image listing widget.
metaconfig::mv_metadata::prepend textarea 60 5 Prepend HTML <SMALL>HTML to be prepended to the widget.
Will substitute in the macros _UI_TABLE_, _UI_COLUMN_,
_UI_KEY, and _UI_VALUE_, and will resolve relative links
with absolute links.</SMALL>
metaconfig::mv_metadata::type select textarea=Textarea,
text=Text entry*,
select=Select box,
yesno=Yes/No (Yes=1),
noyes=No/Yes (No=1),
multiple=Multiple Select,
combo=Combo Select,
reverse_combo=Reverse Combo,
move_combo=Combo move,
display=Text of option,
hidden_text=Hidden (show text),
radio=Radio box,
radio_nbsp=Radio (nbsp),
checkbox=Checkbox,
check_nbsp=Checkbox (nbsp),
imagedir=Image listing,
imagehelper=Image upload,
date=Date selector,
value=Value,
option_format=Option formatter,
show=Show all options Widget type Select the basic display type for the field.
metaconfig::mv_metadata::type select textarea=Textarea,
text=Text entry*,
select=Select box,
multiple=Multiple Select,
combo=Combo Select,
reverse_combo=Reverse Combo,
move_combo=Combo move,
display=Text of option,
hidden_text=Hidden (show text),
radio=Radio box,
radio_nbsp=Radio (nbsp),
checkbox=Checkbox,
check_nbsp=Checkbox (nbsp),
imagedir=Image listing,
date=Date selector,
value=Value,
show=Show all options
Widget type Select the basic display type for the field.
metaconfig::mv_metadata::width text 4 Width SIZE for TEXT<BR>
COLS for TEXTAREA<BR>
Label limit for SELECT digits
modular::options text 20 code
o_master
sku
o_enable options Modular option view code
o_master
sku
o_group
phantom
o_default
o_enable
=Ordering information
description
price
differential
modular::options::differential text 12 Price offset Adjustment to option price when phantom. A positive or negative
number.
modular::options::o_default select =No,
1=Yes Default? Yes if the default selection for the group.
modular::options::o_enable select =No,
1=Yes Follow? Enable for next level
modular::options::o_group combo 5 options Option group Scanned to see if it applies (or doesn't apply) to this product. o_group nullselect
modular::options::o_master select options =none Master item Always included when the base SKU is equal to this. sku
modular::options::phantom select =No,
1=Yes Phantom? If yes, this item is just a placeholder for modular options.
modular::options::price text 12 Price Price of option
modular::options::sku text 20
modular_create::options code
o_master
sku
o_group
description(30)
price code
o_master
sku
o_group
phantom
o_default
=Attributes
price
description
modular_create::options::code text 20 code will be auto-assigned if left blank
modular_create::options::description text 30 3 Option description
modular_create::options::o_default select =No,
1=Yes Default? Whether a/the default selection for this group.
modular_create::options::o_enable select =No,
1=Yes Sub-items
modular_create::options::phantom select =No,
1=Yes Phantom? Whether a phantom for structuring
modular_create::options::price text 12 Price Price of this option.
modular_create::options::sku text 20 Unique SKU
mv_metadata 1
mv_metadata 200 code
type
options 1
mv_metadata::append textarea 60 5 Append HTML <SMALL>HTML to be appended to the widget.
Will substitute in the macros _UI_TABLE_, _UI_COLUMN_,
_UI_KEY, and _UI_VALUE_, and will resolve relative links
with absolute links.</SMALL>
mv_metadata::attribute text 20 Column name Do not set this.
mv_metadata::code text 30 Table::Column Table::Column to be operated on.
mv_metadata::db combo tables Lookup Table Table for an external lookup. nullselect
mv_metadata::field move_combo 20 10 columns:: Field for lookup Can be two comma separated fields, in which case second is used as the label text. Both must be in the same table.
mv_metadata::filter move_combo 30 1 filters Filter(s) Filters which can transform or constrain your data. Some widgets
require filters.
mv_metadata::height text 4 Height SIZE for SELECT<BR>
ROWS for TEXTAREA<BR> digits
mv_metadata::help textarea 70 4 Help This help text. textarea_get textarea_put
mv_metadata::help_url text 70 4 Help URL A URL which will provide more help
mv_metadata::lookup text 20 Lookup select <SMALL>Whether lookup is performed to get options for a select type.
If nothing is in the <B>field</B>, then used as the name of the field to lookup
in. Use <B>Lookup Table</B> if you want to look up in a different table.</SMALL>
mv_metadata::lookup_exclude text 20 Lookup exclude <B>ADVANCED</B>: regular expression that excludes certain keys from the lookup.
mv_metadata::name text 20 Variable name Normally left empty, changes variable name to send in form.
mv_metadata::options textarea 20 8 Options Options for SELECT/COMBO types (if lookup, prepended). Entered in the
interchange option format:<P>
<blockquote>
value=label*</blockquote> option_format
mv_metadata::outboard text 30 Directory Select directory for image listing widget.
mv_metadata::prepend textarea 60 5 Prepend HTML <SMALL>HTML to be prepended to the widget.
Will substitute in the macros _UI_TABLE_, _UI_COLUMN_,
_UI_KEY, and _UI_VALUE_, and will resolve relative links
with absolute links.</SMALL>
mv_metadata::type select textarea=Textarea,
text=Text entry*,
,
select=Select box,
multiple=Multiple Select,
combo=Combo Select,
reverse_combo=Reverse Combo,
move_combo=Combo move,
display=Text of option,
hidden_text=Hidden (show text),
radio=Radio box,
radio_nbsp=Radio (nbsp),
checkbox=Checkbox,
check_nbsp=Checkbox (nbsp),
imagedir=Image listing,
date=Date selector,
value=Value,
option_format=Option format,
show=Show all options Widget type Select the basic display type for the field.
mv_metadata::type select textarea=Textarea,
text=Text entry*,
select=Select box,
multiple=Multiple Select,
combo=Combo Select,
reverse_combo=Reverse Combo,
move_combo=Combo move,
display=Text of option,
hidden_text=Hidden (show text),
radio=Radio box,
radio_nbsp=Radio (nbsp),
checkbox=Checkbox,
check_nbsp=Checkbox (nbsp),
imagedir=Image listing,
date=Date selector,
value=Value,
show=Show all options
Widget type Select the basic display type for the field.
mv_metadata::width text 4 Width SIZE for TEXT<BR>
COLS for TEXTAREA<BR>
Label limit for SELECT digits
optadd::mv_metadata::options textarea 20 8 Options Options in the format:<P>
<blockquote>
value=label*</blockquote>
option_format
options code
sku
o_group
o_master
description(30)
price Product Options
options::code text 10
options::description textarea 50 5 Description For description in display
options::o_exclude textarea 35 5 Exclude Only for modular options. Lists the option groups to exclude
once the include has been done. Takes the form of a number of wildcard atoms.
options::o_group text 20 Option name Name of option variable, i.e. "size__MVC_FIELDMUNGE__"
options::o_height text 4
options::o_include textarea 35 5 Include Only for modular options. Lists the option groups to include
with your item. Takes the form of a number of wildcard atoms.
options::o_label text 40 Label Short name for option display
options::o_matrix select =Non-matrix,!=Matrix options Matrix options Matrix options allow you to maintain multiple option sets with
inventory on each combination.
options::o_modular select =Not modular,Modular options Modular options Modular options allow you to attach multiple SKUs to the same item,
possibly with attached options of their own. Very complex but you can do
most anything.
options::o_value option_format 20 5 Possible Values In Interchange option format:<PRE>
VALUE1=Label 1,
VALUE2=Label 2*
</PRE>(* = default selection) option_format
options::o_widget select textarea=Textarea,
text=Text entry,
select=Select box*,
multiple=Multiple Select,
combo=Combo Select,
reverse_combo=Reverse Combo,
move_combo=Combo move,
display=Text of option,
hidden_text=Hidden (show text),
radio=Radio box,
radio_nbsp=Radio (nbsp),
checkbox=Checkbox,
check_nbsp=Checkbox (nbsp),
imagedir=Image listing,
date=Date selector,
value=Value,
show=Show all options,
Widget type Select the basic display type for the field.
options::o_width text 4
options::price text 12 Price Price data, either option=N.NN or
a number, depending on matrix settings.
options::sku text 20 Associated item
options::volume text 10 Volume (if different, mostly for matrix/modular)
options::weight text 10 Weight (if different, mostly for matrix/modular)
optmaster::options::code text 15
optmaster::options::o_enable select =No,1=Yes Enable options Whether any options processing is done
optmaster::options::o_exclude textarea 20 5 Exclude
optmaster::options::o_include textarea 20 5 Include
optmaster::options::o_matrix select =Non-matrix,1=Matrix options Matrix?
optmaster::options::o_modular select =Not modular,1=Modular options Modular options?
optmaster::options::o_simple select =No,1=Yes Enable options Whether any options processing is done
order_returns::username text Username
order_view::orderline::status display pending=Pending, shipped=Shipped, backorder=Back ordered, credit=Waiting for credit check, canceled=Canceled nullselect
order_view::transactions::status display pending=Pending, shipped=Shipped, partial=Partially shipped, backorder=Back ordered, credit=Waiting for credit check, canceled=Canceled nullselect
orderline text code,sku,description,price, quantity,subtotal 1
orderline::status combo pending=Pending, shipped=Shipped, backorder=Back ordered, credit=Waiting for credit check, canceled=Canceled nullselect
pricing text Pricing Settings 2
pricing::price_group combo pricing Discount group price_group nullselect
pricing::q3 text
products text 50 sku
description(30)
prod_group
category
price(%.2f align=right) Product information Qty price;pricing:q5:rn,Options;options:o_enable:r,Promo;merchandising:featured:r,Inventory;inventory:quantity:rn sku
description
prod_group
category
=Pricing
price
wholesale
=Information/Images
image
thumb
comment
weight
gift_cert
nontaxable
products::artist text 30 Artist
products::category combo 20 1 products Category Enter in box for new category. category nullselect nullselect
products::color textarea 70 2
products::comment textarea 70 8 Long Description
products::comment__MVC_FIELDMUNGE__ textarea 70 8 Detailed Description
products::description text 60 Short Description
products::gift_cert select =No,1=Yes Gift certificate handling? Yes if price should appear to be quantity
#products::image imagehelper images/items Image __MVC_SAMPLEURL__ <A HREF="admin/upload_file?ui_image_preview=__MVC_IMAGEURL__/items/_UI_VALUE_&ui_upload_binary=1&ui_upload_backup=0&mv_arg=images/items/_UI_VALUE_&ui_start_dir=items&ui_return_to=admin/item_edit&ui_return_to=item_id=_UI_KEY_&ui_preload=_UI_TABLE_:_UI_COLUMN_">upload...</A>
products::image imagehelper images/items Image http://sam.heins.net/construct <A HREF="admin/upload_file?ui_image_preview=/construct/images/items/_UI_VALUE_&ui_upload_binary=1&ui_upload_backup=0&mv_arg=images/items/_UI_VALUE_&ui_start_dir=items&ui_return_to=admin/item_edit&ui_return_to=item_id=_UI_KEY_&ui_preload=_UI_TABLE_:_UI_COLUMN_">upload...</A>
products::nontaxable select =Yes, 1=No Taxable?
products::price text 12 Product Price digits_dot
products::prod_group combo 20 products Product Group prod_group nullselect
products::related multiple 5 sku products Related items space-separated SKUs
products::sale_price text 12 Sale Price
products::size textarea 70 2
products::sku text SKU
#products::thumb imagehelper 30 images/thumb Thumb nullselect __MVC_SAMPLEURL__ <A HREF="admin/upload_file?ui_image_preview=__MVC_IMAGEURL__/thumb/_UI_VALUE_&ui_upload_binary=1&ui_upload_backup=0&mv_arg=images/thumb/_UI_VALUE_&ui_start_dir=items&ui_return_to=admin/item_edit&ui_return_to=item_id=_UI_KEY_&ui_preload=_UI_TABLE_:_UI_COLUMN_">upload...</A>
products::thumb imagehelper 30 images/thumb Thumb nullselect http://sam.heins.net/construct/ <A HREF="admin/upload_file?ui_image_preview=/construct/images/thumb/_UI_VALUE_&ui_upload_binary=1&ui_upload_backup=0&mv_arg=images/thumb/_UI_VALUE_&ui_start_dir=items&ui_return_to=admin/item_edit&ui_return_to=item_id=_UI_KEY_&ui_preload=_UI_TABLE_:_UI_COLUMN_">upload...</A>
products::title text 30 Title namecase
products::weight text 4 Weight in pounds digits_dot
products::wholesale text 12 Dealer Price
shipping text description
state code
country
state
name
tax
tax_name State/Province Settings (tax, etc)
state::state text 4 word
transactions text 1
transactions::status combo pending=Pending, shipped=Shipped, partial=Partially shipped, backorder=Back ordered, credit=Waiting for credit check, canceled=Canceled nullselect
userdb text username,company,lname,fname Users
userdb::address1 text 40 Address
userdb::address2 text 40
userdb::address2 text 40
userdb::b_address1 text 40 Billing Address
userdb::b_address2 text 40
userdb::b_city text 40 Billing City
userdb::b_company text 30 Billing Company If different
userdb::b_country text 10 Billing Country
userdb::b_fname text 40 Billing First Name
userdb::b_lname text 40 Billing Last Name
userdb::b_phone text Billing Phone
userdb::b_state text 10 Billing State
userdb::b_zip text 10 Billing Postcode
userdb::city text 40 City
userdb::comment text Comments by user
userdb::company text 40 Company
userdb::country text 10 Country
userdb::dealer radio_nbsp =No,1=Yes Dealer
userdb::email text 40 Email Address
userdb::email_copy select =No, 1=Yes
userdb::fax_order select =Credit Card*, 1=Fax or Mail, 2=Purchase order, 3=COD Payment method
userdb::fax_order select =Credit Card, 1=Fax or Mail, 2=Purchase order, 3=COD Payment method
userdb::feedback textarea 70 8
userdb::fname text 30 First Name
userdb::lname text 30 Last Name
userdb::mail_list check_nbsp offer=Special Offers, newsletter=Newsletter, alert=Alerts and Recalls, upgrade=Upgrades null_to_space
userdb::mod_time text 20
userdb::phone_day text 30 Daytime Phone
userdb::phone_night text 30 Home Phone
userdb::price_level select =Retail,dealer=Dealer,distributor=Distributor Price level
userdb::state text 10 State
userdb::subject text Subject
userdb::username hidden_text 16 Username no_white
userdb::zip text 10 Postcode uc word
variable 1
variable::Variable::ADDRESS text Company Address
variable::Variable::CATALOG_STATIC select No, Yes Enabled for users? <b>Yes</b> will cause Interchange to generate static links where possible.<BR><BR>
<b>No</b> disables generation of static links for users; you can still send a search engine to the statically generated URL and it will spider the static links on the page.
variable::Variable::CGI_URL text CGI URL URL that calls Interchange, without the server name
variable::Variable::CHECK_ACCEPTED select 0=No, 1=Yes
variable::Variable::COD_ACCEPTED select 0=No, 1=Yes
variable::Variable::CREDIT_CARDS_ACCEPTED checkbox visa=Visa, mc=Mastercard, discover=Discover, amex=American Express null_to_space
variable::Variable::DOCROOT text Document root This is the directory where your HTML originates. It should match the DocumentRoot
of your HTTP server. http://www.apache.org/docs/mod/core.html#documentroot
variable::Variable::MULTIORDER select =No,1=Yes Whether users should by default have multipage order forms.
variable::Variable::MYSQL select 0=No, 1=Yes
variable::Variable::POSTAL_ACCEPTED select =No,
1=Yes Accept postal orders?
variable::Variable::PO_ACCEPTED select 0=No, 1=Yes
variable::Variable::SECURE_ENABLE yesno Enable Secure URL?
variable::Variable::STATIC_LOGGED select No, Yes Enabled for logged in users? <b>Yes</b> will cause Interchange to generate static links where possible, even when users are logged in.
variable::Variable::STYLE select foundation=Foundation Theme
variable::Variable::TAXFIELD select state=Simple state-based,
multi=State/Province and VAT Type of tax You must <b>apply changes</b> after changing this.
variable::Variable::UI_ITEM_EXPUNGE text 60 Item expunge tables The tables that should have the SKU removed when you DELETE ITEM from the items menu.
variable::Variable::UI_META_LINK select 0=No, 1=Yes Meta edit links Determines whether enabled by default. They can be turned on in Preferences.
variable::Variable::UI_SECURE yesno Determines whether to force UI into secure mode or not.
variable::code text Variable name
variable::pref_group combo 20 Preferences area pref_group nullselect
variable::pref_group text 20 Preferences area
variant::inventory::quantity text 8 On hand Inventory of this variant.
variant::options::code text 20 SKU
variant::options::description textarea 60 3 Variant description
variant::options::o_height text 4 Height of Widget Height of widget (if applicable)
variant::options::o_width text 4 Width of widget
variant::options::price text 12 Price Price of this variant.
variant::options::weight text 8 Weight Weight for this variant.
variant::options::wholesale text 12 Dealer price