oslover Posted March 8, 2007 Share Posted March 8, 2007 I am an os user and lover too :P I have two websites. I would like to copy all the products presented in the first site to the second site, but due to time constraints it is too difficult to do this in a short time. So, I came to this forum hoping that i will get useful aid. Note: my second website already has products too. but different kind of products than the first one. So i would like to have two different categories of products. Please be precise in your suggestions because I am not an advanced programmer :'( . Any ideas are welcome and thanks in advance. Regards, David Link to comment Share on other sites More sharing options...
Guest Posted March 8, 2007 Share Posted March 8, 2007 You have a couple of options here. 1.) You can install the easy populate into both sites an then do it from the admin. it is an easy contribution to use that allows for mass export and import of products into your website. 2.) Use phpmyadmin to export product tables and other assocaited with products and the add them into the new site. I think that covers it. If you would like more help with this I will try to help as I am availble. I am an os user and lover too :P I have two websites. I would like to copy all the products presented in the first site to the second site, but due to time constraints it is too difficult to do this in a short time. So, I came to this forum hoping that i will get useful aid.Note: my second website already has products too. but different kind of products than the first one. So i would like to have two different categories of products. Please be precise in your suggestions because I am not an advanced programmer :'( . Any ideas are welcome and thanks in advance. Regards, David Link to comment Share on other sites More sharing options...
oslover Posted March 8, 2007 Author Share Posted March 8, 2007 Thank you for your reply. First, I think Easy populate is a great contribution but to tell you the truth I installed it but get confused with all the options and some strange names seen in the Exported file say Excel. I d like to use it in editing the products, prices and so on but I am afraid i will do something wrong with the store. Second I want to <<Use phpmyadmin to export product tables and other assocaited with products and the add them into the new site.>> I know PHPMYADMIN and few things in it. I don't know which product tables and other things (prices, sizes etc..) and how to export them to the second site. Please could you explain in detail and thank you so much for your assistance. Link to comment Share on other sites More sharing options...
Guest Posted March 8, 2007 Share Posted March 8, 2007 Its not really hard to do. Alls you have to do is click on for example the products table. then you need to click on export on this page there is a checkbox to save the file. save it to a text file. next take the "INSERT TO" LINES and paste them into the new sites phpmyadmin mysql box and click go. it is that simple. the table I think deal with products are products products_description products_images products_notifications products_to_categories manufacturers If you are using manufacturers_info If you are using osc_products products_attributes these are only if you are using attributes. products_attributes_download these are only if you are using attributes. products_options these are only if you are using attributes. products_options_values these are only if you are using attributes. products_options_values_to_products_options these are only if you are using attributes. And that will do it. Simple as 1 2 3. download table copy insert to data past to mysql command box Done! Next table. Thank you for your reply. First, I think Easy populate is a great contribution but to tell you the truth I installed it but get confused with all the options and some strange names seen in the Exported file say Excel. I d like to use it in editing the products, prices and so on but I am afraid i will do something wrong with the store. Second I want to <<Use phpmyadmin to export product tables and other assocaited with products and the add them into the new site.>> I know PHPMYADMIN and few things in it. I don't know which product tables and other things (prices, sizes etc..) and how to export them to the second site. Please could you explain in detail and thank you so much for your assistance. Link to comment Share on other sites More sharing options...
oslover Posted March 8, 2007 Author Share Posted March 8, 2007 do you mean I should export the products table first then the manufactures table then products_options? or all these are different tables that i should export and copy to the second website mysql? and how about the pictures? products products_description products_images products_notifications products_to_categories manufacturers If you are using manufacturers_info If you are using osc_products products_attributes these are only if you are using attributes. products_attributes_download these are only if you are using attributes. products_options these are only if you are using attributes. products_options_values these are only if you are using attributes. products_options_values_to_products_options these are only if you are using attributes. Link to comment Share on other sites More sharing options...
Guest Posted March 8, 2007 Share Posted March 8, 2007 these tables are are tables associated with products in osc. Yes download them and then import them into the new site. As far as products download them through ftp and then reupload them through ftp on the new website. Can I ask how many products we are talking about ? do you mean I should export the products table first then the manufactures table then products_options? or all these are different tables that i should export and copy to the second website mysql? and how about the pictures?products products_description products_images products_notifications products_to_categories manufacturers If you are using manufacturers_info If you are using osc_products products_attributes these are only if you are using attributes. products_attributes_download these are only if you are using attributes. products_options these are only if you are using attributes. products_options_values these are only if you are using attributes. products_options_values_to_products_options these are only if you are using attributes. Link to comment Share on other sites More sharing options...
Alexandero Posted March 8, 2007 Share Posted March 8, 2007 Thank you very very much Kevin I will try to do what you said. The number of products is 278 . Link to comment Share on other sites More sharing options...
Guest Posted March 8, 2007 Share Posted March 8, 2007 No problem if you need more help I am always online. I don't sleep lol. Always remember to backup backup backup before messing with databases. 278 is a small amount of products and should work without any real headaches. Remember if you are not using attributes on your site no need to even export that data. Thank you very very much Kevin I will try to do what you said. The number of products is 278 . Link to comment Share on other sites More sharing options...
oslover Posted March 8, 2007 Author Share Posted March 8, 2007 I am now in PHPMYADMIN I am trying to do what you said, I clicked on Products table then i cheked all, then i clicked on Export because there is no Save check box, and in Export page I see these types : CSV CSV for MS Excel Microsoft Excel 2000 Microsoft Word 2000 LaTeX Open Document Spreadsheet Open Document Text PDF SQL XML Which format please should i choose? and there is GO button at the buttom. Link to comment Share on other sites More sharing options...
oslover Posted March 8, 2007 Author Share Posted March 8, 2007 Please anyone kindly reply to my question, I have been waiting for many many hours. Thanks. Link to comment Share on other sites More sharing options...
Guest Posted March 8, 2007 Share Posted March 8, 2007 I am now in PHPMYADMIN I am trying to do what you said, I clicked on Products table then i cheked all, then i clicked on Export because there is no Save check box, and in Export page I see these types : CSV CSV for MS Excel Microsoft Excel 2000 Microsoft Word 2000 LaTeX Open Document Spreadsheet Open Document Text PDF SQL XML Which format please should i choose? and there is GO button at the buttom. Me personally export only in SQL, However you can use any method you prefer. Link to comment Share on other sites More sharing options...
oslover Posted March 8, 2007 Author Share Posted March 8, 2007 Thank you so much for you suggestion :) Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.