At the Database menu, you can view information about imported items, events, and users which are used for recommendations.
Items Tab contains the catalog of the imported products from your website. The data displayed here about each product will be the product info that you've synchronized with Yusp through an item feed or the items we crawl from your website directly. By checking your items here, you can troubleshoot your item synchronization as well.
Items are identified by a unique ID (ItemId) and they can have as many custom attributes as required. Attributes are used for meta-data based recommendation, filtering, and optimization of the recommendations, and of course, they're displayed in your Yusp recommendation boxes as well.
Here you can do the following actions:
- review imported items in the database
- import/delete items from the database
- select a view mode - table or list view
- filter and display items by properties
To make sure the items are being imported properly, pay attention to the main properties like ItemID, Title, Description, Image, Price and URL which are used for recommendations on your website. You can add properties to the list by using the icon.
- eventType - type of the events on your website, like VIEW, BROWSE, BUY, ADD TO CART
- itemId - the ID of an item used in a particular event
- userId - the ID for logged in/registered users (if you have login tracking enabled, these are email addresses)
- cookieId - the ID for users that we didn't yet have a userId for
- time - the time when the event occurred
- ...and other product metadata, for product page view events (Title, Description, Price, etc.)
You can import and synchronize the products from your website into the Yusp database via live feeds or catalog files.
If your catalog is available via HTTP, HTTPS, FTP or as an RSS feed, you can set recurrent database updates. Make sure your catalog contains all necessary information, that is (the fields in your feed need to be named exactly as below):
ItemId - unique product identifier
Title - the title of the product
Description - the description of the product
Image - product image URL
Price - the actual sell price of the product
URL - product page URL
CategoryID (optional) - the id of the category, containing the product (can be multiple values - in that case, in an XML, you'll need to have more of the same tag, like <CategoryID>13</CategoryID> <CategoryID>15</CategoryID>, etc.)
categoryPath (optional) - the path of the category containing the product (i.e. Clothes > T-shirts) the separator can be anything, but "/" and ">" are preferred. This can also have multiple values.
To enable the recurrent import of products, check the Enable Recurrent item import button. Insert the URL where your feed is accessible in the appropriate field to enable the periodical import of your catalog. Here you can set a start date and time, and define the import frequency at the "Repeat every" field.
Once the import is completed, you'll see the notification about the successfully imported products. If there was an error, you'll see a red error message in the "Last import results" row.
If everything works fine, save the setting by clicking the "Save" button in the top menu.
By going to the Manual import tab you can import your catalog by uploading a file in a structured format (CSV, TSV or XML) from your local machine. This is a great option to test and troubleshoot a catalog that you're planning to set as a recurrent feed.
At the Installation Tab you can find important information about your Yusp installation, and settings for some core functionalities, such as:
- your tracking code snippet
- a sample buy event tracking code
- product page and ItemId crawling settings
- the possibility to enable testing mode of the recommendation boxes on your website
the possibility to enable users login tracking
The tracking code contains a unique ID that corresponds to your account and is used by Yusp to collect event data on your site. Fro more info on how to insert this code into your site, check the following article - Inserting the tracking code.
Buy event tracking allows you to track purchases customers make on your website. Implementing buy tracking is extremely important, as this is the only way you'll be able to measure the revenue related metrics of Yusp recommendations on your site, such as revenues through recommendations, and "Yusp share" (revenue through Yusp / all revenues). Check the Implementing Yusp Buy Tracking article for some hints on how to implement the buy tracking.
You can enable the testing mode and check how unpublished recommendation boxes would be displayed on your website. Check the checkbox "Recommendation boxes shop up only as tests".
You can also enable login tracking of your users by checking the Allow login tracking box. This will collect all email addresses typed in by your customers during shopping or registration and pair them with Yusp user profiles.