achievements on 01.09.2024

achievements on 31.08.2024

achievements on 29.08.2024

achievements on 25.08.2024

Inside Out 2, 2024

Watched on Friday August 23, 2024.

achievements on 24.08.2024

achievements on 22.08.2024

achievements on 20.08.2024

achievements on 19.08.2024

Semi Automated Bulk Selling Ebay

Here are my notes on how to efficiently sell multiple CDs on eBay with the help of Apples vision API and ChatGPT.

This can be adapted to selling DVDs or Blu-Rays as well.

taking pictues

Use a ringlight that holds your iPhone in place.

Take one picture of front and back, make sure there are no gaps.

Move the files to your mac, you now have a list of files.

$ ls -rt
IMG_0355 2.HEIC IMG_0369.HEIC   IMG_0380.HEIC   IMG_0391.HEIC   IMG_0402.HEIC   IMG_0413.HEIC
IMG_0356 2.HEIC IMG_0370.HEIC   IMG_0381.HEIC   IMG_0392.HEIC   IMG_0403.HEIC   IMG_0414.HEIC
IMG_0360.HEIC   IMG_0371.HEIC   IMG_0382.HEIC   IMG_0393.HEIC   IMG_0404.HEIC   IMG_0415.HEIC
IMG_0361.HEIC   IMG_0372.HEIC   IMG_0383.HEIC   IMG_0394.HEIC   IMG_0405.HEIC   IMG_0416.HEIC
IMG_0362.HEIC   IMG_0373.HEIC   IMG_0384.HEIC   IMG_0395.HEIC   IMG_0406.HEIC   IMG_0417.HEIC
IMG_0363.HEIC   IMG_0374.HEIC   IMG_0385.HEIC   IMG_0396.HEIC   IMG_0407.HEIC   IMG_0418.HEIC
IMG_0364.HEIC   IMG_0375.HEIC   IMG_0386.HEIC   IMG_0397.HEIC   IMG_0408.HEIC   IMG_0419.HEIC
IMG_0365.HEIC   IMG_0376.HEIC   IMG_0387.HEIC   IMG_0398.HEIC   IMG_0409.HEIC
IMG_0366.HEIC   IMG_0377.HEIC   IMG_0388.HEIC   IMG_0399.HEIC   IMG_0410.HEIC
IMG_0367.HEIC   IMG_0378.HEIC   IMG_0389.HEIC   IMG_0400.HEIC   IMG_0411.HEIC
IMG_0368.HEIC   IMG_0379.HEIC   IMG_0390.HEIC   IMG_0401.HEIC   IMG_0412.HEIC

move images into subdirectories

For this you need GNU parallel.

ls|parallel -N2 "mkdir {#} && mv {1} {2} {#}/."

$ ls

1  10 11 12 13 14 15 16 17 18 19 2  20 21 22 23 24 25 26 27 28 29 3  30 31 4  5  6  7  8  9

