In the event Hera will not accept an address and sticks at "verifying" AND old system work around fails.


In SQL go into datasql and filter under tables - You are looking for tbl-Store-Data


Using this spirit I just changed as an example:


where [S-Data_Store-Code] = '61411sh' will filter so you can see existing


The fields you most commonly will need are 


  • S-Data_Address
  • S-Data_City
  • S-Data_Zip
  • S-Data_State
  • S-Data_Store-Code


Execute the following command substituting YOUR data for the spirit data in this example:



UPDATE [tbl-Store-Data] SET [S-Data_Address] = '12103 US-19', [S-Data_City] = 'Hudson',  [S-Data_Zip]  = '34667' WHERE [S-Data_Store-Code]= '61411sh'


Change fields as needed, [example maybe you need to edit state as well]


Note, may need to update county as well for tax reasons. Finding out parameters.