Changes in Virtuemart

For the purpose of this quote assume a standard site

exist ( complete ) with Virtuemart 2.0.4 and Joomla 2.5 -

for as far as the standard functionality allow.

Changes are required within the Virtuemart Sources. This

project has several phases and this document serves as a

summary of phases 1a and 1b.

We can make the location of the site known, but first want

a quotation for budgetary purposes. ( Phase 1a and 1b )


By basically adding a "stock" field to the "product_categories"

table and a "type" field to the

"Categories" table in Virtuemart the application is to

"buy" stock from a specific "location" ( a category type )

and alter the corresponding "stock" field.

Phase 1a ( Basic stock changes )

General Note:

( Create a SQL file for all database changes - so it can be

applied & managed easier )

The solution must be able to handle a traffic flow of 360


Change the "Product_Category" table in Viruemart to have a "Stock"

field ( Integer )

Change the Category table in Viruemart to have a field ( Integer ) for

"Category Type".

A Type "0" will be "standard" and "1" will be a "location" &

a field for an email address.

( Hard Coded at this stage )

All "location" categories will also be "hidden" ( standard

virtuemart ). ( Location fields will be edited manually )

There is a page that "shows" all the products of a particular

"non hidden" category. On the particular page add a control

( Combobox Selector ) which lists all the "location" type

categories ( including "All" ) and on selection will sort

the "product" further & display the subset of product belonging

to the particular category. Provide another Combobox selector

containing the items ( "All", "In stock" and "Not In Stock" ) -

On selection will filter the displayed product even further

based on the "Stock" field in the "category" table. ( This

selection should only be available if the "category" is

not selected as "All" )

By clicking on a product the "product details" page appears.

On this page the "Add to cart" button also apprears. Now:

( To add ) Add a Combobox selector for all "Location"

categories. Only allow "Add to cart" if a particular

"location" has been selected, bear in mind that ( the default )

selection of the "location" Combobox should be either "All" or the

specific "location" depending if this is known at time of

loading the page.

Add a "column" to the cart which will show the "location" field

( as per the Combobox selector at the time of "Adding to cart".

When finally clicking "Check Out Now" do a check whether stock

exist ( final check ) before creating an order - else warn

user. ( against appropriate field in the categories table )

When an order is placed it should also indicate the "location"

( This will also involve making a change to the database to

store the corresponding field )

The email which is sent to the "store" ( on placement of

order ) must be sent to the "email address" as per the

corresponding field in the "category" table for the particular


Phase 1b ( GUI minor )

Write an application in C# using Microsoft Visual Studio to

illustrate making a connection to a Virtuemart ( MySQL )

database & changing a sample field over a secure

connection, where database "connection details" are also

transmitted in a secure manner.

Other Phases: ( major )

Involves consultancy with respect to the following:

(a) SEO

(b) Strategy to keep this "in line" with Virtuemart & Joomla

future "upgrades"

(c) Security

(d) Query Optimizations

Please reply if you can help and please provide a quote



Skills: Apache, Joomla, MySQL, PHP, Virtuemart

See more: show product categories virtuemart combobox, product categories combobox virtuemart, mysql database buy, in n out application, hour change 2012, email application in php, buy email traffic, quote to illustrate, product selector, microsoft visual studio, in stock, filter sort, d secure transactions, combobox, joomla default document, filter product joomla, joomla user location, mysql sort field, add sample cart, visual studio mysql

About the Employer:
( 0 reviews ) South Africa

Project ID: #1725761

8 freelancers are bidding on average R1547 for this job


Good day, I can assist you. Thanks.

R1999 ZAR in 15 days
(206 Reviews)

Hello, We are ready for that job. Please check Private Message. Regards.

R1750 ZAR in 6 days
(81 Reviews)

I run European website design firm with years of design experience personally developing over 300+ websites. I can also provide a list of references from past customers if you'd like. I'm not the cheapest you'll find, More

R1777 ZAR in 15 days
(76 Reviews)

Please see PMB

R1500 ZAR in 5 days
(115 Reviews)

We are a central india based a renown software company. Wroking from last 8 years, some very strong web based secured .net application for refrence.. [login to view URL](Complete social networking portal like Face More

R1200 ZAR in 25 days
(0 Reviews)

Hello It is our pleasure to work with you on your project. We are willing to provide you quality services,please look further for the expertise on our work. Kind Regards

R1200 ZAR in 25 days
(0 Reviews)

Hi. I'm Joomla developer. I can give the best result in shortest time. I am sure you will be satisfied with my work. Thanks and have a nice day.

R1200 ZAR in 6 days
(0 Reviews)

Custom software development - <b><i>Removed by Admin</i></b>

R1750 ZAR in 1 day
(0 Reviews)