HomeHome Product Discus... Product Discus...RazorCartRazorCartAdding new items to the regions dropdownsAdding new items to the regions dropdowns
Previous
 
Next
New Post
5/8/2019 2:08 PM
 

RazorCart uses the pre-configured region list in DNN to keep the country/region synced correctly with users, I see that they forgot to add some values there for Hong Kong, these value are stored in the DNN table “dbo.Lists”

 

SELECT * FROM [Lists] WHERE [ListName] = 'Country' AND [Text] = 'Hong Kong'

 

SELECT * FROM [Lists] WHERE [ListName] = 'Region' AND [ParentID] = (

SELECT [EntryID] FROM [Lists] WHERE [ListName] = 'Country' AND [Text] = 'Hong Kong'

)

 

I would suggest adding new regions for Hong Kong manually through the SQL console:

 

INSERT INTO [Lists]

([ListName],[Value],[Text],[ParentID],[Level],[SortOrder],[DefinitionID],[Description],[PortalID],[SystemList],[CreatedByUserID],[CreatedOnDate])

VALUES

     ('Region', 'ID', 'Islands', 89, 0, 0, -1, NULL, -1, 1, -1, GETDATE()),

     ('Region', 'KTD', 'Kwai Tsing', 89, 0, 0, -1, NULL, -1, 1, -1, GETDATE()),

     ('Region', 'ND', 'North District', 89, 0, 0, -1, NULL, -1, 1, -1, GETDATE()),

     ('Region', 'SKD', 'Sai Kung', 89, 0, 0, -1, NULL, -1, 1, -1, GETDATE()),

     ('Region', 'STD', 'Sha Tin', 89, 0, 0, -1, NULL, -1, 1, -1, GETDATE()),

     ('Region', 'TPD', 'Tai Po', 89, 0, 0, -1, NULL, -1, 1, -1, GETDATE()),

     ('Region', 'TWD', 'Tsuen Wan', 89, 0, 0, -1, NULL, -1, 1, -1, GETDATE()),

     ('Region', 'TMD', 'Tuen Mun', 89, 0, 0, -1, NULL, -1, 1, -1, GETDATE()),

     ('Region', 'YLD', 'Yuen Long', 89, 0, 0, -1, NULL, -1, 1, -1, GETDATE()),

     ('Region', 'KCD', 'Kowloon City', 89, 0, 0, -1, NULL, -1, 1, -1, GETDATE()),

     ('Region', 'KOD', 'Kwun Tong', 89, 0, 0, -1, NULL, -1, 1, -1, GETDATE()),

     ('Region', 'SSPD', 'Sham Shui Po', 89, 0, 0, -1, NULL, -1, 1, -1, GETDATE()),

     ('Region', 'WTSD', 'Wong Tai Sin', 89, 0, 0, -1, NULL, -1, 1, -1, GETDATE()),

     ('Region', 'YSMD', 'Yau Tsim Mong', 89, 0, 0, -1, NULL, -1, 1, -1, GETDATE()),

     ('Region', 'CWD', 'Central and Western', 89, 0, 0, -1, NULL, -1, 1, -1, GETDATE()),

     ('Region', 'ED', 'Eastern District', 89, 0, 0, -1, NULL, -1, 1, -1, GETDATE()),

     ('Region', 'SD', 'Southern District', 89, 0, 0, -1, NULL, -1, 1, -1, GETDATE()),

     ('Region', 'WCD', 'Wan Chai', 89, 0, 0, -1, NULL, -1, 1, -1, GETDATE())

 

 

** 89 is the EntryID for Hong Kong. And do not forget to clear the cache after inserting the new data


At your service,
Dave Smith
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
Previous
 
Next
HomeHome Product Discus... Product Discus...RazorCartRazorCartAdding new items to the regions dropdownsAdding new items to the regions dropdowns