Skip to content

Families and attributes ​

A family is a group of products that run well together, for example one bag size. Each product is in at most one family.

An attribute is a named detail a product carries, for example how many vents a bag has, what is printed on it, or which way its wicket faces. You define each attribute once, and then every product can have a value for it.

Families and attributes are yours to name. Otto starts with none, and nothing changes anywhere until you add one.

What they don't change ​

  • Families are not rate groups. Rate groups set how fast the line makes a product and colour its runs on the Scheduler (see Run rates and changeovers). A family is only a grouping. The two are set separately, and setting one never changes the other.
  • Changeovers stay the same. The line still stops for a changeover whenever it switches to a different product, even between two products in the same family. Grouping a day by family saves changeovers only because it puts runs of the same product next to each other.
  • Attributes stay on the product. They are not copied onto purchase orders.

Who can do what ​

  • Everyone in the workspace, viewers included, can see the families, the attributes and each product's values.
  • Owners and admins add, rename and delete families, add and change attributes, and import values from a spreadsheet. Members see Settings → Products as plain text.
  • Owners, admins and members set a product's family and values, on one product or many at once, and sort a day's runs on the Scheduler: the same people who edit products and move runs.
  • Viewers can't change anything. When you view Otto as a teammate, these pages are read-only too.

Set up families and attributes ​

Go to Settings → Products.

Families ​

  • Add family asks for a Name and an Order. The order is the place the family takes in lists, smallest first. Choose Save family.
  • To rename a family or change its order, click into the field, type, and press Enter or click away. Escape puts the saved value back.
  • Products counts the active products in the family.
  • Delete asks you first. The products in the family keep everything else and simply have no family afterwards. Deactivated products in it lose the family too.

A name can be up to 80 characters, and two families can't share a name, whatever the capitals or spaces.

Attributes ​

Add attribute asks for:

  • Label: the name people see, for example "Vents".
  • Key: the short name Otto stores the value under, and the column heading a spreadsheet can use. Otto fills it in from the label, for example "Wicket direction" becomes wicket_direction. Lowercase letters, digits and underscores, starting with a letter.
  • Type:
    • Text takes any words, up to 200 characters.
    • Number takes a number such as 4 or 2.5.
    • Select takes one of a list of options you give, one per line, for example "Top" and "Bottom". Up to 50 options, each up to 80 characters.
  • Unit (optional, up to 20 characters): shown after the value, for example "per bag".

Choose Save attribute.

The Key and Type can't change once saved. To change either, add a new attribute and turn the old one off. You can change the label and unit the same way as a family's name.

To change a select's options, choose Edit next to them, change the list and choose Save options. If you take away an option that products still have, Otto first tells you how many, for example "3 products use “Left”; they’ll show no value until you set them again." Choose Save anyway, or put the option back. Renaming an option takes the old spelling away too. Changing only its capitals doesn't: every product keeps its value, shown in the new spelling.

Turning an attribute off ​

Untick Active to turn an attribute off. Attributes can't be deleted. An attribute that is off disappears from products, filters, the import and the Scheduler, but the values products had stay stored and come back if you tick Active again.

Set them on a product ​

Open the product in Inventory Manager → Inventory. On its Overview tab, the Attributes card has:

  • Family: pick a family, or No family. It saves as soon as you pick.
  • One row per attribute, with its unit. A text or number value saves when you press Enter or click away; Escape puts the saved value back. A select saves as soon as you pick. Empty the box, or pick —, to clear the value.

If a value can't be saved, the reason shows under the row, for example "Enter a number such as 4 or 2.5."

If your workspace uses purchase orders with line fields, the same card also has Order line defaults: values copied onto new purchase order lines for this product. They are edited the same way and are not attributes.

With no families and no attributes yet, the card says so, and owners and admins get a link to Settings → Products.

Find and change many products at once ​

Filter the list ​

Once you have a family, the Inventory list has a Family filter and a Family column. Choose a family, or No family for products without one.

Once you have an attribute, it has an Attribute filter. Pick the attribute, then the value, and choose Apply:

  • a select: one of its options;
  • a number: the exact number, for example 4;
  • text: the whole value, ignoring capitals and spaces at either end.

You can filter by one attribute at a time, together with the family filter, search and the other filters. The filters stay in the page's address, so opening a product and going Back returns you to the same list.

The Family column doesn't sort.

Set a family or a value on many products ​

  1. Choose Select, next to Add item. Each row gets a box to tick; on a phone, tap a product's card to tick it.
  2. Tick the products. A bar above the list counts them.
  3. Choose Set family… or Set attribute…:
    • Set family sets one family on every ticked product, or No family to take them out of their families.
    • Set attribute sets one attribute's value on every ticked product. Leave the value empty to clear that attribute on all of them.
  4. Choose Save. The bar says, for example, "Updated 12 products."

