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
Login
Home
Account
Login
Login
Log in
or
Facebook
Google
Don't Have an Account?
Sign up now
