Kartris ON CLOUD

1-click AWS Deployment    1-click Azure Deployment



Overview

Kartris is an opensource ASP.NET web application for running online stores. The system is entirely featured e-commerce CMS (content management system) that can store and display product and other data to customers, and has the e-commerce elements that allow items to be selected and purchased, and orders to be processed. Kartris is written in VB.NET ‘web forms’ with an MS SQL 2008+ database, and as such must be hosted on an MS Windows Server running the Microsoft IIS web server for production deployment, although it can be run for development and test purposes on a variety of Windows installations. The software consists of three main elements:

  • The pages, controls, business logic, templates and other files (including full source code) that run the site
  • The database, which stores all product, customer and other data, and the associated code (including stored procedures and the data access layer)
  • Other product specific files such as uploaded product images, downloadable files, etc.

Kartris has a contemporary, user-friendly interface that makes use of AJAX to deliver a fast, feature-rich experience that works on all modern browsers.

3 things Kartris does that your current e-commerce package probably doesn’t

Handles HUGE product catalogues of 1,000,000+ items

While many systems can easily handle a few hundred products, very often they have not been designed for, or tested with databases containing hundreds of thousands, or even millions of items. Kartris was developed from the beginning to handle this number of items, with careful consideration given to the database design, indexing and stored procedures. The performance and optimization required to run fast even on huge sites means lightning fast response on much smaller sites.

Search

Search also become far more critical on sites with 10s or 100s of thousands of products. Few customers browse through several levels of categories; instead they search for what they want as they would on Google – with a simple phrase, including the main details. Most e-commerce packages have simple ‘and/or’ searches, but with these you either end up with many ‘no results’ responses (because people have one word in the search that is misspelled or not in any products), or an overwhelming number of results because of a common word in the search phrase which almost every record contains. Worse still, the results are not sorted in any particular order. The Kartris search is far more sophisticated; it returns ‘best match’ results, so the results that contain more of the search terms, especially in important fields like the product name, come top.

Allows almost any kind of product interface

Kartris has a variety of product types, from single SKU products, multiple version products, products with options and products with combinations. But now and then, it’s not possible to fit your products into these types, and end up with the interface and functionality you want, especially if you need to calculate the product price based on some kind of lookup in a table. For such occasions, it’s possible to build and deploy custom controls. These are standard .NET user controls which can feature whatever interface you desire, and whatever programming logic you require. They can pull configuration from third party databases, lookup pricing or features in an Excel spreadsheet or a web service. Virtually any kind of custom code can be embedded, as long as the control outputs a price, SKU and string of details.

 

Database admin

   Kartris has a back end section dedicated to various database related tasks. To access this, go to ‘Configuration > Database Admin’.You may find that some tabs referred to below are not visible when you log in. In this case, the backend.expertmode config setting is probably off. This setting hides some back end features, even to those with ‘config’ user permissions. You can edit the config setting to turn on expert mode, which will show advanced tabs in the db admin section.

Expert mode also allows you to edit certain field details of config settings and language strings that are normally hidden.

Home screen

   From here you can restart Kartris. This works by making a minor change to the web.config file and saving it – ASP.NET will restart a site when this file is changed. Therefore it only works if your site has write permissions to the root. If you need to restart Kartris and this does not work, you can manually change the web.config via FTP.

Clear data

   This provides an easy way to clear data related to products, orders or sessions. For each type of deletion, the system knows which tables should be cleared.Where possible, avoid clearing individual tables directly in the database unless you’re absolutely sure you understand the consequences. There are some tables in Kartris (such as config settings and language strings) that should always have data, even in a new install that has no products or customer records.Deleting data from some tables without understanding the relationships can also leave orphan records behind. For example, version records always link to a parent product. If you delete all data from the products table only, you would end up with many orphan records from versions, language elements (the language specific content of products like descriptions and names), related products, etc.

Run query

This provides an easy way to run a query against the database. You can user SELECT, INSERT, DELETE or UPDATE queries.SELECT queries will return results in a tabular format.

Data export

   From time to time, you may need to export data from Kartris to a file. This might be anything from a customer list, order details, product inventory or statistical data for external analysis. Kartris provides both a built-in export for customers/orders, as well as a flexible export system that lets you write your own custom exports and save them within Kartris.

