SELECT xcart_products.*, xcart_quick_flags.*, xcart_quick_prices.variantid, xcart_pricing.price, xcart_products_lng_en.product, xcart_products_lng_en.descr, xcart_products_lng_en.fulldescr, xcart_variants.avail as avail, xcart_variants.weight as weight, xcart_variants.productcode as productcode FROM xcart_products INNER JOIN xcart_pricing ON xcart_pricing.productid = xcart_products.productid AND xcart_products.forsale = 'Y' AND xcart_products.product_type <> 'C' INNER JOIN xcart_quick_flags ON xcart_quick_flags.productid = xcart_products.productid INNER JOIN xcart_quick_prices ON xcart_quick_prices.productid = xcart_products.productid AND xcart_quick_prices.membershipid = '0' AND xcart_quick_prices.priceid = xcart_pricing.priceid INNER JOIN xcart_products_lng_en ON xcart_products_lng_en.productid = xcart_products.productid INNER JOIN xcart_products_categories ON xcart_products_categories.productid = xcart_products.productid AND xcart_products_categories.avail = 'Y' INNER JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid LEFT JOIN xcart_category_memberships ON xcart_category_memberships.categoryid = xcart_products_categories.categoryid LEFT JOIN xcart_product_memberships ON xcart_product_memberships.productid = xcart_products.productid WHERE xcart_category_memberships.membershipid IS NULL AND xcart_product_memberships.membershipid IS NULL AND xcart_products_categories.categoryid='5501' AND ( xcart_variants.avail > 0 OR xcart_products.product_type NOT IN ('','N')) GROUP BY xcart_products.productid ORDER BY xcart_products_categories.orderby ASC, xcart_products_lng_en.product ASC, xcart_products.productcode ASC, xcart_products.productid ASC
SELECT xcart_products.*, xcart_quick_flags.*, xcart_quick_prices.variantid, xcart_pricing.price, xcart_products_lng_en.product, xcart_products_lng_en.descr, xcart_products_lng_en.fulldescr, xcart_variants.avail as avail, xcart_variants.weight as weight, xcart_variants.productcode as productcode FROM xcart_products INNER JOIN xcart_featured_products ON xcart_products.productid=xcart_featured_products.productid AND xcart_featured_products.avail='Y' AND xcart_featured_products.categoryid='5501' INNER JOIN xcart_pricing ON xcart_pricing.productid = xcart_products.productid AND xcart_products.forsale = 'Y' AND xcart_products.product_type <> 'C' INNER JOIN xcart_quick_flags ON xcart_quick_flags.productid = xcart_products.productid INNER JOIN xcart_quick_prices ON xcart_quick_prices.productid = xcart_products.productid AND xcart_quick_prices.membershipid = '0' AND xcart_quick_prices.priceid = xcart_pricing.priceid INNER JOIN xcart_products_lng_en ON xcart_products_lng_en.productid = xcart_products.productid INNER JOIN xcart_products_categories ON xcart_products_categories.productid = xcart_products.productid AND xcart_products_categories.avail = 'Y' INNER JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid LEFT JOIN xcart_category_memberships ON xcart_category_memberships.categoryid = xcart_products_categories.categoryid LEFT JOIN xcart_product_memberships ON xcart_product_memberships.productid = xcart_products.productid WHERE xcart_category_memberships.membershipid IS NULL AND xcart_product_memberships.membershipid IS NULL AND ( xcart_variants.avail > 0 OR xcart_products.product_type NOT IN ('','N')) GROUP BY xcart_products.productid ORDER BY xcart_featured_products.product_order, xcart_products_lng_en.product ASC, xcart_products.productcode ASC, xcart_products.productid ASC
Caporicci Shoes | Dellamoda.com
The website uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Click to learn more. 
    
Login or Register | (0)
?Help
  • Toll Free : 800-515-8523
  • International Calls : 310-622-4490
  • Contact Us
USD ($)

Caporicci Shoes

About the Brand:

Established in 1962 CAPORICCI represents quality, elegance and pride. Founded by master craftsman Domenico Caporicci inherited the delicacy of footwear construction in Italy. From the refinement of stitching to managing an enterprise at an early age propelled innovative techniques that swept the footwear industry across the globe. Collaborating with Browns Shoes in Montreal, Canada launching his first retail line, later became CEO of Munari in 1974, Italy. Domenico Caporicci enhanced the design, equipment and production of European footwear. Based in Miami, Florida CAPORICCI products are solely manufactured in Italy and America’s leading Exporter of Alligator Skin in the United States.