Pluncker Posted June 14, 2012 Share Posted June 14, 2012 I would like to insert and edit products on a non-public mirror of my Prestashop-System and transfer the whole bunch of SQL-tables to a production, public Prestashop. Which tables should be inserted (ps_product_xx, ...)? I'm using specific prices (an PS 1.4.4.1). Are any problems or side-effects aspected? Thank you! Link to comment Share on other sites More sharing options...
Pluncker Posted July 10, 2012 Author Share Posted July 10, 2012 Can anyone help? Link to comment Share on other sites More sharing options...
Mike Kranzler Posted July 10, 2012 Share Posted July 10, 2012 Hi Pluncker, The best thing to do would be to build your site on the non-public mirror, and then either export the entire database to your public site or just point your domain to the previously non-public mirror by following our guide to moving PrestaShop here. -Mike Link to comment Share on other sites More sharing options...
Pluncker Posted July 11, 2012 Author Share Posted July 11, 2012 Hi Mike, thank you for the answer. But I have already a non-public mirror on which I am editing the new/old products/new prices (the products/new prices should be published on a specific target day). And of course I have a production, public shop with current products. I can not move the entire database, because the orders/customers on the public site will be overwritten. Domain pointing is not a serious solution (lack of SSL on the mirror, new orders on the old public server would be gone...). What I would like to do is to move only the product-specific tables from mirror to public server. Pluncker Link to comment Share on other sites More sharing options...
Mike Kranzler Posted July 11, 2012 Share Posted July 11, 2012 Hi Pluncker, It's difficult to tell you a complete list of tables to transfer over without extensive knowledge of everything going into creating the products on your site, but here's a rough list of tables to consider: All ps_attribute tables All ps_category tables All ps_feature tables All ps_image tables All ps_manufacturer tables All ps_product tables All ps_scene tables All ps_specific_price tables All ps_supplier tables There may be a few others based on your specific product configurations, but that should be a good place to start. I hope this helps! -Mike Link to comment Share on other sites More sharing options...
Pluncker Posted July 11, 2012 Author Share Posted July 11, 2012 Thank you, Mike! Pluncker Link to comment Share on other sites More sharing options...
Mike Kranzler Posted July 11, 2012 Share Posted July 11, 2012 I'm glad I could help! Happy selling! -Mike 1 Link to comment Share on other sites More sharing options...
Recommended Posts