Orders export

   

You can specify a date range, the file name you wish to export as, the delimiter (marker) for each field and that indicates string values (non-numeric / text as opposed to numbers). You can optionally include the full order details field (text of the confirmation email to customer stored in the system) and incomplete orders (orders where the status checkbox ‘complete’ is not yet checked to indicate the order has been fully processed).

The file format is CSV – comma-separated values. This is a text format which spreadsheet programs such as MS Excel and Libre Office Calc can open. If you find data shows up in the spreadsheet with single quotes around values, try exporting again but select a double-quote as the ‘string delimiter’.

Custom exports

 Custom exports are saved reports that you can run to output specific data that you need. If you go to the ‘Saved Exports’ tab, you can see some pre-written custom exports that come as standard within Kartris – clicking on edit will allow you to see how these are constructed. An export requires the following information:

 

  • Export name (any name will do, it just lets you identify this export in a list)
  • Field delimiter (separator between different data values, normally a comma)
  • String delimiter (the marker around text / non-numeric values – experiment with a single or double-quote and open up the resulting file in your spreadsheet program such as Microsoft Excel – if you see the single or double-quote mark around data, then try using a different delimiter)
  • Database query

The database query is the key part of the export. This uses ‘structured query language’  (SQL), which is a standard common language that is largely similar on different types of databases to specify which data is to be exported. A full explanation and grounding in writing SQL queries is beyond the scope of this manual, but there are plenty of books and web sites dedicated to the subject.

Microsoft Access and MS SQL Management Studio also include graphical tools to help you build queries.
Advanced users may also prefer to create stored procedures and then call these from the saved export – our standard ‘Products data for data tool’ export which is included in a default installation uses this method

Tools

   This gives an overview of your database, and lets you back it up. Note that this fires the backup facility within MS SQL server. It does not enable a remote backup. You should discuss with your hosting provider about the best way to obtain an off-server back up of your MS SQL database.The page shows the root of the current web, which can help you format the correct path to create the backup file in the correct location within your web in order to let you download it with FTP.

.

Full-text search (FTS)

   MS SQL has a feature called ‘full text search’ that significantly improves the performance of text searches across data, especially on very large databases with many records. This feature of MS SQL is installed with the ‘advanced services’ version, and therefore may not be available on all installations. For this reason, we don’t activate it as standard. On smaller sites, the performance different with and without FTS isn’t significant. You will probably find it simpler not to use this feature.But larger sites will get a huge benefit from this; especially when you have tens of thousands of items, or more.Before attempting to activate this feature, check that your server supports it by expanding your database and looking for the ‘full text catalogs’ folder, as shown below.
If the feature is supported, clicking the link within the FTS tab in your Kartris back end will create the required stored procedures and activate the feature. Searches in both the front and back ends of Kartris will use FTS. For this reason, even stores with a relatively small number of products but with a large customer/order database may also decide to use FTS to improve performance of back end searches.

 

Kartris is an open-source, ASP.NET 4.5 e-commerce system written in VB (Web Forms) and with an MS SQL database back end. It is optimized to handle sites with 1,000,000+ SKUs out-of-the-box, though it’s simple and flexible enough for sites which just have a handful of products.

The latest version (v2.9) includes a fully-responsive front end based on Zurb’s Foundation platform, enabling mobile and tablet support via a single unified front end.

Mobile view   Mobile view   Mobile view

Mobile view   Mobile view

Custom product controls

Kartris has support for plug-in product configuration controls which developers can create in VB and easily incorporate into the site for certain products. For example, you could create a tool that can let a customer choose the height, width and thickness of material for a sign, choose the material and wording, and calculate a price in real time based on a lookup in a spreadsheet or an algorithm, and then add this customized item to the basket to be checked out and purchased like any other product (and together with other ‘normal’ products too). The system is completely flexible – all you need to do is to be able to configure a name, description (dimensions, options and so on), price and quantity to send to the basket and Kartris will take care of the rest.

Back End

There is a fully-featured back end to control all aspects of the store. It includes a unified search, treeview navigation and is optimized to handle hundreds of orders per day and a million-plus products.

Kartris back end

Architecture

