Rank higher in Google Maps
Check out new app Check it out
Increase sales
Collect customer feedback that increases website traffic, drives sales and provides actionable business information.
Control your image
It can be really difficult to reply in time to each review. Automate post-purchase communication, especially when you have profiles on multiple review sites.
Loyal customers
Meet the customers, respond to their concerns and create lasting relationships that will result in more returning visitors.
Building trust
79% of consumers trust reviews, so shorten the process of making decisions by customers. Build trust in your brand by showing your reviews.
Product reviews
Collect positive product reviews from customers for your e-commerce brand's online store and increase sales and SEO
Shopify WooCommerce Deconetwork Baselinker See all
mdi-chat-processing-outline
Blog
Find out what's new
Knowledge base
All technical stuff
Analyze your online image
Our tool gives you an in-depth look at what your company's image looks like
Find out more
mdi-chat-processing-outline
Local SEO Customers Pricing
Sign in
Polish
Swiss
Sign in Sign up for Free Increase sales Control your image Loyal customers Building trust Product reviews Blog Knowledge base Local SEO Customers Pricing Increase sales Loyal customers Control your image Building trust Product reviews Blog Knowledge base API Documentation Customers Pricing Careers Team Reviews Catalog Affiliate Program Terms of Use Privacy Policy Data processing

How to upload a file with customer emails?

How to upload a file with customer emails?

To import the list of customers, follow the steps below.

  1. Go to the Invitations tab.
  2. Click the Import customers button in the top right corner.
  3. Set the date for sending invitations requesting feedback.
  4. Then click Add file and import the prepared contact list.
  5. Finally, click Save changes.
  6. The imported data will appear in the Invitation queue.

In the application, you can download a sample .csv or .xlsx file, which you can then edit according to your needs. Note! Your file should contain a column named 'email' (required). In the file, you can add several columns. Below are their headers along with descriptions.

  • email - customer's email address e.g. '[email protected]' - required column.

  • name - customer's first name or full name e.g. 'John Smith'.

  • phone - user's phone number e.g. '111222333'.

  • website - by specifying this field, we can import emails to multiple pages in Rating Captain simultaneously. This field should be filled with the exact name of the page in the Rating Captain system. By default, if this field is not provided, the import will be saved to the active page.

  • place_name - by adding this field, you specify to which review portal in Rating Captain the customer should be assigned. This field should be the exact name of the review portal in the Rating Captain system. You can find all your connected review portals in the Page => Profiles tab. If you do not provide this field, Rating Captain will automatically assign the platform for reviews.

  • products - list of products in the order. This is an advanced option and requires the help of a programmer. This field should be a valid JSON field. Each object in the array should contain fields such as id - product ID, name - product name, price - product price, optionally image_url - product image URL, product_url - product URL.

The generated file with the specified headers should be saved in Microsoft Excel (.xlsx) or .csv format (values separated by semicolons or commas).

        
<script>
    var RatingCaptain_data_script = {
        /* REQUIRED | Email, on this address will be send message */
            "email": "{$order->email}",
        /* REQUIRED | Order in your system, this field should be unique */
            "external_id": "{$order->id}",
        /* Optional - Products in this order, each product must have id name and price. */
        "products": [
                    {
                        "id": "{$product->id}",
                        "name": "{$product->name}",
                        "price": "{$product->price}",
                        "imageUrl": "{$product->image}",
                    },
        ]
    }
</script>
<script src="https://api.ratingcaptain.com/js_v2/[Your website token]" async></script>

*Each item in bold must be properly configured depending on your system.
*Website token you can find here: Website page.
        
            
<script>
    var rc_products = {/literal}[{foreach from=$items item=i name=list}
{
    'id': '{$i->product_id}',
    'name': '{$i->name}',
    'price': '{$i->price_gross|money_without_currency}',
    'imageUrl': '{$i->product->images[0]->url|product_img_url:th100}'
},
    {/foreach}]{literal};
        var RatingCaptain_data_script = {
            "email": '{client_email}',
            "external_id": '{order_id}',
            "products": rc_products
        }
</script>
<script src="https://ratingcaptain.com/api/js_v2/[Your website token]" async></script>

*Website token you can find here: Website page.
            
        
            
<script>
    var rc_products = [{products}
        {
        "id": "{products.product_id}",
        "price": "{products.float_price}",
        "imageUrl": "{products.img}",
        "name": "{products.name}"
        },
    {/products}];
    var RatingCaptain_data_script = {
        "email": '{email}',
        "external_id": '{order_id}',
        "products": rc_products
    }
</script>
<script src="https://ratingcaptain.com/api/js_v2/[Your website token]" async></script>

*Website token you can find here: Website page.
            
        
            
<script>
    var RatingCaptain_data_script = {
            "email": "[[email]]",
            "external_id": "[[orderid]]"
    }
</script>
<script src="https://ratingcaptain.com/api/js_v2/[Your website token]" async></script>

*Website token you can find here: Website page.
            
        
            
{% block page_checkout_finish_rating_captain %}
    {% set ratingProducts = [] %}
    {% for lineItem in page.order.lineItems.elements %}
        {% if lineItem.type is same as 'product' %}
            {% if lineItem.cover.url %}
                {% set ratingProduct = {
                    id: lineItem.payload.productNumber,
                    name: lineItem.label,
                    price: lineItem.price.totalPrice,
                    imageUrl: lineItem.cover.url,
                } %}
            {% else %}
                {% set ratingProduct = {
                    id: lineItem.payload.productNumber,
                    name: lineItem.label,
                    price: lineItem.price.totalPrice,
                } %}
            {% endif %}
            {% set ratingProducts = ratingProducts|merge([ratingProduct]) %}
        {% endif %}
    {% endfor %}
    {% set ratingCaptainData = {
        email: page.order.orderCustomer.email,
        external_id: page.order.orderNumber,
        products: ratingProducts
    } %}
    <script>
        var RatingCaptain_data_script = [{{ ratingCaptainData | json_encode | raw }}];
    </script>
    <script src="https://ratingcaptain.com/api/js_v2/[Your website token]" async></script>
{% endblock %}

*Website token you can find here: Website page.
            
        

Download a sample file containing only email column.

.csv .xlsx

Download a sample file containing more columns.

.csv .xlsx
Was the article helpful?
mdi-check Yes mdi-close No
Thank you for rate this article.
42 out of 44 found this article helpful
Tabel of contents
Still need help?
If you have not found the information you are interested in, contact us directly. Our support will help to solve your doubts
Contact us
To start
Watch our video explaining the basic functions of Rating Captain.
Watch video