Knowledgebase

Question

I have a v6 site that is up and running. I noticed that there have been some new config settings to later v6.0 releases as well as v6.1.

Is there some way I can add these new config settings directly to the live database?

Answer

Yes. CactuShop has an 'execute query' feature in the back end that lets you run SQL queries directly against the database. This can be used to insert the new records directly to your live database.

Enter the following queries (one at a time if your site uses MS Access, in one go for MS SQL) and submit them. Note that each should be one line of text, although they will wrap within the 'execute query' text area. Make sure you only copy the statements for config settings you are missing, otherwise you will get errors and the new settings will not be created.

-- v6.0 Config Settings (added since original v6 release)

INSERT INTO tblCactuShop1Config (CFG_Name, CFG_Value, CFG_DataType, CFG_DisplayType, CFG_DisplayInfo, CFG_Description, CFG_VersionAdded, CFG_DefaultValue, CFG_ConfigCategoryID)
VALUES ('myaccountaffiliates', 'o', 's', 's', 'on|off', 'Whether to show affiliates section in ''my account''.', 6.032, 'o', 25)

INSERT INTO tblCactuShop1Config (CFG_Name, CFG_Value, CFG_DataType, CFG_DisplayType, CFG_DisplayInfo, CFG_Description, CFG_VersionAdded, CFG_DefaultValue, CFG_ConfigCategoryID)
VALUES ('handlecategoryoverload', 'off', 's', 's', 'on|off', 'For sites with many hundreds of categories, the multiple dropdown selection on the back end may overload. If so, switch this setting on to replace it with a text box featuring comma-separated IDs.', 6.039, 'off', 31)

INSERT INTO tblCactuShop1Config (CFG_Name, CFG_Value, CFG_DataType, CFG_DisplayType, CFG_DisplayInfo, CFG_Description, CFG_VersionAdded, CFG_DefaultValue, CFG_ConfigCategoryID)
VALUES ('EPDQ_ProcessCurrency', 'GBP', 's', 't', '', 'the currency that orders will be passed to this gateway in - if blank, user-selected currency is used', 6.040, 'GBP', 44)

INSERT INTO tblCactuShop1Config (CFG_Name, CFG_Value, CFG_DataType, CFG_DisplayType, CFG_DisplayInfo, CFG_Description, CFG_VersionAdded, CFG_DefaultValue, CFG_ConfigCategoryID)
VALUES ('allowcoupons', 'y', 's', 'b', '', 'Whether to allow the customers to use discount coupons.', 6.042, 'y', 27)

INSERT INTO tblCactuShop1Config (CFG_Name, CFG_Value, CFG_DataType, CFG_DisplayType, CFG_DisplayInfo, CFG_Description, CFG_VersionAdded, CFG_DefaultValue, CFG_ConfigCategoryID)
VALUES ('enablewishlist', 'y', 's', 'b', '', 'Whether to use the wish list functionality in the shop. If you uncheck this, you need to remove the wish lish link in your template.htm to completety disable this.', 6.042, 'y', 25)

-- v6.1 Config Settings

INSERT INTO tblCactuShop1Config (CFG_Name, CFG_Value, CFG_DataType, CFG_DisplayType, CFG_DisplayInfo, CFG_Description, CFG_VersionAdded, CFG_DefaultValue, CFG_ConfigCategoryID)
VALUES ('enableunicode', 'n', 's', 'b', '', 'Set to yes to enable saving of Unicode text (arabic, chinese, hebrew, etc) to the database. Important: only change this if you''re using planning to use Unicode text.', 6.1, 'n', 34)

INSERT INTO tblCactuShop1Config (CFG_Name, CFG_Value, CFG_DataType, CFG_DisplayType, CFG_DisplayInfo, CFG_Description, CFG_VersionAdded, CFG_DefaultValue, CFG_ConfigCategoryID)
VALUES ('GOOGLE_MerchantID', '999999999999999', 's', 't', '', 'Your Google merchant ID.', 6.1, '999999999999999', 45)

