updating zero price items to be ignored...<br>done...<br>looking for categories to import...<br>Categories to import:<br>Brandy and Cognac<br>category already exists, not creating Brandy and Cognac category.<br>getting category key...35<br>Now importing menu items for Brandy and Cognac category...35 <br>select * from Sheet1 where ignored='0' AND imported='0' and Category='Brandy and Cognac'<br>query5 ok......more than zero rows......qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Brandy and Cognac' AND itemName='Christian Brothers - 750ML'...importing single size for Christian Brothers - 750ML (). <br>item already exists. <br>itemkey:294...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Brandy and Cognac' AND itemName='Christian Brothers VS - 1.75L'...importing single size for Christian Brothers VS - 1.75L (1.75L). <br>item already exists. <br>itemkey:295...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Brandy and Cognac' AND itemName='Christian Brothers VS - 1L'...importing single size for Christian Brothers VS - 1L (1.0L). <br>item already exists. <br>itemkey:296...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Brandy and Cognac' AND itemName='Courvoisier VS - 750.0ml'...importing single size for Courvoisier VS - 750.0ml (750.0ml). <br>item already exists. <br>itemkey:297...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Brandy and Cognac' AND itemName='E & J - 1.75L'...importing single size for E & J - 1.75L (). <br>item already exists. <br>itemkey:298...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Brandy and Cognac' AND itemName='E&J VS - 1L'...importing single size for E&J VS - 1L (50.0ml). <br>item already exists. <br>itemkey:299...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Brandy and Cognac' AND itemName='E&J VS - 750.0ml'...importing single size for E&J VS - 750.0ml (750.0ml). <br>item already exists. <br>itemkey:300...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Brandy and Cognac' AND itemName='Hartley VSOP 50ML'...importing single size for Hartley VSOP 50ML (). <br>item already exists. <br>itemkey:301...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Brandy and Cognac' AND itemName='Hennessy Vs - 200ml'...importing single size for Hennessy Vs - 200ml (). <br>item already exists. <br>itemkey:302...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Brandy and Cognac' AND itemName='Hennessy VS - 375.0ml'...importing single size for Hennessy VS - 375.0ml (375.0ml). <br>item already exists. <br>itemkey:303...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Brandy and Cognac' AND itemName='Hennessy VS - 750.0ml'...importing single size for Hennessy VS - 750.0ml (750.0ml). <br>item already exists. <br>itemkey:304...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Brandy and Cognac' AND itemName='Hennessy VS 1L'...importing single size for Hennessy VS 1L (). <br>item already exists. <br>itemkey:305Cider<br>category already exists, not creating Cider category.<br>getting category key...36<br>Now importing menu items for Cider category...36 <br>select * from Sheet1 where ignored='0' AND imported='0' and Category='Cider'<br>query5 ok......more than zero rows......qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Cider' AND itemName='Angry Orchard Crisp Apple - 6 pack, 12 oz bottles'...importing single size for Angry Orchard Crisp Apple - 6 pack, 12 oz bottles (6 pack, 12 oz bottles). <br>item already exists. <br>itemkey:306...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Cider' AND itemName='Redd's Apple Ale - 6 pack, 12 oz bottles'...Craft Beer<br>category already exists, not creating Craft Beer category.<br>getting category key...37<br>Now importing menu items for Craft Beer category...37 <br>select * from Sheet1 where ignored='0' AND imported='0' and Category='Craft Beer'<br>query5 ok......more than zero rows......qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Craft Beer' AND itemName='Bell's Two Hearted 4-16oz Cans'......qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Craft Beer' AND itemName='Bells Two Heated 12 Cans'...importing single size for Bells Two Heated 12 Cans (). <br>item already exists. <br>itemkey:307...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Craft Beer' AND itemName='Bent Paddle 14 ESB Extra Amber - 6 pack, cans'...importing single size for Bent Paddle 14 ESB Extra Amber - 6 pack, cans (). <br>item already exists. <br>itemkey:308...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Craft Beer' AND itemName='Bent Paddle Black Ale - 6 pack, cans'...importing single size for Bent Paddle Black Ale - 6 pack, cans (). <br>item already exists. <br>itemkey:309...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Craft Beer' AND itemName='Bent Paddle Pilsner - 6 pack, cans'...importing single size for Bent Paddle Pilsner - 6 pack, cans (). <br>item already exists. <br>itemkey:310...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Craft Beer' AND itemName='Deschutes Fresh Haze IPA - 12 pack, 12 oz cans'...importing single size for Deschutes Fresh Haze IPA - 12 pack, 12 oz cans (12 pack, 12 oz cans). <br>item already exists. <br>itemkey:311...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Craft Beer' AND itemName='Deschutes Fresh Squeezed IPA - 6 pack, 12 oz bottles'...importing single size for Deschutes Fresh Squeezed IPA - 6 pack, 12 oz bottles (6 pack, 12 oz bottles). <br>item already exists. <br>itemkey:312...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Craft Beer' AND itemName='Founders All Day IPA 15 Cans'...importing single size for Founders All Day IPA 15 Cans (). <br>item already exists. <br>itemkey:313...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Craft Beer' AND itemName='Founders Centennal 15 Can'...importing single size for Founders Centennal 15 Can (). <br>item already exists. <br>itemkey:314...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Craft Beer' AND itemName='Fulton Lonely Blonde - Bottle - 12 pack, 12 oz cans'...importing single size for Fulton Lonely Blonde - Bottle - 12 pack, 12 oz cans (). <br>item already exists. <br>itemkey:315...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Craft Beer' AND itemName='Fulton Lonely Blonde - Bottle - 6 pack, 12 oz bottles'...importing single size for Fulton Lonely Blonde - Bottle - 6 pack, 12 oz bottles (6 pack, 12 oz bottles). <br>item already exists. <br>itemkey:316...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Craft Beer' AND itemName='Fulton Sweet Child of Vine - 12 pack, 12 oz cans'...importing single size for Fulton Sweet Child of Vine - 12 pack, 12 oz cans (12 pack, 12 oz cans). <br>item already exists. <br>itemkey:317...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Craft Beer' AND itemName='Kona Big Wave Golden Ale - 12 pack, 12 oz cans'...importing single size for Kona Big Wave Golden Ale - 12 pack, 12 oz cans (12 pack, 12 oz cans). <br>item already exists. <br>itemkey:318...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Craft Beer' AND itemName='Lift Bridge Mango 6 Can'...importing single size for Lift Bridge Mango 6 Can (). <br>item already exists. <br>itemkey:319...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Craft Beer' AND itemName='New Belgium Fat Tire Amber ale - 6 pack, can'...importing single size for New Belgium Fat Tire Amber ale - 6 pack, can (). <br>item already exists. <br>itemkey:320...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Craft Beer' AND itemName='New Belgium Imperial - 6 pack, 12 oz bottles'...importing single size for New Belgium Imperial - 6 pack, 12 oz bottles (). <br>item already exists. <br>itemkey:321...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Craft Beer' AND itemName='New Belgium Voodoo Ranger 1985 - 6pack cans'...importing single size for New Belgium Voodoo Ranger 1985 - 6pack cans (). <br>item already exists. <br>itemkey:322...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Craft Beer' AND itemName='New Belgium Voodoo Ranger Juicy Haze - 6pack cans'...importing single size for New Belgium Voodoo Ranger Juicy Haze - 6pack cans (). <br>item already exists. <br>itemkey:323...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Craft Beer' AND itemName='Sierra Nevada Pale Ale - 12 pack, 12 oz cans'...importing single size for Sierra Nevada Pale Ale - 12 pack, 12 oz cans (12 pack, 12 oz cans). <br>item already exists. <br>itemkey:324...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Craft Beer' AND itemName='Summit Extra Pale Ale - 12 pack, 12 oz bottles'...importing single size for Summit Extra Pale Ale - 12 pack, 12 oz bottles (12 pack, 12 oz bottles). <br>item already exists. <br>itemkey:325...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Craft Beer' AND itemName='Summit Extra Pale Ale - 12 pack, 12 oz cans'...importing single size for Summit Extra Pale Ale - 12 pack, 12 oz cans (12 pack, 12 oz cans). <br>item already exists. <br>itemkey:326...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Craft Beer' AND itemName='Summit House Party- 12 pack, 12 oz cans'...importing single size for Summit House Party- 12 pack, 12 oz cans (). <br>item already exists. <br>itemkey:327...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Craft Beer' AND itemName='Summit Saga IPA - 6 pack, 12 oz bottles'...importing single size for Summit Saga IPA - 6 pack, 12 oz bottles (6 pack, 12 oz bottles). <br>item already exists. <br>itemkey:328...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Craft Beer' AND itemName='Summit Saga IPA 12 Cans'...importing single size for Summit Saga IPA 12 Cans (). <br>item already exists. <br>itemkey:329...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Craft Beer' AND itemName='Surly Furious - 12 pack, 12 oz cans'...importing single size for Surly Furious - 12 pack, 12 oz cans (12 pack, 12 oz cans). <br>item already exists. <br>itemkey:330...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Craft Beer' AND itemName='Surly Furious - 4 pack, 16 oz cans'...importing single size for Surly Furious - 4 pack, 16 oz cans (4 pack, 16 oz cans). <br>item already exists. <br>itemkey:331...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Craft Beer' AND itemName='Surly Furious - 6 pack, 12 cans'...importing single size for Surly Furious - 6 pack, 12 cans (6 pack, 12 cans). <br>item already exists. <br>itemkey:332...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Craft Beer' AND itemName='Surly Furious IPA 6 Can'...importing single size for Surly Furious IPA 6 Can (). <br>item already exists. <br>itemkey:333...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Craft Beer' AND itemName='Surly Grapefruit Supreme - 12 pack, 12 oz cans'...importing single size for Surly Grapefruit Supreme - 12 pack, 12 oz cans (). <br>item already exists. <br>itemkey:334...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Craft Beer' AND itemName='Surly Sample-Variety/SSNL - 12 pack, 12 oz cans'...importing single size for Surly Sample-Variety/SSNL - 12 pack, 12 oz cans (12 pack, 12 oz cans). <br>item already exists. <br>itemkey:335...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Craft Beer' AND itemName='Surly Xtra Citra Pale Ale - 12 pack, 12 oz cans'...importing single size for Surly Xtra Citra Pale Ale - 12 pack, 12 oz cans (12 pack, 12 oz cans). <br>item already exists. <br>itemkey:336Domestic Beer<br>category already exists, not creating Domestic Beer category.<br>getting category key...38<br>Now importing menu items for Domestic Beer category...38 <br>select * from Sheet1 where ignored='0' AND imported='0' and Category='Domestic Beer'<br>query5 ok......more than zero rows......qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Domestic Beer' AND itemName='Blue Moon - 12 pack, 12 oz. bottles'...importing single size for Blue Moon - 12 pack, 12 oz. bottles (12 pack, 12 oz. bottles). <br>item already exists. <br>itemkey:337...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Domestic Beer' AND itemName='Blue Moon - 6 pack, 12 oz. bottles'...importing single size for Blue Moon - 6 pack, 12 oz. bottles (6 pack, 12 oz. bottles). <br>item already exists. <br>itemkey:338...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Domestic Beer' AND itemName='Blue Moon 15 Can'...importing single size for Blue Moon 15 Can (). <br>item already exists. <br>itemkey:339...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Domestic Beer' AND itemName='Blue Moon Mango 6 Bottles'...importing single size for Blue Moon Mango 6 Bottles (). <br>item already exists. <br>itemkey:340...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Domestic Beer' AND itemName='Budweiser - 12 pack, 12 oz cans'...importing single size for Budweiser - 12 pack, 12 oz cans (12 pack, 12 oz cans). <br>item already exists. <br>itemkey:341...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Domestic Beer' AND itemName='Budweiser - 24 pack, 12 oz cans'...importing single size for Budweiser - 24 pack, 12 oz cans (24 pack, 12 oz cans). <br>item already exists. <br>itemkey:342...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Domestic Beer' AND itemName='Budweiser - 6 pack, 16 oz cans'...importing single size for Budweiser - 6 pack, 16 oz cans (). <br>item already exists. <br>itemkey:343...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Domestic Beer' AND itemName='Budweiser 24PK 16oz Cans'...importing single size for Budweiser 24PK 16oz Cans (). <br>item already exists. <br>itemkey:344...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Domestic Beer' AND itemName='Busch - 24 pack, 12 oz cans'...importing single size for Busch - 24 pack, 12 oz cans (24 pack, 12 oz cans). <br>item already exists. <br>itemkey:345...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Domestic Beer' AND itemName='Castle Danger Cream Ale - 6 pack, 12 oz cans'...importing single size for Castle Danger Cream Ale - 6 pack, 12 oz cans (6 pack, 12 oz cans). <br>item already exists. <br>itemkey:346...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Domestic Beer' AND itemName='Colt 45 24oz'...importing single size for Colt 45 24oz (). <br>item already exists. <br>itemkey:347...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Domestic Beer' AND itemName='Coors Banquet - 12 pack, 12 oz bottles'...importing single size for Coors Banquet - 12 pack, 12 oz bottles (12 pack, 12 oz bottles). <br>item already exists. <br>itemkey:348...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Domestic Beer' AND itemName='Coors Banquet - 12 pack, 12 oz cans'...importing single size for Coors Banquet - 12 pack, 12 oz cans (12 pack, 12 oz cans). <br>item already exists. <br>itemkey:349...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Domestic Beer' AND itemName='Coors Banquet - 24 pack, 12 oz cans'...importing single size for Coors Banquet - 24 pack, 12 oz cans (24 pack, 12 oz cans). <br>item already exists. <br>itemkey:350...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Domestic Beer' AND itemName='Grain Belt Nordeast - 12 pack, 12 oz bottles'...importing single size for Grain Belt Nordeast - 12 pack, 12 oz bottles (12 pack, 12 oz bottles). <br>item already exists. <br>itemkey:351...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Domestic Beer' AND itemName='Grain Belt Nordeast - 12 pack, 16 oz cans'...importing single size for Grain Belt Nordeast - 12 pack, 16 oz cans (12 pack, 16 oz cans). <br>item already exists. <br>itemkey:352...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Domestic Beer' AND itemName='Grain Belt Premium - 12 pack, 12 oz bottles'...importing single size for Grain Belt Premium - 12 pack, 12 oz bottles (12 pack, 12 oz bottles). <br>item already exists. <br>itemkey:353...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Domestic Beer' AND itemName='Grain Belt Premium - 12 pack, 16 oz cans'...importing single size for Grain Belt Premium - 12 pack, 16 oz cans (12 pack, 16 oz cans). <br>item already exists. <br>itemkey:354...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Domestic Beer' AND itemName='Grain Belt Premium - 24 pack, 12 oz cans'...importing single size for Grain Belt Premium - 24 pack, 12 oz cans (24 pack, 12 oz cans). <br>item already exists. <br>itemkey:355...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Domestic Beer' AND itemName='Hamm's - 30 pack, 12 oz cans'......qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Domestic Beer' AND itemName='Icehouse 24 Oz'...importing single size for Icehouse 24 Oz (). <br>item already exists. <br>itemkey:356...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Domestic Beer' AND itemName='Icehouse - 12 pack, 12 oz cans'...importing single size for Icehouse - 12 pack, 12 oz cans (12 pack, 12 oz cans). <br>item already exists. <br>itemkey:357...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Domestic Beer' AND itemName='Icehouse - 24 pack, 12 oz cans'...importing single size for Icehouse - 24 pack, 12 oz cans (24 pack, 12 oz cans). <br>item already exists. <br>itemkey:358...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Domestic Beer' AND itemName='Keystone Ice - 15 pack, 12 oz cans'...importing single size for Keystone Ice - 15 pack, 12 oz cans (15 pack, 12 oz cans). <br>item already exists. <br>itemkey:359...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Domestic Beer' AND itemName='Keystone Ice 24 oz'...importing single size for Keystone Ice 24 oz (). <br>item already exists. <br>itemkey:360...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Domestic Beer' AND itemName='Leinenkugel's Honey Weiss - 12 pack, 12 oz bottles'......qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Domestic Beer' AND itemName='Leinenkugel's Honey Weiss - 6 pack, 12 oz bottles'......qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Domestic Beer' AND itemName='Leinenkugel's Original - 12 pack, 12 oz cans'......qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Domestic Beer' AND itemName='Leinenkugel's Summer Shandy/SNL - 6 pack, 12 oz bottles'......qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Domestic Beer' AND itemName='Michelob Golden Draft - 24 pack, 12 oz cans'...importing single size for Michelob Golden Draft - 24 pack, 12 oz cans (24 pack, 12 oz cans). <br>item already exists. <br>itemkey:361...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Domestic Beer' AND itemName='Miller High Life - 12 pack, 12 oz bottles'...importing single size for Miller High Life - 12 pack, 12 oz bottles (). <br>item already exists. <br>itemkey:362...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Domestic Beer' AND itemName='Miller High Life - 12 pack, 12 oz cans'...importing single size for Miller High Life - 12 pack, 12 oz cans (12 pack, 12 oz cans). <br>item already exists. <br>itemkey:363...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Domestic Beer' AND itemName='Miller High Life - 24 pack, 12 oz cans'...importing single size for Miller High Life - 24 pack, 12 oz cans (24 pack, 12 oz cans). <br>item already exists. <br>itemkey:364...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Domestic Beer' AND itemName='Milwaukee's Best Ice - 24 pack, 12 oz cans'......qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Domestic Beer' AND itemName='Pabst Blue Ribbon - 12 pack, 12 oz cans'...importing single size for Pabst Blue Ribbon - 12 pack, 12 oz cans (12 pack, 12 oz cans). <br>item already exists. <br>itemkey:365...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Domestic Beer' AND itemName='Pabst Blue Ribbon - 24 pack, cans'...importing single size for Pabst Blue Ribbon - 24 pack, cans (). <br>item already exists. <br>itemkey:366...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Domestic Beer' AND itemName='Special Export - 30 pack, cans'...importing single size for Special Export - 30 pack, cans (). <br>item already exists. <br>itemkey:367Gin<br>category already exists, not creating Gin category.<br>getting category key...39<br>Now importing menu items for Gin category...39 <br>select * from Sheet1 where ignored='0' AND imported='0' and Category='Gin'<br>query5 ok......more than zero rows......qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Gin' AND itemName='Beefeater London Dry - 1.75L'...importing single size for Beefeater London Dry - 1.75L (1.75L). <br>item already exists. <br>itemkey:368...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Gin' AND itemName='Beefeater London Dry - 1L'...importing single size for Beefeater London Dry - 1L (1L). <br>item already exists. <br>itemkey:369...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Gin' AND itemName='BOMBAY Sapphire - 1.75L'...importing single size for BOMBAY Sapphire - 1.75L (1.75L). <br>item already exists. <br>itemkey:370...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Gin' AND itemName='BOMBAY Sapphire - 1L'...importing single size for BOMBAY Sapphire - 1L (1L). <br>item already exists. <br>itemkey:371...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Gin' AND itemName='Fleischman's - 1.75L'......qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Gin' AND itemName='Fleischman's - 750.0ml'......qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Gin' AND itemName='Seagram's Extra Dry - 1L'......qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Gin' AND itemName='Tanqueray London Dry - 1.75L'...importing single size for Tanqueray London Dry - 1.75L (1.75L). <br>item already exists. <br>itemkey:372...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Gin' AND itemName='Tanqueray London Dry - 1L'...importing single size for Tanqueray London Dry - 1L (1L). <br>item already exists. <br>itemkey:373Hard Seltzer<br>category already exists, not creating Hard Seltzer category.<br>getting category key...40<br>Now importing menu items for Hard Seltzer category...40 <br>select * from Sheet1 where ignored='0' AND imported='0' and Category='Hard Seltzer'<br>query5 ok......more than zero rows......qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Hard Seltzer' AND itemName='Bud Light Sample Seltzer - 12pack, 12 oz cans'...importing single size for Bud Light Sample Seltzer - 12pack, 12 oz cans (). <br>item already exists. <br>itemkey:374...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Hard Seltzer' AND itemName='Bud Light Seltzer Black Cherry - 12pack, 12 oz cans'...importing single size for Bud Light Seltzer Black Cherry - 12pack, 12 oz cans (12pack, 12 oz cans). <br>item already exists. <br>itemkey:375...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Hard Seltzer' AND itemName='Bud Light Seltzer Lemon Lime - 12pack, 12 oz cans'...importing single size for Bud Light Seltzer Lemon Lime - 12pack, 12 oz cans (12pack, 12 oz cans). <br>item already exists. <br>itemkey:376...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Hard Seltzer' AND itemName='Bud Light Seltzer Strawberry - 12pack, 12 oz cans'...importing single size for Bud Light Seltzer Strawberry - 12pack, 12 oz cans (12pack, 12 oz cans). <br>item already exists. <br>itemkey:377...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Hard Seltzer' AND itemName='Bud Light Seltzer Variety - 12pack, 12 oz cans'...importing single size for Bud Light Seltzer Variety - 12pack, 12 oz cans (12pack, 12 oz cans). <br>item already exists. <br>itemkey:378...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Hard Seltzer' AND itemName='Corona Variety Pack - 12pack, 12 oz cans'...importing single size for Corona Variety Pack - 12pack, 12 oz cans (12pack, 12 oz cans). <br>item already exists. <br>itemkey:379...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Hard Seltzer' AND itemName='Fulton Orange Seltzer 6 pack, Can'...importing single size for Fulton Orange Seltzer 6 pack, Can (). <br>item already exists. <br>itemkey:380...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Hard Seltzer' AND itemName='Mike's Hard Blackcherry - 6 pack, 12 oz bottles'......qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Hard Seltzer' AND itemName='Mike's Hard Lemonade Variety - 12pack, 12 oz cans'......qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Hard Seltzer' AND itemName='Mike's Hard Raspberry - 6 pack, 12 oz bottles'......qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Hard Seltzer' AND itemName='Mike's Hard Strawberry Lemonade - 6 pack, 12 oz bottles'......qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Hard Seltzer' AND itemName='PRESS Grapefruit 6 pack, cans'...importing single size for PRESS Grapefruit 6 pack, cans (). <br>item already exists. <br>itemkey:381...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Hard Seltzer' AND itemName='PRESS Pomegranate - 6 pack, cans'...importing single size for PRESS Pomegranate - 6 pack, cans (). <br>item already exists. <br>itemkey:382...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Hard Seltzer' AND itemName='PRESS Premium Hard Seltzer Variety Pack - 12 pack, 12 oz cans'...importing single size for PRESS Premium Hard Seltzer Variety Pack - 12 pack, 12 oz cans (12 pack, 12 oz cans). <br>item already exists. <br>itemkey:383...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Hard Seltzer' AND itemName='Smirnoff Seltzer - Variety - 12pack, 12 oz cans'...importing single size for Smirnoff Seltzer - Variety - 12pack, 12 oz cans (12pack, 12 oz cans). <br>item already exists. <br>itemkey:384...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Hard Seltzer' AND itemName='Steel Reserve 40oz'...importing single size for Steel Reserve 40oz (). <br>item already exists. <br>itemkey:385...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Hard Seltzer' AND itemName='Steel Reserve - 24oz can'...importing single size for Steel Reserve - 24oz can (). <br>item already exists. <br>itemkey:386...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Hard Seltzer' AND itemName='Truly Berry Mix Pack - 12pack, 12 oz cans'...importing single size for Truly Berry Mix Pack - 12pack, 12 oz cans (). <br>item already exists. <br>itemkey:387...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Hard Seltzer' AND itemName='Truly Blueberry & Acai - 6pack, 12 oz cans'...importing single size for Truly Blueberry & Acai - 6pack, 12 oz cans (). <br>item already exists. <br>itemkey:388...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Hard Seltzer' AND itemName='Truly Lemonade Sampler 12 Can'...importing single size for Truly Lemonade Sampler 12 Can (). <br>item already exists. <br>itemkey:389...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Hard Seltzer' AND itemName='Truly Pineapple - 6pack, 12 oz cans'...importing single size for Truly Pineapple - 6pack, 12 oz cans (6pack, 12 oz cans). <br>item already exists. <br>itemkey:390...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Hard Seltzer' AND itemName='Truly Sample 12 Can'...importing single size for Truly Sample 12 Can (). <br>item already exists. <br>itemkey:391...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Hard Seltzer' AND itemName='Truly Tropical Mix Pack - 12pack, 12 oz cans'...importing single size for Truly Tropical Mix Pack - 12pack, 12 oz cans (12pack, 12 oz cans). <br>item already exists. <br>itemkey:392...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Hard Seltzer' AND itemName='White Claw #2 Sample 12Can'...importing single size for White Claw #2 Sample 12Can (). <br>item already exists. <br>itemkey:393...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Hard Seltzer' AND itemName='White Claw Black Cherry - 6pack, 12 oz cans'...importing single size for White Claw Black Cherry - 6pack, 12 oz cans (6pack, 12 oz cans). <br>item already exists. <br>itemkey:394...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Hard Seltzer' AND itemName='White Claw Mango - 6pack, 12 oz cans'...importing single size for White Claw Mango - 6pack, 12 oz cans (6pack, 12 oz cans). <br>item already exists. <br>itemkey:395...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Hard Seltzer' AND itemName='White Claw Mango 12 pack, cans'...importing single size for White Claw Mango 12 pack, cans (). <br>item already exists. <br>itemkey:396...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Hard Seltzer' AND itemName='White Claw Natural Lime - 6pack, 12 oz cans'...importing single size for White Claw Natural Lime - 6pack, 12 oz cans (6pack, 12 oz cans). <br>item already exists. <br>itemkey:397...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Hard Seltzer' AND itemName='White Claw Raspberry - 6pack, 12 oz cans'...importing single size for White Claw Raspberry - 6pack, 12 oz cans (6pack, 12 oz cans). <br>item already exists. <br>itemkey:398...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Hard Seltzer' AND itemName='White Claw Ruby Grapefruit - 6pack, 12 oz cans'...importing single size for White Claw Ruby Grapefruit - 6pack, 12 oz cans (6pack, 12 oz cans). <br>item already exists. <br>itemkey:399Import Beer<br>category already exists, not creating Import Beer category.<br>getting category key...41<br>Now importing menu items for Import Beer category...41 <br>select * from Sheet1 where ignored='0' AND imported='0' and Category='Import Beer'<br>query5 ok......more than zero rows......qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Import Beer' AND itemName='Beck's bottle - 12 pack, 12 oz bottles'......qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Import Beer' AND itemName='Corona Extra - 12 pack, 12 oz bottles'...importing single size for Corona Extra - 12 pack, 12 oz bottles (12 pack, 12 oz bottles). <br>item already exists. <br>itemkey:400...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Import Beer' AND itemName='Corona Extra - 24 pack, 12 oz bottles'...importing single size for Corona Extra - 24 pack, 12 oz bottles (24 pack, 12 oz bottles). <br>item already exists. <br>itemkey:401...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Import Beer' AND itemName='Corona Extra - 6 pack, 12 oz bottles'...importing single size for Corona Extra - 6 pack, 12 oz bottles (6 pack, 12 oz bottles). <br>item already exists. <br>itemkey:402...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Import Beer' AND itemName='Corona Familiar 32oz'...importing single size for Corona Familiar 32oz (). <br>item already exists. <br>itemkey:403...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Import Beer' AND itemName='Corona Light - 12 pack, 12 oz bottles'...importing single size for Corona Light - 12 pack, 12 oz bottles (12 pack, 12 oz bottles). <br>item already exists. <br>itemkey:404...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Import Beer' AND itemName='Corona Light - 24 pack, 12 oz bottles'...importing single size for Corona Light - 24 pack, 12 oz bottles (24 pack, 12 oz bottles). <br>item already exists. <br>itemkey:405...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Import Beer' AND itemName='Dos Equis Lager Especial - 12 pack, 12 oz bottles'...importing single size for Dos Equis Lager Especial - 12 pack, 12 oz bottles (12 pack, 12 oz bottles). <br>item already exists. <br>itemkey:406...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Import Beer' AND itemName='Dos Equis Lager Especial - 6 pack, 12 oz bottles'...importing single size for Dos Equis Lager Especial - 6 pack, 12 oz bottles (6 pack, 12 oz bottles). <br>item already exists. <br>itemkey:407...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Import Beer' AND itemName='Guinness Draught - 12 pack, 12 oz bottles'...importing single size for Guinness Draught - 12 pack, 12 oz bottles (12 pack, 12 oz bottles). <br>item already exists. <br>itemkey:408...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Import Beer' AND itemName='Guinness Extra Stout - 12 pack, 12 oz bottles'...importing single size for Guinness Extra Stout - 12 pack, 12 oz bottles (12 pack, 12 oz bottles). <br>item already exists. <br>itemkey:409...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Import Beer' AND itemName='Heinenken - 12 pack, 12 oz bottles'...importing single size for Heinenken - 12 pack, 12 oz bottles (12 pack, 12 oz bottles). <br>item already exists. <br>itemkey:410...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Import Beer' AND itemName='Heinenken - 24 pack, 12 oz bottles'...importing single size for Heinenken - 24 pack, 12 oz bottles (24 pack, 12 oz bottles). <br>item already exists. <br>itemkey:411...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Import Beer' AND itemName='Heinenken - 4 pack, 16 oz cans'...importing single size for Heinenken - 4 pack, 16 oz cans (12 pack, 12 oz cans). <br>item already exists. <br>itemkey:412...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Import Beer' AND itemName='Heinenken -18 pack, 12 oz bottles'...importing single size for Heinenken -18 pack, 12 oz bottles (6 pack, 12 oz bottles). <br>item already exists. <br>itemkey:413...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Import Beer' AND itemName='Modelo Chelada Limon 22oz'...importing single size for Modelo Chelada Limon 22oz (). <br>item already exists. <br>itemkey:414...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Import Beer' AND itemName='Modelo Especial - 12 pack, 12 oz bottles'...importing single size for Modelo Especial - 12 pack, 12 oz bottles (12 pack, 12 oz bottles). <br>item already exists. <br>itemkey:415...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Import Beer' AND itemName='Modelo Especial - 24 pack, 12 oz bottles'...importing single size for Modelo Especial - 24 pack, 12 oz bottles (24 pack, 12 oz bottles). <br>item already exists. <br>itemkey:416...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Import Beer' AND itemName='Modelo Especial - 6 pack, 12 oz bottles'...importing single size for Modelo Especial - 6 pack, 12 oz bottles (). <br>item already exists. <br>itemkey:417...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Import Beer' AND itemName='Modelo Picante Chelada 22oz'...importing single size for Modelo Picante Chelada 22oz (). <br>item already exists. <br>itemkey:418...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Import Beer' AND itemName='St Pauli Girl - 12 pack, 11 oz bottles'...importing single size for St Pauli Girl - 12 pack, 11 oz bottles (12 pack, 11 oz bottles). <br>item already exists. <br>itemkey:419...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Import Beer' AND itemName='Stella Artois - 12 pack, 11 oz bottles'...importing single size for Stella Artois - 12 pack, 11 oz bottles (12 pack, 11 oz bottles). <br>item already exists. <br>itemkey:420Light Beer<br>category already exists, not creating Light Beer category.<br>getting category key...42<br>Now importing menu items for Light Beer category...42 <br>select * from Sheet1 where ignored='0' AND imported='0' and Category='Light Beer'<br>query5 ok......more than zero rows......qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Light Beer' AND itemName='Bud Light - 12 pack, 12 oz cans'...importing single size for Bud Light - 12 pack, 12 oz cans (12 pack, 12 oz cans). <br>item already exists. <br>itemkey:421...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Light Beer' AND itemName='Bud Light - 24 pack, 12 oz cans'...importing single size for Bud Light - 24 pack, 12 oz cans (24 pack, 12 oz cans). <br>item already exists. <br>itemkey:422...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Light Beer' AND itemName='Bud Light 24PK 16oz Cans'...importing single size for Bud Light 24PK 16oz Cans (). <br>item already exists. <br>itemkey:423...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Light Beer' AND itemName='Bud Light Platinum - 12pack, 12 oz cans'...importing single size for Bud Light Platinum - 12pack, 12 oz cans (). <br>item already exists. <br>itemkey:424...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Light Beer' AND itemName='Busch Light - 24 pack, 12 oz cans'...importing single size for Busch Light - 24 pack, 12 oz cans (24 pack, 12 oz cans). <br>item already exists. <br>itemkey:425...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Light Beer' AND itemName='Coors Light - 12 pack, 12 oz bottles'...importing single size for Coors Light - 12 pack, 12 oz bottles (12 pack, 12 oz bottles). <br>item already exists. <br>itemkey:426...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Light Beer' AND itemName='Coors Light - 24 pack, 12 oz bottles'...importing single size for Coors Light - 24 pack, 12 oz bottles (6 pack, 12 oz bottles). <br>item already exists. <br>itemkey:427...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Light Beer' AND itemName='Coors Light - 12 pack, 12 oz cans'...importing single size for Coors Light - 12 pack, 12 oz cans (12 pack, 12 oz cans). <br>item already exists. <br>itemkey:428...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Light Beer' AND itemName='Coors Light - 15 pack, 16 oz Alum bottle'...importing single size for Coors Light - 15 pack, 16 oz Alum bottle (15 pack, 16 oz Alum bottle). <br>item already exists. <br>itemkey:429...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Light Beer' AND itemName='Coors Light - 24 pack, 12 oz cans'...importing single size for Coors Light - 24 pack, 12 oz cans (24 pack, 12 oz cans). <br>item already exists. <br>itemkey:430...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Light Beer' AND itemName='Coors Light - 24 pack, 16 oz cans'...importing single size for Coors Light - 24 pack, 16 oz cans (). <br>item already exists. <br>itemkey:431...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Light Beer' AND itemName='Coors Light - 9 pack, 16 oz Alum bottle'...importing single size for Coors Light - 9 pack, 16 oz Alum bottle (9 pack, 16 oz Alum bottle). <br>item already exists. <br>itemkey:432...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Light Beer' AND itemName='Hamms Light - 30 pack, 12 oz cans'...importing single size for Hamms Light - 30 pack, 12 oz cans (). <br>item already exists. <br>itemkey:433...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Light Beer' AND itemName='Keystone Light - 15 pack, 12 oz cans'...importing single size for Keystone Light - 15 pack, 12 oz cans (15 pack, 12 oz cans). <br>item already exists. <br>itemkey:434...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Light Beer' AND itemName='Keystone Light - 24 pack, 12 oz cans'...importing single size for Keystone Light - 24 pack, 12 oz cans (24 pack, 12 oz cans). <br>item already exists. <br>itemkey:435...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Light Beer' AND itemName='Keystone Light 24 oz'...importing single size for Keystone Light 24 oz (). <br>item already exists. <br>itemkey:436...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Light Beer' AND itemName='Mich Golden Draft Light - 6 pack, 16oz'...importing single size for Mich Golden Draft Light - 6 pack, 16oz (). <br>item already exists. <br>itemkey:437...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Light Beer' AND itemName='Michelob Golden Draft Light - 12 pack, 12 oz bottles'...importing single size for Michelob Golden Draft Light - 12 pack, 12 oz bottles (12 pack, 12 oz bottles). <br>item already exists. <br>itemkey:438...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Light Beer' AND itemName='Michelob Golden Draft Light - 12 pack, 12 oz cans'...importing single size for Michelob Golden Draft Light - 12 pack, 12 oz cans (12 pack, 12 oz cans). <br>item already exists. <br>itemkey:439...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Light Beer' AND itemName='Michelob Golden Draft Light - 24 pack, 12 oz bottles'...importing single size for Michelob Golden Draft Light - 24 pack, 12 oz bottles (24 pack, 12 oz bottles). <br>item already exists. <br>itemkey:440...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Light Beer' AND itemName='Michelob Golden Draft Light - 24 pack, 12 oz cans'...importing single size for Michelob Golden Draft Light - 24 pack, 12 oz cans (24 pack, 12 oz cans). <br>item already exists. <br>itemkey:441...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Light Beer' AND itemName='Michelob Golden Draft Light - 24 pack, 16 oz cans'...importing single size for Michelob Golden Draft Light - 24 pack, 16 oz cans (24 pack, 16 oz cans). <br>item already exists. <br>itemkey:442...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Light Beer' AND itemName='Michelob Golden Draft Light- 6 pack, 12 oz bottles'...importing single size for Michelob Golden Draft Light- 6 pack, 12 oz bottles (). <br>item already exists. <br>itemkey:443...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Light Beer' AND itemName='Michelob Ultra - 12 pack, 12 oz bottles'...importing single size for Michelob Ultra - 12 pack, 12 oz bottles (12 pack, 12 oz bottles). <br>item already exists. <br>itemkey:444...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Light Beer' AND itemName='Michelob Ultra - 12 pack, 12 oz cans'...importing single size for Michelob Ultra - 12 pack, 12 oz cans (12 pack, 12 oz cans). <br>item already exists. <br>itemkey:445...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Light Beer' AND itemName='Michelob Ultra - 24 pack, 12 oz cans'...importing single size for Michelob Ultra - 24 pack, 12 oz cans (24 pack, 12 oz cans). <br>item already exists. <br>itemkey:446...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Light Beer' AND itemName='Miller High Life Light - 24 pack, 12 oz cans'...importing single size for Miller High Life Light - 24 pack, 12 oz cans (24 pack, 12 oz cans). <br>item already exists. <br>itemkey:447...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Light Beer' AND itemName='Miller Lite - 12 pack, 12 oz bottles'...importing single size for Miller Lite - 12 pack, 12 oz bottles (12 pack, 12 oz bottles). <br>item already exists. <br>itemkey:448...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Light Beer' AND itemName='Miller Lite - 12 pack, 12 oz cans'...importing single size for Miller Lite - 12 pack, 12 oz cans (12 pack, 12 oz cans). <br>item already exists. <br>itemkey:449...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Light Beer' AND itemName='Miller Lite - 24 pack, 12 oz cans'...importing single size for Miller Lite - 24 pack, 12 oz cans (24 pack, 12 oz cans). <br>item already exists. <br>itemkey:450...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Light Beer' AND itemName='Miller Lite - 24 pack, 16 oz cans'...importing single size for Miller Lite - 24 pack, 16 oz cans (). <br>item already exists. <br>itemkey:451...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Light Beer' AND itemName='Milwaukee's Best Light - 24 pack, 12 oz cans'......qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Light Beer' AND itemName='Natral Light Ice - 18 pack, 16 oz cans'...importing single size for Natral Light Ice - 18 pack, 16 oz cans (6 pack, 16 oz cans). <br>item already exists. <br>itemkey:452...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Light Beer' AND itemName='Natural Light Catalina 12 Can'...importing single size for Natural Light Catalina 12 Can (). <br>item already exists. <br>itemkey:453Liqueurs and Cordials<br>category already exists, not creating Liqueurs and Cordials category.<br>getting category key...43<br>Now importing menu items for Liqueurs and Cordials category...43 <br>select * from Sheet1 where ignored='0' AND imported='0' and Category='Liqueurs and Cordials'<br>query5 ok......more than zero rows......qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Liqueurs and Cordials' AND itemName='99 Apples 50ml'...importing single size for 99 Apples 50ml (50ml). <br>item already exists. <br>itemkey:454...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Liqueurs and Cordials' AND itemName='Bailey's Irish Cream - 1 L'......qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Liqueurs and Cordials' AND itemName='Bailey's Irish Cream - 750ml'......qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Liqueurs and Cordials' AND itemName='Blarney Irish Cream 1.75L'...importing single size for Blarney Irish Cream 1.75L (). <br>item already exists. <br>itemkey:455...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Liqueurs and Cordials' AND itemName='Cointreau - 1L'...importing single size for Cointreau - 1L (1.75L). <br>item already exists. <br>itemkey:456...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Liqueurs and Cordials' AND itemName='Jagermeister - 200ml'...importing single size for Jagermeister - 200ml (200ml). <br>item already exists. <br>itemkey:457...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Liqueurs and Cordials' AND itemName='Jagermeister - 375ml'...importing single size for Jagermeister - 375ml (375ml). <br>item already exists. <br>itemkey:458...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Liqueurs and Cordials' AND itemName='Kahlua - 1 L'...importing single size for Kahlua - 1 L (1 L). <br>item already exists. <br>itemkey:459...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Liqueurs and Cordials' AND itemName='Kahlua - 750ml'...importing single size for Kahlua - 750ml (750ml). <br>item already exists. <br>itemkey:460...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Liqueurs and Cordials' AND itemName='Yukon Jack 50ml'...importing single size for Yukon Jack 50ml (). <br>item already exists. <br>itemkey:461Rum<br>category already exists, not creating Rum category.<br>getting category key...44<br>Now importing menu items for Rum category...44 <br>select * from Sheet1 where ignored='0' AND imported='0' and Category='Rum'<br>query5 ok......more than zero rows......qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Rum' AND itemName='Admiral Nelson's Spiced - 1.75L'......qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Rum' AND itemName='Admiral Nelson's Spiced - 1L'......qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Rum' AND itemName='Bacardi Silver - 1.75L'...importing single size for Bacardi Silver - 1.75L (). <br>item already exists. <br>itemkey:462...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Rum' AND itemName='Bacardi Silver - 1L'...importing single size for Bacardi Silver - 1L (). <br>item already exists. <br>itemkey:463...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Rum' AND itemName='Bacardi Silver - 50ml'...importing single size for Bacardi Silver - 50ml (). <br>item already exists. <br>itemkey:464...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Rum' AND itemName='Bacardi Superior White - 1.0L'...importing single size for Bacardi Superior White - 1.0L (1.0L). <br>item already exists. <br>itemkey:465...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Rum' AND itemName='Bacardi Superior White - 1.75L'...importing single size for Bacardi Superior White - 1.75L (1.75L). <br>item already exists. <br>itemkey:466...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Rum' AND itemName='Captain Morgan Black Cast 100 - 1.0L'...importing single size for Captain Morgan Black Cast 100 - 1.0L (1.0L). <br>item already exists. <br>itemkey:467...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Rum' AND itemName='Captain Morgan Black Cast 100 - 1.75L'...importing single size for Captain Morgan Black Cast 100 - 1.75L (1.75L). <br>item already exists. <br>itemkey:468...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Rum' AND itemName='Captain Morgan Original Spiced - 1.0L'...importing single size for Captain Morgan Original Spiced - 1.0L (1.0L). <br>item already exists. <br>itemkey:469...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Rum' AND itemName='Captain Morgan Original Spiced - 1.75L'...importing single size for Captain Morgan Original Spiced - 1.75L (1.75L). <br>item already exists. <br>itemkey:470...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Rum' AND itemName='Don Q Cristal 50ml'...importing single size for Don Q Cristal 50ml (). <br>item already exists. <br>itemkey:471...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Rum' AND itemName='Ron Diaz Spiced Rum - 1.75L'...importing single size for Ron Diaz Spiced Rum - 1.75L (1.75L). <br>item already exists. <br>itemkey:472...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Rum' AND itemName='Rondiaz Gold - 1.75L'...importing single size for Rondiaz Gold - 1.75L (1.75L). <br>item already exists. <br>itemkey:473...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Rum' AND itemName='Rondiaz Gold - 1L'...importing single size for Rondiaz Gold - 1L (750.0ml). <br>item already exists. <br>itemkey:474...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Rum' AND itemName='Rondiaz Lt - 1.75L'...importing single size for Rondiaz Lt - 1.75L (). <br>item already exists. <br>itemkey:475...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Rum' AND itemName='Ronrico Silver - 1.75L'...importing single size for Ronrico Silver - 1.75L (1.75L). <br>item already exists. <br>itemkey:476...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Rum' AND itemName='Ronrico Silver - 1L'...importing single size for Ronrico Silver - 1L (750.0ml). <br>item already exists. <br>itemkey:477Tequila<br>category already exists, not creating Tequila category.<br>getting category key...45<br>Now importing menu items for Tequila category...45 <br>select * from Sheet1 where ignored='0' AND imported='0' and Category='Tequila'<br>query5 ok......more than zero rows......qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Tequila' AND itemName='1800 Reposado - 1.75 L bottle'...importing single size for 1800 Reposado - 1.75 L bottle (1.75 L bottle). <br>item already exists. <br>itemkey:478...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Tequila' AND itemName='1800 Reposado - 1L'...importing single size for 1800 Reposado - 1L (1L). <br>item already exists. <br>itemkey:479...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Tequila' AND itemName='1800 Reposado - 750.0ml'...importing single size for 1800 Reposado - 750.0ml (750.0ml). <br>item already exists. <br>itemkey:480...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Tequila' AND itemName='Cayman Jack Margarita -6 pack, bottles'...importing single size for Cayman Jack Margarita -6 pack, bottles (). <br>item already exists. <br>itemkey:481...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Tequila' AND itemName='Jose Cuervo Especial Gold - 1.75 L bottle'...importing single size for Jose Cuervo Especial Gold - 1.75 L bottle (1.75 L bottle). <br>item already exists. <br>itemkey:482...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Tequila' AND itemName='Jose Cuervo Especial Gold - 1L'...importing single size for Jose Cuervo Especial Gold - 1L (1L). <br>item already exists. <br>itemkey:483...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Tequila' AND itemName='Jose Cuervo Especial Gold - 200ml'...importing single size for Jose Cuervo Especial Gold - 200ml (200ml). <br>item already exists. <br>itemkey:484...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Tequila' AND itemName='Patron Silver - 750.0ml'...importing single size for Patron Silver - 750.0ml (750.0ml). <br>item already exists. <br>itemkey:485Vodka<br>category already exists, not creating Vodka category.<br>getting category key...46<br>Now importing menu items for Vodka category...46 <br>select * from Sheet1 where ignored='0' AND imported='0' and Category='Vodka'<br>query5 ok......more than zero rows......qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Vodka' AND itemName='Absolut Vodka - 1.75L'...importing single size for Absolut Vodka - 1.75L (1.75L). <br>item already exists. <br>itemkey:486...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Vodka' AND itemName='Absolut Vodka - 1L'...importing single size for Absolut Vodka - 1L (1L). <br>item already exists. <br>itemkey:487...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Vodka' AND itemName='American Anthem Vodka 1750'...importing single size for American Anthem Vodka 1750 (1.75 L bottle). <br>item already exists. <br>itemkey:488...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Vodka' AND itemName='Barton Vodka 200ml'...importing single size for Barton Vodka 200ml (). <br>item already exists. <br>itemkey:489...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Vodka' AND itemName='Grey Goose Vanilla - 1L'...importing single size for Grey Goose Vanilla - 1L (). <br>item already exists. <br>itemkey:490...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Vodka' AND itemName='Karkov - 1.75L'...importing single size for Karkov - 1.75L (1.75L). <br>item already exists. <br>itemkey:491...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Vodka' AND itemName='Karkov - 750.0ml'...importing single size for Karkov - 750.0ml (750.0ml). <br>item already exists. <br>itemkey:492...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Vodka' AND itemName='New Amsterdam Berry 50ml'...importing single size for New Amsterdam Berry 50ml (). <br>item already exists. <br>itemkey:493...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Vodka' AND itemName='New Amsterdam Pink Lemom 750ml'...importing single size for New Amsterdam Pink Lemom 750ml (). <br>item already exists. <br>itemkey:494...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Vodka' AND itemName='New Amsterdam Vodka - 1.75L'...importing single size for New Amsterdam Vodka - 1.75L (1.75L). <br>item already exists. <br>itemkey:495...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Vodka' AND itemName='New Amsterdam Vodka - 1L'...importing single size for New Amsterdam Vodka - 1L (1L). <br>item already exists. <br>itemkey:496...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Vodka' AND itemName='New Amsterdam Vodka - 375ml'...importing single size for New Amsterdam Vodka - 375ml (375ml). <br>item already exists. <br>itemkey:497...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Vodka' AND itemName='New Amsterdam Vodka - 750.0ml'...importing single size for New Amsterdam Vodka - 750.0ml (750.0ml). <br>item already exists. <br>itemkey:498...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Vodka' AND itemName='New Amsterdam Vodka 50ml'...importing single size for New Amsterdam Vodka 50ml (). <br>item already exists. <br>itemkey:499...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Vodka' AND itemName='Phillip's Vodka - 1.75L'......qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Vodka' AND itemName='Phillip's Vodka - 1L'......qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Vodka' AND itemName='Phillip's -Vodka 750.0ml'......qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Vodka' AND itemName='Pinnacle Vodka - 1.75L'...importing single size for Pinnacle Vodka - 1.75L (1.75L). <br>item already exists. <br>itemkey:500...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Vodka' AND itemName='Platinum Vodka - 1.75L'...importing single size for Platinum Vodka - 1.75L (1.75L). <br>item already exists. <br>itemkey:501...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Vodka' AND itemName='Skyy Vodka - 1.75L'...importing single size for Skyy Vodka - 1.75L (1.75L). <br>item already exists. <br>itemkey:502...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Vodka' AND itemName='Skyy Vodka - 1L'...importing single size for Skyy Vodka - 1L (1L). <br>item already exists. <br>itemkey:503...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Vodka' AND itemName='Smirnoff - 1.75L'...importing single size for Smirnoff - 1.75L (1.75L). <br>item already exists. <br>itemkey:504...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Vodka' AND itemName='Smirnoff - 1L'...importing single size for Smirnoff - 1L (1L). <br>item already exists. <br>itemkey:505...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Vodka' AND itemName='Smirnoff - 200ml'...importing single size for Smirnoff - 200ml (200ml). <br>item already exists. <br>itemkey:506...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Vodka' AND itemName='Smirnoff - 375ml'...importing single size for Smirnoff - 375ml (375ml). <br>item already exists. <br>itemkey:507...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Vodka' AND itemName='Smirnoff - 750.0ml'...importing single size for Smirnoff - 750.0ml (750.0ml). <br>item already exists. <br>itemkey:508...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Vodka' AND itemName='Smirnoff Green Apple - 50ml'...importing single size for Smirnoff Green Apple - 50ml (). <br>item already exists. <br>itemkey:509...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Vodka' AND itemName='Smirnoff Vodka 100 Proof - 1L'...importing single size for Smirnoff Vodka 100 Proof - 1L (375ml). <br>item already exists. <br>itemkey:510...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Vodka' AND itemName='Svedka - 1.75L'...importing single size for Svedka - 1.75L (1.75L). <br>item already exists. <br>itemkey:511...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Vodka' AND itemName='Svedka - 1L'...importing single size for Svedka - 1L (1L). <br>item already exists. <br>itemkey:512...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Vodka' AND itemName='Svedka - 375ml'...importing single size for Svedka - 375ml (375ml). <br>item already exists. <br>itemkey:513...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Vodka' AND itemName='Svedka - 750.0ml'...importing single size for Svedka - 750.0ml (750.0ml). <br>item already exists. <br>itemkey:514...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Vodka' AND itemName='Taaka - 1.75L'...importing single size for Taaka - 1.75L (1.75L). <br>item already exists. <br>itemkey:515...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Vodka' AND itemName='Taaka - 1L'...importing single size for Taaka - 1L (1L). <br>item already exists. <br>itemkey:516...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Vodka' AND itemName='Taaka - 375ml'...importing single size for Taaka - 375ml (). <br>item already exists. <br>itemkey:517...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Vodka' AND itemName='Tito's Handmade Vodka - 1.75L'......qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Vodka' AND itemName='Tito's Handmade Vodla- 1L'......qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Vodka' AND itemName='Tower Vodka - 1.75L'...importing single size for Tower Vodka - 1.75L (1.75L). <br>item already exists. <br>itemkey:518Whiskey<br>category already exists, not creating Whiskey category.<br>getting category key...47<br>Now importing menu items for Whiskey category...47 <br>select * from Sheet1 where ignored='0' AND imported='0' and Category='Whiskey'<br>query5 ok......more than zero rows......qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Whiskey' AND itemName='2 Gingers Irish Whiskey 50ml'...importing single size for 2 Gingers Irish Whiskey 50ml (50ml). <br>item already exists. <br>itemkey:519...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Whiskey' AND itemName='Black Velvet Canadian - 750.0ml'...importing single size for Black Velvet Canadian - 750.0ml (750.0ml). <br>item already exists. <br>itemkey:520...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Whiskey' AND itemName='Canadian Club - 1.75L'...importing single size for Canadian Club - 1.75L (1.75L). <br>item already exists. <br>itemkey:521...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Whiskey' AND itemName='Canadian Club - 1L'...importing single size for Canadian Club - 1L (1L). <br>item already exists. <br>itemkey:522...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Whiskey' AND itemName='Crown Royal - 1.75L'...importing single size for Crown Royal - 1.75L (1.75L). <br>item already exists. <br>itemkey:523...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Whiskey' AND itemName='Crown Royal - 750.0ml'...importing single size for Crown Royal - 750.0ml (750.0ml). <br>item already exists. <br>itemkey:524...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Whiskey' AND itemName='Dr Blackberry Whiskey 50ml'...importing single size for Dr Blackberry Whiskey 50ml (). <br>item already exists. <br>itemkey:525...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Whiskey' AND itemName='Evan Willams Apple 50ml'...importing single size for Evan Willams Apple 50ml (). <br>item already exists. <br>itemkey:526...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Whiskey' AND itemName='Evan Willams Honey 50ml'...importing single size for Evan Willams Honey 50ml (). <br>item already exists. <br>itemkey:527...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Whiskey' AND itemName='Evan Williams Black - 1.75L'...importing single size for Evan Williams Black - 1.75L (1.75L). <br>item already exists. <br>itemkey:528...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Whiskey' AND itemName='Evan Williams Black - 1L'...importing single size for Evan Williams Black - 1L (1L). <br>item already exists. <br>itemkey:529...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Whiskey' AND itemName='Fireball Cinnamon Whisky - 100ml'...importing single size for Fireball Cinnamon Whisky - 100ml (). <br>item already exists. <br>itemkey:530...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Whiskey' AND itemName='Fireball Cinnamon Whisky - 1L'...importing single size for Fireball Cinnamon Whisky - 1L (1L). <br>item already exists. <br>itemkey:531...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Whiskey' AND itemName='Fireball Cinnamon Whisky - 200ml'...importing single size for Fireball Cinnamon Whisky - 200ml (). <br>item already exists. <br>itemkey:532...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Whiskey' AND itemName='Fireball Cinnamon Whisky - 375ml'...importing single size for Fireball Cinnamon Whisky - 375ml (375ml). <br>item already exists. <br>itemkey:533...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Whiskey' AND itemName='Fireball Cinnamon Whisky - 750.0ml'...importing single size for Fireball Cinnamon Whisky - 750.0ml (750.0ml). <br>item already exists. <br>itemkey:534...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Whiskey' AND itemName='Jack Daniels Apple 50ml'...importing single size for Jack Daniels Apple 50ml (). <br>item already exists. <br>itemkey:535...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Whiskey' AND itemName='Jack Daniel's No. 7 - 1L'......qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Whiskey' AND itemName='Jack Daniel's No. 7 - 50ml'......qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Whiskey' AND itemName='Jameson Irish - 1L'...importing single size for Jameson Irish - 1L (1L). <br>item already exists. <br>itemkey:536...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Whiskey' AND itemName='Jameson Irish - 50ml'...importing single size for Jameson Irish - 50ml (). <br>item already exists. <br>itemkey:537...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Whiskey' AND itemName='Jameson Irish - 750.0ml'...importing single size for Jameson Irish - 750.0ml (750.0ml). <br>item already exists. <br>itemkey:538...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Whiskey' AND itemName='Jim Beam Bourbon - 1.75L'...importing single size for Jim Beam Bourbon - 1.75L (1.75L). <br>item already exists. <br>itemkey:539...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Whiskey' AND itemName='Jim Beam Bourbon - 1L'...importing single size for Jim Beam Bourbon - 1L (1L). <br>item already exists. <br>itemkey:540...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Whiskey' AND itemName='Jim Beam Bourbon - 50ml'...importing single size for Jim Beam Bourbon - 50ml (200ml). <br>item already exists. <br>itemkey:541...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Whiskey' AND itemName='Johnnie Walker Red Label - 1.75L'...importing single size for Johnnie Walker Red Label - 1.75L (1.75L). <br>item already exists. <br>itemkey:542...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Whiskey' AND itemName='Johnnie Walker Red Label - 1L'...importing single size for Johnnie Walker Red Label - 1L (1L). <br>item already exists. <br>itemkey:543...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Whiskey' AND itemName='Knob Creek Kentucky Straight Bourbon - 750.0ml'...importing single size for Knob Creek Kentucky Straight Bourbon - 750.0ml (750.0ml). <br>item already exists. <br>itemkey:544...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Whiskey' AND itemName='Maker's Mark Bourbon - 1.75L'......qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Whiskey' AND itemName='Maker's Mark Bourbon - 1L'......qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Whiskey' AND itemName='Southern Comfort - 1.75L'...importing single size for Southern Comfort - 1.75L (1.75L). <br>item already exists. <br>itemkey:545...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Whiskey' AND itemName='Southern Comfort - 1L'...importing single size for Southern Comfort - 1L (1L). <br>item already exists. <br>itemkey:546...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Whiskey' AND itemName='Windsor Canadian Blended - 1.75L'...importing single size for Windsor Canadian Blended - 1.75L (1.75L). <br>item already exists. <br>itemkey:547Wine<br>category already exists, not creating Wine category.<br>getting category key...48<br>Now importing menu items for Wine category...48 <br>select * from Sheet1 where ignored='0' AND imported='0' and Category='Wine'<br>query5 ok......more than zero rows......qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Wine' AND itemName='14 Hands Red 750'...importing single size for 14 Hands Red 750 (). <br>item already exists. <br>itemkey:548...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Wine' AND itemName='Apothic Red - 750 ML'...importing single size for Apothic Red - 750 ML (750 ML). <br>item already exists. <br>itemkey:549...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Wine' AND itemName='Barefoot Moscato 750'...importing single size for Barefoot Moscato 750 (). <br>item already exists. <br>itemkey:550...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Wine' AND itemName='Barefoot Pink Moscato 750'...importing single size for Barefoot Pink Moscato 750 (). <br>item already exists. <br>itemkey:551...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Wine' AND itemName='Barefoot Riesling 750'...importing single size for Barefoot Riesling 750 (). <br>item already exists. <br>itemkey:552...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Wine' AND itemName='Black Box Cabernet 3L Box'...importing single size for Black Box Cabernet 3L Box (). <br>item already exists. <br>itemkey:553...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Wine' AND itemName='Black Box Chardonnay 500ml'...importing single size for Black Box Chardonnay 500ml (). <br>item already exists. <br>itemkey:554...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Wine' AND itemName='Black Box Chardonny 3000'...importing single size for Black Box Chardonny 3000 (). <br>item already exists. <br>itemkey:555...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Wine' AND itemName='Black Box Pinot Grigio 500ml'...importing single size for Black Box Pinot Grigio 500ml (). <br>item already exists. <br>itemkey:556...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Wine' AND itemName='Bota Box Cabernet- 3 LTR, box'...importing single size for Bota Box Cabernet- 3 LTR, box (). <br>item already exists. <br>itemkey:557...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Wine' AND itemName='Bota Box Chardonnay - 3 LTR, box'...importing single size for Bota Box Chardonnay - 3 LTR, box (). <br>item already exists. <br>itemkey:558...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Wine' AND itemName='Bota Box Pinot Grigio - 3 LTR, box'...importing single size for Bota Box Pinot Grigio - 3 LTR, box (3 LTR, box). <br>item already exists. <br>itemkey:559...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Wine' AND itemName='Bota Box RedVolution - 3 LTR, box'...importing single size for Bota Box RedVolution - 3 LTR, box (3 LTR, box). <br>item already exists. <br>itemkey:560...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Wine' AND itemName='Bota Box Rose - 3 LTR, box'...importing single size for Bota Box Rose - 3 LTR, box (3 LTR, box). <br>item already exists. <br>itemkey:561...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Wine' AND itemName='Bota Box Sauvignon Blanc - 3 LTR, box'...importing single size for Bota Box Sauvignon Blanc - 3 LTR, box (3 LTR, box). <br>item already exists. <br>itemkey:562...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Wine' AND itemName='Buttercream Chardonnay 750ml'...importing single size for Buttercream Chardonnay 750ml (750 ML). <br>item already exists. <br>itemkey:563...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Wine' AND itemName='Cavit Pinot Grigio - 1.5L'...importing single size for Cavit Pinot Grigio - 1.5L (). <br>item already exists. <br>itemkey:564...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Wine' AND itemName='Columbia Crest Chardonnay - 750 ML'...importing single size for Columbia Crest Chardonnay - 750 ML (750 ML). <br>item already exists. <br>itemkey:565...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Wine' AND itemName='Columbia Crest Two Cab 750'...importing single size for Columbia Crest Two Cab 750 (). <br>item already exists. <br>itemkey:566...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Wine' AND itemName='Cooks Brut - 750ML'...importing single size for Cooks Brut - 750ML (). <br>item already exists. <br>itemkey:567...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Wine' AND itemName='Cupcake Pinot Grigio 750'...importing single size for Cupcake Pinot Grigio 750 (). <br>item already exists. <br>itemkey:568...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Wine' AND itemName='Cupcake Sauvignon Blanc - 750 ML'...importing single size for Cupcake Sauvignon Blanc - 750 ML (750 ML). <br>item already exists. <br>itemkey:569...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Wine' AND itemName='Franzia Chardonnay - 5 LTR, box'...importing single size for Franzia Chardonnay - 5 LTR, box (5 LTR, box). <br>item already exists. <br>itemkey:570...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Wine' AND itemName='Franzia Chianti - 5 LTR, box'...importing single size for Franzia Chianti - 5 LTR, box (5 LTR, box). <br>item already exists. <br>itemkey:571...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Wine' AND itemName='Franzia Crisp White - 5 LTR, box'...importing single size for Franzia Crisp White - 5 LTR, box (5 LTR, box). <br>item already exists. <br>itemkey:572...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Wine' AND itemName='Franzia Dark Red Blend - 5 LTR, box'...importing single size for Franzia Dark Red Blend - 5 LTR, box (5 LTR, box). <br>item already exists. <br>itemkey:573...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Wine' AND itemName='Franzia Pinot Grigio - 5 LTR, box'...importing single size for Franzia Pinot Grigio - 5 LTR, box (). <br>item already exists. <br>itemkey:574...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Wine' AND itemName='Franzia Pinot Grigio 500ml'...importing single size for Franzia Pinot Grigio 500ml (). <br>item already exists. <br>itemkey:575...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Wine' AND itemName='Franzia Sunset Blush - 5 LTR, box'...importing single size for Franzia Sunset Blush - 5 LTR, box (5 LTR, box). <br>item already exists. <br>itemkey:576...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Wine' AND itemName='Franzia White Zinfandel - 5 LTR, box'...importing single size for Franzia White Zinfandel - 5 LTR, box (5 LTR, box). <br>item already exists. <br>itemkey:577...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Wine' AND itemName='Josh Cellars Cabernet 750'...importing single size for Josh Cellars Cabernet 750 (). <br>item already exists. <br>itemkey:578...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Wine' AND itemName='Josh Cellars SauvignonBlanc - 750 ML'...importing single size for Josh Cellars SauvignonBlanc - 750 ML (750 ML). <br>item already exists. <br>itemkey:579...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Wine' AND itemName='Kim Crawford Sauvignon Blanc - 750 ML'...importing single size for Kim Crawford Sauvignon Blanc - 750 ML (750 ML). <br>item already exists. <br>itemkey:580...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Wine' AND itemName='La Vostra Prosecco - 750 ML'...importing single size for La Vostra Prosecco - 750 ML (750 ML). <br>item already exists. <br>itemkey:581...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Wine' AND itemName='Mark West Pinot Noir 750'...importing single size for Mark West Pinot Noir 750 (). <br>item already exists. <br>itemkey:582...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Wine' AND itemName='Pour Haus Chardonnay 3L'...importing single size for Pour Haus Chardonnay 3L (). <br>item already exists. <br>itemkey:583...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Wine' AND itemName='Red Diamond Chard 750'...importing single size for Red Diamond Chard 750 (). <br>item already exists. <br>itemkey:584...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Wine' AND itemName='Red Diamond Merlot 750'...importing single size for Red Diamond Merlot 750 (). <br>item already exists. <br>itemkey:585...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Wine' AND itemName='Red Diamond Cabernet 750'...importing single size for Red Diamond Cabernet 750 (). <br>item already exists. <br>itemkey:586...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Wine' AND itemName='Red Diamond Red Blend 750ml'...importing single size for Red Diamond Red Blend 750ml (). <br>item already exists. <br>itemkey:587...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Wine' AND itemName='Red Diamond Temperamental 750ml'...importing single size for Red Diamond Temperamental 750ml (). <br>item already exists. <br>itemkey:588...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Wine' AND itemName='Roscato Red 750ml'...importing single size for Roscato Red 750ml (). <br>item already exists. <br>itemkey:589...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Wine' AND itemName='Sledgehammer Pinot Noir 750ml'...importing single size for Sledgehammer Pinot Noir 750ml (). <br>item already exists. <br>itemkey:590...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Wine' AND itemName='Sledgehammer Zinfandel 750ml'...importing single size for Sledgehammer Zinfandel 750ml (). <br>item already exists. <br>itemkey:591...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Wine' AND itemName='Starling Castle Riesling 750'...importing single size for Starling Castle Riesling 750 (). <br>item already exists. <br>itemkey:592...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Wine' AND itemName='Ste Michele Jo Riesling 750'...importing single size for Ste Michele Jo Riesling 750 (). <br>item already exists. <br>itemkey:593...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Wine' AND itemName='Tesoro Della Pinot Grigio 750m'...importing single size for Tesoro Della Pinot Grigio 750m (). <br>item already exists. <br>itemkey:594...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Wine' AND itemName='Walking Dead Cabernet 750ml'...importing single size for Walking Dead Cabernet 750ml (). <br>item already exists. <br>itemkey:595...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Wine' AND itemName='Walking Dead Red Blend 750'...importing single size for Walking Dead Red Blend 750 (). <br>item already exists. <br>itemkey:596...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Wine' AND itemName='Woodbridge Chardonnay 750'...importing single size for Woodbridge Chardonnay 750 (). <br>item already exists. <br>itemkey:597...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Wine' AND itemName='Yellow Tail Cabernet - 1.5L'...importing single size for Yellow Tail Cabernet - 1.5L (1.5L). <br>item already exists. <br>itemkey:598...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Wine' AND itemName='Yellow Tail Cabernet Merlot - 1.5 L'...importing single size for Yellow Tail Cabernet Merlot - 1.5 L (1.5 L). <br>item already exists. <br>itemkey:599...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Wine' AND itemName='Yellow Tail Merlot - 1.5L'...importing single size for Yellow Tail Merlot - 1.5L (1.5L). <br>item already exists. <br>itemkey:600...qry6: select * from Sheet1 where ignored='0' AND imported='0' and Category='Wine' AND itemName='Yellow Tail Pinot Grigio 750'...importing single size for Yellow Tail Pinot Grigio 750 (). <br>item already exists. <br>itemkey:601