I have 160,000 products on our Magento 2 store. Having to make changes through importing files in Admin is super slow.
I want to use the good old SQL scripts like UPDATE to change the info in certain tables, like crosssell_skus for products.
I have looked SELECT at the tables in my store and the tables that relate to crosssell are empty. So, were are is the data, as they all have 6 crosssell_sku products associated with them and they show in the cart?
That brings me to a bigger question that I'm sure many would like to know.
Is there a list of that Magento 2 product / catalog information is mapped to which MariaDB tables / fields?
I have looked all over the InterWeb and not found this information.
Cheers...
