VM category issue

Here is my issue:

I have over a large number of categories and sub categories and so on, to be honest about 66,000

Well why you ask, becuase im creating an automotive peroformance parts website and the stucture for each car goes like this

make/model/year/ then a selection of about 9 categories like engine, suspension, brakes, and some sub categories under some

So overall it spans with all the cars to about 66,000 categories.

Virtuemart is fine in the frontend. does'nt slow down at all. It can handle all those categories


my issue is having all those categories load when adding or editing a product from the back end.

In the back end on the edit product page. ([url removed, login to view]) It loads all the categories at once, which is 60 thousand queries executed.

Here is what i thinking:

What i need is a better way of loading and selecting the categories in the product form, in the back end.

Maybe it can load all the parent categories first so it doesnt load 66 thousand things. Then in a tree like structure, like clicking a plus sign, then it will just load the sub categories then so on with all child categories under it. and have it just load when clicked to show.

I dont know if this can be done or if there is a better method but im all ears.

Also a possibility.

Since i just do all my categorie management thru CSV, Then what i can work with is, how about just when i open to edit a product cant, it just load and display all the categories already assigned to it?

Ive already tryed to remove form that displays the categories and it helps as it doesnt load all those categories anymore but then i get this error when i try and save it "error: must select a category"

Even if i could just remove that error i would be happy.

I dont know im open for ideas.

Ive added a pic to show you the categorie form from the backend i was talking about.

Thank you

So my question is

Ether, how to i remove the must select category error


How do i get it to load about a quarter or the categories in that area, or just load the categories allready assigned to the product.


joomla [url removed, login to view]

Virtuemart: [url removed, login to view]

Please help a poor soul

Thank you.

Evner: AJAX

Se mere: work in nt, vm management, parts tree, nt a car, just brakes, how do i get to work from here, c# category, how do i save, Suspension, sub editing, Soul, parent, nt, my website is so slow, loading product, just remove, issue, creating question, select category, joomla ask question, joomla edit category, tree category php, engine car, structure tree, management issue

Om arbejdsgiveren:
( 1 bedømmelse ) flagstaff, United States

Projekt ID: #274342

3 freelancere byder i gennemsnit $83 på dette job


we can do it

$75 USD på 1 dag
(10 bedømmelser)

I can do this

$75 USD på 1 dag
(2 bedømmelser)

Hi, I can provide the mod as discussed Thanks

$100 USD in 15 dage
(0 bedømmelser)