Huge amount of Variations
-
Hi there, i was wondering if you could help me out with an issue im facing right now.
Im using woocommerce, and i have about 25 products, where every product has about 6700 variations (yeah i know, that’s a huge amount). An example data would be like :sku | value_a | value_b | price |
———————————————————————–
00000001 | 70cm | 100cm | 10,00 |
00000001 | 70cm | 101cm | 10,00 |
00000001 | 70cm | 102cm | 10,00 |
00000001 | 70cm | 103cm | 10,00 |
00000001 | 70cm | 104cm | 10,00 |
00000001 | 70cm | 105cm | 10,00 |
00000001 | 70cm | 106cm | 11,00 |
00000001 | 70cm | 107cm | 11,00 |
00000001 | 70cm | 108cm | 11,00 |
00000001 | 70cm | 109cm | 11,00 |
00000001 | 70cm | 110cm | 11,00 |
00000001 | 71cm | 100cm | 10,50 |
00000001 | 71cm | 101cm | 10,50 |
00000001 | 71cm | 102cm | 10,50 |
00000001 | 71cm | 103cm | 10,50 |
00000001 | 71cm | 104cm | 10,50 |
00000001 | 71cm | 105cm | 10,50 |
00000001 | 71cm | 106cm | 11,50 |
00000001 | 71cm | 107cm | 11,50 |
00000001 | 71cm | 108cm | 11,50 |
00000001 | 71cm | 109cm | 11,50 |
00000001 | 71cm | 110cm | 11,50 |and so on … value_a goes till 200cm and value_b goes till 220cm
as you can imagine, having in every product about 6700 different variations and in 25 products about 167.500 is a lot of data and the wordpress/woocommerce installation suffers massive from that.
So i was wondering if there is something, where for example it would load from a different db/table, or just to write some code to autopopulate in the single products page all the data (via ajax/js reading again from diferent db/table), without to break down the wordpress/woocommerce installation.
Any help is appreciated
Jan
- The topic ‘Huge amount of Variations’ is closed to new replies.