File types

You can use three types of inventory files to maintain your catalog. Depending on your purpose, you can choose the file type to use.

In the Example column, assume that you have 100 items in your inventory. Out of the 100 items, 80 items are available for purchase.

File type	Description	File name	Example
Full inventory file	Define all items in your inventory. Use the `available` column to indicate whether to display the item for purchase. For example, you might have Christmas trees in your warehouse, but you want to display the trees on your storefront during the November and December months.	Include the date of upload and the word `full`. For example: `20180606_store_full.tsv`	Contains 100 rows with the following breakdown: • 80 rows: `available = TRUE` • 20 rows: `available = FALSE`
Reinventory file	Update the entire storefront with only the items you want displayed. Any item not included in the file is automatically marked as unavailable.	Include the date of upload and the word `reinventory`. For example: `20180606_store_reinventory.tsv`	Contains 80 rows with the following breakdown: • You do not have to include the `available` column. • Every row in the file is assumed to be set with ‘available = TRUE’.
Delta file	Update items that have changed.	Include the date of upload and the word `delta` to indicate that this file is a delta file. For example: `20180606_store_delta.tsv`	Contains 4 rows with the following breakdown: • Two rows contain changes to the `available` column, where the value is set to FALSE. • Two rows contain changes to the `cost_price_per_unit` column.