S
S
sputnickk2020-04-17 09:18:55
MySQL
sputnickk, 2020-04-17 09:18:55

How to bulk update attribute values?

We transferred a huge store from the old site to a new one, imported data from the tables of the old site into

the
new
site ( base ) :

previously cleared. Everything is ok, everything works, but in some products and categories the connections are lost, for example, if you want to buy a variable product, you choose a color variation - an error with the color variation is written, it is solved by going to the products - attributes - Set rules - and on this particular attribute you click properties - update and everything works. The same with categories, you go by category on the front - 404 error, just update the category (properties - update) - it is restored.

I checked the values ​​of the tables wp_term_relationships and so on - everything is there, ID_shki match.

If the attribute values ​​​​would be like categories - half a hundred, I updated it with my hands in a couple of hours without problems, but there are several thousand attributes.

Googled bulc update woocomerce atribute valuses - everything leads to updating the attributes of the products themselves, and all similar plugins do the same, but it is the attribute (values) itself that needs to be updated.

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question