SELECT SQL_CALC_FOUND_ROWS  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.ID NOT IN (
				SELECT object_id
				FROM ujw_term_relationships
				WHERE term_taxonomy_id IN (11)
			) 
  AND 
  ujw_term_relationships.term_taxonomy_id IN (1047)
) AND ((ujw_posts.post_type = 'product' AND (ujw_posts.post_status = 'publish' OR ujw_posts.post_status = 'acf-disabled')))
					 GROUP BY ujw_posts.ID
					 ORDER BY ujw_posts.post_date DESC, ujw_posts.ID DESC
					 LIMIT 0, 12
Party Wear Fabric Collection | Charu Creation Party Wear Fabric Collection | Charu Creation
X

Showing 1–12 of 30 resultsSorted by latest

Showing 1–12 of 30 resultsSorted by latest

16
    16
    Your Cart
    Peach Color Plain Cotton Cambric Lining Dress Material fabric
    Peach Color Plain Cotton Cambric Lining Dress Material fabric
    Price: MRP Original price was: ₹346.50.Current price is: ₹197.54. / mtr (incl. of all taxes)
    ₹197.54 (incl. GST)
    Beige Color Cotton Gauze Fabric For Women's Dress
    Beige Color Cotton Gauze Fabric For Women's Dress
    Price: MRP₹203.18 / mtr (incl. of all taxes)
    ₹203.18 (incl. GST)
    Multicolor Nylon net sequence fabric for Women's Western Dress
    Multicolor Nylon net sequence fabric for Women's Western Dress
    Price: MRP₹1,580.25 / mtr (incl. of all taxes)
    ₹1,580.25 (incl. GST)
    Multicolor Nylon net sequence fabric for Women's Wedding Lehenga
    Multicolor Nylon net sequence fabric for Women's Wedding Lehenga
    Price: MRP₹1,580.25 / mtr (incl. of all taxes)
    ₹1,580.25 (incl. GST)
    Multicolor Checks on Cotton Dobby Yarn Dyed Fabric For Women's Kurta
    Multicolor Checks on Cotton Dobby Yarn Dyed Fabric For Women's Kurta
    Price: MRP₹282.19 / mtr (incl. of all taxes)
    ₹282.19 (incl. GST)
    Black Base Color White Cotton Hakoba Embroidery Fabric For Women's Dress
    Black Base Color White Cotton Hakoba Embroidery Fabric For Women's Dress
    Price: MRP Original price was: ₹677.25.Current price is: ₹630.00. / mtr (incl. of all taxes)
    ₹630.00 (incl. GST)
    Double Side Poly Textured Dress Material Fabric
    Double Side Poly Textured Dress Material Fabric
    Price: MRP Original price was: ₹592.20.Current price is: ₹288.75. / mtr (incl. of all taxes)
    ₹288.75 (incl. GST)
    White color Cotton Cambric Embroidery Dyeable fabric for Women's Western Top
    White color Cotton Cambric Embroidery Dyeable fabric for Women's Western Top
    Price: MRP Original price was: ₹677.25.Current price is: ₹630.00. / mtr (incl. of all taxes)
    ₹630.00 (incl. GST)
    Yellow and Peach Color Ombre Cotton Hakoba Embroidery Fabric For Women's Top
    Yellow and Peach Color Ombre Cotton Hakoba Embroidery Fabric For Women's Top
    Price: MRP Original price was: ₹1,155.00.Current price is: ₹1,050.00. / mtr (incl. of all taxes)
    ₹1,050.00 (incl. GST)
    Off White color Nylon net embroidery dyeable fabric for Women's Suit Shrug
    Off White color Nylon net embroidery dyeable fabric for Women's Suit Shrug
    Price: MRP Original price was: ₹790.13.Current price is: ₹735.00. / mtr (incl. of all taxes)
    ₹735.00 (incl. GST)
    White color Cotton Cambric Embroidery Dyeable fabric for Women's Kurta
    White color Cotton Cambric Embroidery Dyeable fabric for Women's Kurta
    Price: MRP Original price was: ₹564.38.Current price is: ₹525.00. / mtr (incl. of all taxes)
    ₹525.00 (incl. GST)
    White color Cotton Cambric Embroidery Dyeable fabric for Women's Summer Wear Dress
    White color Cotton Cambric Embroidery Dyeable fabric for Women's Summer Wear Dress
    Price: MRP Original price was: ₹338.63.Current price is: ₹315.00. / mtr (incl. of all taxes)
    ₹315.00 (incl. GST)
    White color Cotton Cambric Embroidery Dyeable fabric for Ladies Casual Top
    White color Cotton Cambric Embroidery Dyeable fabric for Ladies Casual Top
    Price: MRP Original price was: ₹903.00.Current price is: ₹840.00. / mtr (incl. of all taxes)
    ₹840.00 (incl. GST)
    White color Cotton Cambric Embroidery Dyeable fabric for Women's Top
    White color Cotton Cambric Embroidery Dyeable fabric for Women's Top
    Price: MRP Original price was: ₹677.25.Current price is: ₹630.00. / mtr (incl. of all taxes)
    ₹630.00 (incl. GST)
    cotton hakoba fabric
    ₹840.00 (incl. GST)
    Pink Silver Baby Sequin On Mesh Glittery Dress Material
    Pink Silver Baby Sequin On Mesh Glittery Dress Material
    Price: MRP₹1,260.00 / mtr (incl. of all taxes)
    ₹1,260.00 (incl. GST)