Do you already have a MySQL database set up with inventory counts for some of the images in your gallery, and is updatable from your point-of-sale ?

Do you just want something like "3 in stock" to be added before "Important Ordering Information" in the description for each image?

I have some PHP & MySQL skills. I currently use Square for inventory control, and I could export from Square then import to MySQL prior to a show.

I'd prefer no display of an out of stock image. An item count in the comment would work fine.

Edited by: rdubbs on 5 Jan 2022, 09:15

Thanks! Your demo page would work well. I very much like n'Anders reply in the MySQL thread. I will throw some time at this problem this weekend.

You can see my PHP/MySQL ability here (choose any name in the login dropdownĺ: http://frugalpix.com/nlwl/index.php

Edited by: rdubbs on 6 Jan 2022, 15:45

Thank you for finding the Square info for me. This looks really promising. I will report back my findings, though I'm not a fast programmer so patience will be required. I really want to move my booth to digital display of my open stock photos, so I plan to be successful with this project.

I've been looking at the API information that Square provides. I believe that that resource could provide the service I need, however I'm not going to pursue that path right now. I have no experience working with APIs. It seems to me that jAlbum wants to hit a static database or paths (I'm not fully up to speed on jAlbum data access), and I have MySQL experience. My plan, now, is to see if I can get jAlbum to get inventory counts from MySQL, and then I'll write a PHP front end to that database so I can update inventory counts on the fly. It won't be entirely automatic, but I believe it will work. It also has the benefit that I cab run it locally, if I don't have Internet access.

I would have thought that Square would be able to communicate via PHP in the same way that MySQL can, thus removing the necessity for maintaining and synchronising two separate but essentially equivalent databases ?

Further success!

This weekend, I'll post a "proof of concept" site that will be permit some manipulation. I have it to the point where the entire database can be updated from the Square items catalog, and individual items can be edited.

On the jAlbum side, I've modified the SampleOne skin to directly produce the PHP files needed for MySQL access. The only editing required is to set the MySQL access credentials. I have tried to modify the Tiger skin, and it threw a number of errors. I'm not which skin I'll settle on for my booth, but I expect it can be PHP/MySQL enabled.

One key consideration is the name of the photo in Square must be the same in jAlbum. If there are many photos in the album/catalog, synchronizing those names may be a challenge. I did a manipulation in a spreadsheet to change the names in Square, as Square permits catalog updates via CSV.