Customised osCommerce Fixes

We have a live clothing/garments osCommerce website with extensive customisations.

Fixes required:

When we add Special prices the disable checkbox doesn't work.

Search by Size and Search by Description display disabled products and they should ignore disabled product including disabled special prices and categories.

Disabled categories need to disable all "child" products and categories - doesn't do this.

We are also trying to move the site to a new server that has MySQL 5, live server has MySQL 4. Most pages seem to work OK but we have one page (product listing) that is displaying the error message below - the column is definitely in the table - otherwise the other pages wouldn't work.

1054 - Unknown column 'p.products_id' in 'on clause'

select count(distinct p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '464'and p.master_product='1'

Please only bid if you have the experience and the time available to get these issues fixed quickly.

Compétences : Linux, PHP, Script Install, Design de site internet

en voir plus : s.a.p. experience, products manufacturers, new product manufacturers, manufacturers products, error fixes, castle a, a.m. castle, fixed prices, website fixes, php fixes, garments, fixes, child clothing, php mysql join table, mysql join table, mysql table join, trying, clothing description, php mysql error unknown column, customised, checkbox required, 1054 unknown column select, 1054 php, description product clothing, add checkbox website

Concernant l'employeur :
( 22 commentaires ) Shrewsbury, United Kingdom

Nº du projet : #55406

12 freelance font une offre moyenne de $217 pour ce travail


I can do it for you. regards.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(255 Commentaires)

Hi, i can finish it in 2 days, maximum Please, see PM

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(356 Commentaires)

I run a Sacramento, CA website design firm with 8 years of design experience developing over 70 websites, and 13 years of IT Engineering experience. Your bid includes a complete shopping cart system located at http://w Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(36 Commentaires)

Our bid is for really very high quality work for your Customised osCommerce Fixesthat will be made to be upgradable in case you need some upgrades in future. We will always be available for upgrades. Our bid includes s Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(78 Commentaires)

Hi I am UK based and can make the required changes and fixes to your OSCommerce site. I am experienced in OSCommerce and knowledgeable about the issues you are encountering. You can be assured of exceptional service Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(22 Commentaires)

It can be done easily and perfectly :) Escrow required.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(35 Commentaires)

please check my won project and PMB for demo

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(13 Commentaires)

please see PM for more details

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(13 Commentaires)

“We are team of professional’s expertise in developing web based application using PHP/ASP/.NET and in web designing using Photoshop, Dreamweaver MX, Flash [login to view URL] reading your project description, we are highly int Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(2 Commentaires)

Greetings, we have reviewed your outsourced project description in depth. We're confident we can a deliver a professional looking design(s) with proposed functionality to match your concept. We have several URLs, which Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)

Please check PMB

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 15 jours
(0 Commentaires)

I have no rating on this site yet, so my bid is low. I worked with osc and it's modifications many times. I can fix your problem with mysql5 within 10 minutes. 5 days maximum for whole project

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(0 Commentaires)