Thread: Product Dimensions with Special Charectors

Hi,
i am wondering if we can enter the product dimensions with Special Characters like inch sign feet sign

10"x20"x4'

because all the product under a category are not in same measuring dimensions

some are in feets some or in inches some are in millimeters

so i am looking to make ti possible so that i can enter the dimensions in 10"x20"
10'x20"

10"x20mm

20'x30yrds

can any one tell me if i can do this.

thanks

Have you tried it? Dimensions is defined as nvarchar(100) so should take anything.

If you are having problems, what are they?

Are you passing Dimensions (Is Ship Separately = yes) to UPS, Fedex, etc for shipping quotes or you just need to display the info in the product page, as shown below?


Do you use Real-time or fixed shipping?

P.S The standard "Unit of Meansurement" of dimensions is in cm.

not using (Is Ship Separately = yes)

Dimensions is defined as ntext not nvarchar(100)
do you think it will work if i change it to nvarchar(100)

right now the problem is if i enter 10"x10"x10' in dimensions field it will accept first time.
if i edit the product info next time, in dimensions field instead of 10"x10"x10' it will appear as 10" x 10" x 10" and if we click on update,

on the customer side in product information page dimensions will be displayed as 10" x 10" x 10"

thats the problem i am facing.
do you think it will work if i change it to nvarchar(100)


thanks

ntext is OK, don't change anything in the DB except this:

Open EntityEditProductVariant.aspx.cs, go to LoadContent() method, and locate this line:

Code:

 txtDimensions.Text = Server.HtmlEncode(DB.RSField(rs, "Dimensions"));

...then change it to:

Code:

txtDimensions.Text = Server.HtmlDecode(DB.RSField(rs, "Dimensions"));

Let me know if that works.

This is working
thanks a lot for helping me with this