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: SQL Query for category images

  1. 07-04-2013, 02:10 PM #1
    medsupply is offline Senior Member
    Join Date
    Jul 2011
    Posts
    99

    Default SQL Query for category images

    I would like to assign images to categories in bulk via SQL query but I am no programmer. Would this be the right query? Somehow it's not working

    UPDATE Category SET ImageFileNameOverride='imagename.jpg' WHERE Category ID=XXX

    Thx!
  2. 07-12-2013, 09:47 AM #2
    jsimacek is offline Senior Member
    Join Date
    Dec 2008
    Location
    Phoenix, AZ
    Posts
    373

    Default

    That is correct, make sure you have the correct column name which looks like you do: ImageFilenameOverride

    Then, also make sure the images of that name are uploaded into the /images/category/icon and medium and large!
    Jan Simacek - Compunix, LLC
    AspDotNetStorefront trusted Devnet Partner and Reseller since 2005

    AspDotNetStorefront Mods and Add-Ons at http://www.ecommercecartmods.com/
    - Searching, Filtering and Sorting (like cSearch, Dealer Locator, Price Ranges, Blog)
    - Reports (like Cart Abandonment and Net Sales)
    - Customer Experience (like Question/Answers)
    - Site and Data Management (like Entity Product Mapper, Bulk Updaters, Make/Model/Year filters)