osCommerce Music Service UPC update

Closed

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: Engineering, Javascript, MySQL, PHP, Project Management, Software Architecture, Software Testing, Web Hosting, Website Management, Website Testing, XML

See more: xml data entry form, wiki website us, watercolor artist, video edit service, update oscommerce 2.2 to 2.3.1, upc barcode scanner, new product brief, info data entry works, i need artist for a book, edit service, custom video game music, custom game music, bring your a game to work book, artist's posters, artist's book, service fees, Painting oil, oil painting how to, h game, color corrections, data entry form types, admin and data entry service, video game music, update product page, silkscreen

Project ID: #3737209

1 freelancer is bidding on average $850 for this job

alphaleap

See private message.

$850 USD in 14 days
(20 Reviews)
5.4