[ic] Upgrading production 4.6.5 to 4.8.1

Mike Heins interchange-users@interchange.redhat.com
Wed Aug 22 17:26:01 2001


--bp/iNruPH9dso1Pn
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

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

--bp/iNruPH9dso1Pn
Content-Type: text/plain; charset=us-ascii
Content-Description: variable.txt
Content-Disposition: attachment; filename="variable.txt"

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

--bp/iNruPH9dso1Pn
Content-Type: text/plain; charset=us-ascii
Content-Description: mv_metadata.asc
Content-Disposition: attachment; filename="mv_metadata.asc"

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 (& -> &amp;), 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								&nbsp;&nbsp;<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					&nbsp;&nbsp;<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								&nbsp;&nbsp;<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:&lt;PRE>
  VALUE1=Label 1,
  VALUE2=Label 2*
&lt;/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								&nbsp;
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

--bp/iNruPH9dso1Pn--