Modification of Virtuemart/Joomla store

Sheet music and CD store implementation in VirtueMart

General description:

Customize Virtuemart to sell sheet music and CD’s.

The process will be done in several steps, and the first step is described here. If you do a good job on the first step you will get the next ones.

The first step is to add support for names and roles connected to products.

When you sell sheet music and CD’s the customers need to be able to search for people connected to the products. Artists, composers, arrangers etc. A typical store that utilizes this is

Database modifications:

We need two new tables: vm_roles and vm_prod_roles.

The People table

Since VirtueMart already have a people-table with relevant fields I’d like to use that unless the programmer can come up with a good argument to use a separate table. Relevant VirtueMart table is vm_user_info.

Only one field must be added: roles YES or NO. Only people with YES here shows up in the product-people list.

The Role Table

Contains info about the possible roles that a person can have in a product.

Table name: vm_roles

Field name Type Comment

role_id Int(11) Auto_increment Unique nr

role_type Text 255 composer, arranger, artist etc

role_short Text 10 Abbr to be used in lists (Ex Comp for composer, Arr for arranger etc)

role_sort_order int Sort order in lists

Role_placement Text Where should the text appear in layout and whether to display Last name, First Name, or Company fields

The People/Product/Role Table

One person can have multiple roles in a product (For example he can be both composer AND artist on the same CD). We need a table to define his role(s) in the specific product.

Table name: vm_prod_roles

Field name Type Comment

prod_role_id Int(11) Auto_increment Unique nr

product_id Int(11) Linked to product

user_id Int(11) Linked to user

role_id Int(11) Linked to role

Modifications to layout

Shop side

1. Include results from the people database in the free text search. Search the first and last name.

2. Include product categories in search.

3. Create two new Browse pages with and without product thumbnails. See attached file for details.

4. Ajax drilldown search system on top of the product listing. See attached file for details.

5. Allow the roles to be visible on all lists in the store through out the check out system, invoices etc. This is to identify products with similar names but different arrangers etc.

6. Add the roles to the “Order by” dropdown list.

In other words, it should be possible to order the last name of any person associated with the product.

Admin side changes

1. Add system for assigning persons and roles to the product. Since the list of people can be very long, more than 500 people, drop down is not suitable. Use an ajax system similar to the one used in VirtueMart ”related products”. See attached file for details.

2. Create global layout settings to customize where to show these names and how.


Behind product name on Browsepages, Flypages, Cartinfo, Invoices…


Lastname, Firstname or Firstname Lastname or Company

With abbreviation for the role or full rolename

Taidot: AJAX, Joomla, PHP, SQL

Näytä lisää: joomla store, where to get a job on programmer, top sort, shop for joomla, search up people details, search for artists, search for an artists, search artist, programmer shop, programmer names, programmer it job description, product artist, need music composer, need a music composer, name of product and description, music composer job, list of artists, linked int, job role for php programmer, job for composer, job description of programmer, job define, it support role, it programmer names, it programmer job search

Tietoa työnantajasta:
( 25 arvostelua ) RANHEIM, Norway

Projektin tunnus: #453238

6 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Dear Sir I have experienced and expertise in joomla virtuemart fields. Please view my developed joomla virtuemart sites I hope that you will provide this job to me and reply to me as soon as possible. Regards Raj

$250 USD 6 päivässä
(13 arvostelua)

Hi, I will like to do that work for you. I have expertise over joomla and virtuemart both. I am sure to get the work after 1 step. I will complete your work with standard development process and step by step by Lisää

$650 USD 25 päivässä
(8 arvostelua)

We can do it We are expert in the joomla

$450 USD 20 päivässä
(0 arvostelua)

Good Day. Here at Bamboo Designs we are very interested in creating the specific task that you have requested above. Our team of highly skilled professional designers, programmers, and marketers are confident that we Lisää

$750 USD 20 päivässä
(0 arvostelua)

Hi, I am very interested in this job position. I am waiting for your PM. Thank You.

$300 USD 20 päivässä
(0 arvostelua)

Please check PMB,Thanks

$250 USD 2 päivässä
(0 arvostelua)