Setup > SuiteCommerce Advanced > Setup Website, then edit your website and go to the Advanced tab. In the Image Resizing section On this page you can also see the Images Folder, which is the location in the file cabinet where your product images live. Since we’re doing a bulk upload, we’ll be using the Advanced Add feature built into NetSuite to upload a zip file of all our images once we’ve named them correctly. And using a field called Image Code as my file identifier, and a period (.) character to separate the categories or matrix options in the file names.
So, for example, if my Image Code field held a value of ABCD1234, and if I was dealing with a matrix item that was the colour green, then my image would need to be named ABCD1234.media.Green.01.jpg.These might be different depending on your site settings
Step 1: Item Import CSV
With your naming convention and images prepared, we need to move onto how we’re going to generate the correct file names for the images.
The next logical place to go in regard to your image names is to gather up all your image identifiers (eg SKU numbers) in your item import CSV file. This gives us a column that we can use to rename our files based on the image identifier, along with any matrix values that we want to use for naming in the process.
Step 2: Gather Your Image Files onto a folder
Step 3: Get the Image List
Open command prompt:cd C:\Documents and Settings\jj\documents\ItemImages
When you’re in this directory, you’ll need to export
dir /b > myimagelist.txt
myimagelist.txt file contains:
1920px-1980_-_VAZ_2101.JPG
LBGLOVE-5678.EFGH.jpeg
MBSHOE-1234.ABCD.jpeg
PNKSPRNKLDONUT5.jpeg
appl.steamy.iron.jpeg
blue_tie_45098.jpeg
fancy camera with lens 01.jpeg
macbook-pro-1967.jpeg
Step 4: Create Copy Commands in Spreadsheet
The trick is going to be that we’re going to copy the image files from the source directory into our newly created renamed directory. In the process of copying the files, we’re going to rename them based on the data in the CSV file. To do that, we need to generate the correct commands for each one, and, for that, we’re going to head back to our spreadsheet.
It sounds difficult, but it’s actually pretty simple:
Create a copy of your item import CSV file and open it up in your chosen spreadsheet application
Add a new column called something like ImageFile
Add another column called CopyCommand
Open the text file and paste in the list of file names into the ImageFile column. Note that this assumes that your import sheet rows are in the same order — if they’re not, you’ll need to sort them correctly beforehand.
Now for the magic!
Put one of the following formulas into cell K2, assuming that this the first cell in the CopyCommand column:="copy """&J2&""" renamed\"&D2&".media"&IF(LEN(I2)>0,"."&I2,"")&".01.jpg &^"
After hitting Enter, it should return something like this: copy "1920px-1980_-_VAZ_2101.JPG" renamed\LVAZ2101.media.01.jpg &^
Step 5: Run the Commands
Highlight the entire CopyCommand column (except for the header text) and copy it. In your command line window, paste it in but before you hit Enter, make sure you remove the final && or &^, as we want the command sequence to end after the final command in the chain. If you’re using a version of Windows prior to 10, you might need to select the paste command in the top left corner of the command prompt window.
Step 6: Zip and Upload Your Images