INSERT INTO tblCactuShop1Config (CFG_Name, CFG_Value, CFG_DataType, CFG_DisplayType, CFG_DisplayInfo, CFG_Description, CFG_VersionAdded, CFG_DefaultValue, CFG_ConfigCategoryID)
VALUES ('GOOGLE_MerchantKey', 'MerchantKeyGoesHere', 's', 't', '', 'Your Google merchant key.', 6.1, '999999999999999', 45)

INSERT INTO tblCactuShop1Config (CFG_Name, CFG_Value, CFG_DataType, CFG_DisplayType, CFG_DisplayInfo, CFG_Description, CFG_VersionAdded, CFG_DefaultValue, CFG_ConfigCategoryID)
VALUES ('GOOGLE_ProcessCurrency', 'GBP', 's', 't', '', 'The currency that orders will be passed to this gateway in.', 6.1, 'GBP', 45)

INSERT INTO tblCactuShop1Config (CFG_Name, CFG_Value, CFG_DataType, CFG_DisplayType, CFG_DisplayInfo, CFG_Description, CFG_VersionAdded, CFG_DefaultValue, CFG_ConfigCategoryID)
VALUES ('GOOGLE_Status', 'test', 's', 's', 'on|off|test', 'Status for this gateway.', 6.1, 'off', 45)

INSERT INTO tblCactuShop1Config (CFG_Name, CFG_Value, CFG_DataType, CFG_DisplayType, CFG_DisplayInfo, CFG_Description, CFG_VersionAdded, CFG_DefaultValue, CFG_ConfigCategoryID)
VALUES ('GOOGLE_AuthorizedOnly', 'n', 's', 'b', '', 'Whether only authorized customers can access this payment method.', 6.1, 'n', 45)

INSERT INTO tblCactuShop1Config (CFG_Name, CFG_Value, CFG_DataType, CFG_DisplayType, CFG_DisplayInfo, CFG_Description, CFG_VersionAdded, CFG_DefaultValue, CFG_ConfigCategoryID)
VALUES ('enablemailinglist', 'y', 's', 'b', '', 'Whether to use the mailing list functionality in the shop. If you uncheck this, you need to remove the mailing list link in your template.htm to completely disable this.', 6.104, 'y', 32)

INSERT INTO tblCactuShop1Config (CFG_Name, CFG_Value, CFG_DataType, CFG_DisplayType, CFG_DisplayInfo, CFG_Description, CFG_VersionAdded, CFG_DefaultValue, CFG_ConfigCategoryID)
VALUES ('GOOGLE_ProxyURL', 'https://www.demo.xyz/payment/proxy/google.asp', 's', 't', '', 'The full URL (must be https) of your site''s google proxy script.', 6.104, 'https://www.demo.xyz/payment/proxy/google.asp', 45)

INSERT INTO tblCactuShop1Config (CFG_Name, CFG_Value, CFG_DataType, CFG_DisplayType, CFG_DisplayInfo, CFG_Description, CFG_VersionAdded, CFG_DefaultValue, CFG_ConfigCategoryID)
VALUES ('returnstocklevelfordeletedorders', 'y', 's', 'b', '', 'Whether to return stock levels on items in deleted orders.', 6.116, 'y', 27)

INSERT INTO tblCactuShop1ConfigCategories (CFGC_ID, CFGC_ParentID, CFGC_Category, CFGC_OrderByValue) VALUES (45, 10, 'Google Checkout', 0)

INSERT INTO tblCactushop1Config (CFG_Name, CFG_Value, CFG_DataType, CFG_DisplayType, CFG_DisplayInfo, CFG_Description, CFG_VersionAdded, CFG_DefaultValue, CFG_ConfigCategoryID) VALUES ('PROTXDIRECT_Status', 'test', 's', 's', 'on|off|test|fake', 'Status for the this gateway', 6.1, 'off', 51)

