I have 4 stores with RMS system with HQ.
I setup as 1, 2, 3, 4 store ID in HQ. but fourth store has store ID 3 instead of 4.
so I tried to change store ID to 4 from 3 in store configuration multi-store.
but number 3 cannot be changeable.
Could you let me know how to change store ID so that It can be connected without any problem?
Thank you so much
Regards,
*This post is locked for comments
I'm not able to understand the case clearly, would you plz explain it further?
in all cases, the store id can't be changed once you the store database is exported and used, if the store database is not used yet, then u can change the store id and re-export the store database
If store 4 has a storied of 3 then what is the ID of store 3?
There are a few ways you can approach this, but no matter what direction you choose you will need to run queries on every table in the store database to either update or reset the StoreID in all the tables to 0 which will refresh the data and cause it all to sync back up to HQ. This shouldn't be a problem if the store has a decent HQ Client connection and a relatively small store database but can be an issue with larger dbs.
Essentially, you will remove the store from HQ by deleting it and running queries to eliminate records, then run queries at that store to update the storeID to zero or then new ID (don't forget the Configuration table storied and syncID). After all that, you can resync your store.
Connect database via sql management studio and checge it.
Share
Report
All responses (
Answers (
