Mssql_Result Object ( [fetch_type:protected] => mssql_fetch_object [return_type:protected] => stdClass [result:protected] => Resource id #3 [insert_id:protected] => [sql:protected] => SELECT id ,seq ,brandName ,descriptiveText ,brandLogo ,urlName ,createDate ,updateDate FROM ProductBrand ORDER BY seq,brandName [current_row:protected] => 0 [total_rows:protected] => 4 ) Mssql_Result Object ( [fetch_type:protected] => mssql_fetch_object [return_type:protected] => stdClass [result:protected] => Resource id #6 [insert_id:protected] => [sql:protected] => SELECT CategoryID, CategoryName FROM V_ProductBrandsAndCategories WHERE CatParentID = 0 AND CategoryId != 60 AND display = 1 AND brandId = 1 ORDER BY sort [current_row:protected] => 0 [total_rows:protected] => 32 ) Mssql_Result Object ( [fetch_type:protected] => mssql_fetch_object [return_type:protected] => stdClass [result:protected] => Resource id #8 [insert_id:protected] => [sql:protected] => SELECT CategoryID, CategoryName FROM V_ProductBrandsAndCategories WHERE CatParentID = 0 AND CategoryId != 60 AND display = 1 AND brandId = 3 ORDER BY sort [current_row:protected] => 0 [total_rows:protected] => 15 ) Mssql_Result Object ( [fetch_type:protected] => mssql_fetch_object [return_type:protected] => stdClass [result:protected] => Resource id #10 [insert_id:protected] => [sql:protected] => SELECT CategoryID, CategoryName FROM V_ProductBrandsAndCategories WHERE CatParentID = 0 AND CategoryId != 60 AND display = 1 AND brandId = 4 ORDER BY sort [current_row:protected] => 0 [total_rows:protected] => 12 ) Mssql_Result Object ( [fetch_type:protected] => mssql_fetch_object [return_type:protected] => stdClass [result:protected] => Resource id #12 [insert_id:protected] => [sql:protected] => SELECT CategoryID, CategoryName FROM V_ProductBrandsAndCategories WHERE CatParentID = 0 AND CategoryId != 60 AND display = 1 AND brandId = 5 ORDER BY sort [current_row:protected] => 0 [total_rows:protected] => 5 ) Mssql_Result Object ( [fetch_type:protected] => mssql_fetch_object [return_type:protected] => stdClass [result:protected] => Resource id #15 [insert_id:protected] => [sql:protected] => SELECT msgName as message_name, msgHTML as message FROM nccMessage where id = 3 [current_row:protected] => 0 [total_rows:protected] => 1 ) Mssql_Result Object ( [fetch_type:protected] => mssql_fetch_object [return_type:protected] => stdClass [result:protected] => Resource id #18 [insert_id:protected] => [sql:protected] => SELECT * FROM [V_ProductInformation] WHERE [web_id] = 'DRK1660' AND [LocaleID] = 1 [current_row:protected] => 0 [total_rows:protected] => 1 ) Mssql_Result Object ( [fetch_type:protected] => mssql_fetch_object [return_type:protected] => stdClass [result:protected] => Resource id #20 [insert_id:protected] => [sql:protected] => SELECT colors.Color FROM V_productcolor INNER JOIN colors ON V_productcolor.color_id = colors.Color_Id WHERE V_productcolor.web_id='DRK1660' AND (V_productcolor.colorlocation='external') ORDER BY colors.color [current_row:protected] => 0 [total_rows:protected] => 5 ) Mssql_Result Object ( [fetch_type:protected] => mssql_fetch_object [return_type:protected] => stdClass [result:protected] => Resource id #22 [insert_id:protected] => [sql:protected] => SELECT Web_Id,productOption_Id AS alt_item, productOption_Name AS alt_item_name FROM V_ProductOptionDropdown WHERE Web_Id = 'DRK1660' AND active = 1 ORDER BY sequence [current_row:protected] => 0 [total_rows:protected] => 0 ) Mssql_Result Object ( [fetch_type:protected] => mssql_fetch_object [return_type:protected] => stdClass [result:protected] => Resource id #24 [insert_id:protected] => [sql:protected] => SELECT * FROM V_PriceGrid WHERE Web_Id = 'DRK1660' AND LocaleID = 1 ORDER BY SEQ [current_row:protected] => 0 [total_rows:protected] => 2 ) Mssql_Result Object ( [fetch_type:protected] => mssql_fetch_object [return_type:protected] => stdClass [result:protected] => Resource id #26 [insert_id:protected] => [sql:protected] => --function name: getFamilyListOfWebIDs SELECT relatedWeb_Id FROM V_ProductsRelatedByMaster WHERE web_Id = 'DRK1660' AND active = 1 [current_row:protected] => 0 [total_rows:protected] => 1 ) Mssql_Result Object ( [fetch_type:protected] => mssql_fetch_object [return_type:protected] => stdClass [result:protected] => Resource id #28 [insert_id:protected] => [sql:protected] => --function name: getOptionsByIDs SELECT web_id, type_description, option_description, optionNumber, optionName, image, uomprice, cost_code, message, markup_method FROM V_GetProductOptions WHERE (type_description = 'Chocolate Options' AND web_id IN ('DRK1660')) OR (type_description != 'Chocolate Options' AND web_id IN ('DRK1660')) ORDER BY sort ASC [current_row:protected] => 0 [total_rows:protected] => 0 ) Mssql_Result Object ( [fetch_type:protected] => mssql_fetch_object [return_type:protected] => stdClass [result:protected] => Resource id #30 [insert_id:protected] => [sql:protected] => --function get_alternates() first query SELECT alt_item FROM V_productAlternates WHERE web_id = 'DRK1660' ORDER BY sequence ASC [current_row:protected] => 0 [total_rows:protected] => 7 ) Mssql_Result Object ( [fetch_type:protected] => mssql_fetch_object [return_type:protected] => stdClass [result:protected] => Resource id #32 [insert_id:protected] => [sql:protected] => --function get_alternates() second query SELECT * FROM V_ProductSmry WHERE LocaleID = 1 AND active = 1 AND Web_id IN ('DRK1800','DRK1900','DRK1950','DRK1960','DRK1980','DRK240','DRK330') --get_alternates [current_row:protected] => 0 [total_rows:protected] => 7 ) Mssql_Result Object ( [fetch_type:protected] => mssql_fetch_object [return_type:protected] => stdClass [result:protected] => Resource id #34 [insert_id:protected] => [sql:protected] => SELECT SEQ, Web_Id, DetailName, DetailValue FROM dbo.V_ProductDetail WHERE Web_Id = 'DRK1660' AND isAgg = 0 -- 1 returns aggregated product details in a single cell. ORDER BY SEQ ASC [current_row:protected] => 0 [total_rows:protected] => 5 ) Mssql_Result Object ( [fetch_type:protected] => mssql_fetch_object [return_type:protected] => stdClass [result:protected] => Resource id #36 [insert_id:protected] => [sql:protected] => SELECT Web_ID,CategoryID FROM V_ProductsXCategories WHERE isPrimary = 1 AND Web_ID = 'DRK1660' [current_row:protected] => 0 [total_rows:protected] => 1 ) Mssql_Result Object ( [fetch_type:protected] => mssql_fetch_object [return_type:protected] => stdClass [result:protected] => Resource id #38 [insert_id:protected] => [sql:protected] => SELECT CategoryName, CatParentID, keywords FROM V_ProductCategories WHERE CategoryID = 498 AND display = 1 [current_row:protected] => 0 [total_rows:protected] => 1 ) Mssql_Result Object ( [fetch_type:protected] => mssql_fetch_object [return_type:protected] => stdClass [result:protected] => Resource id #40 [insert_id:protected] => [sql:protected] => SELECT CategoryName, CatParentID, keywords FROM V_ProductCategories WHERE CategoryID = 14 AND display = 1 [current_row:protected] => 0 [total_rows:protected] => 1 ) Mssql_Result Object ( [fetch_type:protected] => mssql_fetch_object [return_type:protected] => stdClass [result:protected] => Resource id #3 [insert_id:protected] => [sql:protected] => SELECT id ,seq ,brandName ,descriptiveText ,brandLogo ,urlName ,createDate ,updateDate FROM ProductBrand ORDER BY seq,brandName [current_row:protected] => 0 [total_rows:protected] => 4 ) Mssql_Result Object ( [fetch_type:protected] => mssql_fetch_object [return_type:protected] => stdClass [result:protected] => Resource id #6 [insert_id:protected] => [sql:protected] => SELECT CategoryID, CategoryName FROM V_ProductBrandsAndCategories WHERE CatParentID = 0 AND CategoryId != 60 AND display = 1 AND brandId = 1 ORDER BY sort [current_row:protected] => 0 [total_rows:protected] => 32 ) Mssql_Result Object ( [fetch_type:protected] => mssql_fetch_object [return_type:protected] => stdClass [result:protected] => Resource id #8 [insert_id:protected] => [sql:protected] => SELECT CategoryID, CategoryName FROM V_ProductBrandsAndCategories WHERE CatParentID = 0 AND CategoryId != 60 AND display = 1 AND brandId = 3 ORDER BY sort [current_row:protected] => 0 [total_rows:protected] => 15 ) Mssql_Result Object ( [fetch_type:protected] => mssql_fetch_object [return_type:protected] => stdClass [result:protected] => Resource id #10 [insert_id:protected] => [sql:protected] => SELECT CategoryID, CategoryName FROM V_ProductBrandsAndCategories WHERE CatParentID = 0 AND CategoryId != 60 AND display = 1 AND brandId = 4 ORDER BY sort [current_row:protected] => 0 [total_rows:protected] => 12 ) Mssql_Result Object ( [fetch_type:protected] => mssql_fetch_object [return_type:protected] => stdClass [result:protected] => Resource id #12 [insert_id:protected] => [sql:protected] => SELECT CategoryID, CategoryName FROM V_ProductBrandsAndCategories WHERE CatParentID = 0 AND CategoryId != 60 AND display = 1 AND brandId = 5 ORDER BY sort [current_row:protected] => 0 [total_rows:protected] => 5 ) NC Custom: 20 oz Satin Vacuum Tumbler. Supplied By: Lanco
  
×
NC Customers / Nassau Candy / Chocolate Inn / LANCO Promotions

Visit us at NCcustom.com
 

20 oz Satin Vacuum Tumbler

Print

20 oz Satin Vacuum Tumbler

Item #DRK1660
Supplied by: Lanco

DRK1660 48 96 288 576
Price $11.51 $10.96 $10.64 $10.34 4C
24 Hour Rush $13.81 $13.15 $12.77 n/a 3C
Absolute Minimum Order Quantity: 48
24 hour rush service available
USD
Sold by the: PIECE


Keep your brand on the move and your drinks at optimal temperatures thanks to these logoed satin tumblers. Designed with a capacity of 20 ounces, each tumbler measures 10 1/2"H x 3"D and features vacuum insulation and a handle lid for an easy carry. They are available in an assortment of colors and customization is offered, so add a one color imprint, showcasing a brand name, logo, marketing message and more.


Size:
Production Time:
Imprint Method:
Imprint Area:
Color Options:

Imprinting Information: (One color imprint only) Set-up charge $50(G) per location. Additional location running charge $.30(G) per piece. Re-order set-up charge $30(G) per location. (Run charges apply).


Absolute Min Order Qty:

Item Size:

Max Imprint Area:

Imprint Template:

Qty per Carton:
Carton Dimensions:
Ship Wt per Carton:
FOB Point:
 

You Might Also Like...

Overview


Details


Ordering


Shipping

Follow Us

 
Top