Changing Store In Sql Directly

Developers Dev talks
1

Hi,

I have 3 shops and one catalogue only (no sales) running from my database. When products are loaded up I always attached them to one store (store 1) only however over time products seem to be be listed as other stores being the prime owner of the product. As I am closing one store I would like to go directly into the SQL database and change all the store 3 to store 1. Then in the future remove store 3 totally.

I understand that if I just delete store 3 any products attached to it will also delete but these are currently shared with the other stores so I do not want this to happen.

If anyone knows any problems this may cause I would appreciate your comments.

I am trying to avoid having to reenter the products as there is over 400 of them.

Thanks Fran

2

We suggest you to use export/import feature instead of making changes in the database. It can cause a lot of unexpected issues (like missed product attributes, etc)

3

We suggest you to use export/import feature instead of making changes in the database. It can cause a lot of unexpected issues (like missed product attributes, etc)

Thanks for the tip. Just to confirm - if I use the bulk export and re-import with the "owning" shop amended to the one I require - this is all I need to do.

Thanks again, Fran

4

Thanks for the tip. Just to confirm - if I use the bulk export and re-import with the "owning" shop amended to the one I require - this is all I need to do.

Thanks again, Fran

Yes, you are right. The only thing which I am not sure is that if the product will be updated or duplicate will be created. Please try with one product and post the result here

5

Hi

I finally tested this and it does create new products if you reload via bulk import. I also did some work making sure the category fields where OK. I miss typed some categories so ended up with some odd new ones. I then corrected product by product to the correct categories and deleted the newly created categories. I needed to delete duplicates products. It is only important if you are worried about search engine listings, bookmark links customers might have on their computers or use the old product item numbers for some reports.

With the new entries you can still sell them but they have a new address.

So as I had a few (18) at one shop I changed these in the actual database via Cpanel by typing in the preferred store number. I then went to each product and checked the categories they were listed in. A few changes/corrections where required. I looked at a few tables involving products and or categories for these 18 and nothing looked too bad. I looked at the products in the shops and looked OK.

I WOULD NOT RECOMMEND any of this unless you are brave and are willing to put up with any unknown consequences.