add a feild in to customer table

hi
i have create an sunglasses and glasses frame web site,
for that i need to add new field in to the database that is prescription field so that customer can add the prescription number and on base on that prescription we can make the frame so can you guide on this '

i really help in this i am dependend on you fr this

regards
gaurish

gaurishrane wrote:
Another way to do it is using a Product Attribute with custom text wher the customer can put the preecription number while adding the product to cart. Check http://admin-demo.nopcommerce.com/administration/ProductAttributeDetails.aspx?ProductAttributeID=11

thanks for reply

but i need to add more attribute then only presc riptin i need to add frame color, glasses color, glasses brand, etc
can it add all this attrbute in the product if yes then is it will be time consuming ....

d i need to add attribute to all product one one or can it be able to done in bulk..

reply plz

gaurishrane wrote:
You can have many attributes for each product. See example in demo store of Build your Own Computer in:
http://demo.nopcommerce.com/products/67-build-your-own-computer.aspx
and in admin in http://admin-demo.nopcommerce.com/administration/ProductVariantDetails.aspx?ProductVariantID=76 in the Product Variant Attributes tab

You can create a product with all the attributes you need (as a template) and then copy it as many times as you need and then jut make te necessary changes as you neee in each copy

thank about that

Can you explain how insert product in bulk.. with image i try importing my exmal file but i could not import image into it.
i also try to import direct to database but that also fail. i could not able to insert image in bulk

Plz help

Gaurish

Done at https://www.nopcommerce.com/boards/t/9428/bulk-product-insert-with-image.aspx