Database Management
It is important to back up your mySQL database whenever you add new information. Your best bet is to use a utility such as phpMyAdmin, which is often installed on your server. See our short instructions regarding database backups.
- You can add entire text files, database dumps or spreadsheets full of data to your mySQL database in one large chunk, instead of adding products individually.
- This service is not included with the Company Website Catalog installation, but can be done yourself through phpMyAdmin, if you are familiar with the service.
- Information about the table structure, to assist with a product upload :
- Shop_Items: Contains the majority of the product information (name, description, price, categories, etc.)
- Shop_Options: Lists all of the product options. This table is linked to the Shop_Items table by the item ID number: Shop_Options.ItemID = Shop_Items.ID
- Shop_Related: Links the ID numbers of a product with its related products. This table is linked to the Shop_Items table by the item ID number: Shop_Related.ProductID = Shop_Items.ID (of the main item) and Shop_Related.RelatedID = Shop_Items.ID (of related items).
- The categories listed in the Shop_Items table are linked by the category name, not by ID.