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] = 'ABL9300' 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='ABL9300' AND (V_productcolor.colorlocation='external') ORDER BY colors.color [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 #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 = 'ABL9300' AND active = 1 ORDER BY sequence [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 #24 [insert_id:protected] => [sql:protected] => SELECT * FROM V_PriceGrid WHERE Web_Id = 'ABL9300' AND LocaleID = 1 ORDER BY SEQ [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 #26 [insert_id:protected] => [sql:protected] => --function name: getFamilyListOfWebIDs SELECT relatedWeb_Id FROM V_ProductsRelatedByMaster WHERE web_Id = 'ABL9300' AND active = 1 [current_row:protected] => 0 [total_rows:protected] => 3 ) 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 ('ABL9300','ABL9310','ABL9320')) OR (type_description != 'Chocolate Options' AND web_id IN ('ABL9300')) 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 = 'ABL9300' ORDER BY sequence 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 #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 ('') --get_alternates [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 #34 [insert_id:protected] => [sql:protected] => --function getCategoryIDFromProduct(ABL9300) SELECT Web_ID,CategoryID FROM V_ProductsXCategories WHERE Web_ID = 'ABL9300' ORDER BY isPrimary DESC [current_row:protected] => 0 [total_rows:protected] => 10 ) Mssql_Result Object ( [fetch_type:protected] => mssql_fetch_object [return_type:protected] => stdClass [result:protected] => Resource id #36 [insert_id:protected] => [sql:protected] => SELECT * FROM V_CatSmry WHERE categoryID IN (2240 ) AND Web_id NOT IN ( 'ABL9300' ) AND LocaleID = 1 ORDER BY isBestSeller DESC, sortBestSeller ASC, moqAdjPrice ASC [current_row:protected] => 0 [total_rows:protected] => 66 ) Mssql_Result Object ( [fetch_type:protected] => mssql_fetch_object [return_type:protected] => stdClass [result:protected] => Resource id #38 [insert_id:protected] => [sql:protected] => SELECT SEQ, Web_Id, DetailName, DetailValue FROM dbo.V_ProductDetail WHERE Web_Id = 'ABL9300' 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 #40 [insert_id:protected] => [sql:protected] => SELECT Web_ID,CategoryID FROM V_ProductsXCategories WHERE isPrimary = 1 AND Web_ID = 'ABL9300' [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 #42 [insert_id:protected] => [sql:protected] => SELECT CategoryName, CatParentID, keywords FROM V_ProductCategories WHERE CategoryID = 2240 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 #44 [insert_id:protected] => [sql:protected] => SELECT CategoryName, CatParentID, keywords FROM V_ProductCategories WHERE CategoryID = 24 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: Fresh Start Kit Sleek & Simple. Supplied By: Lanco
  
×
NC Customers / Nassau Candy / Chocolate Inn / LANCO Promotions

Visit us at NCcustom.com
 

Fresh Start Kit Sleek & Simple

Print

Fresh Start Kit Sleek & Simple

Item #ABL9300
Supplied by: Lanco

Choose another product option:

ABL9300 50 150 300 600
Price $8.98 $8.54 $8.30 $8.06 4C
Absolute Minimum Order Quantity: 50 USD
Sold by the: PIECE

This product is subject to federal shipping regulations (detail)



Fresh Start Kit Sleek & Simple.

  • 1 Cloth Mask (MSK100).
  • 1 1oz. Hand Sanitizer Bottle (ABL3130).
  • 1 Domed Mint Tin (300).
  • Packaged in a stand up pouch with full color label.
  • All sales final.

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

Imprinting Information: Setup charge $120(G). Re-order setup charge $50(G). Set-up charge is for a standard one location imprint on items. All items in kit are included in the set-up price.


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