Import Products from Spreadsheet

When editing either the employee or product (shown to the left) remember these tips:

Sample spreadsheet for product

  1. Never change the column heading from the downloaded template

  2. Be consistent when naming statuses and expire units

  3. Any dated product should have nothing in the expire units

  4. Never leave any rows blank at the end of the spreadsheet

  5. When entering multiple statuses for a product, repeat the product for each status, like Bread in the example.

 

illustration of how spreadsheet data flows into Spoiler alert

Notice how each unique status in the spreadsheet will create a single product status inside Spoiler Alert for you.

The expire times and units of measure will flow into  the product definition inside Spoiler Alert.