Guidance

How to complete a CSV file for IPAFFS (plants and plant products)

Updated 14 May 2024

You can use a CSV file to upload commodity details about plants and plant products to the Import of products, animals, food and feed system (IPAFFS).

You must enter the values into the CSV file exactly as they appear in this guide.

Download the IPAFFS CSV template file.

The previous version of the CSV template is no longer supported.

If you try to upload a CSV file using the previous template, you鈥檒l get the following error message: 鈥榃e do not recognise these column headings 鈥 download the CSV template and try again鈥.

The updated CSV template includes an 鈥業ntended for final users (or commercial flower production)鈥 column, which is required for some plants and bulbs that are for planting. This replaces the 鈥業ntended for final user or propagated鈥 column in the previous version.

Commodity code

Required for all commodities.

Enter a commodity code.

IPAFFS allows you to search for commodities by genus and species when creating your import notification. You can use this search feature to look up the correct commodity codes you need.

Genus and species

Enter a valid scientific name for the commodity, such as 鈥楥hamaecrista comosa var. capricorna鈥. You can enter a European and Mediterranean Plant Protection Organisation (EPPO) code into column C instead and leave the genus and species column blank.

Use the to find the scientific names.

EPPO code

Enter an EPPO code from the .

You can enter the genus and species into column B instead of entering an EPPO code.

Variety

Required for fruit and vegetables (commodity codes starting with 07 and 08) which are Horticultural Marketing Inspectorate (HMI) and Specific Marketing Standard (SMS) regulated.

The value must match the name of a variety in IPAFFS, including spaces and capital letters.

Class

Required for fruit and vegetables (commodity codes starting with 07 and 08) which are HMI and SMS regulated.

Your answer must match one of these values exactly, including spaces and capital letters:

  • Class I

  • Class II

  • Extra Class

Intended for final users (or commercial flower production)

Required for some plants and bulbs (commodity codes starting with 06 and 07) which are for planting.

Your answer must match one of these values exactly, including capital letters:

  • Yes

  • No

If you鈥檙e importing bulbs

If the bulbs are intended for final users or commercial flower production, enter 鈥榊es鈥 in this column. Otherwise, enter 鈥楴o鈥.

You only need to enter a value for the following commodity codes:

  • 06011010 (Hyacinths)

  • 06011020 (Narcissi)

  • 06011030 (Tulips)

  • 06011040 (Gladioli)

  • 06011090 (Other)

If you鈥檙e importing plants

If the commodity is intended for final users, enter 鈥榊es鈥 in this column. Otherwise, enter 鈥楴o鈥.

You only need to enter a value for the commodity codes shown in the following table.

Commodity code Commodity heading Commodity name
06012010 Bulbs, tubers, tuberous roots, corms, crowns and rhizomes, in growth or in flower; chicory plants and roots Chicory plants and roots
06012030 Bulbs, tubers, tuberous roots, corms, crowns and rhizomes, in growth or in flower; chicory plants and roots Orchids, hyacinths, narcissi and tulips
06012090 Bulbs, tubers, tuberous roots, corms, crowns and rhizomes, in growth or in flower; chicory plants and roots Other
0601209010 Bulbs, tubers, tuberous roots, corms, crowns and rhizomes, in growth or in flower; chicory plants and roots Plants (rhizomes in flower) of Colocasia Schott
0601209090 Bulbs, tubers, tuberous roots, corms, crowns and rhizomes, in growth or in flower; chicory plants and roots Other
06021010 Unrooted cuttings and slips Of vines
06021090 Unrooted cuttings and slips Other
0602109010 Unrooted cuttings and slips Mormodica L., Solanum Melogena L. and Trichosantes L.
0602109090 Unrooted cuttings and slips Other
06022010 Trees, shrubs and bushes, grafted or not, of kinds which bear edible fruit or nuts Vine slips, grafted or rooted
06022020 Trees, shrubs and bushes, grafted or not, of kinds which bear edible fruit or nuts With bare roots
06022030 Trees, shrubs and bushes, grafted or not, of kinds which bear edible fruit or nuts Citrus
06022080 Trees, shrubs and bushes, grafted or not, of kinds which bear edible fruit or nuts Other
0602300010 Rhododendrons and azaleas, grafted or not Rhododendrons
0602300090 Rhododendrons and azaleas, grafted or not Azaleas
06024000 Roses, grafted or not Roses, grafted or not
0602400010 Roses, grafted or not Cuttings
0602400090 Roses, grafted or not Other
06029020 Other Pineapple plants
06029030 Other Vegetable and strawberry plants
06029041 Other Forest trees
06029045 Other Rooted cuttings and young plants
06029046 Other With bare roots
06029047 Other Conifers and evergreens
06029048 Other Other
06029050 Other Other outdoor plants
0602905010 Other Mormodica L., Solanum Melogena L. and Trichosantes L.
0602905090 Other Other
06029070 Other Rooted cuttings and young plants, excluding cacti
06029091 Other Flowering plants with buds or flowers, excluding cacti
0602909110 Other Potted plants not exceeding 1m in height
0602909190 Other Other
06029099 Other Other
0602909910 Other Potted plants not exceeding 1m in height
0602909990 Other Other

