how to delete store id

Make a backup before you do anything:

Execute following query

update configuration set Syncid=0

thank you for your response, my problem is where I deleted a store, the store id remains in the Item properties- Store quantity and store tax. can this be removed i am using RMS 1.3 refresh. Tried the query but no dice.

It sounds like you are trying to delete the itemdynamic records for stores that no longer exists:

delete d from itemdynamic d left join store s on storeid=s.id where s.id is null and quantity=0 and snapshotquantity=0

disclaimer: modifying your table like this is a bit drastic, so you should take precautions to avoid unwanted results: backup your database, use select query statements before the update to make sure this will change it to what you want, if you are not familiar with directly modifying your tables you should get help, etc.

"Tr> thank you for your response, my problem is where I deleted a store, the store