How Can We Help?

Search for answers or browse our knowledge base.

Print

Kickstart: Sending review requests to past customers

If you have just started your journey with customer ratings and reviews, you may want to consider getting a nice reviews boost from day 1.

Kickstart means sending a batch of invitations to your past customers. Usually, we recommend t 1-3 months back, so that the impressions your customer had while shopping and of the products are still fresh. However, feel free to choose the period you find most relevant based on your preferences and products type.

Specific file and data structure is required for the invitations import not to fail. Please follow the instructions below when creating the import file.

  • Format: CSV file 
  • The first line in the import must always have the column names 
  • All rows in an import must follow the exact same format and data in columns must correspond with the column names 

PRODUCT invitations import

As the name suggests, product reviews are reviews about the quality, looks, usability and other details of your proudcts. Product reveiws are displayed in widgets on product pages.

Obligatory columns for Product reviews Kickstart
  • CustomerName: The full name (both first and last name) of the person getting the review invitation. 
  • CustomerEmail: The email address of the person getting the invitation.  
  • DateOfPurchase: The date the purchase / transaction was made, must be provided in the format YYYY-MM-DD. 
  • ProductID: ProductID can be anything, both numbers and letters. What matters is that ProductID in the file must be exactly the same as the one used in Lipscore integration. Otherwise, reviews will not show under relevant products. To check if the ProductID is the same as one used in the Lipscore integration: Go to a product page > right-click > Inspect > ctrl+f > ls-product-id. If the ID you want to use matches the ls-product-id, it is correct.
  • ProductName: The name of the product being rated / reviewed. If this column is not included but the ProductID is the import will fail. If both columns ProductID and ProductName are not included the person will be invited to write a Service Review. 
  • ProductURL: The fully qualified URL of the product page, including “https://”. 
  • Language: A two letter code of the language the transaction was made in (NO / SE / EN / etc). 
  • *GTIN: The Global Trade Item Number of the product / service that is being rated / reviewed. Can be an EAN code, ISBN, etc. Obligatory ONLY for the purpose of showing stars in Google Shopping. 

Non-obligatory: 

  • Brand: The brand of the product / service that is being rated / reviewed. 
  • Category: The category your product / service belongs to. 
  • Currency: The currency of the price that is being specified. 
  • Price: The price of the product / service that is being rated / reviewed. 
Product review Kickstart data structure that can be imported via copy-paste into Data field

CustomerName;CustomerEmail;DateOfPurchase;ProductID;ProductName;ProductURL;Language
Donna Paulsen;donna@mysite.com;2022-01-01;6268A;Emma’s Miracle shampoo – thinning hair;https://emmastone.com/shampoo/miracle-thinning-hair/6268;en

SERVICE reviews import

Service reviews, often referred to as Company reviews, are reviews about delivery, website, performance of your customer support representatives, and other parts of your customers’ general shopping experience.

Obligatory columns for Service reviews import
  • CustomerName: The full name (both first and last name) of the person getting the review invitation 
  • CustomerEmail: The email address of the person getting the invitation.  
  • DateOfPurchase: The date the purchase / transaction was made, must be provided in the format YYYY-MM-DD. If this column is not included today’s date will be used. 
  • Language: A two letter code of the language the transaction was made in (NO / SE / EN / etc). 
Service review Kickstart data structure that can be imported via copy-paste into Data field

CustomerName;CustomerEmail;DateOfPurchase;Language 
Donna Paulsen;donna@mysite.com;2022-01-01;en

File correctness checklist 

  • Check if the top row displays column names and if all data follows the column names.
  • Check for special characters (e.g. Norwegian å, Å, ø, Ø, æ, Æ) and correct them if necessary  
  • Check if all data is correct (e.g. Date format) 
  • Check if the file coding is UTF-8

How to import invitations

  1. Save the file as CSV file with semicolon as a delimiter
  2. Go to Invitations and click Invitations import link at the top of the website
  3. Choose First invitation date – invitations will be scheduled based on the Invitation delays set up in the Invitations setup but no invitations will be sent before the selected first invitation date.
  4. Set Semicolon as delimiter
  5. Upload the file or copy data from your CSV file and paste them in the Data field
  6. Import

Depending on the number of invitations data in your file the import will take a while. When you refresh the page, you will see the progress of the import under the Data field. The invitations will now be scheduled and automatically sent. You can find the scheduled invitations in the Invitations section.

Common errors in Kickstart imports

When tracking the progress of your import you may notice that some invitations get correctly Imported and some get Errors. Some errors can be ignored, others need to be given a closer look. Here are the most common errors.

Customer has this purchase already. 

This customer purchased the same product less than 90 days after the previous purchase – and Lipscore does not create invitations for such purchases (read more about the 90/14 days rule).

Row has invalid columns format/count. 

The imported data is incorrect – something is missing, there is semicolon in a wrong place, and others. Take a close look at instructions vs the line that returned an error.

The purchase doesn’t contain any products

Information about product is missing in the data you are trying to import.

Buyer cannot be found/created

Information about customer is missing in the data you are trying to import.

Lang is empty

Information about language is missing in the data you are trying to import.

Products are blocked

The data you are trying to create an invitation for contains products that belong to Blocked category based on the setting in Settings > General > Blocked products.

Monthly invitations limit has been reached

If your invitations limit is set up on a monthly basis, this simply means that you have no more invitations left in your package. Contact the Lipscore team to increase your package or switch to yearly limit.

User has a purchase within blockage period

If you have set up a specific period for blocking invitations (Settings > Invitation setup > Number of days to block new invitations for repeat customers) this error means that the purchase you are trying to import falls under the criteria of blocked invitations.

Table of Contents