1. Introduction.
The world of trade has new dimensions nowadays - the E-commerce. It is the fastest
developing marketing of all times. E-commerce has no borders, no time, no place.
E-commerce allows traders to have their storehouses non-stop open - no
physical borders, no time zones, no need of huge stores or to employ lots
of personnel. All traders need is advertising their products in Internet.
On the other hand customers may find what they need - products or
services - for the shortest time - the time needed to click the mouse.
All problems from the past - lack of protection or secured Internet payment
system - are already history.
EDA Ltd. provides specialized E-commerce solutions which make it easier for
traders and customers to offer and look for products and services providing
protected payment transactions.
These are systems, ordered by clients as well as EDA own solutions [screens]. Our experience
up to now allowed us to start developing some basic modules of E-commerce Internet
site thus enabling us to develop projects ordered by clients, interested in such
systems. Using "system" further on we shall mean the whole set of systematic and
applied programme means constituting the E-commerce Internet site.
2. Elements.
The system is aimed at E-commerce via Internet of products, goods or
services offered to customers providing contracting their sale upon orders
placed and following their execution through the following means:
- Products.
- Users and Customers.
- Basket and orders.
- Additional elements.
a) Products.
Products are the basic object of E-commerce sites. They can also be goods or services. Products
can be placed in groups in three levels, they can also be described and
propertyized, and have their sales price fixed.
- The system products are organized hierarchically in
three levels – stores, departments and products.
Hierarchical Structure of Products
The products organization in such a structure allows their easy
management and placing them in different pages for fast search, find and view.
To make the system more flexible a product may be placed in more than one department
and a department may be placed in several stores.
- Products have an additional system describing their
properties, organized in categories and attributes.
Organization of products attributes in categories
- Every product is attached to a store and his attributes are
only these attributes, which define the store.
Product <-> Attributes connection
Every page of e-commerce part of the public site is convenient for clients - they have a
possibility to access products easy. So they can find what they look for.
These are possibilities of doing search:
o left-side menus about stores, pricelists - with
information from the database;
o names of products' manufacturers are extracted from
database and are shown in left-side menu also;
o shown products on every page reloading are different.
Next to the product are his price and “buy now” button to add the product to the basket
immediately.
o the products have a little image so the clients can
have the information about the product better than only from product's name;
o there is a possibility to make search by string or a
part of a sting on every page;
o top sellers are shown on every page and depend on its
content. If the client looks at “monitors”, in this menu are shown monitors.
It is very convinient that if the client is an registered customer and is logged in, his
basket with information about its content is shown on every page.
There is a little horizontally menu which “remembers” where the client comes from. So the
navigation is very easy.
Products categorization allows flexible description of their properties and provides
the system with additional search criteria (filtering) applied to the catalogue information.
ÎJoining properties in categories allows the system to display comparative information
on group of products (chosen by the customer) on different WEB pages which allows the
customer to choose quickly the product meeting his criteria.
- Products [screens] are described with respect
to name, description, overview, part number of the retailer and the manufacturer, expire
date and etc.
- There is information on every product price,
comprising of:
o End price - price for end-users;
o Sale price - in case product is in promotion;
o Dealer price - level 1;
o Dealer price - level 2, higher discount;
o Currency – the currency of the price; it may differ
the currency of the transaction.
o Date – îthe date when the prices become into force.
The system stores information on past product prices which allows entering of “future” prices,
i.e. prices which shall become valid on a specific date and time in the future. Customers
are always being displayed the up-to-date price, i.e. the price valid on the current date
and time.
The system allows saving product prices in several different currencies for traders
convenience. The moment an order is placed prices are calculated in the currency of the
transaction (in Bulgaria it is BGN) using the current exchange rate.
- Every product, department or store may have an “image”
(one or several) of GIF, JPG or SWF (Flash animation) format to be displayed on the
relevant product pages thus contributing to their attractiveness.
b) Users and Customers.
Every visitor to the WEB site is a system's user. He may view all products, their
end-prices, to download price-lists for end-users. He may also choose the product
he wants to purchase from the so called market basket or simply basket but he is not allowed
to do shopping.
Customer is every system's user who have registered with the system. He may get
use of any services offered on the WEB site, the most important being shopping and
following the status of the orders he has placed.
- The information on registered customers includes:
o User name - used for identification in the system;
o Password – used for authentication by the system;
o E-mail address - used for correspondence with the client;
o Contact name - used in the correspondence.
- While working every customer may save its own address
information [screen] in the so called address book, namely:
o Preferred shipping address;
o Preferred billing address;
o Aditional addresses which can be used either for the
shipping or for billing purposes.
This address information is accessible on the page where the customer's personal
data [screen] is
and he can change it /by adding new addresses and/or deleting old ones/ whenever he wants.
- Every new customer acquires the status of an “end user”
and he can see only the end and promotional prices of the products. “The level”
of a client may be changed anytime to:
o Invalid client - the client is deprived of shopping
and has no access to his personal data and orders he has placed;
o End-user - basic level (granted at the time of registration);
o Dealer - dealer level;
o Dealer - dealer level with higher discount.
Customers from different level have different access to price information [screens] and
to documents containing products price-lists.
- The system allows storing and placing at customer's
disposal price-lists and other documents (brochures, user's manuals, audio and
video, etc.) Each price-list or document is being assigned an accessed level which
corresponds the customers' levels.
- For the purpose of easy search and find the
price-lists and the documents are organized in sections. When a document is uploaded
in the database the system automatically recognizes and records:
o Its type (if it's a text file, document, Flash
animation, audio or video file);
o Its name;
o The document's size in bytes.
Customers at a particular level have access only to documents corresponding to their
level and the sublevels. End-users don't have access to dealers' price-lists while dealers
may download the price-lists for end-users.
c) Basket and orders.
The basket [screen] is the place where users and clients put the products which
they intend to purchase. The basket information is kept long enough after user's log-out
of the system so that every time the user logs-in again he can access it, browse it and
put or remove products. This process is not time-limited.
The basket content is as follows:
- User/customer id;
- Basket creation date;
- Products quantity;
- List of products with every product:
o Product id and name;
o Quantity, price (in the currency of the price-list)
and value;
o .. etc.
The moment the customer decides to buy these products and upon entering the
information necessary to make the sale, the basket transforms into order. The
order includes details on:
- Basket content:
o Shipping cost;
o Tax;
o VAT;
o Total value of the order.
- Address information of shipping and billing;
- Shipping method;
- Payment method;
- rder status (initially is “placed”).
Any moment the customer may track his order [screen] and have information on date and time
its status has been changed. Information is saved on every status the order has passed,
namely:
- The status itself - placed, approved, processed,
fulfilled, shipped, removed;
- Date of status change;
- Additional information.
d) Additional elements.
Apart from the basic modules the system is able to manage additional information,
necessary to add to the website content. This allows adding of new functions to
contribute to system's attractiveness.
At the moment these modules are:
- Help [screen] – management
of the most frequently asked question by the clients (grouped by themes) and their
organization in a convenient form with respect to their use;
- News [screen] – enter and edit company news
(grouped by sectors);
- Questions and answers / Q & A / [screen] - information
about site operating and its advantages;
- Clients [screen] – a list with clients' references
(grouped by industry) thus showing the company's portfolio of satisfied clients;
- Projects [screen] – a list and description of company's
projects thus advertising company's achievements.
3. General structure.
The website consists of several web pages linked via a system of menus and hyperlinks
providing convenient and fast navigation. Most of the pages are dynamic which means
their content is not static but is dynamically generated every time on the basis of the
up-to-date information retrieved from the database.
The Internet site consists of two parts:
- Public site [screen] which is the site visited
and servicing the users and clients;
- Admin site [screen] site which services the
system administrators - the products managers who enter and edit information on the products
and the price-lists; the trade managers who process the clients' orders; the maintenance staff.
The next site map shows the different pages and group of pages which form
the public site.
Public site map.
Every page consists of two parts: static and dynamic. The static part
consists of title, main menu, submenu and ending part.
The static part enables the user to get used to the location of the links
to the main sections of the site and its functions as their position remain
unchanged while navigating through the pages.
The dynamic part displays the context- specific information from the website
content and usually this is information dynamically retrieved from the database linked to
the site thus always providing the user with up-to-date information.
Pages are grouped in several sections.
4. Base pages.
This is the biggest part of the public site. Here are the pages with the
catalogue information about the products, the pages for the execution of the orders,
the pages with personal (registration) data of the clients and the orders they have
placed, the pages for clients servicing.
Following is a map of the and their links.
Product part site map.
Here is a list of these pages and it includes:
à) Products
- Pages with information about products:
o Stores [screen] – home page of the products;
A list of products' databases is displayed, their description and images with links to the
page of the respective store page (page Departments).
If the user is known (by cookie) a greeting to him is displayed. If the user is unknown
he may log out and/or register again under his name but anyway it doesn't prevent him
from working.
o Departments [screen];
A list of the departments of the particular store is displayed with links to their
pages (page Products). A drop down list of the products' stores is displayed thus
providing fast access to their pages.
A link to price-lists' page is displayed (in case there are price-lists in the database
for the chosen store).
o Products [screen];
A list of the products of the chosen department is displayed with a brief
information about the product and its price. If the product is in promotion
its sale price is in red and the regular price is strikethrough. What is
displayed on this page depends on the user's level and it may show the dealers' prices
(apart from the end ones).
The name of the product list is at the same time a link to a page with detailed
information about the respective product (page Product). This link is available
only in case there is detailed information about the product in the database.
Next to every product there is a button to add the product to the basket.
This is a link to the basket page so that the user can check what he has added to it
and what is the basket content or to change the quantity of the ordered product.
The page enables the users to filter (limit) the list of the products according
to the values of their properties. This is realized by two drop down lists: the first one
containing the properties' names which may be used for filtering purposes and the second
one containing the properties' values. Upon selecting a property's value the list is limited
only to the products which property is of the chosen value.
Other additional elements are the check boxes in front of every product providing
selection of many products to be shown in a table of comparison (page Compare) [screen].
There is also a link to page Price-lists (provided that there are price-lists for the
selected stores in the database).
There is also a back button to page Departments and information is stored
where exactly the user came from so that he could be back there.
o Product [screen];
This is the page with the most detailed information about the product and
it's named with the product's name.
The following information is displayed on the page in a table: information about
the product, detailed description of the product and detailed specification
with the product's properties.
There is also an image of the product, its current and sale price and trader's
and manufacturer's product numbers.
There is a button on the page to add the product to the shopping basket.
There is also a back button to page Products and information is stored where
exactly the user came from so that he could be back there.
o Search [screen];
The search page is a very convenient and easy to use tool.
Initially there is only a search field and a go button to start the search.
Upon entering random text and start the search the system displays the result (if any)
as a list of departments and products which meet the search criteria.
The Search command searches across: the departments' names and their description,
the products' names and their description, the products' numbers and their properties'
values.
In the list of departments, found upon search, the departments' names are the links
to the departments' pages.
Upon finding the products which meet the search criteria there is an add button next
to every product in the product list so that it can be added in the basket. The name
of the product is the link to the product's page.
There is a search criteria field and a search button on every page of the website
so that it can be used anytime.
o Compare [screen].
This is a very useful page for the users. This is the page where comparative
information about several products of similar attributes and their values is
displayed. It is very suitable for fast selection of product meeting the search criteria.
A comparative table is displayed where in the columns are the products' data and in
the rows - the compared properties. The attributes' names, grouped by category, are in
the first column. Next columns contain an image of the product, its name and price, an
add button to add the product to the shopping basket, trader's and manufacturer's product
number. Following is product's attributes (their values), grouped by category and type
as set in the first column of the table. Should there is no value for a particular
attribute a dash (“-“) is displayed .
Every attribute name in the first column is the link which makes the system
arrange the columns with the products in an ascending order with respect to the
values of that attribute and the page is renewed. If it is a price the cheapest product
will be placed in the first column.
Every column with a product has at its top a link that orders the system to remove
the product from the comparison table.
The button with the name of the department is the link to the Products page where
the user has come from.
b) Pricelists and documents
Pricelists and documents are available to the users according to their access level.
- Price lists [screen]
A dynamic page in witch the customer can choose which information to include in his
pricelist. The page is available from the left-side menu.
If the client clicks “More” from the left-side menu the list of stores and departments
is full.
If the client clicks a name of a store from the menu, the list contains only departments
from this store.
The pricelist will contain information about products of checked stores and departments.
If the store name is checked, all its products will be included in the offer. If only
department names are checked, the pricelist will include only their products. If no name
is checked, all products will be included in the pricelist.
There is a text on the page to help the clients.
The pricelists can be generated in HTML and Excel (XML or CSV) type.
There is a left-side menu to documents, stored in the database.
- Documents [screen]
Operating with document is similar to operating with pricelists. A short help text is in
the page. The clients can view all documents (by clicking “More”) or files from choosen
store by its name.
c) Shopping process
- Pages for the shopping process:
This is that part of the website where the e-commerce is done and the deals with
the customers are concluded. The access to these pages (apart from the “Basket” page)
is via secure socket layer (SSL) upon login.
o Basket [screen];
This is the homepage for start shopping. The basket content together with the current
prices of every product and the total value of all products in the respective currency is
displayed here. There are also fields to enter data thus changing every product ordered
quantity and a recalculate button. Next to every product there is a button by which a
product may be removed from the basket. There is also a button to empty the whole basket
and a button to place an order (it's a link to the next page - “Shipping address”).
o Shipping address [screen];
On this page the shipping address is specified by the client. First the preferred
shipping address is displayed (if any in the address book) and a button to select this
it. Following is the list of the rest addresses from the address book and a from enter
a new shipping address. This form is used in case there are no addresses in the address
book or if the client wants to use temporary another address or he wants to enter a new
address in his address book. Upon selection or entering of an address (if it's a proper one)
the client goes to the next page – “Shipping method”.
There is also a back button to page – “Basket”.
o Shipping method [screen];
On this page the client selects from a list the shipping method and goes to the next page
– “Payment”.
There is also a back button to page – “Shipping address”.
o Payment [screen];
On this page the client selects from a list the payment method and goes to the next page
– “Billing”.
There is also a back button to page – “Shipping method”.
o Billing [screen];
This page is similar to the page “Shipping address” but data refers to the billing address.
Upon selection from a list the client goes to the next page – “Place order”.
There is also a back button to page – “Payment”.
o Place order [screen];
On this page the order content is displayed: the basket content with an edit button (to page
“Basket”), ), calculated in the currency of the order; shipping address with an edit button (to page
“Shipping address”"); shipping method with an edit button (to page “Shipping method”); billing
address with an edit button (to page “Billing”"); payment with an edit button (to page
“Payment”). Additional information is displayed at the end (if any).
There is a button “Place order”by which the client confirms the reviewed order and
places the order. In this case the system accepts the order and sends notification e-mails
to the client and to the administrator in charge of the ordered products. If the order
is placed successfully the client goes to the next page – “Confirm” (of the accepted order).
o Confirm [screen].
On this page the client receives confirmation of the accepted order together with detailed
information about it. There is a back button here to the page with the products for sale.
d) Your account
- Customers' account pages:
o Your account [screen];
This is the main page for clients' servicing. There are links to the pages with the
personal data, addresses, placed orders information and to the page for recovering of
a forgotten password.
If the customer is recognized by the system his name appears at the beginning of the
page. If it is not the customer working at that moment a notice warns him to identify
himself (link to the identification page).
o Change personal data [screen];
On this page the customer may change the following data: user name, contact name, e-mail
address and password.
o Forgotten password [screen];
A set of pages enabling the customer to change the forgotten password with a new one.
o Address book [screen];
Displays information about all addresses in the customer's address book and the shipping
and billing address preferred by him. The old addresses may be edited or deleted and new ones
may be added.
o Information about orders [screen].
Several pages of the same structure displaying: reacent orders (“n” in number); all orders;
only “open” orders, i.e. placed orders but not filled yet and the shipped orders. A list of
the orders, their status and order value as well as the total value of the orders in the
list is displayed. Every order has a link to the page with the detailed order and it can
be printed.
- Pages for clients servicing:
o Identification [screen];
Pages for identification and authentication (login) of the clients in the system.
ÂIn the first part of the page there are two fields - one for user's name and one for
password and by entering them the client “introduces” himself to the system.
In the second part of the page there is a button forwarding the new clients to the
registration page.
In the third part of the page there is a help button for clients who have forgotten
their password and want to enter a new one without registration.
o Registration of new clients [screen].
On this page the clients enter data for registration purposes: user's name; contact name;
e-mail address and password.
5. Additional pages.
This is the smaller part of the public site. These are the pages with information
about the firm - owner ofte the site.
Here is an information about:
- which is the owner of the site and what is its
business;
- contact information;
- partners of the firm;
- clients of the firm;
- projects of the firm;
- news;
- how to operate with the site;
a) About the company
This group comprises the pages with general information about the company, letters
of reference by clients, projects, partners, etc.
- About the company [screen] - a static page with
information about the company (may consist of several pages);
- Our clients [screen] – a dynamic page with
reference to important or successful company clients. Its content is based on the
information entered in the database. In fact there are three pages: a homepage with
brief description and a list of the most important clients, the second page with a
full list of the clients and the third page with detailed information about every
client as follows:
o Name and description of the client;
o Information about the client's activity and
the industry he represents;
o Link to the client's web page (URL).
- Our projects [screen] – a dynamic page
comprising references of successful projects, developed by the company. Its content
is based on the information entered in the database. There are two pages here: a
homepage with a brief introduction and a list of all projects (entered in the database)
and the second page with detailed information about the project as follows:
o Project name;
o Name, graphic logo and description of the
client-company;
o Main Features;
o Specific Solution;
o Information on the resources used in the development:
team, time needed, etc.;
o Link to the client's web page (URL) or to the project.
- Partners [screen] – ña static page with
information about the company's partners. It may comprise several pages with appropriate
presentation of every partner and the type of partnership (on distribution, representation,
etc. basis);
- News [screen] – a dynamic page with company's
news or important events. It comprises three pages: a page with the latest news grouped
by sectors and chronologically; news can be sorted by sectors. The second page is
accessible via a hyperlink from the news title and it displays all the information
in the news: date, title, source, author, city, full text. The third page is also
accessible via a hyperlink - this is an archive of all news in the database which can
be sorted by sectors.
b) Contact
- Contact [screen]
One or several static pages containing information about the contacts of the company
running the e-commerce shop.
- Feedback [screen]
A page containing a form to send an e-mail to the system's administrator. Several fields
to enter information are displayed. In the fields for the name and the e-mail of the user
the system automatically downloads data from the database if the customer is recognized
by the system.
- Questions and answers [screen]
A dynamic page containing the most frequently asked question and their answers, grouped
by their themes.
- Terms of service
A static page containing the conditions under which services provided by the website for
e-commerce may be used (usually this is legal information).
c) Help [screen]
The pages with the information about the clients - how to operate with the site and
its possibilities and advantages.
Information is organized by themes for convinience.
4. Admin site [screen]
This site is bigger and more complex than the public
one. It is a really web based application for management of the public website
content, management of the database information and management of the users,
customers and their orders.
Browsing the pages of this site is controlled and is
possible only upon identification and authentication of the administrators.
This site may be operate by SSL link (recommended). All pages have static and
dynamic parts. The static part contains a header with information on the
authenticated administrator, logout button and left aligned main menu for fast
access to the administrative functions.
All users of the administrative site are called
administrators. They may have different functions: product managers
administrate products data, price-lists, etc.; customers administrators are
responsible for customers registration and customers level of access; orders
managers process all orders placed.
Administrative site map.
a) Products management:
- Stores
Enter and/or edit stores and organization of their
departments. A group of pages – one containing the whole list, one for editing,
one for entering new stores and one for deleting stores.
o List [screen]
A list of all stores is displayed. The name of the
store is the link to the page containing
the departments in this store. Next to every store is a link to the functions:
Edit (page Edit) and Delete (page Delete). A link to New Store is at the
beginning of the list.
o Edit [screen]
A table of fields for editing stores related data and
links to Save and Cancel is displayed on the first part of the page. The second
part contains a list of this store departments and links to Delete in order to
Detach the department from that store. The third part displays the name of the
image for that store and a link to Delete function in order to Detach the image
from the store.
There is a backward button to the stores list.
o New store
Displays a table of fields for entering stores related
data and links to Save and Cancel. There is a backward button to the stores
list. Upon saving the page transforms to Edit page.
o Delete
Displays data on the store, subject of deleting and
links to confirmation function – Yes and canceling function – No to deleting.
There is a backward button to the stores list.
- Departments
Enter and/or edit the products departments and
organization of products in departments. Management of the categories,
containing products parameters. A group of pages – one containing the whole
list, one for editing and one for deleting departments.
o List [screen]
A list of all departments is displayed. The name of the department is the link to
the products page, included in it. There are two functions available next to every
department: Edit (to Edit page) and Delete (to Delete page). At the end of the list
there are fields for entering new departments and a link to Add a new department function.
There is also a field for selection of a store available enabling fast
access to a similar page containing the list of departments from the
selected store.
o Edit [screen]
A table of fields for editing departments related data and links to Save, Cancel and
Save As (copy) is displayed on the first part of the page. The second part contains
a list of the stores in which is the department and links to Delete in order to Detach
the department from that store. After the list there is a Select filed and a link to
Add function in case the department is to be added to the selected store.
The third part displays a list of categories according to which the products
from that department can be classified and a link to Delete function in order to
Detach the category from that department. After the list there is a Select filed
and a link to Add function in case the selected category is to be added to the department.
The fourth part displays the name of the image for that department and a link
to Delete function in order to Detach the image from that department.
There is a backward button to the departments list.
o Delete
Displays data on the department, subject of deleting and links to confirmation function -
Yes and canceling function - No to deleting. There is a backward button to the departments list.
- Products
Enter and/or edit the products related data. Full description of products, their
parameters, prices and images. A group of pages - a page containing the whole list,
an Edit page, one for entering a new product, one for entering and editing their
parameters values and one for entering and editing their prices.
o List [screen]
A list of all products from the selected department is displayed. There are
links to two functions available next to every product: Edit (to Edit page) and
Delete (to Delete page). A link to New Product function is at the beginning of the
list (to New Product page). There is a check box in front of the product and a link
to Enter Price after the product to facilitate fast entering of prices for all products selected.
At the beginning of the list there are two fields allowing selection of a store and a
department thus enabling fast access to a similar page containing the list of products
from the store and department selected.
o Edit [screen]
A table of fields for editing products related data and links to Save, Cancel and
Save As (copy) is displayed on the first part of the page. A table with the product’s l
atest prices listed chronologically with links to Edit and Delete prices function
is displayed in the second part. At the beginning of this table there is a field
for new prices entering and a link to Add New Price function. The second part contains
also a list of the departments in which the product is included and links to Delete
in order to Detach the product from that department. After the list there is a Select
filed and a link to Add function in case the product is to be added to the selected department.
The third part displays a list of categories, the same as in the departments, to which the
product belongs, their attributes and values (parameters) and a link to Delete function in
order to delete this parameter. There is a link to Edit Parameters page at the beginning of the list.
The fourth part displays the name of the image for that product and a link to Delete
function in order to Detach the image from that product. Several images can be attached
to one product.
There is a backward button to the products list.
o New product [screen]
A table for entering product related data and links to Save and Cancel is displayed. There
is a backward button to the products list. Upon save the page is transformed to Edit page.
There are next possibilities for fast editing of checked products:
o Entering prices (bulk edit) [screen]
A list of the products which prices are to be entered is displayed. Next to every product
a field allows entering of prices. There is a Save prices button and a backward button to
the products list.
o Entering sale prices [screen]
Similar to entering prices.
o Entering attributes [screen]
Similar to entering prices.
o Entering the product statuses [screen]
Similar to previous pages.
o Attach all products to the title department
All products from the list can be attached to their title department.
o Edit Attributes [screen]
Information on categories, attributes and their values (parameters) classified in
categories in displayed. All categories from the departments are listed. There is an
Enter/Edit field next to every attribute to edit its value and a field to select a
value from all entered values for that attribute and category within the department.
Links to Save and Cancel and a backward button to the products list.
This is the main page to enter new prices of products.
- Categories
Enter and/or edit the categories and the their attributes (parameters). A group
of pages - a page containing the whole list, an Edit page, one for entering and
editing the attributes of the categories and one for entering new categories.
o List [screen]
A list of all categories displayed. There are links to two functions available next
to every category: Edit (to Edit page) and Delete (to Delete page). A link to New
Category function is at the beginning of the list (to New Category page).
o Edit [screen]
A table of fields for editing categories related data and links to Save and Cancel is
displayed on the first part of the page. The second part contains a list of the category
attributes and links to Edit and Delete the selected attribute. A field to enter a new
category is displayed in the third part and an Add button.
There is a backward button to the categories list.
o New Category
A table with a field to enter the category name and links to Save and Cancel is
displayed. There is a backward button to the categories list. Upon Save the page
transforms to Edit page.
- Images
Pages for administration of images (images and Flash animation), used for the
design of the public site. The system allows storing images and Flash animation
in the data base and their dynamic display on the pages of the stores, departments
and products in the public site. Two dynamic pages - one with the list of the images
and one containing detailed image properties.
o List [screen]
A list containing all images stored in the database is displayed. There are links
to two functions available next to every image: Edit (the image name) and Delete. The
image name is the link to its detailed page (Image Data page).
At the bottom of the page there are two tables containing fields for entering
new images data and their saving into the database. The first table allows selection
of a file with an image from the local PC (or local network) while the second one
allows selection of an image via Internet of URL of the image.
o Image Properties [screen]
A page containing detailed image properties and information to which stores,
departments and products the image is “attached to”.
The first part of the page displays the image and dimensions buttons /enlarge, shrink,
real size and fit to window) to modify the image size.
The second part displays the image properties (name, size in bytes, size in pixels and
mime type) and fields to modify the image (from the local PC or Internet).
The third part displays three tables containing lists of the products, departments
and stores “attached to” that image and a link to “Detach” function. The function
“Attach” the image to an object (product, department or store) is available at the
beginning of every table.
There is a backward button to the images list.
b) Management of Customers
- Customers
A page allowing processing of clients’ data. The system saves the clients’ registration
data in the database and allows the administrators to make inquiries, to change the access
level (even to cancel the right of access) as well as to edit and to delete this information.
A group of three dynamic pages - one containing the clients’ list, one for editing
and one for deleting.
o List [screen]
A list of all registered clients is displayed on this page. Next to every client in a Select
field is displayed the client’s level of access (access to price lists) and a link to Change
Level function. There are two functions for every client - Edit (to Edit page) and Delete. A
filter field to select a letter from the alphabet is displayed at the beginning of the list
(i.e. upon filtering the list contains only the clients whose names begin with the selected letter).
o Edit [screen]
A table of fields for editing the clients’ data (without the password because it
is saved in an encrypted type and the system cannot decrypt it) and links to Save and
Cancel are displayed on the first part of the page. The second part contains a list
of the client’s address book without possibility to edit it. A list of the client’s
credit card (not showing the full credit card number) and also without permission
to edit it is displayed in the third part.
There is a backward button to the clients’ list which plays the role of Cancel, too.
o Delete
Data related to the client subject of deleting is displayed and links to confirm - Yes
and cancel - No the deleting.
There is a backward button to the clients’ list.
- Levels
A page to manage the clients’ access levels. Assigning levels is needed in order
to offer the relevant price data to the clients of the e-commerce shop. Consists of
two dynamic pages - one containing the list of access levels and the second one - enabling editing.
o List [screen]
A list of clients’ access levels is displayed. The first line is level “0” which in
fact strikes off the list a certain client (this level can not be subject of editing
or deleting). Levels from 1 to 3 follow. You can select how many levels of clients,
except for “0” level, the system shall support but there must be at least one level.
There are links to Edit and Delete functions next to every level (if the system
supports only one level except for the “0” level, the function Delete is not
displayed). Following the list there is a form of fields to enter data for a new
level and Add button.
o Edit
A page similar to the List page but only the table with the levels’ list is displayed
and the level’s related data subject of editing is transformed to an Edit field. Links
to Save and Cancel are displayed next to the level.
- Documents
Pages to manage the price lists (or any files containing documents, images, audio
and video data, etc.), i.e.: upload, description, organization with respect to the
clients’ level or products groups. The system allows uploading and saving in the
database files containing documents and after that they are offered for downloading
by the users and customers. These are two dynamic pages - one containing a list
of price-lists and the second one - for editing.
o List [screen]
A list of the price-lists /documents/ saved in the database is displayed. It is
sorted with respect to the related stores and the clients’ levels. There are links
to Edit and Delete functions next to every document.
There are two filter fields at the beginning of the list - one containing all
stores and the second one - containing the levels.
Following is a form of fields to enter data for a new document and Add button.
o Edit
A page similar to the List page but only the table with the documents’ list is
displayed and the document related data subject of editing is transformed to an
Edit field. Links to Save and Cancel are displayed next to the document.
- Price Lists
Pages for inserting price information about the products from .xls file. There must be
an information about products' part or manufacturer number or both witch to be
corresponding to products in the database. If there is no information about date and
currency of prices, the data from the begining of the page will be used. Paste .xls
data in the textarea of the page [screen] and click “Analyze”.
The information will be analyzed and labels for columns will be offer [screen]. Change
labels if necessary and click “Check”.
The system will search the database for products with part and manufacturer numbers according to
the pasted data and choosen labels. If there is such product the first checkbox will be checked.
If there is an information about price, the second checkbox will be checked. In the database
will be inserted information only for products with two checked checkboxes [screen].
Click “Prepare” to prepare information for inserting: prices and currency [screen].
Click “Insert” to insert the data - list of products with inserted data will be displayed [screen].
There is à legend on the pages.
- Statuses
Pages for inserting product statuses from .xls file. The work is like inserting of prices,
described on the previous page.
The data from the .xls file have to be pasted in the textarea [screen]. The first row of
this information must contain the column names - Part #, Mfg #,
Name, OnStock, Expected, OnOrder.
Click “Analyze” and look at the analyzes data [screen].
Click “Check” to search the database for products with pasted part and manufacturer numbers.
If there is a corresponding product in the database, the first checkbox will be checked. If
there is an information about product status in pasted data, the second checkbox will be
checked. Only information about products with two checked checkboxes will be stored in the
DB [screen].
Click “Prepare” - only products witch information will be stored in the DB remain [screen].
The priority of status information is: OnStock, Expected, OnOrder. If there is information in
more than one column for statuses of a product the first-priority column data will be inserted.
Click “Insert” to save the information in the database. The list of products with stored data
will be displayed [screen].
There is a legend on the pages.
c) Orders Management:
- orders
ÑPages to manage the clients’ orders. These are three dynamic pages - one containing
a form to enter the orders search criteria, the second one containing the list of
the orders meeting the search criteria, the third one enabling View/Edit of the order
and the last one - for Printing the order.
o Search Criteria [screen]
This is the first page to be displayed when start working with
orders. It consists of a table of fields to enter properties as search
criteria to filter the database so only the orders meeting the search criteria
to be displayed. The search criteria may be: from …. to ……. (today, from
yesterday, the current or the previous week, this or the previous month or
the time period between any two dates); client’s name (a set of characters
to search for the client’s name); product’s name (a set of characters to
search for the product’s name); order’s total value, calculated in the
currency of the deal (i.e. USD or BGN) (to 100, from 100 to 1000, from
1000 to 5000, 5000 and up or between any two values); order’s status (placed,
approved, etc.). In case of more than one search criteria all of them are
taken into consideration. Any of the search criteria may be used in the administrators’ work.
Links to Place the order and Blank the from are available.
o List [screen]
At the beginning of the page the Search criteria form is displayed again thus
showing the search criteria met by the orders displayed in the list. This enables
entering of new search criteria and to start searching again.
Following is a list with a brief description of the orders that meet the search
criteria, arranged by date. There is a field to change the status of the order and
to enter the reason for this change next to every order. Links to Save (new status)
and Cancel (the changes made) are available next to every order.
Every order’s number is the link to the detailed page of the order.
The total value of the orders in the list is displayed at the end of the table.
o Order [screen]
All data related to the order is displayed. If the order is Placed, the page
displays the data that can be changed in Edit fields and a link to Save function is available.
The last table contains a form to enter a new status of the order, Save it and
displays any statuses related to this order and arranged by date and a link to
Delete a certain status.
A link to Print the order is displayed at the end of the page (to Print page).
o Print
A page with all the data related to the order (in a separate window of the browser),
fit for printing. There are two buttons displayed - one to start printing and another
one to close the window. The printing may be activated via the system functions of the browser.
- Status
A page to Enter/Edit the order’s status. The system allows using these statuses
when servicing the clients’ orders. Consists of three dynamic pages - one containing
the list of statuses, one for editing and one for deleting.
o List [screen]
A list of all orders’ statuses is displayed. Links to Edit and Delete are
available next to every status.
Following is a form to enter a new status and an Add button.
o Edit
A page similar to the List page but only the table containing the list of statuses
is displayed and the status related data subject of editing is transformed to an Edit
field. Links to Save and Cancel are displayed next to this status.
o Delete
Data related to the status subject of deleting is displayed and links to confirm - Yes
and cancel - No the deleting.
There is a backward button to the list of statuses.
- Country
Pages to entering countries in witch the shipping is available.
o List [screen]
Next to the every country in the list are links to “edit” and “delete” the entry.
There is a possibility to add a country to the list.
o Edit [screen]
The name of the country can be edited.
In this page have to be given the dependence between countries and available shipping methods
and countries and available payment methods.
- Shipping
A page to Enter/Edit the means of shipment maintained by the trader. The system
allows offering the means of shipment to the clients prior to placing their orders.
Consists of two dynamic pages - one containing the means of shipment and one for editing.
o List [screen]
ÍA list of means of shipment is displayed. Links to Edit and Delete functions are
available next to every means of shipment.
Following is a form to enter new means of shipment and an Add button.
o Edit
A page similar to the List page but only the table containing the list of means of
shipment is displayed and the means of shipment subject of editing is transformed
to Edit fields. Links to Save and Cancel are displayed next to this means of shipment.
- Payment
ÑA page to Enter/Edit the terms of payment maintained by the trader. The system
allows offering the terms of payment to the clients prior to placing their orders.
Consists of two dynamic pages - one containing the terms of shipment and one for editing.
o List [screen]
A list of terms of shipment is displayed. Links to Edit and Delete functions are
available next to every term of payment.
Following is a form to enter new terms of payment and an Add button.
o Edit
A page similar to the List page but only the table containing the list of terms of
payment is displayed and the term of payment subject of editing is transformed to Edit
fields. Links to Save and Cancel are displayed next to the edited term of payment.
- Currency
A page to Enter/Edit the type of currencies used by the system and their current
rates of exchange. The system allows storing chronological data on the exchange rates
applied in the price lists of the products. The exchange rates refer to the currency
used by the traders when dealing. Consists of five dynamic pages - one containing
the list of all currencies and their rates of exchange, one for editing the
description of the currency, one for deleting a currency, one for entering
and editing of the exchange rates and one for deleting a particular exchange rate.
o List [screen]
At the top of the page a list of all currencies, used within the system and their
exchange rates are displayed. There is a field for entering a new exchange rate next
to every currency. Links to Edit and Delete functions are available (to Delete page).
At the beginning of the table there is a field to enter the valid date for the new
exchange rates subject of entering (as default the current date is displayed) and
at the end of the table there is a link to Save new exchange rates. The names of
the currencies and the current exchange rates are links to the page containing the exchange rates.
Following is a form to enter data for a new currency and an Add button.
o Edit
Edit fields to edit the selected currency is displayed and a Save button. There is a
backward button to the currency list.
o Delete
Data referring to the currency subject of deleting is displayed and a Delete button
are displayed. There is a backward button to the list of the currencies.
o Currency Rates [screen]
Displays a table of rates of exchange in a reverse chronological order. Links to
Edit and Delete functions are available next to every exchange rate. Fields to
enter new exchange rate are displayed on the first row of the table and a link to Save function.
Above the table there is a field to select a range of currencies to be displayed in the
table, namely: last 7, last 30, current year or display all.
There is a backward button to the list of the currencies.
o Delete Currency Rates
Data referring to the exchange rate subject of deleting is displayed on this page and a
Delete button.
There is a backward button to the list of the currencies.
- Taxes
A page to enter the taxes applied in the countries where the trader is doing his
business. The system allows these taxes (most often VAT) to be calculated in the
orders values depending on the country (or state) of the deal. Consists of three
dynamic pages - one containing the list of taxes, one for editing and one for entering of a new tax.
o List [screen]
A list of the taxes is displayed on this page. Links to Edit and Delete functions are
available next to every tax. At the beginning of the table there is a link to New Tax
function (to page New Tax).
o Edit
Fields to edit the selected tax are displayed. Links to Save and Cancel are
available next to the fields.
There is a backward button to the list of taxes.
o New Tax
The page displays a table of fields to enter tax related data and links to Save and Cancel functions.
There is a backward button to the list of taxes.
d) Company’s Information:
- Company [screen]
Enter and Edit company related data. This is the page to enter the company’s address,
currency of the deal, company’s bank details (if the payment shall be effected by bank transfer), etc.
e) Administrators:
- Administrators
A page to Enter/Edit the system’s administrators. This is the page where the access
to the system is managed by a group of administrators. This is the page where the
links of the administrators to the group of products are entered which means that
in case order for a product from a certain group is placed the administrator shall
be notified by e-mail. Consists of two dynamic pages - one containing the list of
the administrators and one for editing. Only the admin administrator is authorized
to modify the data referring to the rest of the administrators and their access to the system.
o List [screen]
A list of the administrators is displayed on this page. Links to Edit and Delete
functions are available next to every administrator in case the admin administrator
is operating the system. Otherwise only a link to the Edit function is available next
to the administrator operating at the moment.
Following is a form of fields to enter data for a new administrator and an Add button
(only if the admin administrator is working).
o Edit [screen]
A page of fields to Edit administrator’s related data. Links to Save and Cancel are
displayed next to this administrator. Following is a table containing the list of stores
the administrator manages and links to Detach function in order to detach a particular
store from the administrator’s responsibilities. A list of the stores is displayed in
the field on the last row of the table with a link to the Attach function enabling
selection of a store to be attached to a particular administrator.
There is a backward button to the list of administrators.
f) Offers:
- Offers
Pages for making of complex offers with information from the database.
o List [screen]
The list of ready offers is displayed. Every one can be edited, previewed end deleted.
The number of the offer is link to edit page.
There is a possibility to add new offer and filter orref's list by the date period.
o Edit [screen]
The information about the offer can be edited on the page.
There are buttons for saving, canceling, going back to the list, previewin and sending the offer
to the recipient by the e-mail.
There is a link to offer's content page.
o Configuration content [screen]
This is the page with offer content. Every offer can contain one or more configurations with
one or more products in it. Their list is shown after the configuration. Every configuration
can be edited and deleted. Its name is link to the edit page.
There is a possibility to enter new configuration - name, quantity, currency, show total, show
the price for every product, witch price level to be used and a descriptive text.
o Edit configuration [screen]
This is the page for editing the configuration - its products, their quantity and show order.
Every product can be replaced with another from the same store and department and can be
deleted.
There is a button for changing quantities and show order of all configuration products and a
table for product witch are not stored in the database.
g) Other information:
- Q & A
A page to enter and edit the most frequently asked questions and their answers. They
are grouped by topic and the topics may be entered and edited. Consists of four dynamic
pages - one displaying a list of Q & A and enabling entering a new Q & A, one for editing
Q&A and grouping them by topic, one displaying the topics and enabling entering a new
topic and one for editing the topics.
o List of Q & A [screen]
This is the initial page when you start working with Q & A. A list of all Q & A is
displayed and links to Edit and Delete are displayed next to every Q & A. Following
is a form of fields to enter a new Q & A and an Add button. There is a search field
at the beginning of the table enabling selection of a topic and displaying only the
topics that meet the search criteria. Ahead of this field there is a link to the page
containing the list of topics.
o Edit Q & A [screen]
A page displaying field to edit Q & A and a Save button. Following is a table containing
the list of topics in which the Q & A is classified and a link to Delete function
enabling deleting of the Q & A from this topic. There is a search field on the last
row of the table enabling selection of topics with a link to the Add function in order to
add a particular Q & A to the selected topic.
There is a backward button to the list of Q & A.
o List of Themes [screen]
Displays a list of all themes and links to Edit and Delete functions next to every theme.
Following is a form of fields to enter data for a new theme and Add button. The name of a theme
is the link to the relevant page “List of Q & A” from the selected theme.
o Edit Themes
A page similar to “List of Themes” page but only the table containing the list of themes is
displayed and the data related to the topic subject of editing is transformed in edit fields.
Next to the themes links to Save and Cancel are available.
- News
Pages to enter and edit company’s and product’s news. News are classified by sectors.
Sectors can be entered and edited. Consists of five dynamic pages - one displaying the
list of news, one enabling editing of news and their classification by sectors, one for
adding news, one displaying the list of sectors and enabling adding of a new sector and
one for editing sectors.
o List of News [screen]
This is the home page when processing news. Displays a list of all news and links to Edit
and Delete are available next to every news. The header of the news is the link to page Edit
news. A search field enabling selection of a sector is displayed at the top of the page. Ahead
of the search field there is a link to the page containing the list of sectors. Following is a
link to the Add News page and the list of the news.
o Edit News [screen]
Fields to edit the news are displayed on this page and a link to Save. Following is a table
containing the list of sectors in which the particular news is classified and links to Delete
function in order to delete the news from the particular sector. There is a search field on the
last row of the table enabling selection of a sector with a link to the Add function in order
to add news to the selected sector.
There is a backward button to the list of sectors.
o Add News
A table of fields to enter details for the news is displayed on this page with a link to
Save function. There is a backward button to the list of news. Upon saving the page transforms
to page Edit News.
o List of Sectors [screen]
Displays a list of all sectors and links to Edit and Delete are available next to every sector.
Following is a form of fields to enter data for a new sector and an Add button. The name of the
sector is the link to the page List of News from the selected sector.
o Edit Sectors
A page similar to “List of Sectors” page but only the table containing the list of sectors is
displayed and the data related to the sector subject of editing is transformed in edit fields.
Next to the topic links to Save and Cancel are available.
- our Clients
A page to enter and edit data on respected clients of the company, running the e-commerce
shop, which the company wants to present to its customers thus promoting its achievements.
This page allows classifying the clients by industry and entering and editing industries.
Consists of five dynamic pages - one displaying the list of clients, one for editing clients
and classifying them by industry, one for adding a new client, one displaying the list of
industries and entering a new industry and one for editing industries.
o Clients List [screen]
ÒThis is the home page when start working with clients. Displays a list of all clients and
links to Edit and Delete functions are available next to every client. The name of the client
is the link to page Edit Clients. A search field enabling selection of an industrial branch is
displayed at the top of the page. Ahead of the search field there is a link to the page
containing the list of all industrial branches. Following is a link to the Add Client page
and the list of the clients.
o Edit Clients [screen]
Fields to edit the clients are displayed on this page and a link to Save. Following is a
table containing the list of industrial branches in which the particular client is classified
and links to Delete function in order to delete the client from the particular industrial
branch. There is a search field on the last row of the table enabling selection of an
industrial branch with a link to the Add function in order to add a client to the selected
industrial branch. At the bottom of the page there is a link to page “Add Client” (to the
same industrial branch).
There is a backward button to the list of clients.
o Add a Client
A table of fields to enter data for the client is displayed on this page with a link to Save
function. There is a backward button to the list of clients. Upon saving the page transforms to
page Edit Clients.
o List of Industries [screen]
Displays a list of all industrial branches and links to Edit and Delete functions are
available next to every industry. Following is a form of fields to enter data for a new
industrial branch and an Add button. The name of the industry in the list is the link to page
List of Clients of the selected industry.
o Edit Industries
A page similar to “List of Industries” page but only the table containing the list of
industries is displayed and the data related to the industry subject of editing is transformed
in edit fields. Next to the industry links to Save and Cancel are available.
- Case Studies
A page to enter and edit cases developed by the company, running the e-commerce shop, by
which the company wants to promote its developments vis-a-vis its clients. Consists of three
dynamic pages - one displaying the list of cases, one for editing a case and one for adding a new case.
o List [screen]
This is the initial page when you start working with cases. A list of all cases is displayed and
links to Edit and Delete are available next to every case. The name of the case in the list is the
link to the Edit page. There is a link to Add Case page at the beginning of the list.
o Edit [screen]
ÒFields to edit cases are displayed on this page and a link to Save. Forms to upload an
image of the detailed page of the case in the public site are also displayed.
There is a backward button to the list of cases.
o Add Case
A table of fields to enter details on the case is displayed on this page with a link to Save
function. There is a backward button to the list of cases. Upon saving the page transforms to Edit page.
- Help
Pages for storing in the database of information witch helps to the clients to
operate with the site and understand what are its possibilities and advantiges. These are
four pages - for help themes, edit of a theme, list of helps, edit help.
o Help [screen]
This is the first page of working with help. There is shown a list of helps according to
the choosen language and choosen theme. Every question can be edited and deleted. There is a
section for inserting new help to the choosen theme.
o Edit help [screen]
The help can be edited and saved on this page. The help can be added to another theme.
There is a back button to the list of helps.
o Themes [screen]
The list of help themes is showm on this page. Every theme can be edited and deleted. The theme name is
link to the page with helps of this theme. There is a section for entering the new theme.
o Edit theme
This is the page for editing of a theme. There are buttons for saving and to the list of
theme helps.
h) Newsletters:
- Newsletters
Pages for saving in the database of newsletters, their overviewing and sending to all clients
whitch want to receive them. The newsletter can be sent to a list of e-mails also.
o Nesletter's list [screen]
This is the first page for newsletters. Every newsletter can be edited and deleted. The list of
newsletters can be filtered by a date period.
o Edit newsletter [screen]
This is the page for editing of a newsletter. There are buttons for saving, canceling and
going back to the newsletter's list.
After entering the newsletter information, products from selected store
and department can be “attached”.
There can be three types of newsletters: with detail information about one product and
list of products; with full information about one product only; a list of products. The
product with full or detail information must be selected as “favourite”. The favourite
product can be deleted from the newsletter.
The newsletter can be viewed by clicking the preview button according to the language.
Every administrator can send a newsletter to one address at a time only but admin
can send it to all addresses according their category.
o Enter the newsletter
This is the page for entering the newsletter fields. There are buttons for saving and canceling.
After saving this page transfroms in edit page.
- Newsletter logs
Pages for information about newsletters - who and when is sending the newsletter.
o Newsletter list [screen]
This page shows a newsletter list with link to the details about every newsletter
(if are available).
o Details [screen]
This page shows the time when the newsletter was sent and who sent it.
There is a back button.
- E-mail list [screen]
The page for inserting and editing of e-mail addresses for sending newsletters.
The contact name, information about newsletter language, the e-mail category
and price level information have to be written.
E-mail categorization is for convinience.
Every e-mail can be edited and deleted.
The e-mail list can be filtered by: string to be searched in the e-mail or contact name;
category; receiving newsletters.
Used technologies
a) Hardware.
- Web server: Intel Pentium II, 500 MGHz, 5GB HDD, 64MB RAM.
- Database server: on the same mashine or mashine with
same parameters.
b) System software.
- OS: Linux
- Web server: Apache
- Database server: MySQL
- Firewall and SSL
c) Scripts.
- Active pages: PHP, XML
- Client side: HTML, DHTML, JavaScript, CSS
d) Application Software.
- Not special software. You need a computer with Internet and
browser (IE or NS).
|