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
Register
Home
Account
Register
Create an Account
Register
or
Facebook
Google
Already have an account?
Log in
