Login

Create new account

Create Account

Forgot Password

Enter Mobile Number

Enter OTP

  • 300+ Fashion Designers & Global Brands
  • Enjoy 10% off using code INDY10
  • Fashion Stylist at your doorstep. Call at 9205991345
  • Sign up for Complimentary Benefits
Home / designer / Diamond Silk
Filters

Diamond Silk

Diamond Silk is a renowned manufacturer and exporter of handloom and powerloom textiles. Our range includes the finest fabrics, sarees, ladies suits and dupattas, stoles and scarves, and ladies bags (potly, batua, clutch, etc.). Our products are made from 100% pure silk, art silk, cotton silk, and other blends such as organza, brocade, crepe, chiffon, filature, katan, spun, tussar, munga, silk cotton (chanderi), poly cotton (chanderi), PST Poly, and PST Viscose. Our products are available in plain, dobby, and jacquard weaves and feature a variety of prints and embroidery techniques to suit your needs.

15 Product(s)
    SELECT P.productID,P.designerID,P.productName,P.seoUri,P.xOrder,P.productSKU,P.brandName,P.USDproductPrice,P.USDspecialPrice,P.dateModified,DD.brandName AS designerBrandName,P.visibilityID,P.isDTR,P.featuredID,P.productImg,P.instagramImg,P.productPrice,P.specialPrice,P.customField,GROUP_CONCAT(DISTINCT(PI.imageName) ORDER BY PI.imgXorder ASC) AS multiImg,SUM(PS1.productQuantity) AS stockCount FROM fx_product AS P INNER JOIN fx_productimages AS PI ON P.productID=PI.productID INNER JOIN fx_designer_details AS DD ON P.designerID=DD.designerID AND DD.status='1' LEFT JOIN fx_product_specification AS PS1 ON P.productID=PS1.productID WHERE P.designerID = '48' AND P.status = 1 AND P.productStatus='0' GROUP BY P.productID HAVING stockCount>0 ORDER BY P.xOrder ASC LIMIT 0,42
    SELECT P.productID,P.designerID,P.productName,P.seoUri,P.xOrder,P.productSKU,P.brandName,P.USDproductPrice,P.USDspecialPrice,P.dateModified,DD.brandName AS designerBrandName,P.visibilityID,P.isDTR,P.featuredID,P.productImg,P.instagramImg,P.productPrice,P.specialPrice,P.customField,GROUP_CONCAT(DISTINCT(PI.imageName) ORDER BY PI.imgXorder ASC) AS multiImg,SUM(PS1.productQuantity) AS stockCount FROM fx_product AS P INNER JOIN fx_productimages AS PI ON P.productID=PI.productID INNER JOIN fx_designer_details AS DD ON P.designerID=DD.designerID AND DD.status='1' LEFT JOIN fx_product_specification AS PS1 ON P.productID=PS1.productID WHERE P.designerID = '48' AND P.status = 1 AND P.productStatus='0' GROUP BY P.productID HAVING stockCount>0 ORDER BY P.xOrder ASC LIMIT 0,42
    Disk got full writing '.(temporary)' (Errcode: 28 "No space left on device")