Our Shopify inventory management app, EZ Inventory, now supports dynamic date variables in the file paths, URLs, and filters.

This update provides a way to retrieve an inventory feed that uses dates in the file path or URL. The feed data can also now be filtered based on the current date.

Below is a list of the available date variables that you can use:

• {{ YYYY }} - the current year (e.g. 2018)
• {{ MM }} - the current month (e.g. 09)
• {{ DD }} - the current day (e.g. 21)

Using Date Variables in FTP or SFTP File Paths

In the File Path field in EZ Inventory, you can specify the file path to be something like this:

/feeds/stock_{{ YYYY }}_{{ MM }}_{{ DD }}.csv

This will be automatically converted by our app to: /feeds/stock_2018_09_21.csv

You can also use the date variables in the directory paths like this:

/feeds/{{ YYYY }}/{{ MM }}/{{ DD }}/stock.csv

This will produce the following: /feeds/2018/09/21/stock.csv

Using Date Variables in the Data Feed Filters

EZ Inventory already has a pretty flexible way of filtering the feed data. With the addition of date variables support, it just got even more flexible.

For example, if you have one big data feed that contains historical inventory data, it might have a "Date" field specifying the date of the stock level. With the date variables, you can now tell our app to only sync the data whose "Date" field matches the current date.

Another use case is if the data feed uses a static filename like "stock.csv" but the feed might not get updated daily and we want to ensure that we only sync the data if it's up to date. So in this case, if the data feed has a date field specifying when the inventory data was last updated, we can then use the date variables in the filters so the Shopify inventory quantity will only get updated if the date in the data feed itself matches the current date.

We hope this latest update will prove useful to our current and future customers. We're still constantly making improvements to our app and we'll be releasing more features in the upcoming weeks.

If you have any questions or suggestions, please don't hesitate to reach out! :)