$ ls */*.HEIC

1/IMG_0355 2.HEIC 15/IMG_0387.HEIC  21/IMG_0398.HEIC  27/IMG_0411.HEIC  5/IMG_0366.HEIC
1/IMG_0356 2.HEIC 16/IMG_0388.HEIC  21/IMG_0399.HEIC  28/IMG_0412.HEIC  5/IMG_0367.HEIC
10/IMG_0376.HEIC  16/IMG_0389.HEIC  22/IMG_0400.HEIC  28/IMG_0413.HEIC  6/IMG_0368.HEIC
10/IMG_0377.HEIC  17/IMG_0390.HEIC  22/IMG_0401.HEIC  29/IMG_0414.HEIC  6/IMG_0369.HEIC
11/IMG_0378.HEIC  17/IMG_0391.HEIC  23/IMG_0402.HEIC  29/IMG_0415.HEIC  7/IMG_0370.HEIC
11/IMG_0379.HEIC  18/IMG_0392.HEIC  23/IMG_0403.HEIC  3/IMG_0362.HEIC   7/IMG_0371.HEIC
12/IMG_0380.HEIC  18/IMG_0393.HEIC  24/IMG_0404.HEIC  3/IMG_0363.HEIC   8/IMG_0372.HEIC
12/IMG_0381.HEIC  19/IMG_0394.HEIC  24/IMG_0405.HEIC  30/IMG_0416.HEIC  8/IMG_0373.HEIC
13/IMG_0382.HEIC  19/IMG_0395.HEIC  25/IMG_0406.HEIC  30/IMG_0417.HEIC  9/IMG_0374.HEIC
13/IMG_0383.HEIC  2/IMG_0360.HEIC   25/IMG_0407.HEIC  31/IMG_0418.HEIC  9/IMG_0375.HEIC
14/IMG_0384.HEIC  2/IMG_0361.HEIC   26/IMG_0408.HEIC  31/IMG_0419.HEIC
14/IMG_0385.HEIC  20/IMG_0396.HEIC  26/IMG_0409.HEIC  4/IMG_0364.HEIC
15/IMG_0386.HEIC  20/IMG_0397.HEIC  27/IMG_0410.HEIC  4/IMG_0365.HEIC

convert images

Depending on the browser / eBay client you use this may be optional. I found it most robust to convert all images upfront.

This uses imagemagick. There are some warnings to use the convert command instead.

$ ls */*.HEIC|parallel "magick convert {} {.}.jpg"

$ ls */*.jpg

1/IMG_0355 2.jpg 15/IMG_0387.jpg  21/IMG_0398.jpg  27/IMG_0411.jpg  5/IMG_0366.jpg
1/IMG_0356 2.jpg 16/IMG_0388.jpg  21/IMG_0399.jpg  28/IMG_0412.jpg  5/IMG_0367.jpg
10/IMG_0376.jpg  16/IMG_0389.jpg  22/IMG_0400.jpg  28/IMG_0413.jpg  6/IMG_0368.jpg
10/IMG_0377.jpg  17/IMG_0390.jpg  22/IMG_0401.jpg  29/IMG_0414.jpg  6/IMG_0369.jpg
11/IMG_0378.jpg  17/IMG_0391.jpg  23/IMG_0402.jpg  29/IMG_0415.jpg  7/IMG_0370.jpg
11/IMG_0379.jpg  18/IMG_0392.jpg  23/IMG_0403.jpg  3/IMG_0362.jpg   7/IMG_0371.jpg
12/IMG_0380.jpg  18/IMG_0393.jpg  24/IMG_0404.jpg  3/IMG_0363.jpg   8/IMG_0372.jpg
12/IMG_0381.jpg  19/IMG_0394.jpg  24/IMG_0405.jpg  30/IMG_0416.jpg  8/IMG_0373.jpg
13/IMG_0382.jpg  19/IMG_0395.jpg  25/IMG_0406.jpg  30/IMG_0417.jpg  9/IMG_0374.jpg
13/IMG_0383.jpg  2/IMG_0360.jpg   25/IMG_0407.jpg  31/IMG_0418.jpg  9/IMG_0375.jpg
14/IMG_0384.jpg  2/IMG_0361.jpg   26/IMG_0408.jpg  31/IMG_0419.jpg
14/IMG_0385.jpg  20/IMG_0396.jpg  26/IMG_0409.jpg  4/IMG_0364.jpg
15/IMG_0386.jpg  20/IMG_0397.jpg  27/IMG_0410.jpg  4/IMG_0365.jpg

extract text from images

This uses Apples vision API (as opposed to Vision OS). This should also be what Apple uses to have you select / copy text from images throughout the operating system.

The CLI tool I am using is called litex.

$ ls */*.jpg|parallel "litex --lang de-DE --use-vision {}"

