Sometimes you have a reference catalog that is not available online. Don’t worry, you can import an offline reference catalog with a CSV file! Just look into the following these steps.

How to import offline reference catalog to Sniffie

  1. You need to be on an editor for your organization.
  2. You need to have an Excel file with the following column names (case sensitive):CategoryWebsite nameProduct namePrice (needs to be a floating point number with dot as a decimal separator)
  3. Optional fields include:Store nameBrandCurrency in ISO 4127 format.Everything else (such as EAN, SKU)
  4. Please note that if there are multiple columns named the same name, the right-most column’s value will be retained.
  5. Read this article to define how unique products are identified in Sniffie’s product catalog.
  6. Every row needs to have information in the compulsory fields or it is skipped.
  7. Save the Excel file as CSV to a location that you can easily access (e.g. desktop).
  8. Go to your product catalog in Sniffie.
  9. Click the “Upload data to product catalog” button at the top right of the table.
  10. A modal will appear. Select file to upload or drag and drop the file that you want to add.
  11. Click the “browse” button and select your saved CSV file.
  12. Our system will check the file validity. If it’s valid, the import will start. Depending on the amount of product imported, this may take a while. Millions of products may take a few minutes.
  13. You will get a success message when the import is finished. It’s ok to navigate away, since the import will be going on in the background.

Did this answer your question?