Once you know which products you want to include in your guided selling app, you can gather them in a spreadsheet.

Then:

<aside> 💡 Good to know: It may not be necessary to feature every single product in your app; usually, a selection will do nicely.

Learn more: How to optimize your product selection.

</aside>

Prepare your CSV file

<aside> 👉 Looking for a template? We've got you!

Dog food.csv

</aside>

1. Your spreadsheet should contain the following columns:

   • An ID column containing unique values, such as a SKU or EAN number.

     Make sure each product has a unique ID. Multiple products with the same ID will be overwritten. Products without an ID can't be processed.

   • A column with product names.

   • A column with a product URL for each product where the urls link to a product page (https://...).

   • A column with product images in the format of a url. The URL is (https://...) to a product image. Usually such a URL ends in .jp(e)g or .png.

   • Optional: A column that contains the product price. The price does not contain currency characters such as € and any decimals are dot separated. For example: 100.00 instead of €100,-.

   Mandatory columns should not have any empty cells, meaning that the information is filled for every product. And make sure there are no empty rows in your file.

2. Apart from these mandatory columns, we strongly recommend to add columns with additional product properties. For instance, the properties your filters are based on in your webshop. This will help you to create segments you can use while matching the products to the advice.

3. Save or download your file in a CSV format before you upload it to Aiden.

<aside> ❗ A column in your CSV that contains both numbers and text or special characters will be interpreted as text.

Would you like to be able to filter your products using ranges? For example, to match the products that have a price between € 20 and € 50? Then you'll need to make sure that the data in your 'price' columns is interpreted as numbers.

The easiest way to make sure the columns in your file contain only numbers, is to filter them or sort them in a Google Sheet or Excel file.

</aside>

<aside> ❗ Use the correct price format to avoid misinterpretation of your data.

It's important that the price column does not contain currency characters such as €, and that any decimals are dot separated. For example: use 188.99 instead of €188,99. Why? Using commas as separators can lead to misinterpreted data. For example: 188,99 would be turned into a price of € 18899,00.

So, before you upload your CSV, check if your data set doesn't contain any comma separated prices.

</aside>

Upload your CSV file

1. After preparing your file, choose CSV as your important type and select it in the upload dialog.
2. You'll immediately see a preview of your catalogue. Does everything look OK? Click Next.
3. Now you can indicate which columns from your file correspond to which mandatory product properties.

These properties will be used on the advice page your customer will see. For this reason, they're required.

Whenever possible we will pre-fill these with our best guess. Do you see a green ✅ for all columns? Click Next. 4. Your product data will now be uploaded and processed.

What happens when you select the wrong column.....

<aside> 👉 Next:

Learn how to Match products to answers to create the best advice!

</aside>