Extra product fields in template

RE: Extra product fields in template



> Wil said:
> I would be very interested to know how you did that with Merchant 4.

Using OpenXB and PPTemplates, here's an example:

%begin_if|Products.d.shipmsg|%
Normally delivered in %product|shipmsg|%

%end_if%

ShipMsg is a column I added to the Products table.

Robert

RE: Extra product fields in template



I would be very interested to know how you did that with Merchant 4.


Wil Hatfield
HyperConX Customer Care

HyperConX International - <A HREF ="http://www.hyperconx.com">http://www.hyperconx.com</A>
1.800.894.3613 - Toll Free in the US and Canada

Check out the all new Miva Pages:
<A HREF ="http://www.hyperconx.com/miva/">http://www.hyperconx.com/miva/</A>

Premium e-commerce hosting, 24/7 technical support, toll free
support lines for your convenience, great low cost packages to
choose from, Authorize.Net Direct retailer, need high-speed
connectivity well we have that too. Everything a business
needs to succeed. Host with the Pros and sell like one too!




-----Original Message-----
From: [email protected]
[mailto:[email protected]]On Behalf Of R. Bradley
Sent: Friday, May 06, 2005 2:33 PM
To: [email protected]
Subject: [m5u] RE: Extra product fields in template


Thanks, Bill. One problem in my approach is that I did not realize how to
add a custom product field via MM5; I had added it directly through ALTER
TABLE. In fact, I had looked for some way to add a custom product field
within MM5, but couldn't find it (and I couldn't find a mention in the
docs). After rechecking, I found the Custom Fields Utility that had to be
assigned to the store. After using that, your instructions worked fine.

BUT - this method is not desirable from my own twisted data normalization
goals. The Custom Fields are not stored in the product table, but rather a
pair of additional tables. This makes sense from the Miva point of view,
but not from a data normalization standpoint, and makes everything (from a
data management perspective) more difficult. Further, the Custom Fields are
all the same data type and length, something that is abhorrent to me (again,
though, I understand why Miva decided to do it that way).

So, even though you gave the "right" answer (and many thanks for the speedy
response), I still need to know: how can I display the field value for ANY
field within a given table (like I used to be able to do in MM4)?

Robert

> R. Bradley wrote:
> > Any idea how to make a non-standard Product (or any table, really)
> > display in the templates?
>
> Go to page 'prod'. Click the link for product display
> layout. If you do not see the checkboxes to assign the extra
> fields to the display, but rather see the code for the
> product display, scroll down and click the link for Point +
> Click. That will let you assign the custom product fields to
> the 'prod' page. Save that setting. Now if you go back to
> the advanced mode of the product display layout you will see
> the code generated for the new fields. Also, this is one of
> the gotchas in MM5.

RE: Extra product fields in template



Thanks, Bill. One problem in my approach is that I did not realize how =
to
add a custom product field via MM5; I had added it directly through =
ALTER
TABLE. In fact, I had looked for some way to add a custom product field
within MM5, but couldn't find it (and I couldn't find a mention in the
docs). After rechecking, I found the Custom Fields Utility that had to =
be
assigned to the store. After using that, your instructions worked fine.

BUT - this method is not desirable from my own twisted data =
normalization
goals. The Custom Fields are not stored in the product table, but =
rather a
pair of additional tables. This makes sense from the Miva point of =
view,
but not from a data normalization standpoint, and makes everything (from =
a
data management perspective) more difficult. Further, the Custom Fields =
are
all the same data type and length, something that is abhorrent to me =
(again,
though, I understand why Miva decided to do it that way).

So, even though you gave the "right" answer (and many thanks for the =
speedy
response), I still need to know: how can I display the field value for =
ANY
field within a given table (like I used to be able to do in MM4)?

Robert

> R. Bradley wrote:
> > Any idea how to make a non-standard Product (or any table, really)=20
> > display in the templates?
>=20
> Go to page 'prod'. Click the link for product display=20
> layout. If you do not see the checkboxes to assign the extra=20
> fields to the display, but rather see the code for the=20
> product display, scroll down and click the link for Point +=20
> Click. That will let you assign the custom product fields to=20
> the 'prod' page. Save that setting. Now if you go back to=20
> the advanced mode of the product display layout you will see=20
> the code generated for the new fields. Also, this is one of=20
> the gotchas in MM5.=20

Extra product fields in template



R. Bradley wrote:
>
> I'm clueless: I've found where the product display template is located (no
> easy feat in itself), but cannot figger out how to get an additional product
> field (a field I've added into the actual products table) to display. I've
> tried various combinations, but the &mvt:product:fieldname format seems to
> only work with the standard fields.
>
> Any idea how to make a non-standard Product (or any table, really) display
> in the templates?

Go to page 'prod'. Click the link for product display layout. If you
do not see the checkboxes to assign the extra fields to the display, but
rather see the code for the product display, scroll down and click the
link for Point + Click. That will let you assign the custom product
fields to the 'prod' page. Save that setting. Now if you go back to
the advanced mode of the product display layout you will see the code
generated for the new fields. Also, this is one of the gotchas in MM5.
If you had previously edited the 'prod' page template layout section, it
will have been overwritten with the new one which includes the new
fields. You'll need to copy those new fields to the clipboard, then
recall the previous template (great save your butt feature). Paste the
new field stuff into the previous template and save. You won't lose
anything.


--
Bill Weiland A2Z Emporium Plus <A HREF ="http://www.emporiumplus.com/store.mvc ">http://www.emporiumplus.com/store.mvc </A>
Modules for eCommerce. Mail Mgr, Coupon, PayPal, Froogle/Yahoo feeds
Rate This, Gift/Wish List, Wait List Mgr, EZ Batch, Shipping & more
Online Documentation <A HREF ="http://www.emporiumplus.com/docs">http://www.emporiumplus.com/docs</A>
Question <A HREF ="http://www.emporiumplus.com/mivamodule_wcw.mvc?Screen=SPTS ">http://www.emporiumplus.com/mivamodu...vc?Screen=SPTS </A>
|

------=_NextPart_000_01AD_01C55255.BC503CC0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

I'm clueless: I've found where the product display template is located =
(no
easy feat in itself), but cannot figger out how to get an additional =
product
field (a field I've added into the actual products table) to display. =
I've
tried various combinations, but the &mvt:product:fieldname format seems =
to
only work with the standard fields.

Any idea how to make a non-standard Product (or any table, really) =
display
in the templates?

------=_NextPart_000_01AD_01C55255.BC503CC0--