cancel
Showing results for 
Search instead for 
Did you mean: 

Magento 2 MariaDB fields mapped to Product Import CSV colums

   Did you know you can see the translated content as per your choice?

Translation is in progress. Please check again after few minutes.

Magento 2 MariaDB fields mapped to Product Import CSV colums

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...