Allow Virtuemart to handle a large amount of categories

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.

please disregard all the information under "So my question is" accident.

Kemahiran: Joomla, PHP

Lihat lagi: virtuemart slow, virtuemart cars, virtuemart slow category load, virtuemart select category backend large amount categorie, virtuemart category slow, virtuemart show money ammount, remove virtuemart subcategories, virtuemart remove subcategories, virtuemart loading slow, slow categories virtuemart css, error category must selected virtuemart, virtuemart slow load, virtuemart load excel, virtuemart slow category, virtuemart product already assigned, work in nt, why would you like to work here, pending amount, parts tree, nt a car, just brakes, how do i get to work from here, could of, a cars, virtuemart slow queries

Tentang Majikan:
( 1 ulasan ) flagstaff, United States

ID Projek: #262000

13 pekerja bebas membida secara purata $388 untuk pekerjaan ini



$600 USD dalam 20 hari
(90 Ulasan)

I can help you to solve the issue.

$300 USD dalam 7 hari
(95 Ulasan)

Hi Greetings from TIS INDIA, TIS India is one of the best PHP/AJAX Programmer, Web Designer Company in New Delhi, India. Our domain of expertise include: PHP/AJAX Programming, Web Development, Multimedia Graphics and F Lagi

$700 USD dalam 5 hari
(37 Ulasan)

We can do it for you,please check the pmb,Thank you,Janky

$300 USD dalam 5 hari
(47 Ulasan)

read and understand your project... let starts

$300 USD dalam 5 hari
(196 Ulasan)

I am the expert in such things. Let me complete your project quickly with a top quantity. Regards.

$250 USD dalam 3 hari
(60 Ulasan)

We are a Pune based Software Development and IT Company based in Pune, India. We have gone through the information provided by you and we understand your requirement very well. We have excellent expertise in PHP5 , MYS Lagi

$700 USD dalam 15 hari
(7 Ulasan)

Please check pmb

$250 USD dalam 5 hari
(51 Ulasan)

Hi, I suggest we build an AJAX searchbox for adding categories. The box would allow search-as-you-type and would paginate the results. This way you'll get only the categories subset you're interested in, and only 'n' r Lagi

$250 USD dalam 5 hari
(3 Ulasan)

Please see PM.

$400 USD dalam 15 hari
(5 Ulasan)

if ,you are interested in some serious work,than lets our team [url removed, login to view] know us some of our customize zoomla sites. etesting(dot)com aiqglobal(dot)com

$500 USD dalam 15 hari
(0 Ulasan)

Please check PM

$250 USD dalam 10 hari
(0 Ulasan)

Hi, Please read PMB for details. Thanks and Regards.

$250 USD dalam 3 hari
(0 Ulasan)