The North Face

The North Face Women's Venture 2 Jacket

$99.00

Item # NF0A2VCR

query
RESULTSET
query
  ORIGSIZ QOH SCALE_ENTRY_ID SIZ SIZE_ORDER SKU_ID STYLE_ID
1 00_XS 21 152633 XS 1 526527 107029
2 01_SM 23 152634 S 2 526528 107029
3 02_MD 33 152635 M 3 526529 107029
4 03_LG 24 152636 L 13 526530 107029
5 04_XL 17 152637 XL 24 526531 107029
6 05_XXL 7 152638 XXL 33 526526 107029
CACHED false
EXECUTIONTIME 525
SQL SELECT distinct (b.siz) as origSiz, max(CASE WHEN b.siz_alias IS NULL OR RTRIM(LTRIM(b.siz_alias)) = '' THEN b.siz ELSE b.siz_alias END) as siz, max(b.size_order) as size_order, max(a.sku_id) as sku_id, max(a.scale_entry_id) as scale_entry_id, sum(e.qoh) as qoh, max(a.style_id) as style_id FROM tb_skus a WITH (NOLOCK) LEFT JOIN tb_size_entries b WITH (NOLOCK) on (b.scale_entry_id = a.scale_entry_id) INNER JOIN ( SELECT DISTINCT sku_id , sum(qoh+qc) as qoh FROM dbo.tb_sku_buckets WITH (NOLOCK) WHERE store_id in(98,8,9,2,5,7,6,3) GROUP BY sku_id ) e on (a.sku_id = e.sku_id) LEFT JOIN tb_attr1_entries d WITH (NOLOCK) on (d.attr1_entry_id = a.attr1_entry_id) LEFT JOIN ( SELECT style_id FROM tb_styles WITH (NOLOCK) WHERE web_style = ? and web_style is not null ) sq ON(a.style_id = sq.style_id) WHERE (sq.style_id is not null OR a.style_id = ?) AND (b.siz_alias is null OR b.siz_alias NOT IN ('NO SHOW','NOSHOW') ) AND isNull(a.sell_web,'Y') = 'Y' AND e.qoh > 1 GROUP BY b.siz ORDER BY max(b.size_order), max(a.scale_entry_id)
SQLPARAMETERS
array
1 NF0A2VCR
2 107029
query
RESULTSET
query
  ATTR1 ATTR1_ALIAS ATTR1_ENTRY_ID FAM HEX ORIGATTR1 QOH SIZE SKU_ID SORT_ORDER STYLE_ID
1 PURPLE_D2Q [empty string] 133561 [empty string] [empty string] PURPLE_D2Q 39 152638 526526 [empty string] 107029
2 TNF Black TNF Black 133537 [empty string] [empty string] BLACK_JK3 32 152638 505385 [empty string] 107029
3 GREY_FTJ [empty string] 133557 [empty string] [empty string] GREY_FTJ 29 152637 506278 [empty string] 107029
4 BLUE_TQ5 [empty string] 133562 [empty string] [empty string] BLUE_TQ5 25 152637 526531 [empty string] 107029
CACHED false
EXECUTIONTIME 4
SQL SELECT distinct (b.attr1) as origAttr1, max(b.attr1_alias) as attr1_alias, max(CASE WHEN b.attr1_alias IS NULL OR RTRIM(LTRIM(b.attr1_alias)) = '' THEN b.attr1 ELSE b.attr1_alias END) as attr1, max(a.sku_id) as sku_id, max(b.attr1_entry_id) as attr1_entry_id, sum(e.qoh) as qoh, max(b.attr1_order) as sort_order, max(c.attr1_hex) as hex,max(d.attr1_fam) as fam, max(a.style_id) as style_id, max(a.SCALE_ENTRY_ID) as size FROM tb_skus a LEFT JOIN tb_attr1_entries b WITH (NOLOCK) ON (b.attr1_entry_id = a.attr1_entry_id) INNER JOIN ( SELECT DISTINCT sku_id , sum(qoh+qc) as qoh FROM dbo.tb_sku_buckets WITH (NOLOCK) WHERE store_id in(98,8,9,2,5,7,6,3) GROUP BY sku_id ) e on (a.sku_id = e.sku_id) LEFT JOIN tb_attr1_hexes c WITH (NOLOCK) ON (b.attr1=c.attr1) LEFT JOIN tb_size_entries k WITH (NOLOCK) on (k.scale_entry_id = a.scale_entry_id) LEFT JOIN tb_attr1_families d WITH (NOLOCK) ON (c.attr1_fam_id = d.attr1_fam_id) WHERE a.style_id =? AND (b.attr1_alias is null OR b.attr1_alias NOT IN ('NO SHOW','NOSHOW') ) AND e.qoh > 1 AND isNull(a.sell_web,'Y') = 'Y' GROUP BY b.attr1 ORDER BY sum(e.qoh) DESC --max(b.attr1_order), max(b.attr1_entry_id)
SQLPARAMETERS
array
1 107029
The North Face Women's Venture 2 Jacket PURPLE_D2Q The North Face Women's Venture 2 Jacket BLACK_JK3 The North Face Women's Venture 2 Jacket GREY_FTJ The North Face Women's Venture 2 Jacket BLUE_TQ5
XS S M L XL XXL
query
RESULTSET
query
  ATTR1_ENTRY_ID ATTR2_ENTRY_ID DEPT PURCHASE_AMOUNT QOH SCALE_ENTRY_ID SKU_ID STORE_ID STYLE
