Vend doesn't recognize my Price Book CSV import


Latest update: - Andrea Montes

Problem

When importing a Price Book CSV, the following error appears:

Screenshot_2019-02-26_at_09.27.49.png

Setup

  • Vend for Mac or PC

Cause

There is a non-numerical character in the Retail_price column.

Solution

  1. Go to the Product Page
  2. Go to Price Books
  3. Click on Export Price Book
  4. Open your Price Book CSV file
  5. Go to the Retail_price column
  6. Remove any non-numerical character
  7. Save
  8. Go to the Product Page
  9. Go to Price Books
  10. Click on Add Price Book
  11. Fill the information
  12. Click on Choose File
  13. Select the Price Book CSV file you modified
  14. Click on Save Price Book