hbsys Posted January 12, 2018 Share Posted January 12, 2018 I used a backup of a multistore multi domain to build a new shop. there is 1 shop and 1 domain left. now the shop has left over shop_id 2. can I rename shop_id 2 to shop_id 1 possibly only in the ps_shop table this is immediately adjusted everywhere? Link to comment Share on other sites More sharing options...
musicmaster Posted January 13, 2018 Share Posted January 13, 2018 No. You can not. The id_shop is used in many tables. You would need to adapt it in all of them. In phpmyadmin you can export the structure of the database (not the data!) and then do a text search to find them all. Link to comment Share on other sites More sharing options...
musicmaster Posted January 13, 2018 Share Posted January 13, 2018 Be sure to make a backup when doing this kind of things. Link to comment Share on other sites More sharing options...
hbsys Posted January 14, 2018 Author Share Posted January 14, 2018 On 13-1-2018 at 12:17 PM, musicmaster said: Be sure to make a backup when doing this kind of things. Musicmaster thank you for the information, I had already started searching in the database and it is really everywhere. I made a clone of the current shop, exported the sql and search once where it all occurs. The reason for this question is that we have a tool for the synchronization of stock and import of orders, to our administration system. since this shop now has id 2 the synchronization does not work this is hardcoded to id 1. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now