Here is a little tutorial I put together to help you out.
1) Gather all of your art in a single folder. Use logical filenames to help you keep your brain from frying. Here is an example of a photograph of a lamp for this tutorial:
2) In Photoshop, you are going to create a new document that will be the correct size and resolution for your final print. You had mentioned 4x6 prints, so let's go with 4x6 at 240 dpi for kicks, 8 bit RGB color. I didn't do that for this example, I'm just saying....
3) Set up the document carefully, as this will be the "Master" template, upon which all of your comps will be based. You are going to set up you Master with layers. Each layer will be an element you want to change in a comp. This may include background visibility, lamp images, lamp names, lamp prices, lamp catalog numbers, etc.
Give each layer a logical name. Here is an example of a master document, set up as a template:
Note the layer names, etc. In this case, I am going to have four lamps, and each arrangement will have two different backgrounds, one that is white (ground) and one that is 50% gray (backdrop). For each version, I will toggle the visibility of the "Backdrop" layer to reveal or hide the white "Ground" layer.
So, once we have the template set up the way we want it to look, we need to set up each layer as a variable. Graphics layers will have the ability to toggle visibility, or specify a "pixel replacement" attribute. Text layers will have similar attributes. Go to the "Image > Variables > Define" menu item:
and define each layer's attribute. Note that you will need to define a variable name. Replace the default with something more logical - I used the field text from the template doc as the variable name. Note, variable names are CASE SENSITIVE.
4) Fire up your spreadsheet or text editor and define your Data Sets. Here is my Excel spreadsheet:
here you can see my variable names and how I refer to the graphic files I want to insert in each case (Graphic) the visibility of either the gray backdrop (BackdropVisible) and the text I want in each field placeholder for each lamp version.
once you get that all set, export it as a CSV or Tab delimited text file. This is what you will feed to the automated Photoshop machine in the next step.
5) Now you are going to define your Data Sets. You could do this manually for each version of the comp you want to generate, but you already did this efficiently in the spreadsheet. So, go to "Image > Variables > Data Sets":
And you will get the following Data Sets dialog - select "import" from the right hand side:
hit "Select File" and browse to the CSV file you exported from Excel earlier.
6) When you do this, Photoshop creates a Data Set for each line of your CSV file (ie, a Data Set for each comp you want). Here you can preview each comp by clicking the previous and next arrows next to the Data Set field.
Cool. If all looks good, you are ready to automagically crank out all of the comps you need.
7) Go to "File > Export > Data Sets as Files"
and tweak the final naming convention and save location. You will export PSD files, so each comp will be fully editable on the layer level you set up in the Master template, in case you need to make some changes.
Here are the final comps of my sweet lamp shoot, with 4 lamps and two backgrounds:
As you can appreciate, careful set up of the template, uniformity of source material and an organized set of variable names/spreadsheet are the keys to making quick work of a large number of comps. Hope this helps. Have fun!
Kirk
PS - it was really late when i wrote this, forgive mistakes, typos etc. If something seems amiss, it probably is. I will check it in the morning. Hopefully this will get you started.