Announcement

Collapse
No announcement yet.

Color choices

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Color choices

    I have lets say 100 products that all have color choices
    green, blue, red, black.
    I want to add white to all of them. is there a way to do it automatically. or i have to add this color one by one

    #2
    Change the first one and then copy paste this one into each location. A bit long winded but quicker than typing, especially if you turn preview window off.

    Comment


      #3
      I know how to do it manually. I need to do it automatically as there are many products and it is time consumming.

      Comment


        #4
        Colour Chnage

        Try opening the relevant file in MS Access and adding another line and copying all the relevant bits from one of the other colours, and just add the colour needed.
        Thanks for helping me, all healp is needed.

        Regards
        The Trautbec

        Comment


          #5
          I need to do it automatically. even in access, i need to do with a push of a button. I dont want to copy and paste.

          Comment


            #6
            Write an update query in access to insert into the product properties table, based on one of the other colours. Bit dodgy mind you, so make many backups before doing it.

            Another idea would be to export a hierarchical import file for your catalog and somehow use find and replace to add the extra colour and then import it - don't know how you would get the extra colour onto a new line though.

            Regards,
            Jan Strassen, Mole End

            Comment


              #7
              I think it would take longer to create something to do it with one-click than to do the work - unless you know access well.

              Export to csv and use macros in Excel and then like Jan says use an hierarchical import to update.

              Mind, you if you only have 100 or so to do then you can do it with cut and paste in Excel and import an update in less than half an hour. Safest way.

              Duncan R

              Comment

              Working...
              X