You can enrich your existing data by importing new data to your Sniffie account on your own. This can be done through the Product Catalog's upload data option. To import new data from the Product Catalog view you must click the three dots in the upper right corner of the toolbar.
Clicking on this icon will open a modal with the following three options:
The upload data modal has three options to choose from.
Update existing product data (will not update prices)
The first of the possible upload options is to update existing product data. This is useful when you want to enrich already existing information with new data, e.g. color, category info, size, etc...
To get started with enriching the products that you want, make sure to filter down the product catalog so that only the products that you want to update are filtered. This ensures that the file you work with does not become too big. After filtering down successfully, you can download the data by clicking the Export data icon. You can choose between .csv and .xlsx file types.
How to update existing product data in Sniffie:
Open up your data file, in Excel for example
Find the column you want to add data to
Add data to as many columns you want (Not price)
Delete the unnecessary columns that you did not alter. However, do not delete or alter the first column (ID). This is how we know what product to update.
Download / Export the file as .csv
Upload the file to Sniffie with the Upload data modal.
Our system will check the file validity. If it’s valid, the upload will start. Depending on the amount of products you've updated, this may take a while. Millions of products may take a few minutes.
A success message will be displayed when the upload is finished. It’s okay to navigate away. The import will continue in the background.
Upload reference products
If you have a reference catalog that is not available online, don’t worry. You can import an offline reference catalog as a CSV file. Just follow these steps:
How to import offline reference catalog to Sniffie
To upload reference products you must have editor permissions for your organization.
You need to have an Excel file with the following case sensitive column names: Category, Website name, Product name, Price (needs to be a floating point number with dot as a decimal separator)
Optional fields include: Store name, Brand, Currency in ISO 4127 format, and everything else (such as EAN, SKU, Custom columns etc.)
Please note that if there are multiple columns with the same name, the right-most column’s value is the value that will be retained.
Read this article which defines how unique products are identified in Sniffie’s Product Catalog.
Every row needs to have information in the compulsory fields or the row will be skipped.
Save the Excel file as CSV to a location that you can easily access (e.g. desktop).
Select the Upload reference products option.
Select the file to upload or drag and drop the file that you want to add.
Click the browse button and select your saved CSV file.
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.
A success message will be displayed when the upload is finished. It’s okay to navigate away. The import will continue in the background.
Upload new prices or campaigns for your products
You can use the upload data function to update prices or schedule new pricing campaigns for your products. However, this is only possible when you have established a working integration between Sniffie and your eCommerce platform. If you have no active integration, updating prices or scheduling campaigns with data uploads is not possible.
To get started with uploading new prices or campaigns, use filters to filter down your products in the Product Catalog view so that only the products that you want to update are displayed. This ensures that the file you work with does not become too big.
After you have filtered for the products you want to update, you can download the product data by clicking the Export data icon. You can choose between .csv and .xlsx file types.
How to upload new prices or campaigns in Sniffie:
Open up the file you downloaded from Sniffie
Delete all columns except the first column, ID (we use this to distinguish the product in Sniffie).
Add the following case sensitive column names New price, Comparison Price, Start date, End date.
Input the pricing information
Download/export the file as CSV (.csv)
Upload the file to Sniffie through the Upload data modal in Product Catalog by selecting the option to upload new prices or campaigns..
Our system will check the file validity. If it’s valid, the upload will start. Depending on the amount of products affected, this may take a while. Millions of products may take a few minutes.
A success message will be displayed when the upload is finished. It’s okay to navigate away. The import will continue in the background.
Example of a file that is used to upload prices to Sniffie.
A few key points to keep in mind when pricing / setting campaigns using spreadsheets:
The New price column is the price that will take place in the set Start date
If Start date is left empty, the price change will take effect immediately.
If End date is left empty, the price change will stay in effect until the price is changed again somehow.
If Start date and End date are set, the new price will stay on your web store for the set period of time. When the End date is reached, the price will be restored to what it was before the initial price change. The only officially supported date format is ISO date (i.e. date formatted in YYYY-MM-DD HH:mm:ss) and you might get errors if you use any other date formats.
If Comparison price is set, the product's price is changed to be a discounted price, where the discounted price is New price and Comparison price is the price which is shown as the comparison. If Comparison price is empty, product's price is changed as a normal price.
In some cases you may encounter an error when you try to upload new prices for your products. Some events that can trigger an error are:
End date is set before Start date, or date format is incorrect.
Start date has already happened.
The New price field contains non-numeric information
The Comparison price field contains non-numeric information
Product ID:s are incorrect