Are you looking to change your retail labels? To customise your price tags? Selfor brings you a wide range of tags and labels: strung labels, sheets of labels, self-adhesive labels, Brother labelling machines and their accessories... Come and meet us in our Parisian store for advice and ideas of how to personalise your labels !
See description
FIRSTSELECT SQL_CALC_FOUND_ROWS _prix.id_article,_articles.uk,
IFNULL( _articles.titre_uk , IFNULL( _articles.titre_uk, _articles.titre_fr )) AS 'titre_uk', IF( _articles.titre_uk IS NULL , IF( _articles.titre_uk IS NULL , 'fr' , 'uk'), 'uk' ) AS 'titre_langue', _prix.ref_prix as 'reference', _articles.id_categorieA, _articles.id_categorieB, _articles.id_categorieC, _articles.selection , _prix.id_article, Tri_Caract.Nom_fr
FROM _articles
INNER JOIN _prix on _articles.id_article = _prix.id_article
LEFT OUTER JOIN Tri_Trieur on _prix.id_prix = Tri_Trieur.ID_Prix
LEFT OUTER JOIN Tri_Caract on Tri_Caract.ID_Caract = Tri_Trieur.ID_Caract3
WHERE _articles.uk = '1'
AND _prix.actif = '1'
AND ( (_prix.stock > 0 ) )
AND ( (_prix.indispo = 0 ) OR ( _prix.indispo = 1 AND _prix.indispo_date < ADDDATE(_prix.indispo_date, INTERVAL 7 DAY) ) )
AND _prix.SE = 1
AND _articles.id_categorieA = '8' GROUP BY _articles.id_article, Tri_Trieur.ID_Caract3 ORDER BY _prix.date_miseenligne DESC, _articles.ordre, _articles.id_article DESC LIMIT 63, 12
31.14€ TTC - Chain / necklace display labels in sheets - with French inscription ACIER
29.70€ TTC - 25 sheets of plastic earrings presentation labels
38.22€ TTC - Plastic earring display labels in sheets - with French inscription OR 750/1000
38.22€ TTC - Plastic earring display labels in sheets with inscription in French - ARGENT 925/1000
38.22€ TTC - Plastic earring display labels in sheets - with French inscription PLAQUE OR
38.22€ TTC - Plastic earring display labels in sheets - with French inscription ACIER
29.70€ TTC - Pack of 25 sheets of plastic display labels
38.22€ TTC - Plastic chain / necklace display labels with inscription in French - OR 750/1000
38.22€ TTC - Plastic chain / necklace display labels with inscription in French - ARGENT 925/1000
38.22€ TTC - Plastic chain / necklace display labels with inscription in French - PLAQUE OR
38.22€ TTC - Plastic chain / necklace display labels with inscription in French - ACIER
From 16.08€ TTC - Cardboard hang cards for earrings and necklaces (2 models to choose from)
Sign up and stay up to date with our new products and great deals!
OK
Delivery France, Luxembourg, Belgium: Delivery in 48/72 hrs - Other countries: 2 to 5 days according to destination. Some items may take longer to be delivered.