Find items that are about to Expire

Inactive items are items that have sold out or been deleted from FillZ. After items sell out or are deleted, FillZ stores the items as 'inactive' items for a period of time, as per your choice on the Settings page of your FillZ account.

You can easily view inactive items that set to Expire in FillZ:

1. Click on Inventory.
2. Change the value in the Qty field from >0 to =0
3. Hit Enter on your keyboard.
4. Click on Last-Modified.

Your listings will then be sorted in order of oldest modifications to newest modifications. The listings at the top of the page are the listings that are set to expire.

To export a file to your computer to view Inactive items:

1. Log into your FillZ account.
2. Click on Export.
3. Using the bottom half of the page (under "Manual Export - Inventory), change the Format to FillZ Inventory Loader.
4. Check the box beside Export items with a quantity of 0.
5. Check the box beside Export items that have been marked as inactive.
6. Click on All Data.

A file with your active and inactive items will then be generated so you can save it to your computer. You can open the file using a product such as Excel. You would want to sort the file by Quantity, and remove any items that have a quantity greater than zero, as FillZ doesn't expire active inventory items. Some of the remaining items are what would be expiring. FillZ doesn't currently export the "Last Modified Date", so you will not be able to determine exactly which items are set to expire.

Helpful Excel Tip:
Sorting:

• Click on the gray box between 1 and A at the top left corner. This will highlight all of the boxes on the screen so you can sort by a field and not have your listings mixed up.
• Now you can click on "Data" and then "Sort", and then choose the column you would like to sort by. You can also choose whether you would like the data to be arranged in ascending or descending order.
• Once you've made your selections, you just need to click on "OK" and you will see the results.