Migrate back from multistore to single store? How?

[Ste00]

We setup our site using the new multistore functionality thinking it would be a good idea... its caused so many issues its now come to the point that the site has been live 2 days and we need to find a way to migrate back to a single shop.

 

At the moment we are running 1.5.2 is there any easy way to migrate to a single store install or would it have to be a fresh install and then migrate the products, customers ect from the multistore db?

[dpatty]

I have the same issue.

I thought upgrading would have a fix for it. I tried to upgrade to 1.5.3, it went bad and had to restore the site back to 1.5.2

 

Idea #2 I thought maybe they got all that fixed in 1.5.3.1, it went even worse. Still picking up the pieces from that bad idea.

 

Idea #3. Do a fresh install of 1.5.3.1 and just copy over the database. My whole site didn't crash so that was a plus. However, it copies the issue to the new install and you still cannot go back to a single store mode and have it work like before.

 

Hope somebody figures this out soon

[dpatty]

Ok, finally figured this out.

First go to Advanced Parameters - Multishop. You have to unshare everything then disable group default.

Then go to preferences and select no for use multi shop.

Then goto Catalog - Products and see you now have no inventory. You will need to edit all of them to either manually select quantity or use advanced stock management.

[Trip]

In multitstore mode the product quantities are stored in ps_stock_available if you do not use advanced stock management

To revert to single store your basically only have to copy the quantities from ps_stock_available to the product.quantity. You can achieve that with a couple of lines code quite easy-

I hope ps will implement such a function in future.

Regards, trip