Accueil
Vétérinaire

Vétérinaire

La SRA n'est pas habilitée à stocker des produits vétérinaires. Bayer se charge de facturer et livrer votre officine. Cela ne change rien dans vos habitudes, vous passez commande sur le site de Pharmazon, la facture et les produits vous seront livrés séparément. ATTENTION au franco 12 unités panachées comme vous le souhaitez, ET 200€ de commande.

Nous avons également référencé le laboratoire Beaphar, pour lequel Pharmazon se chargera de facturer, et le laboratoire de livrer votre officine. Attention au franco 70€ par commande.

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 = '345' 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