Start Free Trial
Start Free Trial

Use Matrixify export filters for Shopify data exports

Learn to apply Matrixify export filters for customizing your Shopify data exports in the Matrixify app.
This can be incredibly useful when you want to focus on a particular collection, product, or other data sheet, or when you’re looking to speed up the export process by reducing the amount of data being exported.
So, let’s dive in and learn how to make your data exports better tailored to your needs!

Where to find Matrixify export filters?

Once you’ve selected the data sheets you want to export (like Products, Collections, Customers, etc.), you can click on that sheet card to open it and see three sections “Select Columns”, “Customize Columns” and “Set Filters”.
Under the “Set Filters” section click on the “Filter” button to open a list of filters for your selected export sheet.

where to locate filter in the Matrixify app - export data backup Shopify CSV XLSX

Understanding each export filter

Each possible filter is unique as it filters by different attribute or column values and thus has different conditions that can be set for it.
We have documented each possible filter for each data sheet so that you can find filters that best match your specific use case:

Combining multiple Matrixify export filters

All the filters set for the same entity sheet will be applied with AND logical condition. Meaning that all the applied filters will need to match for that item to be included in the export.
For example, if you apply “Files” sheet filters “Type: Image” and “Created At: Big Bang – 2024-01-25” then only Files that are images and created before 2024-01-25 will be exported.

The AND condition is specifically between different filters not within any individual filter. For some individual filters, you might have various selectable conditions, for example equals to any of, which allow you to list multiple values where any of the listed values need to match.

3 - use multiple combined filters in the same entity export for Shopify data export with Matrixify

Troubleshooting common issues with Matrixify export filters

Total item count and estimated export duration change

When you apply a filter in the Matrixify app, the item count and estimates will not change as the app does not know how many items match the applied filters.

For some filters, Matrixify still has to run through all your store data to find those items. So, don’t worry if the count and estimate don’t change right after applying the filter. Once you start the export, the app will begin processing the store data with filters applied.
The Total item count will remain the same for the whole job duration as it represents the total count of items for this entity in the store, but the Exported item count will represent exported items and thus show the filter working.
Matrixify app Shopify data export report backup export item counter CSV Excel XLSX

Filter did not make the export faster

Applying a filter does not necessarily speed up the export process. The Matrixify app still has to run through all your store data to find the items that match the filter criteria.
For some filters, the Matrixify app can filter by querying the Shopify API directly so they might show a sudden jump in the processed item count when the export job is running.

Date filter with the “relative date” condition did not include recent items

Condition “relative date” is available for all the date filters and it is unique – it allows applying filters dynamically which is useful for repeated exports but it might come with some confusion on how it is working.
The “relative date” condition filters the last full date period.

For example, if your export has a filter Created Atrelative dateLast: 1 days and it starts at 10 am, it will export everything for the full calendar “yesterday” – from >= 00:00 till < 00:00 (to be very precise with date boundaries).
All the time filters are applied in your store time zone.
The same example if using filter Last: x hours, for example, Last: 3 hours. If export starts at 15:43, the app will apply the filter last 3 full hours – from >= 12:00:00 until < 15:00:00 (less than 15:00:00).

What to do next?