LIP CRAYONS

burt's bees

No LIP_CRAYONS

Be the first to review!

Regular Price: $8.99

Sale Price: $7.19

Choose Color

query

RESULTSET

query
	ATTR1	ATTR1_ENTRY_ID	FAM	HEX	MAXQC	MAXQOH	MINQC	MINQOH	ORIGATTR1	QOH	SELL_WEB	SKUOF16	SKU_ID	SORT_ORDER	STYLE_ID
1	CAROLINA_COAST	41728	[empty string]	[empty string]	0	19	0	0	CAROLINA_COAST	111	Y	[empty string]	564005	[empty string]	117126
2	HAWAIIAN_SMOLDER	41729	[empty string]	[empty string]	0	21	0	0	HAWAIIAN_SMOLDER	106	Y	[empty string]	564006	[empty string]	117126
3	NAPA_VINEYARD	41730	[empty string]	[empty string]	0	20	0	0	NAPA_VINEYARD	107	Y	[empty string]	564007	[empty string]	117126
4	NIAGARA_OVERLOOK	41731	[empty string]	[empty string]	0	22	0	0	NIAGARA_OVERLOOK	106	Y	[empty string]	564008	[empty string]	117126
5	REDWOOD_FOREST	41732	[empty string]	[empty string]	0	16	-1	0	REDWOOD_FOREST	97	Y	[empty string]	564009	[empty string]	117126
6	SEDONA_SANDS	41733	[empty string]	[empty string]	0	19	0	0	SEDONA_SANDS	103	Y	[empty string]	564010	[empty string]	117126

SELECT distinct (b.attr1) as origAttr1, 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+e.qc) as qoh , max(b.attr1_order) as sort_order, max(c.attr1_hex) as hex,max(d.attr1_fam) as fam,max(a.SKU_OF16) as skuOF16,max(e.qoh) as maxqoh,max(e.qc) as maxqc,min(e.qoh) as minqoh,min(e.qc) as minqc,max(a.style_id) as style_id,max(a.sell_web) as sell_web FROM tb_skus a with (nolock) inner join (select distinct sku_id as sku_id from TB_SKU_BUCKETS with (nolock) where 1=1 and store_id in (11,5,8,6,9,14,15,7,2,1,3,97) group by sku_id having sum(qoh+qc) >=4) skuqoh on (skuqoh.sku_id=a.sku_id) LEFT JOIN tb_attr1_entries b WITH (NOLOCK) ON (b.attr1_entry_id = a.attr1_entry_id) LEFT JOIN tb_sku_buckets e WITH (NOLOCK) ON (e.sku_id = a.sku_id) LEFT JOIN tb_attr1_hexes c WITH (NOLOCK) ON (b.attr1=c.attr1) LEFT JOIN tb_attr1_families d WITH (NOLOCK) ON (c.attr1_fam_id = d.attr1_fam_id) WHERE (a.sell_web in ('Y','YES') ) and a.style_id=? AND e.store_id in(11,5,8,6,9,14,15,7,2,1,3,97) GROUP BY b.attr1 HAVING sum(e.qoh+e.qc) >= 4 ORDER BY max(b.attr1_order), max(b.attr1_entry_id)

SQLPARAMETERS

array
1	117126

struct
INTERNALLISTPRICE	8.99
INTERNALMARKDOWN	false
INTERNALPRICE	8.99
REG	8.99
SALE	7.192
TERMSALE	true
TERMSALELISTPRICE	8.99
TERMSALEPRICE	7.192

query

RESULTSET

query
	ATTR1	ATTR1_ENTRY_ID	FAM	HEX	MAXQC	MAXQOH	MINQC	MINQOH	ORIGATTR1	QOH	SELL_WEB	SKUOF16	SKU_ID	SORT_ORDER	STYLE_ID
1	CAROLINA_COAST	41728	[empty string]	[empty string]	0	19	0	0	CAROLINA_COAST	111	Y	[empty string]	564005	[empty string]	117126
2	HAWAIIAN_SMOLDER	41729	[empty string]	[empty string]	0	21	0	0	HAWAIIAN_SMOLDER	106	Y	[empty string]	564006	[empty string]	117126
3	NAPA_VINEYARD	41730	[empty string]	[empty string]	0	20	0	0	NAPA_VINEYARD	107	Y	[empty string]	564007	[empty string]	117126
4	NIAGARA_OVERLOOK	41731	[empty string]	[empty string]	0	22	0	0	NIAGARA_OVERLOOK	106	Y	[empty string]	564008	[empty string]	117126
5	REDWOOD_FOREST	41732	[empty string]	[empty string]	0	16	-1	0	REDWOOD_FOREST	97	Y	[empty string]	564009	[empty string]	117126
6	SEDONA_SANDS	41733	[empty string]	[empty string]	0	19	0	0	SEDONA_SANDS	103	Y	[empty string]	564010	[empty string]	117126

