Sometimes it’s just wise to import offline data to existing products. This may really help with matching processes, especially using Sniffie’s bulk AI matcher. Note that bulk AI matcher is an experimental feature currently in testing at Sniffie Nightly, mostly by Sniffie data team.
How it works
- Create a Sniffie product feed link normally.
- Copy the link you are creating. Don’t only download the CSV.
- Add &format=csv&forUpdate=1 at the end of the link.
- Paste the link to your browser.
- A CSV file will download. The first column will be named dont_change_this. DO NOT ALTER VALUES IN THIS COLUMN. DO NOT CHANGE THE POSITION OF THIS COLUMN.
- Open a CSV file in Excel and copy paste data from from you offline Excel. Use VLOOKUP with a unique value to get values correctly.
- Save the file as a CSV in a location that you find.
- Remove all unnecessary columns except dont_change_this and your imported offline data. If you don’t remove unnecessary columns, those will be imported as offline data. You most likely don’t want that.
- Remove all empty rows or rows that have some weird data like #N/A.
- Go to your product catalogue. Click the import offline data button.
- A warning modal will open. Click “Accept” if you are sure you have not altered the dont_change_this column values.
- Once you click accept, click the browse button and select the CSV file you saved in Step 7.
- If your data is properly formatted, the update will start. You can update up to one million products with one CSV.
- If the data is not properly formatted, you will get an error.
Please note that all documents imported to Sniffie platform need to be in UTF-8 format.
How to import product tags
- Follow the above steps until you have dont_change_this.
- Create new columns for tags you want the product to have. All columns should start with product_tag: followed by the tag name. There is no limit of how many product tags you can update for a single query.
- Every single row needs to have a non-empty value (regardless of the value) for them to be tagged.
- When you import, your products are tagged automatically with the tags you provide. You can go to the product tag manager to see the end result. Here is an example of how product tagging could be made:You can mark any value in the “any value” cells as shown in the example though the actual Tag that will be shown in Sniffie is the one that you mark as a title of the column E.g.Example1. Also, note that products with empty values E.g.ID B will not be tagged as shown in “Example 2” because it has an empty value in the example.
The following columns override the existing value in the product catalogue (instead of adding new imported data). Overriding these will not result in new product appearing in the catalogue regardless of the uniqueness criteria Sniffie uses.
- Product name
- Product code