Export by category and status

Stan82

Hi there,
is there a way to filter exported products in stock based on product category? For example, if I only want to export stock status for products in my shirts category.

Also, is there an option to filter daily orders based on the default WC order status, for example, to export all orders marked as "completed"?

Thank you

japiera

Hi Stan82 ,

Thanks for your post.

ATUM Export Pro allows filtering by any of the fields in a template. Please read this article: https://stockmanagementlabs.crunch.help/en/atum-export-import-pro/exporting-from-scratch#filtering

You can use the filters to filter by category, dates, and Order statuses.

Best Regards,
José Andrés

Stan82

Hi, thank you for your reply.

I have tried the category filter, but can I export only 1 specific category and all its products?

Kind regards.
Stan

japiera

Hi Stan82 ,

Please use the "in" clause. It should work:

Best Regards,
José Andrés

Stan82

Thanks again for the reply.
That looks great.

We have an issue where categories are shown only for items with no variations.
If the item has variations (clothing, sizes, and colors) it doesn't show a category for it.

japiera

Hi Stan82 ,

Unfortunately, categories are linked to the parent variable products, not to their variants, so filtering by category won't include variations. I'm sorry.

Best Regards,
José Andrés