huffmancs Posted March 7, 2006 Posted March 7, 2006 I have a catalog of over 900 pages. Each page is entered into OSCommerce as a product, showing a scanned in image of this page. All the products, part numbers, on that page are options, entered as attributes. I am dealing with thousands of attriubutes, most with different pricing. I just want to be able to edit my products and atrributes/options offline. Working on the web interface takes so long to bring things up. I even get bumped off the server for going over my allowable amount of queries. I tried easy populate, but it didn't bring my attribute information down. From what I heard about it, I don't want to use in anyways. Maybe I am doing something wrong. My solution is to be able to download the MySQL database, make additions/changes and update prices, then upload the database back onto the web. What are your solutions for this? What do I need to edit MySQL offline?
rahul23 Posted March 8, 2006 Posted March 8, 2006 If you want to work with your database offline and are using a windows machine use mysqlfront available at http://www.mysqlfront.de. Its an evaluation copy that works for 30 days to purchase its about $30 US dollars. If your provider allows it, MySQL-Front can make direct contact with the database. Otherwise only one small script is to be installed on the publishing website. Login-information and passwords are stored on the harddisk, there is no need to log in on different webinterfaces. MySQL-Front presents an uniform front-end for every database in all current projects. In practice one can work with a database of one's choice after only a few clicks. Hope this helped.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.