Waterloo

Notice (8): Undefined variable: total_count [APP/View/Sellers/brands.ctp, line 163]
Code Context
              <div id="categoryInfo"> 
                <?php foreach($interests as $interest => $interestKey): ?>
                <?php  $total_count += $interests[$interest][2]; ?>
$viewFile = '/home/grovara/public_html/platform/app/View/Sellers/brands.ctp'
$dataForView = array(
	'allow_terms' => false,
	'brand_buyer_discounts' => array(),
	'seller' => array(
		'User' => array(
			'password' => '*****',
			'id' => '437',
			'role_id' => '10',
			'seller_id' => null,
			'email' => 'nate@drinkwaterloo.com',
			'first_name' => 'Nate ',
			'middle_name' => null,
			'last_name' => 'Bernstein',
			'phone_number' => null,
			'fax_number' => null,
			'cell_number' => '7272524574',
			'title' => 'VP Alternate Channels',
			'website' => null,
			'avatar' => null,
			'profile_pic' => null,
			'token' => null,
			'token_issued' => null,
			'brand_subscription' => null,
			'subscription_plan_id' => null,
			'subscription_start_date' => null,
			'free_trial' => false,
			'is_active' => true,
			'status' => '2',
			'status_reason' => null,
			'status_date' => null,
			'status_submitted_by' => null,
			'last_login' => '2021-07-08 14:29:34',
			'created' => '2020-09-30 14:57:43',
			'modified' => '2022-04-08 04:00:02',
			'user_type_id' => '3',
			'brand_id' => null,
			'super_brand_id' => null,
			'stripe_token' => null,
			'stripe_user_id' => null,
			'stripe_sub_id' => null,
			'wire_only' => null,
			'accepted_tos' => true,
			'tos_path' => null,
			'tos_date' => null,
			'grovara_signed_tos' => null,
			'tos_hash' => null,
			'qb_id' => '3734',
			'2fa_key' => null,
			'2fa_status' => null,
			'hubspot_id' => '396001',
			'hubspot_association' => true,
			'accounting_contact' => false,
			'transfermate_id' => null,
			'full_name' => 'Nate  Bernstein',
			'company_name' => '',
			'country_code' => '',
			'city' => '',
			'profile_status_id' => '',
			'has_ordered' => '',
			'email_lower' => 'nate@drinkwaterloo.com'
		)
	),
	'brand' => array(
		'Brand' => array(
			'id' => '56',
			'name' => 'Waterloo ',
			'slug' => 'waterloo-',
			'logo' => 'WL_logo-MAIN_1 (2).png',
			'main_banner' => 'Banner_1134.124_1.png',
			'sub_banner_1' => null,
			'sub_banner_2' => null,
			'sub_banner_3' => null,
			'sub_banner_4' => null,
			'website' => 'https://www.drinkwaterloo.com/',
			'facebook' => 'https://www.facebook.com/waterloosparkling',
			'pinterest' => '',
			'twitter' => 'https://twitter.com/DoYouWaterloo',
			'instagram' => 'https://www.instagram.com/waterloosparkling/',
			'youtube' => '',
			'promo_video' => '',
			'promo_video_1' => '',
			'promo_video_2' => '',
			'about' => 'All Waterloo’s natural flavor ingredients are derived from non-GMO, vegan sources. Oils, extracts, or essences from the named fruit (or fruits) on each variety are paired with complementary flavors to build our unique, bold taste profile. Using these powerful extracts and oils allows us to pack a lot of flavor without any sugar, sweeteners, or other unwanted additives.',
			'grovara_comments' => 'Grovara can not pursue international Costcos. ',
			'policies' => '',
			'policies_modified' => '2021-06-22 11:57:31',
			'payment' => '',
			'spins_metric_type_1' => 'Sales',
			'spins_title_description_1' => 'YOY',
			'spins_metric_1' => '$112.3M',
			'spins_channel_1' => 'Natural & Organic',
			'spins_channel_subtext_1' => '',
			'spins_metric_type_2' => 'Growth Dollars',
			'spins_title_description_2' => 'YOY',
			'spins_metric_2' => '49%',
			'spins_channel_2' => 'Natural & Organic',
			'spins_channel_subtext_2' => '',
			'spins_scorecard' => null,
			'promoted_products' => '',
			'active' => true,
			'samples_allowed' => true,
			'product_sort' => '["200060","200040","200600","200760","200250","200260","200070","200130","200570","200200","200110","200700","200730","200210","200140","201100","201030","200580","G020969","202070","202060","202100","202090"]',
			'meta_title' => 'Waterloo ',
			'meta_description' => 'All Waterloo’s natural flavor ingredients are derived from non-GMO, vegan sources. Oils, extracts, or essences from the named fruit (or fruits) on each variety are paired with complementary flavors to build our unique, bold taste profile. Using these powerful extracts and oils allows us to pack a lot of flavor without any sugar, sweeteners, or other unwanted additives.',
			'created' => '2020-09-30 14:57:43',
			'modified' => '2023-03-13 12:31:54',
			'spins_metric_3' => '#32',
			'spins_metric_type_3' => 'Out of 945',
			'spins_title_description_3' => 'YOY',
			'spins_channel_3' => 'Shelf Stable Water',
			'spins_channel_subtext_3' => '',
			'brochure_1' => 'Waterloo_Presentation_7_28_2021.pdf',
			'brochure_2' => 'Waterloo2022BrandOverview081022.pptx',
			'brochure_3' => '',
			'mkt_support' => false,
			'mkt_support_text' => '',
			'bracket_pricing_1' => null,
			'bracket_pricing_2' => null,
			'offers_terms' => 'yes',
			'offers_terms_text' => '',
			'allow_pallet_height_70' => false,
			'brand_country' => 'US'
		),
		'BrandFaq' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			),
			(int) 2 => array(
				[maximum depth reached]
			)
		)
	),
	'products' => array(
		(int) 0 => array(
			'Product' => array(
				[maximum depth reached]
			),
			'ParentProduct' => array(
				[maximum depth reached]
			),
			'Category' => array(
				[maximum depth reached]
			),
			'SubCategory' => array(
				[maximum depth reached]
			),
			'ShippingStorage' => array(
				[maximum depth reached]
			),
			'Brand' => array(
				[maximum depth reached]
			),
			'ProductCategory' => array([maximum depth reached]),
			'ProductImage' => array([maximum depth reached]),
			'ChildProduct' => array([maximum depth reached]),
			'MerchPalletProduct' => array([maximum depth reached]),
			'NotifyInStock' => array([maximum depth reached])
		),
		(int) 1 => array(
			'Product' => array(
				[maximum depth reached]
			),
			'ParentProduct' => array(
				[maximum depth reached]
			),
			'Category' => array(
				[maximum depth reached]
			),
			'SubCategory' => array(
				[maximum depth reached]
			),
			'ShippingStorage' => array(
				[maximum depth reached]
			),
			'Brand' => array(
				[maximum depth reached]
			),
			'ProductCategory' => array([maximum depth reached]),
			'ProductImage' => array([maximum depth reached]),
			'ChildProduct' => array([maximum depth reached]),
			'MerchPalletProduct' => array([maximum depth reached]),
			'NotifyInStock' => array([maximum depth reached])
		),
		(int) 2 => array(
			'Product' => array(
				[maximum depth reached]
			),
			'ParentProduct' => array(
				[maximum depth reached]
			),
			'Category' => array(
				[maximum depth reached]
			),
			'SubCategory' => array(
				[maximum depth reached]
			),
			'ShippingStorage' => array(
				[maximum depth reached]
			),
			'Brand' => array(
				[maximum depth reached]
			),
			'ProductCategory' => array([maximum depth reached]),
			'ProductImage' => array([maximum depth reached]),
			'ChildProduct' => array([maximum depth reached]),
			'MerchPalletProduct' => array([maximum depth reached]),
			'NotifyInStock' => array([maximum depth reached])
		),
		(int) 3 => array(
			'Product' => array(
				[maximum depth reached]
			),
			'ParentProduct' => array(
				[maximum depth reached]
			),
			'Category' => array(
				[maximum depth reached]
			),
			'SubCategory' => array(
				[maximum depth reached]
			),
			'ShippingStorage' => array(
				[maximum depth reached]
			),
			'Brand' => array(
				[maximum depth reached]
			),
			'ProductCategory' => array([maximum depth reached]),
			'ProductImage' => array([maximum depth reached]),
			'ChildProduct' => array([maximum depth reached]),
			'MerchPalletProduct' => array([maximum depth reached]),
			'NotifyInStock' => array([maximum depth reached])
		),
		(int) 4 => array(
			'Product' => array(
				[maximum depth reached]
			),
			'ParentProduct' => array(
				[maximum depth reached]
			),
			'Category' => array(
				[maximum depth reached]
			),
			'SubCategory' => array(
				[maximum depth reached]
			),
			'ShippingStorage' => array(
				[maximum depth reached]
			),
			'Brand' => array(
				[maximum depth reached]
			),
			'ProductCategory' => array([maximum depth reached]),
			'ProductImage' => array([maximum depth reached]),
			'ChildProduct' => array([maximum depth reached]),
			'MerchPalletProduct' => array([maximum depth reached]),
			'NotifyInStock' => array([maximum depth reached])
		),
		(int) 5 => array(
			'Product' => array(
				[maximum depth reached]
			),
			'ParentProduct' => array(
				[maximum depth reached]
			),
			'Category' => array(
				[maximum depth reached]
			),
			'SubCategory' => array(
				[maximum depth reached]
			),
			'ShippingStorage' => array(
				[maximum depth reached]
			),
			'Brand' => array(
				[maximum depth reached]
			),
			'ProductCategory' => array([maximum depth reached]),
			'ProductImage' => array([maximum depth reached]),
			'ChildProduct' => array([maximum depth reached]),
			'MerchPalletProduct' => array([maximum depth reached]),
			'NotifyInStock' => array([maximum depth reached])
		),
		(int) 6 => array(
			'Product' => array(
				[maximum depth reached]
			),
			'ParentProduct' => array(
				[maximum depth reached]
			),
			'Category' => array(
				[maximum depth reached]
			),
			'SubCategory' => array(
				[maximum depth reached]
			),
			'ShippingStorage' => array(
				[maximum depth reached]
			),
			'Brand' => array(
				[maximum depth reached]
			),
			'ProductCategory' => array(
				[maximum depth reached]
			),
			'ProductImage' => array([maximum depth reached]),
			'ChildProduct' => array([maximum depth reached]),
			'MerchPalletProduct' => array([maximum depth reached]),
			'NotifyInStock' => array([maximum depth reached])
		),
		(int) 7 => array(
			'Product' => array(
				[maximum depth reached]
			),
			'ParentProduct' => array(
				[maximum depth reached]
			),
			'Category' => array(
				[maximum depth reached]
			),
			'SubCategory' => array(
				[maximum depth reached]
			),
			'ShippingStorage' => array(
				[maximum depth reached]
			),
			'Brand' => array(
				[maximum depth reached]
			),
			'ProductCategory' => array([maximum depth reached]),
			'ProductImage' => array([maximum depth reached]),
			'ChildProduct' => array([maximum depth reached]),
			'MerchPalletProduct' => array([maximum depth reached]),
			'NotifyInStock' => array([maximum depth reached])
		)
	),
	'profile' => array(
		'Profile' => array(
			'id' => '365',
			'full_name' => 'Nate  Bernstein',
			'business_name' => 'Waterloo ',
			'legal_company_name' => 'Waterloo ',
			'job_title' => '',
			'tin' => '111111111',
			'address_1' => '2612 East Cesar Chavez Street ',
			'address_2' => 'Suite 200 ',
			'city' => 'Austin ',
			'country' => 'US',
			'state' => 'TX',
			'postal_code' => '78702',
			'business_phone' => '(512) 910- 8990',
			'mobile_phone' => null,
			'company_website' => 'www.drinkwaterloo.com',
			'made_in_usa' => true,
			'whse_address_1' => 'Refresco',
			'whse_address_2' => '2525 Schuetz Rd',
			'whse_city' => 'Maryland Heights',
			'whse_state' => 'MO',
			'whse_postal_code' => '63043',
			'whse_country' => 'US',
			'categories' => '',
			'created' => '2020-09-30 14:57:43',
			'modified' => '2023-03-13 12:31:54',
			'active' => true,
			'approved' => true,
			'user_id' => '437',
			'buyer_type' => null,
			'categories_of_interest' => null,
			'grovara_buyer_rep_1' => null,
			'grovara_buyer_rep_2' => null,
			'grovara_brand_rep_1' => '795',
			'grovara_brand_rep_2' => null,
			'messages_rep' => null,
			'measurement_type' => 'STANDARD',
			'shipping_type_id' => '5',
			'shipping_mode_id' => '1',
			'incoterm_id' => '1',
			'finterm_id' => '4',
			'accepted_finterm_ids' => null,
			'required_finterm_id' => null,
			'accepted_terms' => false,
			'accepted_accrual' => false,
			'status' => '2',
			'status_reason' => '',
			'status_date' => '2021-05-28 11:06:19',
			'status_submitted_by' => '1',
			'created_by_grovara' => false,
			'hubspot_id' => '2458727162',
			'moq' => 'One pallet per flavor MOQ ',
			'allow_terms' => false,
			'exclusive_brand_id' => null,
			'prohibited_brand_id' => null,
			'available_finterms' => 'Net 30, Net 21, Net 15, Cash Advance'
		)
	),
	'faqs' => array(
		(int) 0 => array(
			'BrandFaq' => array(
				[maximum depth reached]
			)
		),
		(int) 1 => array(
			'BrandFaq' => array(
				[maximum depth reached]
			)
		),
		(int) 2 => array(
			'BrandFaq' => array(
				[maximum depth reached]
			)
		)
	),
	'interests' => array(
		(int) 0 => array(
			(int) 0 => 'Dairy Free',
			(int) 1 => 'claim_dairy_free',
			(int) 2 => (int) 0
		),
		(int) 1 => array(
			(int) 0 => 'Fair Trade',
			(int) 1 => 'claim_fair_trade',
			(int) 2 => (int) 0
		),
		(int) 2 => array(
			(int) 0 => 'Gluten Free',
			(int) 1 => 'claim_gluten_free',
			(int) 2 => (int) 21
		),
		(int) 3 => array(
			(int) 0 => 'Grain Free',
			(int) 1 => 'claim_grain_free',
			(int) 2 => (int) 0
		),
		(int) 4 => array(
			(int) 0 => 'Halal',
			(int) 1 => 'claim_halai',
			(int) 2 => (int) 0
		),
		(int) 5 => array(
			(int) 0 => 'Kosher',
			(int) 1 => 'claim_kosher',
			(int) 2 => (int) 21
		),
		(int) 6 => array(
			(int) 0 => 'Low Carb',
			(int) 1 => 'claim_low_carb',
			(int) 2 => (int) 0
		),
		(int) 7 => array(
			(int) 0 => 'Non GMO',
			(int) 1 => 'claim_non_gmo',
			(int) 2 => (int) 21
		),
		(int) 8 => array(
			(int) 0 => 'Nut Free',
			(int) 1 => 'claim_nut_free',
			(int) 2 => (int) 0
		),
		(int) 9 => array(
			(int) 0 => 'Organic',
			(int) 1 => 'claim_organic',
			(int) 2 => (int) 0
		),
		(int) 10 => array(
			(int) 0 => 'Paleo',
			(int) 1 => 'claim_paleo',
			(int) 2 => (int) 0
		),
		(int) 11 => array(
			(int) 0 => 'Plant Based',
			(int) 1 => 'claim_plant_based',
			(int) 2 => (int) 0
		),
		(int) 12 => array(
			(int) 0 => 'Vegan',
			(int) 1 => 'claim_vegan',
			(int) 2 => (int) 21
		),
		(int) 13 => array(
			(int) 0 => 'Vegetarian',
			(int) 1 => 'claim_vegetarian',
			(int) 2 => (int) 0
		),
		(int) 14 => array(
			(int) 0 => 'Wheat Free',
			(int) 1 => 'claim_wheat_free',
			(int) 2 => (int) 0
		)
	),
	'additional_whses' => array(
		(int) 0 => array(
			'BrandWarehouse' => array(
				[maximum depth reached]
			)
		),
		(int) 1 => array(
			'BrandWarehouse' => array(
				[maximum depth reached]
			)
		),
		(int) 2 => array(
			'BrandWarehouse' => array(
				[maximum depth reached]
			)
		),
		(int) 3 => array(
			'BrandWarehouse' => array(
				[maximum depth reached]
			)
		)
	),
	'description_for_layout' => 'All Waterloo’s natural flavor ingredients are derived from non-GMO, vegan sources. Oils, extracts, or essences from the named fruit (or fruits) on each variety are paired with complementary flavors to build our unique, bold taste profile. Using these powerful extracts and oils allows us to pack a lot of flavor without any sugar, sweeteners, or other unwanted additives.',
	'title_for_layout' => 'Waterloo ',
	'user_measurement_type' => 'STANDARD',
	'activeUserAcceptedTos' => (int) 0,
	'access_level' => '',
	'user' => array(),
	'custom_items' => null,
	'gtm_user_type' => 'unassigned',
	'activeUser' => null,
	'cart' => null,
	'use_brand_subs' => false
)
$allow_terms = false
$brand_buyer_discounts = array()
$seller = array(
	'User' => array(
		'password' => '*****',
		'id' => '437',
		'role_id' => '10',
		'seller_id' => null,
		'email' => 'nate@drinkwaterloo.com',
		'first_name' => 'Nate ',
		'middle_name' => null,
		'last_name' => 'Bernstein',
		'phone_number' => null,
		'fax_number' => null,
		'cell_number' => '7272524574',
		'title' => 'VP Alternate Channels',
		'website' => null,
		'avatar' => null,
		'profile_pic' => null,
		'token' => null,
		'token_issued' => null,
		'brand_subscription' => null,
		'subscription_plan_id' => null,
		'subscription_start_date' => null,
		'free_trial' => false,
		'is_active' => true,
		'status' => '2',
		'status_reason' => null,
		'status_date' => null,
		'status_submitted_by' => null,
		'last_login' => '2021-07-08 14:29:34',
		'created' => '2020-09-30 14:57:43',
		'modified' => '2022-04-08 04:00:02',
		'user_type_id' => '3',
		'brand_id' => null,
		'super_brand_id' => null,
		'stripe_token' => null,
		'stripe_user_id' => null,
		'stripe_sub_id' => null,
		'wire_only' => null,
		'accepted_tos' => true,
		'tos_path' => null,
		'tos_date' => null,
		'grovara_signed_tos' => null,
		'tos_hash' => null,
		'qb_id' => '3734',
		'2fa_key' => null,
		'2fa_status' => null,
		'hubspot_id' => '396001',
		'hubspot_association' => true,
		'accounting_contact' => false,
		'transfermate_id' => null,
		'full_name' => 'Nate  Bernstein',
		'company_name' => '',
		'country_code' => '',
		'city' => '',
		'profile_status_id' => '',
		'has_ordered' => '',
		'email_lower' => 'nate@drinkwaterloo.com'
	)
)
$brand = array(
	'Brand' => array(
		'id' => '56',
		'name' => 'Waterloo ',
		'slug' => 'waterloo-',
		'logo' => 'WL_logo-MAIN_1 (2).png',
		'main_banner' => 'Banner_1134.124_1.png',
		'sub_banner_1' => null,
		'sub_banner_2' => null,
		'sub_banner_3' => null,
		'sub_banner_4' => null,
		'website' => 'https://www.drinkwaterloo.com/',
		'facebook' => 'https://www.facebook.com/waterloosparkling',
		'pinterest' => '',
		'twitter' => 'https://twitter.com/DoYouWaterloo',
		'instagram' => 'https://www.instagram.com/waterloosparkling/',
		'youtube' => '',
		'promo_video' => '',
		'promo_video_1' => '',
		'promo_video_2' => '',
		'about' => 'All Waterloo’s natural flavor ingredients are derived from non-GMO, vegan sources. Oils, extracts, or essences from the named fruit (or fruits) on each variety are paired with complementary flavors to build our unique, bold taste profile. Using these powerful extracts and oils allows us to pack a lot of flavor without any sugar, sweeteners, or other unwanted additives.',
		'grovara_comments' => 'Grovara can not pursue international Costcos. ',
		'policies' => '',
		'policies_modified' => '2021-06-22 11:57:31',
		'payment' => '',
		'spins_metric_type_1' => 'Sales',
		'spins_title_description_1' => 'YOY',
		'spins_metric_1' => '$112.3M',
		'spins_channel_1' => 'Natural & Organic',
		'spins_channel_subtext_1' => '',
		'spins_metric_type_2' => 'Growth Dollars',
		'spins_title_description_2' => 'YOY',
		'spins_metric_2' => '49%',
		'spins_channel_2' => 'Natural & Organic',
		'spins_channel_subtext_2' => '',
		'spins_scorecard' => null,
		'promoted_products' => '',
		'active' => true,
		'samples_allowed' => true,
		'product_sort' => '["200060","200040","200600","200760","200250","200260","200070","200130","200570","200200","200110","200700","200730","200210","200140","201100","201030","200580","G020969","202070","202060","202100","202090"]',
		'meta_title' => 'Waterloo ',
		'meta_description' => 'All Waterloo’s natural flavor ingredients are derived from non-GMO, vegan sources. Oils, extracts, or essences from the named fruit (or fruits) on each variety are paired with complementary flavors to build our unique, bold taste profile. Using these powerful extracts and oils allows us to pack a lot of flavor without any sugar, sweeteners, or other unwanted additives.',
		'created' => '2020-09-30 14:57:43',
		'modified' => '2023-03-13 12:31:54',
		'spins_metric_3' => '#32',
		'spins_metric_type_3' => 'Out of 945',
		'spins_title_description_3' => 'YOY',
		'spins_channel_3' => 'Shelf Stable Water',
		'spins_channel_subtext_3' => '',
		'brochure_1' => 'Waterloo_Presentation_7_28_2021.pdf',
		'brochure_2' => 'Waterloo2022BrandOverview081022.pptx',
		'brochure_3' => '',
		'mkt_support' => false,
		'mkt_support_text' => '',
		'bracket_pricing_1' => null,
		'bracket_pricing_2' => null,
		'offers_terms' => 'yes',
		'offers_terms_text' => '',
		'allow_pallet_height_70' => false,
		'brand_country' => 'US'
	),
	'BrandFaq' => array(
		(int) 0 => array(
			'id' => '91',
			'brand_id' => '56',
			'question' => 'What’s the best way to drink Waterloo?',
			'answer' => 'Enjoy ice-cold! Our flavor team crafted Waterloo to be served chilled, so we recommend refrigerating before popping the tab. It will be worth the wait!'
		),
		(int) 1 => array(
			'id' => '92',
			'brand_id' => '56',
			'question' => 'What are Waterloo’s natural flavors?',
			'answer' => 'All Waterloo’s natural flavor ingredients are derived from non-GMO, vegan sources. Oils, extracts, or essences from the named fruit (or fruits) on each variety are paired with complementary flavors to build our unique, bold taste profile.'
		),
		(int) 2 => array(
			'id' => '93',
			'brand_id' => '56',
			'question' => 'Is Waterloo made with purified water?',
			'answer' => 'Before carbonation and canning, our water undergoes a multi-step filtration process to ensure a pure product for you. Our water is free of fluoride, sodium, and other additives/impurities before we add our flavors and carbonate.'
		)
	)
)
$products = array(
	(int) 0 => array(
		'Product' => array(
			'id' => '13622',
			'parent_id' => '0',
			'seller_id' => '437',
			'ix_one_id' => null,
			'sku' => '200060',
			'item_upc' => '819215020051',
			'case_upc' => '10819215020263',
			'pop_box_upc' => '819215020266',
			'name' => 'Waterloo Black Cherry Sparkling Water',
			'description' => 'Pure essence of fresh muddled cherries. Rich, crisp taste that brightens the taste buds with perfect balance of sweet and tart and a finish that does not linger.',
			'about' => '',
			'legal_disclaimer' => 'no_data',
			'category_id' => '1',
			'sub_category_id' => '2',
			'group' => '14',
			'ingredients' => null,
			'best_use' => '',
			'nutrition_info' => '/files/products/images/56/waterloo_200060_nutrition.png',
			'primary_image' => '/files/products/images/56/waterloo_200060_primary.png',
			'secondary_image' => '/files/products/images/56/waterloo_200060_secondary.png',
			'innerpack_nutrition' => null,
			'ingredients_innerpack' => null,
			'ingredients_unit' => null,
			'flavor' => 'Black Cherry',
			'unit_cost' => null,
			'lowest_case_cost' => '0.00',
			'case_cost' => '7.00',
			'unit_price' => '0.34',
			'case_price' => '8.24',
			'suggested_retail_price' => '0.00',
			'product_label' => '/files/products/images/56/waterloo_200060_label.png',
			'product_ingredients' => '',
			'specifications' => '',
			'certificate_of_analysis' => null,
			'qty_per_case' => '2',
			'size' => '144',
			'size_uom' => 'fluid ounces',
			'retail_unit_size' => '12.00',
			'innerpack' => true,
			'unit_length' => '2.60',
			'unit_width' => '2.60',
			'unit_height' => '4.84',
			'unit_dimension_uom' => 'inches',
			'unit_weight' => '0.82',
			'unit_weight_uom' => 'pounds',
			'unit_package_type' => 'Can',
			'unit_package_material' => null,
			'case_length' => '15.67',
			'case_width' => '10.55',
			'case_height' => '4.88',
			'case_dimension_uom' => 'inches',
			'case_weight' => '19.60',
			'case_weight_uom' => 'pounds',
			'case_cubic_feet' => '0.47',
			'pallet_ti' => '10.00',
			'case_package_type' => 'CORRUGATE',
			'case_innerpack_count' => null,
			'qty_per_innerpack' => null,
			'case_package_material' => null,
			'pallet_hi' => '10.00',
			'pallet_cases_per_layer' => '0.00',
			'pallet_weight' => '2000.00',
			'pallet_weight_uom' => 'pounds',
			'pallet_height' => '54.40',
			'pallet_dimension_uom' => 'inches',
			'pallet_cubic_feet' => '60',
			'pallet_package_type' => 'Wood',
			'container_20' => '10',
			'container_40' => '20',
			'shipment_lead_time' => null,
			'shelf_life' => '365',
			'shelf_life_pickup' => '180',
			'shipping_storeage_id' => '1',
			'storage_requirement' => 'Ambient',
			'hts' => '2202.10.0060',
			'date_code' => '',
			'item_ordering' => '0',
			'min_total_order' => '0',
			'size_variations' => '',
			'claim_dairy_free' => 'no',
			'claim_fair_trade' => 'no',
			'claim_gluten_free' => 'yes',
			'claim_grain_free' => 'no',
			'claim_halai' => 'no',
			'claim_ketogenic' => 'no',
			'claim_kosher' => 'yes',
			'claim_low_carb' => 'no',
			'claim_non_gmo' => 'yes',
			'claim_non_gmo_verified' => null,
			'claim_nut_free' => 'no',
			'claim_organic' => 'no',
			'claim_paleo' => 'no',
			'claim_plant_based' => 'no',
			'organic_certifier' => 'no',
			'claim_vegan' => 'yes',
			'claim_vegetarian' => 'no',
			'claim_wheat_free' => null,
			'allergens' => null,
			'allergens_ancillary' => null,
			'code_date_example' => null,
			'contains' => null,
			'does_not_contain' => null,
			'product_of' => null,
			'country_of_origin' => null,
			'status' => 'Active',
			'incoterms_id' => '1',
			'shipping_provider_id' => null,
			'brand_id' => '56',
			'ix_one_created' => null,
			'ix_one_modified' => null,
			'spins_group' => null,
			'spins_category' => null,
			'spins_subcategory' => null,
			'ecommerce_name_a' => null,
			'item_romance_description' => null,
			'out_of_stock' => false,
			'temperature_min' => '33.00',
			'temperature_max' => '75.00',
			'temperature_uom' => 'Fahrenheit',
			'created' => '2023-02-09 07:50:06',
			'modified' => '2023-02-09 07:50:06',
			'slug' => 'waterloo-black-cherry-sparkling-water-200060',
			'meta_title' => 'Waterloo Black Cherry Sparkling Water - 200060',
			'meta_description' => 'Pure essence of fresh muddled cherries. Rich, crisp taste that brightens the taste buds with perfect balance of sweet and tart and a finish that does not linger.',
			'public' => true,
			'featured' => false,
			'best_selling_product' => 'yes',
			'mfg_state' => '',
			'innerpack_qty' => '12',
			'total_units_per_master_case' => '24',
			'product_type' => 'Retail',
			'private_label' => 'No',
			'expected_date_in_stock' => null,
			'auto_in_stock' => false,
			'out_of_stock_date' => null,
			'out_of_stock_reason' => null,
			'made_in' => 'US',
			'list_case_price' => '8.24',
			'brand_name' => 'Waterloo ',
			'pallet_only' => '1',
			'samples_allowed' => '1',
			'us_brand' => '1',
			'brand_country' => 'US',
			'made_in_country' => 'United States of America',
			'profile_and_user_approved' => '1',
			'search_relevance' => '100',
			'metric_name' => 'Waterloo Black Cherry Sparkling Water 2 innerpacks per case 4259 mL',
			'standard_name' => 'Waterloo Black Cherry Sparkling Water 2 innerpacks per case 144.0 fl',
			'metric_name_short' => 'Waterloo Black Cherry Sparkling Water 2 innerpacks per case',
			'standard_name_short' => 'Waterloo Black Cherry Sparkling Water 2 innerpacks per case',
			'standard_size' => '144.0',
			'metric_size' => '4259',
			'standard_size_uom' => 'fluid ounces',
			'metric_size_uom' => 'milliliters',
			'standard_unit_weight' => '0.9',
			'metric_unit_weight' => '1',
			'standard_unit_weight_uom' => 'pounds',
			'metric_unit_weight_uom' => 'kilograms',
			'standard_case_weight' => '19.7',
			'metric_case_weight' => '9',
			'standard_case_weight_uom' => 'pounds',
			'metric_case_weight_uom' => 'kilograms',
			'standard_pallet_weight' => '2000.0',
			'metric_pallet_weight' => '908',
			'standard_pallet_weight_uom' => 'pounds',
			'metric_pallet_weight_uom' => 'kilograms',
			'standard_unit_dimensions' => '2.6in(L)x2.6in(W)x4.9in(H)',
			'standard_unit_length' => '2.6',
			'standard_unit_width' => '2.6',
			'standard_unit_height' => '4.9',
			'standard_unit_dimension_uom' => 'inches',
			'metric_unit_dimensions' => '7cm(L)x7cm(W)x13cm(H)',
			'metric_unit_length' => '7',
			'metric_unit_width' => '7',
			'metric_unit_height' => '13',
			'metric_unit_dimension_uom' => 'cm',
			'standard_case_dimensions' => '15.7in(L)x10.6in(W)x4.9in(H)',
			'standard_case_length' => '15.7',
			'standard_case_width' => '10.6',
			'standard_case_height' => '4.9',
			'standard_case_dimension_uom' => 'in',
			'standard_pallet_height' => '54.5',
			'standard_pallet_dimension_uom' => 'in',
			'metric_case_dimensions' => '40cm(L)x27cm(W)x13cm(H)',
			'metric_case_length' => '40',
			'metric_case_width' => '27',
			'metric_case_height' => '13',
			'metric_case_dimension_uom' => 'cm',
			'metric_pallet_height' => '139',
			'metric_pallet_dimension_uom' => 'cm',
			'metric_temperature_min' => '1',
			'metric_temperature_max' => '24',
			'metric_temperature_uom' => 'Celsius',
			'standard_temperature_min' => '33.00',
			'standard_temperature_max' => '75.00',
			'standard_temperature_uom' => 'Fahrenheit'
		),
		'ParentProduct' => array(
			'id' => null,
			'parent_id' => null,
			'seller_id' => null,
			'ix_one_id' => null,
			'sku' => null,
			'item_upc' => null,
			'case_upc' => null,
			'pop_box_upc' => null,
			'name' => null,
			'description' => null,
			'about' => null,
			'legal_disclaimer' => null,
			'category_id' => null,
			'sub_category_id' => null,
			'group' => null,
			'ingredients' => null,
			'best_use' => null,
			'nutrition_info' => null,
			'primary_image' => null,
			'secondary_image' => null,
			'innerpack_nutrition' => null,
			'ingredients_innerpack' => null,
			'ingredients_unit' => null,
			'flavor' => null,
			'unit_cost' => null,
			'lowest_case_cost' => null,
			'case_cost' => null,
			'unit_price' => null,
			'case_price' => null,
			'suggested_retail_price' => null,
			'product_label' => null,
			'product_ingredients' => null,
			'specifications' => null,
			'certificate_of_analysis' => null,
			'qty_per_case' => null,
			'size' => null,
			'size_uom' => null,
			'retail_unit_size' => null,
			'innerpack' => null,
			'unit_length' => null,
			'unit_width' => null,
			'unit_height' => null,
			'unit_dimension_uom' => null,
			'unit_weight' => null,
			'unit_weight_uom' => null,
			'unit_package_type' => null,
			'unit_package_material' => null,
			'case_length' => null,
			'case_width' => null,
			'case_height' => null,
			'case_dimension_uom' => null,
			'case_weight' => null,
			'case_weight_uom' => null,
			'case_cubic_feet' => null,
			'pallet_ti' => null,
			'case_package_type' => null,
			'case_innerpack_count' => null,
			'qty_per_innerpack' => null,
			'case_package_material' => null,
			'pallet_hi' => null,
			'pallet_cases_per_layer' => null,
			'pallet_weight' => null,
			'pallet_weight_uom' => null,
			'pallet_height' => null,
			'pallet_dimension_uom' => null,
			'pallet_cubic_feet' => null,
			'pallet_package_type' => null,
			'container_20' => null,
			'container_40' => null,
			'shipment_lead_time' => null,
			'shelf_life' => null,
			'shelf_life_pickup' => null,
			'shipping_storeage_id' => null,
			'storage_requirement' => null,
			'hts' => null,
			'date_code' => null,
			'item_ordering' => null,
			'min_total_order' => null,
			'size_variations' => null,
			'claim_dairy_free' => null,
			'claim_fair_trade' => null,
			'claim_gluten_free' => null,
			'claim_grain_free' => null,
			'claim_halai' => null,
			'claim_ketogenic' => null,
			'claim_kosher' => null,
			'claim_low_carb' => null,
			'claim_non_gmo' => null,
			'claim_non_gmo_verified' => null,
			'claim_nut_free' => null,
			'claim_organic' => null,
			'claim_paleo' => null,
			'claim_plant_based' => null,
			'organic_certifier' => null,
			'claim_vegan' => null,
			'claim_vegetarian' => null,
			'claim_wheat_free' => null,
			'allergens' => null,
			'allergens_ancillary' => null,
			'code_date_example' => null,
			'contains' => null,
			'does_not_contain' => null,
			'product_of' => null,
			'country_of_origin' => null,
			'status' => null,
			'incoterms_id' => null,
			'shipping_provider_id' => null,
			'brand_id' => null,
			'ix_one_created' => null,
			'ix_one_modified' => null,
			'spins_group' => null,
			'spins_category' => null,
			'spins_subcategory' => null,
			'ecommerce_name_a' => null,
			'item_romance_description' => null,
			'out_of_stock' => null,
			'temperature_min' => null,
			'temperature_max' => null,
			'temperature_uom' => null,
			'created' => null,
			'modified' => null,
			'slug' => null,
			'meta_title' => null,
			'meta_description' => null,
			'public' => null,
			'featured' => null,
			'best_selling_product' => null,
			'mfg_state' => null,
			'innerpack_qty' => null,
			'total_units_per_master_case' => null,
			'product_type' => null,
			'private_label' => null,
			'expected_date_in_stock' => null,
			'auto_in_stock' => null,
			'out_of_stock_date' => null,
			'out_of_stock_reason' => null,
			'made_in' => null,
			'list_case_price' => null,
			'brand_name' => null,
			'pallet_only' => null,
			'samples_allowed' => null,
			'us_brand' => null,
			'brand_country' => null,
			'made_in_country' => null,
			'profile_and_user_approved' => '0',
			'search_relevance' => '100',
			'metric_name' => null,
			'standard_name' => null,
			'metric_name_short' => null,
			'standard_name_short' => null,
			'standard_size' => null,
			'metric_size' => null,
			'standard_size_uom' => null,
			'metric_size_uom' => null,
			'standard_unit_weight' => null,
			'metric_unit_weight' => null,
			'standard_unit_weight_uom' => null,
			'metric_unit_weight_uom' => null,
			'standard_case_weight' => null,
			'metric_case_weight' => null,
			'standard_case_weight_uom' => null,
			'metric_case_weight_uom' => null,
			'standard_pallet_weight' => null,
			'metric_pallet_weight' => null,
			'standard_pallet_weight_uom' => null,
			'metric_pallet_weight_uom' => null,
			'standard_unit_dimensions' => null,
			'standard_unit_length' => null,
			'standard_unit_width' => null,
			'standard_unit_height' => null,
			'standard_unit_dimension_uom' => null,
			'metric_unit_dimensions' => null,
			'metric_unit_length' => null,
			'metric_unit_width' => null,
			'metric_unit_height' => null,
			'metric_unit_dimension_uom' => null,
			'standard_case_dimensions' => null,
			'standard_case_length' => null,
			'standard_case_width' => null,
			'standard_case_height' => null,
			'standard_case_dimension_uom' => null,
			'standard_pallet_height' => null,
			'standard_pallet_dimension_uom' => null,
			'metric_case_dimensions' => null,
			'metric_case_length' => null,
			'metric_case_width' => null,
			'metric_case_height' => null,
			'metric_case_dimension_uom' => null,
			'metric_pallet_height' => null,
			'metric_pallet_dimension_uom' => null,
			'metric_temperature_min' => null,
			'metric_temperature_max' => null,
			'metric_temperature_uom' => 'Celsius',
			'standard_temperature_min' => null,
			'standard_temperature_max' => null,
			'standard_temperature_uom' => 'Fahrenheit'
		),
		'Category' => array(
			'id' => '1',
			'parent_id' => null,
			'title' => 'Grocery & Gourmet Foods',
			'slug' => 'grocery_and_gourmet_foods',
			'description' => 'Grocery & Gourmet Foods',
			'icon' => 'mini-cart.svg',
			'icon_dir' => null,
			'cover' => 'cat_bg_grocery.png',
			'cover_dir' => null,
			'banner' => null,
			'is_public' => true,
			'sort' => null,
			'created' => '2018-09-07 14:43:28',
			'modified' => '2019-07-02 16:17:43'
		),
		'SubCategory' => array(
			'id' => '2',
			'parent_id' => '1',
			'title' => 'Beverages',
			'slug' => 'beverages',
			'description' => 'Beverages',
			'icon' => 'beverages.png',
			'icon_dir' => null,
			'cover' => 'beverages-hero.png',
			'cover_dir' => null,
			'banner' => null,
			'is_public' => true,
			'sort' => null,
			'created' => null,
			'modified' => '2019-08-28 09:07:46'
		),
		'ShippingStorage' => array(
			'id' => '1',
			'storage_location' => 'Ambient'
		),
		'Brand' => array(
			'id' => '56',
			'name' => 'Waterloo ',
			'slug' => 'waterloo-',
			'logo' => 'WL_logo-MAIN_1 (2).png',
			'main_banner' => 'Banner_1134.124_1.png',
			'sub_banner_1' => null,
			'sub_banner_2' => null,
			'sub_banner_3' => null,
			'sub_banner_4' => null,
			'website' => 'https://www.drinkwaterloo.com/',
			'facebook' => 'https://www.facebook.com/waterloosparkling',
			'pinterest' => '',
			'twitter' => 'https://twitter.com/DoYouWaterloo',
			'instagram' => 'https://www.instagram.com/waterloosparkling/',
			'youtube' => '',
			'promo_video' => '',
			'promo_video_1' => '',
			'promo_video_2' => '',
			'about' => 'All Waterloo’s natural flavor ingredients are derived from non-GMO, vegan sources. Oils, extracts, or essences from the named fruit (or fruits) on each variety are paired with complementary flavors to build our unique, bold taste profile. Using these powerful extracts and oils allows us to pack a lot of flavor without any sugar, sweeteners, or other unwanted additives.',
			'grovara_comments' => 'Grovara can not pursue international Costcos. ',
			'policies' => '',
			'policies_modified' => '2021-06-22 11:57:31',
			'payment' => '',
			'spins_metric_type_1' => 'Sales',
			'spins_title_description_1' => 'YOY',
			'spins_metric_1' => '$112.3M',
			'spins_channel_1' => 'Natural & Organic',
			'spins_channel_subtext_1' => '',
			'spins_metric_type_2' => 'Growth Dollars',
			'spins_title_description_2' => 'YOY',
			'spins_metric_2' => '49%',
			'spins_channel_2' => 'Natural & Organic',
			'spins_channel_subtext_2' => '',
			'spins_scorecard' => null,
			'promoted_products' => '',
			'active' => true,
			'samples_allowed' => true,
			'product_sort' => '["200060","200040","200600","200760","200250","200260","200070","200130","200570","200200","200110","200700","200730","200210","200140","201100","201030","200580","G020969","202070","202060","202100","202090"]',
			'meta_title' => 'Waterloo ',
			'meta_description' => 'All Waterloo’s natural flavor ingredients are derived from non-GMO, vegan sources. Oils, extracts, or essences from the named fruit (or fruits) on each variety are paired with complementary flavors to build our unique, bold taste profile. Using these powerful extracts and oils allows us to pack a lot of flavor without any sugar, sweeteners, or other unwanted additives.',
			'created' => '2020-09-30 14:57:43',
			'modified' => '2023-03-13 12:31:54',
			'spins_metric_3' => '#32',
			'spins_metric_type_3' => 'Out of 945',
			'spins_title_description_3' => 'YOY',
			'spins_channel_3' => 'Shelf Stable Water',
			'spins_channel_subtext_3' => '',
			'brochure_1' => 'Waterloo_Presentation_7_28_2021.pdf',
			'brochure_2' => 'Waterloo2022BrandOverview081022.pptx',
			'brochure_3' => '',
			'mkt_support' => false,
			'mkt_support_text' => '',
			'bracket_pricing_1' => null,
			'bracket_pricing_2' => null,
			'offers_terms' => 'yes',
			'offers_terms_text' => '',
			'allow_pallet_height_70' => false,
			'brand_country' => 'US'
		),
		'ProductCategory' => array(),
		'ProductImage' => array(),
		'ChildProduct' => array(),
		'MerchPalletProduct' => array(),
		'NotifyInStock' => array()
	),
	(int) 1 => array(
		'Product' => array(
			'id' => '13623',
			'parent_id' => '0',
			'seller_id' => '437',
			'ix_one_id' => null,
			'sku' => '200040',
			'item_upc' => '819215020037',
			'case_upc' => '10819215020287',
			'pop_box_upc' => '819215020280',
			'name' => 'Waterloo Lemon-Lime Sparkling Water',
			'description' => 'Refreshing zest of lemon-lime. Zesty complex of lime and lemon flavors; short but prevalent bright citrus finish.',
			'about' => '',
			'legal_disclaimer' => 'no_data',
			'category_id' => '1',
			'sub_category_id' => '2',
			'group' => '14',
			'ingredients' => null,
			'best_use' => '',
			'nutrition_info' => '/files/products/images/56/waterloo_200040_nutrition.png',
			'primary_image' => '/files/products/images/56/waterloo_200040_primary.png',
			'secondary_image' => '/files/products/images/56/waterloo_200040_secondary.png',
			'innerpack_nutrition' => null,
			'ingredients_innerpack' => null,
			'ingredients_unit' => null,
			'flavor' => 'Lemon-Lime',
			'unit_cost' => null,
			'lowest_case_cost' => '0.00',
			'case_cost' => '7.00',
			'unit_price' => '0.34',
			'case_price' => '8.24',
			'suggested_retail_price' => '0.00',
			'product_label' => '/files/products/images/56/waterloo_200040_label.png',
			'product_ingredients' => '',
			'specifications' => '',
			'certificate_of_analysis' => null,
			'qty_per_case' => '2',
			'size' => '144',
			'size_uom' => 'fluid ounces',
			'retail_unit_size' => '12.00',
			'innerpack' => true,
			'unit_length' => '2.60',
			'unit_width' => '2.60',
			'unit_height' => '4.84',
			'unit_dimension_uom' => 'inches',
			'unit_weight' => '0.82',
			'unit_weight_uom' => 'pounds',
			'unit_package_type' => 'Can',
			'unit_package_material' => null,
			'case_length' => '15.67',
			'case_width' => '10.55',
			'case_height' => '4.88',
			'case_dimension_uom' => 'inches',
			'case_weight' => '19.60',
			'case_weight_uom' => 'pounds',
			'case_cubic_feet' => '0.47',
			'pallet_ti' => '10.00',
			'case_package_type' => 'CORRUGATE',
			'case_innerpack_count' => null,
			'qty_per_innerpack' => null,
			'case_package_material' => null,
			'pallet_hi' => '10.00',
			'pallet_cases_per_layer' => '0.00',
			'pallet_weight' => '2000.00',
			'pallet_weight_uom' => 'pounds',
			'pallet_height' => '54.40',
			'pallet_dimension_uom' => 'inches',
			'pallet_cubic_feet' => '60',
			'pallet_package_type' => 'Wood',
			'container_20' => '10',
			'container_40' => '20',
			'shipment_lead_time' => null,
			'shelf_life' => '365',
			'shelf_life_pickup' => '180',
			'shipping_storeage_id' => '1',
			'storage_requirement' => 'Ambient',
			'hts' => '2202.10.0060',
			'date_code' => '',
			'item_ordering' => '0',
			'min_total_order' => '0',
			'size_variations' => '',
			'claim_dairy_free' => 'no',
			'claim_fair_trade' => 'no',
			'claim_gluten_free' => 'yes',
			'claim_grain_free' => 'no',
			'claim_halai' => 'no',
			'claim_ketogenic' => 'no',
			'claim_kosher' => 'yes',
			'claim_low_carb' => 'no',
			'claim_non_gmo' => 'yes',
			'claim_non_gmo_verified' => null,
			'claim_nut_free' => 'no',
			'claim_organic' => 'no',
			'claim_paleo' => 'no',
			'claim_plant_based' => 'no',
			'organic_certifier' => 'no',
			'claim_vegan' => 'yes',
			'claim_vegetarian' => 'no',
			'claim_wheat_free' => null,
			'allergens' => null,
			'allergens_ancillary' => null,
			'code_date_example' => null,
			'contains' => null,
			'does_not_contain' => null,
			'product_of' => null,
			'country_of_origin' => null,
			'status' => 'Active',
			'incoterms_id' => '1',
			'shipping_provider_id' => null,
			'brand_id' => '56',
			'ix_one_created' => null,
			'ix_one_modified' => null,
			'spins_group' => null,
			'spins_category' => null,
			'spins_subcategory' => null,
			'ecommerce_name_a' => null,
			'item_romance_description' => null,
			'out_of_stock' => false,
			'temperature_min' => '33.00',
			'temperature_max' => '75.00',
			'temperature_uom' => 'Fahrenheit',
			'created' => '2023-02-09 07:50:06',
			'modified' => '2023-02-09 07:50:06',
			'slug' => 'waterloo-lemon-lime-sparkling-water-200040',
			'meta_title' => 'Waterloo Lemon-Lime Sparkling Water - 200040',
			'meta_description' => 'Refreshing zest of lemon-lime. Zesty complex of lime and lemon flavors; short but prevalent bright citrus finish.',
			'public' => true,
			'featured' => false,
			'best_selling_product' => 'yes',
			'mfg_state' => '',
			'innerpack_qty' => '12',
			'total_units_per_master_case' => '24',
			'product_type' => 'Retail',
			'private_label' => 'No',
			'expected_date_in_stock' => null,
			'auto_in_stock' => false,
			'out_of_stock_date' => null,
			'out_of_stock_reason' => null,
			'made_in' => 'US',
			'list_case_price' => '8.24',
			'brand_name' => 'Waterloo ',
			'pallet_only' => '1',
			'samples_allowed' => '1',
			'us_brand' => '1',
			'brand_country' => 'US',
			'made_in_country' => 'United States of America',
			'profile_and_user_approved' => '1',
			'search_relevance' => '100',
			'metric_name' => 'Waterloo Lemon-Lime Sparkling Water 2 innerpacks per case 4259 mL',
			'standard_name' => 'Waterloo Lemon-Lime Sparkling Water 2 innerpacks per case 144.0 fl',
			'metric_name_short' => 'Waterloo Lemon-Lime Sparkling Water 2 innerpacks per case',
			'standard_name_short' => 'Waterloo Lemon-Lime Sparkling Water 2 innerpacks per case',
			'standard_size' => '144.0',
			'metric_size' => '4259',
			'standard_size_uom' => 'fluid ounces',
			'metric_size_uom' => 'milliliters',
			'standard_unit_weight' => '0.9',
			'metric_unit_weight' => '1',
			'standard_unit_weight_uom' => 'pounds',
			'metric_unit_weight_uom' => 'kilograms',
			'standard_case_weight' => '19.7',
			'metric_case_weight' => '9',
			'standard_case_weight_uom' => 'pounds',
			'metric_case_weight_uom' => 'kilograms',
			'standard_pallet_weight' => '2000.0',
			'metric_pallet_weight' => '908',
			'standard_pallet_weight_uom' => 'pounds',
			'metric_pallet_weight_uom' => 'kilograms',
			'standard_unit_dimensions' => '2.6in(L)x2.6in(W)x4.9in(H)',
			'standard_unit_length' => '2.6',
			'standard_unit_width' => '2.6',
			'standard_unit_height' => '4.9',
			'standard_unit_dimension_uom' => 'inches',
			'metric_unit_dimensions' => '7cm(L)x7cm(W)x13cm(H)',
			'metric_unit_length' => '7',
			'metric_unit_width' => '7',
			'metric_unit_height' => '13',
			'metric_unit_dimension_uom' => 'cm',
			'standard_case_dimensions' => '15.7in(L)x10.6in(W)x4.9in(H)',
			'standard_case_length' => '15.7',
			'standard_case_width' => '10.6',
			'standard_case_height' => '4.9',
			'standard_case_dimension_uom' => 'in',
			'standard_pallet_height' => '54.5',
			'standard_pallet_dimension_uom' => 'in',
			'metric_case_dimensions' => '40cm(L)x27cm(W)x13cm(H)',
			'metric_case_length' => '40',
			'metric_case_width' => '27',
			'metric_case_height' => '13',
			'metric_case_dimension_uom' => 'cm',
			'metric_pallet_height' => '139',
			'metric_pallet_dimension_uom' => 'cm',
			'metric_temperature_min' => '1',
			'metric_temperature_max' => '24',
			'metric_temperature_uom' => 'Celsius',
			'standard_temperature_min' => '33.00',
			'standard_temperature_max' => '75.00',
			'standard_temperature_uom' => 'Fahrenheit'
		),
		'ParentProduct' => array(
			'id' => null,
			'parent_id' => null,
			'seller_id' => null,
			'ix_one_id' => null,
			'sku' => null,
			'item_upc' => null,
			'case_upc' => null,
			'pop_box_upc' => null,
			'name' => null,
			'description' => null,
			'about' => null,
			'legal_disclaimer' => null,
			'category_id' => null,
			'sub_category_id' => null,
			'group' => null,
			'ingredients' => null,
			'best_use' => null,
			'nutrition_info' => null,
			'primary_image' => null,
			'secondary_image' => null,
			'innerpack_nutrition' => null,
			'ingredients_innerpack' => null,
			'ingredients_unit' => null,
			'flavor' => null,
			'unit_cost' => null,
			'lowest_case_cost' => null,
			'case_cost' => null,
			'unit_price' => null,
			'case_price' => null,
			'suggested_retail_price' => null,
			'product_label' => null,
			'product_ingredients' => null,
			'specifications' => null,
			'certificate_of_analysis' => null,
			'qty_per_case' => null,
			'size' => null,
			'size_uom' => null,
			'retail_unit_size' => null,
			'innerpack' => null,
			'unit_length' => null,
			'unit_width' => null,
			'unit_height' => null,
			'unit_dimension_uom' => null,
			'unit_weight' => null,
			'unit_weight_uom' => null,
			'unit_package_type' => null,
			'unit_package_material' => null,
			'case_length' => null,
			'case_width' => null,
			'case_height' => null,
			'case_dimension_uom' => null,
			'case_weight' => null,
			'case_weight_uom' => null,
			'case_cubic_feet' => null,
			'pallet_ti' => null,
			'case_package_type' => null,
			'case_innerpack_count' => null,
			'qty_per_innerpack' => null,
			'case_package_material' => null,
			'pallet_hi' => null,
			'pallet_cases_per_layer' => null,
			'pallet_weight' => null,
			'pallet_weight_uom' => null,
			'pallet_height' => null,
			'pallet_dimension_uom' => null,
			'pallet_cubic_feet' => null,
			'pallet_package_type' => null,
			'container_20' => null,
			'container_40' => null,
			'shipment_lead_time' => null,
			'shelf_life' => null,
			'shelf_life_pickup' => null,
			'shipping_storeage_id' => null,
			'storage_requirement' => null,
			'hts' => null,
			'date_code' => null,
			'item_ordering' => null,
			'min_total_order' => null,
			'size_variations' => null,
			'claim_dairy_free' => null,
			'claim_fair_trade' => null,
			'claim_gluten_free' => null,
			'claim_grain_free' => null,
			'claim_halai' => null,
			'claim_ketogenic' => null,
			'claim_kosher' => null,
			'claim_low_carb' => null,
			'claim_non_gmo' => null,
			'claim_non_gmo_verified' => null,
			'claim_nut_free' => null,
			'claim_organic' => null,
			'claim_paleo' => null,
			'claim_plant_based' => null,
			'organic_certifier' => null,
			'claim_vegan' => null,
			'claim_vegetarian' => null,
			'claim_wheat_free' => null,
			'allergens' => null,
			'allergens_ancillary' => null,
			'code_date_example' => null,
			'contains' => null,
			'does_not_contain' => null,
			'product_of' => null,
			'country_of_origin' => null,
			'status' => null,
			'incoterms_id' => null,
			'shipping_provider_id' => null,
			'brand_id' => null,
			'ix_one_created' => null,
			'ix_one_modified' => null,
			'spins_group' => null,
			'spins_category' => null,
			'spins_subcategory' => null,
			'ecommerce_name_a' => null,
			'item_romance_description' => null,
			'out_of_stock' => null,
			'temperature_min' => null,
			'temperature_max' => null,
			'temperature_uom' => null,
			'created' => null,
			'modified' => null,
			'slug' => null,
			'meta_title' => null,
			'meta_description' => null,
			'public' => null,
			'featured' => null,
			'best_selling_product' => null,
			'mfg_state' => null,
			'innerpack_qty' => null,
			'total_units_per_master_case' => null,
			'product_type' => null,
			'private_label' => null,
			'expected_date_in_stock' => null,
			'auto_in_stock' => null,
			'out_of_stock_date' => null,
			'out_of_stock_reason' => null,
			'made_in' => null,
			'list_case_price' => null,
			'brand_name' => null,
			'pallet_only' => null,
			'samples_allowed' => null,
			'us_brand' => null,
			'brand_country' => null,
			'made_in_country' => null,
			'profile_and_user_approved' => '0',
			'search_relevance' => '100',
			'metric_name' => null,
			'standard_name' => null,
			'metric_name_short' => null,
			'standard_name_short' => null,
			'standard_size' => null,
			'metric_size' => null,
			'standard_size_uom' => null,
			'metric_size_uom' => null,
			'standard_unit_weight' => null,
			'metric_unit_weight' => null,
			'standard_unit_weight_uom' => null,
			'metric_unit_weight_uom' => null,
			'standard_case_weight' => null,
			'metric_case_weight' => null,
			'standard_case_weight_uom' => null,
			'metric_case_weight_uom' => null,
			'standard_pallet_weight' => null,
			'metric_pallet_weight' => null,
			'standard_pallet_weight_uom' => null,
			'metric_pallet_weight_uom' => null,
			'standard_unit_dimensions' => null,
			'standard_unit_length' => null,
			'standard_unit_width' => null,
			'standard_unit_height' => null,
			'standard_unit_dimension_uom' => null,
			'metric_unit_dimensions' => null,
			'metric_unit_length' => null,
			'metric_unit_width' => null,
			'metric_unit_height' => null,
			'metric_unit_dimension_uom' => null,
			'standard_case_dimensions' => null,
			'standard_case_length' => null,
			'standard_case_width' => null,
			'standard_case_height' => null,
			'standard_case_dimension_uom' => null,
			'standard_pallet_height' => null,
			'standard_pallet_dimension_uom' => null,
			'metric_case_dimensions' => null,
			'metric_case_length' => null,
			'metric_case_width' => null,
			'metric_case_height' => null,
			'metric_case_dimension_uom' => null,
			'metric_pallet_height' => null,
			'metric_pallet_dimension_uom' => null,
			'metric_temperature_min' => null,
			'metric_temperature_max' => null,
			'metric_temperature_uom' => 'Celsius',
			'standard_temperature_min' => null,
			'standard_temperature_max' => null,
			'standard_temperature_uom' => 'Fahrenheit'
		),
		'Category' => array(
			'id' => '1',
			'parent_id' => null,
			'title' => 'Grocery & Gourmet Foods',
			'slug' => 'grocery_and_gourmet_foods',
			'description' => 'Grocery & Gourmet Foods',
			'icon' => 'mini-cart.svg',
			'icon_dir' => null,
			'cover' => 'cat_bg_grocery.png',
			'cover_dir' => null,
			'banner' => null,
			'is_public' => true,
			'sort' => null,
			'created' => '2018-09-07 14:43:28',
			'modified' => '2019-07-02 16:17:43'
		),
		'SubCategory' => array(
			'id' => '2',
			'parent_id' => '1',
			'title' => 'Beverages',
			'slug' => 'beverages',
			'description' => 'Beverages',
			'icon' => 'beverages.png',
			'icon_dir' => null,
			'cover' => 'beverages-hero.png',
			'cover_dir' => null,
			'banner' => null,
			'is_public' => true,
			'sort' => null,
			'created' => null,
			'modified' => '2019-08-28 09:07:46'
		),
		'ShippingStorage' => array(
			'id' => '1',
			'storage_location' => 'Ambient'
		),
		'Brand' => array(
			'id' => '56',
			'name' => 'Waterloo ',
			'slug' => 'waterloo-',
			'logo' => 'WL_logo-MAIN_1 (2).png',
			'main_banner' => 'Banner_1134.124_1.png',
			'sub_banner_1' => null,
			'sub_banner_2' => null,
			'sub_banner_3' => null,
			'sub_banner_4' => null,
			'website' => 'https://www.drinkwaterloo.com/',
			'facebook' => 'https://www.facebook.com/waterloosparkling',
			'pinterest' => '',
			'twitter' => 'https://twitter.com/DoYouWaterloo',
			'instagram' => 'https://www.instagram.com/waterloosparkling/',
			'youtube' => '',
			'promo_video' => '',
			'promo_video_1' => '',
			'promo_video_2' => '',
			'about' => 'All Waterloo’s natural flavor ingredients are derived from non-GMO, vegan sources. Oils, extracts, or essences from the named fruit (or fruits) on each variety are paired with complementary flavors to build our unique, bold taste profile. Using these powerful extracts and oils allows us to pack a lot of flavor without any sugar, sweeteners, or other unwanted additives.',
			'grovara_comments' => 'Grovara can not pursue international Costcos. ',
			'policies' => '',
			'policies_modified' => '2021-06-22 11:57:31',
			'payment' => '',
			'spins_metric_type_1' => 'Sales',
			'spins_title_description_1' => 'YOY',
			'spins_metric_1' => '$112.3M',
			'spins_channel_1' => 'Natural & Organic',
			'spins_channel_subtext_1' => '',
			'spins_metric_type_2' => 'Growth Dollars',
			'spins_title_description_2' => 'YOY',
			'spins_metric_2' => '49%',
			'spins_channel_2' => 'Natural & Organic',
			'spins_channel_subtext_2' => '',
			'spins_scorecard' => null,
			'promoted_products' => '',
			'active' => true,
			'samples_allowed' => true,
			'product_sort' => '["200060","200040","200600","200760","200250","200260","200070","200130","200570","200200","200110","200700","200730","200210","200140","201100","201030","200580","G020969","202070","202060","202100","202090"]',
			'meta_title' => 'Waterloo ',
			'meta_description' => 'All Waterloo’s natural flavor ingredients are derived from non-GMO, vegan sources. Oils, extracts, or essences from the named fruit (or fruits) on each variety are paired with complementary flavors to build our unique, bold taste profile. Using these powerful extracts and oils allows us to pack a lot of flavor without any sugar, sweeteners, or other unwanted additives.',
			'created' => '2020-09-30 14:57:43',
			'modified' => '2023-03-13 12:31:54',
			'spins_metric_3' => '#32',
			'spins_metric_type_3' => 'Out of 945',
			'spins_title_description_3' => 'YOY',
			'spins_channel_3' => 'Shelf Stable Water',
			'spins_channel_subtext_3' => '',
			'brochure_1' => 'Waterloo_Presentation_7_28_2021.pdf',
			'brochure_2' => 'Waterloo2022BrandOverview081022.pptx',
			'brochure_3' => '',
			'mkt_support' => false,
			'mkt_support_text' => '',
			'bracket_pricing_1' => null,
			'bracket_pricing_2' => null,
			'offers_terms' => 'yes',
			'offers_terms_text' => '',
			'allow_pallet_height_70' => false,
			'brand_country' => 'US'
		),
		'ProductCategory' => array(),
		'ProductImage' => array(),
		'ChildProduct' => array(),
		'MerchPalletProduct' => array(),
		'NotifyInStock' => array()
	),
	(int) 2 => array(
		'Product' => array(
			'id' => '13624',
			'parent_id' => '0',
			'seller_id' => '437',
			'ix_one_id' => null,
			'sku' => '200600',
			'item_upc' => '819215020099',
			'case_upc' => '10819215020225',
			'pop_box_upc' => '819215020228',
			'name' => 'Waterloo Peach Sparkling Water',
			'description' => 'Soft, ripe peaches. Sweet, ripe flavor that reminds you of a hot summer day with a freshly picked peach.',
			'about' => '',
			'legal_disclaimer' => 'no_data',
			'category_id' => '1',
			'sub_category_id' => '2',
			'group' => '14',
			'ingredients' => null,
			'best_use' => '',
			'nutrition_info' => '/files/products/images/56/waterloo_200600_nutrition.png',
			'primary_image' => '/files/products/images/56/waterloo_200600_primary.png',
			'secondary_image' => '/files/products/images/56/waterloo_200600_secondary.png',
			'innerpack_nutrition' => null,
			'ingredients_innerpack' => null,
			'ingredients_unit' => null,
			'flavor' => 'Peach',
			'unit_cost' => null,
			'lowest_case_cost' => '0.00',
			'case_cost' => '7.00',
			'unit_price' => '0.34',
			'case_price' => '8.24',
			'suggested_retail_price' => '0.00',
			'product_label' => '/files/products/images/56/waterloo_200600_label.png',
			'product_ingredients' => '',
			'specifications' => '',
			'certificate_of_analysis' => null,
			'qty_per_case' => '2',
			'size' => '144',
			'size_uom' => 'fluid ounces',
			'retail_unit_size' => '12.00',
			'innerpack' => true,
			'unit_length' => '2.60',
			'unit_width' => '2.60',
			'unit_height' => '4.84',
			'unit_dimension_uom' => 'inches',
			'unit_weight' => '0.82',
			'unit_weight_uom' => 'pounds',
			'unit_package_type' => 'Can',
			'unit_package_material' => null,
			'case_length' => '15.67',
			'case_width' => '10.55',
			'case_height' => '4.88',
			'case_dimension_uom' => 'inches',
			'case_weight' => '19.60',
			'case_weight_uom' => 'pounds',
			'case_cubic_feet' => '0.47',
			'pallet_ti' => '10.00',
			'case_package_type' => 'CORRUGATE',
			'case_innerpack_count' => null,
			'qty_per_innerpack' => null,
			'case_package_material' => null,
			'pallet_hi' => '10.00',
			'pallet_cases_per_layer' => '0.00',
			'pallet_weight' => '2000.00',
			'pallet_weight_uom' => 'pounds',
			'pallet_height' => '54.40',
			'pallet_dimension_uom' => 'inches',
			'pallet_cubic_feet' => '60',
			'pallet_package_type' => 'Wood',
			'container_20' => '10',
			'container_40' => '20',
			'shipment_lead_time' => null,
			'shelf_life' => '365',
			'shelf_life_pickup' => '180',
			'shipping_storeage_id' => '1',
			'storage_requirement' => 'Ambient',
			'hts' => '2202.10.0060',
			'date_code' => '',
			'item_ordering' => '0',
			'min_total_order' => '0',
			'size_variations' => '',
			'claim_dairy_free' => 'no',
			'claim_fair_trade' => 'no',
			'claim_gluten_free' => 'yes',
			'claim_grain_free' => 'no',
			'claim_halai' => 'no',
			'claim_ketogenic' => 'no',
			'claim_kosher' => 'yes',
			'claim_low_carb' => 'no',
			'claim_non_gmo' => 'yes',
			'claim_non_gmo_verified' => null,
			'claim_nut_free' => 'no',
			'claim_organic' => 'no',
			'claim_paleo' => 'no',
			'claim_plant_based' => 'no',
			'organic_certifier' => 'no',
			'claim_vegan' => 'yes',
			'claim_vegetarian' => 'no',
			'claim_wheat_free' => null,
			'allergens' => null,
			'allergens_ancillary' => null,
			'code_date_example' => null,
			'contains' => null,
			'does_not_contain' => null,
			'product_of' => null,
			'country_of_origin' => null,
			'status' => 'Active',
			'incoterms_id' => '1',
			'shipping_provider_id' => null,
			'brand_id' => '56',
			'ix_one_created' => null,
			'ix_one_modified' => null,
			'spins_group' => null,
			'spins_category' => null,
			'spins_subcategory' => null,
			'ecommerce_name_a' => null,
			'item_romance_description' => null,
			'out_of_stock' => false,
			'temperature_min' => '33.00',
			'temperature_max' => '75.00',
			'temperature_uom' => 'Fahrenheit',
			'created' => '2023-02-09 07:50:06',
			'modified' => '2023-02-09 07:50:06',
			'slug' => 'waterloo-peach-sparkling-water-200600',
			'meta_title' => 'Waterloo Peach Sparkling Water - 200600',
			'meta_description' => 'Soft, ripe peaches. Sweet, ripe flavor that reminds you of a hot summer day with a freshly picked peach.',
			'public' => true,
			'featured' => false,
			'best_selling_product' => 'yes',
			'mfg_state' => '',
			'innerpack_qty' => '12',
			'total_units_per_master_case' => '24',
			'product_type' => 'Retail',
			'private_label' => 'No',
			'expected_date_in_stock' => null,
			'auto_in_stock' => false,
			'out_of_stock_date' => null,
			'out_of_stock_reason' => null,
			'made_in' => 'US',
			'list_case_price' => '8.24',
			'brand_name' => 'Waterloo ',
			'pallet_only' => '1',
			'samples_allowed' => '1',
			'us_brand' => '1',
			'brand_country' => 'US',
			'made_in_country' => 'United States of America',
			'profile_and_user_approved' => '1',
			'search_relevance' => '100',
			'metric_name' => 'Waterloo Peach Sparkling Water 2 innerpacks per case 4259 mL',
			'standard_name' => 'Waterloo Peach Sparkling Water 2 innerpacks per case 144.0 fl',
			'metric_name_short' => 'Waterloo Peach Sparkling Water 2 innerpacks per case',
			'standard_name_short' => 'Waterloo Peach Sparkling Water 2 innerpacks per case',
			'standard_size' => '144.0',
			'metric_size' => '4259',
			'standard_size_uom' => 'fluid ounces',
			'metric_size_uom' => 'milliliters',
			'standard_unit_weight' => '0.9',
			'metric_unit_weight' => '1',
			'standard_unit_weight_uom' => 'pounds',
			'metric_unit_weight_uom' => 'kilograms',
			'standard_case_weight' => '19.7',
			'metric_case_weight' => '9',
			'standard_case_weight_uom' => 'pounds',
			'metric_case_weight_uom' => 'kilograms',
			'standard_pallet_weight' => '2000.0',
			'metric_pallet_weight' => '908',
			'standard_pallet_weight_uom' => 'pounds',
			'metric_pallet_weight_uom' => 'kilograms',
			'standard_unit_dimensions' => '2.6in(L)x2.6in(W)x4.9in(H)',
			'standard_unit_length' => '2.6',
			'standard_unit_width' => '2.6',
			'standard_unit_height' => '4.9',
			'standard_unit_dimension_uom' => 'inches',
			'metric_unit_dimensions' => '7cm(L)x7cm(W)x13cm(H)',
			'metric_unit_length' => '7',
			'metric_unit_width' => '7',
			'metric_unit_height' => '13',
			'metric_unit_dimension_uom' => 'cm',
			'standard_case_dimensions' => '15.7in(L)x10.6in(W)x4.9in(H)',
			'standard_case_length' => '15.7',
			'standard_case_width' => '10.6',
			'standard_case_height' => '4.9',
			'standard_case_dimension_uom' => 'in',
			'standard_pallet_height' => '54.5',
			'standard_pallet_dimension_uom' => 'in',
			'metric_case_dimensions' => '40cm(L)x27cm(W)x13cm(H)',
			'metric_case_length' => '40',
			'metric_case_width' => '27',
			'metric_case_height' => '13',
			'metric_case_dimension_uom' => 'cm',
			'metric_pallet_height' => '139',
			'metric_pallet_dimension_uom' => 'cm',
			'metric_temperature_min' => '1',
			'metric_temperature_max' => '24',
			'metric_temperature_uom' => 'Celsius',
			'standard_temperature_min' => '33.00',
			'standard_temperature_max' => '75.00',
			'standard_temperature_uom' => 'Fahrenheit'
		),
		'ParentProduct' => array(
			'id' => null,
			'parent_id' => null,
			'seller_id' => null,
			'ix_one_id' => null,
			'sku' => null,
			'item_upc' => null,
			'case_upc' => null,
			'pop_box_upc' => null,
			'name' => null,
			'description' => null,
			'about' => null,
			'legal_disclaimer' => null,
			'category_id' => null,
			'sub_category_id' => null,
			'group' => null,
			'ingredients' => null,
			'best_use' => null,
			'nutrition_info' => null,
			'primary_image' => null,
			'secondary_image' => null,
			'innerpack_nutrition' => null,
			'ingredients_innerpack' => null,
			'ingredients_unit' => null,
			'flavor' => null,
			'unit_cost' => null,
			'lowest_case_cost' => null,
			'case_cost' => null,
			'unit_price' => null,
			'case_price' => null,
			'suggested_retail_price' => null,
			'product_label' => null,
			'product_ingredients' => null,
			'specifications' => null,
			'certificate_of_analysis' => null,
			'qty_per_case' => null,
			'size' => null,
			'size_uom' => null,
			'retail_unit_size' => null,
			'innerpack' => null,
			'unit_length' => null,
			'unit_width' => null,
			'unit_height' => null,
			'unit_dimension_uom' => null,
			'unit_weight' => null,
			'unit_weight_uom' => null,
			'unit_package_type' => null,
			'unit_package_material' => null,
			'case_length' => null,
			'case_width' => null,
			'case_height' => null,
			'case_dimension_uom' => null,
			'case_weight' => null,
			'case_weight_uom' => null,
			'case_cubic_feet' => null,
			'pallet_ti' => null,
			'case_package_type' => null,
			'case_innerpack_count' => null,
			'qty_per_innerpack' => null,
			'case_package_material' => null,
			'pallet_hi' => null,
			'pallet_cases_per_layer' => null,
			'pallet_weight' => null,
			'pallet_weight_uom' => null,
			'pallet_height' => null,
			'pallet_dimension_uom' => null,
			'pallet_cubic_feet' => null,
			'pallet_package_type' => null,
			'container_20' => null,
			'container_40' => null,
			'shipment_lead_time' => null,
			'shelf_life' => null,
			'shelf_life_pickup' => null,
			'shipping_storeage_id' => null,
			'storage_requirement' => null,
			'hts' => null,
			'date_code' => null,
			'item_ordering' => null,
			'min_total_order' => null,
			'size_variations' => null,
			'claim_dairy_free' => null,
			'claim_fair_trade' => null,
			'claim_gluten_free' => null,
			'claim_grain_free' => null,
			'claim_halai' => null,
			'claim_ketogenic' => null,
			'claim_kosher' => null,
			'claim_low_carb' => null,
			'claim_non_gmo' => null,
			'claim_non_gmo_verified' => null,
			'claim_nut_free' => null,
			'claim_organic' => null,
			'claim_paleo' => null,
			'claim_plant_based' => null,
			'organic_certifier' => null,
			'claim_vegan' => null,
			'claim_vegetarian' => null,
			'claim_wheat_free' => null,
			'allergens' => null,
			'allergens_ancillary' => null,
			'code_date_example' => null,
			'contains' => null,
			'does_not_contain' => null,
			'product_of' => null,
			'country_of_origin' => null,
			'status' => null,
			'incoterms_id' => null,
			'shipping_provider_id' => null,
			'brand_id' => null,
			'ix_one_created' => null,
			'ix_one_modified' => null,
			'spins_group' => null,
			'spins_category' => null,
			'spins_subcategory' => null,
			'ecommerce_name_a' => null,
			'item_romance_description' => null,
			'out_of_stock' => null,
			'temperature_min' => null,
			'temperature_max' => null,
			'temperature_uom' => null,
			'created' => null,
			'modified' => null,
			'slug' => null,
			'meta_title' => null,
			'meta_description' => null,
			'public' => null,
			'featured' => null,
			'best_selling_product' => null,
			'mfg_state' => null,
			'innerpack_qty' => null,
			'total_units_per_master_case' => null,
			'product_type' => null,
			'private_label' => null,
			'expected_date_in_stock' => null,
			'auto_in_stock' => null,
			'out_of_stock_date' => null,
			'out_of_stock_reason' => null,
			'made_in' => null,
			'list_case_price' => null,
			'brand_name' => null,
			'pallet_only' => null,
			'samples_allowed' => null,
			'us_brand' => null,
			'brand_country' => null,
			'made_in_country' => null,
			'profile_and_user_approved' => '0',
			'search_relevance' => '100',
			'metric_name' => null,
			'standard_name' => null,
			'metric_name_short' => null,
			'standard_name_short' => null,
			'standard_size' => null,
			'metric_size' => null,
			'standard_size_uom' => null,
			'metric_size_uom' => null,
			'standard_unit_weight' => null,
			'metric_unit_weight' => null,
			'standard_unit_weight_uom' => null,
			'metric_unit_weight_uom' => null,
			'standard_case_weight' => null,
			'metric_case_weight' => null,
			'standard_case_weight_uom' => null,
			'metric_case_weight_uom' => null,
			'standard_pallet_weight' => null,
			'metric_pallet_weight' => null,
			'standard_pallet_weight_uom' => null,
			'metric_pallet_weight_uom' => null,
			'standard_unit_dimensions' => null,
			'standard_unit_length' => null,
			'standard_unit_width' => null,
			'standard_unit_height' => null,
			'standard_unit_dimension_uom' => null,
			'metric_unit_dimensions' => null,
			'metric_unit_length' => null,
			'metric_unit_width' => null,
			'metric_unit_height' => null,
			'metric_unit_dimension_uom' => null,
			'standard_case_dimensions' => null,
			'standard_case_length' => null,
			'standard_case_width' => null,
			'standard_case_height' => null,
			'standard_case_dimension_uom' => null,
			'standard_pallet_height' => null,
			'standard_pallet_dimension_uom' => null,
			'metric_case_dimensions' => null,
			'metric_case_length' => null,
			'metric_case_width' => null,
			'metric_case_height' => null,
			'metric_case_dimension_uom' => null,
			'metric_pallet_height' => null,
			'metric_pallet_dimension_uom' => null,
			'metric_temperature_min' => null,
			'metric_temperature_max' => null,
			'metric_temperature_uom' => 'Celsius',
			'standard_temperature_min' => null,
			'standard_temperature_max' => null,
			'standard_temperature_uom' => 'Fahrenheit'
		),
		'Category' => array(
			'id' => '1',
			'parent_id' => null,
			'title' => 'Grocery & Gourmet Foods',
			'slug' => 'grocery_and_gourmet_foods',
			'description' => 'Grocery & Gourmet Foods',
			'icon' => 'mini-cart.svg',
			'icon_dir' => null,
			'cover' => 'cat_bg_grocery.png',
			'cover_dir' => null,
			'banner' => null,
			'is_public' => true,
			'sort' => null,
			'created' => '2018-09-07 14:43:28',
			'modified' => '2019-07-02 16:17:43'
		),
		'SubCategory' => array(
			'id' => '2',
			'parent_id' => '1',
			'title' => 'Beverages',
			'slug' => 'beverages',
			'description' => 'Beverages',
			'icon' => 'beverages.png',
			'icon_dir' => null,
			'cover' => 'beverages-hero.png',
			'cover_dir' => null,
			'banner' => null,
			'is_public' => true,
			'sort' => null,
			'created' => null,
			'modified' => '2019-08-28 09:07:46'
		),
		'ShippingStorage' => array(
			'id' => '1',
			'storage_location' => 'Ambient'
		),
		'Brand' => array(
			'id' => '56',
			'name' => 'Waterloo ',
			'slug' => 'waterloo-',
			'logo' => 'WL_logo-MAIN_1 (2).png',
			'main_banner' => 'Banner_1134.124_1.png',
			'sub_banner_1' => null,
			'sub_banner_2' => null,
			'sub_banner_3' => null,
			'sub_banner_4' => null,
			'website' => 'https://www.drinkwaterloo.com/',
			'facebook' => 'https://www.facebook.com/waterloosparkling',
			'pinterest' => '',
			'twitter' => 'https://twitter.com/DoYouWaterloo',
			'instagram' => 'https://www.instagram.com/waterloosparkling/',
			'youtube' => '',
			'promo_video' => '',
			'promo_video_1' => '',
			'promo_video_2' => '',
			'about' => 'All Waterloo’s natural flavor ingredients are derived from non-GMO, vegan sources. Oils, extracts, or essences from the named fruit (or fruits) on each variety are paired with complementary flavors to build our unique, bold taste profile. Using these powerful extracts and oils allows us to pack a lot of flavor without any sugar, sweeteners, or other unwanted additives.',
			'grovara_comments' => 'Grovara can not pursue international Costcos. ',
			'policies' => '',
			'policies_modified' => '2021-06-22 11:57:31',
			'payment' => '',
			'spins_metric_type_1' => 'Sales',
			'spins_title_description_1' => 'YOY',
			'spins_metric_1' => '$112.3M',
			'spins_channel_1' => 'Natural & Organic',
			'spins_channel_subtext_1' => '',
			'spins_metric_type_2' => 'Growth Dollars',
			'spins_title_description_2' => 'YOY',
			'spins_metric_2' => '49%',
			'spins_channel_2' => 'Natural & Organic',
			'spins_channel_subtext_2' => '',
			'spins_scorecard' => null,
			'promoted_products' => '',
			'active' => true,
			'samples_allowed' => true,
			'product_sort' => '["200060","200040","200600","200760","200250","200260","200070","200130","200570","200200","200110","200700","200730","200210","200140","201100","201030","200580","G020969","202070","202060","202100","202090"]',
			'meta_title' => 'Waterloo ',
			'meta_description' => 'All Waterloo’s natural flavor ingredients are derived from non-GMO, vegan sources. Oils, extracts, or essences from the named fruit (or fruits) on each variety are paired with complementary flavors to build our unique, bold taste profile. Using these powerful extracts and oils allows us to pack a lot of flavor without any sugar, sweeteners, or other unwanted additives.',
			'created' => '2020-09-30 14:57:43',
			'modified' => '2023-03-13 12:31:54',
			'spins_metric_3' => '#32',
			'spins_metric_type_3' => 'Out of 945',
			'spins_title_description_3' => 'YOY',
			'spins_channel_3' => 'Shelf Stable Water',
			'spins_channel_subtext_3' => '',
			'brochure_1' => 'Waterloo_Presentation_7_28_2021.pdf',
			'brochure_2' => 'Waterloo2022BrandOverview081022.pptx',
			'brochure_3' => '',
			'mkt_support' => false,
			'mkt_support_text' => '',
			'bracket_pricing_1' => null,
			'bracket_pricing_2' => null,
			'offers_terms' => 'yes',
			'offers_terms_text' => '',
			'allow_pallet_height_70' => false,
			'brand_country' => 'US'
		),
		'ProductCategory' => array(),
		'ProductImage' => array(),
		'ChildProduct' => array(),
		'MerchPalletProduct' => array(),
		'NotifyInStock' => array()
	),
	(int) 3 => array(
		'Product' => array(
			'id' => '13625',
			'parent_id' => '0',
			'seller_id' => '437',
			'ix_one_id' => null,
			'sku' => '200760',
			'item_upc' => '819215020921',
			'case_upc' => '10819215020942',
			'pop_box_upc' => '819215020945',
			'name' => 'Waterloo Pineapple Sparkling Water',
			'description' => 'Taste of sun-ripened pineapple. Perfect tropical balance of tangy, tart and sweet, just like a delicious pineapple is expected to taste.',
			'about' => '',
			'legal_disclaimer' => 'no_data',
			'category_id' => '1',
			'sub_category_id' => '2',
			'group' => '14',
			'ingredients' => null,
			'best_use' => '',
			'nutrition_info' => '/files/products/images/56/waterloo_200760_nutrition.png',
			'primary_image' => '/files/products/images/56/waterloo_200760_primary.png',
			'secondary_image' => '/files/products/images/56/waterloo_200760_secondary.png',
			'innerpack_nutrition' => null,
			'ingredients_innerpack' => null,
			'ingredients_unit' => null,
			'flavor' => 'Pineapple',
			'unit_cost' => null,
			'lowest_case_cost' => '0.00',
			'case_cost' => '7.00',
			'unit_price' => '0.34',
			'case_price' => '8.24',
			'suggested_retail_price' => '0.00',
			'product_label' => '/files/products/images/56/waterloo_200760_label.png',
			'product_ingredients' => '',
			'specifications' => '',
			'certificate_of_analysis' => null,
			'qty_per_case' => '2',
			'size' => '144',
			'size_uom' => 'fluid ounces',
			'retail_unit_size' => '12.00',
			'innerpack' => true,
			'unit_length' => '2.60',
			'unit_width' => '2.60',
			'unit_height' => '4.84',
			'unit_dimension_uom' => 'inches',
			'unit_weight' => '0.82',
			'unit_weight_uom' => 'pounds',
			'unit_package_type' => 'Can',
			'unit_package_material' => null,
			'case_length' => '15.67',
			'case_width' => '10.55',
			'case_height' => '4.88',
			'case_dimension_uom' => 'inches',
			'case_weight' => '19.60',
			'case_weight_uom' => 'pounds',
			'case_cubic_feet' => '0.47',
			'pallet_ti' => '10.00',
			'case_package_type' => 'CORRUGATE',
			'case_innerpack_count' => null,
			'qty_per_innerpack' => null,
			'case_package_material' => null,
			'pallet_hi' => '10.00',
			'pallet_cases_per_layer' => '0.00',
			'pallet_weight' => '2000.00',
			'pallet_weight_uom' => 'pounds',
			'pallet_height' => '54.40',
			'pallet_dimension_uom' => 'inches',
			'pallet_cubic_feet' => '60',
			'pallet_package_type' => 'Wood',
			'container_20' => '10',
			'container_40' => '20',
			'shipment_lead_time' => null,
			'shelf_life' => '365',
			'shelf_life_pickup' => '180',
			'shipping_storeage_id' => '1',
			'storage_requirement' => 'Ambient',
			'hts' => '2202.10.0060',
			'date_code' => '',
			'item_ordering' => '0',
			'min_total_order' => '0',
			'size_variations' => '',
			'claim_dairy_free' => 'no',
			'claim_fair_trade' => 'no',
			'claim_gluten_free' => 'yes',
			'claim_grain_free' => 'no',
			'claim_halai' => 'no',
			'claim_ketogenic' => 'no',
			'claim_kosher' => 'yes',
			'claim_low_carb' => 'no',
			'claim_non_gmo' => 'yes',
			'claim_non_gmo_verified' => null,
			'claim_nut_free' => 'no',
			'claim_organic' => 'no',
			'claim_paleo' => 'no',
			'claim_plant_based' => 'no',
			'organic_certifier' => 'no',
			'claim_vegan' => 'yes',
			'claim_vegetarian' => 'no',
			'claim_wheat_free' => null,
			'allergens' => null,
			'allergens_ancillary' => null,
			'code_date_example' => null,
			'contains' => null,
			'does_not_contain' => null,
			'product_of' => null,
			'country_of_origin' => null,
			'status' => 'Active',
			'incoterms_id' => '1',
			'shipping_provider_id' => null,
			'brand_id' => '56',
			'ix_one_created' => null,
			'ix_one_modified' => null,
			'spins_group' => null,
			'spins_category' => null,
			'spins_subcategory' => null,
			'ecommerce_name_a' => null,
			'item_romance_description' => null,
			'out_of_stock' => false,
			'temperature_min' => '33.00',
			'temperature_max' => '75.00',
			'temperature_uom' => 'Fahrenheit',
			'created' => '2023-02-09 07:50:06',
			'modified' => '2023-02-09 07:50:06',
			'slug' => 'waterloo-pineapple-sparkling-water-200760',
			'meta_title' => 'Waterloo Pineapple Sparkling Water - 200760',
			'meta_description' => 'Taste of sun-ripened pineapple. Perfect tropical balance of tangy, tart and sweet, just like a delicious pineapple is expected to taste.',
			'public' => true,
			'featured' => false,
			'best_selling_product' => 'yes',
			'mfg_state' => '',
			'innerpack_qty' => '12',
			'total_units_per_master_case' => '24',
			'product_type' => 'Retail',
			'private_label' => 'No',
			'expected_date_in_stock' => null,
			'auto_in_stock' => false,
			'out_of_stock_date' => null,
			'out_of_stock_reason' => null,
			'made_in' => 'US',
			'list_case_price' => '8.24',
			'brand_name' => 'Waterloo ',
			'pallet_only' => '1',
			'samples_allowed' => '1',
			'us_brand' => '1',
			'brand_country' => 'US',
			'made_in_country' => 'United States of America',
			'profile_and_user_approved' => '1',
			'search_relevance' => '100',
			'metric_name' => 'Waterloo Pineapple Sparkling Water 2 innerpacks per case 4259 mL',
			'standard_name' => 'Waterloo Pineapple Sparkling Water 2 innerpacks per case 144.0 fl',
			'metric_name_short' => 'Waterloo Pineapple Sparkling Water 2 innerpacks per case',
			'standard_name_short' => 'Waterloo Pineapple Sparkling Water 2 innerpacks per case',
			'standard_size' => '144.0',
			'metric_size' => '4259',
			'standard_size_uom' => 'fluid ounces',
			'metric_size_uom' => 'milliliters',
			'standard_unit_weight' => '0.9',
			'metric_unit_weight' => '1',
			'standard_unit_weight_uom' => 'pounds',
			'metric_unit_weight_uom' => 'kilograms',
			'standard_case_weight' => '19.7',
			'metric_case_weight' => '9',
			'standard_case_weight_uom' => 'pounds',
			'metric_case_weight_uom' => 'kilograms',
			'standard_pallet_weight' => '2000.0',
			'metric_pallet_weight' => '908',
			'standard_pallet_weight_uom' => 'pounds',
			'metric_pallet_weight_uom' => 'kilograms',
			'standard_unit_dimensions' => '2.6in(L)x2.6in(W)x4.9in(H)',
			'standard_unit_length' => '2.6',
			'standard_unit_width' => '2.6',
			'standard_unit_height' => '4.9',
			'standard_unit_dimension_uom' => 'inches',
			'metric_unit_dimensions' => '7cm(L)x7cm(W)x13cm(H)',
			'metric_unit_length' => '7',
			'metric_unit_width' => '7',
			'metric_unit_height' => '13',
			'metric_unit_dimension_uom' => 'cm',
			'standard_case_dimensions' => '15.7in(L)x10.6in(W)x4.9in(H)',
			'standard_case_length' => '15.7',
			'standard_case_width' => '10.6',
			'standard_case_height' => '4.9',
			'standard_case_dimension_uom' => 'in',
			'standard_pallet_height' => '54.5',
			'standard_pallet_dimension_uom' => 'in',
			'metric_case_dimensions' => '40cm(L)x27cm(W)x13cm(H)',
			'metric_case_length' => '40',
			'metric_case_width' => '27',
			'metric_case_height' => '13',
			'metric_case_dimension_uom' => 'cm',
			'metric_pallet_height' => '139',
			'metric_pallet_dimension_uom' => 'cm',
			'metric_temperature_min' => '1',
			'metric_temperature_max' => '24',
			'metric_temperature_uom' => 'Celsius',
			'standard_temperature_min' => '33.00',
			'standard_temperature_max' => '75.00',
			'standard_temperature_uom' => 'Fahrenheit'
		),
		'ParentProduct' => array(
			'id' => null,
			'parent_id' => null,
			'seller_id' => null,
			'ix_one_id' => null,
			'sku' => null,
			'item_upc' => null,
			'case_upc' => null,
			'pop_box_upc' => null,
			'name' => null,
			'description' => null,
			'about' => null,
			'legal_disclaimer' => null,
			'category_id' => null,
			'sub_category_id' => null,
			'group' => null,
			'ingredients' => null,
			'best_use' => null,
			'nutrition_info' => null,
			'primary_image' => null,
			'secondary_image' => null,
			'innerpack_nutrition' => null,
			'ingredients_innerpack' => null,
			'ingredients_unit' => null,
			'flavor' => null,
			'unit_cost' => null,
			'lowest_case_cost' => null,
			'case_cost' => null,
			'unit_price' => null,
			'case_price' => null,
			'suggested_retail_price' => null,
			'product_label' => null,
			'product_ingredients' => null,
			'specifications' => null,
			'certificate_of_analysis' => null,
			'qty_per_case' => null,
			'size' => null,
			'size_uom' => null,
			'retail_unit_size' => null,
			'innerpack' => null,
			'unit_length' => null,
			'unit_width' => null,
			'unit_height' => null,
			'unit_dimension_uom' => null,
			'unit_weight' => null,
			'unit_weight_uom' => null,
			'unit_package_type' => null,
			'unit_package_material' => null,
			'case_length' => null,
			'case_width' => null,
			'case_height' => null,
			'case_dimension_uom' => null,
			'case_weight' => null,
			'case_weight_uom' => null,
			'case_cubic_feet' => null,
			'pallet_ti' => null,
			'case_package_type' => null,
			'case_innerpack_count' => null,
			'qty_per_innerpack' => null,
			'case_package_material' => null,
			'pallet_hi' => null,
			'pallet_cases_per_layer' => null,
			'pallet_weight' => null,
			'pallet_weight_uom' => null,
			'pallet_height' => null,
			'pallet_dimension_uom' => null,
			'pallet_cubic_feet' => null,
			'pallet_package_type' => null,
			'container_20' => null,
			'container_40' => null,
			'shipment_lead_time' => null,
			'shelf_life' => null,
			'shelf_life_pickup' => null,
			'shipping_storeage_id' => null,
			'storage_requirement' => null,
			'hts' => null,
			'date_code' => null,
			'item_ordering' => null,
			'min_total_order' => null,
			'size_variations' => null,
			'claim_dairy_free' => null,
			'claim_fair_trade' => null,
			'claim_gluten_free' => null,
			'claim_grain_free' => null,
			'claim_halai' => null,
			'claim_ketogenic' => null,
			'claim_kosher' => null,
			'claim_low_carb' => null,
			'claim_non_gmo' => null,
			'claim_non_gmo_verified' => null,
			'claim_nut_free' => null,
			'claim_organic' => null,
			'claim_paleo' => null,
			'claim_plant_based' => null,
			'organic_certifier' => null,
			'claim_vegan' => null,
			'claim_vegetarian' => null,
			'claim_wheat_free' => null,
			'allergens' => null,
			'allergens_ancillary' => null,
			'code_date_example' => null,
			'contains' => null,
			'does_not_contain' => null,
			'product_of' => null,
			'country_of_origin' => null,
			'status' => null,
			'incoterms_id' => null,
			'shipping_provider_id' => null,
			'brand_id' => null,
			'ix_one_created' => null,
			'ix_one_modified' => null,
			'spins_group' => null,
			'spins_category' => null,
			'spins_subcategory' => null,
			'ecommerce_name_a' => null,
			'item_romance_description' => null,
			'out_of_stock' => null,
			'temperature_min' => null,
			'temperature_max' => null,
			'temperature_uom' => null,
			'created' => null,
			'modified' => null,
			'slug' => null,
			'meta_title' => null,
			'meta_description' => null,
			'public' => null,
			'featured' => null,
			'best_selling_product' => null,
			'mfg_state' => null,
			'innerpack_qty' => null,
			'total_units_per_master_case' => null,
			'product_type' => null,
			'private_label' => null,
			'expected_date_in_stock' => null,
			'auto_in_stock' => null,
			'out_of_stock_date' => null,
			'out_of_stock_reason' => null,
			'made_in' => null,
			'list_case_price' => null,
			'brand_name' => null,
			'pallet_only' => null,
			'samples_allowed' => null,
			'us_brand' => null,
			'brand_country' => null,
			'made_in_country' => null,
			'profile_and_user_approved' => '0',
			'search_relevance' => '100',
			'metric_name' => null,
			'standard_name' => null,
			'metric_name_short' => null,
			'standard_name_short' => null,
			'standard_size' => null,
			'metric_size' => null,
			'standard_size_uom' => null,
			'metric_size_uom' => null,
			'standard_unit_weight' => null,
			'metric_unit_weight' => null,
			'standard_unit_weight_uom' => null,
			'metric_unit_weight_uom' => null,
			'standard_case_weight' => null,
			'metric_case_weight' => null,
			'standard_case_weight_uom' => null,
			'metric_case_weight_uom' => null,
			'standard_pallet_weight' => null,
			'metric_pallet_weight' => null,
			'standard_pallet_weight_uom' => null,
			'metric_pallet_weight_uom' => null,
			'standard_unit_dimensions' => null,
			'standard_unit_length' => null,
			'standard_unit_width' => null,
			'standard_unit_height' => null,
			'standard_unit_dimension_uom' => null,
			'metric_unit_dimensions' => null,
			'metric_unit_length' => null,
			'metric_unit_width' => null,
			'metric_unit_height' => null,
			'metric_unit_dimension_uom' => null,
			'standard_case_dimensions' => null,
			'standard_case_length' => null,
			'standard_case_width' => null,
			'standard_case_height' => null,
			'standard_case_dimension_uom' => null,
			'standard_pallet_height' => null,
			'standard_pallet_dimension_uom' => null,
			'metric_case_dimensions' => null,
			'metric_case_length' => null,
			'metric_case_width' => null,
			'metric_case_height' => null,
			'metric_case_dimension_uom' => null,
			'metric_pallet_height' => null,
			'metric_pallet_dimension_uom' => null,
			'metric_temperature_min' => null,
			'metric_temperature_max' => null,
			'metric_temperature_uom' => 'Celsius',
			'standard_temperature_min' => null,
			'standard_temperature_max' => null,
			'standard_temperature_uom' => 'Fahrenheit'
		),
		'Category' => array(
			'id' => '1',
			'parent_id' => null,
			'title' => 'Grocery & Gourmet Foods',
			'slug' => 'grocery_and_gourmet_foods',
			'description' => 'Grocery & Gourmet Foods',
			'icon' => 'mini-cart.svg',
			'icon_dir' => null,
			'cover' => 'cat_bg_grocery.png',
			'cover_dir' => null,
			'banner' => null,
			'is_public' => true,
			'sort' => null,
			'created' => '2018-09-07 14:43:28',
			'modified' => '2019-07-02 16:17:43'
		),
		'SubCategory' => array(
			'id' => '2',
			'parent_id' => '1',
			'title' => 'Beverages',
			'slug' => 'beverages',
			'description' => 'Beverages',
			'icon' => 'beverages.png',
			'icon_dir' => null,
			'cover' => 'beverages-hero.png',
			'cover_dir' => null,
			'banner' => null,
			'is_public' => true,
			'sort' => null,
			'created' => null,
			'modified' => '2019-08-28 09:07:46'
		),
		'ShippingStorage' => array(
			'id' => '1',
			'storage_location' => 'Ambient'
		),
		'Brand' => array(
			'id' => '56',
			'name' => 'Waterloo ',
			'slug' => 'waterloo-',
			'logo' => 'WL_logo-MAIN_1 (2).png',
			'main_banner' => 'Banner_1134.124_1.png',
			'sub_banner_1' => null,
			'sub_banner_2' => null,
			'sub_banner_3' => null,
			'sub_banner_4' => null,
			'website' => 'https://www.drinkwaterloo.com/',
			'facebook' => 'https://www.facebook.com/waterloosparkling',
			'pinterest' => '',
			'twitter' => 'https://twitter.com/DoYouWaterloo',
			'instagram' => 'https://www.instagram.com/waterloosparkling/',
			'youtube' => '',
			'promo_video' => '',
			'promo_video_1' => '',
			'promo_video_2' => '',
			'about' => 'All Waterloo’s natural flavor ingredients are derived from non-GMO, vegan sources. Oils, extracts, or essences from the named fruit (or fruits) on each variety are paired with complementary flavors to build our unique, bold taste profile. Using these powerful extracts and oils allows us to pack a lot of flavor without any sugar, sweeteners, or other unwanted additives.',
			'grovara_comments' => 'Grovara can not pursue international Costcos. ',
			'policies' => '',
			'policies_modified' => '2021-06-22 11:57:31',
			'payment' => '',
			'spins_metric_type_1' => 'Sales',
			'spins_title_description_1' => 'YOY',
			'spins_metric_1' => '$112.3M',
			'spins_channel_1' => 'Natural & Organic',
			'spins_channel_subtext_1' => '',
			'spins_metric_type_2' => 'Growth Dollars',
			'spins_title_description_2' => 'YOY',
			'spins_metric_2' => '49%',
			'spins_channel_2' => 'Natural & Organic',
			'spins_channel_subtext_2' => '',
			'spins_scorecard' => null,
			'promoted_products' => '',
			'active' => true,
			'samples_allowed' => true,
			'product_sort' => '["200060","200040","200600","200760","200250","200260","200070","200130","200570","200200","200110","200700","200730","200210","200140","201100","201030","200580","G020969","202070","202060","202100","202090"]',
			'meta_title' => 'Waterloo ',
			'meta_description' => 'All Waterloo’s natural flavor ingredients are derived from non-GMO, vegan sources. Oils, extracts, or essences from the named fruit (or fruits) on each variety are paired with complementary flavors to build our unique, bold taste profile. Using these powerful extracts and oils allows us to pack a lot of flavor without any sugar, sweeteners, or other unwanted additives.',
			'created' => '2020-09-30 14:57:43',
			'modified' => '2023-03-13 12:31:54',
			'spins_metric_3' => '#32',
			'spins_metric_type_3' => 'Out of 945',
			'spins_title_description_3' => 'YOY',
			'spins_channel_3' => 'Shelf Stable Water',
			'spins_channel_subtext_3' => '',
			'brochure_1' => 'Waterloo_Presentation_7_28_2021.pdf',
			'brochure_2' => 'Waterloo2022BrandOverview081022.pptx',
			'brochure_3' => '',
			'mkt_support' => false,
			'mkt_support_text' => '',
			'bracket_pricing_1' => null,
			'bracket_pricing_2' => null,
			'offers_terms' => 'yes',
			'offers_terms_text' => '',
			'allow_pallet_height_70' => false,
			'brand_country' => 'US'
		),
		'ProductCategory' => array(),
		'ProductImage' => array(),
		'ChildProduct' => array(),
		'MerchPalletProduct' => array(),
		'NotifyInStock' => array()
	),
	(int) 4 => array(
		'Product' => array(
			'id' => '13626',
			'parent_id' => '0',
			'seller_id' => '437',
			'ix_one_id' => null,
			'sku' => '200250',
			'item_upc' => '819215020471',
			'case_upc' => '10819215020485',
			'pop_box_upc' => '819215020488',
			'name' => 'Waterloo Strawberry Sparkling Water',
			'description' => 'Like a fresh bowl of strawberries. Flavor forward hit of fragrant strawberry with a sweet finish that keeps you coming back for more.',
			'about' => '',
			'legal_disclaimer' => 'no_data',
			'category_id' => '1',
			'sub_category_id' => '2',
			'group' => '14',
			'ingredients' => null,
			'best_use' => '',
			'nutrition_info' => '/files/products/images/56/waterloo_200250_nutrition.png',
			'primary_image' => '/files/products/images/56/waterloo_200250_primary.png',
			'secondary_image' => '/files/products/images/56/waterloo_200250_secondary.png',
			'innerpack_nutrition' => null,
			'ingredients_innerpack' => null,
			'ingredients_unit' => null,
			'flavor' => 'Strawberry',
			'unit_cost' => null,
			'lowest_case_cost' => '0.00',
			'case_cost' => '7.00',
			'unit_price' => '0.34',
			'case_price' => '8.24',
			'suggested_retail_price' => '0.00',
			'product_label' => '/files/products/images/56/waterloo_200250_label.png',
			'product_ingredients' => '',
			'specifications' => '',
			'certificate_of_analysis' => null,
			'qty_per_case' => '2',
			'size' => '144',
			'size_uom' => 'fluid ounces',
			'retail_unit_size' => '12.00',
			'innerpack' => true,
			'unit_length' => '2.60',
			'unit_width' => '2.60',
			'unit_height' => '4.84',
			'unit_dimension_uom' => 'inches',
			'unit_weight' => '0.82',
			'unit_weight_uom' => 'pounds',
			'unit_package_type' => 'Can',
			'unit_package_material' => null,
			'case_length' => '15.67',
			'case_width' => '10.55',
			'case_height' => '4.88',
			'case_dimension_uom' => 'inches',
			'case_weight' => '19.60',
			'case_weight_uom' => 'pounds',
			'case_cubic_feet' => '0.47',
			'pallet_ti' => '10.00',
			'case_package_type' => 'CORRUGATE',
			'case_innerpack_count' => null,
			'qty_per_innerpack' => null,
			'case_package_material' => null,
			'pallet_hi' => '10.00',
			'pallet_cases_per_layer' => '0.00',
			'pallet_weight' => '2000.00',
			'pallet_weight_uom' => 'pounds',
			'pallet_height' => '54.40',
			'pallet_dimension_uom' => 'inches',
			'pallet_cubic_feet' => '60',
			'pallet_package_type' => 'Wood',
			'container_20' => '10',
			'container_40' => '20',
			'shipment_lead_time' => null,
			'shelf_life' => '365',
			'shelf_life_pickup' => '180',
			'shipping_storeage_id' => '1',
			'storage_requirement' => 'Ambient',
			'hts' => '2202.10.0060',
			'date_code' => '',
			'item_ordering' => '0',
			'min_total_order' => '0',
			'size_variations' => '',
			'claim_dairy_free' => 'no',
			'claim_fair_trade' => 'no',
			'claim_gluten_free' => 'yes',
			'claim_grain_free' => 'no',
			'claim_halai' => 'no',
			'claim_ketogenic' => 'no',
			'claim_kosher' => 'yes',
			'claim_low_carb' => 'no',
			'claim_non_gmo' => 'yes',
			'claim_non_gmo_verified' => null,
			'claim_nut_free' => 'no',
			'claim_organic' => 'no',
			'claim_paleo' => 'no',
			'claim_plant_based' => 'no',
			'organic_certifier' => 'no',
			'claim_vegan' => 'yes',
			'claim_vegetarian' => 'no',
			'claim_wheat_free' => null,
			'allergens' => null,
			'allergens_ancillary' => null,
			'code_date_example' => null,
			'contains' => null,
			'does_not_contain' => null,
			'product_of' => null,
			'country_of_origin' => null,
			'status' => 'Active',
			'incoterms_id' => '1',
			'shipping_provider_id' => null,
			'brand_id' => '56',
			'ix_one_created' => null,
			'ix_one_modified' => null,
			'spins_group' => null,
			'spins_category' => null,
			'spins_subcategory' => null,
			'ecommerce_name_a' => null,
			'item_romance_description' => null,
			'out_of_stock' => false,
			'temperature_min' => '33.00',
			'temperature_max' => '75.00',
			'temperature_uom' => 'Fahrenheit',
			'created' => '2023-02-09 07:50:06',
			'modified' => '2023-02-09 07:50:06',
			'slug' => 'waterloo-strawberry-sparkling-water-200250',
			'meta_title' => 'Waterloo Strawberry Sparkling Water - 200250',
			'meta_description' => 'Like a fresh bowl of strawberries. Flavor forward hit of fragrant strawberry with a sweet finish that keeps you coming back for more.',
			'public' => true,
			'featured' => false,
			'best_selling_product' => 'yes',
			'mfg_state' => '',
			'innerpack_qty' => '12',
			'total_units_per_master_case' => '24',
			'product_type' => 'Retail',
			'private_label' => 'No',
			'expected_date_in_stock' => null,
			'auto_in_stock' => false,
			'out_of_stock_date' => null,
			'out_of_stock_reason' => null,
			'made_in' => 'US',
			'list_case_price' => '8.24',
			'brand_name' => 'Waterloo ',
			'pallet_only' => '1',
			'samples_allowed' => '1',
			'us_brand' => '1',
			'brand_country' => 'US',
			'made_in_country' => 'United States of America',
			'profile_and_user_approved' => '1',
			'search_relevance' => '100',
			'metric_name' => 'Waterloo Strawberry Sparkling Water 2 innerpacks per case 4259 mL',
			'standard_name' => 'Waterloo Strawberry Sparkling Water 2 innerpacks per case 144.0 fl',
			'metric_name_short' => 'Waterloo Strawberry Sparkling Water 2 innerpacks per case',
			'standard_name_short' => 'Waterloo Strawberry Sparkling Water 2 innerpacks per case',
			'standard_size' => '144.0',
			'metric_size' => '4259',
			'standard_size_uom' => 'fluid ounces',
			'metric_size_uom' => 'milliliters',
			'standard_unit_weight' => '0.9',
			'metric_unit_weight' => '1',
			'standard_unit_weight_uom' => 'pounds',
			'metric_unit_weight_uom' => 'kilograms',
			'standard_case_weight' => '19.7',
			'metric_case_weight' => '9',
			'standard_case_weight_uom' => 'pounds',
			'metric_case_weight_uom' => 'kilograms',
			'standard_pallet_weight' => '2000.0',
			'metric_pallet_weight' => '908',
			'standard_pallet_weight_uom' => 'pounds',
			'metric_pallet_weight_uom' => 'kilograms',
			'standard_unit_dimensions' => '2.6in(L)x2.6in(W)x4.9in(H)',
			'standard_unit_length' => '2.6',
			'standard_unit_width' => '2.6',
			'standard_unit_height' => '4.9',
			'standard_unit_dimension_uom' => 'inches',
			'metric_unit_dimensions' => '7cm(L)x7cm(W)x13cm(H)',
			'metric_unit_length' => '7',
			'metric_unit_width' => '7',
			'metric_unit_height' => '13',
			'metric_unit_dimension_uom' => 'cm',
			'standard_case_dimensions' => '15.7in(L)x10.6in(W)x4.9in(H)',
			'standard_case_length' => '15.7',
			'standard_case_width' => '10.6',
			'standard_case_height' => '4.9',
			'standard_case_dimension_uom' => 'in',
			'standard_pallet_height' => '54.5',
			'standard_pallet_dimension_uom' => 'in',
			'metric_case_dimensions' => '40cm(L)x27cm(W)x13cm(H)',
			'metric_case_length' => '40',
			'metric_case_width' => '27',
			'metric_case_height' => '13',
			'metric_case_dimension_uom' => 'cm',
			'metric_pallet_height' => '139',
			'metric_pallet_dimension_uom' => 'cm',
			'metric_temperature_min' => '1',
			'metric_temperature_max' => '24',
			'metric_temperature_uom' => 'Celsius',
			'standard_temperature_min' => '33.00',
			'standard_temperature_max' => '75.00',
			'standard_temperature_uom' => 'Fahrenheit'
		),
		'ParentProduct' => array(
			'id' => null,
			'parent_id' => null,
			'seller_id' => null,
			'ix_one_id' => null,
			'sku' => null,
			'item_upc' => null,
			'case_upc' => null,
			'pop_box_upc' => null,
			'name' => null,
			'description' => null,
			'about' => null,
			'legal_disclaimer' => null,
			'category_id' => null,
			'sub_category_id' => null,
			'group' => null,
			'ingredients' => null,
			'best_use' => null,
			'nutrition_info' => null,
			'primary_image' => null,
			'secondary_image' => null,
			'innerpack_nutrition' => null,
			'ingredients_innerpack' => null,
			'ingredients_unit' => null,
			'flavor' => null,
			'unit_cost' => null,
			'lowest_case_cost' => null,
			'case_cost' => null,
			'unit_price' => null,
			'case_price' => null,
			'suggested_retail_price' => null,
			'product_label' => null,
			'product_ingredients' => null,
			'specifications' => null,
			'certificate_of_analysis' => null,
			'qty_per_case' => null,
			'size' => null,
			'size_uom' => null,
			'retail_unit_size' => null,
			'innerpack' => null,
			'unit_length' => null,
			'unit_width' => null,
			'unit_height' => null,
			'unit_dimension_uom' => null,
			'unit_weight' => null,
			'unit_weight_uom' => null,
			'unit_package_type' => null,
			'unit_package_material' => null,
			'case_length' => null,
			'case_width' => null,
			'case_height' => null,
			'case_dimension_uom' => null,
			'case_weight' => null,
			'case_weight_uom' => null,
			'case_cubic_feet' => null,
			'pallet_ti' => null,
			'case_package_type' => null,
			'case_innerpack_count' => null,
			'qty_per_innerpack' => null,
			'case_package_material' => null,
			'pallet_hi' => null,
			'pallet_cases_per_layer' => null,
			'pallet_weight' => null,
			'pallet_weight_uom' => null,
			'pallet_height' => null,
			'pallet_dimension_uom' => null,
			'pallet_cubic_feet' => null,
			'pallet_package_type' => null,
			'container_20' => null,
			'container_40' => null,
			'shipment_lead_time' => null,
			'shelf_life' => null,
			'shelf_life_pickup' => null,
			'shipping_storeage_id' => null,
			'storage_requirement' => null,
			'hts' => null,
			'date_code' => null,
			'item_ordering' => null,
			'min_total_order' => null,
			'size_variations' => null,
			'claim_dairy_free' => null,
			'claim_fair_trade' => null,
			'claim_gluten_free' => null,
			'claim_grain_free' => null,
			'claim_halai' => null,
			'claim_ketogenic' => null,
			'claim_kosher' => null,
			'claim_low_carb' => null,
			'claim_non_gmo' => null,
			'claim_non_gmo_verified' => null,
			'claim_nut_free' => null,
			'claim_organic' => null,
			'claim_paleo' => null,
			'claim_plant_based' => null,
			'organic_certifier' => null,
			'claim_vegan' => null,
			'claim_vegetarian' => null,
			'claim_wheat_free' => null,
			'allergens' => null,
			'allergens_ancillary' => null,
			'code_date_example' => null,
			'contains' => null,
			'does_not_contain' => null,
			'product_of' => null,
			'country_of_origin' => null,
			'status' => null,
			'incoterms_id' => null,
			'shipping_provider_id' => null,
			'brand_id' => null,
			'ix_one_created' => null,
			'ix_one_modified' => null,
			'spins_group' => null,
			'spins_category' => null,
			'spins_subcategory' => null,
			'ecommerce_name_a' => null,
			'item_romance_description' => null,
			'out_of_stock' => null,
			'temperature_min' => null,
			'temperature_max' => null,
			'temperature_uom' => null,
			'created' => null,
			'modified' => null,
			'slug' => null,
			'meta_title' => null,
			'meta_description' => null,
			'public' => null,
			'featured' => null,
			'best_selling_product' => null,
			'mfg_state' => null,
			'innerpack_qty' => null,
			'total_units_per_master_case' => null,
			'product_type' => null,
			'private_label' => null,
			'expected_date_in_stock' => null,
			'auto_in_stock' => null,
			'out_of_stock_date' => null,
			'out_of_stock_reason' => null,
			'made_in' => null,
			'list_case_price' => null,
			'brand_name' => null,
			'pallet_only' => null,
			'samples_allowed' => null,
			'us_brand' => null,
			'brand_country' => null,
			'made_in_country' => null,
			'profile_and_user_approved' => '0',
			'search_relevance' => '100',
			'metric_name' => null,
			'standard_name' => null,
			'metric_name_short' => null,
			'standard_name_short' => null,
			'standard_size' => null,
			'metric_size' => null,
			'standard_size_uom' => null,
			'metric_size_uom' => null,
			'standard_unit_weight' => null,
			'metric_unit_weight' => null,
			'standard_unit_weight_uom' => null,
			'metric_unit_weight_uom' => null,
			'standard_case_weight' => null,
			'metric_case_weight' => null,
			'standard_case_weight_uom' => null,
			'metric_case_weight_uom' => null,
			'standard_pallet_weight' => null,
			'metric_pallet_weight' => null,
			'standard_pallet_weight_uom' => null,
			'metric_pallet_weight_uom' => null,
			'standard_unit_dimensions' => null,
			'standard_unit_length' => null,
			'standard_unit_width' => null,
			'standard_unit_height' => null,
			'standard_unit_dimension_uom' => null,
			'metric_unit_dimensions' => null,
			'metric_unit_length' => null,
			'metric_unit_width' => null,
			'metric_unit_height' => null,
			'metric_unit_dimension_uom' => null,
			'standard_case_dimensions' => null,
			'standard_case_length' => null,
			'standard_case_width' => null,
			'standard_case_height' => null,
			'standard_case_dimension_uom' => null,
			'standard_pallet_height' => null,
			'standard_pallet_dimension_uom' => null,
			'metric_case_dimensions' => null,
			'metric_case_length' => null,
			'metric_case_width' => null,
			'metric_case_height' => null,
			'metric_case_dimension_uom' => null,
			'metric_pallet_height' => null,
			'metric_pallet_dimension_uom' => null,
			'metric_temperature_min' => null,
			'metric_temperature_max' => null,
			'metric_temperature_uom' => 'Celsius',
			'standard_temperature_min' => null,
			'standard_temperature_max' => null,
			'standard_temperature_uom' => 'Fahrenheit'
		),
		'Category' => array(
			'id' => '1',
			'parent_id' => null,
			'title' => 'Grocery & Gourmet Foods',
			'slug' => 'grocery_and_gourmet_foods',
			'description' => 'Grocery & Gourmet Foods',
			'icon' => 'mini-cart.svg',
			'icon_dir' => null,
			'cover' => 'cat_bg_grocery.png',
			'cover_dir' => null,
			'banner' => null,
			'is_public' => true,
			'sort' => null,
			'created' => '2018-09-07 14:43:28',
			'modified' => '2019-07-02 16:17:43'
		),
		'SubCategory' => array(
			'id' => '2',
			'parent_id' => '1',
			'title' => 'Beverages',
			'slug' => 'beverages',
			'description' => 'Beverages',
			'icon' => 'beverages.png',
			'icon_dir' => null,
			'cover' => 'beverages-hero.png',
			'cover_dir' => null,
			'banner' => null,
			'is_public' => true,
			'sort' => null,
			'created' => null,
			'modified' => '2019-08-28 09:07:46'
		),
		'ShippingStorage' => array(
			'id' => '1',
			'storage_location' => 'Ambient'
		),
		'Brand' => array(
			'id' => '56',
			'name' => 'Waterloo ',
			'slug' => 'waterloo-',
			'logo' => 'WL_logo-MAIN_1 (2).png',
			'main_banner' => 'Banner_1134.124_1.png',
			'sub_banner_1' => null,
			'sub_banner_2' => null,
			'sub_banner_3' => null,
			'sub_banner_4' => null,
			'website' => 'https://www.drinkwaterloo.com/',
			'facebook' => 'https://www.facebook.com/waterloosparkling',
			'pinterest' => '',
			'twitter' => 'https://twitter.com/DoYouWaterloo',
			'instagram' => 'https://www.instagram.com/waterloosparkling/',
			'youtube' => '',
			'promo_video' => '',
			'promo_video_1' => '',
			'promo_video_2' => '',
			'about' => 'All Waterloo’s natural flavor ingredients are derived from non-GMO, vegan sources. Oils, extracts, or essences from the named fruit (or fruits) on each variety are paired with complementary flavors to build our unique, bold taste profile. Using these powerful extracts and oils allows us to pack a lot of flavor without any sugar, sweeteners, or other unwanted additives.',
			'grovara_comments' => 'Grovara can not pursue international Costcos. ',
			'policies' => '',
			'policies_modified' => '2021-06-22 11:57:31',
			'payment' => '',
			'spins_metric_type_1' => 'Sales',
			'spins_title_description_1' => 'YOY',
			'spins_metric_1' => '$112.3M',
			'spins_channel_1' => 'Natural & Organic',
			'spins_channel_subtext_1' => '',
			'spins_metric_type_2' => 'Growth Dollars',
			'spins_title_description_2' => 'YOY',
			'spins_metric_2' => '49%',
			'spins_channel_2' => 'Natural & Organic',
			'spins_channel_subtext_2' => '',
			'spins_scorecard' => null,
			'promoted_products' => '',
			'active' => true,
			'samples_allowed' => true,
			'product_sort' => '["200060","200040","200600","200760","200250","200260","200070","200130","200570","200200","200110","200700","200730","200210","200140","201100","201030","200580","G020969","202070","202060","202100","202090"]',
			'meta_title' => 'Waterloo ',
			'meta_description' => 'All Waterloo’s natural flavor ingredients are derived from non-GMO, vegan sources. Oils, extracts, or essences from the named fruit (or fruits) on each variety are paired with complementary flavors to build our unique, bold taste profile. Using these powerful extracts and oils allows us to pack a lot of flavor without any sugar, sweeteners, or other unwanted additives.',
			'created' => '2020-09-30 14:57:43',
			'modified' => '2023-03-13 12:31:54',
			'spins_metric_3' => '#32',
			'spins_metric_type_3' => 'Out of 945',
			'spins_title_description_3' => 'YOY',
			'spins_channel_3' => 'Shelf Stable Water',
			'spins_channel_subtext_3' => '',
			'brochure_1' => 'Waterloo_Presentation_7_28_2021.pdf',
			'brochure_2' => 'Waterloo2022BrandOverview081022.pptx',
			'brochure_3' => '',
			'mkt_support' => false,
			'mkt_support_text' => '',
			'bracket_pricing_1' => null,
			'bracket_pricing_2' => null,
			'offers_terms' => 'yes',
			'offers_terms_text' => '',
			'allow_pallet_height_70' => false,
			'brand_country' => 'US'
		),
		'ProductCategory' => array(),
		'ProductImage' => array(),
		'ChildProduct' => array(),
		'MerchPalletProduct' => array(),
		'NotifyInStock' => array()
	),
	(int) 5 => array(
		'Product' => array(
			'id' => '13627',
			'parent_id' => '0',
			'seller_id' => '437',
			'ix_one_id' => null,
			'sku' => '200260',
			'item_upc' => '819215020457',
			'case_upc' => '10819215020461',
			'pop_box_upc' => '819215020464',
			'name' => 'Waterloo Grape Sparkling Water',
			'description' => 'Bold grape taste. A tart grape flavor balanced with a crisp bubble finish - everything you loved about grape soda without the guilt.',
			'about' => '',
			'legal_disclaimer' => 'no_data',
			'category_id' => '1',
			'sub_category_id' => '2',
			'group' => '14',
			'ingredients' => null,
			'best_use' => '',
			'nutrition_info' => '/files/products/images/56/waterloo_200260_nutrition.png',
			'primary_image' => '/files/products/images/56/waterloo_200260_primary.png',
			'secondary_image' => '/files/products/images/56/waterloo_200260_secondary.png',
			'innerpack_nutrition' => null,
			'ingredients_innerpack' => null,
			'ingredients_unit' => null,
			'flavor' => 'Grape',
			'unit_cost' => null,
			'lowest_case_cost' => '0.00',
			'case_cost' => '7.00',
			'unit_price' => '0.34',
			'case_price' => '8.24',
			'suggested_retail_price' => '0.00',
			'product_label' => '/files/products/images/56/waterloo_200260_label.png',
			'product_ingredients' => '',
			'specifications' => '',
			'certificate_of_analysis' => null,
			'qty_per_case' => '2',
			'size' => '144',
			'size_uom' => 'fluid ounces',
			'retail_unit_size' => '12.00',
			'innerpack' => true,
			'unit_length' => '2.60',
			'unit_width' => '2.60',
			'unit_height' => '4.84',
			'unit_dimension_uom' => 'inches',
			'unit_weight' => '0.82',
			'unit_weight_uom' => 'pounds',
			'unit_package_type' => 'Can',
			'unit_package_material' => null,
			'case_length' => '15.67',
			'case_width' => '10.55',
			'case_height' => '4.88',
			'case_dimension_uom' => 'inches',
			'case_weight' => '19.60',
			'case_weight_uom' => 'pounds',
			'case_cubic_feet' => '0.47',
			'pallet_ti' => '10.00',
			'case_package_type' => 'CORRUGATE',
			'case_innerpack_count' => null,
			'qty_per_innerpack' => null,
			'case_package_material' => null,
			'pallet_hi' => '10.00',
			'pallet_cases_per_layer' => '0.00',
			'pallet_weight' => '2000.00',
			'pallet_weight_uom' => 'pounds',
			'pallet_height' => '54.40',
			'pallet_dimension_uom' => 'inches',
			'pallet_cubic_feet' => '60',
			'pallet_package_type' => 'Wood',
			'container_20' => '10',
			'container_40' => '20',
			'shipment_lead_time' => null,
			'shelf_life' => '365',
			'shelf_life_pickup' => '180',
			'shipping_storeage_id' => '1',
			'storage_requirement' => 'Ambient',
			'hts' => '2202.10.0060',
			'date_code' => '',
			'item_ordering' => '0',
			'min_total_order' => '0',
			'size_variations' => '',
			'claim_dairy_free' => 'no',
			'claim_fair_trade' => 'no',
			'claim_gluten_free' => 'yes',
			'claim_grain_free' => 'no',
			'claim_halai' => 'no',
			'claim_ketogenic' => 'no',
			'claim_kosher' => 'yes',
			'claim_low_carb' => 'no',
			'claim_non_gmo' => 'yes',
			'claim_non_gmo_verified' => null,
			'claim_nut_free' => 'no',
			'claim_organic' => 'no',
			'claim_paleo' => 'no',
			'claim_plant_based' => 'no',
			'organic_certifier' => 'no',
			'claim_vegan' => 'yes',
			'claim_vegetarian' => 'no',
			'claim_wheat_free' => null,
			'allergens' => null,
			'allergens_ancillary' => null,
			'code_date_example' => null,
			'contains' => null,
			'does_not_contain' => null,
			'product_of' => null,
			'country_of_origin' => null,
			'status' => 'Active',
			'incoterms_id' => '1',
			'shipping_provider_id' => null,
			'brand_id' => '56',
			'ix_one_created' => null,
			'ix_one_modified' => null,
			'spins_group' => null,
			'spins_category' => null,
			'spins_subcategory' => null,
			'ecommerce_name_a' => null,
			'item_romance_description' => null,
			'out_of_stock' => false,
			'temperature_min' => '33.00',
			'temperature_max' => '75.00',
			'temperature_uom' => 'Fahrenheit',
			'created' => '2023-02-09 07:50:06',
			'modified' => '2023-02-09 07:50:06',
			'slug' => 'waterloo-grape-sparkling-water-200260',
			'meta_title' => 'Waterloo Grape Sparkling Water - 200260',
			'meta_description' => 'Bold grape taste. A tart grape flavor balanced with a crisp bubble finish - everything you loved about grape soda without the guilt.',
			'public' => true,
			'featured' => false,
			'best_selling_product' => 'no',
			'mfg_state' => '',
			'innerpack_qty' => '12',
			'total_units_per_master_case' => '24',
			'product_type' => 'Retail',
			'private_label' => 'No',
			'expected_date_in_stock' => null,
			'auto_in_stock' => false,
			'out_of_stock_date' => null,
			'out_of_stock_reason' => null,
			'made_in' => 'US',
			'list_case_price' => '8.24',
			'brand_name' => 'Waterloo ',
			'pallet_only' => '1',
			'samples_allowed' => '1',
			'us_brand' => '1',
			'brand_country' => 'US',
			'made_in_country' => 'United States of America',
			'profile_and_user_approved' => '1',
			'search_relevance' => '100',
			'metric_name' => 'Waterloo Grape Sparkling Water 2 innerpacks per case 4259 mL',
			'standard_name' => 'Waterloo Grape Sparkling Water 2 innerpacks per case 144.0 fl',
			'metric_name_short' => 'Waterloo Grape Sparkling Water 2 innerpacks per case',
			'standard_name_short' => 'Waterloo Grape Sparkling Water 2 innerpacks per case',
			'standard_size' => '144.0',
			'metric_size' => '4259',
			'standard_size_uom' => 'fluid ounces',
			'metric_size_uom' => 'milliliters',
			'standard_unit_weight' => '0.9',
			'metric_unit_weight' => '1',
			'standard_unit_weight_uom' => 'pounds',
			'metric_unit_weight_uom' => 'kilograms',
			'standard_case_weight' => '19.7',
			'metric_case_weight' => '9',
			'standard_case_weight_uom' => 'pounds',
			'metric_case_weight_uom' => 'kilograms',
			'standard_pallet_weight' => '2000.0',
			'metric_pallet_weight' => '908',
			'standard_pallet_weight_uom' => 'pounds',
			'metric_pallet_weight_uom' => 'kilograms',
			'standard_unit_dimensions' => '2.6in(L)x2.6in(W)x4.9in(H)',
			'standard_unit_length' => '2.6',
			'standard_unit_width' => '2.6',
			'standard_unit_height' => '4.9',
			'standard_unit_dimension_uom' => 'inches',
			'metric_unit_dimensions' => '7cm(L)x7cm(W)x13cm(H)',
			'metric_unit_length' => '7',
			'metric_unit_width' => '7',
			'metric_unit_height' => '13',
			'metric_unit_dimension_uom' => 'cm',
			'standard_case_dimensions' => '15.7in(L)x10.6in(W)x4.9in(H)',
			'standard_case_length' => '15.7',
			'standard_case_width' => '10.6',
			'standard_case_height' => '4.9',
			'standard_case_dimension_uom' => 'in',
			'standard_pallet_height' => '54.5',
			'standard_pallet_dimension_uom' => 'in',
			'metric_case_dimensions' => '40cm(L)x27cm(W)x13cm(H)',
			'metric_case_length' => '40',
			'metric_case_width' => '27',
			'metric_case_height' => '13',
			'metric_case_dimension_uom' => 'cm',
			'metric_pallet_height' => '139',
			'metric_pallet_dimension_uom' => 'cm',
			'metric_temperature_min' => '1',
			'metric_temperature_max' => '24',
			'metric_temperature_uom' => 'Celsius',
			'standard_temperature_min' => '33.00',
			'standard_temperature_max' => '75.00',
			'standard_temperature_uom' => 'Fahrenheit'
		),
		'ParentProduct' => array(
			'id' => null,
			'parent_id' => null,
			'seller_id' => null,
			'ix_one_id' => null,
			'sku' => null,
			'item_upc' => null,
			'case_upc' => null,
			'pop_box_upc' => null,
			'name' => null,
			'description' => null,
			'about' => null,
			'legal_disclaimer' => null,
			'category_id' => null,
			'sub_category_id' => null,
			'group' => null,
			'ingredients' => null,
			'best_use' => null,
			'nutrition_info' => null,
			'primary_image' => null,
			'secondary_image' => null,
			'innerpack_nutrition' => null,
			'ingredients_innerpack' => null,
			'ingredients_unit' => null,
			'flavor' => null,
			'unit_cost' => null,
			'lowest_case_cost' => null,
			'case_cost' => null,
			'unit_price' => null,
			'case_price' => null,
			'suggested_retail_price' => null,
			'product_label' => null,
			'product_ingredients' => null,
			'specifications' => null,
			'certificate_of_analysis' => null,
			'qty_per_case' => null,
			'size' => null,
			'size_uom' => null,
			'retail_unit_size' => null,
			'innerpack' => null,
			'unit_length' => null,
			'unit_width' => null,
			'unit_height' => null,
			'unit_dimension_uom' => null,
			'unit_weight' => null,
			'unit_weight_uom' => null,
			'unit_package_type' => null,
			'unit_package_material' => null,
			'case_length' => null,
			'case_width' => null,
			'case_height' => null,
			'case_dimension_uom' => null,
			'case_weight' => null,
			'case_weight_uom' => null,
			'case_cubic_feet' => null,
			'pallet_ti' => null,
			'case_package_type' => null,
			'case_innerpack_count' => null,
			'qty_per_innerpack' => null,
			'case_package_material' => null,
			'pallet_hi' => null,
			'pallet_cases_per_layer' => null,
			'pallet_weight' => null,
			'pallet_weight_uom' => null,
			'pallet_height' => null,
			'pallet_dimension_uom' => null,
			'pallet_cubic_feet' => null,
			'pallet_package_type' => null,
			'container_20' => null,
			'container_40' => null,
			'shipment_lead_time' => null,
			'shelf_life' => null,
			'shelf_life_pickup' => null,
			'shipping_storeage_id' => null,
			'storage_requirement' => null,
			'hts' => null,
			'date_code' => null,
			'item_ordering' => null,
			'min_total_order' => null,
			'size_variations' => null,
			'claim_dairy_free' => null,
			'claim_fair_trade' => null,
			'claim_gluten_free' => null,
			'claim_grain_free' => null,
			'claim_halai' => null,
			'claim_ketogenic' => null,
			'claim_kosher' => null,
			'claim_low_carb' => null,
			'claim_non_gmo' => null,
			'claim_non_gmo_verified' => null,
			'claim_nut_free' => null,
			'claim_organic' => null,
			'claim_paleo' => null,
			'claim_plant_based' => null,
			'organic_certifier' => null,
			'claim_vegan' => null,
			'claim_vegetarian' => null,
			'claim_wheat_free' => null,
			'allergens' => null,
			'allergens_ancillary' => null,
			'code_date_example' => null,
			'contains' => null,
			'does_not_contain' => null,
			'product_of' => null,
			'country_of_origin' => null,
			'status' => null,
			'incoterms_id' => null,
			'shipping_provider_id' => null,
			'brand_id' => null,
			'ix_one_created' => null,
			'ix_one_modified' => null,
			'spins_group' => null,
			'spins_category' => null,
			'spins_subcategory' => null,
			'ecommerce_name_a' => null,
			'item_romance_description' => null,
			'out_of_stock' => null,
			'temperature_min' => null,
			'temperature_max' => null,
			'temperature_uom' => null,
			'created' => null,
			'modified' => null,
			'slug' => null,
			'meta_title' => null,
			'meta_description' => null,
			'public' => null,
			'featured' => null,
			'best_selling_product' => null,
			'mfg_state' => null,
			'innerpack_qty' => null,
			'total_units_per_master_case' => null,
			'product_type' => null,
			'private_label' => null,
			'expected_date_in_stock' => null,
			'auto_in_stock' => null,
			'out_of_stock_date' => null,
			'out_of_stock_reason' => null,
			'made_in' => null,
			'list_case_price' => null,
			'brand_name' => null,
			'pallet_only' => null,
			'samples_allowed' => null,
			'us_brand' => null,
			'brand_country' => null,
			'made_in_country' => null,
			'profile_and_user_approved' => '0',
			'search_relevance' => '100',
			'metric_name' => null,
			'standard_name' => null,
			'metric_name_short' => null,
			'standard_name_short' => null,
			'standard_size' => null,
			'metric_size' => null,
			'standard_size_uom' => null,
			'metric_size_uom' => null,
			'standard_unit_weight' => null,
			'metric_unit_weight' => null,
			'standard_unit_weight_uom' => null,
			'metric_unit_weight_uom' => null,
			'standard_case_weight' => null,
			'metric_case_weight' => null,
			'standard_case_weight_uom' => null,
			'metric_case_weight_uom' => null,
			'standard_pallet_weight' => null,
			'metric_pallet_weight' => null,
			'standard_pallet_weight_uom' => null,
			'metric_pallet_weight_uom' => null,
			'standard_unit_dimensions' => null,
			'standard_unit_length' => null,
			'standard_unit_width' => null,
			'standard_unit_height' => null,
			'standard_unit_dimension_uom' => null,
			'metric_unit_dimensions' => null,
			'metric_unit_length' => null,
			'metric_unit_width' => null,
			'metric_unit_height' => null,
			'metric_unit_dimension_uom' => null,
			'standard_case_dimensions' => null,
			'standard_case_length' => null,
			'standard_case_width' => null,
			'standard_case_height' => null,
			'standard_case_dimension_uom' => null,
			'standard_pallet_height' => null,
			'standard_pallet_dimension_uom' => null,
			'metric_case_dimensions' => null,
			'metric_case_length' => null,
			'metric_case_width' => null,
			'metric_case_height' => null,
			'metric_case_dimension_uom' => null,
			'metric_pallet_height' => null,
			'metric_pallet_dimension_uom' => null,
			'metric_temperature_min' => null,
			'metric_temperature_max' => null,
			'metric_temperature_uom' => 'Celsius',
			'standard_temperature_min' => null,
			'standard_temperature_max' => null,
			'standard_temperature_uom' => 'Fahrenheit'
		),
		'Category' => array(
			'id' => '1',
			'parent_id' => null,
			'title' => 'Grocery & Gourmet Foods',
			'slug' => 'grocery_and_gourmet_foods',
			'description' => 'Grocery & Gourmet Foods',
			'icon' => 'mini-cart.svg',
			'icon_dir' => null,
			'cover' => 'cat_bg_grocery.png',
			'cover_dir' => null,
			'banner' => null,
			'is_public' => true,
			'sort' => null,
			'created' => '2018-09-07 14:43:28',
			'modified' => '2019-07-02 16:17:43'
		),
		'SubCategory' => array(
			'id' => '2',
			'parent_id' => '1',
			'title' => 'Beverages',
			'slug' => 'beverages',
			'description' => 'Beverages',
			'icon' => 'beverages.png',
			'icon_dir' => null,
			'cover' => 'beverages-hero.png',
			'cover_dir' => null,
			'banner' => null,
			'is_public' => true,
			'sort' => null,
			'created' => null,
			'modified' => '2019-08-28 09:07:46'
		),
		'ShippingStorage' => array(
			'id' => '1',
			'storage_location' => 'Ambient'
		),
		'Brand' => array(
			'id' => '56',
			'name' => 'Waterloo ',
			'slug' => 'waterloo-',
			'logo' => 'WL_logo-MAIN_1 (2).png',
			'main_banner' => 'Banner_1134.124_1.png',
			'sub_banner_1' => null,
			'sub_banner_2' => null,
			'sub_banner_3' => null,
			'sub_banner_4' => null,
			'website' => 'https://www.drinkwaterloo.com/',
			'facebook' => 'https://www.facebook.com/waterloosparkling',
			'pinterest' => '',
			'twitter' => 'https://twitter.com/DoYouWaterloo',
			'instagram' => 'https://www.instagram.com/waterloosparkling/',
			'youtube' => '',
			'promo_video' => '',
			'promo_video_1' => '',
			'promo_video_2' => '',
			'about' => 'All Waterloo’s natural flavor ingredients are derived from non-GMO, vegan sources. Oils, extracts, or essences from the named fruit (or fruits) on each variety are paired with complementary flavors to build our unique, bold taste profile. Using these powerful extracts and oils allows us to pack a lot of flavor without any sugar, sweeteners, or other unwanted additives.',
			'grovara_comments' => 'Grovara can not pursue international Costcos. ',
			'policies' => '',
			'policies_modified' => '2021-06-22 11:57:31',
			'payment' => '',
			'spins_metric_type_1' => 'Sales',
			'spins_title_description_1' => 'YOY',
			'spins_metric_1' => '$112.3M',
			'spins_channel_1' => 'Natural & Organic',
			'spins_channel_subtext_1' => '',
			'spins_metric_type_2' => 'Growth Dollars',
			'spins_title_description_2' => 'YOY',
			'spins_metric_2' => '49%',
			'spins_channel_2' => 'Natural & Organic',
			'spins_channel_subtext_2' => '',
			'spins_scorecard' => null,
			'promoted_products' => '',
			'active' => true,
			'samples_allowed' => true,
			'product_sort' => '["200060","200040","200600","200760","200250","200260","200070","200130","200570","200200","200110","200700","200730","200210","200140","201100","201030","200580","G020969","202070","202060","202100","202090"]',
			'meta_title' => 'Waterloo ',
			'meta_description' => 'All Waterloo’s natural flavor ingredients are derived from non-GMO, vegan sources. Oils, extracts, or essences from the named fruit (or fruits) on each variety are paired with complementary flavors to build our unique, bold taste profile. Using these powerful extracts and oils allows us to pack a lot of flavor without any sugar, sweeteners, or other unwanted additives.',
			'created' => '2020-09-30 14:57:43',
			'modified' => '2023-03-13 12:31:54',
			'spins_metric_3' => '#32',
			'spins_metric_type_3' => 'Out of 945',
			'spins_title_description_3' => 'YOY',
			'spins_channel_3' => 'Shelf Stable Water',
			'spins_channel_subtext_3' => '',
			'brochure_1' => 'Waterloo_Presentation_7_28_2021.pdf',
			'brochure_2' => 'Waterloo2022BrandOverview081022.pptx',
			'brochure_3' => '',
			'mkt_support' => false,
			'mkt_support_text' => '',
			'bracket_pricing_1' => null,
			'bracket_pricing_2' => null,
			'offers_terms' => 'yes',
			'offers_terms_text' => '',
			'allow_pallet_height_70' => false,
			'brand_country' => 'US'
		),
		'ProductCategory' => array(),
		'ProductImage' => array(),
		'ChildProduct' => array(),
		'MerchPalletProduct' => array(),
		'NotifyInStock' => array()
	),
	(int) 6 => array(
		'Product' => array(
			'id' => '13628',
			'parent_id' => '0',
			'seller_id' => '437',
			'ix_one_id' => null,
			'sku' => '200070',
			'item_upc' => '819215020075',
			'case_upc' => '10819215020249',
			'pop_box_upc' => '819215020242',
			'name' => 'Waterloo Watermelon Sparkling Water',
			'description' => 'Sweet & summery. Juicy watermelon taste and aroma that delivers a delightful refreshment and the feeling of summer all year long.',
			'about' => '',
			'legal_disclaimer' => 'no_data',
			'category_id' => '1',
			'sub_category_id' => '2',
			'group' => '14',
			'ingredients' => null,
			'best_use' => '',
			'nutrition_info' => '/files/products/images/56/waterloo_200070_nutrition.png',
			'primary_image' => '/files/products/images/56/waterloo_200070_primary.png',
			'secondary_image' => '/files/products/images/56/waterloo_200070_secondary.png',
			'innerpack_nutrition' => null,
			'ingredients_innerpack' => null,
			'ingredients_unit' => null,
			'flavor' => 'Watermelon',
			'unit_cost' => null,
			'lowest_case_cost' => '0.00',
			'case_cost' => '7.00',
			'unit_price' => '0.34',
			'case_price' => '8.24',
			'suggested_retail_price' => '0.00',
			'product_label' => '/files/products/images/56/waterloo_200070_label.png',
			'product_ingredients' => '',
			'specifications' => '',
			'certificate_of_analysis' => null,
			'qty_per_case' => '2',
			'size' => '144',
			'size_uom' => 'fluid ounces',
			'retail_unit_size' => '12.00',
			'innerpack' => true,
			'unit_length' => '2.60',
			'unit_width' => '2.60',
			'unit_height' => '4.84',
			'unit_dimension_uom' => 'inches',
			'unit_weight' => '0.82',
			'unit_weight_uom' => 'pounds',
			'unit_package_type' => 'Can',
			'unit_package_material' => null,
			'case_length' => '15.67',
			'case_width' => '10.55',
			'case_height' => '4.88',
			'case_dimension_uom' => 'inches',
			'case_weight' => '19.60',
			'case_weight_uom' => 'pounds',
			'case_cubic_feet' => '0.47',
			'pallet_ti' => '10.00',
			'case_package_type' => 'CORRUGATE',
			'case_innerpack_count' => null,
			'qty_per_innerpack' => null,
			'case_package_material' => null,
			'pallet_hi' => '10.00',
			'pallet_cases_per_layer' => '0.00',
			'pallet_weight' => '2000.00',
			'pallet_weight_uom' => 'pounds',
			'pallet_height' => '54.40',
			'pallet_dimension_uom' => 'inches',
			'pallet_cubic_feet' => '60',
			'pallet_package_type' => 'Wood',
			'container_20' => '10',
			'container_40' => '20',
			'shipment_lead_time' => null,
			'shelf_life' => '365',
			'shelf_life_pickup' => '180',
			'shipping_storeage_id' => '1',
			'storage_requirement' => 'Ambient',
			'hts' => '2202.10.0060',
			'date_code' => '',
			'item_ordering' => '0',
			'min_total_order' => '0',
			'size_variations' => '',
			'claim_dairy_free' => '0',
			'claim_fair_trade' => '0',
			'claim_gluten_free' => 'yes',
			'claim_grain_free' => '0',
			'claim_halai' => '0',
			'claim_ketogenic' => '0',
			'claim_kosher' => 'yes',
			'claim_low_carb' => '0',
			'claim_non_gmo' => 'yes',
			'claim_non_gmo_verified' => null,
			'claim_nut_free' => '0',
			'claim_organic' => '0',
			'claim_paleo' => '0',
			'claim_plant_based' => '0',
			'organic_certifier' => 'no',
			'claim_vegan' => 'yes',
			'claim_vegetarian' => '0',
			'claim_wheat_free' => null,
			'allergens' => null,
			'allergens_ancillary' => null,
			'code_date_example' => null,
			'contains' => null,
			'does_not_contain' => null,
			'product_of' => null,
			'country_of_origin' => null,
			'status' => 'Active',
			'incoterms_id' => '1',
			'shipping_provider_id' => null,
			'brand_id' => '56',
			'ix_one_created' => null,
			'ix_one_modified' => null,
			'spins_group' => null,
			'spins_category' => null,
			'spins_subcategory' => null,
			'ecommerce_name_a' => null,
			'item_romance_description' => null,
			'out_of_stock' => false,
			'temperature_min' => '33.00',
			'temperature_max' => '75.00',
			'temperature_uom' => 'Fahrenheit',
			'created' => '2023-02-09 07:50:06',
			'modified' => '2023-02-24 09:58:57',
			'slug' => 'waterloo-watermelon-sparkling-water-200070',
			'meta_title' => 'Waterloo Watermelon Sparkling Water - 200070',
			'meta_description' => 'Sweet & summery. Juicy watermelon taste and aroma that delivers a delightful refreshment and the feeling of summer all year long.',
			'public' => true,
			'featured' => false,
			'best_selling_product' => 'no',
			'mfg_state' => '',
			'innerpack_qty' => '12',
			'total_units_per_master_case' => '24',
			'product_type' => 'Retail',
			'private_label' => 'No',
			'expected_date_in_stock' => null,
			'auto_in_stock' => false,
			'out_of_stock_date' => null,
			'out_of_stock_reason' => '',
			'made_in' => 'US',
			'list_case_price' => '8.24',
			'brand_name' => 'Waterloo ',
			'pallet_only' => '1',
			'samples_allowed' => '1',
			'us_brand' => '1',
			'brand_country' => 'US',
			'made_in_country' => 'United States of America',
			'profile_and_user_approved' => '1',
			'search_relevance' => '100',
			'metric_name' => 'Waterloo Watermelon Sparkling Water 2 innerpacks per case 4259 mL',
			'standard_name' => 'Waterloo Watermelon Sparkling Water 2 innerpacks per case 144.0 fl',
			'metric_name_short' => 'Waterloo Watermelon Sparkling Water 2 innerpacks per case',
			'standard_name_short' => 'Waterloo Watermelon Sparkling Water 2 innerpacks per case',
			'standard_size' => '144.0',
			'metric_size' => '4259',
			'standard_size_uom' => 'fluid ounces',
			'metric_size_uom' => 'milliliters',
			'standard_unit_weight' => '0.9',
			'metric_unit_weight' => '1',
			'standard_unit_weight_uom' => 'pounds',
			'metric_unit_weight_uom' => 'kilograms',
			'standard_case_weight' => '19.7',
			'metric_case_weight' => '9',
			'standard_case_weight_uom' => 'pounds',
			'metric_case_weight_uom' => 'kilograms',
			'standard_pallet_weight' => '2000.0',
			'metric_pallet_weight' => '908',
			'standard_pallet_weight_uom' => 'pounds',
			'metric_pallet_weight_uom' => 'kilograms',
			'standard_unit_dimensions' => '2.6in(L)x2.6in(W)x4.9in(H)',
			'standard_unit_length' => '2.6',
			'standard_unit_width' => '2.6',
			'standard_unit_height' => '4.9',
			'standard_unit_dimension_uom' => 'inches',
			'metric_unit_dimensions' => '7cm(L)x7cm(W)x13cm(H)',
			'metric_unit_length' => '7',
			'metric_unit_width' => '7',
			'metric_unit_height' => '13',
			'metric_unit_dimension_uom' => 'cm',
			'standard_case_dimensions' => '15.7in(L)x10.6in(W)x4.9in(H)',
			'standard_case_length' => '15.7',
			'standard_case_width' => '10.6',
			'standard_case_height' => '4.9',
			'standard_case_dimension_uom' => 'in',
			'standard_pallet_height' => '54.5',
			'standard_pallet_dimension_uom' => 'in',
			'metric_case_dimensions' => '40cm(L)x27cm(W)x13cm(H)',
			'metric_case_length' => '40',
			'metric_case_width' => '27',
			'metric_case_height' => '13',
			'metric_case_dimension_uom' => 'cm',
			'metric_pallet_height' => '139',
			'metric_pallet_dimension_uom' => 'cm',
			'metric_temperature_min' => '1',
			'metric_temperature_max' => '24',
			'metric_temperature_uom' => 'Celsius',
			'standard_temperature_min' => '33.00',
			'standard_temperature_max' => '75.00',
			'standard_temperature_uom' => 'Fahrenheit'
		),
		'ParentProduct' => array(
			'id' => null,
			'parent_id' => null,
			'seller_id' => null,
			'ix_one_id' => null,
			'sku' => null,
			'item_upc' => null,
			'case_upc' => null,
			'pop_box_upc' => null,
			'name' => null,
			'description' => null,
			'about' => null,
			'legal_disclaimer' => null,
			'category_id' => null,
			'sub_category_id' => null,
			'group' => null,
			'ingredients' => null,
			'best_use' => null,
			'nutrition_info' => null,
			'primary_image' => null,
			'secondary_image' => null,
			'innerpack_nutrition' => null,
			'ingredients_innerpack' => null,
			'ingredients_unit' => null,
			'flavor' => null,
			'unit_cost' => null,
			'lowest_case_cost' => null,
			'case_cost' => null,
			'unit_price' => null,
			'case_price' => null,
			'suggested_retail_price' => null,
			'product_label' => null,
			'product_ingredients' => null,
			'specifications' => null,
			'certificate_of_analysis' => null,
			'qty_per_case' => null,
			'size' => null,
			'size_uom' => null,
			'retail_unit_size' => null,
			'innerpack' => null,
			'unit_length' => null,
			'unit_width' => null,
			'unit_height' => null,
			'unit_dimension_uom' => null,
			'unit_weight' => null,
			'unit_weight_uom' => null,
			'unit_package_type' => null,
			'unit_package_material' => null,
			'case_length' => null,
			'case_width' => null,
			'case_height' => null,
			'case_dimension_uom' => null,
			'case_weight' => null,
			'case_weight_uom' => null,
			'case_cubic_feet' => null,
			'pallet_ti' => null,
			'case_package_type' => null,
			'case_innerpack_count' => null,
			'qty_per_innerpack' => null,
			'case_package_material' => null,
			'pallet_hi' => null,
			'pallet_cases_per_layer' => null,
			'pallet_weight' => null,
			'pallet_weight_uom' => null,
			'pallet_height' => null,
			'pallet_dimension_uom' => null,
			'pallet_cubic_feet' => null,
			'pallet_package_type' => null,
			'container_20' => null,
			'container_40' => null,
			'shipment_lead_time' => null,
			'shelf_life' => null,
			'shelf_life_pickup' => null,
			'shipping_storeage_id' => null,
			'storage_requirement' => null,
			'hts' => null,
			'date_code' => null,
			'item_ordering' => null,
			'min_total_order' => null,
			'size_variations' => null,
			'claim_dairy_free' => null,
			'claim_fair_trade' => null,
			'claim_gluten_free' => null,
			'claim_grain_free' => null,
			'claim_halai' => null,
			'claim_ketogenic' => null,
			'claim_kosher' => null,
			'claim_low_carb' => null,
			'claim_non_gmo' => null,
			'claim_non_gmo_verified' => null,
			'claim_nut_free' => null,
			'claim_organic' => null,
			'claim_paleo' => null,
			'claim_plant_based' => null,
			'organic_certifier' => null,
			'claim_vegan' => null,
			'claim_vegetarian' => null,
			'claim_wheat_free' => null,
			'allergens' => null,
			'allergens_ancillary' => null,
			'code_date_example' => null,
			'contains' => null,
			'does_not_contain' => null,
			'product_of' => null,
			'country_of_origin' => null,
			'status' => null,
			'incoterms_id' => null,
			'shipping_provider_id' => null,
			'brand_id' => null,
			'ix_one_created' => null,
			'ix_one_modified' => null,
			'spins_group' => null,
			'spins_category' => null,
			'spins_subcategory' => null,
			'ecommerce_name_a' => null,
			'item_romance_description' => null,
			'out_of_stock' => null,
			'temperature_min' => null,
			'temperature_max' => null,
			'temperature_uom' => null,
			'created' => null,
			'modified' => null,
			'slug' => null,
			'meta_title' => null,
			'meta_description' => null,
			'public' => null,
			'featured' => null,
			'best_selling_product' => null,
			'mfg_state' => null,
			'innerpack_qty' => null,
			'total_units_per_master_case' => null,
			'product_type' => null,
			'private_label' => null,
			'expected_date_in_stock' => null,
			'auto_in_stock' => null,
			'out_of_stock_date' => null,
			'out_of_stock_reason' => null,
			'made_in' => null,
			'list_case_price' => null,
			'brand_name' => null,
			'pallet_only' => null,
			'samples_allowed' => null,
			'us_brand' => null,
			'brand_country' => null,
			'made_in_country' => null,
			'profile_and_user_approved' => '0',
			'search_relevance' => '100',
			'metric_name' => null,
			'standard_name' => null,
			'metric_name_short' => null,
			'standard_name_short' => null,
			'standard_size' => null,
			'metric_size' => null,
			'standard_size_uom' => null,
			'metric_size_uom' => null,
			'standard_unit_weight' => null,
			'metric_unit_weight' => null,
			'standard_unit_weight_uom' => null,
			'metric_unit_weight_uom' => null,
			'standard_case_weight' => null,
			'metric_case_weight' => null,
			'standard_case_weight_uom' => null,
			'metric_case_weight_uom' => null,
			'standard_pallet_weight' => null,
			'metric_pallet_weight' => null,
			'standard_pallet_weight_uom' => null,
			'metric_pallet_weight_uom' => null,
			'standard_unit_dimensions' => null,
			'standard_unit_length' => null,
			'standard_unit_width' => null,
			'standard_unit_height' => null,
			'standard_unit_dimension_uom' => null,
			'metric_unit_dimensions' => null,
			'metric_unit_length' => null,
			'metric_unit_width' => null,
			'metric_unit_height' => null,
			'metric_unit_dimension_uom' => null,
			'standard_case_dimensions' => null,
			'standard_case_length' => null,
			'standard_case_width' => null,
			'standard_case_height' => null,
			'standard_case_dimension_uom' => null,
			'standard_pallet_height' => null,
			'standard_pallet_dimension_uom' => null,
			'metric_case_dimensions' => null,
			'metric_case_length' => null,
			'metric_case_width' => null,
			'metric_case_height' => null,
			'metric_case_dimension_uom' => null,
			'metric_pallet_height' => null,
			'metric_pallet_dimension_uom' => null,
			'metric_temperature_min' => null,
			'metric_temperature_max' => null,
			'metric_temperature_uom' => 'Celsius',
			'standard_temperature_min' => null,
			'standard_temperature_max' => null,
			'standard_temperature_uom' => 'Fahrenheit'
		),
		'Category' => array(
			'id' => '1',
			'parent_id' => null,
			'title' => 'Grocery & Gourmet Foods',
			'slug' => 'grocery_and_gourmet_foods',
			'description' => 'Grocery & Gourmet Foods',
			'icon' => 'mini-cart.svg',
			'icon_dir' => null,
			'cover' => 'cat_bg_grocery.png',
			'cover_dir' => null,
			'banner' => null,
			'is_public' => true,
			'sort' => null,
			'created' => '2018-09-07 14:43:28',
			'modified' => '2019-07-02 16:17:43'
		),
		'SubCategory' => array(
			'id' => '2',
			'parent_id' => '1',
			'title' => 'Beverages',
			'slug' => 'beverages',
			'description' => 'Beverages',
			'icon' => 'beverages.png',
			'icon_dir' => null,
			'cover' => 'beverages-hero.png',
			'cover_dir' => null,
			'banner' => null,
			'is_public' => true,
			'sort' => null,
			'created' => null,
			'modified' => '2019-08-28 09:07:46'
		),
		'ShippingStorage' => array(
			'id' => '1',
			'storage_location' => 'Ambient'
		),
		'Brand' => array(
			'id' => '56',
			'name' => 'Waterloo ',
			'slug' => 'waterloo-',
			'logo' => 'WL_logo-MAIN_1 (2).png',
			'main_banner' => 'Banner_1134.124_1.png',
			'sub_banner_1' => null,
			'sub_banner_2' => null,
			'sub_banner_3' => null,
			'sub_banner_4' => null,
			'website' => 'https://www.drinkwaterloo.com/',
			'facebook' => 'https://www.facebook.com/waterloosparkling',
			'pinterest' => '',
			'twitter' => 'https://twitter.com/DoYouWaterloo',
			'instagram' => 'https://www.instagram.com/waterloosparkling/',
			'youtube' => '',
			'promo_video' => '',
			'promo_video_1' => '',
			'promo_video_2' => '',
			'about' => 'All Waterloo’s natural flavor ingredients are derived from non-GMO, vegan sources. Oils, extracts, or essences from the named fruit (or fruits) on each variety are paired with complementary flavors to build our unique, bold taste profile. Using these powerful extracts and oils allows us to pack a lot of flavor without any sugar, sweeteners, or other unwanted additives.',
			'grovara_comments' => 'Grovara can not pursue international Costcos. ',
			'policies' => '',
			'policies_modified' => '2021-06-22 11:57:31',
			'payment' => '',
			'spins_metric_type_1' => 'Sales',
			'spins_title_description_1' => 'YOY',
			'spins_metric_1' => '$112.3M',
			'spins_channel_1' => 'Natural & Organic',
			'spins_channel_subtext_1' => '',
			'spins_metric_type_2' => 'Growth Dollars',
			'spins_title_description_2' => 'YOY',
			'spins_metric_2' => '49%',
			'spins_channel_2' => 'Natural & Organic',
			'spins_channel_subtext_2' => '',
			'spins_scorecard' => null,
			'promoted_products' => '',
			'active' => true,
			'samples_allowed' => true,
			'product_sort' => '["200060","200040","200600","200760","200250","200260","200070","200130","200570","200200","200110","200700","200730","200210","200140","201100","201030","200580","G020969","202070","202060","202100","202090"]',
			'meta_title' => 'Waterloo ',
			'meta_description' => 'All Waterloo’s natural flavor ingredients are derived from non-GMO, vegan sources. Oils, extracts, or essences from the named fruit (or fruits) on each variety are paired with complementary flavors to build our unique, bold taste profile. Using these powerful extracts and oils allows us to pack a lot of flavor without any sugar, sweeteners, or other unwanted additives.',
			'created' => '2020-09-30 14:57:43',
			'modified' => '2023-03-13 12:31:54',
			'spins_metric_3' => '#32',
			'spins_metric_type_3' => 'Out of 945',
			'spins_title_description_3' => 'YOY',
			'spins_channel_3' => 'Shelf Stable Water',
			'spins_channel_subtext_3' => '',
			'brochure_1' => 'Waterloo_Presentation_7_28_2021.pdf',
			'brochure_2' => 'Waterloo2022BrandOverview081022.pptx',
			'brochure_3' => '',
			'mkt_support' => false,
			'mkt_support_text' => '',
			'bracket_pricing_1' => null,
			'bracket_pricing_2' => null,
			'offers_terms' => 'yes',
			'offers_terms_text' => '',
			'allow_pallet_height_70' => false,
			'brand_country' => 'US'
		),
		'ProductCategory' => array(
			(int) 0 => array(
				[maximum depth reached]
			)
		),
		'ProductImage' => array(),
		'ChildProduct' => array(),
		'MerchPalletProduct' => array(),
		'NotifyInStock' => array()
	),
	(int) 7 => array(
		'Product' => array(
			'id' => '13629',
			'parent_id' => '0',
			'seller_id' => '437',
			'ix_one_id' => null,
			'sku' => '200130',
			'item_upc' => '819215020051',
			'case_upc' => '10819215020157',
			'pop_box_upc' => '819215020150',
			'name' => 'Waterloo Black Cherry Sparkling Water',
			'description' => 'Pure essence of fresh muddled cherries. Rich, crisp taste that brightens the taste buds with perfect balance of sweet and tart and a finish that does not linger.',
			'about' => '',
			'legal_disclaimer' => 'no_data',
			'category_id' => '1',
			'sub_category_id' => '2',
			'group' => '14',
			'ingredients' => null,
			'best_use' => '',
			'nutrition_info' => '/files/products/images/56/waterloo_200130_nutrition.jpg',
			'primary_image' => '/files/products/images/56/waterloo_200130_primary.png',
			'secondary_image' => '/files/products/images/56/waterloo_200130_secondary.png',
			'innerpack_nutrition' => null,
			'ingredients_innerpack' => null,
			'ingredients_unit' => null,
			'flavor' => 'Black Cherry',
			'unit_cost' => null,
			'lowest_case_cost' => '0.00',
			'case_cost' => '7.39',
			'unit_price' => '0.36',
			'case_price' => '8.69',
			'suggested_retail_price' => '0.00',
			'product_label' => '/files/products/images/56/waterloo_200130_label.png',
			'product_ingredients' => '',
			'specifications' => '',
			'certificate_of_analysis' => null,
			'qty_per_case' => '3',
			'size' => '96',
			'size_uom' => 'fluid ounces',
			'retail_unit_size' => '12.00',
			'innerpack' => true,
			'unit_length' => '2.60',
			'unit_width' => '2.60',
			'unit_height' => '4.84',
			'unit_dimension_uom' => 'inches',
			'unit_weight' => '0.82',
			'unit_weight_uom' => 'pounds',
			'unit_package_type' => 'Can',
			'unit_package_material' => null,
			'case_length' => '15.80',
			'case_width' => '10.68',
			'case_height' => '5.01',
			'case_dimension_uom' => 'inches',
			'case_weight' => '19.60',
			'case_weight_uom' => 'pounds',
			'case_cubic_feet' => '0.49',
			'pallet_ti' => '10.00',
			'case_package_type' => 'CORRUGATE',
			'case_innerpack_count' => null,
			'qty_per_innerpack' => null,
			'case_package_material' => null,
			'pallet_hi' => '10.00',
			'pallet_cases_per_layer' => '0.00',
			'pallet_weight' => '2000.00',
			'pallet_weight_uom' => 'pounds',
			'pallet_height' => '55.05',
			'pallet_dimension_uom' => 'inches',
			'pallet_cubic_feet' => '61',
			'pallet_package_type' => 'Wood',
			'container_20' => '10',
			'container_40' => '20',
			'shipment_lead_time' => null,
			'shelf_life' => '365',
			'shelf_life_pickup' => '180',
			'shipping_storeage_id' => '1',
			'storage_requirement' => 'Ambient',
			'hts' => '2202.10.0060',
			'date_code' => '',
			'item_ordering' => '0',
			'min_total_order' => '0',
			'size_variations' => '',
			'claim_dairy_free' => 'no',
			'claim_fair_trade' => 'no',
			'claim_gluten_free' => 'yes',
			'claim_grain_free' => 'no',
			'claim_halai' => 'no',
			'claim_ketogenic' => 'no',
			'claim_kosher' => 'yes',
			'claim_low_carb' => 'no',
			'claim_non_gmo' => 'yes',
			'claim_non_gmo_verified' => null,
			'claim_nut_free' => 'no',
			'claim_organic' => 'no',
			'claim_paleo' => 'no',
			'claim_plant_based' => 'no',
			'organic_certifier' => 'no',
			'claim_vegan' => 'yes',
			'claim_vegetarian' => 'no',
			'claim_wheat_free' => null,
			'allergens' => null,
			'allergens_ancillary' => null,
			'code_date_example' => null,
			'contains' => null,
			'does_not_contain' => null,
			'product_of' => null,
			'country_of_origin' => null,
			'status' => 'Active',
			'incoterms_id' => '1',
			'shipping_provider_id' => null,
			'brand_id' => '56',
			'ix_one_created' => null,
			'ix_one_modified' => null,
			'spins_group' => null,
			'spins_category' => null,
			'spins_subcategory' => null,
			'ecommerce_name_a' => null,
			'item_romance_description' => null,
			'out_of_stock' => false,
			'temperature_min' => '33.00',
			'temperature_max' => '75.00',
			'temperature_uom' => 'Fahrenheit',
			'created' => '2023-02-09 07:50:06',
			'modified' => '2023-02-09 07:50:06',
			'slug' => 'waterloo-black-cherry-sparkling-water-200130',
			'meta_title' => 'Waterloo Black Cherry Sparkling Water - 200130',
			'meta_description' => 'Pure essence of fresh muddled cherries. Rich, crisp taste that brightens the taste buds with perfect balance of sweet and tart and a finish that does not linger.',
			'public' => true,
			'featured' => false,
			'best_selling_product' => 'no',
			'mfg_state' => '',
			'innerpack_qty' => '8',
			'total_units_per_master_case' => '24',
			'product_type' => 'Retail',
			'private_label' => 'No',
			'expected_date_in_stock' => null,
			'auto_in_stock' => false,
			'out_of_stock_date' => null,
			'out_of_stock_reason' => null,
			'made_in' => 'US',
			'list_case_price' => '8.69',
			'brand_name' => 'Waterloo ',
			'pallet_only' => '1',
			'samples_allowed' => '1',
			'us_brand' => '1',
			'brand_country' => 'US',
			'made_in_country' => 'United States of America',
			'profile_and_user_approved' => '1',
			'search_relevance' => '100',
			'metric_name' => 'Waterloo Black Cherry Sparkling Water 3 innerpacks per case 2840 mL',
			'standard_name' => 'Waterloo Black Cherry Sparkling Water 3 innerpacks per case 96.0 fl',
			'metric_name_short' => 'Waterloo Black Cherry Sparkling Water 3 innerpacks per case',
			'standard_name_short' => 'Waterloo Black Cherry Sparkling Water 3 innerpacks per case',
			'standard_size' => '96.0',
			'metric_size' => '2840',
			'standard_size_uom' => 'fluid ounces',
			'metric_size_uom' => 'milliliters',
			'standard_unit_weight' => '0.9',
			'metric_unit_weight' => '1',
			'standard_unit_weight_uom' => 'pounds',
			'metric_unit_weight_uom' => 'kilograms',
			'standard_case_weight' => '19.7',
			'metric_case_weight' => '9',
			'standard_case_weight_uom' => 'pounds',
			'metric_case_weight_uom' => 'kilograms',
			'standard_pallet_weight' => '2000.0',
			'metric_pallet_weight' => '908',
			'standard_pallet_weight_uom' => 'pounds',
			'metric_pallet_weight_uom' => 'kilograms',
			'standard_unit_dimensions' => '2.6in(L)x2.6in(W)x4.9in(H)',
			'standard_unit_length' => '2.6',
			'standard_unit_width' => '2.6',
			'standard_unit_height' => '4.9',
			'standard_unit_dimension_uom' => 'inches',
			'metric_unit_dimensions' => '7cm(L)x7cm(W)x13cm(H)',
			'metric_unit_length' => '7',
			'metric_unit_width' => '7',
			'metric_unit_height' => '13',
			'metric_unit_dimension_uom' => 'cm',
			'standard_case_dimensions' => '15.9in(L)x10.7in(W)x5.1in(H)',
			'standard_case_length' => '15.9',
			'standard_case_width' => '10.7',
			'standard_case_height' => '5.1',
			'standard_case_dimension_uom' => 'in',
			'standard_pallet_height' => '55.1',
			'standard_pallet_dimension_uom' => 'in',
			'metric_case_dimensions' => '41cm(L)x28cm(W)x13cm(H)',
			'metric_case_length' => '41',
			'metric_case_width' => '28',
			'metric_case_height' => '13',
			'metric_case_dimension_uom' => 'cm',
			'metric_pallet_height' => '140',
			'metric_pallet_dimension_uom' => 'cm',
			'metric_temperature_min' => '1',
			'metric_temperature_max' => '24',
			'metric_temperature_uom' => 'Celsius',
			'standard_temperature_min' => '33.00',
			'standard_temperature_max' => '75.00',
			'standard_temperature_uom' => 'Fahrenheit'
		),
		'ParentProduct' => array(
			'id' => null,
			'parent_id' => null,
			'seller_id' => null,
			'ix_one_id' => null,
			'sku' => null,
			'item_upc' => null,
			'case_upc' => null,
			'pop_box_upc' => null,
			'name' => null,
			'description' => null,
			'about' => null,
			'legal_disclaimer' => null,
			'category_id' => null,
			'sub_category_id' => null,
			'group' => null,
			'ingredients' => null,
			'best_use' => null,
			'nutrition_info' => null,
			'primary_image' => null,
			'secondary_image' => null,
			'innerpack_nutrition' => null,
			'ingredients_innerpack' => null,
			'ingredients_unit' => null,
			'flavor' => null,
			'unit_cost' => null,
			'lowest_case_cost' => null,
			'case_cost' => null,
			'unit_price' => null,
			'case_price' => null,
			'suggested_retail_price' => null,
			'product_label' => null,
			'product_ingredients' => null,
			'specifications' => null,
			'certificate_of_analysis' => null,
			'qty_per_case' => null,
			'size' => null,
			'size_uom' => null,
			'retail_unit_size' => null,
			'innerpack' => null,
			'unit_length' => null,
			'unit_width' => null,
			'unit_height' => null,
			'unit_dimension_uom' => null,
			'unit_weight' => null,
			'unit_weight_uom' => null,
			'unit_package_type' => null,
			'unit_package_material' => null,
			'case_length' => null,
			'case_width' => null,
			'case_height' => null,
			'case_dimension_uom' => null,
			'case_weight' => null,
			'case_weight_uom' => null,
			'case_cubic_feet' => null,
			'pallet_ti' => null,
			'case_package_type' => null,
			'case_innerpack_count' => null,
			'qty_per_innerpack' => null,
			'case_package_material' => null,
			'pallet_hi' => null,
			'pallet_cases_per_layer' => null,
			'pallet_weight' => null,
			'pallet_weight_uom' => null,
			'pallet_height' => null,
			'pallet_dimension_uom' => null,
			'pallet_cubic_feet' => null,
			'pallet_package_type' => null,
			'container_20' => null,
			'container_40' => null,
			'shipment_lead_time' => null,
			'shelf_life' => null,
			'shelf_life_pickup' => null,
			'shipping_storeage_id' => null,
			'storage_requirement' => null,
			'hts' => null,
			'date_code' => null,
			'item_ordering' => null,
			'min_total_order' => null,
			'size_variations' => null,
			'claim_dairy_free' => null,
			'claim_fair_trade' => null,
			'claim_gluten_free' => null,
			'claim_grain_free' => null,
			'claim_halai' => null,
			'claim_ketogenic' => null,
			'claim_kosher' => null,
			'claim_low_carb' => null,
			'claim_non_gmo' => null,
			'claim_non_gmo_verified' => null,
			'claim_nut_free' => null,
			'claim_organic' => null,
			'claim_paleo' => null,
			'claim_plant_based' => null,
			'organic_certifier' => null,
			'claim_vegan' => null,
			'claim_vegetarian' => null,
			'claim_wheat_free' => null,
			'allergens' => null,
			'allergens_ancillary' => null,
			'code_date_example' => null,
			'contains' => null,
			'does_not_contain' => null,
			'product_of' => null,
			'country_of_origin' => null,
			'status' => null,
			'incoterms_id' => null,
			'shipping_provider_id' => null,
			'brand_id' => null,
			'ix_one_created' => null,
			'ix_one_modified' => null,
			'spins_group' => null,
			'spins_category' => null,
			'spins_subcategory' => null,
			'ecommerce_name_a' => null,
			'item_romance_description' => null,
			'out_of_stock' => null,
			'temperature_min' => null,
			'temperature_max' => null,
			'temperature_uom' => null,
			'created' => null,
			'modified' => null,
			'slug' => null,
			'meta_title' => null,
			'meta_description' => null,
			'public' => null,
			'featured' => null,
			'best_selling_product' => null,
			'mfg_state' => null,
			'innerpack_qty' => null,
			'total_units_per_master_case' => null,
			'product_type' => null,
			'private_label' => null,
			'expected_date_in_stock' => null,
			'auto_in_stock' => null,
			'out_of_stock_date' => null,
			'out_of_stock_reason' => null,
			'made_in' => null,
			'list_case_price' => null,
			'brand_name' => null,
			'pallet_only' => null,
			'samples_allowed' => null,
			'us_brand' => null,
			'brand_country' => null,
			'made_in_country' => null,
			'profile_and_user_approved' => '0',
			'search_relevance' => '100',
			'metric_name' => null,
			'standard_name' => null,
			'metric_name_short' => null,
			'standard_name_short' => null,
			'standard_size' => null,
			'metric_size' => null,
			'standard_size_uom' => null,
			'metric_size_uom' => null,
			'standard_unit_weight' => null,
			'metric_unit_weight' => null,
			'standard_unit_weight_uom' => null,
			'metric_unit_weight_uom' => null,
			'standard_case_weight' => null,
			'metric_case_weight' => null,
			'standard_case_weight_uom' => null,
			'metric_case_weight_uom' => null,
			'standard_pallet_weight' => null,
			'metric_pallet_weight' => null,
			'standard_pallet_weight_uom' => null,
			'metric_pallet_weight_uom' => null,
			'standard_unit_dimensions' => null,
			'standard_unit_length' => null,
			'standard_unit_width' => null,
			'standard_unit_height' => null,
			'standard_unit_dimension_uom' => null,
			'metric_unit_dimensions' => null,
			'metric_unit_length' => null,
			'metric_unit_width' => null,
			'metric_unit_height' => null,
			'metric_unit_dimension_uom' => null,
			'standard_case_dimensions' => null,
			'standard_case_length' => null,
			'standard_case_width' => null,
			'standard_case_height' => null,
			'standard_case_dimension_uom' => null,
			'standard_pallet_height' => null,
			'standard_pallet_dimension_uom' => null,
			'metric_case_dimensions' => null,
			'metric_case_length' => null,
			'metric_case_width' => null,
			'metric_case_height' => null,
			'metric_case_dimension_uom' => null,
			'metric_pallet_height' => null,
			'metric_pallet_dimension_uom' => null,
			'metric_temperature_min' => null,
			'metric_temperature_max' => null,
			'metric_temperature_uom' => 'Celsius',
			'standard_temperature_min' => null,
			'standard_temperature_max' => null,
			'standard_temperature_uom' => 'Fahrenheit'
		),
		'Category' => array(
			'id' => '1',
			'parent_id' => null,
			'title' => 'Grocery & Gourmet Foods',
			'slug' => 'grocery_and_gourmet_foods',
			'description' => 'Grocery & Gourmet Foods',
			'icon' => 'mini-cart.svg',
			'icon_dir' => null,
			'cover' => 'cat_bg_grocery.png',
			'cover_dir' => null,
			'banner' => null,
			'is_public' => true,
			'sort' => null,
			'created' => '2018-09-07 14:43:28',
			'modified' => '2019-07-02 16:17:43'
		),
		'SubCategory' => array(
			'id' => '2',
			'parent_id' => '1',
			'title' => 'Beverages',
			'slug' => 'beverages',
			'description' => 'Beverages',
			'icon' => 'beverages.png',
			'icon_dir' => null,
			'cover' => 'beverages-hero.png',
			'cover_dir' => null,
			'banner' => null,
			'is_public' => true,
			'sort' => null,
			'created' => null,
			'modified' => '2019-08-28 09:07:46'
		),
		'ShippingStorage' => array(
			'id' => '1',
			'storage_location' => 'Ambient'
		),
		'Brand' => array(
			'id' => '56',
			'name' => 'Waterloo ',
			'slug' => 'waterloo-',
			'logo' => 'WL_logo-MAIN_1 (2).png',
			'main_banner' => 'Banner_1134.124_1.png',
			'sub_banner_1' => null,
			'sub_banner_2' => null,
			'sub_banner_3' => null,
			'sub_banner_4' => null,
			'website' => 'https://www.drinkwaterloo.com/',
			'facebook' => 'https://www.facebook.com/waterloosparkling',
			'pinterest' => '',
			'twitter' => 'https://twitter.com/DoYouWaterloo',
			'instagram' => 'https://www.instagram.com/waterloosparkling/',
			'youtube' => '',
			'promo_video' => '',
			'promo_video_1' => '',
			'promo_video_2' => '',
			'about' => 'All Waterloo’s natural flavor ingredients are derived from non-GMO, vegan sources. Oils, extracts, or essences from the named fruit (or fruits) on each variety are paired with complementary flavors to build our unique, bold taste profile. Using these powerful extracts and oils allows us to pack a lot of flavor without any sugar, sweeteners, or other unwanted additives.',
			'grovara_comments' => 'Grovara can not pursue international Costcos. ',
			'policies' => '',
			'policies_modified' => '2021-06-22 11:57:31',
			'payment' => '',
			'spins_metric_type_1' => 'Sales',
			'spins_title_description_1' => 'YOY',
			'spins_metric_1' => '$112.3M',
			'spins_channel_1' => 'Natural & Organic',
			'spins_channel_subtext_1' => '',
			'spins_metric_type_2' => 'Growth Dollars',
			'spins_title_description_2' => 'YOY',
			'spins_metric_2' => '49%',
			'spins_channel_2' => 'Natural & Organic',
			'spins_channel_subtext_2' => '',
			'spins_scorecard' => null,
			'promoted_products' => '',
			'active' => true,
			'samples_allowed' => true,
			'product_sort' => '["200060","200040","200600","200760","200250","200260","200070","200130","200570","200200","200110","200700","200730","200210","200140","201100","201030","200580","G020969","202070","202060","202100","202090"]',
			'meta_title' => 'Waterloo ',
			'meta_description' => 'All Waterloo’s natural flavor ingredients are derived from non-GMO, vegan sources. Oils, extracts, or essences from the named fruit (or fruits) on each variety are paired with complementary flavors to build our unique, bold taste profile. Using these powerful extracts and oils allows us to pack a lot of flavor without any sugar, sweeteners, or other unwanted additives.',
			'created' => '2020-09-30 14:57:43',
			'modified' => '2023-03-13 12:31:54',
			'spins_metric_3' => '#32',
			'spins_metric_type_3' => 'Out of 945',
			'spins_title_description_3' => 'YOY',
			'spins_channel_3' => 'Shelf Stable Water',
			'spins_channel_subtext_3' => '',
			'brochure_1' => 'Waterloo_Presentation_7_28_2021.pdf',
			'brochure_2' => 'Waterloo2022BrandOverview081022.pptx',
			'brochure_3' => '',
			'mkt_support' => false,
			'mkt_support_text' => '',
			'bracket_pricing_1' => null,
			'bracket_pricing_2' => null,
			'offers_terms' => 'yes',
			'offers_terms_text' => '',
			'allow_pallet_height_70' => false,
			'brand_country' => 'US'
		),
		'ProductCategory' => array(),
		'ProductImage' => array(),
		'ChildProduct' => array(),
		'MerchPalletProduct' => array(),
		'NotifyInStock' => array()
	)
)
$profile = array(
	'Profile' => array(
		'id' => '365',
		'full_name' => 'Nate  Bernstein',
		'business_name' => 'Waterloo ',
		'legal_company_name' => 'Waterloo ',
		'job_title' => '',
		'tin' => '111111111',
		'address_1' => '2612 East Cesar Chavez Street ',
		'address_2' => 'Suite 200 ',
		'city' => 'Austin ',
		'country' => 'US',
		'state' => 'TX',
		'postal_code' => '78702',
		'business_phone' => '(512) 910- 8990',
		'mobile_phone' => null,
		'company_website' => 'www.drinkwaterloo.com',
		'made_in_usa' => true,
		'whse_address_1' => 'Refresco',
		'whse_address_2' => '2525 Schuetz Rd',
		'whse_city' => 'Maryland Heights',
		'whse_state' => 'MO',
		'whse_postal_code' => '63043',
		'whse_country' => 'US',
		'categories' => '',
		'created' => '2020-09-30 14:57:43',
		'modified' => '2023-03-13 12:31:54',
		'active' => true,
		'approved' => true,
		'user_id' => '437',
		'buyer_type' => null,
		'categories_of_interest' => null,
		'grovara_buyer_rep_1' => null,
		'grovara_buyer_rep_2' => null,
		'grovara_brand_rep_1' => '795',
		'grovara_brand_rep_2' => null,
		'messages_rep' => null,
		'measurement_type' => 'STANDARD',
		'shipping_type_id' => '5',
		'shipping_mode_id' => '1',
		'incoterm_id' => '1',
		'finterm_id' => '4',
		'accepted_finterm_ids' => null,
		'required_finterm_id' => null,
		'accepted_terms' => false,
		'accepted_accrual' => false,
		'status' => '2',
		'status_reason' => '',
		'status_date' => '2021-05-28 11:06:19',
		'status_submitted_by' => '1',
		'created_by_grovara' => false,
		'hubspot_id' => '2458727162',
		'moq' => 'One pallet per flavor MOQ ',
		'allow_terms' => false,
		'exclusive_brand_id' => null,
		'prohibited_brand_id' => null,
		'available_finterms' => 'Net 30, Net 21, Net 15, Cash Advance'
	)
)
$faqs = array(
	(int) 0 => array(
		'BrandFaq' => array(
			'id' => '91',
			'brand_id' => '56',
			'question' => 'What’s the best way to drink Waterloo?',
			'answer' => 'Enjoy ice-cold! Our flavor team crafted Waterloo to be served chilled, so we recommend refrigerating before popping the tab. It will be worth the wait!'
		)
	),
	(int) 1 => array(
		'BrandFaq' => array(
			'id' => '92',
			'brand_id' => '56',
			'question' => 'What are Waterloo’s natural flavors?',
			'answer' => 'All Waterloo’s natural flavor ingredients are derived from non-GMO, vegan sources. Oils, extracts, or essences from the named fruit (or fruits) on each variety are paired with complementary flavors to build our unique, bold taste profile.'
		)
	),
	(int) 2 => array(
		'BrandFaq' => array(
			'id' => '93',
			'brand_id' => '56',
			'question' => 'Is Waterloo made with purified water?',
			'answer' => 'Before carbonation and canning, our water undergoes a multi-step filtration process to ensure a pure product for you. Our water is free of fluoride, sodium, and other additives/impurities before we add our flavors and carbonate.'
		)
	)
)
$interests = array(
	(int) 0 => array(
		(int) 0 => 'Dairy Free',
		(int) 1 => 'claim_dairy_free',
		(int) 2 => (int) 0
	),
	(int) 1 => array(
		(int) 0 => 'Fair Trade',
		(int) 1 => 'claim_fair_trade',
		(int) 2 => (int) 0
	),
	(int) 2 => array(
		(int) 0 => 'Gluten Free',
		(int) 1 => 'claim_gluten_free',
		(int) 2 => (int) 21
	),
	(int) 3 => array(
		(int) 0 => 'Grain Free',
		(int) 1 => 'claim_grain_free',
		(int) 2 => (int) 0
	),
	(int) 4 => array(
		(int) 0 => 'Halal',
		(int) 1 => 'claim_halai',
		(int) 2 => (int) 0
	),
	(int) 5 => array(
		(int) 0 => 'Kosher',
		(int) 1 => 'claim_kosher',
		(int) 2 => (int) 21
	),
	(int) 6 => array(
		(int) 0 => 'Low Carb',
		(int) 1 => 'claim_low_carb',
		(int) 2 => (int) 0
	),
	(int) 7 => array(
		(int) 0 => 'Non GMO',
		(int) 1 => 'claim_non_gmo',
		(int) 2 => (int) 21
	),
	(int) 8 => array(
		(int) 0 => 'Nut Free',
		(int) 1 => 'claim_nut_free',
		(int) 2 => (int) 0
	),
	(int) 9 => array(
		(int) 0 => 'Organic',
		(int) 1 => 'claim_organic',
		(int) 2 => (int) 0
	),
	(int) 10 => array(
		(int) 0 => 'Paleo',
		(int) 1 => 'claim_paleo',
		(int) 2 => (int) 0
	),
	(int) 11 => array(
		(int) 0 => 'Plant Based',
		(int) 1 => 'claim_plant_based',
		(int) 2 => (int) 0
	),
	(int) 12 => array(
		(int) 0 => 'Vegan',
		(int) 1 => 'claim_vegan',
		(int) 2 => (int) 21
	),
	(int) 13 => array(
		(int) 0 => 'Vegetarian',
		(int) 1 => 'claim_vegetarian',
		(int) 2 => (int) 0
	),
	(int) 14 => array(
		(int) 0 => 'Wheat Free',
		(int) 1 => 'claim_wheat_free',
		(int) 2 => (int) 0
	)
)
$additional_whses = array(
	(int) 0 => array(
		'BrandWarehouse' => array(
			'id' => '17',
			'brand_id' => '56',
			'address_1' => 'Refresco',
			'address_2' => '103 Commerce Drive',
			'city' => 'Aston',
			'state' => 'PA',
			'postal_code' => '19014',
			'country' => 'US',
			'created' => '2021-08-12 16:27:36',
			'modified' => '2021-08-12 16:27:36'
		)
	),
	(int) 1 => array(
		'BrandWarehouse' => array(
			'id' => '18',
			'brand_id' => '56',
			'address_1' => 'Refresco',
			'address_2' => '5210 S 16th Ave',
			'city' => 'Tampa',
			'state' => 'FL',
			'postal_code' => '33619',
			'country' => 'US',
			'created' => '2021-08-12 16:28:26',
			'modified' => '2021-08-12 16:28:26'
		)
	),
	(int) 2 => array(
		'BrandWarehouse' => array(
			'id' => '19',
			'brand_id' => '56',
			'address_1' => 'Refresco',
			'address_2' => '15200 Trinity Blvd',
			'city' => 'Forth Worth',
			'state' => 'TX',
			'postal_code' => '76155',
			'country' => 'US',
			'created' => '2021-08-12 16:29:14',
			'modified' => '2021-08-12 16:29:14'
		)
	),
	(int) 3 => array(
		'BrandWarehouse' => array(
			'id' => '20',
			'brand_id' => '56',
			'address_1' => 'Refresco',
			'address_2' => '631 Waterman Ave',
			'city' => 'San Bernardino',
			'state' => 'CA',
			'postal_code' => '92408',
			'country' => 'US',
			'created' => '2021-08-12 16:30:08',
			'modified' => '2021-08-12 16:30:08'
		)
	)
)
$description_for_layout = 'All Waterloo’s natural flavor ingredients are derived from non-GMO, vegan sources. Oils, extracts, or essences from the named fruit (or fruits) on each variety are paired with complementary flavors to build our unique, bold taste profile. Using these powerful extracts and oils allows us to pack a lot of flavor without any sugar, sweeteners, or other unwanted additives.'
$title_for_layout = 'Waterloo '
$user_measurement_type = 'STANDARD'
$activeUserAcceptedTos = (int) 0
$access_level = ''
$user = array()
$custom_items = null
$gtm_user_type = 'unassigned'
$activeUser = null
$cart = null
$use_brand_subs = false
$have_spins_1 = true
$have_spins_2 = true
$have_spins_3 = true
$interestKey = array(
	(int) 0 => 'Dairy Free',
	(int) 1 => 'claim_dairy_free',
	(int) 2 => (int) 0
)
$interest = (int) 0
$total_count = null
include - APP/View/Sellers/brands.ctp, line 163
View::_evaluate() - CORE/Cake/View/View.php, line 971
View::_render() - CORE/Cake/View/View.php, line 933
View::render() - CORE/Cake/View/View.php, line 473
Controller::render() - CORE/Cake/Controller/Controller.php, line 963
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 200
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 107

Download