POSSIBILE RITORNO PRODOTTO E RIMBORSO

Query: LEFT JOIN `jos_{vm}_product_price` ON `jos_{vm}_product`.`product_id` = `jos_{vm}_product_price`.`product_id`
 LEFT JOIN `jos_vm_product_discount`
ON (`jos_vm_product`.`product_discount_id` = `jos_vm_product_discount`.`discount_id` OR `jos_vm_product`.`product_discount_id` = '0')  WHERE `jos_{vm}_product_category_xref`.`product_id`=`jos_{vm}_product`.`product_id`
 AND `jos_{vm}_product_category_xref`.`category_id`=`jos_{vm}_category`.`category_id`
 AND `jos_{vm}_product_category_xref`.`category_id`=34
 AND ((`jos_{vm}_product`.`product_id`=`jos_{vm}_product_price`.`product_id` AND `jos_{vm}_shopper_group`.`shopper_group_id`=`jos_{vm}_product_price`.`shopper_group_id`) OR `jos_{vm}_product_price`.`product_id` IS NULL) 
 AND `jos_{vm}_shopper_group`.`default` = 1
 AND ((`product_parent_id`='0') OR (`product_parent_id`='')) 
 AND (`product_publish`='Y')  
 AND `product_publish`='Y' 
 AND `category_publish`='Y' 
 GROUP BY `jos_{vm}_product`.`product_sku` 
 ORDER BY `jos_{vm}_product_category_xref`.`product_list` ASC

