Guest Posted September 8, 2005 Share Posted September 8, 2005 This is my first time setting up a store. My client has one currently, but we are switching to cube cart after I design his new website. He is asking me what the field structure of the new database is so he can send me the file with all the products. What is the answer for this? Quote Link to comment Share on other sites More sharing options...
Guest tbladecki Posted September 8, 2005 Share Posted September 8, 2005 What I would do, it may not be the best way, but because I know alot about MySQL, I would enter a product thur the admin section on the site, then go to MyPHPAdmin and export the inventory out to a delimiting file. Then you can open the file and see what fields are avialable in the database, you may have to look at the actual structure to detemine how and what information you can have in the field. Hope this helps, but this is how I got the same information when I needed it. Quote Link to comment Share on other sites More sharing options...
Guest Posted September 8, 2005 Share Posted September 8, 2005 Thanks! How do I get to MyPHPAdmin? Quote Link to comment Share on other sites More sharing options...
Guest tbladecki Posted September 8, 2005 Share Posted September 8, 2005 You have to go to the cPanel or the admin address for you website. You should be able to get to PHPAdmin from there. In fact I have looked at the export capablities and notice that within phpMyAdmin you can export a "structure" for the table you are looking for, which is: "Cubecart_inventory" Open the table and click on the export at the top of the table, once this opens leave the "export" column alone and uncheck the box next to data, and check the "save as file" box, and then "go" this will give you a text file that lets you see what the "structure" for the inventory is. Hope this helps Quote Link to comment Share on other sites More sharing options...
Guest Posted September 8, 2005 Share Posted September 8, 2005 That worked! Thanks so much. You just saved me hours of research. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.