As a rule, Lipscore schedules invitations for purchases automatically when orders reach a status specified in the onboarding and integration process (e.g., when order is Complete, order data is automatically sent to Lipscore, invitation is created and sent to a shopper after a speficied number of days).

However, in some usecases it makes more sense to schedule invitations manually and this is also possible in your Lipscore account.

Let’s go through invitations import process step by step.

Data format

You can import invitations in various ways:

• By uploading a CSV file with data
• By copy-pasting data from a CSV file
• By typing in the data

Very secific file / data structure is required for the invitations import not to fail. Please follow the instructions below when creating the import file.

• Format: CSV file with UFT-8 coding or data copy-pasted / manualy typed in, separated by comma or semicolon
• The first line in the import must 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.

IMPORTANT: In order to send ONLY product review invitations, make sure to change the ratio of service reviews in your account to 0% in Settings – Invitation setup – General – Percent of service reviews. If this setting has a different ratio (e.g., 10% for service, 90% for product invitations), the imported invitations will be scheduled according to this setting.

Product review import file structure

>> CLICK THIS LINK TO SEE A TEMPLATE WITH INSTRUCTIONS <<

Required data for PRODUCT REVIEW invitations import

• CustomerName: Preferably, full name (both first and last name) of the person getting the review invitation. If they made a purchase anonymously (e.g., using only the first name or a nickname), use the name they provided. The name provided in the file will be display next to their review.
• CustomerEmail: The email address of the person getting the invitation.  
• DateOfPurchase: The date the purchase was made, must be provided in the YYYY-MM-DD format (e.g., 2022-12-01)
• ProductID: ProductID in the file must be exactly the same as the one used in Lipscore integration. Otherwise, reviews will not show on relevant product pages. 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). 

Optional but highly recommended data for PRODUCT REVIEW invitations import

• GTIN number: The Global Trade Item Number of the product / service that is being reviewed. Can be an EAN code, ISBN, etc. Without this number, ratings and reviews will not have a chance to show in Google organic results or Google Shopping ads.
• Category: The category your product / service belongs to. If you are using Product attributes feature and would like to choose different sets of questions for various categories, or would like to be able to block products that belong to a specific category from being rated and reviewed, or would like to force a service invitation on some product categories – category data will be required.
• SKU number – number for the purchased product variant. This can also be the same as Variant ID
• VariantID – use this field for the unique ID of a specific product variant being reviewed. If the product has variations (like size or color), enter its variant-level ID.
• VariantName -this field specifies the variant of the main product, describing distinctive features like color
• ProductImageURL: If you want to include a picture of the product in the review invitation, this is where you provide the URL for the product image.

Non-obligatory: 

• Brand: The brand of the product / service that is being rated / reviewed. 
• Currency: The currency of the price that is being specified. 
• Price: The price of the product / service that is being rated / reviewed. 

Required data for product review invitations import from physical stores:

• SourceID: The ID of your physical store that is used in the Lipscore integration.
• SourceName: The name of your physical store that is used in the Lipscore integration.
• ParentSourceID: The Parent ID of the group of stores that is used in the Lipscore integration.
• ParentSourceName: The name of a group of stores used in the Lipscore integration.

Service review import file structure

>> CLICK THIS LINK TO SEE A TEMPLATE WITH INSTRUCTIONS <<

Required data for SERVICE REVIEW invitations 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). 

Required data for service review invitations import from physical stores:

• SourceID: The ID of your physical store that is used in the Lipscore integration.
• SourceName: The name of your physical store that is used in the Lipscore integration.
• ParentSourceID: The Parent ID of the group of stores that is used in the Lipscore integration.
• ParentSourceName: The name of a group of stores used in the Lipscore integration.

Example of importable data format

PRODUCT review invitations

CustomerName;CustomerEmail;DateOfPurchase;ProductID;ProductName;ProductVariantID;ProductVariantName;ProductURL;Language
Donna Paulsen;[email protected];2022-01-01;6268A;Emma's Miracle shampoo;123456701;Emmas Miracle shampoo - thinning hair;https://emmastone.com/shampoo/for-redheads/6268;en
Harvey Specter;[email protected];2022-01-01;2214A;Emma's Miracle shampoo;123456701;Emmas Miracle shampoo - thinning hair;https://emmastone.com/shampoo/for-men/2214A;en
Lucky Luke;[email protected];2022-12-01;3183B;Emma's Miracle shampoo;123456701;Emmas Miracle shampoo - thinning hair;https://emmastone.com/shampoo/for-toys/3183B;en

Example of importable data format – SERVICE review invitations

CustomerName;CustomerEmail;DateOfPurchase;Language
Donna Paulsen;[email protected];2022-01-01;en
Harvey Specter;[email protected];2022-01-01;en
Lucky Luke;[email protected];2022-12-01;en

Data 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, product IDs) 
• If you are importing a file, check if the file coding is UTF-8

How to import invitations

1. Save the file as CSV file
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. Choose the correct delimiter
5. Upload the file / Copy data from your CSV file or type data 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 when importing a file / data

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.