How Did I Use ChatGPT and PowerShell to Make Bulk eBay Listing Easier?
On an eBay job for my buddy, I put the item photos into ChatGPT to help suggest prices and draft descriptions, had it write a PowerShell script to bulk rename the files, and used eBay's bulk listing CSV. It was easier, but it still took hours, and I had to fix titles and prices myself.
What was the eBay job, and why was it so slow?
My buddy asked if I could help him list things on eBay. I said, "Sure." I tell the bigger story of how that job pulled me back into IT in another post How I Found My Way Back to IT. This one is about the method.
The first night was all manual. He took pictures and synced them into a shared iCloud album. I sat there downloading batches, dragging pictures into eBay's image search, and copying and pasting filenames.
My buddy and I spent about 12 hours on it. If I remember right, I had maybe 40 out of 150 items inventoried and about 10 listings drafted.
That's the part that stuck with me. The slow part wasn't knowing what the items were. It was the repetition: download, drag, search, copy, paste, and do it again for the next item.
What did I change the next day?
He had hired me to help with this, so I kept the inventory when he went home. The next day, I thought, why don't I put the pictures into ChatGPT and have it help me suggest prices and draft descriptions?
About 45 minutes into that, another thought hit me. Wait a minute. I can have this application inspect the photos and write a PowerShell command to rename the files.
At that point, I was still dragging and dropping about 10 images at a time, depending on file size. The photos were around 1 MB each. I dragged them straight from File Explorer, on a multiple-display setup, into ChatGPT, and also into eBay. Even with a system, it was easy to forget which batch I had dragged.
Then ChatGPT kept mentioning a "bulk listing CSV," so I looked into it. I remember thinking, wow, this is so much easier.
How did I use ChatGPT, PowerShell, and eBay's bulk listing CSV, step by step?
This is the order I worked in on that job. It's my personal experience from one project, not a tested recipe.
- Get the photos onto my computer. My buddy's pictures came in through the shared iCloud album, and I downloaded them in batches.
- Give ChatGPT the photos in small batches. I dragged about 10 images at a time from File Explorer, depending on file size, and asked it to help suggest prices and draft descriptions.
- Confirm the file names, then ask ChatGPT for a rename script. ChatGPT can look at the photos, but it doesn't read the original file names from those uploads. So I confirmed the local file names first, then had it write a PowerShell script that mapped each old name to a new one. The new names used a SKU, a short description of the item, and a two-digit photo number, with spaces only, like DC 001 M2 Machines PEZ Auto Drivers 1956 Ford F 100 Truck 01.JPEG. There were about two photos per item, and those names sorted in order in File Explorer.
- Run the rename in PowerShell. A short batch of PowerShell commands did the bulk rename that I had been doing by hand.
- Build a drafts upload CSV and review the drafts in eBay. I kept a master inventory CSV, then built a separate upload file from eBay's "Create new drafts" template and uploaded it. That file created drafts. It did not pull the photos in from my computer. After the upload, I reviewed the drafts in eBay and added the photos and remaining details there. By then the photos already had SKU file names and were in order. I used the Custom label (SKU) field so each draft could be matched back to its photos and to the master file.
- Check titles and prices by hand. I had to go back and adjust titles and prices because I had been relying too heavily on ChatGPT. That step is not optional.
I also wrote the steps down as a checklist and workflow docs, so I could run the same process on the next batch.
How the system works
There are three pieces, and each one does a different job.
ChatGPT looks at the photos. OpenAI's ChatGPT Image Inputs FAQ says ChatGPT can understand and interpret images you add to a conversation, and that you can drag an image file into the text area. The same page lists limits worth knowing for this kind of work: the model doesn't process original file names or metadata, and it may generate incorrect descriptions in certain scenarios. So whatever it suggests is based on what it sees in the picture, and it can be wrong. That is why I confirmed the local file names before I asked it for a rename script.
PowerShell does the bulk rename. Microsoft's Rename-Item (Microsoft.PowerShell.Management) page describes Rename-Item as the cmdlet that changes the name of an item, like a file. A single rename looks like this. This is an illustrative example, not the exact command I ran. The new file name follows my pattern; the folder path and the old file name are made up:
Rename-Item -LiteralPath "C:\eBay\photos\IMG_0412.JPEG" -NewName "DC 001 M2 Machines PEZ Auto Drivers 1956 Ford F 100 Truck 01.JPEG" -WhatIf
The real value is that ChatGPT can write a list of lines like that for a whole batch, once the original names are confirmed. The -WhatIf switch in the example is documented on Microsoft's Rename-Item page. It shows what would happen if the cmdlet runs, without running it, which is a reasonable way to preview a batch. The same page says you can't use Rename-Item to replace an existing item, even with -Force, so a duplicate target name will fail. That's one reason each file name includes a unique SKU and a photo number.
eBay's bulk file creates the drafts. eBay's Uploadable Templates page describes a template as a file with predefined column headers. Each row describes one product, each column holds one listing field (like title, price, category, or description), and the first column sets what action the file performs. eBay offers a "Create new listings" template by category, and a "Create new drafts" template that uploads draft listings in bulk to your eBay Drafts folder so you can finish and activate them in your account. The same page says you can add an item photo URL on the draft template, or add images from your own local hard drive or from a web-hosted URL within your Drafts folder. I did not put local Windows file paths into the CSV. I used "Create new drafts," then added the photos in eBay after the upload.
Put together, the photos give ChatGPT something to read, PowerShell handles the file names, and the bulk file replaces a lot of one-at-a-time clicking. The photos still have to be added in eBay.
Why do AI drafts of titles and prices need a human check?
This is my own lesson from the job. It was easier, but it still took hours, and I had to go back and adjust titles and prices because I had been relying too heavily on ChatGPT.
A title or a price is what a buyer sees. If ChatGPT's suggestions are off, that mistake goes straight into the listing. OpenAI's own help page says the model may generate incorrect descriptions. So I treat what it writes as a first draft, including suggested prices. I read every title and check every price myself before anything goes live.
What did this job change for me?
When I first heard "AI," I thought of a better way to Google things, generate some images, and maybe get help writing a PowerShell command to organize files. This job was exactly that, and it got me thinking differently about the work.
The idea I took from it is simple: find the step I'm repeating by hand (automation and AI), and see if a tool can do that step while I keep the decisions. Today I work with people and businesses in Holbrook, Ronkonkoma, Bohemia and across Suffolk County.
Frequently asked questions
Did ChatGPT write the eBay listings for you?
It helped me suggest prices and draft descriptions from the photos. I still had to go back and adjust titles and prices myself.
What did PowerShell do in this process?
I had ChatGPT inspect the photos and write a PowerShell script to bulk rename the files, using a SKU, a short description, and a photo number, so I stopped copying and pasting filenames by hand.
What is a bulk listing CSV on eBay?
It's an uploadable template file where each row describes one product and each column holds one listing field, such as title, price, category, or description. I used eBay's "Create new drafts" template, then finished the drafts in eBay, including the photos.
How long did the job take?
The first night, my buddy and I spent about 12 hours and had maybe 40 of 150 items inventoried and about 10 listings drafted. Even with ChatGPT and the CSV, it still took hours.
What's the next step?
If you have repetitive file or spreadsheet work you want to talk through, here's how to reach me.
Call (631) 229-4446 or use the contact page at rosscoreit.com/contact. By appointment.
Sources
The events and numbers in this post are personal experience and are not backed by these links. For the tools I mention:
- eBay, Uploadable Templates
- Microsoft, Rename-Item (Microsoft.PowerShell.Management)
- OpenAI, ChatGPT Image Inputs FAQ