Kartris is built on a multi-tier model, with database, stored procedures, DAL, BLL and front end. Visual customization is via ‘skins’, a combination of master pages and CSS. The database is structured with no limit on the number of languages or currencies that can be used. The database has been optimized so that the software is capable of running stores with well over a million SKUs out-of-the-box. The back end has been refined to handle hundreds of orders per day, and to make managing huge catalogues feasible.

Licensing

Kartris was previously only available on a proprietary license. From v2 onwards, it is available under both the GPL v2 and the Kartris Commercial License (proprietary).

Kartris is a free ASP.NET web application for running online stores. The system is fully featured e-commerce CMS (content management system) that can store and display product and other data to customers, and has the e-commerce elements that allow items to be selected and purchased, and orders to be processed.

 

kartis_2008_10

 

Kartris is written in VB.NET ‘web forms’ with an MS SQL 2008+ database, and as such must be hosted on an MS Windows Server running the Microsoft IIS web server for production deployment, although it can be run for development and test purposes on a variety of Windows installations. The software consists of three main elements:

 

The pages, controls, business logic, templates and other files (including full source code) that run the site
The database, which stores all product, customer and other data, and the associated code (including stored procedures and the data access layer)
Other product specific files such as uploaded product images, downloadable files, etc.
Kartris has a modern, user-friendly interface that makes use of AJAX to deliver a fast, feature-rich experience that works on all modern browsers.

Features

Major Features of Kartris

1. Support systems: Kartris contains built-in facilities to handle customer support through your web site.

These include a searchable knowledgebase system that you can load up with articles relating to specific products or technical issues, and a support ticket system that allows you to handle support from customers in a managed way, instead of via a slew of emails.

2. Stock notifications: The stock notifications system was added to Kartris with version v2.9005. It allows items that are out of stock to display a ‘notify me’ button. Users can click this, and enter their email address into the popup that appears. When the item is back in stock, the user will receive an email to tell them. 

AWS

Installation Instructions For Ubuntu

Note : 1. Please use “Kartris” in the place of “stack_name

             2. How to find PublicDNS in AWS

A) Application URL: Access the application via a browser at      http://PublicDNS/Kartris

  •  Username: ec2-user
  •  Passward: Passw@rd123

B) Steps to access the  Admin Panel:

  • To login to Kartris  Administrative Panel, you need
    to open your browser and navigate to http://PublicDNS/Kartris/admin
  • Enter username and password in the given fields and click on the“Login”button to access the Admin Panel.
  • After successful login to the Admin Panel, you will get access to Kartris Dashboard.

C) SSH Connection: To connect to the operating system,

1) Download Putty.

2) Connect to virtual machine using following SSH credentials :

  • Hostname: PublicDNS  / IP of machine
  • Port : 22

Username: To connect to the operating system, use SSH and the username is ubuntu.
Password : Please Click here  to know how to  get password .

D) Other Information:
Default installation path: will be on your web root folder “/var/www/html/Kartris” ( Please see above Note for stack name)
2.Default ports:

  • Linux Machines:  SSH Port – 22 or 2222
  • Http: 80 or 8080
  • Https: 443
  • Sql or Mysql ports: By default these are not open on Public Endpoints. Internally Sql server: 1433. Mysql :3306

E)Database Login Details :

  • SQL Username : sa
  • SQL Password : Passw@rd123


Note :-Please change password immediately after first login.

Configure custom inbound and outbound rules using this link

 


Installation Instructions For Windows

Note : 1. Please use “Kartris” in the place of “stack_name

2. How to find PublicDNS in AWS

A) Application URL: Access the application via a browser at      http://PublicDNS/Kartris

  •  Username: ec2-user
  •  Passward: Passw@rd123

B) Steps to access the  Admin Panel:

  • To login to Kartris  Administrative Panel, you need
    to open your browser and navigate to http://PublicDNS/Kartris/admin
  • Enter username and password in the given fields and click on the“Login”button to access the Admin Panel.
  • After successful login to the Admin Panel, you will get access to Kartris Dashboard.

C) RDP Connection: To connect to the operating system,

1) Connect to virtual machine using following RDP credentials :

  • Hostname: PublicDNS  / IP of machine
  • Port : 3389