1 133537 47504 10-OUTERWEAR [empty string] 6 152633 419562 98 NF0A2VCR
2 133538 47504 10-OUTERWEAR [empty string] 0 152633 419563 98 NF0A2VCR
3 133539 47504 10-OUTERWEAR [empty string] 0 152633 419564 98 NF0A2VCR
4 133540 47504 10-OUTERWEAR [empty string] 0 152633 419565 98 NF0A2VCR
5 133541 47504 10-OUTERWEAR [empty string] 0 152633 419566 98 NF0A2VCR
6 133537 47504 10-OUTERWEAR [empty string] 4 152634 419567 98 NF0A2VCR
7 133538 47504 10-OUTERWEAR [empty string] 0 152634 419568 98 NF0A2VCR
8 133539 47504 10-OUTERWEAR [empty string] 0 152634 419569 98 NF0A2VCR
9 133540 47504 10-OUTERWEAR [empty string] 0 152634 419570 98 NF0A2VCR
10 133541 47504 10-OUTERWEAR [empty string] 0 152634 419571 98 NF0A2VCR
11 133537 47504 10-OUTERWEAR [empty string] 7 152635 419572 98 NF0A2VCR
12 133538 47504 10-OUTERWEAR [empty string] 0 152635 419573 98 NF0A2VCR
13 133539 47504 10-OUTERWEAR [empty string] 0 152635 419574 98 NF0A2VCR
14 133540 47504 10-OUTERWEAR [empty string] 0 152635 419575 98 NF0A2VCR
15 133541 47504 10-OUTERWEAR [empty string] 0 152635 419576 98 NF0A2VCR
16 133537 47504 10-OUTERWEAR [empty string] 7 152636 419577 98 NF0A2VCR
17 133538 47504 10-OUTERWEAR [empty string] 0 152636 419578 98 NF0A2VCR
18 133539 47504 10-OUTERWEAR [empty string] 0 152636 419579 98 NF0A2VCR
19 133540 47504 10-OUTERWEAR [empty string] 0 152636 419580 98 NF0A2VCR
20 133541 47504 10-OUTERWEAR [empty string] 0 152636 419581 98 NF0A2VCR
21 133537 47504 10-OUTERWEAR [empty string] 4 152637 419582 98 NF0A2VCR
22 133538 47504 10-OUTERWEAR [empty string] 0 152637 419583 98 NF0A2VCR
23 133539 47504 10-OUTERWEAR [empty string] 0 152637 419584 98 NF0A2VCR
24 133540 47504 10-OUTERWEAR [empty string] 0 152637 419585 98 NF0A2VCR
25 133541 47504 10-OUTERWEAR [empty string] 0 152637 419586 98 NF0A2VCR
26 133542 47504 10-OUTERWEAR [empty string] 0 152633 425424 98 NF0A2VCR
27 133542 47504 10-OUTERWEAR [empty string] 0 152634 425425 98 NF0A2VCR
28 133542 47504 10-OUTERWEAR [empty string] 0 152635 425426 98 NF0A2VCR
29 133542 47504 10-OUTERWEAR [empty string] 0 152636 425427 98 NF0A2VCR
30 133542 47504 10-OUTERWEAR [empty string] 0 152637 425428 98 NF0A2VCR
31 133543 47504 10-OUTERWEAR [empty string] 0 152633 425429 98 NF0A2VCR
32 133543 47504 10-OUTERWEAR [empty string] 0 152634 425430 98 NF0A2VCR
33 133543 47504 10-OUTERWEAR [empty string] 0 152635 425431 98 NF0A2VCR
34 133543 47504 10-OUTERWEAR [empty string] 0 152636 425432 98 NF0A2VCR
35 133543 47504 10-OUTERWEAR [empty string] 0 152637 425433 98 NF0A2VCR
36 133544 47504 10-OUTERWEAR [empty string] 0 152633 425434 98 NF0A2VCR
37 133544 47504 10-OUTERWEAR [empty string] 0 152634 425435 98 NF0A2VCR
38 133544 47504 10-OUTERWEAR [empty string] 0 152635 425436 98 NF0A2VCR
39 133544 47504 10-OUTERWEAR [empty string] 0 152636 425437 98 NF0A2VCR
40 133544 47504 10-OUTERWEAR [empty string] 0 152637 425438 98 NF0A2VCR
41 133545 47504 10-OUTERWEAR [empty string] 0 152633 437414 98 NF0A2VCR
42 133545 47504 10-OUTERWEAR [empty string] 0 152634 437415 98 NF0A2VCR
43 133545 47504 10-OUTERWEAR [empty string] 0 152635 437416 98 NF0A2VCR
44 133545 47504 10-OUTERWEAR [empty string] 0 152636 437417 98 NF0A2VCR
45 133545 47504 10-OUTERWEAR [empty string] 0 152637 437418 98 NF0A2VCR
46 133546 47504 10-OUTERWEAR [empty string] 0 152633 437419 98 NF0A2VCR
47 133546 47504 10-OUTERWEAR [empty string] 0 152634 437420 98 NF0A2VCR
48 133546 47504 10-OUTERWEAR [empty string] 0 152635 437421 98 NF0A2VCR
49 133546 47504 10-OUTERWEAR [empty string] 0 152636 437422 98 NF0A2VCR
50 133546 47504 10-OUTERWEAR [empty string] 0 152637 437423 98 NF0A2VCR
51 133547 47504 10-OUTERWEAR [empty string] 0 152633 463578 98 NF0A2VCR
52 133547 47504 10-OUTERWEAR [empty string] 0 152634 463579 98 NF0A2VCR
53 133547 47504 10-OUTERWEAR [empty string] 0 152635 463580 98 NF0A2VCR
54 133547 47504 10-OUTERWEAR [empty string] 0 152636 463581 98 NF0A2VCR
55 133547 47504 10-OUTERWEAR [empty string] 0 152637 463582 98 NF0A2VCR
56 133548 47504 10-OUTERWEAR [empty string] 0 152633 463583 98 NF0A2VCR
57 133548 47504 10-OUTERWEAR [empty string] 0 152634 463584 98 NF0A2VCR
58 133548 47504 10-OUTERWEAR [empty string] 0 152635 463585 98 NF0A2VCR
59 133548 47504 10-OUTERWEAR [empty string] 0 152636 463586 98 NF0A2VCR
60 133548 47504 10-OUTERWEAR [empty string] 1 152637 463587 98 NF0A2VCR
61 133549 47504 10-OUTERWEAR [empty string] 0 152633 463588 98 NF0A2VCR
62 133549 47504 10-OUTERWEAR [empty string] 0 152634 463589 98 NF0A2VCR
63 133549 47504 10-OUTERWEAR [empty string] 0 152635 463590 98 NF0A2VCR
64 133549 47504 10-OUTERWEAR [empty string] 0 152636 463591 98 NF0A2VCR
65 133549 47504 10-OUTERWEAR [empty string] 0 152637 463592 98 NF0A2VCR
66 133550 47504 10-OUTERWEAR [empty string] 0 152633 463593 98 NF0A2VCR
67 133550 47504 10-OUTERWEAR [empty string] 0 152634 463594 98 NF0A2VCR
68 133550 47504 10-OUTERWEAR [empty string] 0 152635 463595 98 NF0A2VCR
69 133550 47504 10-OUTERWEAR [empty string] 0 152636 463596 98 NF0A2VCR
70 133550 47504 10-OUTERWEAR [empty string] 0 152637 463597 98 NF0A2VCR
71 133551 47504 10-OUTERWEAR [empty string] 0 152633 477174 98 NF0A2VCR
72 133551 47504 10-OUTERWEAR [empty string] 0 152634 477175 98 NF0A2VCR
73 133551 47504 10-OUTERWEAR [empty string] 0 152635 477176 98 NF0A2VCR
74 133551 47504 10-OUTERWEAR [empty string] 0 152636 477177 98 NF0A2VCR
75 133551 47504 10-OUTERWEAR [empty string] 0 152637 477178 98 NF0A2VCR
76 133552 47504 10-OUTERWEAR [empty string] 1 152633 477179 98 NF0A2VCR
77 133552 47504 10-OUTERWEAR [empty string] 0 152634 477180 98 NF0A2VCR
78 133552 47504 10-OUTERWEAR [empty string] 0 152635 477181 98 NF0A2VCR
79 133552 47504 10-OUTERWEAR [empty string] 0 152636 477182 98 NF0A2VCR
80 133552 47504 10-OUTERWEAR [empty string] 1 152637 477183 98 NF0A2VCR
81 133553 47504 10-OUTERWEAR [empty string] 0 152633 477184 98 NF0A2VCR
82 133553 47504 10-OUTERWEAR [empty string] 0 152634 477185 98 NF0A2VCR
83 133553 47504 10-OUTERWEAR [empty string] 0 152635 477186 98 NF0A2VCR
84 133553 47504 10-OUTERWEAR [empty string] 0 152636 477187 98 NF0A2VCR
85 133553 47504 10-OUTERWEAR [empty string] 0 152637 477188 98 NF0A2VCR
86 133554 47504 10-OUTERWEAR [empty string] 0 152633 483211 98 NF0A2VCR
87 133554 47504 10-OUTERWEAR [empty string] 0 152634 483212 98 NF0A2VCR
88 133554 47504 10-OUTERWEAR [empty string] 0 152635 483213 98 NF0A2VCR
89 133554 47504 10-OUTERWEAR [empty string] 0 152636 483214 98 NF0A2VCR
90 133554 47504 10-OUTERWEAR [empty string] 0 152637 483215 98 NF0A2VCR
91 133555 47504 10-OUTERWEAR [empty string] 0 152633 483216 98 NF0A2VCR
92 133555 47504 10-OUTERWEAR [empty string] 0 152634 483217 98 NF0A2VCR
93 133555 47504 10-OUTERWEAR [empty string] 0 152635 483218 98 NF0A2VCR
94 133555 47504 10-OUTERWEAR [empty string] 0 152636 483219 98 NF0A2VCR
95 133555 47504 10-OUTERWEAR [empty string] 0 152637 483220 98 NF0A2VCR
96 133537 47504 10-OUTERWEAR [empty string] 4 152638 505385 98 NF0A2VCR
97 133538 47504 10-OUTERWEAR [empty string] 0 152638 505386 98 NF0A2VCR
98 133539 47504 10-OUTERWEAR [empty string] 0 152638 505387 98 NF0A2VCR
99 133540 47504 10-OUTERWEAR [empty string] 0 152638 505388 98 NF0A2VCR
100 133541 47504 10-OUTERWEAR [empty string] 0 152638 505389 98 NF0A2VCR
101 133542 47504 10-OUTERWEAR [empty string] 0 152638 505390 98 NF0A2VCR
102 133543 47504 10-OUTERWEAR [empty string] 0 152638 505391 98 NF0A2VCR
103 133544 47504 10-OUTERWEAR [empty string] 0 152638 505392 98 NF0A2VCR
104 133545 47504 10-OUTERWEAR [empty string] 0 152638 505393 98 NF0A2VCR
105 133546 47504 10-OUTERWEAR [empty string] 0 152638 505394 98 NF0A2VCR
106 133547 47504 10-OUTERWEAR [empty string] 0 152638 505395 98 NF0A2VCR
107 133548 47504 10-OUTERWEAR [empty string] 0 152638 505396 98 NF0A2VCR
108 133549 47504 10-OUTERWEAR [empty string] 0 152638 505397 98 NF0A2VCR
109 133550 47504 10-OUTERWEAR [empty string] 0 152638 505398 98 NF0A2VCR
110 133551 47504 10-OUTERWEAR [empty string] 0 152638 505399 98 NF0A2VCR
111 133552 47504 10-OUTERWEAR [empty string] 0 152638 505400 98 NF0A2VCR
112 133553 47504 10-OUTERWEAR [empty string] 0 152638 505401 98 NF0A2VCR
113 133554 47504 10-OUTERWEAR [empty string] 0 152638 505402 98 NF0A2VCR
114 133555 47504 10-OUTERWEAR [empty string] 0 152638 505403 98 NF0A2VCR
115 133556 47504 10-OUTERWEAR [empty string] 0 152633 506268 98 NF0A2VCR
116 133556 47504 10-OUTERWEAR [empty string] 0 152634 506269 98 NF0A2VCR
117 133556 47504 10-OUTERWEAR [empty string] 1 152635 506270 98 NF0A2VCR
118 133556 47504 10-OUTERWEAR [empty string] 0 152636 506271 98 NF0A2VCR
119 133556 47504 10-OUTERWEAR [empty string] 0 152637 506272 98 NF0A2VCR
120 133556 47504 10-OUTERWEAR [empty string] 1 152638 506273 98 NF0A2VCR
121 133557 47504 10-OUTERWEAR [empty string] 6 152633 506274 98 NF0A2VCR
122 133557 47504 10-OUTERWEAR [empty string] 5 152634 506275 98 NF0A2VCR
123 133557 47504 10-OUTERWEAR [empty string] 9 152635 506276 98 NF0A2VCR
124 133557 47504 10-OUTERWEAR [empty string] 6 152636 506277 98 NF0A2VCR
125 133557 47504 10-OUTERWEAR [empty string] 3 152637 506278 98 NF0A2VCR
126 133557 47504 10-OUTERWEAR [empty string] 0 152638 506279 98 NF0A2VCR
127 133558 47504 10-OUTERWEAR [empty string] 1 152633 506280 98 NF0A2VCR
128 133558 47504 10-OUTERWEAR [empty string] 0 152634 506281 98 NF0A2VCR
129 133558 47504 10-OUTERWEAR [empty string] 0 152635 506282 98 NF0A2VCR
130 133558 47504 10-OUTERWEAR [empty string] 1 152636 506283 98 NF0A2VCR
131 133558 47504 10-OUTERWEAR [empty string] 0 152637 506284 98 NF0A2VCR
132 133558 47504 10-OUTERWEAR [empty string] 0 152638 506285 98 NF0A2VCR
133 133559 47504 10-OUTERWEAR [empty string] 1 152633 506286 98 NF0A2VCR
134 133559 47504 10-OUTERWEAR [empty string] 0 152634 506287 98 NF0A2VCR
135 133559 47504 10-OUTERWEAR [empty string] -1 152635 506288 98 NF0A2VCR
136 133559 47504 10-OUTERWEAR [empty string] 0 152636 506289 98 NF0A2VCR
137 133559 47504 10-OUTERWEAR [empty string] 0 152637 506290 98 NF0A2VCR
138 133559 47504 10-OUTERWEAR [empty string] 0 152638 506291 98 NF0A2VCR
139 133560 47504 10-OUTERWEAR [empty string] 0 152633 526515 98 NF0A2VCR
140 133560 47504 10-OUTERWEAR [empty string] 0 152634 526516 98 NF0A2VCR
141 133560 47504 10-OUTERWEAR [empty string] 0 152635 526517 98 NF0A2VCR
142 133560 47504 10-OUTERWEAR [empty string] 0 152636 526518 98 NF0A2VCR
143 133560 47504 10-OUTERWEAR [empty string] 0 152637 526519 98 NF0A2VCR
144 133560 47504 10-OUTERWEAR [empty string] 0 152638 526520 98 NF0A2VCR
145 133561 47504 10-OUTERWEAR [empty string] 6 152633 526521 98 NF0A2VCR
146 133561 47504 10-OUTERWEAR [empty string] 8 152634 526522 98 NF0A2VCR
147 133561 47504 10-OUTERWEAR [empty string] 9 152635 526523 98 NF0A2VCR
148 133561 47504 10-OUTERWEAR [empty string] 7 152636 526524 98 NF0A2VCR
149 133561 47504 10-OUTERWEAR [empty string] 6 152637 526525 98 NF0A2VCR
150 133561 47504 10-OUTERWEAR [empty string] 3 152638 526526 98 NF0A2VCR
151 133562 47504 10-OUTERWEAR [empty string] 3 152633 526527 98 NF0A2VCR
152 133562 47504 10-OUTERWEAR [empty string] 6 152634 526528 98 NF0A2VCR
153 133562 47504 10-OUTERWEAR [empty string] 8 152635 526529 98 NF0A2VCR
154 133562 47504 10-OUTERWEAR [empty string] 4 152636 526530 98 NF0A2VCR
155 133562 47504 10-OUTERWEAR [empty string] 4 152637 526531 98 NF0A2VCR
156 133562 47504 10-OUTERWEAR [empty string] 1 152638 526532 98 NF0A2VCR
157 133563 47504 10-OUTERWEAR [empty string] 0 152633 526533 98 NF0A2VCR
158 133563 47504 10-OUTERWEAR [empty string] 0 152634 526534 98 NF0A2VCR
159 133563 47504 10-OUTERWEAR [empty string] 0 152635 526535 98 NF0A2VCR
160 133563 47504 10-OUTERWEAR [empty string] 0 152636 526536 98 NF0A2VCR
161 133563 47504 10-OUTERWEAR [empty string] 0 152637 526537 98 NF0A2VCR
162 133563 47504 10-OUTERWEAR [empty string] 0 152638 526538 98 NF0A2VCR
CACHED false
EXECUTIONTIME 49
SQL SELECT sum(c.qoh+c.qc) as qoh ,max(b.sku_id) as sku_id , max(b.scale_entry_id) as scale_entry_id , max(b.attr2_entry_id) as attr2_entry_id , max(e.attr1_entry_id) as attr1_entry_id , max(g.dept) as dept , max(a.style) as style , max(c.store_id) as store_id , max(h.purchase_amount) as purchase_amount FROM tb_styles a LEFT JOIN tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id) LEFT JOIN tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id) LEFT JOIN tb_size_entries d WITH (NOLOCK) ON (d.scale_entry_id = b.scale_entry_id) LEFT JOIN tb_attr1_entries e WITH (NOLOCK) ON (e.attr1_entry_id = b.attr1_entry_id) LEFT JOIN tb_attr2_entries f WITH (NOLOCK) ON (f.attr2_entry_id = b.attr2_entry_id) LEFT JOIN tb_taxonomy g WITH (NOLOCK) ON (g.taxonomy_id = a.taxonomy_id) LEFT JOIN web_product_information h WITH (NOLOCK) ON (a.style_id = h.style_id) WHERE (b.style_id IN ( SELECT style_id FROM tb_styles WHERE web_style = 'NF0A2VCR' ) or b.style_id =?) and c.store_id in(98,8,9,2,5,7,6,3) --AND c.qoh > 1 and b.attr2_entry_id = 47504 AND isNull(b.sell_web,'Y') = 'Y' GROUP BY b.sku_id ORDER BY b.sku_id
SQLPARAMETERS
array
1 107029
133
Add to Cart Find in Store Add to Wish List

