Can I Use the Column Position Instead of a Header Row to Fulfill My Orders?

By default, EZ Fulfill requires a header row as the first row in your CSV or Excel file.  This header row maps the fields in your file to Shopify's fields, filters your source data, replaces values in your file, and parses your source data.

You can use the column number if your file doesn't have a header row.  To do so, click the Use Column Position As Header Row option under the File Format filed on your Data Feed.

When you enable this option, our app automatically adds a header row where the column names are based on the position.  This only gets added within our app; your feed/file won't get modified.

For example, if you have a file without a header row that looks like this:

Enabling the Use Column Position As Header Row option will essentially insert a header row at the top with values from 0 to 7, where the first column is 0, and the eighth column is 7 (this is "virtual," and your file WILL NOT change):

In the Field Mapping settings, you would then specify the column position for the fields you plan on using.  For example, you would put 0 for the Order number and 1 for the Tracking Number, and so on.

Working With Advanced Features

When you have the Use Column Position As Header Row feature enabled, you must use the column position number (starting with position 0) when referencing columns in other data feed configurations that need them.  For example, if you use the Replace Values Configuration and want to replace a tracking company value, you must reference the column by its position.  In our sample from above, the Tracking Company field is in position 2, so this is what we would enter in the Column Name input box as displayed below:

 


App: EZ Fulfill

Tags: faq, fulfillment, data feeds