Shopping in

10968

Change your location

Shop by

Department

Shop by

Store
Gift Cards
Gift Cards

Hello, User

Your Account
Sign In
0
Department
My Account
Home
Department
Cart
Stores
Profile

Quicklly Cart x

Delivery Van Free Delivery Over $30

Checkout with Shef $[NETAMOUNTSHEF]

Shef

Minimum Order Value: $25

Delivery Charge: $4.25 I Free Delivery Above $25

[Name1]

[Name2]

$[UnitPrice]

- [qty] +

Checkout with Quicklly $[NETAMOUNT]
[Name]

[TotalOrderAmount] $[TotalPrice]

Minimum Order Value: $[MinOrderAmt]

[WarnMsg]
[Name1]

[Name2]

$[UnitPrice]

Remove

[sub]

[Remarks]

$[Price] - [qty] +

X

HERE'S EXTRA 10% OFF!

When you combine with Food, Tiffin or Catering. Offer valid till today only! Hurry up!

Proceed to Checkout

Can't Miss This

Get $10 off $30 on your next 3 Shef orders

Enter your email below to claim the coupon

+1
GROCERY Grocery
FOODS & BEVERAGES Foods & Beverages
Dairy Products Masalas / Spices / Pastes Dals & Pulses Poha / Rice Products Frozen Foods Edible Oils & Ghee Flours & Sooji Salt, Sugar & Jaggery Sauce / Ketchups / Chutneys Jams & Spreads Breakfast Cereals Pickles Dry Fruits Organic Staples Frozen Vegetables/ Fruits Tea & Coffee Ready To Eat & Cook Namkeen/Munchies/Chips Biscuits / Cookies / Cake Indian Toffee/Chocolates Pasta / Pasta Sauce Indian Desserts Refreshments / Juice / Soda

Error: SELECT distinct storeid, storename FROM stores where storeid in (select distinct p.storeid from tbl_product p inner join tbl_maincategory c on c.id = p.cat_id left join tbl_productprice pp on p.id=pp.product_id where p.status=1 and pp.in_stock=1 and pp.status=1 and p.storeid in () AND c.status = 1 AND c.parent_id = 4320) order by storename

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND c.status = 1 AND c.parent_id = 4320) order by storename' at line 1