Read only some of the rows of a file

A file does not always hold one kind of item. A shop's own export has its products and the variations of its variable products in rows of one file, with a column such as Type saying which is which. A configuration reads one kind of item, so it needs to read only the rows of its kind. That is what Rows to read does: the rows that do not meet the condition are left out.

Choose the rows#

In the editor, find the section Rows to read and tick Read only some of the rows of the file. Then say which rows to read, from the cell of one column:

Write several values separated by commas. Capitals and spaces around a value do not matter. A cell that holds several values, such as simple, downloadable, virtual in a WooCommerce export, is read value by value: the row where it is simple, virtual is a row where Type is one of simple.

A column the file does not have counts as empty. The column the condition reads is one the configuration uses, so a later file without it is stopped before anything is checked, as for any other column (when columns change).

One file, two configurations#

The same file can be dropped on two configurations. Say a file has the rows of a variable product and of its sizes:

• The configuration for Products reads the rows where Type is none of variation: the vest.
• The configuration for Product variations reads the rows where Type is one of variation: its two sizes.

Each configuration is checked and published on its own, so each has its own review. Publish the products first when the variations belong to products that are new (variable products).

What a row that is left out is#

• It is not read. It is not checked, so a mistake in it is not an error, and no item is made or changed for it. It does not count as a write.

• It is not deleted. An item that an earlier file made from a row that is now left out stays exactly as it is on the site.

• It is counted. The review says what the configuration read and how many rows it left out, next to the number of rows of the file:

  

• The file's limits count every row of the file, also those that are left out: at most 10,000 rows (prepare your first spreadsheet).

In the preview#

The preview of the editor shows one sample row at a time. When the configuration leaves the row out, the preview says so instead of showing values: This row is not read: only rows where Type is variation are read, and its Type is “variable”. Choose another sample row to see what a row that is read gives.

When something is wrong#