Wellcome to LankaMart.com
Subscribe to SMS to receive updates about new products.
Subscribe
Don't show this popup again!
Call Now
0815 145 145
English
LKR
All Category
SELECT COUNT(`p`.`code`) AS `count`, `mp`.`product_price_types_id` AS `price_type`,IFNULL( ( SELECT `cw`.`webcat_id` FROM `cattowebcat` `cw` WHERE `cw`.`category_id` = `p`.`category` ), 0 ) AS `web_cat_id`, IFNULL( ( SELECT `wc`.`main` FROM `web_categories` `wc` WHERE `wc`.`id` = `web_cat_id` ), 0 ) AS `web_main_category_id`, IFNULL( ( SELECT `wmc`.`en_name` FROM `web_main_categories` `wmc` WHERE `wmc`.`id` = `web_main_category_id` ), 'OTHER' ) AS `web_main_category`, IFNULL( ( SELECT `wmc`.`icon` FROM `web_main_categories` `wmc` WHERE `wmc`.`id` = `web_main_category_id` ), '' ) AS `web_main_category_image`, IFNULL( ( SELECT `wmc`.`w_order` FROM `web_main_categories` `wmc` WHERE `wmc`.`id` = `web_main_category_id` ), 9999 ) AS `web_main_category_order` FROM ( `products` `p` JOIN `product_marked_price` `mp` ) WHERE `mp`.`product` = `p`.`code` GROUP BY `web_main_category_id` ORDER BY `web_main_category_order` ASC
Grocery & Staples
Vegetables & Fruits
Eggs, Meats & Fish
Cooking Essentials
Chilled & Frozen Food
Breakfast & Dairy
Noodles & Instant Foods
Beverages
OTHER
0
2
LKR
00.00
Home
Account
Login
Register
My Account
Shop
Cart
Checkout
products
Contact Us
0815 145 145
Product List
Home
Shop
Product List
Vegetables & Fruits
category
Grocery & Staples
(333)
Rice
(98)
Pulses
(235)
Vegetables & Fruits
(2)
Vegetables
(1)
Fruits
(1)
Eggs, Meats & Fish
(25)
Eggs, Meats & Fish
(25)
Cooking Essentials
(259)
Cooking Essentials
(259)
Chilled & Frozen Food
(150)
Chilled & Frozen Food
(150)
Breakfast & Dairy
(72)
Breakfast & Dairy
(72)
Noodles & Instant Foods
(107)
Noodles & Instant Foods
(107)
Beverages
(1)
Beverages
(1)
OTHER
(6046)
OTHER
(6046)
Brands
Reston
(5)
Munchee
(86)
OTHER
(6904)
NO RESULT !