You can set up to 500 products at a time. Other values on those products stay as they are.

Your ticks stay when you sort, filter or search, so you can build up a selection. If some ticked products aren't in the list on screen, the bar says so, for example "3 selected (1 not shown in this list)", so you know before you save. Clear selection, or turning Select off, unticks everything.

The save is all or nothing. If a ticked product was deleted or deactivated meanwhile, nothing is saved: Otto says which product it was, takes it out of your selection, and you can save again for the others.

Import from a spreadsheet ​

Owners and admins can load families and values for many products at once, from Import attributes from a spreadsheet on Settings → Products.

  1. Save your sheet as CSV UTF-8, comma separated.
  2. Choose the file, or paste the text into CSV text.
  3. Choose Preview. This is a dry run: nothing is saved. Otto shows how many rows matched a product, every change it would make (product, field, from, to), the families it would create, and anything it couldn't use.
  4. Read the preview. If it's right, choose Apply. Otto saves exactly what the preview showed.

If anything changed between the preview and Apply, for example someone edited one of the products, nothing is saved and Otto says "Something changed since the preview. Preview again." Changing the text after a preview also means you preview again before you can apply.

The columns ​

The first row names the columns. Capitals and extra spaces in a heading don't matter.

  • Name, Product or Item: the product's name. One of these is required.
  • SKU: optional.
  • Family or Product family: optional.
  • One column per attribute, headed with the attribute's key or its label, for example vents or "Vents".
  • Order line defaults can have columns too, headed the same way.

Any other column is listed under Columns not used and left alone, as is a column for an attribute that is turned off, or a second column for something that already has one (the first column wins).

The headings Name, Product, Item, SKU, Family and Product family always mean the product's name, SKU or family. An attribute labelled with one of those words can't be imported; give it another label first.

How rows find their product ​

  • SKU first. If the row has a SKU and exactly one active product has that SKU (capitals ignored), that's the product. If its name differs from the row's, the preview lists it under Rows matched by SKU to a product with another name, so you can check.
  • Then the name, ignoring capitals and extra spaces.
  • No match: the row is listed under Rows that matched no product and nothing is written.
  • More than one product with that name: the row is listed under Rows that matched more than one product, and nothing is written to any of them. Give each of those rows a SKU that only one product has.

Deactivated products are never matched. If several rows find the same product, they apply from top to bottom, so the lower row wins.

What a cell does ​

  • An empty cell leaves that value, or the family, as it is.
  • A dash (-) clears it.
  • Anything else is the new value, checked the same way as on the product page: a number for a number attribute, one of the options for a select (capitals ignored), up to 200 characters for text. A value that doesn't fit is listed under Values that were not used, and the rest of that row still applies.
  • A family name that matches one of your families (capitals and extra spaces ignored) puts the product in it. A new name, up to 80 characters, is listed under Families to create and created when you apply.

A cell that looks like a spreadsheet formula is kept as plain text and never worked out.

Limits ​

  • Up to 2 MB and 20,000 rows per file. Split a bigger sheet and import each part.
  • A row with more cells than the heading row, usually from a stray comma, is skipped and listed under Rows skipped, never written into the wrong columns.
  • Each list in the preview shows its first 500 entries and says how many there are in all.

Run like products together ​

Once you have a family or an attribute, the Scheduler's Day view shows a Group by box. Choose Family, Rate group (if you have rate groups) or any attribute, and the day's runs are listed under the timeline by group, with each group's bags. None puts the view back. Your choice stays while the page is open and isn't saved.

The Selected run panel also lists a run's family and attribute values, under Product details.

Sort a day's runs ​

Sort today’s runs (or Sort this day’s runs on another day) puts the day's runs in group order, with each product's runs back to back. It first shows you the day Before and After, and how many changeovers that saves, or adds, with the minutes. Nothing moves until you choose Move runs.

  • Only the runs that start that day and haven't started yet move. Runs already under way stay where they are.
  • The group the day starts with stays first, and the group it ends with stays last, so the changeover across midnight doesn't change. When one group holds both, it goes first and the dialog says if the next day's first run will need a changeover it doesn't need now.
  • Otto works out the After order with the same rules as any move, so it shows where runs will really land: a run waiting on materials goes where its materials allow, even onto the next day.
  • If runs on other days would move too, Otto lists them and asks Move runs on other days too? before moving anything.
  • If the day's runs change between the preview and Move runs, nothing moves and Otto shows you the new order.

Anyone who can move runs can sort a day. A viewer sees the new order but can't move the runs. More about the Day view is in Planning the line.

Questions this guide doesn’t answer — contact Otto support. · Privacy policy