Are you a local GTA manufacturer looking for a website solution to manage your on-line product inventory? Theme-based websites (Drupal, Joolma and WordPress) are handy for retail and small business websites but don’t work well with marketing / products managers that use Microsoft Access or Excel to handle extensive product inventories (5,000+ products). Some products have so many fields! We commonly convert client spreadsheets with 75 columns or more (A-Z, AA-AZ, BA-BZ, CA-CZ, etc.) into functional and easy to navigate MySQL databases.
What’s nice about MySQL is it has the flexibility to handle large, text-based fields that can contain virtually unlimited HTML content. With UTF-8 format, fields can also contain trademarks (™), registered symbols (®), copyrights (©), international characters (àáâãçèéê) and other unique symbols.
For products with several images, a relational photo database can be established containing pertinent photo information, ie. captions, renderings, lightbox/popup/zoom-in details and SEO information.
MySQL is ideally suited for products that are organized in a hierarchical structure addressing such requirements as product industry and material type.
MySQL product tables are also easy to import back into Microsoft Excel via CSV generated files that way reference to spreadsheets can still be maintained.