oppinion on admin approach on ecommerce website
Hi, I am trying to design a good approach for my new ecommerce website.
(1) Currently I have a supplier uploading product images via FTP to the server, they are also including a .CSV which I intend to set up a CRON job so it adds the data to a table on the database. With this I have setup on the backend to allow my client to select from these records and create a product. With this approach I am not storing any product filenames directly in the products table in the database. The filenames of the product images consist of the product SKU (which is stored in the product table - I could also allow the client to manually upload a product image if required. This approach does mean that I cannot use any WebAssist server behaviors to do any image manipulation such as image resize. But can use the WebAssist server behavior to cache a resized image on the server. Any thoughts on this approach. Am I missing any potential problems that could arise?
(2) Relating to the above, I may have discovered a bug, In the backend part of the website, when I initially look at the page displaying all the newly uploaded images (there are over 1000). Using the pagination last page button, The very last record that was showing was a PHP error relating to the WebAssist Image Resizer server behavior. I need to reproduce this, but is there a limit on what the server behavior can do since it is caching a lot of images?