This is OSCommerce site, which needs some minor modification and data load.
I need two things done in this project for someone with expertise in OSCommerce and MySQL.
1. Currently price of the product shows only "$ 45" . I need to change that so it shows as "Our Price" and then shows actual price of the product (i.e. $ 45) I also need to show additional values like "Retail Price" and "You Save" on the website, I guess which will require new field/s in product table (and any other tables linked
with product). I don't know OSC schema well that I can do it myself, so you should know OSC schema well to do this change without breaking existing functionality. At the completion of job- when a product is displayed, there will be three prices shown: our price (this is actual price for the item), retail price, and you save.
This includes schema modification and any php files modification required.
2. I need to get about 4500 products loaded into database. This might be little tricky, since I need some adjustments made while loading data into database. Please see attached sample product file and read below instructions on how data needs to be loaded. I will provide a excel spreadsheet with same format as attached sample products file (with all products). All the products from the spreadsheet should get loaded in appropriate category and in format as outlined below.
Please see attached sample file to understand below instructions.
"NAME" column will be used for name of the product.
Products Desciption will consist of three columns "NAME", "TITLE", and "DESCRIPTION". But make sure that you add line breaks (br)(br) at the end of each column value, so when shown on website, it will have proper line breaks
(otherwise it will put everything in one long wrapped sentence). Also based on value of GENDER column, you will need to add MENS, WOMENS or UNISEX in the begining of the "TITLE" column. see example below:
line 1 - LE JARDIN by Dana - Womens
line 2 -
line 3 - WOMENS EDT SPRAY 1 OZ
line 4 -
line 3 - Launched by the design house of Dana in 1983, LE JARDIN by Dana is classified as a refreshing fragrance. This feminine scent posesses a blend of: fresh white flowers, very soft. It is recommended for daytime wear.
When inserting data into table, item id will be used from "ITEM" column instead of system generated item id.
You need to get VENDOR column populated (in spreadsheet) from NAME coulmn. For example if product name is "LE JARDIN by Dana", vendor name will be "Dana". You will then use this VENDOR column to populate "Products Manufacturer" in the database, so user can search proucts by manufacturer. You have to insert all manufacturers in database before you load any product in database, so products can be mapped to appropriate manufacturer.
Based on TITLE and GENDER of the item, item will go into the appropriate category. Below are category breakdowns.
categories list:
----------------
Perfume
Men's
Women's
Unisex
Miniatures
GiftSet
Men's
Women's
Unisex
Miniatures
Skincare
Men's
Women's
Haircare
Makeup
Bath & Body
Men's
Women's
Accessories
Men's
Women's
I will upload all images to database, so you just need to use value in the IMAGE column when loading data to the database. (assuming you will do sql data load, manual data entry will require all images to be on your computer and time consuming also)
Site url is: [login to view URL]
Please PMB for any questions.
Thanks
Ankit