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: Swatch Images

  1. #1
    cmclellan is offline Junior Member
    Join Date
    Jul 2009
    Posts
    5

    Default Swatch Images

    I have manually created my swatch and swatch image and applied it to a single product through the admin site. The opportunity I have is that I want the same swatch and swatch image to be assigned to about 20,000 products. Anyone have any ideas how I might go about doing this in a quick and efficient manner. It would take me weeks to seek out each product in via the admin site and add these.

    Thanks,

    Mac

  2. #2
    AspDotNetStorefront Staff - Scott's Avatar
    AspDotNetStorefront Staff - Scott is offline Administrator
    Join Date
    Mar 2007
    Location
    Ashland, OR
    Posts
    2,390

    Default

    You should be able to copy the image map code to the other products easily enough through an SQL query, that's stored in the SwatchImageMap field in the Product table.

    As for the image, there are a lot of bulk file copy/rename tools out there, I would recommend using one to just copy the image for all the products you want to assign it to. The swatch image is saved in /images/product/swatch/productID.jpg