The category is a structure of your catalog. By creating category customer can easily find the specific product amongst the lot on your e-commerce website.
It is used for making the hierarchical arrangement of your website. Here we have listed down steps to create a new category and root category in bagisto.
Bagisto comes with a default root category i.e Root but you can also create your own root category. Root Category is not visible on the front end because it acts as a container to contain the categories to be displayed on the website.
Click on Catalog>>Categories>>Add Category
Enter the general value like name, position, description and add images.
Display Mode- Display mode is about to which content detail visible on the category page. There is three option
Product and Description:-
When you set display mode “Product and Description” then product and description about the category both will be visible on the front end.
Product:-
When you set display mode “Product” then product will be visible on the front end.
Description:-
When you set display mode “Description” then only category description will be visible on the front end
Step 4
Attach the category image.
Do not select any category from Parent Category so as to be created as the root category.
You can select the filterable attributes so it will be visible on that category as layered navigation. Enter the slug and click on Save Channel.
Note:- Only select and multi-select type attribute will visible in the filterable attributes and make sure layered navigation should be “yes” in attributes.
Root Category will be visible on the product page while assigning that product in a particular category.
For creating a new category, you have to follow the above step only you have to do some below changes in step 5
Select any Parent Category (already created root category) under which you want to put the newly created category.
Your channel can have only one root category active at a time. Click on Setting>>Channels>>open the selected channel in Edit Mode>>select root category from the list>> Save Channel.
By following the above steps, you can easily create a new category and root category in Bagisto. Hope it will be helpful for you or if you have any issue feel free to raise a ticket at https://bagisto.uvdesk.com/en/
If you have more details or questions, you can reply to the received confirmation email.
Back to Home
The Issue:
When I select a parent category in order to create a sub-category, I get a database error – SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation ‘=’ (SQL: update
categories
set_lft
= case when_lft
between 16 and 17 then_lft
-2 when_lft
between 14 and 17 then_lft
+2 else_lft
end,_rgt
= case when_rgt
between 16 and 17 then_rgt
-2 when_rgt
between 14 and 17 then_rgt
+2 else_rgt
end where (_lft
between 14 and 17 or_rgt
between 14 and 17))Attempted Solution:
I edited the default database collation to utf8mb4_unicode_ci in operations but I still receive the exact same error.
Can you help, please?
Thanks in anticipation.