array
1	117126

struct
INTERNALLISTPRICE	8.99
INTERNALMARKDOWN	false
INTERNALPRICE	8.99
REG	8.99
SALE	7.192
TERMSALE	true
TERMSALELISTPRICE	8.99
TERMSALEPRICE	7.192

query

RESULTSET

query
	ATTR1	ATTR1_ENTRY_ID	FAM	HEX	MAXQC	MAXQOH	MINQC	MINQOH	ORIGATTR1	QOH	SELL_WEB	SKUOF16	SKU_ID	SORT_ORDER	STYLE_ID
1	CAROLINA_COAST	41728	[empty string]	[empty string]	0	19	0	0	CAROLINA_COAST	111	Y	[empty string]	564005	[empty string]	117126
2	HAWAIIAN_SMOLDER	41729	[empty string]	[empty string]	0	21	0	0	HAWAIIAN_SMOLDER	106	Y	[empty string]	564006	[empty string]	117126
3	NAPA_VINEYARD	41730	[empty string]	[empty string]	0	20	0	0	NAPA_VINEYARD	107	Y	[empty string]	564007	[empty string]	117126
4	NIAGARA_OVERLOOK	41731	[empty string]	[empty string]	0	22	0	0	NIAGARA_OVERLOOK	106	Y	[empty string]	564008	[empty string]	117126
5	REDWOOD_FOREST	41732	[empty string]	[empty string]	0	16	-1	0	REDWOOD_FOREST	97	Y	[empty string]	564009	[empty string]	117126
6	SEDONA_SANDS	41733	[empty string]	[empty string]	0	19	0	0	SEDONA_SANDS	103	Y	[empty string]	564010	[empty string]	117126

array
1	117126

struct
INTERNALLISTPRICE	8.99
INTERNALMARKDOWN	false
INTERNALPRICE	8.99
REG	8.99
SALE	7.192
TERMSALE	true
TERMSALELISTPRICE	8.99
TERMSALEPRICE	7.192

query

RESULTSET

query
	ATTR1	ATTR1_ENTRY_ID	FAM	HEX	MAXQC	MAXQOH	MINQC	MINQOH	ORIGATTR1	QOH	SELL_WEB	SKUOF16	SKU_ID	SORT_ORDER	STYLE_ID
1	CAROLINA_COAST	41728	[empty string]	[empty string]	0	19	0	0	CAROLINA_COAST	111	Y	[empty string]	564005	[empty string]	117126
2	HAWAIIAN_SMOLDER	41729	[empty string]	[empty string]	0	21	0	0	HAWAIIAN_SMOLDER	106	Y	[empty string]	564006	[empty string]	117126
3	NAPA_VINEYARD	41730	[empty string]	[empty string]	0	20	0	0	NAPA_VINEYARD	107	Y	[empty string]	564007	[empty string]	117126
4	NIAGARA_OVERLOOK	41731	[empty string]	[empty string]	0	22	0	0	NIAGARA_OVERLOOK	106	Y	[empty string]	564008	[empty string]	117126
5	REDWOOD_FOREST	41732	[empty string]	[empty string]	0	16	-1	0	REDWOOD_FOREST	97	Y	[empty string]	564009	[empty string]	117126
6	SEDONA_SANDS	41733	[empty string]	[empty string]	0	19	0	0	SEDONA_SANDS	103	Y	[empty string]	564010	[empty string]	117126

array
1	117126

struct
INTERNALLISTPRICE	8.99
INTERNALMARKDOWN	false
INTERNALPRICE	8.99
REG	8.99
SALE	7.192
TERMSALE	true
TERMSALELISTPRICE	8.99
TERMSALEPRICE	7.192

query

RESULTSET

query
	ATTR1	ATTR1_ENTRY_ID	FAM	HEX	MAXQC	MAXQOH	MINQC	MINQOH	ORIGATTR1	QOH	SELL_WEB	SKUOF16	SKU_ID	SORT_ORDER	STYLE_ID
