Merchandising implementation

This page helps making your website product catalog available to sync with CS Merchandising. Keeping your catalog up to date and reflecting your live site is key to getting the full value from CS Merchandising.

There are two parts to this process and both need to be completed as soon as possible:

  • Implementing CS Merchandising web tracking on your site
  • Making your product catalog available to Contentsquare

You’ll need to complete the following key tasks:

Content needed from your catalog

Section titled Content needed from your catalog

To benefit from CS Merchandising’s capabilities you’ll also need to provide an updated catalog version that contains all products visible on your site, at all times. Contentsquare is only able to capture data about a product if it is in your product catalog.

  • Any product that is visible on the site should be in the product catalog (even if they are out of stock).
  • If you are launching a new product, make sure it is in your product catalog before launching it on your site.

The product catalog must be provided in either .CSV, .TSV, .XML, or Google Sheets format.

We will be able to map the name of the columns of your catalog with our system, the wording for the information below is just an example.

The catalog must contain, at least, the following information:

SKUIdentifies the product SKU.It must exactly match the SKU that is pushed in the Contentsquare Tag for ‘Transactions’ and ‘Add to Cart’.

It has to be unique.
Model IDIn case of products that have variants, this ID must be common to the SKUs (variants) of the same product.

If it’s necessary, Contentsquare will provide all CS Merchandising data aggregated on the Model ID.
NameIdentifies the product name

It’s needed to display the name of the product in the Merchandising solution.
It’s preferable that it is unique to avoid confusion with another product.
CategoryIdentifies the product category.

It’s needed to classify the products according to their category tree.
It has to use the following format: Shoes > Men > Boots

nb: the ”>” separator used can be different

We can only have 1 categorization per product
URLIdentifies the product page URL on the site

It can be used to match the visits and appearance of the product on the website with the product in the catalog
The URL must be complete (protocol + domain + path)

It has to match with the website’s product page URL

The URL will be stripped of queries and fragments
Image URLURL link to the product image

It’s needed to display the product image in the CS Merchandising solution
Only 1 URL should be indicated in the field

The URL must be complete (protocol + domain + path)
BrandIndicates the name product brand

It allows to have aggregated KPIs for a given brand
PriceIndicates the unit price of the product.

If the product is discounted, the discounted price can be placed in this field or put in another field.

It’s needed to run competitive data analysis, comparing your prices with competitors’
Shipping feesIndicates the product’s shipping fees

It’s only needed for competitive data analysis to compare shipping fees with your competitors’
It’s optional
gtin / EAN / UPCIndicates the EAN / GTIN / UPC of the product. It’s a unique id of the product on the market

It’s used to match products with your competitors’ when running competitive analysis.
It has to be unique

We currently support the following formats: EAN, UPC, GS1, ITF
CurrencyIdentifies the product price’s currency
Stock availability

(mandatory if you want to benefit from stock insights, otherwise optional)
Indicates if the product is “in stock” or “out of stock”
Stock quantity

(mandatory if you want to benefit from stock insights, otherwise optional)
Indicates the stock quantity of the productIt must be a number

Provide your product catalog on a feed

Section titled Provide your product catalog on a feed

Contentsquare will synchronize your product catalog every hour to provide you with the most accurate insights. Before CS Merchandising can sync with your catalog, you’ll need to make it available on a feed.

Make your catalog available on a feed using either of these options:

Once you have chosen a method, let our Implementation Team know so they can assist you.

Upload your catalog on Contentsquare’s secured FTP

Section titled Upload your catalog on Contentsquare’s secured FTP

Provide the Implementation team with:

  • The IP address from which the catalog will be uploaded and to allowlist.
  • A public key in OpenSSH format, for authentication purposes.
  • The exact name of the catalog file that is to be uploaded.

In turn, Contentsquare will provide you with:

  • The SFTP URL.
  • The username (project ID) to perform the upload.

To update the last-in-date catalog, use your private key to authenticate and upload the file.