oscommerce errors+new modules

Hi everybody,

Please read this first before bidding: SERIOUS BIDDERS ONLY, NO TIME WASTERS

I am very frustrated because I have to repost this job as my previous service provider has failed to deliver what he promised to. So before bidding, please read carefully and make sure you have enough knowledge and time.(do not pretend you will do the job faster than you actually can)

I have made a oscommerce website using a template but still have minor bugs and need few modifications. The site is working pretty well but I want it to be perfect. it shouldn’t be difficult for experienced Oscommerce programmers and installers.

1)"Products attributes" needs to be fixed. The different options don't appear when I am uploading a new product. Might be a conflict with product extra fields.

2) Secure the website (SSL connection)

3)Search tool bug: Here's what happens when I am using the function

1066 - Not unique table/alias: 'pd'

select count(distinct p.products_id) as total from (products p left join products_to_products_extra_fields p2pef on p.products_id=p2pef.products_id) left join manufacturers m on m.manufacturers_id=p.manufacturers_id, products_description pd left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c, products_extra_fields pef, products_description pd, categories c, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and pef.products_extra_fields_id=p2pef.products_extra_fields_id and ((pd.products_name like '%vdfvd%' or p.products_model like '%vdfvd%' or m.manufacturers_name like '%vdfvd%' or pef.products_extra_fields_name like '%vdfvd%' or p2pef.products_extra_fields_value like '%vdfvd%') )

4) Installation:

osCommerce PayPal IPN Module

MoneyBookers IPN

UltraPics - MS2 Image Addon Pack!

Purchase Without Account

Category Tabs with Subs

Credit Class & Gift Voucher

Google Checkout module for osCommerce

I know it's easy but I want to make sure it's safe and installed by a pro.

5) shipping module: I haven't had time to check the different modules available (Extraship v3.0) online but I want an option to ship internationaly and be able to easily modify rates/weight to:

- Asia

- Europe

- North America

-South America


Payments will be made in 2 stages; 50% of Payment will be made upon start of project and the last 50% will be made when 100% is completed, delivered without bugs (no partial, or bugs).

Skills: PHP, Shopping Carts

See more: what can i need for make a perfect website, want to make new site, voucher online, service provider template, service america, search online for programmers, search for online programmers, search for manufacturers, programmers search, products manufacturers, pef m, p.c. connection, paypal still pending, online voucher, online programmers working, online job for c programmers, new product manufacturers, new first search, manufacturers products, job options for programmers, i want programmers, had experienced, google checkout rates, gift categories, first programmers

About the Employer:
( 0 reviews ) seoul, Korea, Republic of

Project ID: #218063