Import/Export Advanced: Nur aktive Artikel exportieren, Varianten mit Option

Hallo JoernBernd,

schätze, das solltest du direkt mit MySQL machen. In etwa so:

SELECT a.name, ad.ordernumber, a.active, ad.instock, aco.name AS Optionname 
FROM s_articles a, s_articles_details AS ad, s_article_configurator_options AS aco, s_article_configurator_option_relations AS acor  
WHERE a.active=1 AND ad.instock>0 AND a.id=ad.articleID AND ad.kind <> 3 AND ad.id=acor.article_id AND aco.id=acor.option_id
ORDER BY a.id;

Lieber Gruß: Martin