product description

Updated with revised style lines, cleaner construction details and new fabric, The North Face Women's Venture 2 Jacket is a classic year-round jacket that is designed to withstand backcountry storms and is styled for everyday use.

product specs
  • Standard fit
  • Waterproof, breathable, seam-sealed DryVent 2.5L shell
  • 100% windproof fabric
  • Attached, fully adjustable hood
  • Stormflap with Velcro® closure covers the center front zip
  • Covered, secure-zip hand pockets
  • Stowable in hand pocket
  • Pit-zip venting
  • Adjustable Velcro® cuff tabs
  • Hem cinch-cord
  • Centerback: 27in
  • Materials:
  • Solid: 40D 85g/m² DryVent 2.5L — 100% nylon ripstop
  • Heather: 70D 161 g/m² DryVent 2.5L — 62% nylon, 38% polyester
  • Weight: 290g (10.23oz)
Overall Rating

0.0/5.0

Review Stats 0 total reviews

5 0

4 0

3 0

2 0

1 0

Write a Review
Very Poor Poor Average Very Good Excellent
Name: *
Location:
Review Title:
Review: * (maximum 1000 characters)
1 - 0 of 0

No reviews have been written for this product.
Be the first one!  –


FREE SHIPPING* ON ORDERS OVER $100.00
My Bag (0)
Menu

