Help CenterContact support
All Custos: EU Compliance articles

How do I import a supplier spec sheet with its own column names?

Updated

On this page
  1. Steps
  2. Verify it worked
  3. Good to know
  4. Troubleshooting

The CSV import lets you map the columns of a supplier’s sheet (for example Zutaten or Produkt-ID) onto the import’s columns once, and save that mapping under the supplier’s name. The next sheet from the same supplier is read with the mapping by itself.

Steps

  1. Open Food labels, click Import CSV, choose how rows are matched and changed, and drop the supplier’s CSV file. See importing labels from a CSV file.
  2. Under Supplier columns, each column the import doesn’t know has a list. Pick the import column it fills, such as ingredients for Zutaten, or keep Leave out for columns like internal notes.
  3. Click Apply columns. The file is checked again with your choices and the preview appears.
  4. To reuse the mapping, enter the supplier’s name in Save as and click Save mapping.
  5. Check the preview and save or publish the rows as usual.

Verify it worked

  • After step 4 the import shows Read with the mapping “<name>”, and the Saved mapping list has the supplier’s name.
  • When you drop the next sheet from that supplier, the same sentence appears without mapping anything.

Good to know

  • A saved mapping is applied by itself when the file has every column the mapping names. Upper and lower case don’t matter. When several fit, the one naming the most columns is used.
  • Pick Read the file as it is under Saved mapping to import a file without the mapping, or pick another saved mapping.
  • Each import column can be chosen once per mapping.
  • Saving under the name of the mapping in use replaces it. Another name saves a new mapping. Delete mapping removes the one in use; the file stays mapped until you close the import.
  • You can save up to 50 mappings. They are deleted together with your store’s data 48 hours after you uninstall the app.

Troubleshooting

“Another mapping already has this name”

Pick that mapping under Saved mapping first to replace it, or choose another name.

“You have 50 saved mappings.”

Pick a mapping you no longer need under Saved mapping, click Delete mapping, then save again.

Built and supported by StoreFleet, Shopify app developers since 2021.