{
"query_block": {
"select_id": 1,
"table": {
"table_name": "shared_option_variants",
"access_type": "system",
"possible_keys": ["PRIMARY", "company_id"],
"rows": 0,
"filtered": 0,
"const_row_not_found": true
},
"read_sorted_file": {
"filesort": {
"sort_key": "a.position, a.variant_id",
"table": {
"table_name": "a",
"access_type": "range",
"possible_keys": ["option_id", "option_id_2", "status"],
"key": "option_id",
"key_length": "6",
"used_key_parts": ["option_id", "status"],
"rows": 133,
"filtered": 100,
"index_condition": "a.option_id in (22655,22656,22571,22572,22575,22576,23629,23628) and a.`status` = 'A'"
}
}
},
"table": {
"table_name": "b",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY"],
"key": "PRIMARY",
"key_length": "9",
"used_key_parts": ["variant_id", "lang_code"],
"ref": ["cscart_migrate.a.variant_id", "const"],
"rows": 1,
"filtered": 100,
"attached_condition": "trigcond(b.lang_code = 'en')"
}
}
}| variant_id | option_id | position | modifier | modifier_type | weight_modifier | weight_modifier_type | nav_skus | commercial_modifier | commercial_dn | same_as_option | price_overrides | base_cost | variant_name |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 222726 | 22571 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 222727 | 22572 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 222805 | 22575 | 0 | 0.000 | A | 0.000 | A | unselected | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 222806 | 22576 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 223891 | 22655 | 0 | 0.000 | A | 0.000 | A | unselected | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 223892 | 22656 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 238873 | 23628 | 0 | 0.000 | A | 0.000 | A | NA | 0.00 | 0.00 | 0 | 0.00 | None | |
| 238889 | 23629 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 222712 | 22571 | 3 | 0.000 | A | 0.000 | A | SBK | 0.00 | 0.00 | 0 | 0.00 | Standard Black | |
| 222764 | 22575 | 3 | 59.000 | A | 0.000 | A | 150 | 0.00 | 0.00 | 0 | 0.00 | 150-Black | |
| 238875 | 23629 | 3 | 0.000 | A | 0.000 | A | SBK | 0.00 | 0.00 | 0 | 0.00 | Standard Black | SBK | |
| 222713 | 22571 | 5 | 5.000 | A | 0.000 | A | SWH | 0.00 | 0.00 | 0 | 0.00 | Standard White | |
| 222728 | 22572 | 5 | 0.000 | A | 0.000 | A | 100 | 0.00 | 0.00 | 0 | 0.00 | 100-Black | |
| 222765 | 22575 | 5 | 59.000 | A | 0.000 | A | 250 | 0.00 | 0.00 | 0 | 0.00 | 250-White | |
| 222807 | 22576 | 5 | 0.000 | A | 0.000 | A | 975 | 0.00 | 0.00 | 0 | 0.00 | 975-Galvanized | |
| 223893 | 22656 | 5 | 0.000 | A | 0.000 | A | 975 | 0.00 | 0.00 | 0 | 0.00 | 975-Galvanized | |
| 238874 | 23628 | 5 | 33.000 | A | 0.000 | A | TS | 0.00 | 0.00 | 0 | 0.00 | On/Off Toggle Switch | |
| 238876 | 23629 | 5 | 0.000 | A | 0.000 | A | SWH | 0.00 | 0.00 | 0 | 0.00 | Standard White | SWH | |
| 222714 | 22571 | 10 | 10.000 | A | 0.000 | A | CSB | 0.00 | 0.00 | 0 | 0.00 | Black Cloth | |
| 222729 | 22572 | 10 | 0.000 | A | 0.000 | A | 200 | 0.00 | 0.00 | 0 | 0.00 | 200-White | |
| 222766 | 22575 | 10 | 59.000 | A | 0.000 | A | 350 | 0.00 | 0.00 | 0 | 0.00 | 350-Vintage Green | |
| 222808 | 22576 | 10 | 0.000 | A | 0.000 | A | 100 | 0.00 | 0.00 | 0 | 0.00 | 100-Black | |
| 223894 | 22656 | 10 | 0.000 | A | 0.000 | A | 100 | 0.00 | 0.00 | 0 | 0.00 | 100-Black | |
| 238877 | 23629 | 10 | 0.000 | A | 0.000 | A | CSB | 0.00 | 0.00 | 0 | 0.00 | Black Cloth | CSB | |
| 222715 | 22571 | 15 | 10.000 | A | 0.000 | A | SLVR | 0.00 | 0.00 | 0 | 0.00 | Silver Cloth | |
| 222767 | 22575 | 15 | 59.000 | A | 0.000 | A | 355 | 0.00 | 0.00 | 0 | 0.00 | 355-Jadite | |
| 222809 | 22576 | 15 | 13.000 | A | 0.000 | A | 997 | 0.00 | 0.00 | 0 | 0.00 | 997-Raw Brass | |
| 223895 | 22656 | 15 | 13.000 | A | 0.000 | A | 997 | 0.00 | 0.00 | 0 | 0.00 | 997-Raw Brass | |
| 238878 | 23629 | 15 | 0.000 | A | 0.000 | A | CSW | 0.00 | 0.00 | 0 | 0.00 | White Cloth | CSW | |
| 222716 | 22571 | 20 | 10.000 | A | 0.000 | A | CRM | 0.00 | 0.00 | 0 | 0.00 | Creme Cloth | |
| 222770 | 22575 | 20 | 59.000 | A | 0.000 | A | 650 | 0.00 | 0.00 | 0 | 0.00 | 650-Bronze | |
| 222810 | 22576 | 20 | 17.000 | A | 0.000 | A | 998 | 0.00 | 0.00 | 0 | 0.00 | 998-Weathered Brass | |
| 223896 | 22656 | 20 | 17.000 | A | 0.000 | A | 998 | 0.00 | 0.00 | 0 | 0.00 | 998-Weathered Brass | |
| 238879 | 23629 | 20 | 0.000 | A | 0.000 | A | CSR | 0.00 | 0.00 | 0 | 0.00 | Red Cloth | CSR | |
| 222717 | 22571 | 25 | 10.000 | A | 0.000 | A | BPNK | 0.00 | 0.00 | 0 | 0.00 | Blush Pink Cloth | |
| 222768 | 22575 | 25 | 76.000 | A | 0.000 | A | 455 | 0.00 | 0.00 | 0 | 0.00 | 455-Cherry Red | |
| 238880 | 23629 | 25 | 0.000 | A | 0.000 | A | CSBW | 0.00 | 0.00 | 0 | 0.00 | Black & White Cloth | CSBW | |
| 222718 | 22571 | 30 | 20.000 | A | 0.000 | A | CNF | 0.00 | 0.00 | 0 | 0.00 | Confetti Cloth | |
| 222769 | 22575 | 30 | 76.000 | A | 0.000 | A | 550 | 0.00 | 0.00 | 0 | 0.00 | 550-Yellow | |
| 238881 | 23629 | 30 | 0.000 | A | 0.000 | A | CSRW | 0.00 | 0.00 | 0 | 0.00 | Red & White Cloth | CSRW | |
| 222719 | 22571 | 35 | 10.000 | A | 0.000 | A | RST | 0.00 | 0.00 | 0 | 0.00 | Rust Cloth | |
| 222771 | 22575 | 35 | 76.000 | A | 0.000 | A | 750 | 0.00 | 0.00 | 0 | 0.00 | 750-Cobalt Blue | |
| 238882 | 23629 | 35 | 0.000 | A | 0.000 | A | CSBG | 0.00 | 0.00 | 0 | 0.00 | Black & Gold Cloth | CSBG | |
| 222720 | 22571 | 40 | 15.000 | A | 0.000 | A | RBS | 0.00 | 0.00 | 0 | 0.00 | Barn Red & Black Swirl Cloth | |
| 222772 | 22575 | 40 | 76.000 | A | 0.000 | A | 765 | 0.00 | 0.00 | 0 | 0.00 | 765-Delphite Blue | |
| 238883 | 23629 | 40 | 0.000 | A | 0.000 | A | CSBP | 0.00 | 0.00 | 0 | 0.00 | Black & Pink Cloth | CSBP | |
| 222721 | 22571 | 45 | 10.000 | A | 0.000 | A | ORG | 0.00 | 0.00 | 0 | 0.00 | Orange Cloth | |
| 222773 | 22575 | 45 | 76.000 | A | 0.000 | A | 850 | 0.00 | 0.00 | 0 | 0.00 | 850-Graphite | |
| 238884 | 23629 | 45 | 0.000 | A | 0.000 | A | CSGW | 0.00 | 0.00 | 0 | 0.00 | Gold & White Cloth | CSGW | |
| 222722 | 22571 | 50 | 10.000 | A | 0.000 | A | YLW | 0.00 | 0.00 | 0 | 0.00 | Buttery Yellow Cloth | |
| 222774 | 22575 | 50 | 76.000 | A | 0.000 | A | 950 | 0.00 | 0.00 | 0 | 0.00 | 950-Metallic Chrome | |
| 238885 | 23629 | 50 | 0.000 | A | 0.000 | A | CSUW | 0.00 | 0.00 | 0 | 0.00 | Blue & White Cloth | CSUW | |
| 222723 | 22571 | 55 | 10.000 | A | 0.000 | A | NGRN | 0.00 | 0.00 | 0 | 0.00 | Neon Green Cloth | |
| 222775 | 22575 | 55 | 0.000 | A | 0.000 | A | 100 | 0.00 | 0.00 | 0 | 0.00 | 100-Black | |
| 223861 | 22655 | 55 | 0.000 | A | 0.000 | A | 100 | 0.00 | 0.00 | 0 | 0.00 | 100-Black | |
| 238886 | 23629 | 55 | 0.000 | A | 0.000 | A | CSBB | 0.00 | 0.00 | 0 | 0.00 | Black & Brown Chevron Cloth | CSBB | |
| 222724 | 22571 | 60 | 10.000 | A | 0.000 | A | EGRN | 0.00 | 0.00 | 0 | 0.00 | Emerald Green Cloth | |
| 222776 | 22575 | 60 | 0.000 | A | 0.000 | A | 105 | 0.00 | 0.00 | 0 | 0.00 | 105-Textured Black | |
| 223862 | 22655 | 60 | 0.000 | A | 0.000 | A | 105 | 0.00 | 0.00 | 0 | 0.00 | 105-Textured Black | |
| 238887 | 23629 | 60 | 0.000 | A | 0.000 | A | CRZ | 0.00 | 0.00 | 0 | 0.00 | Red Chevron Cloth | CRZ | |
| 222725 | 22571 | 65 | 20.000 | A | 0.000 | A | FGRN | 0.00 | 0.00 | 0 | 0.00 | Fern Green Chevron Cloth | |
| 222777 | 22575 | 65 | 0.000 | A | 0.000 | A | 200 | 0.00 | 0.00 | 0 | 0.00 | 200-White | |
| 223863 | 22655 | 65 | 0.000 | A | 0.000 | A | 200 | 0.00 | 0.00 | 0 | 0.00 | 200-White | |
| 238888 | 23629 | 65 | 0.000 | A | 0.000 | A | CMG | 0.00 | 0.00 | 0 | 0.00 | Grey Cloth | CMG | |
| 222778 | 22575 | 70 | 0.000 | A | 0.000 | A | 300 | 0.00 | 0.00 | 0 | 0.00 | 300-Dark Green | |
| 223864 | 22655 | 70 | 0.000 | A | 0.000 | A | 300 | 0.00 | 0.00 | 0 | 0.00 | 300-Dark Green | |
| 243091 | 22571 | 70 | 10.000 | A | 0.000 | A | SFM | 0.00 | 0.00 | 0 | 0.00 | Seafoam Cloth | |
| 222779 | 22575 | 75 | 0.000 | A | 0.000 | A | 975 | 0.00 | 0.00 | 0 | 0.00 | 975-Galvanized | |
| 223865 | 22655 | 75 | 0.000 | A | 0.000 | A | 975 | 0.00 | 0.00 | 0 | 0.00 | 975-Galvanized | |
| 243092 | 22571 | 75 | 10.000 | A | 0.000 | A | SBLU | 0.00 | 0.00 | 0 | 0.00 | Sky Blue Cloth | |
| 222780 | 22575 | 80 | 0.000 | A | 0.000 | A | 605 | 0.00 | 0.00 | 0 | 0.00 | 605-Textured Rust | |
| 223866 | 22655 | 80 | 0.000 | A | 0.000 | A | 605 | 0.00 | 0.00 | 0 | 0.00 | 605-Rust | |
| 243093 | 22571 | 80 | 10.000 | A | 0.000 | A | RBLU | 0.00 | 0.00 | 0 | 0.00 | Royal Blue Cloth | |
| 236890 | 22655 | 82 | 18.000 | A | 0.000 | A | 106 | 0.00 | 0.00 | 0 | 0.00 | 106-Matte Black | |
| 236891 | 22655 | 83 | 18.000 | A | 0.000 | A | 206 | 0.00 | 0.00 | 0 | 0.00 | 206-Matte White | |
| 222781 | 22575 | 85 | 18.000 | A | 0.000 | A | 307 | 0.00 | 0.00 | 0 | 0.00 | 307-Emerald Green | |
| 243094 | 22571 | 85 | 10.000 | A | 0.000 | A | NVY | 0.00 | 0.00 | 0 | 0.00 | Navy Cloth | |
| 223867 | 22655 | 86 | 18.000 | A | 0.000 | A | 307 | 0.00 | 0.00 | 0 | 0.00 | 307-Emerald Green | |
| 241746 | 22575 | 86 | 18.000 | A | 0.000 | A | 320 | 0.00 | 0.00 | 0 | 0.00 | 320-Fern Green | |
| 246057 | 22655 | 87 | 18.000 | A | 0.000 | A | 311 | 0.00 | 0.00 | 0 | 0.00 | 311-Jadite | |
| 222804 | 22575 | 88 | 18.000 | A | 0.000 | A | 370 | 0.00 | 0.00 | 0 | 0.00 | 370-Mint | |
| 223890 | 22655 | 88 | 18.000 | A | 0.000 | A | 370 | 0.00 | 0.00 | 0 | 0.00 | 370-Mint | |
| 222782 | 22575 | 90 | 18.000 | A | 0.000 | A | 380 | 0.00 | 0.00 | 0 | 0.00 | 380-Chartreuse | |
| 223868 | 22655 | 90 | 18.000 | A | 0.000 | A | 380 | 0.00 | 0.00 | 0 | 0.00 | 380-Chartreuse | |
| 222783 | 22575 | 95 | 18.000 | A | 0.000 | A | 390 | 0.00 | 0.00 | 0 | 0.00 | 390-Teal | |
| 223869 | 22655 | 95 | 18.000 | A | 0.000 | A | 390 | 0.00 | 0.00 | 0 | 0.00 | 390-Teal | |
| 222784 | 22575 | 100 | 18.000 | A | 0.000 | A | 400 | 0.00 | 0.00 | 0 | 0.00 | 400-Barn Red | |
| 223870 | 22655 | 100 | 18.000 | A | 0.000 | A | 400 | 0.00 | 0.00 | 0 | 0.00 | 400-Barn Red | |
| 222785 | 22575 | 105 | 18.000 | A | 0.000 | A | 420 | 0.00 | 0.00 | 0 | 0.00 | 420-Orange | |
| 223871 | 22655 | 105 | 18.000 | A | 0.000 | A | 420 | 0.00 | 0.00 | 0 | 0.00 | 420-Orange | |
| 241747 | 22575 | 108 | 18.000 | A | 0.000 | A | 430 | 0.00 | 0.00 | 0 | 0.00 | 430-Soft Clay | |
| 222786 | 22575 | 110 | 18.000 | A | 0.000 | A | 470 | 0.00 | 0.00 | 0 | 0.00 | 470-Watermelon | |
| 223872 | 22655 | 110 | 18.000 | A | 0.000 | A | 470 | 0.00 | 0.00 | 0 | 0.00 | 470-Watermelon | |
| 222787 | 22575 | 115 | 18.000 | A | 0.000 | A | 480 | 0.00 | 0.00 | 0 | 0.00 | 480-Blush Pink | |
| 223873 | 22655 | 115 | 18.000 | A | 0.000 | A | 480 | 0.00 | 0.00 | 0 | 0.00 | 480-Blush Pink | |
| 222788 | 22575 | 120 | 18.000 | A | 0.000 | A | 490 | 0.00 | 0.00 | 0 | 0.00 | 490-Magenta | |
| 223874 | 22655 | 120 | 18.000 | A | 0.000 | A | 490 | 0.00 | 0.00 | 0 | 0.00 | 490-Magenta | |
| 222789 | 22575 | 125 | 18.000 | A | 0.000 | A | 495 | 0.00 | 0.00 | 0 | 0.00 | 495-Sherbet Orange | |
| 223875 | 22655 | 125 | 18.000 | A | 0.000 | A | 495 | 0.00 | 0.00 | 0 | 0.00 | 495-Sherbet Orange | |
| 222790 | 22575 | 130 | 18.000 | A | 0.000 | A | 500 | 0.00 | 0.00 | 0 | 0.00 | 500-Buttery Yellow | |
| 223876 | 22655 | 130 | 18.000 | A | 0.000 | A | 500 | 0.00 | 0.00 | 0 | 0.00 | 500-Buttery Yellow | |
| 222791 | 22575 | 135 | 18.000 | A | 0.000 | A | 570 | 0.00 | 0.00 | 0 | 0.00 | 570-Sunflower | |
| 223877 | 22655 | 135 | 18.000 | A | 0.000 | A | 570 | 0.00 | 0.00 | 0 | 0.00 | 570-Sunflower | |
| 222792 | 22575 | 140 | 18.000 | A | 0.000 | A | 600 | 0.00 | 0.00 | 0 | 0.00 | 600-Bronze | |
| 223878 | 22655 | 140 | 18.000 | A | 0.000 | A | 600 | 0.00 | 0.00 | 0 | 0.00 | 600-Bronze | |
| 222793 | 22575 | 145 | 18.000 | A | 0.000 | A | 601 | 0.00 | 0.00 | 0 | 0.00 | 601-Chocolate | |
| 223879 | 22655 | 145 | 18.000 | A | 0.000 | A | 601 | 0.00 | 0.00 | 0 | 0.00 | 601-Chocolate | |
| 241748 | 22575 | 148 | 18.000 | A | 0.000 | A | 607 | 0.00 | 0.00 | 0 | 0.00 | 607-Taupe | |
| 222794 | 22575 | 150 | 18.000 | A | 0.000 | A | 615 | 0.00 | 0.00 | 0 | 0.00 | 615-Oil-Rubbed Bronze | |
| 223880 | 22655 | 150 | 18.000 | A | 0.000 | A | 615 | 0.00 | 0.00 | 0 | 0.00 | 615-Oil-Rubbed Bronze | |
| 241749 | 22575 | 153 | 18.000 | A | 0.000 | A | 630 | 0.00 | 0.00 | 0 | 0.00 | 630-Beige | |
| 222795 | 22575 | 155 | 18.000 | A | 0.000 | A | 700 | 0.00 | 0.00 | 0 | 0.00 | 700-Royal Blue | |
| 223881 | 22655 | 155 | 18.000 | A | 0.000 | A | 700 | 0.00 | 0.00 | 0 | 0.00 | 700-Royal Blue | |
| 222796 | 22575 | 160 | 18.000 | A | 0.000 | A | 705 | 0.00 | 0.00 | 0 | 0.00 | 705-Navy | |
| 223882 | 22655 | 160 | 18.000 | A | 0.000 | A | 705 | 0.00 | 0.00 | 0 | 0.00 | 705-Navy | |
| 246058 | 22655 | 163 | 18.000 | A | 0.000 | A | 710 | 0.00 | 0.00 | 0 | 0.00 | 710-Cobalt Blue | |
| 246059 | 22655 | 164 | 18.000 | A | 0.000 | A | 715 | 0.00 | 0.00 | 0 | 0.00 | 715-Delphite Blue | |
| 222797 | 22575 | 165 | 18.000 | A | 0.000 | A | 800 | 0.00 | 0.00 | 0 | 0.00 | 800-Industrial Grey | |
| 223883 | 22655 | 165 | 18.000 | A | 0.000 | A | 800 | 0.00 | 0.00 | 0 | 0.00 | 800-Industrial Grey | |
| 222798 | 22575 | 170 | 18.000 | A | 0.000 | A | 805 | 0.00 | 0.00 | 0 | 0.00 | 805-Charcoal Granite | |
| 223884 | 22655 | 170 | 18.000 | A | 0.000 | A | 805 | 0.00 | 0.00 | 0 | 0.00 | 805-Charcoal Granite | |
| 246060 | 22655 | 172 | 18.000 | A | 0.000 | A | 810 | 0.00 | 0.00 | 0 | 0.00 | 810-Graphite | |
| 241750 | 22575 | 173 | 18.000 | A | 0.000 | A | 815 | 0.00 | 0.00 | 0 | 0.00 | 815-Light Grey | |
| 222799 | 22575 | 175 | 61.000 | A | 0.000 | A | 995 | 0.00 | 0.00 | 0 | 0.00 | 995-Raw Copper | |
| 223885 | 22655 | 175 | 61.000 | A | 0.000 | A | 995 | 0.00 | 0.00 | 0 | 0.00 | 995-Raw Copper | |
| 222800 | 22575 | 180 | 91.000 | A | 0.000 | A | 996 | 0.00 | 0.00 | 0 | 0.00 | 996-Weathered Copper | |
| 223886 | 22655 | 180 | 91.000 | A | 0.000 | A | 996 | 0.00 | 0.00 | 0 | 0.00 | 996-Weathered Copper | |
| 222801 | 22575 | 185 | 91.000 | A | 0.000 | A | 999 | 0.00 | 0.00 | 0 | 0.00 | 999-Oil-Rubbed Copper | |
| 223887 | 22655 | 185 | 91.000 | A | 0.000 | A | 999 | 0.00 | 0.00 | 0 | 0.00 | 999-Oil-Rubbed Copper | |
| 222802 | 22575 | 190 | 92.000 | A | 0.000 | A | 997 | 0.00 | 0.00 | 0 | 0.00 | 997-Raw Brass | |
| 223888 | 22655 | 190 | 92.000 | A | 0.000 | A | 997 | 0.00 | 0.00 | 0 | 0.00 | 997-Raw Brass | |
| 222803 | 22575 | 195 | 121.000 | A | 0.000 | A | 998 | 0.00 | 0.00 | 0 | 0.00 | 998-Weathered Brass | |
| 223889 | 22655 | 195 | 121.000 | A | 0.000 | A | 998 | 0.00 | 0.00 | 0 | 0.00 | 998-Weathered Brass |