Hi all,

I have a portal I'm building, and it uses the E-Commerce module. A requirement I have is to add a second Price field to a Product. This is because a product has two prices, a retail price, and a members price.
As per the docs, I've added a new field by going to:
Site Manager -> Development -> System Tables -> Ecommerce - SKU

And the field details are (among others):
Attribute Name: MemberPrice
Attribute type: Decimal Number (Double Precision)
Field Type: Textbox

When I edit a given product, and update the MemberPrice, I can see that in the database (COM_SKU table), the new Column MemberPrice is holding the value I inserted for that product.

Then in my Transformation, I access it as follows:

<%# EcommerceFunctions.GetFormatedPrice(Eval("MemberPrice")) %>

And for some reason, I'm getting back '0'. I've checked that it's grabbing details from the correct product, by altering other data, and it is in fact the correct Product.

I've also noticed that if I access it by:

<%# Eval("MemberPrice") %>

Then nothing comes back, which would indicate a NULL.

Has anyone dealt with this before?

Many thanks in advance!