osCommerce - Variation SKU

Avg Bid (USD)
Project Budget (USD)
$250 - $750

Project Description:

I am currently in the process of developing an ecommerce website for the running/walking store I work for. We have been selling on Amazon.com for some time and would like to also sell our inventory on our website. We decided, probably prematurely, that we liked a certain osCommerce template so went with osCommerce for our shopping cart. Because we sell our inventory in store, on amazon, and now on the website we will be needing to keep our inventory in-sync across channels. To do this we have been using Webgility's ECC as a bridge between our ecommerce channels and our master database file (Quickbooks POS). ECC has built-in osCommerce functionality and we have added the proper module to our osCommerce store for linking with ECC. Our issue is how osCommerce does not track stock at the attribute level. We are primarily a shoe store so we will have various sizes and colors of any given shoe that will need to be consolidated under one product--and the quantities of each variation needs to be tracked. Each child product/variation will need to have a SKU assigned to it. It would also be nice if there was another field added for UPC. We thought that installing the osCommerce contribution "QTpro" would of solved this--but QTpro does not assign a SKU to each product variation. It is important that our inventory sync software "Webgility ECC" is able to see each product variation as a unique item for keeping the on-hand quantity correct. I suspect a modification of the contribution QTpro is in order--but I do not see anyone who has done this. See youtube video here for what it is I think I need--http://www.youtube.com/watch?v=_6aCD9MWKcM. The important work I need is the ability to add SKU's to each product variation. Example;

Nike Zoom Structure+ 16 (parent/main item) (no SKU needed for parent item)

Size:10.5 - Color: Grey/Blue - SKU - 001
Size: 11.0 - Color: Grey/Blue - SKU - 002
Size: 11.5 - Color: Grey/Blue - SKU - 003

I know that this isn't the clearest of explanations, but please ask me specific questions about the project and I can probably answer them. Price is negotiable as long as you are confident that you can deliver 100% the solution I am looking for.

Thanks for your time!

Skills required:
MySQL, OSCommerce, Quickbooks & Quicken, Shopping Carts
About the employer:
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.

$ 3608
in 30 days
$ 578
in 15 days
$ 695
in 7 days
Hire kagg
$ 768
in 5 days
Hire consus
$ 1051
in 15 days
$ 1400
in 35 days
Hire ecartsolutions
$ 277
in 2 days
$ 773
in 12 days
$ 250
in 5 days
$ 1052
in 21 days