Upgrading Content Management System on MYSQL PHP

111pinknails

Can anyone tell me if it is possible to upgrade the content management system on MYSQL PHP, we are having a new website built and our web developer has designed the content management system, which on the whole works, but because we have a large database of over 10,000 products some of which appear in more than one category, the backend is very temperamental and difficult to manage, the primary problem being there is no facility to bulk edit, so for instance if we have a t-shirt that appears six times (one for each colour) and the t-shirt needs to be moved into a different category or even removed altogether, this would take a minimum of two click per each colour, rather than being able to move all at once? Any ideas would be much appreciated as it is a very laborious process. Additionally I am finding problems with the database not displaying products in a 'c' level category even though the box has been ticked, it will only display if I hit the submit button each time, and with over 500 products in some of the categories this is very time consuming. I think this must be a coding issue?:bemused:

Weedpacket

It would be impossible to say. There are any number of content management systems developed to use MySQL and PHP even without counting those that are custom-made for one client. It all comes down to what the developer has implemented (or is capable of implementing) and how it accords with what they have been contracted to implement.

111pinknails

Weedpacket;11034159 wrote:
It would be impossible to say. There are any number of content management systems developed to use MySQL and PHP even without counting those that are custom-made for one client. It all comes down to what the developer has implemented (or is capable of implementing) and how it accords with what they have been contracted to implement.

Are there any members that might be able to take a look for me and come up with some suggestions?

johanafm

111pinknails;11034151 wrote:
I think this must be a coding issue?:bemused:

Actually, it sounds like a schema design (the structure of your database data storage) issue. It may "simply" be bad presentation / ui design. Should the system be otherwise well coded, with a good separation of presentation and business logic, this shouldn't be too hard to fix. But if there's a problem due to bad schema design, it's not unlikely that whomever made it also have made the rest of the code a mess, and then it'd be harder to fix.

111pinknails;11034171 wrote:
Are there any members that might be able to take a look for me

I could if I was otherwise unemployed and you paid me well…

111pinknails;11034171 wrote:
and come up with some suggestions?

The best way of getting someone to do this is paying someone to do this. Just like the best way of getting someone build a new roof on your house
is paying someone to build a new roof on your house. If you have no idea at all about how these things work, you might want to consider paying two differnet people/companies to assess the current status independently so that you may compare their suggested courses of action.