osCommerce Music Service UPC update

CLOSED
Bids
1
Avg Bid (USD)
$850
Project Budget (USD)
$30 - $5000

Project Description:
**3 updates needed to our osCommerce site**.

**1**. === Add Product Types to S&H setup.

Our osCommerce s&h fees are set up by the product type. Would like to add extra product types to our data entry form and have new product types displayed where current product types are displayed.


**2.** === Update Javascript functionality
The custom javascript code to enter our current data to website currently only functions properly in IE6. I would like the code to work properly in Firefox 2 and IE7.


**3.** === Add auto product data insertion feature

Have barcode scanner, need a way to talk with outside DB and be able to add/edit product to our site.

Thank you for your consideration in quoting this project.

## Deliverables

Specifies for the brief outline given above:



**3 updates needed to our osCommerce site in the Admin section.**

**1.** === Add Product Types to S&H setup.

Our osCommerce s&h fees are set up by the product type. Would like to add extra product types to our data entry form and have new product types displayed where current product types are displayed.
Currently we have the following product types:
Music Reg
Music Fat
DVD
Video Game
Book

Would like to add Product Types:
Paintings (shipping price should be individually added since they will be various sizes)
Prints (shipping price should be individually added)
Posters (same shipping set up as current product types [$[url removed, login to view] S&H each])

Each PRoduct type has formats.

Painting Formats:
Acrylic
Oil
Watercolor

Prints Formats:
Glicee
Silkscreen

Posters Formats:
Four Color Press
Duo Tone Press

**2.** === Update Javascript functionality in Add/Edit Product page.

The custom javascript code to enter our current data to website currently only functions properly in IE6. I would like the code to also work properly in Firefox 2 and IE7.


**3.** === Add auto product data insertion feature

Data should be transferable via XML. Please see: [url removed, login to view]

IF product type == Music Reg or Music Fat {

Have a way for our website to take any of the following info from a product (barcode or text to be entered via search box - admin site currently has search box but does not yet search for UPC code)

1. upc code
2. artist
3. title

and search our database for the item.

IF item is in our DB, then bring up the current Edit Product page in admin so we can edit quantity conditions of product. (this last statement is how the program works now, so no change needed here.)


ELSE IF the item is not in our DB, then contact [url removed, login to view] for the following

1 upc code (if available)
2 artist
3 CD title

and return the CD info. Then give a way for us to:
1. choose the correct CD out of a list of returned data.
2. display the CD data in our current New Product form. Allow us to edit data as needed in that same form.
3. allow us to add CD info to our database via our current New Product form, and if edit corrections were needed allow us to click a button to update Musicbrainz.org.


ELSE IF the item NOT in our DB AND NOT in [url removed, login to view], then
we would like to add the data to our DB manually in our usual way..
but also add the info to musicbrainz.org.
}

Else for other product types {for now we'll continue to enter the data manually but could be future project.}


Thank you for your consideration in quoting this project.

Skills required:
Engineering, Javascript, MySQL, PHP, Project Management, Software Architecture, Software Testing, Web Hosting, Website Management, Website Testing, XML
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.