I’ve been having occasional problems with FTP on my image hosting service provider for a while. Never enough to yell at them, but once every 1000 listings or so it will time out or log me out or think I’m doing some kind of DDoS. At that point GS will start failing to log in and all the listings will stop uploading correctly.
Yes I know I can use GS hosting! I do, in fact, switch between GS and my ftp now and then, usually when I have 600 listings to launch or re-list, and my FTP server is locked. Also: yes! I am in contact with the service provider and the support people are skeptical about any third party FTP software so they aren’t being helpful.
So I now (and always, until I fix FTP reliability) have some listings with images hosted on my FTP server, and some with images hosted on GS image service.
In order to move all the images in running listings from one hosting service to the other, so I can at least delete all the old extra images that have accumulated from the failures (and from size changes, and from stopped-and-relisted listings) over the years, what I’d like to be able to do is:
- select one or more listings
- be told which server the images are hosted on
Is that information stored anywhere in the database tables, by any chance? If not, could it maybe be added to the Listing <-> Image relationship so we can do maintenance? I suspect that no Listing will ever use more than one server in my case (famous last words), but I can imagine somebody with a commodity inventory and numerous associated Listings with one item. So in terms of DB design, it sounds like the server info should be associated with that `Listing <-> Image` association, not with either end node? ¯\\_(ツ)_/¯
This is also linked to GarageSale’s “delete old images” functionality, I assume. How does that even work, if I upload half my listings to my FTP server, then switch to GS hosting and upload the remainder? Or upload (accidentally) to both? Is there any record, or is the global setting Upload images using:… under eBay images pane in the Settings the only record of where things “are”?