Username: To connect to the operating system, use RDP and the username is Administrator.
Password : Please Click here  to know how to  get password .

D) Other Information:

1.Default installation path: will be on your web root folder “C:\inetpub\wwwroot\Kartris
2.Default ports:

  • Windows Machines:  RDP Port – 3389
  • Http: 80
  • Https: 443
  • Sql or Mysql ports: By default these are not open on Public Endpoints. Internally Sql server: 1433. Mysql :3306

E) Database Login Details :

  • SQL Username : sa
  • SQL Password : Passw@rd123

Note :-Please change password immediately after first login.

Configure custom inbound and outbound rules using this link

AWS Step By Step Screenshots

 

kartis_2008

 

kartis_2008_2

 

kartis_2008_3

 

kartis_2008_4

 

kartis_2008_5

 

kartis_2008_6

 

kartis_2008_11

 

kartis_2008_9

 

kartis_2008_10

 

kartis_2008_13

 

kartis_2008_8

 

 

 

kartis_2008_public_6

 

kartis_2008_public_7

 

kartis_2008_public_8

 

kartis_2008_public_9

 

kartis_2008_public_3

 

kartis_2008_public_4

 

Azure

Installation Instructions For Ubuntu

Note : 1. Please use “Kartris” in the place of “stack_name

             2. How to find PublicDNS in Azure

A) Application URL: Access the application via a browser at      http://PublicDNS/Kartris

  •  Username: azureuser
  •  Passward: Passw@rd123

B) Steps to access the  Admin Panel:

  • To login to Kartris Administrative Panel, you need
    to open your browser and navigate to http://PublicDNS/Kartris/admin
  • Enter username and password in the given fields and click on the“Login”button to access the Admin Panel.
  • After successful login to the Admin Panel, you will get access to Kartris  Dashboard.

C) SSH Connection: To connect to the operating system,

1) Download Putty.

2) Connect to virtual machine using following SSH credentials :

  • Hostname: PublicDNS  / IP of machine
  • Port : 22

Username: Your chosen username when you created the machine ( For example:  Azureuser)

Password : Your Chosen Password when you created the machine ( How to reset the password if you do not remember)

D) Other Information:
Default installation path: will be on your web root folder “/var/www/html/Kartris” ( Please see above Note for stack name)
2.Default ports:

  • Linux Machines:  SSH Port – 22 or 2222
  • Http: 80 or 8080
  • Https: 443
  • Sql or Mysql ports: By default these are not open on Public Endpoints. Internally Sql server: 1433. Mysql :3306

E)Database Login Details :

  • SQL Username : sa
  • SQL Password : Passw@rd123

Note :-Please change password immediately after first login.

Configure custom inbound and outbound rules using this link

 


 

Installation Instructions for Windows

Note :1. Please use “Kartris” in the place of “stack_name

2.How to find PublicDNS in Azure

A) Application URL: Access the application via a browser at      http://PublicDNS/Kartris

  •  Username: azureuser
  •  Passward: Passw@rd123

B) Steps to access the  Admin Panel:

  • To login to Kartris Administrative Panel, you need
    to open your browser and navigate to http://PublicDNS/Kartris/admin
  • Enter username and password in the given fields and click on the“Login”button to access the Admin Panel.
  • After successful login to the Admin Panel, you will get access to Kartris  Dashboard.

C) RDP Connection: To connect to the operating system,

1) Connect to virtual machine using following RDP credentials :

  • Hostname: PublicDNS  / IP of machine
  • Port : 3389

Username: Your chosen username when you created the machine ( For example:  Azureuser)
Password : Your Chosen Password when you created the machine ( How to reset the password if you do not remember)

D) Other Information:

1.Default installation path: will be on your web root folder “C:\inetpub\wwwroot\Kartris 
2.Default ports:

  • Windows Machines:  RDP Port – 3389
  • Http: 80
  • Https: 443
  • Sql or Mysql ports: By default these are not open on Public Endpoints. Internally Sql server: 1433. Mysql :3306

E) Database Login Details :

  • SQL Username : sa
  • SQL Password : Passw@rd123


Note :-Please change password immediately after first login.

Configure custom inbound and outbound rules using this link

 

 

Video

 

Kartris ON CLOUD

Related Posts