GRAVITY 172 GREY-20%
GRAVITY 172 GREY
100% Polyester, Powerloomed
Dimensioni - Prezzo
120cm x 156cm - 131.25 € 105.00 €
133cm x 185cm - 172.50 € 138.00 €
160cm x 235cm - 263.75 € 211.00 €
200cm x 285cm - 400.00 € 320.00 €
HALI BEIGE RED
HALI BEIGE RED
100% Heatset.
Dimensioni - Prezzo
170cm x 230cm - 269.00 €
KLASSIK 315A CHERRY
KLASSIK 315A CHERRY
100% Acrylic Heatset.
Dimensioni - Prezzo
80cm x 150cm - 34.00 €
133cm x 190cm - 72.00 €
160cm x 230cm - 105.00 €
200cm x 290cm - 165.00 €
Bedroom Set - 92.00 €
OLYMPIA 6045A RED
OLYMPIA 6045A RED
100% Acrylic.
Dimensioni - Prezzo
GRAVITY 150 BEIGE-20%
GRAVITY 150 BEIGE
100% Polyester, Powerloomed
Dimensioni - Prezzo
120cm x 156cm - 131.25 € 105.00 €
133cm x 185cm - 172.50 € 138.00 €
160cm x 235cm - 263.75 € 211.00 €
200cm x 285cm - 400.00 € 320.00 €
GRAVITY 153 IVORY-20%
GRAVITY 153 IVORY
100% Polyester, Powerloomed
Dimensioni - Prezzo
120cm x 156cm - 131.25 € 105.00 €
133cm x 185cm - 172.50 € 138.00 €
160cm x 235cm - 263.75 € 211.00 €
200cm x 285cm - 400.00 € 320.00 €
KLASSIK 1019A CHERRY
KLASSIK 1019A CHERRY
100% Acrylic Heatset.
Dimensioni - Prezzo
80cm x 150cm - 34.00 €
133cm x 190cm - 72.00 €
160cm x 230cm - 105.00 €
200cm x 290cm - 165.00 €
Bedroom Set - 92.00 €
VINTAGE 23014-953
VINTAGE 23014-953
Acrylic Heatset,Polyester.
Dimensioni - Prezzo
166cm x 236cm - 210.00 €
Bedroom Set - 190.00 €
KLASSIK 2288A CHERRY
KLASSIK 2288A CHERRY
100% Acrylic Heatset.
Dimensioni - Prezzo
133cm x 190cm - 72.00 €
160cm x 230cm - 105.00 €
200cm x 290cm - 165.00 €
ELITE 16959-675
ELITE 16959-675
Acrylic, Polyester.
Dimensioni - Prezzo
160cm x 230cm - 210.00 €
200cm x 290cm - 325.00 €
ELITE 16955-095
ELITE 16955-095
Acrylic, Polyester.
Dimensioni - Prezzo
160cm x 230cm - 210.00 €
ELITE 16954-953
ELITE 16954-953
Acrylic, Polyester.
Dimensioni - Prezzo
160cm x 230cm - 210.00 €
Bedroom set - 200.00 €
ASSOS 17515-095
ASSOS 17515-095
Acrylic, Polyester.
Dimensioni - Prezzo
160cm x 230cm - 210.00 €
200cm x 250cm - 280.00 €
200cm x 290cm - 325.00 €
ASSOS 17180-095
ASSOS 17180-095
Acrylic, Polyester.
Dimensioni - Prezzo
133cm x 190cm - 145.00 €
160cm x 230cm - 210.00 €
200cm x 250cm - 280.00 €
200cm x 290cm - 325.00 €
ASSOS 17222-095
ASSOS 17222-095
Acrylic, Polyester.
Dimensioni - Prezzo
160cm x 230cm - 210.00 €
200cm x 250cm - 280.00 €
200cm x 290cm - 325.00 €
ASSOS 17194-095
ASSOS 17194-095
Acrylic, Polyester.
Dimensioni - Prezzo
160cm x 230cm - 210.00 €
200cm x 290cm - 325.00 €
OUSHAK 555 LIGHT BLUE
OUSHAK 555 LIGHT BLUE
100% Acrylic Heatset,Powerloomed
Dimensioni - Prezzo
120cm x 170cm - 86.00 €
160cm x 230cm - 155.00 €
200cm x 250cm - 210.00 €
200cm x 300cm - 250.00 €
240cm x 300cm - 300.00 €
VINTAGE 23024-956
VINTAGE 23024-956
Acrylic Heatset,Polyester.
Dimensioni - Prezzo
166cm x 236cm - 265.00 €
200cm x 290cm - 310.00 €
Bedroom Set - 190.00 €
ELITE 16969-095
ELITE 16969-095
Acrylic, Polyester.
Dimensioni - Prezzo
160cm x 230cm - 210.00 €
VENUS 17521-695-25%
VENUS 17521-695
100% Acrylic.
Dimensioni - Prezzo
160cm x 230cm - 265.00 € 198.75 €
200cm x 290cm - 415.00 € 311.25 €
VENUS 17520-695-25%
VENUS 17520-695
100% Acrylic.
Dimensioni - Prezzo
200cm x 290cm - 415.00 € 311.25 €
OLYMPOS 15893-670
OLYMPOS 15893-670
Acrylic, Polyester.
Dimensioni - Prezzo
160cm x 230cm - 185.00 €
200cm x 290cm - 290.00 €
OLYMPOS 15891-630
OLYMPOS 15891-630
Acrylic, Polyester.
Dimensioni - Prezzo
160cm x 230cm - 185.00 €
200cm x 290cm - 290.00 €
OLYMPOS 15891-620
OLYMPOS 15891-620
Acrylic, Polyester.
Dimensioni - Prezzo
160cm x 230cm - 185.00 €
200cm x 290cm - 290.00 €
Bedroom Set - 200.00 €
OLYMPOS 15890-670
OLYMPOS 15890-670
Acrylic, Polyester.
Dimensioni - Prezzo
160cm x 230cm - 185.00 €
200cm x 290cm - 290.00 €
OLYMPOS 15889-761
OLYMPOS 15889-761
Acrylic, Polyester.
Dimensioni - Prezzo
160cm x 230cm - 185.00 €
200cm x 290cm - 290.00 €
OLYMPOS 15889-010
OLYMPOS 15889-010
Acrylic, Polyester.
Dimensioni - Prezzo
200cm x 290cm - 290.00 €
MOHAMADI 15404-110-20%
MOHAMADI 15404-110
100% Acrylic Heatset Frise.
Dimensioni - Prezzo
200cm x 290cm - 265.00 € 212.00 €
MOHAMADI 15402-110-20%
MOHAMADI 15402-110
100% Acrylic Heatset Frise.
Dimensioni - Prezzo
160cm x 230cm - 170.00 € 136.00 €
200cm x 290cm - 265.00 € 212.00 €
ZIEGLER 1629 IVORY NAVY
ZIEGLER 1629 IVORY NAVY
100% Heatset Frise.
Dimensioni - Prezzo
133cm x 195cm - 105.00 €
170cm x 240cm - 175.00 €
200cm x 290cm - 239.00 €
Bedroom Set - 149.00 €
ZIEGLER 1594 RED IVORY
ZIEGLER 1594 RED IVORY
100% Heatset Frise.
Dimensioni - Prezzo
133cm x 195cm - 105.00 €
170cm x 240cm - 175.00 €
200cm x 290cm - 239.00 €
ZIEGLER 1594 IVORY RED
ZIEGLER 1594 IVORY RED
100% Heatset Frise.
Dimensioni - Prezzo
133cm x 195cm - 105.00 €
170cm x 240cm - 175.00 €
200cm x 290cm - 239.00 €
ZIEGLER 1594 L.BROWN IVORY
ZIEGLER 1594 L.BROWN IVORY
100% Heatset Frise.
Dimensioni - Prezzo
133cm x 195cm - 105.00 €
170cm x 240cm - 175.00 €
200cm x 290cm - 239.00 €
ZIEGLER 1267 RED IVORY
ZIEGLER 1267 RED IVORY
100% Heatset Frise.
Dimensioni - Prezzo
133cm x 195cm - 105.00 €
170cm x 240cm - 175.00 €
200cm x 290cm - 239.00 €
Bedroom Set - 149.00 €
ZIEGLER 1260 RED IVORY
ZIEGLER 1260 RED IVORY
100% Heatset Frise.
Dimensioni - Prezzo
133cm x 195cm - 105.00 €
170cm x 240cm - 175.00 €
200cm x 290cm - 239.00 €
Bedroom Set - 149.00 €
ZIEGLER 1259 IVORY RED
ZIEGLER 1259 IVORY RED
100% Heatset Frise.
Dimensioni - Prezzo
133cm x 195cm - 105.00 €
170cm x 240cm - 175.00 €
200cm x 290cm - 239.00 €
VEGAS CLASSIC 5001 CHERRY
VEGAS CLASSIC 5001 CHERRY
100% Heatset
Dimensioni - Prezzo
133cm x 190cm - 70.00 €
160cm x 230cm - 105.00 €
200cm x 290cm - 169.00 €
VEGAS CLASSIC 5001 BEIGE
VEGAS CLASSIC 5001 BEIGE
100% Heatset
Dimensioni - Prezzo
133cm x 190cm - 70.00 €
160cm x 230cm - 105.00 €
200cm x 290cm - 169.00 €
VEGAS CLASSIC 1266 CHERRY
VEGAS CLASSIC 1266 CHERRY
100% Heatset
Dimensioni - Prezzo
133cm x 190cm - 70.00 €
160cm x 230cm - 105.00 €
200cm x 290cm - 169.00 €
VEGAS CLASSIC 1266 BEIGE
VEGAS CLASSIC 1266 BEIGE
100% Heatset
Dimensioni - Prezzo
133cm x 190cm - 70.00 €
160cm x 230cm - 105.00 €
200cm x 290cm - 169.00 €
ZIEGLER 1629 RED NAVY
ZIEGLER 1629 RED NAVY
100% Heatset Frise.
Dimensioni - Prezzo
133cm x 195cm - 105.00 €
170cm x 240cm - 175.00 €
200cm x 290cm - 239.00 €
Bedroom Set - 149.00 €
ZIEGLER 1631 IVORY RED
ZIEGLER 1631 IVORY RED
100% Heatset Frise.
Dimensioni - Prezzo
133cm x 195cm - 105.00 €
170cm x 240cm - 175.00 €
200cm x 290cm - 239.00 €
Bedroom Set - 149.00 €
OUSHAK 555 BROWN
OUSHAK 555 BROWN
100% Acrylic Heatset,Powerloomed
Dimensioni - Prezzo
160cm x 230cm - 155.00 €
200cm x 300cm - 250.00 €
OUSHAK 554 TERRA
OUSHAK 554 TERRA
100% Acrylic Heatset,Powerloomed
Dimensioni - Prezzo
160cm x 230cm - 155.00 €
200cm x 300cm - 250.00 €
FORTUNE 1901J
FORTUNE 1901J
Acrylic Heatset,Viscose Powerloomed
Dimensioni - Prezzo
133cm x 190cm - 145.00 €
160cm x 235cm - 215.00 €
200cm x 250cm - 285.00 €
200cm x 285cm - 325.00 €
FORTUNE 502X
FORTUNE 502X
Acrylic Heatset,Viscose Powerloomed
Dimensioni - Prezzo
160cm x 235cm - 215.00 €
FORTUNE 501J
FORTUNE 501J
Acrylic Heatset,Viscose Powerloomed
Dimensioni - Prezzo
160cm x 235cm - 215.00 €
OUSHAK 753 D.BROWN BEIGE
OUSHAK 753 D.BROWN BEIGE
100% Acrylic Heatset,Powerloomed
Dimensioni - Prezzo
160cm x 230cm - 155.00 €
200cm x 250cm - 210.00 €
200cm x 300cm - 250.00 €
240cm x 300cm - 300.00 €

Tutto il materiale, in qualsiasi forma, su questo sito è protetto da copyright, dai Greci e il diritto internazionale. Il materiale su questo sito possono essere utilizzati solo per uso personale. Nulla di quanto contenuto nel presente Sito soprattutto le foto e i video dei nostri prodotti non possono essere copiati, modificati, pubblicati o distribuiti in qualsiasi modo senza il previo consenso di Doup.gr.