Hello Tony,

Thanks for putting your concern here. I understand that you are finding trouble with sellacious backend/frontend slowness as you have nearly Six thousand product categories.

I would like to convey here, that sellacious backend UI has nothing to do with how many categories or products you have in your Database as sellacious backend UI only show limited amount of categories or products in the backend UI so even if you have 10k categories sellacious backend UI won't be slow as it will anyway show 100-200 categories in list. However, if you are forcefully trying to list all Categories or all products in one list then the UI will definitely be slow and your browser may crash.

Also, the calculation of categories/products when done by sellacious is based on what filter or sorting options you have selected. This needs ample server resources, as more the data more CPU, ram, disk read-write speed will be required thus we always suggest using a good fast server with proper resources to tackle the slowness issue on a higher amount of data. If you are trying to run sellacious or any other software with lots of data on a shared server then also you might experience very slow and crashing website.

We also suggest creating fewer categories as it is anyway not good for the end user to explore throw that many product categories, you can rather use product filterable attribute. Taking the example of Biggest Marketplaces like Amazon they also do not have 5-6000 categories there could be a very good reason why they do not have them.

Rest assured that if all above guidelines are taken care of it will work very smoothly. Many enterprise clients are using sellacious with as many as 12k product categories, However, it's again not recommended due to bad UX of frontend and won't work well until and unless you have very customized frontend.


-Abhishek
Team sellacious

Hi Abhishek,

Thank you for your answer.

Indeed, I am able to decrease the number of category.


For example:

Agriculture --> (no product here, it's only a family category filter)
Agriculture/Agricultural Greenhouses --> (product here)
Agriculture/Animal Husbandry --> (no product here, it's only a family sub category filter )
Agriculture/Animal Husbandry/Dairy Products --> (no product here, it's only a sub sub category filter)
Agriculture/Animal Husbandry/Dairy Products/Butter --> (product here)

In my example, I have got 2 real product categories where sellers will be able to post their own products.

To reduce categories, I could only create 2 product categories instead of 5. Do you recommand to create a joomla menu about non-product category (in my example: "Agriculture", Animal Husbandry", and "Dairy Products"?

Do you think I could reduce also categories with custom fields?

For example if I post a product Inside "Dairy Products" category (product category in this example), I can use a custom field as a product category and choose between:

-Butter
-Canned Dairy Products
-Casein
-Cheese
-Condensed Milk
-Cream
-Ice Cream
-Lactose
-Milk
-Milk Powder
-Whey Powder
-Yogurt
-Other Dairy Products

and if I select "Butter" in my example, some other custom fields, corresponding to butter, appear to complete the description to my product.

Do you recommand this method?

Thank you for your answer.

Tony

Dear Tony,

Essentially if you want /butter in URL or breadcrumbs

OR

if you have other additional attributes based on a selection that should be created as a category.

Thus, in this case, it looks like using categories will be better, as you need attributes and url both.

-Abhishek
Team sellacious