$ ls 2/*.txt

2/IMG_0360_text.txt 2/IMG_0361_text.txt

$ cat 2/IMG_0360_text.txt

NUR auf Bravo His BACKSTREET ROYS UNPLUGGE Nia Social
8 10
Aus der TV- und Tunkwerbung
HITS
23
Faithless
Depeche Mode
Destree
Christian Wunderlich
Falco
Franka Potente & Thomas ID.
16
17
18
19
20
21
22 23 24
25 26 27
28
29 30
31 32%

have ChatGPT generate item descriptions

The ChatGPT client I use can be found on Github. This needs an API key from OpenAI and the calls incur costs.

The model defaults to ‘gpt-3.5-turbo’ for me. Runnning this for 18 CDs cost one US cent, but YMMV depending on the amount of text the previous step extracts.

$ ls */*.txt|parallel -P1 -N2 'cat {1} {2}|chatgpt -p "Das ist der OCR Text einer CD Vorder- und Rückseite. Ermittle wie die CD mutmaßlich heißt, generiere ein Track-Listung und einen kurzen Verkaufstext für eine eBay Auktion. Beschränke dich auf die Beschreibung der CD, nichts zu modalitäten des Verkaufs.">{1//}/description.txt'

$ ls */description.txt

1/description.txt  16/description.txt 22/description.txt 29/description.txt 7/description.txt
10/description.txt 17/description.txt 23/description.txt 3/description.txt  8/description.txt
11/description.txt 18/description.txt 24/description.txt 30/description.txt 9/description.txt
12/description.txt 19/description.txt 25/description.txt 31/description.txt
13/description.txt 2/description.txt  26/description.txt 4/description.txt
14/description.txt 20/description.txt 27/description.txt 5/description.txt
15/description.txt 21/description.txt 28/description.txt 6/description.txt

$ cat 2/description.txt 

Die mutmaßliche CD heißt: "Bravo Hits 23"

Track-Liste:
CD 1:
1. BACKSTREET BOYS - "All I Have To Give"
2. CHRISTIAN WUNDERLICH - "That's My Way To Say Goodbye"
[…]
19. MANIC STREET PREACHERS - "If You Tolerate This Your Children Will Not Be"
20. DIE ROTEN ROSEN - "Kommet ihr Kinderlein"

CD 2:
1. FAITHLESS - "God Is A DJ"
2. DEPECHE MODE - "Only When I Lose Myself"
[…]
19. SILENT BREED - "Sync In"
20. STORM - "Huri-Khan"

Verkaufstext für eBay Auktion:
Erleben Sie mit der "Bravo Hits 23" eine Zusammenstellung der größten Hits aus dem Jahr 1998! Mit bekannten Künstlern wie Backstreet Boys, Faithless, Depeche Mode, und vielen mehr, ist diese Doppel-CD vollgepackt mit eingängigen Songs aus verschiedenen Genres. Perfekt für Fans der 90er Musik und für Sammler von Bravo Hits. Holen Sie sich jetzt dieses nostalgische Musikalbum und genießen Sie die zeitlosen Hits von damals!

enter listings

This part is one I would love to automate better. The eBay CSV format is atrocious and eBay seems to no longer support it, as one cannot download clean example files from the eBay web-ui. For now I use the power seller console to input all data by copy / pasting. This also helps spotting transcription errors.

Ant-Man and the Wasp: Quantumania, 2023

Watched on Saturday August 17, 2024.

achievements on 18.08.2024

Fly Me to the Moon, 2024

Watched on Friday August 16, 2024.

achievements on 17.08.2024

achievements on 16.08.2024

achievements on 13.08.2024

My Cousin Vinny, 1992

Watched on Saturday August 10, 2024.

achievements on 11.08.2024

achievements on 10.08.2024

achievements on 04.08.2024

achievements on 28.07.2024

Twelve O'Clock High, 1949

Watched on Friday July 26, 2024.

achievements on 27.07.2024

achievements on 26.07.2024

achievements on 25.07.2024