How do I add a MSSQL database as a product?

If you provide Windows hosting as a service, you may wish to also provide Microsoft SQL databases to customers via HostShop.

To set an MSSQL database up, you’ll need to:

Log in to My20i

Head to Hostshop > Product Catalogue

• Select Add New > Product

Change Product Type to Web Hosting Add-ons

Change Add-on Products to MSSQL Database

We suggest a recommended price of £14.99, giving you a markup of £4.99. The original £10 price of an MSSQL database is the price of the licence provided directly by Microsoft. Select Create Product.

Next we’ll add an annual renewal option by clicking the Product Pricing tab and checking the text box under Annually from the menu. We’re going to offer a £2.00 per month discount if you pay yearly, so we’ll add the price £155.88 to the field and select Save.

If you now head to your shop, and then select to head to the Client Area, you’ll see the ability to order an MSSQL database.

Note: In order for a customer to order an MSSQL database they will need to have already purchased Windows hosting so the database can be assigned to the hosting package.