Product Section Thumbnail and Product Price

[denspad]

Hi All,

Have just followed the Actinic advanced tutorial in order to provide Product Thumbnails linked to a detail page with more information and product price.

I set out the catalogue as described with the creation of a section for each product (which would act as a thumbnail) and each product within the section with the same name.

I do however have a problem, when the thumbnails are displayed in a 3x3 grid (another change I implemented) it would make sense if the visitor saw the price of the product before selecting >>More Detail to obtain more detailed information about the product, the price and the add to basket option. Is there a way of allowing the thumbnail section to also display a price as well as the product?. This would make sense to me as otherwise the customer has to click through to each product to find the price.

I hope this is simple. Ideally, the price the client enters into the catalogue should be used for this requirement as opposed to additional custom variables which could result in incorrectly keyed prices between fields.

Hope this makes sense. Any advice or help would be most appreciated.

Kind Regards,

Alan Wyatt-Jones.

[NormanRouxel]

Actinic doesn't know that you only intend to have one product per Section and has no way to use that single price on the parent page.

If your products have a simple price it may be possible to create a blank custom property for every Section and to use a very complex Access query on the ActinicCatalog.mdb database to populate that Custom Properties value with the price from the child sections sole product.

If you don't use the Section Description field it may be easier to use the Query to put the price there, rather than in a Custom Property. This one isn't too hard to do:-

I.E. for each line in the Product table with status N, get the Price and nParentSectionID. Then look in the CatalogSection table for a matching nSectionID and put the Price (converted from pennies and VAT added if appropriate) into sSectionDescription.

I'm no Access guru so I'll leave the actual coding of that query to someone else.