Onedesksolutions OS Commerce

Description

Attached is a sample excel file. will need to create a category variants table

1) tool to upload excel files

bread crumb will create category

for example

Home > Electronics > Cameras and Photography > Digital Camera Accessories

will create Elecronics ( if it does not exist )

Cameras and Photography will be under Electronics ( if it does not exist )

Digital Camera Accessories will be under Cameras and photography (if it does not exist )

i will need a tool to merge categories too because there will be duplication

2) create variants for categories like product variants. this will require a new table

In oscommerce admin under Content there is product variants

i need a link called category variants

when you click under category variants it will have a drop down with categories

after selectin categories it will show 1st level variant. i.e. Brand

after clicking brand it will show all brands for the category uploaded from excel file

Note: All fields must be uploaded EXCEPT PRICE, STORE

3) New product link will first have a drop down with category

After selecting category it will goto the normal add product screen with an extra category Variants tab

These will come from category variants table

4) under Data i will need a 2 new fields called CF Item No and CF UPC

this will need to be in the database

5) Under new product > General

i will need 4 new text boxes named

Features, Specifications, Included Components, Instructions

MySQL OSCommerce PHP

Project ID: #685606

About the project