Number of packages

Required for all commodities.

Enter the number of packages for this commodity in your consignment. You must use digits only.

You can find the number of packages on your phytosanitary certificate.

Do not use commas in numbers over 999. For example, enter one thousand packages as 1000.

Type of package

Required for all commodities.

Use the following list of codes to identify the type of packaging used to transport this commodity.

Your answer must match one of these codes exactly, including capital letters.

If your answer does not match one of these codes, the type of package will default to 鈥極ther鈥 when uploaded to IPAFFS.

顿别蝉肠谤颈辫迟颈辞苍听听听听听听听听听听听听听听听听听听听听听听听听听听听听听 Code
叠补驳听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听 叠骋听听
叠补濒别听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听 叠尝听听
叠辞虫听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听 叠齿听听
Bulk solid granular particles (鈥済rains鈥) 痴搁听听
颁补苍听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听 颁础听听
颁补谤迟辞苍听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听 颁罢听听
颁补蝉别听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听 颁厂听听
颁补蝉办听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听 颁碍听听
颁辞蹿蹿别谤听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听 颁贵听听
颁辞苍迟补颈苍别谤听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听 颁狈听听
颁谤补迟别听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听 颁搁听听
笔补肠办补驳别听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听 笔碍听听
笔补濒濒别迟听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听 笔齿听听
罢谤补测听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听 笔鲍听听
罢耻产别听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听 罢鲍听听
痴颈补濒听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听听 痴滨听听
Wood barrel聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽 叠础听听
Wood bundle聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽 叠贰听听
Wood case with pallet base聽聽聽聽聽聽聽聽聽聽聽聽聽聽 贰贰听听
Wood crate聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽 8叠听听

Quantity

Required for all commodities.

This is the quantity of the commodity in this row.

You must use digits only.

For example, if the consignment has 10 boxes of the same commodity and each box contains 100 bulbs, the quantity is 1000.

Do not use commas in numbers over 999. For example, enter one thousand bulbs as 1000.

This number relates to the Quantity type value that follows in the CSV file.

Quantity type

Required for all commodities.

This is the measurement unit used for the commodity you are importing.

Your answer must match one of these codes exactly, including capital letters.

顿别蝉肠谤颈辫迟颈辞苍听听听听听听听听听听听听听 Code
叠耻濒产蝉听听听听听听听听听听听听听听听听听听听 叠尝叠听
Corms and rhizomes聽聽聽聽聽聽 颁搁窜听
碍颈濒辞驳谤补尘蝉听听听听听听听听听听听听听听听 碍骋惭听
笔颈别肠别蝉听听听听听听听听听听听听听听听听听听 笔颁厂听
Plants in tissue culture 笔罢颁听
厂别别诲蝉听听听听听听听听听听听听听听听听听听听 厂顿厂听
厂迟别尘蝉听听听听听听听听听听听听听听听听听听听 厂罢惭听

Net weight (kg)

Required for all commodities.

This is the net weight of the entire commodity in this row, measured in kilograms (kg).

The net weight (kg) value must:

  • be a number only 鈥 do not include 鈥榢ilograms鈥 or 鈥榢g鈥
  • be 0.001 or greater
  • use no more than 3 decimals, for example 12.345 not 12.3456

Do not use commas to separate numbers over 999. For example, enter one thousand kilograms as 1000.

Controlled atmosphere container

Optional (leaving this blank will default to 鈥楴o鈥 when uploaded to IPAFFS).

This identifies if the commodity is being stored in a controlled atmosphere container.

Your answer must match one of these values exactly, including capital letters:

  • Yes
  • No