Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

How do I export products of a particular category in magento? 
 
muk_t
Sr. Member
 
Total Posts:  226
Joined:  2012-07-24
 

Hi,

I am trying to export products from a particular category in magento 1.7.0.2 community edition.I also have some products with no categories assigned.

I am using advance data flow profile and following xmlBut all the category product are being exported.

<action type="catalog/convert_adapter_product" method="load">
    <var 
name="store"><![CDATA[0]]></var>    
    <var 
name="filter/category_ids"><![CDATA[44]]></var>
</
action>

<
action type="catalog/convert_parser_product" method="unparse">
    <var 
name="store"><![CDATA[0]]></var>
    <var 
name="url_field"><![CDATA[0]]></var>
</
action>

<
action type="dataflow/convert_mapper_column" method="map">
</
action>

<
action type="dataflow/convert_parser_csv" method="unparse">
    <var 
name="delimiter"><![CDATA[,]]></var>
    <var 
name="enclose"><![CDATA["]]></var>
    <var name="
fieldnames">true</var>
</action>

<action type="
dataflow/convert_adapter_io" method="save">
    <var name="
type">file</var>
    <var name="
path">var/export</var>
    <var name="
filename"><![CDATA[export_selected_category_products.csv]]></var>
</action>

Please help.
Thanks

 
Magento Community Magento Community
Magento Community
Magento Community
 
Store_Manager
Enthusiast
 
Avatar
Total Posts:  867
Joined:  2012-07-09
 

Hello,

Actually, do not know how to update filter of Dataflow export, but I can offer you an alternative solution if you are interested.
By means of the application - Store Manager for Magento you will be able to filter your products (there are filers to show products from selected category and show products not assigned to any category), select the products, right click and export them.

There is 2-weeks free version, so if you want to do it only once or a couple of times, you do not need to pay.
Download the application from here - http://www.magentocommerce.com/magento-connect/store-manager-for-magento.html

Hope it was helpful.

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top