Skip to main content

How to change category product position in database

I want to change the position value of category product tab in category page from 0 to 2. When newly created product is created, its default position value was 0.

This is my progress as off now.

Category ID is 218

I already found the position attribute_id = 53

SELECT * FROM eav_attribute WHERE frontend_label = 'Position';

I want to change all the position value of specific category.

What tables do I need to look at?