Skip to content
KernoHelp Center
    Open Kerno
    Help CenterTroubleshooting & FAQMy import says a column is matched to two fields

    Troubleshooting & FAQ

    My import says a column is matched to two fields

    Each column in your file can feed one field only. On Match your columns, if you choose the same column for two fields, both fields show a message such as "Also…

    1 min readUpdated November 13, 2026

    Each column in your file can feed one field only. On Match your columns, if you choose the same column for two fields, both fields show a message such as "Also matched to SKU. Choose another column for one of them." and Preview import stays grayed out.

    To fix it:

    1. Find the two fields with the message. The note above the buttons names the column and both fields.
    2. For one of them, choose another column, or Not imported.

    The messages clear. Each column in the list shows which field it already feeds, so you can spot one that's taken.

    Preview import also stays grayed out while a required field has no column. The message names the fields, such as "Choose a column for Category, Quantity on hand to continue."

    More in Troubleshooting & FAQ

    Still need a hand?

    Our support team is here when you need a person.

    Contact support

    Related guides

    • A material's stock is valued at $0
    • A product I buy and resell shows No cost
    • A product I just created isn't on the Margins card or in the reports
    • Complete production says to record the actual quantity
    • How do I reach support?
    • I can't change my workspace currency
    • I can't choose per lb when I create an ingredient in the library
    • My BOM came in as two versions
    • My BOM from a recipe shows long decimals
    • My import says a SKU needs a cost
    • My import says rows "will be created" after I imported
    • My production run says "Unsaved changes"
    • My supplier SKU import skips every row
    • My teammate's invitation doesn't work
    • QA says "Quality checks recorded" but I haven't checked anything
    • The preview says rows are ready, but the button says Import 0 rows
    • What does "A new version of Kerno is ready" mean?
    • What does Open Demand count?
    • When do materials come out of stock during a run?
    • Where do I find a customer's order history?
    • Why can't I turn on automatic reordering for a supplier?
    • Why did a low-stock alert come a few minutes after my stock changed?
    • Why doesn't my variant show its own price?
    • Why is Delete grayed out on a recipe version?
    © 2026 Kerno, Inc. All rights reserved
    Privacy Policy (opens in a new tab)Terms of Service (opens in a new tab)Cookies (opens in a new tab)