INSERT INTO tblCactushop1Config (CFG_Name, CFG_Value, CFG_DataType, CFG_DisplayType, CFG_DisplayInfo, CFG_Description, CFG_VersionAdded, CFG_DefaultValue, CFG_ConfigCategoryID) VALUES ('PROTXDIRECT_TxType', 'PAYMENT', 's', 't', NULL, 'The transaction type sent to protx. The default value is ''PAYMENT''. Please see latest protx documentation for more details.', 6, 'PAYMENT', 51)

INSERT INTO tblCactushop1Config (CFG_Name, CFG_Value, CFG_DataType, CFG_DisplayType, CFG_DisplayInfo, CFG_Description, CFG_VersionAdded, CFG_DefaultValue, CFG_ConfigCategoryID) VALUES ('PROTXDIRECT_AuthorizedOnly', 'n', 's', 'b', NULL, 'Whether only authorized customers can access this payment method.', 6.1, 'n', 51)

INSERT INTO tblCactushop1Config (CFG_Name, CFG_Value, CFG_DataType, CFG_DisplayType, CFG_DisplayInfo, CFG_Description, CFG_VersionAdded, CFG_DefaultValue, CFG_ConfigCategoryID) VALUES ('PROTXDIRECT_URL', 'https://ukvpstest.protx.com/vspgateway/service/vspdirect-register.vsp', 's', 't', NULL, 'Protx Direct payment URL. https://ukvpstest.protx.com/vspgateway/service/vspdirect-register.vsp for testing, https://ukvps.protx.com/vspgateway/service/vspdirect-register.vsp for live transactions.', 6.1, 'https://ukvpstest.protx.com/vspgateway/service/vspdirect-register.vsp', 51)

INSERT INTO tblCactushop1Config (CFG_Name, CFG_Value, CFG_DataType, CFG_DisplayType, CFG_DisplayInfo, CFG_Description, CFG_VersionAdded, CFG_DefaultValue, CFG_ConfigCategoryID) VALUES ('PROTXDIRECT_VendorID', 'testvendor', 's', 't', NULL, 'Protx Direct vendor ID - they will supply this to your with your account details.', 6.1, '', 51)

INSERT INTO tblCactushop1Config (CFG_Name, CFG_Value,CFG_DataType, CFG_DisplayType, CFG_DisplayInfo, CFG_Description, CFG_VersionAdded, CFG_DefaultValue, CFG_ConfigCategoryID) VALUES ('PROTXDIRECT_3DCallbackURL','https://ukvpstest.protx.com/vspgateway/service/direct3dcallback.vsp','s','t',NULL,
'Protx Direct payment 3D Callback Page. https://ukvpstest.protx.com/vspgateway/service/direct3dcallback.vsp for testing, https://ukvps.protx.com/vspgateway/service/direct3dcallback.vsp for live transactions.',6.1,'https://ukvpstest.protx.com/vspgateway/service/direct3dcallback.vsp',51)

INSERT INTO tblCactushop1ConfigCategories (CFGC_ID, CFGC_ParentID, CFGC_Category, CFGC_OrderByValue)
VALUES (51,10,'Protx Direct',0)

INSERT INTO tblCactushop1Config (CFG_Name, CFG_Value, CFG_DataType, CFG_DisplayType, CFG_DisplayInfo, CFG_Description, CFG_VersionAdded, CFG_DefaultValue, CFG_ConfigCategoryID) VALUES ('froogleproductcondition', 'new', 's', 't', NULL, 'The value to use for the Googlebase condition attribute.', 6.1, '', 31)

INSERT INTO tblCactushop1Config (CFG_Name, CFG_Value, CFG_DataType, CFG_DisplayType, CFG_DisplayInfo, CFG_Description, CFG_VersionAdded, CFG_DefaultValue, CFG_ConfigCategoryID) VALUES ('googleanalyticspropertyID', '', 's', 't', NULL, 'The Google Analytics web property ID for your account.', 6.156, '', 24)

Once you have added these, you will need to edit each in the back end to set it to the appropriate value. At least one config setting edit is required before these values actually go live on your site.

Can't find the answer you need? Click here to open a support ticket.