I sell lots of things to hardware stores. Retail stores keep track of items by their own internal number. We refer to those numbers as 'customer numbers' because we have lots of customers and customers each have their own numbers.
They each call them the SKU number aka STOCK KEEPING UNIT.
I had 450 image files listed by model number(our number) that needed to be changed to customer numbers(their number). Here's how i did it.
Create an excel spreadsheet with current filename(with file extension) in column A
Put the filename you want in column B.
Put an equation in column C that is "ren " and column A and " " and column B.
spreadsheet should look like this:
They each call them the SKU number aka STOCK KEEPING UNIT.
I had 450 image files listed by model number(our number) that needed to be changed to customer numbers(their number). Here's how i did it.
Create an excel spreadsheet with current filename(with file extension) in column A
Put the filename you want in column B.
Put an equation in column C that is "ren " and column A and " " and column B.
spreadsheet should look like this:
Current Filename
|
Filename You Want
|
="ren "&A1&" "&B1
|
| 10036.jpg | B000HJDBAU.pt01.jpg | ren 10036.jpg B000HJDBAU.pt01.jpg |
| 10038.jpg | B000VRDIA6.pt01.jpg | ren 10038.jpg B000VRDIA6.pt01.jpg |
| 10040.jpg | B000BQ7UW4.pt01.jpg | ren 10040.jpg B000BQ7UW4.pt01.jpg |
After you have a completed the spreadsheet open CMD like this:
After the CMD is open, you need to open the folder where your images are. find your pictures and right click to 'copy address as text'
Back in the CMD type: CD [right click to paste the address that you just copied]
Now copy column C from your spreadsheet and paste into the CMD. It will find all the current filenames and change them to the ones you want!
Comments
Post a Comment