Note: This feature is only available to users with administrator role.
Overview
Price Intelligence allows you to manually match competitor listings to products from your own catalog, either individually or in bulk.
There are two primary use cases for adding matches in bulk:
Adding listings you’ve gathered yourself and consider like-matches to your products.
Adding competitive product matches from sites where it’s not possible to automate the matching process.
When bulk importing matches, it’s important to understand the process and the validations our system performs to ensure accuracy and effectiveness.
Step 1 - Prepare your import file
Your file must include columns for your SKU, the competitor URL, and the match type. Make sure all fields are filled out correctly, following the required format:
File format: CSV
3 required columns (with all column names in lower case):
sku: inform the SKU code of the product that should receive the competitor product match.
url: provide the URL of the competitor product listings page.
match_type: specify whether this is an exact or equivalent match. The accepted values are 'exact' and ‘equivalent' in lowercase.
Download this template file for a quick start.
Step 2 - Upload your file
Navigate to the ‘Match Import’ page under Settings and click on ‘Import Matches’ to upload your file
A side drawer will open where you can upload your CSV file with matches, and be notified when the import finishes.
Step 3 - System Check
PI will perform a series of checks before adding a competitor match, such as:
SKU existence: Checks if your SKU is present in your catalog.
Valid URL: Ensures the URL is properly formatted with a protocol, domain name, and path.
Duplicate matches: Verifies if the product has already been matched.
Unauthorized stores: Checks if your environment is authorized to extract products from the listed store.
etc.
Step 4- Review the results
After the import has finished, you will receive a detailed report with the results. validations.
The matches that passed the system validations will be matched to your product catalog. The matches that did not pass the validations will be denied, and the reason will be outlined in the results file.
A report with detailed results of this process will be available to you directly in Price Intelligence, as well as sent to your email after the import has finished (if email notifications are enabled).
Step 4 - Handle errors, if any
In the report you can find 5 types of messages:
Information and Success messages: this means the competitor match was added.
Warning message: this means the competitor match was added, but bypassing common validation rule(s) because the ‘Force Insert’ feature was enabled.
Validation Error message: this means the competitor match was NOT added. Review the full message and make necessary corrections, either in your import file or in your catalog in the Price Intelligence system.
Extraction Error message: this means the competitor match was NOT added. This is only a temporary error that happened during the extraction of that page due to high traffic. If this happens, please try again.
Examples of messages included:
message_type | message |
Information | No action needed. This product was already matched to this SKU. |
Success | Product match added successfully. |
Success | This product was already matched to this SKU but under a different URL. URL has been updated. |
Validation Error | We did not find your informed SKU in your catalog. |
Validation Error | Invalid URL. Please make sure the URL has a protocol, domain name, and path. |
Validation Error | This product was already matched and verified to another SKU 12345 as an exact match. |
Validation Error | A different product from this same store was already matched and verified to this SKU as an exact match. |
Validation Error | We did not find the competitor SKU variant code provided under this URL. Please make sure that the informed competitor SKU variant code and URL are correct. |
Validation Error | The provided URL has multiple SKU variants. Please inform the code of the SKU variant you want in the competitor_sku column in your file. |
Validation Error | Incorrect values in the match_type column. Accepted values are ‘exact’ or 'equivalent', case insensitive. |
Validation Error | Unauthorized store. Your environment is not registered to extract products from this store. |
Validation Error | Not supported character in the SKU column. Only ASCII characters are supported. |
Extraction Error | An error happened during extraction (error code 123). It could be a temporary conflict with other tasks. Please try again. |
After corrections, re-upload the file to process the bulk match import again.