1	CAROLINA_COAST	41728	[empty string]	[empty string]	0	19	0	0	CAROLINA_COAST	111	Y	[empty string]	564005	[empty string]	117126
2	HAWAIIAN_SMOLDER	41729	[empty string]	[empty string]	0	21	0	0	HAWAIIAN_SMOLDER	106	Y	[empty string]	564006	[empty string]	117126
3	NAPA_VINEYARD	41730	[empty string]	[empty string]	0	20	0	0	NAPA_VINEYARD	107	Y	[empty string]	564007	[empty string]	117126
4	NIAGARA_OVERLOOK	41731	[empty string]	[empty string]	0	22	0	0	NIAGARA_OVERLOOK	106	Y	[empty string]	564008	[empty string]	117126
5	REDWOOD_FOREST	41732	[empty string]	[empty string]	0	16	-1	0	REDWOOD_FOREST	97	Y	[empty string]	564009	[empty string]	117126
6	SEDONA_SANDS	41733	[empty string]	[empty string]	0	19	0	0	SEDONA_SANDS	103	Y	[empty string]	564010	[empty string]	117126

array
1	117126

struct
INTERNALLISTPRICE	8.99
INTERNALMARKDOWN	false
INTERNALPRICE	8.99
REG	8.99
SALE	7.192
TERMSALE	true
TERMSALELISTPRICE	8.99
TERMSALEPRICE	7.192

query

RESULTSET

query
	ATTR1	ATTR1_ENTRY_ID	FAM	HEX	MAXQC	MAXQOH	MINQC	MINQOH	ORIGATTR1	QOH	SELL_WEB	SKUOF16	SKU_ID	SORT_ORDER	STYLE_ID
1	CAROLINA_COAST	41728	[empty string]	[empty string]	0	19	0	0	CAROLINA_COAST	111	Y	[empty string]	564005	[empty string]	117126
2	HAWAIIAN_SMOLDER	41729	[empty string]	[empty string]	0	21	0	0	HAWAIIAN_SMOLDER	106	Y	[empty string]	564006	[empty string]	117126
3	NAPA_VINEYARD	41730	[empty string]	[empty string]	0	20	0	0	NAPA_VINEYARD	107	Y	[empty string]	564007	[empty string]	117126
4	NIAGARA_OVERLOOK	41731	[empty string]	[empty string]	0	22	0	0	NIAGARA_OVERLOOK	106	Y	[empty string]	564008	[empty string]	117126
5	REDWOOD_FOREST	41732	[empty string]	[empty string]	0	16	-1	0	REDWOOD_FOREST	97	Y	[empty string]	564009	[empty string]	117126
6	SEDONA_SANDS	41733	[empty string]	[empty string]	0	19	0	0	SEDONA_SANDS	103	Y	[empty string]	564010	[empty string]	117126

array
1	117126

struct
INTERNALLISTPRICE	8.99
INTERNALMARKDOWN	false
INTERNALPRICE	8.99
REG	8.99
SALE	7.192
TERMSALE	true
TERMSALELISTPRICE	8.99
TERMSALEPRICE	7.192

Qty

Check Store Availability

Add to Basket

Please login or create an account to save this product to your wish list.

Description
Specs
Reviews
Live Chat

creamy coverage from coast to coast

Take your lips on a tour of this great country of ours with Burt's Bees Lip Crayons. With six new regionally named, creamy shades of color, you'll enjoy lightweight moisture in each stick. It's perfect for everyday wear, alone or layered under lip gloss, and will leave your lips feeling soft and smooch-worthy.

Made in USA
100% natural
Creamy matte color
Lightweight moisture
Infused with shea butter, kendi oil, and jojoba oil
No added flavor or fragrance
Precise application
Never needs sharpening

No Reviews Yet!

Spill the Beans

Headline Name Email Overall Rating

Review

We want to make sure you know: All reviews become the property of Mast General Store. Your review requires staff approval before posting. See our Terms of Use for details.

Description

Take your lips on a tour of this great country of ours with Burt's Bees Lip Crayons. With six new regionally named, creamy shades of color, you'll enjoy lightweight moisture in each stick. It's perfect for everyday wear, alone or layered under lip gloss, and will leave your lips feeling soft and smooch-worthy.
Specs
- Made in USA
- 100% natural
- Creamy matte color
- Lightweight moisture
- Infused with shea butter, kendi oil, and jojoba oil
- No added flavor or fragrance
- Precise application
- Never needs sharpening
Reviews

No Reviews Yet!
Live Chat

LIP CRAYONS

Regular Price: $8.99

Sale Price: $7.19

Choose Color

Qty

Spill the Beans

You may also like

Regular Price: $12.99

Sale Price: $10.39