Getting a Missing Column Error or General CSV Error

If you're getting a missing column error or a csv error it usually has to do with having missing headings or misplace headings. Even if a column like email or phone are blank you've got to leave the corresponding headings.


One other consideration is to make sure your CSV is in UTF-8 format. This is the required format for Shopify + Selling Point. If you're using Excel there's a tendency to export CSV's with malformed formatting. You can get around this by using Google Sheets and exporting from there.


Here's a perfect example:

These are all of the columns that are necessary to import.

  1. Code
  2. Initial Value
  3. Balance
  4. Currency

Everything else is optional. However, you do need the headers even if they are empty.


Here's the Gift Card CSV template so it's close at hand:

Download the Selling Point Gift Card CSV

Still need help? Contact Us Contact Us