DataBase Field that represent default product attribute

[Reserve Joias]

Hi there everyone,

 

This is my first request for hep  thank you so much for everybody consideration.

Well, let`s go down to it. 

I am having a problem with an automation I am working at, in the TAB #2 where we configure product attributes there is our DEFAULT ATTRIBUTE radio button. How is this field set? And mainly WHERE?

I have found this in the following:

ps_product > cache_default_attribute
ps_product_attribute > default_on
ps_product_shop > cache_default_attribute

 

But when I change those fields to the data I want, when I open the product administration tab#2 I see no changes...

Is there someother table in DB that I am missing? Or do I need to run some cache cleaning procedure?

Thank you so much for helping us

Herbert Smith
 

[Bruno G]

I have the same problem in PS 1.7.6, and i can't find how to do it from the database (ps_product_attribute.default_on doesn't change anything)

EDIT :

It works, and to make it work, you have to set it in tables fields :

ps_product.cache_default_attribute

ps_product_shop.cache_default_attribute

ps_product_attribute.default_on

ps_product_attribute_shop.default_on

Edited July 31, 2020 by Bruno G (see edit history)