query
RESULTSET
query
  ADDITIONAL_DESCRIPTION AGERANGE ALTIMAGERECORDCOUNT ATTR1ID ATTR1LIST ATTR2ID BRAND BRANDDISPLAY DEPT DEPTTREE DESCRIPTION FAMLIST GENDER GOOGLEPRODUCTTAXONOMY HEXLIST ID INSTORE_ONLY INTERNALLISTPRICE INTERNALMARKDOWN INTERNALPRICE KEYWORDS LARGEPICTURE LISTPRICE LOWESTPRICE MEDIUMPICTURE METADESC METATAGS NAME NEW OF1 OF10 OF11 OF12 OF13 OF14 OF15 OF16 OF17 OF18 OF19 OF2 OF20 OF3 OF4 OF5 OF6 OF7 OF8 OF9 ORIGBRAND OVERALLQOH OVERALL_RATING PAGETITLE PICTUREID PICTURE_ID PRICERANGE PRODREVIEWSAVERAGE PRODREVIEWSRECORDCOUNT QUANTITYONHANDSUM QUANTITYSOLDSUM RANKING REALNAME ROMANTICCOPYLONG ROMANTICCOPYSHORT SALE SALEPRICERANGEBOTTOM SALEPRICERANGETOP SCALEID SHIP_SURCHARGE SIZELIST SIZING_IMAGE_FILE SMALLPICTURE SORTPOSITION STYLE STYLE_ID SUBTYP1 SUBTYP2 SUBTYP3 TERMSALE TERMSALELISTPRICE TERMSALEPRICE TINYPICTURE TYP URL USEPACKAGE VIDEO WEBSTYLE WEB_OF1 WEB_OF10 WEB_OF11 WEB_OF12 WEB_OF13 WEB_OF14 WEB_OF15 WEB_OF16 WEB_OF17 WEB_OF18 WEB_OF19 WEB_OF2 WEB_OF20 WEB_OF3 WEB_OF4 WEB_OF5 WEB_OF6 WEB_OF7 WEB_OF8 WEB_OF9
