Store manager import image names
Our feed that comes from our computer supplier doesnt include image names.
But the image name is always the model number and always jpg images.
Is there away to automate this on the image field would use the model number name and add .jpg to the end?
13
votes
You are not logged in.
If your building CSV's in most spreadsheet editors you can use a formula to combine the two. For example; if using Excel, you would be using concatenate and the formula would look like this (in the desired cell) =CONCATENATE(P#,".jpg")-P# representing product number
I would take what is suggested a step further
Something like
get image at [CSV_COL(image URL)] set it = to CONCAT([vendor/,[CSV_COL(Model Number)],.jpg)
but since I really now nothing about writing SQL, I have no idea how to even write the expression correctly much less if it would would with the import process.
But if there is a way to write an expression that will achieve this it would be great to have.
Dan
The following expression works to name images by model ... to a directory ... with .jpg attached ... keep in mind this is all fictitious information you are loading into the database and that there is no FTP of the image done by Store Manager ... you will have to do that on your own.
CONCAT('image/',[CSV_COL(1)],'.jpg')
image/ = the directory you wish the image to be in
CSV_COL(1) = the column in your csv import file that contains the model number ... specifically (1) ...
.jpg = the extension you wish the file to have
Dan