Campanie cupoane Cadou 3.07.2017 -20.07.2017

Campanie cupoane 10% inapoi la comenzile peste 500 lei.

In perioada 3.07.2017 -20.07.2017 orice comanda plasata pe siteul www.claumarpescar.ro cu o valoare mai mare de 500 lei va primi automat un cupon de reducere valabil in 10 zile din momentul in care statusul comenzii se schimba in "Predata La Curier" si are o valabilitate de 30 zile pe toate categoriile din siteul www.claumarpescar.ro, exceptie fac produsele care se afla intr-o alta promotie.

Termenii si conditiile cuponului

Cuponul este valabil pe toata oferta de produse aflata pe site-ul www.claumarpescar.ro exceptie facand produsele aflate in alte oferte, deasemenea exceptie mai fac urmatoarea lista de brand-uri.

Cuponul trebuie folosit in totatlitate pe o singura comanda.

Cuponul poate fi folosit doar pe magazinul online NU si in magazinul fizic.

Daca totalul comenzii inaintea aplicarii cuponului depaseste 100 lei intra in promotia Transport Gratuit.

Cuponul poate fi transmisibil el putand fi folosit si in cazul clientilor care nu au cont sau adresa de email.

Queries: 9, Total time: 0.746 ms [By time] [By id] [By file]

1 (0.091)

SELECT data
FROM `oc_session`
WHERE session_id = '6e307d100bebd823ff51e13efc'

/var/www/clients/client1/web1/web/system/library/session/db.php:24

2 (0.077)

SELECT `trigger`, `action`
FROM oc_event

/var/www/clients/client1/web1/web/index.php:453

3 (0.095)

SELECT *
FROM oc_url_alias
WHERE keyword = 'campanie_cupoane_cadou_3-07-2017_20-07-2017.html'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48

4 (0.123)

SELECT DISTINCT *
FROM oc_information i
LEFT JOIN oc_information_description id ON (i.information_id = id.information_id)
LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE i.information_id = '27' AND id.language_id = '2' AND i2s.store_id = '0' AND i.status = '1'

/var/www/clients/client1/web1/web/catalog/model/catalog/information.php:9

5 (0.078)

SELECT *
FROM oc_information_to_layout
WHERE information_id = '27' AND store_id = '0'

/var/www/clients/client1/web1/web/catalog/model/catalog/information.php:34

6 (0.068)

SELECT *
FROM oc_information_to_layout
WHERE information_id = '27' AND store_id = '0'

/var/www/clients/client1/web1/web/catalog/model/catalog/information.php:34

7 (0.065)

SELECT *
FROM oc_information_to_layout
WHERE information_id = '27' AND store_id = '0'

/var/www/clients/client1/web1/web/catalog/model/catalog/information.php:34

8 (0.063)

SELECT *
FROM oc_information_to_layout
WHERE information_id = '27' AND store_id = '0'

/var/www/clients/client1/web1/web/catalog/model/catalog/information.php:34

9 (0.086)

SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37