laboratoire : BIOFREEZE
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`, (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 = '3'
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
INNER JOIN `catalog_product_index_eav` AS `manufacturer_idx` ON manufacturer_idx.entity_id = e.entity_id AND manufacturer_idx.attribute_id = '161' AND manufacturer_idx.store_id = 1 AND manufacturer_idx.value IN('153') WHERE (e.manufacturer NOT IN('5610')) ORDER BY `e`.`gamme_value` ASC LIMIT 96

Laboratoires
- 3M SANTE
- A-DERMA
- AGETI
- ALVITA
- AMDIPHARM
- ARKOPHARMA
- ARROW
- ASCENSIA DIABETES CARE
- ASEPTA
- AVENE
- AVRIL COSMETIQUE BIO
- BABYDERME
- BAILLEUL
- BAYER CONSUMER HEALTH
- BAYER SCHERING PHARMA
- BD MEDICAL
- BEAPHAR
- BEAUTERRA
- BIOCODEX
- BIODERMA
- BIOFREEZE
- BIOSTIME
- BLUE-LENS
- BOIRON
- BOUCHARA
- BRAUN
- BROTHIER-NOGUES
- C'EST MOI QUI L'AI FAIT
- CARRARE
- CATTIER
- CERAVE
- CHAUVIN BAUSCH & LOMB
- CLEANEAR
- COLOPLAST
- CONVATEC
- COVID-19
- CRAZY RUMORS
- CRYOBEAUTY
- DAYANG
- DAZONT
- DERMOPHIL (MELISANA)
- DIFRAX
- DISSOLVUROL
- DODIE
- DUCRAY
- DURANCE
- DUREX
- EA PHARMA
- EAU DE MELISSE
- EG LABO
- ELANCO (MMX, CAPSTAR)
- ELANCO EX-BAYER SA
- ELASTOPLAST
- ELERTE
- ELIXIR & CO
- EUCERIN
- EVERGREEN PARAKITO
- EXPANSCIENCE
- FAMADEM
- GABA
- GALDERMA
- GALLIA
- GENEVRIER
- GIFRER
- GILBERT
- GRAVIER
- GRIMBERG
- GSK
- GUM SUNSTAR
- HARTMANN
- HORIZANE SANTE
- HORUS PHARMA
- HRA
- IGLOO
- INELDEA
- IPRAD
- IPSEN CONSUMER HEALTHCARE
- JOHNSON ET JOHNSON
- KLORANE
- KNEIPP
- LA CHENAIE
- LA ROCHE POSAY
- LABORATOIRES VISIOMED
- LADY GREEN
- LANSINOH
- LAUDAVIE
- LCA
- LEHNING
- LES CHOCHOTTES
- LES PETITS BAINS DE PROVENCE
- LES SECRETS DE LOLY
- LIEBHERR
- LIFESCAN
- LILLY
- LOHMANN & RAUSCHER
- MAM
- MANIX
- MATERIEL BUREAUTIQUE
- MAYOLY SPINDLER
- MEDIATEUR
- MEDIFLUX
- MICROLIFE
- MODILAC
- MÖLNLYCKE
- MUSTELA
- MYLAN MEDICAL
- NAT&FORM
- NATURANCIA
- NEOPULSE
- NESTLE HEALTH SCIENCE
- NHS MENARINI
- NUTRAVALIA
- NUTREOV
- NUTRIBEN
- ORLIMAN (SM EUROPE)
- PEDIACT
- PELUCHO
- PFIZER SANTE
- PHARM'UP
- PHARMACIE DE FRANCE
- PHARMAGUIDEUR
- PHARMASTRA
- PHYTEA DEDICATE
- PHYTO-TERRA
- PHYTOMANIA FRANCE
- PIERRE FABRE MEDICAL CARE
- PIERRE FABRE NATURACTIVE
- PIERRE FABRE ORAL CARE
- PROCTER & GAMBLE HEALTH
- PRODHEX
- PULMOLL
- PURESSENTIEL
- RECKITT BENCKISER
- RESPIRE
- RICHESSES DU MONDE
- ROCHE DIABETES CARE
- ROGE CAVAILLES
- RUBY - OB - NETT
- S.A.D
- SANTE VERTE
- SCHOLL
- SEA-BANDS
- SERVIER
- SMITH AND NEPHEW
- SOFIBEL - FUMOUZE
- SOINEO
- SOLENS
- SOVEDIS
- SUAVINEX
- SUN COAT
- SUNPASS
- SYNERGIA
- TECHNI PHARMA
- TETRA MEDICAL
- TEVA
- TEXTILE FRANCAIS
- THEA
- THERMACELL
- THUASNE
- TILMAN
- TOPICREM
- TRADIPHAR
- U.LABS (Unilever)
- URIAGE
- VICHY
- VISIOCLEAN
- VITAFLOR
- WELEDA
- YOGI TEA
- YOUR GOOD SKIN
- ZAMBON
- ZENTIVA

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

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

Tarifs membres
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.
Booster les ventes
Catalogue
- Télécharger le catalogue CSV
- Télécharger le catalogue XLS
- Télécharger le catalogue winpharma
- Télécharger un catalogue dans win pharma mise à jour non automatique
- Télécharger le catalogue SMART RX mise à jour automatique depuis le LGO
- Télécharger le catalogue LGPI mise à jour automatique depuis le LGO
Aide en ligne

101 rue de la gare
45000 ORLEANS
Tél. : 02 38 84 04 64
contact@sra-pharmazon.com
Association immatriculée au RNA N° W452017434
SIRET : 851 115 501 000 13
TVA intra communautaire : FR92851115501