E-Commerce Inventory Spreadsheet

I need a clean, well-structured Excel workbook that lets me stay on top of my e-commerce product inventory. The core focus is product data, so each row should capture the essentials—SKU, title, detailed description, category, price, quantity on hand, and a spot for a product photo or image link.

Because I don’t want to copy-paste numbers every day, please build in an automatic update mechanism. Whether you prefer Power Query, a VBA routine, or dynamic Excel functions, the sheet should refresh stock figures from a simple CSV feed or other flat file I can drop into a folder. All formulas must recalculate without manual intervention.

Deliverables
• One Excel file (.xlsx) ready to use, with clearly labeled worksheets
• Built-in auto-refresh for stock levels, triggered on file open or with a single click
• Columns and formatting that make long product descriptions easy to read
• Support for storing or referencing product photos (embedded image or hyperlink field)
• Brief instructions inside the workbook so anyone on my team can update the feed source, add new products, or adjust categories without breaking the automation

If something in my requirements isn’t feasible in native Excel, let me know your workaround before you start. I’m ready to review your approach and get this live as soon as possible.