When we access the product sheet, we can see all the data that has been gathered about a particular product. This information gets updated every time a contact visits the product's page on the site. These sheets are specially useful to know the tags and categories of the products that, along with the other data, we can use in dynamic contents such as related product Inlines. We can also see the explicitly related products that we have previously stipulated on our store, if there are any. When we place an image URL inside a dynamic content, it will be shown like you can see here. Same with the unitary price.
In the case that our site has information that doesn't appear in the sheets, like sizes or colors, you can add custom fields. You can do it by changing your Connectif integration so it can gather this information.
All the data that is shown in the sheets comes from the tool that you're using to manage your ecommerce. Because of that, we can't edit the info from the Connectif sheet. Also, if we want to see the updated information regarding a product, we can click in "verify product now". That way, Connectif will check if the URL is still active and will update the information the same way it would if a client would visit the product page. You can see the last time that sheet was updated, too.
In case that we make changes to our catalog and want to see them reflected on the sheets, there are three ways to do it:
- Visiting the product by ourselves, on the website, after the update.
- Going to the sheet and clicking "verify product now".
- Doing a "massive product synchronization" from the "Catalog" page.
If there is a particular field that is not correct or it doesn't appear in the sheet, we'll update the product to check if it's getting the information. If it's not solved after that, it's convenient to check the catalog from where Connectif gets the information. It could be the case that the information is not actually in the store or that there was an update that altered Connectif's integration.
Inside the product sheet, we can edit three fields:
- Priority: when two products have the same conditions, the one with more priority will come before. In the node "obtain products" there's an option that let's you sort products by priority.
- Units in stock: the number of product left. It doesn't have to match with the real number of units left. By default, Connectif doesn't recommend products that are not in stock. That makes this field useful if we still want the recommendations to show up even if we don't have units left, but we might get latter.
- Black list: in case you want a product blacklisted. They don't get recommended either. It's useful if you don't want to show a particular product. It's not possible to add multiple products to the black list at the same time.
The rest of the information in the sheet can't be changed. Being able to see this information is useful to know what data Connectif is getting from each product. The price that the contacts see is always the unitary price and they include the VAT if it was originally stipulated on the site.
This section also allows us to see which products Connectif establishes as automatically related according to the contact's behavior regarding that product. If we click in "related products", we'll see which products have more chances of receiving clicks when you are looking at their related product. In the first weeks using Connectif, this lists could be a bit confusing and random, since the system gathers information little by little regarding behaviors of both the contacts and the ecommerce.
If the products have variants and we want to recommend them as individual products, we'll give each variant a different ID from our store. That way, they will appear on the site as independent articles.