online fabric store Archives - Page 4 of 4 - Charu Creation

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

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

Sage Nylon Viscose Fabric with Floral Embroidery | 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

Buy Fabric Online Cheap cartoon prints Charu Creation cotton Cotton Cambric cotton cambric fabric cotton cambric fabric online Cotton Cambric fabric online india Designer Fabric Collection

Copyright 2023 © Charu Creation

0

0

Your Cart

Your cart is emptyReturn to Shop

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