Here is another pragmatic web-technology based solution I would like to share with you. We had a given Demandware eShop with 35k variants at the time (in 2014). Where a variant represents a ‘product’ in a unique color and ‘articles’ being the children of the variants as real orderable items – a variant in a certain size. A big eShopping site.
Our goal was to have any image of articles in the eShop under a very simple URL that can be generated only by knowing a ‘number’ (SKU or EAN if available) leading to an existing article like this: http://imagex.xxxxx.de/<sku>. The response would be a html image header and the streamed content of the image itself or if not available a placeholder image.
Fortunately Demandware offers a comprehensive, well documented REST based API (we used the Open Commerce API 13.6) to interact with the eShop returning results in pure JSON.
The initial use case was to add pictures of the articles to help logistics people picking the purchased items from the warehouse. They use mobile devices with a screen and item lists on it. Another use case was to add article images on various internal reports based on the business intelligence system informing management of what is currently being sold.
The workflow of the application works like this:
- The image is stored in an ‘eternal cache’ in a directory path that is generated from the ‘number’ – e.g. 4054781891957 converts to this path data/400/405/478/189/195/7/4054781891957.jpg (400 being the width of the cached image version).
This way we did not have to use a database. We use just use is_file($path) to find out if we have a valid cache hit.
- If a cached file does not yet exist (first call on a ‘number’), depending on the type of the given ‘number’ we check a bunch things via the API in the background. This is like a regular search on the eShop, fetch the URL of the article’s main image, download it and save it to the local cache converted to 400px, 200px and 100px width.
Drawback: OCAPI only offers information about articles that are ‘online’ at the time of the API call.
- debug: Outputs the differnets actions along the way to the image.
- nocache: Forces re-fetch from Demandware OCAPI.
- w: Default width is 200px. Possible Values 400, 200, 100
The application is hosted in our own infrastructure for the customer. The application is based on Symfony2.
Update: The application now has also a SOAP/WSDL API to a) integrate images into other enterprise applications via base64-stream and b) force cache refresh of an image (happens on recycled article numbers).