Start a conversation Sign in
Start a conversation
  1. Digital Retail Solutions
  2. Self Service KB
  3. SQL Server

Clone Store Ops db for use at new store location (non-HQ)

Backup db and restore at new location running same version of RMS.
Clear transactions using Administrator.
Set all inventory to zero using Wizard or script.
If any items show negative qty they are likely non-inventory items that were once standard items which were not zeroed before changing item type. Change back to standard, clear committed qty, save changes, change back to non-inventory.
 
If customer accounts will not be retained --
 
If V.I.P Zone was installed for HQ run these scripts one at a time.
DROP TABLE DRS_Customer
DROP TABLE DRS_StoreCustUpdate
DROP TABLE DRS_ShipTo
 
Afterwards run these scripts.
DELETE FROM Customer 
DELETE FROM ShipTo
 
 
Choose files or drag and drop files
Was this article helpful?
Yes
No

  1. Dave J

  2. Posted
  3. Updated

Comments