Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 2 of 2

Thread: How to add common options to all products ?

  1. #1
    rtomer is offline Member
    Join Date
    Jan 2010
    Posts
    39

    Default How to add common options to all products ?

    Hello everyone,

    I need to set some options for product in my cart like size and color .

    Suppose for Size, options are S,M,L,XL
    and for color, options are White,Black

    and these option need to be set on each and every product of my cart.

    Now I want to know what would be the best / Optimal way to do this or I have to add these options for more than 3000 products already in cart manually from admin panel

  2. #2
    esedirect is offline Senior Member
    Join Date
    Feb 2010
    Location
    Norfolk, UK
    Posts
    343

    Default

    Presuming you mean 'store' instead of 'cart', you can do it through SQL

    Code:
    UPDATE [ProductVariant]
    SET [Colors] = 'White,Black',
    Sizes = 'S,M,L,XL'
    I suggest you do this on a test system first, to ensure it gives the correct, expected results.
    http://www.esedirect.co.uk
    --------------------------------------------------------------------------
    Using MS 9.2.0.0 with the following customisations:

    Lightbox/Fancybox enlarged images;
    Auto-suggest searchbox;
    Extra product information shown only to our IP Address (such as supplier info, costs, etc.);
    Failed transactions emailed via trigger;
    Custom app to show basket contents when customer online;
    Orders pushed through to accounting systems.

    All the above without source!