Login
About Charu Creation
Track your order
Videos
Live Showroom
Coupons
Bulk Enquiry
Currency: INR
- INR
- USD

Home
Fabric
Embroidery/Hakoba
- By Materials
- By Design
Crochet
Laces
Silk
New Arrival
OFFERS
Collection
Under Rs. 99

Home
Fabric
Embroidery/Hakoba
- By Materials
- By Design
Crochet
Laces
Silk
New Arrival
OFFERS
Collection
Under Rs. 99

X

Knowledge Videos

SELECT   ujw_posts.*
					 FROM ujw_posts 
					 WHERE 1=1  AND ujw_posts.post_parent = 0  AND ( 
  ujw_posts.ID NOT IN (
				SELECT object_id
				FROM ujw_term_relationships
				WHERE term_taxonomy_id IN (11)
			)
) AND ujw_posts.post_type = 'product' AND ((ujw_posts.post_status = 'publish'))
					 GROUP BY ujw_posts.ID
					 ORDER BY ujw_posts.post_date DESC
					 LIMIT 0, 1

Latest

Off White Cotton Linen with Floral Embroidered Border | Charu Creation MRP₹630.00 / mtr (incl. of all taxes)

SELECT   ujw_posts.*
					 FROM ujw_posts  INNER JOIN ujw_postmeta ON ( ujw_posts.ID = ujw_postmeta.post_id )
					 WHERE 1=1  AND ujw_posts.post_parent = 0  AND ( 
  ujw_posts.ID NOT IN (
				SELECT object_id
				FROM ujw_term_relationships
				WHERE term_taxonomy_id IN (11)
			)
) AND ( 
  ujw_postmeta.meta_key = 'total_sales'
) AND ujw_posts.post_type = 'product' AND ((ujw_posts.post_status = 'publish'))
					 GROUP BY ujw_posts.ID
					 ORDER BY ujw_postmeta.meta_value+0 DESC
					 LIMIT 0, 1

Best Selling

Multicolor Circle Floral Design Cotton Chemical Lace Print Dress Material Fabric MRP₹98.70 / mtr (incl. of all taxes)

SELECT   ujw_posts.*
					 FROM ujw_posts  LEFT JOIN ujw_term_relationships ON (ujw_posts.ID = ujw_term_relationships.object_id)
					 WHERE 1=1  AND ujw_posts.post_parent = 0  AND ( 
  ujw_posts.ID NOT IN (
				SELECT object_id
				FROM ujw_term_relationships
				WHERE term_taxonomy_id IN (11)
			) 
  AND 
  ujw_term_relationships.term_taxonomy_id IN (14)
) AND ujw_posts.post_type = 'product' AND ((ujw_posts.post_status = 'publish'))
					 GROUP BY ujw_posts.ID
					 ORDER BY ujw_posts.post_date DESC
					 LIMIT 0, 1

Featured

Sky Blue Cotton Cambric Fabric – Floral Print Design MRP₹315.00 / mtr (incl. of all taxes)

SELECT   ujw_posts.*
					 FROM ujw_posts  LEFT JOIN ujw_term_relationships ON (ujw_posts.ID = ujw_term_relationships.object_id)
					 WHERE 1=1  AND ujw_posts.post_parent = 0  AND ( 
  ujw_posts.ID NOT IN (
				SELECT object_id
				FROM ujw_term_relationships
				WHERE term_taxonomy_id IN (11)
			) 
  AND 
  ujw_term_relationships.term_taxonomy_id IN (14)
) AND ujw_posts.post_type = 'product' AND ((ujw_posts.post_status = 'publish'))
					 GROUP BY ujw_posts.ID
					 ORDER BY ujw_posts.post_date DESC
					 LIMIT 0, 1

On Sale

Sky Blue Cotton Cambric Fabric – Floral Print Design MRP₹315.00 / mtr (incl. of all taxes)

ABOUT CHARU CREATION PVT LTD

About Charu Creation
Blog
Team
Prominent Customers
Testimonials
Videos
Color wheel

INFO

Return and Cancellation Policy
Domestic Orders-FAQ
Bulk Order Enquiry
Privacy Policy
Terms & Conditions
Sizing Chart
Disclaimer
International Shipping & Orders

CONTACT US

GF-2/90, Mansarovar Building, Nehru Place, New Delhi-110019

Phone : +91-9971106200

Email : [email protected]

FOLLOW US ON

WHAT IS TRENDING

0

Your Cart

Your cart is emptyReturn to Shop

To find out your shipping cost , Please proceed to checkout.