- Accueil
- Bureautique
- Produits alimentaires secs
Produits alimentaires secs
SELECT 1 AS `status`, `e`.`entity_id`, `e`.`type_id`, `e`.`attribute_set_id`, `cat_index`.`position` AS `cat_index_position`, `e`.`name`, `e`.`short_description`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`manufacturer`, `e`.`manufacturer_value`, `e`.`small_image`, `e`.`thumbnail`, `e`.`color`, `e`.`color_value`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`status`, `e`.`url_key`, `e`.`required_options`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`msrp_enabled`, `e`.`msrp_display_actual_price_type`, `e`.`msrp`, `e`.`tax_class_id`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`shipment_type`, `e`.`links_purchased_separately`, `e`.`links_exist`, `e`.`cip7`, `e`.`cip13`, `e`.`ean`, `e`.`remise_client`, `e`.`remise_achat`, `e`.`price_catalogue`, `e`.`directlog_fournisseur`, `e`.`directlog_produit`, `e`.`gamme`, `e`.`gamme_value`, `e`.`is_adhesion`, `e`.`is_print`, `e`.`format`, `e`.`format_value`, `e`.`support`, `e`.`support_value`, `e`.`remise_exceptionnelle`, `e`.`stock_exceptionnel`, `e`.`date_remise`, `e`.`stock_initial`, `e`.`is_charge`, `e`.`s30`, `e`.`exclude_groupement`, (SELECT MIN(price) FROM catalog_product_index_price as cpip WHERE cpip.entity_id = e.entity_id AND cpip.website_id = '1' AND cpip.customer_group_id IN(0) ) AS `price`, (SELECT MIN(final_price) FROM catalog_product_index_price as cpip WHERE cpip.entity_id = e.entity_id AND cpip.website_id = '1' AND cpip.customer_group_id IN(0) ) AS `final_price`, (SELECT MIN(tax_class_id) FROM catalog_product_index_price as cpip WHERE cpip.entity_id = e.entity_id AND cpip.website_id = '1' AND cpip.customer_group_id IN(0) ) AS `tax_class_id`, (SELECT MIN(min_price) FROM catalog_product_index_price as cpip WHERE cpip.entity_id = e.entity_id AND cpip.website_id = '1' AND cpip.customer_group_id IN(0) ) AS `min_price`, (SELECT MIN(max_price) FROM catalog_product_index_price as cpip WHERE cpip.entity_id = e.entity_id AND cpip.website_id = '1' AND cpip.customer_group_id IN(0) ) AS `max_price`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, (SELECT MIN(price) FROM catalog_product_index_price as cpip WHERE cpip.entity_id = e.entity_id AND cpip.website_id = '1' AND cpip.customer_group_id IN(0) ) AS `price`, (SELECT MIN(final_price) FROM catalog_product_index_price as cpip WHERE cpip.entity_id = e.entity_id AND cpip.website_id = '1' AND cpip.customer_group_id IN(0) ) AS `final_price`, (SELECT MIN(tax_class_id) FROM catalog_product_index_price as cpip WHERE cpip.entity_id = e.entity_id AND cpip.website_id = '1' AND cpip.customer_group_id IN(0) ) AS `tax_class_id`, (SELECT MIN(min_price) FROM catalog_product_index_price as cpip WHERE cpip.entity_id = e.entity_id AND cpip.website_id = '1' AND cpip.customer_group_id IN(0) ) AS `min_price`, (SELECT MIN(max_price) FROM catalog_product_index_price as cpip WHERE cpip.entity_id = e.entity_id AND cpip.website_id = '1' AND cpip.customer_group_id IN(0) ) AS `max_price`, (SELECT MIN(price) FROM catalog_product_index_price as cpip WHERE cpip.entity_id = e.entity_id AND cpip.website_id = '1' AND cpip.customer_group_id IN(0) ) AS `price`, (SELECT MIN(final_price) FROM catalog_product_index_price as cpip WHERE cpip.entity_id = e.entity_id AND cpip.website_id = '1' AND cpip.customer_group_id IN(0) ) AS `final_price`, (SELECT MIN(tax_class_id) FROM catalog_product_index_price as cpip WHERE cpip.entity_id = e.entity_id AND cpip.website_id = '1' AND cpip.customer_group_id IN(0) ) AS `tax_class_id`, (SELECT MIN(min_price) FROM catalog_product_index_price as cpip WHERE cpip.entity_id = e.entity_id AND cpip.website_id = '1' AND cpip.customer_group_id IN(0) ) AS `min_price`, (SELECT MIN(max_price) FROM catalog_product_index_price as cpip WHERE cpip.entity_id = e.entity_id AND cpip.website_id = '1' AND cpip.customer_group_id IN(0) ) AS `max_price` FROM `catalog_product_flat_1` AS `e`
INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '545'
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 WHERE (e.manufacturer NOT IN('5610')) ORDER BY `e`.`gamme_value` ASC LIMIT 96
Aucun produit ne correspond à la sélection
Laboratoires
- 3M SANTE
- A-DERMA
- AGETI
- ALVITA
- AMDIPHARM
- ARKOPHARMA
- AROMADUNES
- ASEPTA
- AUDISPRAY-DIEPHARMEX
- AVENE
- BAILLEUL
- BAYER CONSUMER HEALTH
- BAYER SANTE ANIMALE
- BAYER SCHERING PHARMA
- BD MEDICAL
- BEAPHAR
- BEWELLCONNECT
- BIOCODEX
- BIODERMA
- BIOFREEZE
- BLUE SKIN
- BOIRON
- BOUCHARA
- BROTHIER-NOGUES
- CATTIER
- CERAVE
- CHAUVIN BAUSCH & LOMB
- COMPEED (HRA)
- COOPER
- CRYOBEAUTY
- DAYANG
- DERMOPHIL (MELISANA)
- DIFRAX
- DISSOLVUROL
- DODIE
- DUCRAY
- DUREX
- EA PHARMA
- EAU DE MELISSE
- EG LABO
- ELASTOPLAST
- ELERTE
- EUCERIN
- EXPANSCIENCE
- FAMADEM
- GABA
- GALDERMA
- GALLIA
- GENEVRIER
- GIFRER
- GILBERT
- GRAVIER
- GRIMBERG
- GSK
- GUM SUNSTAR
- HARTMANN
- HORIZANE SANTE
- IGLOO
- INELDEA
- IPRAD
- IPSEN PHARMA
- JOHNSON ET JOHNSON
- KLORANE
- KNEIPP
- LA ROCHE POSAY
- LABORATOIRES VISIOMED
- LAUDAVIE
- LCA
- LEHNING
- LES CHOCHOTTES
- LES PETITS BAINS DE PROVENCE
- LIFESCAN
- LILLY
- LOHMANN & RAUSCHER
- MAM
- MANIX
- MATERIEL BUREAUTIQUE
- MAYOLY SPINDLER
- MEDA
- MEDIATEUR
- MEDIFLUX
- MERCK MEDICATION FAMILIALE
- MOLNLYCKE
- MUSTELA
- NESTLE HEALTH SCIENCE
- NHS MENARINI
- NUTERGIA
- NUTRAVALIA
- NUTREOV
- OENOBIOL
- ORLIMAN (SM EUROPE)
- PFIZER OTC
- PFIZER SANTE
- PHARM'UP
- PHARMASTRA
- PHARMAVOYAGE
- PHYTEA DEDICATE
- PHYTO-TERRA
- PIERRE FABRE HEALTHCARE
- PIERRE FABRE NATURACTIVE
- PIERRE FABRE ORAL CARE
- POLAAR - ISKIN
- PRESCRIPTION NATURE
- PROCTER & GAMBLE
- PRODHEX
- PULMOLL
- PURESSENTIEL
- RECKITT BENCKISER
- RICHESSES DU MONDE
- RIVADOUCE
- ROC
- ROCHE DIABETES CARE
- ROGE CAVAILLES
- RUBY - OB
- SANOFI GRAND PUBLIC
- SCHOLL
- SERVIER
- SMITH AND NEPHEW
- SOFIBEL - FUMOUZE
- TETRA MEDICAL
- THEA
- THERABEL
- THERAMEX
- THUASNE
- TONIPHARM
- TRADIPHAR
- URIAGE
- VALDISPHARM
- VICHY
- WELEDA
- ZAMBON
- ZENTIVA

+ 7000 références
de médicaments OTC, LNR, et de parapharmacie.

Livraison 72h
sans franco, livraison en 72h par notre transporteur Chronopost.

Tarifs adhérents
négociés par nos acheteurs et réservés aux pharmaciens membres de la SRA.

Besoin de conseil ?
une équipe disponible pour vous répondre du lundi au vendredi.