{
"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": 262,
"filtered": 100,
"index_condition": "a.option_id in (23149,21927,22853,21948,21949,22008,21950,22016,22017,23734,22659,21933,21934,21935,23328,21936,21937,21976,21977,23116,22644) 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 220140 | 21927 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 220192 | 21948 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 220193 | 21949 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 220198 | 22008 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 220203 | 22016 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 220205 | 22017 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 220211 | 21950 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 220255 | 21933 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 220256 | 21934 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 220257 | 21935 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 220286 | 21937 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 220315 | 21976 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 220316 | 21977 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 220414 | 21936 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 223755 | 22644 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 223933 | 22659 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 227176 | 22853 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 230828 | 23116 | 0 | 0.000 | A | 0.000 | A | unselected | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 231182 | 23149 | 0 | 0.000 | A | 0.000 | A | unselected | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 233546 | 23328 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 239505 | 23734 | 0 | 0.000 | A | 0.000 | A | skip | 0.00 | 0.00 | 0 | 0.00 | Please Select | |
| 233545 | 22659 | 2 | 0.000 | A | 0.000 | A | NA | 0.00 | 0.00 | 0 | 6.25 | No Guard | |
| 244494 | 21927 | 2 | 79.000 | A | 0.000 | A | M103 | 50.00 | 0.00 | 0 | 0.00 | M103-Black | |
| 244510 | 21937 | 2 | 0.000 | A | 0.000 | A | M103 | 0.00 | 0.00 | 0 | 0.00 | M103-Black | |
| 215265 | 21933 | 3 | 0.000 | A | 0.000 | A | CLR | 0.00 | 0.00 | 0 | 0.00 | Clear Glass | |
| 215275 | 21934 | 3 | 0.000 | A | 0.000 | A | CLR | 0.00 | 0.00 | 0 | 0.00 | Clear Glass | |
| 215285 | 21935 | 3 | 0.000 | A | 0.000 | A | CLR | 0.00 | 0.00 | 0 | 0.00 | Clear Glass | |
| 215295 | 21936 | 3 | 0.000 | A | 0.000 | A | 100 | 0.00 | 0.00 | 0 | 0.00 | 100-Black | |
| 215466 | 21948 | 3 | 0.000 | A | 0.000 | A | 0.00 | 0.00 | 21927 | 0.00 | Same as Shade | ||
| 215479 | 21949 | 3 | 0.000 | A | 0.000 | A | 0.00 | 0.00 | 21927 | 0.00 | Same as Shade | ||
| 215822 | 21976 | 3 | 0.000 | A | 0.000 | A | NA | 0.00 | 0.00 | 0 | 0.00 | None | |
| 215824 | 21977 | 3 | 0.000 | A | 0.000 | A | NA | 0.00 | 0.00 | 0 | 0.00 | None | |
| 216766 | 22008 | 3 | 0.000 | A | 0.000 | A | 100 | 0.00 | 0.00 | 0 | 0.00 | 100-Black | |
| 216996 | 22017 | 3 | 0.000 | A | 0.000 | A | 0.00 | 0.00 | 0 | 0.00 | Standard Canopy | ||
| 223930 | 22659 | 3 | 0.000 | A | 0.000 | A | WGG | 0.00 | 0.00 | 0 | 16.34 | Wire Guard | |
| 227163 | 22853 | 3 | 0.000 | A | 0.000 | A | ST506 | 0.00 | 0.00 | 0 | 0.00 | 6" Stem - ½" Diameter | |
| 244511 | 21937 | 4 | 0.000 | A | 0.000 | A | M200 | 0.00 | 0.00 | 0 | 0.00 | M200-White | |
| 215266 | 21933 | 5 | 10.000 | A | 0.000 | A | FST | 0.00 | 0.00 | 0 | 1.88 | Frosted Glass | |
| 215276 | 21934 | 5 | 10.000 | A | 0.000 | A | FST | 0.00 | 0.00 | 0 | 1.88 | Frosted Glass | |
| 215286 | 21935 | 5 | 10.000 | A | 0.000 | A | FST | 0.00 | 0.00 | 0 | 1.88 | Frosted Glass | |
| 215296 | 21936 | 5 | 0.000 | A | 0.000 | A | 105 | 0.00 | 0.00 | 0 | 0.00 | 105-Textured Black | |
| 215480 | 21949 | 5 | 0.000 | A | 0.000 | A | 100 | 0.00 | 0.00 | 0 | 0.00 | 100-Black | |
| 215510 | 21950 | 5 | 0.000 | A | 0.000 | A | 0.00 | 0.00 | 0 | 0.00 | Standard Canopy | ||
| 215823 | 21976 | 5 | 110.000 | A | 0.000 | A | DCHX | 0.00 | 0.00 | 0 | 27.50 | Copper Canopy & Hex Cover | |
| 215825 | 21977 | 5 | 121.000 | A | 0.000 | A | DCHX | 0.00 | 0.00 | 0 | 30.25 | Brass Canopy & Hex Cover | |
| 216767 | 22008 | 5 | 0.000 | A | 0.000 | A | 105 | 0.00 | 0.00 | 0 | 0.00 | 105-Textured Black | |
| 216993 | 22016 | 5 | 0.000 | A | 0.000 | A | 0.00 | 0.00 | 0 | 0.00 | Standard Canopy | ||
| 223756 | 22644 | 5 | 0.000 | A | 0.000 | A | 2700K | 0.00 | 0.00 | 0 | 0.00 | 2700K - Warm White/Soft White | |
| 223931 | 22659 | 5 | 0.000 | A | 0.000 | A | CGG | 0.00 | 0.00 | 0 | 1.50 | Cast Guard | |
| 227164 | 22853 | 5 | 1.000 | A | 0.000 | A | ST706 | 0.00 | 0.00 | 0 | 0.18 | 6" Stem - ¾" Diameter | |
| 230827 | 23116 | 5 | 0.000 | A | 0.000 | A | LED16.8 | 0.00 | 0.00 | 0 | 0.00 | 16.8W LED - 1600 Lumen | |
| 233547 | 23328 | 5 | 0.000 | A | 0.000 | A | CLR | 0.00 | 0.00 | 0 | 2.85 | Clear Glass | |
| 239506 | 23734 | 5 | 0.000 | A | 0.000 | A | 0.00 | 0.00 | 0 | 0.00 | None | ||
| 244495 | 21927 | 5 | 79.000 | A | 0.000 | A | M200 | 50.00 | 0.00 | 0 | 0.00 | M200-White | |
| 244502 | 21948 | 5 | 11.000 | A | 0.000 | A | M103 | 0.00 | 0.00 | 0 | 0.00 | M103-Black | |
| 244512 | 21937 | 6 | 0.000 | A | 0.000 | A | M305 | 0.00 | 0.00 | 0 | 0.00 | M305-Forest Green | |
| 244503 | 21948 | 7 | 11.000 | A | 0.000 | A | M200 | 0.00 | 0.00 | 0 | 0.00 | M200-White | |
| 244513 | 21937 | 8 | 0.000 | A | 0.000 | A | M603 | 0.00 | 0.00 | 0 | 0.00 | M603-Brown | |
| 215267 | 21933 | 10 | 13.000 | A | 0.000 | A | RIB | 0.00 | 0.00 | 0 | 3.15 | Ribbed Glass | |
| 215277 | 21934 | 10 | 13.000 | A | 0.000 | A | RIB | 0.00 | 0.00 | 0 | 3.15 | Ribbed Glass | |
| 215287 | 21935 | 10 | 13.000 | A | 0.000 | A | RIB | 0.00 | 0.00 | 0 | 3.15 | Ribbed Glass | |
| 215297 | 21936 | 10 | 0.000 | A | 0.000 | A | 200 | 0.00 | 0.00 | 0 | 0.00 | 200-White | |
| 215481 | 21949 | 10 | 0.000 | A | 0.000 | A | 105 | 0.00 | 0.00 | 0 | 0.00 | 105-Textured Black | |
| 215511 | 21950 | 10 | 44.000 | A | 0.000 | A | HSC | 0.00 | 0.00 | 0 | 11.00 | 25° Hang Straight Canopy | |
| 216768 | 22008 | 10 | 0.000 | A | 0.000 | A | 200 | 0.00 | 0.00 | 0 | 0.00 | 200-White | |
| 216994 | 22016 | 10 | 44.000 | A | 0.000 | A | HSC | 0.00 | 0.00 | 0 | 11.00 | 25° Hang Straight Canopy | |
| 216997 | 22017 | 10 | 44.000 | A | 0.000 | A | HSC | 0.00 | 0.00 | 0 | 11.00 | 25° Hang Straight Canopy | |
| 223757 | 22644 | 10 | 0.000 | A | 0.000 | A | 3000K | 0.00 | 0.00 | 0 | 0.00 | 3000K - Neutral White | |
| 227165 | 22853 | 10 | 3.000 | A | 0.000 | A | ST512 | 0.00 | 0.00 | 0 | 0.56 | 12" Stem - ½" Diameter | |
| 233548 | 23328 | 10 | 10.000 | A | 0.000 | A | FST | 0.00 | 0.00 | 0 | 1.88 | Frosted Glass | |
| 239507 | 23734 | 10 | 36.000 | A | 0.000 | A | SWK | 0.00 | 0.00 | 0 | 0.00 | Swivel Knuckle | |
| 244496 | 21927 | 10 | 79.000 | A | 0.000 | A | M305 | 50.00 | 0.00 | 0 | 0.00 | M305-Forest Green | |
| 244504 | 21948 | 10 | 11.000 | A | 0.000 | A | M305 | 0.00 | 0.00 | 0 | 0.00 | M305-Forest Green | |
| 244514 | 21937 | 10 | 0.000 | A | 0.000 | A | M415 | 0.00 | 0.00 | 0 | 0.00 | M415-Red | |
| 244505 | 21948 | 12 | 11.000 | A | 0.000 | A | M603 | 0.00 | 0.00 | 0 | 0.00 | M603-Brown | |
| 244515 | 21937 | 12 | 0.000 | A | 0.000 | A | M315 | 0.00 | 0.00 | 0 | 0.00 | M315-Seafoam | |
| 244506 | 21948 | 14 | 11.000 | A | 0.000 | A | M415 | 0.00 | 0.00 | 0 | 0.00 | M415-Red | |
| 244516 | 21937 | 14 | 0.000 | A | 0.000 | A | M803 | 0.00 | 0.00 | 0 | 0.00 | M803-Dark Grey | |
| 215298 | 21936 | 15 | 0.000 | A | 0.000 | A | 300 | 0.00 | 0.00 | 0 | 0.00 | 300-Dark Green | |
| 215482 | 21949 | 15 | 0.000 | A | 0.000 | A | 200 | 0.00 | 0.00 | 0 | 0.00 | 200-White | |
| 215512 | 21950 | 15 | 24.000 | A | 0.000 | A | HDSMC | 0.00 | 0.00 | 0 | 6.00 | Heavy Duty Canopy | |
| 216769 | 22008 | 15 | 0.000 | A | 0.000 | A | 300 | 0.00 | 0.00 | 0 | 0.00 | 300-Dark Green | |
| 216995 | 22016 | 15 | 24.000 | A | 0.000 | A | HDSMC | 0.00 | 0.00 | 0 | 6.00 | Heavy Duty Canopy | |
| 216998 | 22017 | 15 | 24.000 | A | 0.000 | A | HDSMC | 0.00 | 0.00 | 0 | 6.00 | Heavy Duty Canopy | |
| 223758 | 22644 | 15 | 0.000 | A | 0.000 | A | 3500K | 0.00 | 0.00 | 0 | 0.00 | 3500K - Bright White | |
| 223932 | 22659 | 15 | 0.000 | A | 0.000 | A | TGG | 0.00 | 0.00 | 0 | 1.50 | Heavy Duty Guard | |
| 227166 | 22853 | 15 | 4.000 | A | 0.000 | A | ST712 | 0.00 | 0.00 | 0 | 0.92 | 12" Stem - ¾" Diameter | |
| 231185 | 23149 | 15 | 18.000 | A | 0.000 | A | ASFC12 | 0.00 | 0.00 | 0 | 7.05 | 12" Shade | |
| 233549 | 23328 | 15 | 10.000 | A | 0.000 | A | RIB | 0.00 | 0.00 | 0 | 3.15 | Ribbed Glass | |
| 244497 | 21927 | 15 | 79.000 | A | 0.000 | A | M603 | 50.00 | 0.00 | 0 | 0.00 | M603-Brown | |
| 244507 | 21948 | 16 | 11.000 | A | 0.000 | A | M315 | 0.00 | 0.00 | 0 | 0.00 | M315-Seafoam | |
| 244517 | 21937 | 16 | 0.000 | A | 0.000 | A | M210 | 0.00 | 0.00 | 0 | 0.00 | M210-Cream | |
| 244508 | 21948 | 18 | 11.000 | A | 0.000 | A | M803 | 0.00 | 0.00 | 0 | 0.00 | M803-Dark Grey | |
| 215299 | 21936 | 20 | 0.000 | A | 0.000 | A | 975 | 0.00 | 0.00 | 0 | 0.00 | 975-Galvanized | |
| 215483 | 21949 | 20 | 0.000 | A | 0.000 | A | 300 | 0.00 | 0.00 | 0 | 0.00 | 300-Dark Green | |
| 216770 | 22008 | 20 | 0.000 | A | 0.000 | A | 975 | 0.00 | 0.00 | 0 | 0.00 | 975-Galvanized | |
| 223759 | 22644 | 20 | 0.000 | A | 0.000 | A | 4000K | 0.00 | 0.00 | 0 | 0.00 | 4000K - Cool White | |
| 227167 | 22853 | 20 | 5.000 | A | 0.000 | A | ST518 | 0.00 | 0.00 | 0 | 1.12 | 18" Stem - ½" Diameter | |
| 231186 | 23149 | 20 | 36.000 | A | 0.000 | A | ASFC14 | 0.00 | 0.00 | 0 | 11.44 | 14" Shade | |
| 244498 | 21927 | 20 | 79.000 | A | 0.000 | A | M415 | 50.00 | 0.00 | 0 | 0.00 | M415-Red | |
| 244509 | 21948 | 20 | 11.000 | A | 0.000 | A | M210 | 0.00 | 0.00 | 0 | 0.00 | M210-Cream | |
| 215300 | 21936 | 25 | 0.000 | A | 0.000 | A | 605 | 0.00 | 0.00 | 0 | 0.00 | 605-Textured Rust | |
| 215484 | 21949 | 25 | 0.000 | A | 0.000 | A | 975 | 0.00 | 0.00 | 0 | 0.00 | 975-Galvanized | |
| 216771 | 22008 | 25 | 0.000 | A | 0.000 | A | 980 | 0.00 | 0.00 | 0 | 0.00 | 980-Brushed Aluminum | |
| 227168 | 22853 | 25 | 7.000 | A | 0.000 | A | ST718 | 0.00 | 0.00 | 0 | 1.67 | 18" Stem - ¾" Diameter | |
| 244499 | 21927 | 25 | 79.000 | A | 0.000 | A | M315 | 50.00 | 0.00 | 0 | 0.00 | M315-Seafoam | |
| 236852 | 21936 | 27 | 11.000 | A | 0.000 | A | 106 | 0.00 | 0.00 | 0 | 2.75 | 106-Matte Black | |
| 215744 | 21949 | 28 | 0.000 | A | 0.000 | A | 980 | 0.00 | 0.00 | 0 | 0.00 | 980-Brushed Aluminum | |
| 236853 | 21936 | 28 | 11.000 | A | 0.000 | A | 206 | 0.00 | 0.00 | 0 | 2.75 | 206-Matte White | |
| 215301 | 21936 | 30 | 11.000 | A | 0.000 | A | 307 | 0.00 | 0.00 | 0 | 2.75 | 307-Emerald Green | |
| 215485 | 21949 | 30 | 0.000 | A | 0.000 | A | 605 | 0.00 | 0.00 | 0 | 0.00 | 605-Textured Rust | |
| 216772 | 22008 | 30 | 0.000 | A | 0.000 | A | 605 | 0.00 | 0.00 | 0 | 0.00 | 605-Textured Rust | |
| 227169 | 22853 | 30 | 7.000 | A | 0.000 | A | ST524 | 0.00 | 0.00 | 0 | 1.69 | 24" Stem - ½" Diameter | |
| 244500 | 21927 | 30 | 79.000 | A | 0.000 | A | M803 | 50.00 | 0.00 | 0 | 0.00 | M803-Dark Grey | |
| 236938 | 22008 | 32 | 11.000 | A | 0.000 | A | 106 | 0.00 | 0.00 | 0 | 2.75 | 106-Matte Black | |
| 236940 | 21949 | 32 | 11.000 | A | 0.000 | A | 106 | 0.00 | 0.00 | 0 | 2.75 | 106-Matte Black | |
| 245098 | 21936 | 32 | 11.000 | A | 0.000 | A | 311 | 0.00 | 0.00 | 0 | 0.00 | 311-Jadite | |
| 236939 | 22008 | 33 | 11.000 | A | 0.000 | A | 206 | 0.00 | 0.00 | 0 | 2.75 | 206-Matte White | |
| 236941 | 21949 | 33 | 11.000 | A | 0.000 | A | 206 | 0.00 | 0.00 | 0 | 2.75 | 206-Matte White | |
| 240955 | 21936 | 33 | 11.000 | A | 0.000 | A | 320 | 0.00 | 0.00 | 0 | 2.75 | 320-Fern Green | |
| 215302 | 21936 | 35 | 11.000 | A | 0.000 | A | 370 | 0.00 | 0.00 | 0 | 2.75 | 370-Mint | |
| 215486 | 21949 | 35 | 11.000 | A | 0.000 | A | 307 | 0.00 | 0.00 | 0 | 2.75 | 307-Emerald Green | |
| 216773 | 22008 | 35 | 11.000 | A | 0.000 | A | 307 | 0.00 | 0.00 | 0 | 2.75 | 307-Emerald Green | |
| 227170 | 22853 | 35 | 10.000 | A | 0.000 | A | ST724 | 0.00 | 0.00 | 0 | 2.41 | 24" Stem - ¾" Diameter | |
| 244501 | 21927 | 35 | 79.000 | A | 0.000 | A | M210 | 50.00 | 0.00 | 0 | 0.00 | M210-Cream | |
| 245094 | 21949 | 36 | 11.000 | A | 0.000 | A | 311 | 0.00 | 0.00 | 0 | 0.00 | 311-Jadite | |
| 245090 | 22008 | 37 | 11.000 | A | 0.000 | A | 311 | 0.00 | 0.00 | 0 | 0.00 | 311-Jadite | |
| 240975 | 21949 | 38 | 11.000 | A | 0.000 | A | 320 | 0.00 | 0.00 | 0 | 2.75 | 320-Fern Green | |
| 240980 | 22008 | 38 | 11.000 | A | 0.000 | A | 320 | 0.00 | 0.00 | 0 | 2.75 | 320-Fern Green | |
| 215303 | 21936 | 40 | 11.000 | A | 0.000 | A | 380 | 0.00 | 0.00 | 0 | 2.75 | 380-Chartreuse | |
| 215487 | 21949 | 40 | 11.000 | A | 0.000 | A | 370 | 0.00 | 0.00 | 0 | 2.75 | 370-Mint | |
| 216774 | 22008 | 40 | 11.000 | A | 0.000 | A | 370 | 0.00 | 0.00 | 0 | 2.75 | 370-Mint | |
| 227171 | 22853 | 40 | 12.000 | A | 0.000 | A | ST536 | 0.00 | 0.00 | 0 | 2.81 | 36" Stem - ½" Diameter | |
| 215304 | 21936 | 45 | 11.000 | A | 0.000 | A | 390 | 0.00 | 0.00 | 0 | 2.75 | 390-Teal | |
| 215488 | 21949 | 45 | 11.000 | A | 0.000 | A | 380 | 0.00 | 0.00 | 0 | 2.75 | 380-Chartreuse | |
| 216775 | 22008 | 45 | 11.000 | A | 0.000 | A | 380 | 0.00 | 0.00 | 0 | 2.75 | 380-Chartreuse | |
| 227172 | 22853 | 45 | 16.000 | A | 0.000 | A | ST736 | 0.00 | 0.00 | 0 | 3.90 | 36" Stem - ¾" Diameter | |
| 215305 | 21936 | 50 | 11.000 | A | 0.000 | A | 400 | 0.00 | 0.00 | 0 | 2.75 | 400-Barn Red | |
| 215489 | 21949 | 50 | 11.000 | A | 0.000 | A | 390 | 0.00 | 0.00 | 0 | 2.75 | 390-Teal | |
| 216776 | 22008 | 50 | 11.000 | A | 0.000 | A | 390 | 0.00 | 0.00 | 0 | 2.75 | 390-Teal | |
| 227173 | 22853 | 50 | 16.000 | A | 0.000 | A | ST548 | 0.00 | 0.00 | 0 | 3.93 | 48" Stem - ½" Diameter | |
| 215119 | 21927 | 55 | 0.000 | A | 0.000 | A | 100 | 0.00 | 0.00 | 0 | 0.00 | 100-Black | |
| 215306 | 21936 | 55 | 11.000 | A | 0.000 | A | 420 | 0.00 | 0.00 | 0 | 2.75 | 420-Orange | |
| 215490 | 21949 | 55 | 11.000 | A | 0.000 | A | 400 | 0.00 | 0.00 | 0 | 2.75 | 400-Barn Red | |
| 216777 | 22008 | 55 | 11.000 | A | 0.000 | A | 400 | 0.00 | 0.00 | 0 | 2.75 | 400-Barn Red | |
| 227174 | 22853 | 55 | 22.000 | A | 0.000 | A | ST748 | 0.00 | 0.00 | 0 | 5.39 | 48" Stem - ¾" Diameter | |
| 240956 | 21936 | 58 | 11.000 | A | 0.000 | A | 430 | 0.00 | 0.00 | 0 | 2.75 | 430-Soft Clay | |
| 215120 | 21927 | 60 | 0.000 | A | 0.000 | A | 105 | 0.00 | 0.00 | 0 | 0.00 | 105-Textured Black | |
| 215307 | 21936 | 60 | 11.000 | A | 0.000 | A | 470 | 0.00 | 0.00 | 0 | 2.75 | 470-Watermelon | |
| 215491 | 21949 | 60 | 11.000 | A | 0.000 | A | 420 | 0.00 | 0.00 | 0 | 2.75 | 420-Orange | |
| 216778 | 22008 | 60 | 11.000 | A | 0.000 | A | 420 | 0.00 | 0.00 | 0 | 2.75 | 420-Orange | |
| 240976 | 21949 | 63 | 11.000 | A | 0.000 | A | 430 | 0.00 | 0.00 | 0 | 2.75 | 430-Soft Clay | |
| 240981 | 22008 | 63 | 11.000 | A | 0.000 | A | 430 | 0.00 | 0.00 | 0 | 2.75 | 430-Soft Clay | |
| 215121 | 21927 | 65 | 0.000 | A | 0.000 | A | 200 | 0.00 | 0.00 | 0 | 0.00 | 200-White | |
| 215308 | 21936 | 65 | 11.000 | A | 0.000 | A | 480 | 0.00 | 0.00 | 0 | 2.75 | 480-Blush Pink | |
| 215492 | 21949 | 65 | 11.000 | A | 0.000 | A | 470 | 0.00 | 0.00 | 0 | 2.75 | 470-Watermelon | |
| 216779 | 22008 | 65 | 11.000 | A | 0.000 | A | 470 | 0.00 | 0.00 | 0 | 2.75 | 470-Watermelon | |
| 215122 | 21927 | 70 | 0.000 | A | 0.000 | A | 300 | 0.00 | 0.00 | 0 | 0.00 | 300-Dark Green | |
| 215309 | 21936 | 70 | 11.000 | A | 0.000 | A | 490 | 0.00 | 0.00 | 0 | 2.75 | 490-Magenta | |
| 215493 | 21949 | 70 | 11.000 | A | 0.000 | A | 480 | 0.00 | 0.00 | 0 | 2.75 | 480-Blush Pink | |
| 216780 | 22008 | 70 | 11.000 | A | 0.000 | A | 480 | 0.00 | 0.00 | 0 | 2.75 | 480-Blush Pink | |
| 215123 | 21927 | 75 | 0.000 | A | 0.000 | A | 975 | 0.00 | 0.00 | 0 | 0.00 | 975-Galvanized | |
| 215310 | 21936 | 75 | 11.000 | A | 0.000 | A | 495 | 0.00 | 0.00 | 0 | 2.75 | 495-Sherbet Orange | |
| 215494 | 21949 | 75 | 11.000 | A | 0.000 | A | 490 | 0.00 | 0.00 | 0 | 2.75 | 490-Magenta | |
| 216781 | 22008 | 75 | 11.000 | A | 0.000 | A | 490 | 0.00 | 0.00 | 0 | 2.75 | 490-Magenta | |
| 215124 | 21927 | 80 | 0.000 | A | 0.000 | A | 605 | 0.00 | 0.00 | 0 | 0.00 | 605-Textured Rust | |
| 215311 | 21936 | 80 | 11.000 | A | 0.000 | A | 500 | 0.00 | 0.00 | 0 | 2.75 | 500-Buttery Yellow | |
| 215495 | 21949 | 80 | 11.000 | A | 0.000 | A | 495 | 0.00 | 0.00 | 0 | 2.75 | 495-Sherbet Orange | |
| 216782 | 22008 | 80 | 11.000 | A | 0.000 | A | 495 | 0.00 | 0.00 | 0 | 2.75 | 495-Sherbet Orange | |
| 236846 | 21927 | 82 | 18.000 | A | 0.000 | A | 106 | 0.00 | 0.00 | 0 | 4.50 | 106-Matte Black | |
| 236847 | 21927 | 84 | 18.000 | A | 0.000 | A | 206 | 0.00 | 0.00 | 0 | 4.50 | 206-Matte White | |
| 215125 | 21927 | 85 | 18.000 | A | 0.000 | A | 307 | 0.00 | 0.00 | 0 | 4.50 | 307-Emerald Green | |
| 215312 | 21936 | 85 | 11.000 | A | 0.000 | A | 570 | 0.00 | 0.00 | 0 | 2.75 | 570-Sunflower | |
| 215496 | 21949 | 85 | 11.000 | A | 0.000 | A | 500 | 0.00 | 0.00 | 0 | 2.75 | 500-Buttery Yellow | |
| 216783 | 22008 | 85 | 11.000 | A | 0.000 | A | 500 | 0.00 | 0.00 | 0 | 2.75 | 500-Buttery Yellow | |
| 245086 | 21927 | 86 | 18.000 | A | 0.000 | A | 311 | 0.00 | 0.00 | 0 | 0.00 | 311-Jadite | |
| 240940 | 21927 | 87 | 18.000 | A | 0.000 | A | 320 | 0.00 | 0.00 | 0 | 4.50 | 320-Fern Green | |
| 215126 | 21927 | 90 | 18.000 | A | 0.000 | A | 370 | 0.00 | 0.00 | 0 | 4.50 | 370-Mint | |
| 215313 | 21936 | 90 | 11.000 | A | 0.000 | A | 600 | 0.00 | 0.00 | 0 | 2.75 | 600-Bronze | |
| 215497 | 21949 | 90 | 11.000 | A | 0.000 | A | 570 | 0.00 | 0.00 | 0 | 2.75 | 570-Sunflower | |
| 216784 | 22008 | 90 | 11.000 | A | 0.000 | A | 570 | 0.00 | 0.00 | 0 | 2.75 | 570-Sunflower | |
| 215127 | 21927 | 95 | 18.000 | A | 0.000 | A | 380 | 0.00 | 0.00 | 0 | 4.50 | 380-Chartreuse | |
| 215314 | 21936 | 95 | 11.000 | A | 0.000 | A | 601 | 0.00 | 0.00 | 0 | 2.75 | 601-Chocolate | |
| 215498 | 21949 | 95 | 11.000 | A | 0.000 | A | 600 | 0.00 | 0.00 | 0 | 2.75 | 600-Bronze | |
| 216785 | 22008 | 95 | 11.000 | A | 0.000 | A | 600 | 0.00 | 0.00 | 0 | 2.75 | 600-Bronze | |
| 240957 | 21936 | 98 | 11.000 | A | 0.000 | A | 607 | 0.00 | 0.00 | 0 | 2.75 | 607-Taupe | |
| 215128 | 21927 | 100 | 18.000 | A | 0.000 | A | 390 | 0.00 | 0.00 | 0 | 4.50 | 390-Teal | |
| 215315 | 21936 | 100 | 11.000 | A | 0.000 | A | 615 | 0.00 | 0.00 | 0 | 2.75 | 615-Oil-Rubbed Bronze | |
| 215499 | 21949 | 100 | 11.000 | A | 0.000 | A | 601 | 0.00 | 0.00 | 0 | 2.75 | 601-Chocolate | |
| 216786 | 22008 | 100 | 11.000 | A | 0.000 | A | 601 | 0.00 | 0.00 | 0 | 2.75 | 601-Chocolate | |
| 240958 | 21936 | 103 | 11.000 | A | 0.000 | A | 630 | 0.00 | 0.00 | 0 | 2.75 | 630-Beige | |
| 240977 | 21949 | 103 | 11.000 | A | 0.000 | A | 607 | 0.00 | 0.00 | 0 | 2.75 | 607-Taupe | |
| 240982 | 22008 | 103 | 11.000 | A | 0.000 | A | 607 | 0.00 | 0.00 | 0 | 2.75 | 607-Taupe | |
| 215129 | 21927 | 105 | 18.000 | A | 0.000 | A | 400 | 0.00 | 0.00 | 0 | 4.50 | 400-Barn Red | |
| 215316 | 21936 | 105 | 11.000 | A | 0.000 | A | 700 | 0.00 | 0.00 | 0 | 2.75 | 700-Royal Blue | |
| 215500 | 21949 | 105 | 11.000 | A | 0.000 | A | 615 | 0.00 | 0.00 | 0 | 2.75 | 615-Oil-Rubbed Bronze | |
| 216787 | 22008 | 105 | 11.000 | A | 0.000 | A | 615 | 0.00 | 0.00 | 0 | 2.75 | 615-Oil-Rubbed Bronze | |
| 240978 | 21949 | 108 | 11.000 | A | 0.000 | A | 630 | 0.00 | 0.00 | 0 | 2.75 | 630-Beige | |
| 240983 | 22008 | 108 | 11.000 | A | 0.000 | A | 630 | 0.00 | 0.00 | 0 | 2.75 | 630-Beige | |
| 215130 | 21927 | 110 | 18.000 | A | 0.000 | A | 420 | 0.00 | 0.00 | 0 | 4.50 | 420-Orange | |
| 215317 | 21936 | 110 | 11.000 | A | 0.000 | A | 705 | 0.00 | 0.00 | 0 | 2.75 | 705-Navy | |
| 215501 | 21949 | 110 | 11.000 | A | 0.000 | A | 700 | 0.00 | 0.00 | 0 | 2.75 | 700-Royal Blue | |
| 216788 | 22008 | 110 | 11.000 | A | 0.000 | A | 700 | 0.00 | 0.00 | 0 | 2.75 | 700-Royal Blue | |
| 245099 | 21936 | 112 | 11.000 | A | 0.000 | A | 710 | 0.00 | 0.00 | 0 | 0.00 | 710-Cobalt Blue | |
| 240941 | 21927 | 113 | 18.000 | A | 0.000 | A | 430 | 0.00 | 0.00 | 0 | 4.50 | 430-Soft Clay | |
| 245100 | 21936 | 113 | 11.000 | A | 0.000 | A | 715 | 0.00 | 0.00 | 0 | 0.00 | 715-Delphite Blue | |
| 215131 | 21927 | 115 | 18.000 | A | 0.000 | A | 470 | 0.00 | 0.00 | 0 | 4.50 | 470-Watermelon | |
| 215318 | 21936 | 115 | 11.000 | A | 0.000 | A | 790 | 0.00 | 0.00 | 0 | 2.75 | 790-Lavender | |
| 215502 | 21949 | 115 | 11.000 | A | 0.000 | A | 705 | 0.00 | 0.00 | 0 | 2.75 | 705-Navy | |
| 216789 | 22008 | 115 | 11.000 | A | 0.000 | A | 705 | 0.00 | 0.00 | 0 | 2.75 | 705-Navy | |
| 245091 | 22008 | 116 | 11.000 | A | 0.000 | A | 710 | 0.00 | 0.00 | 0 | 0.00 | 710-Cobalt Blue | |
| 245095 | 21949 | 116 | 11.000 | A | 0.000 | A | 710 | 0.00 | 0.00 | 0 | 0.00 | 710-Cobalt Blue | |
| 245092 | 22008 | 117 | 11.000 | A | 0.000 | A | 715 | 0.00 | 0.00 | 0 | 0.00 | 715-Delphite Blue | |
| 245096 | 21949 | 117 | 11.000 | A | 0.000 | A | 715 | 0.00 | 0.00 | 0 | 0.00 | 715-Delphite Blue | |
| 225910 | 21949 | 118 | 11.000 | A | 0.000 | A | 790 | 0.00 | 0.00 | 0 | 2.75 | 790-Lavender | |
| 225911 | 22008 | 118 | 11.000 | A | 0.000 | A | 790 | 0.00 | 0.00 | 0 | 2.75 | 790-Lavender | |
| 215132 | 21927 | 120 | 18.000 | A | 0.000 | A | 480 | 0.00 | 0.00 | 0 | 4.50 | 480-Blush Pink | |
| 215319 | 21936 | 120 | 11.000 | A | 0.000 | A | 800 | 0.00 | 0.00 | 0 | 2.75 | 800-Industrial Grey | |
| 215503 | 21949 | 120 | 11.000 | A | 0.000 | A | 800 | 0.00 | 0.00 | 0 | 2.75 | 800-Industrial Grey | |
| 216790 | 22008 | 120 | 11.000 | A | 0.000 | A | 800 | 0.00 | 0.00 | 0 | 2.75 | 800-Industrial Grey | |
| 215133 | 21927 | 125 | 18.000 | A | 0.000 | A | 490 | 0.00 | 0.00 | 0 | 4.50 | 490-Magenta | |
| 215320 | 21936 | 125 | 11.000 | A | 0.000 | A | 805 | 0.00 | 0.00 | 0 | 2.75 | 805-Charcoal Granite | |
| 216791 | 22008 | 125 | 11.000 | A | 0.000 | A | 805 | 0.00 | 0.00 | 0 | 2.75 | 805-Charcoal Granite | |
| 245101 | 21936 | 126 | 11.000 | A | 0.000 | A | 810 | 0.00 | 0.00 | 0 | 0.00 | 810-Graphite | |
| 245093 | 22008 | 127 | 11.000 | A | 0.000 | A | 810 | 0.00 | 0.00 | 0 | 0.00 | 810-Graphite | |
| 240959 | 21936 | 128 | 11.000 | A | 0.000 | A | 815 | 0.00 | 0.00 | 0 | 2.75 | 815-Light Grey | |
| 240984 | 22008 | 128 | 11.000 | A | 0.000 | A | 815 | 0.00 | 0.00 | 0 | 2.75 | 815-Light Grey | |
| 215134 | 21927 | 130 | 18.000 | A | 0.000 | A | 495 | 0.00 | 0.00 | 0 | 4.50 | 495-Sherbet Orange | |
| 215504 | 21949 | 130 | 11.000 | A | 0.000 | A | 805 | 0.00 | 0.00 | 0 | 2.75 | 805-Charcoal Granite | |
| 216900 | 22008 | 130 | 93.000 | A | 0.000 | A | 995 | 0.00 | 0.00 | 0 | 23.25 | 995-Raw Copper | |
| 245097 | 21949 | 132 | 11.000 | A | 0.000 | A | 810 | 0.00 | 0.00 | 0 | 0.00 | 810-Graphite | |
| 240979 | 21949 | 133 | 11.000 | A | 0.000 | A | 815 | 0.00 | 0.00 | 0 | 2.75 | 815-Light Grey | |
| 215135 | 21927 | 135 | 18.000 | A | 0.000 | A | 500 | 0.00 | 0.00 | 0 | 4.50 | 500-Buttery Yellow | |
| 215505 | 21949 | 135 | 93.000 | A | 0.000 | A | 995 | 0.00 | 0.00 | 0 | 23.25 | 995-Raw Copper | |
| 216901 | 22008 | 135 | 93.000 | A | 0.000 | A | 996 | 0.00 | 0.00 | 0 | 23.25 | 996-Weathered Copper | |
| 215136 | 21927 | 140 | 18.000 | A | 0.000 | A | 570 | 0.00 | 0.00 | 0 | 4.50 | 570-Sunflower | |
| 215506 | 21949 | 140 | 93.000 | A | 0.000 | A | 996 | 0.00 | 0.00 | 0 | 23.25 | 996-Weathered Copper | |
| 216902 | 22008 | 140 | 93.000 | A | 0.000 | A | 999 | 0.00 | 0.00 | 0 | 23.25 | 999-Oil-Rubbed Copper | |
| 215137 | 21927 | 145 | 18.000 | A | 0.000 | A | 600 | 0.00 | 0.00 | 0 | 4.50 | 600-Bronze | |
| 215507 | 21949 | 145 | 93.000 | A | 0.000 | A | 999 | 0.00 | 0.00 | 0 | 23.25 | 999-Oil-Rubbed Copper | |
| 216903 | 22008 | 145 | 93.000 | A | 0.000 | A | 997 | 0.00 | 0.00 | 0 | 23.25 | 997-Raw Brass | |
| 215138 | 21927 | 150 | 18.000 | A | 0.000 | A | 601 | 0.00 | 0.00 | 0 | 4.50 | 601-Chocolate | |
| 215508 | 21949 | 150 | 93.000 | A | 0.000 | A | 997 | 0.00 | 0.00 | 0 | 23.25 | 997-Raw Brass | |
| 216904 | 22008 | 150 | 93.000 | A | 0.000 | A | 998 | 0.00 | 0.00 | 0 | 23.25 | 998-Weathered Brass | |
| 240942 | 21927 | 153 | 18.000 | A | 0.000 | A | 607 | 0.00 | 0.00 | 0 | 4.50 | 607-Taupe | |
| 215139 | 21927 | 155 | 18.000 | A | 0.000 | A | 615 | 0.00 | 0.00 | 0 | 4.50 | 615-Oil-Rubbed Bronze | |
| 215509 | 21949 | 155 | 93.000 | A | 0.000 | A | 998 | 0.00 | 0.00 | 0 | 23.25 | 998-Weathered Brass | |
| 240943 | 21927 | 158 | 18.000 | A | 0.000 | A | 630 | 0.00 | 0.00 | 0 | 4.50 | 630-Beige | |
| 215140 | 21927 | 160 | 18.000 | A | 0.000 | A | 700 | 0.00 | 0.00 | 0 | 4.50 | 700-Royal Blue | |
| 215141 | 21927 | 165 | 18.000 | A | 0.000 | A | 705 | 0.00 | 0.00 | 0 | 4.50 | 705-Navy | |
| 245087 | 21927 | 166 | 18.000 | A | 0.000 | A | 710 | 0.00 | 0.00 | 0 | 0.00 | 710-Cobalt Blue | |
| 245088 | 21927 | 167 | 18.000 | A | 0.000 | A | 715 | 0.00 | 0.00 | 0 | 0.00 | 715-Delphite Blue | |
| 225909 | 21927 | 168 | 18.000 | A | 0.000 | A | 790 | 0.00 | 0.00 | 0 | 4.50 | 790-Lavender | |
| 215142 | 21927 | 170 | 18.000 | A | 0.000 | A | 800 | 0.00 | 0.00 | 0 | 4.50 | 800-Industrial Grey | |
| 215143 | 21927 | 175 | 18.000 | A | 0.000 | A | 805 | 0.00 | 0.00 | 0 | 4.50 | 805-Charcoal Granite | |
| 245089 | 21927 | 176 | 18.000 | A | 0.000 | A | 810 | 0.00 | 0.00 | 0 | 0.00 | 810-Graphite | |
| 240944 | 21927 | 178 | 18.000 | A | 0.000 | A | 815 | 0.00 | 0.00 | 0 | 4.50 | 815-Light Grey | |
| 215144 | 21927 | 180 | 160.000 | A | 0.000 | A | 995 | 0.00 | 0.00 | 0 | 40.00 | 995-Raw Copper | |
| 215145 | 21927 | 185 | 200.000 | A | 0.000 | A | 996 | 0.00 | 0.00 | 0 | 50.00 | 996-Weathered Copper | |
| 215146 | 21927 | 190 | 250.000 | A | 0.000 | A | 999 | 0.00 | 0.00 | 0 | 70.00 | 999-Oil-Rubbed Copper | |
| 215147 | 21927 | 195 | 210.000 | A | 0.000 | A | 997 | 0.00 | 0.00 | 0 | 55.00 | 997-Raw Brass | |
| 215148 | 21927 | 200 | 250.000 | A | 0.000 | A | 998 | 0.00 | 0.00 | 0 | 75.00 | 998-Weathered Brass |