1 <ul> <li>Standard fit</li> <li>Waterproof, breathable, seam-sealed DryVent 2.5L shell</li> <li>100% windproof fabric</li> <li>Attached, fully adjustable hood</li> <li>Stormflap with Velcro&reg; closure covers the center front zip</li> <li>Covered, secure-zip hand pockets</li> <li>Stowable in hand pocket</li> <li>Pit-zip venting</li> <li>Adjustable Velcro&reg; cuff tabs</li> <li>Hem cinch-cord</li> <li>Centerback: 27in</li> <li>Materials:</li> <li>Solid: 40D 85g/m&sup2; DryVent 2.5L &mdash; 100% nylon ripstop</li> <li>Heather: 70D 161 g/m&sup2; DryVent 2.5L &mdash; 62% nylon, 38% polyester</li> <li>Weight: 290g (10.23oz)</li> </ul> [empty string] [empty string] 60726 PURPLE_D2Q,BLACK_JK3,GREY_FTJ,BLUE_TQ5, 47482 THE NORTH FACE The North Face CLOTHING & FOOTWEAR Clothing & Footwear &gt Women's &gt Outerwear &gt Rainwear [empty string] [empty string] [empty string] 596 [empty string] 27417484 [empty string] 99 99 99 tnf, jacket, outdoor 13243-DEFAULT-l.jpg 99 [empty string] 13243-DEFAULT-m.jpg Be prepared for backcountry storms in your everyday urban exploration. The North Face Women's Venture 2 Jacket has waterproof, breathable, seam-sealed fabric plus style and versatility for year-round wear. [empty string] W/ Venture 2 Jacket N NEWATTR [empty string] [empty string] [empty string] [empty string] BTSTFW [empty string] [empty string] LANYARD [empty string] ACTIVE A 10B [empty string] [empty string] FALL_3 [empty string] [empty string] [empty string] N NORTH FACE 124 0 [empty string] 13243 13243 50-to-100 0.00 0 [empty string] [empty string] [empty string] The North Face Women's Venture 2 Jacket <p>Updated with revised style lines, cleaner construction details and new fabric, The North Face Women&#39;s Venture 2 Jacket is a classic year-round jacket that is designed to withstand backcountry storms and is styled for everyday use.</p> [empty string] N 99 99 61089 0 L,M,S,XL,XS,XXL, [empty string] 13243-DEFAULT-s.jpg 1000 NF0A2VCR 107029 OUTERWEAR RAINWEAR EMPTY 0 [empty string] [empty string] 13243-DEFAULT-xs.jpg WOMENS shop/the-north-face-womens-venture--107029 0 [empty string] NF0A2VCR [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string]
CACHED false
EXECUTIONTIME 6
SQL SELECT * from [dbo].[web_all_products] WHERE style_id='107029' order by ID desc