Currently we have category and sub-category are free text and user can give anything.
Solution
We need to provide ability for the user to create set of category and related sub-category and related operations like delete or update the same.
Discussions
[x] The product schema to update to include sub-category and sub-category2.
[x] The sub-category and sub-category2 can never be null.
[x] We need to update the fetchProductAPI to facilitage search based on the 'category', 'sub-categoryand 'sub-category2. It should not be search like rather should be equal.
[x] We need to create the category table where fields will be id, name, Type(root(default), non-root), linked-categories(comma separated) and generic fields.
Problem
Currently we have
categoryandsub-categoryare free text and user can give anything.Solution
We need to provide ability for the user to create set of category and related sub-category and related operations like delete or update the same.
Discussions
sub-categoryandsub-category2.sub-categoryandsub-category2can never be null.fetchProductAPIto facilitage search based on the 'category', 'sub-categoryand 'sub-category2. It should not be search like rather should be equal.id, name, Type(root(default), non-root), linked-categories(comma separated) and generic fields.Linked to: #1