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