RIS-SC-1005

Multi-Channel Price Comparison

Description

This query compares prices of products listed on different channels (Amazon, eBay, Etsy, and a website) for a given keyword. It determines which channel offers the cheapest price for each product and provides comments based on the price comparisons.
image 13
male female graphic designers interacting computer
female web designer taking notes office
How to generate the report: a step-by-step guide
  1. Select the Multi-Channel Price Comparison report in the Query type drop-down menu.
  2. Write your Amazon, eBay, Etsy, and Website links in the textbox.
  3. Click the Generate Report button.
  4. Select the Time Zone and click the Download (CSV file) button when downloading the report.

Summary

This query retrieves price information for products listed on different channels and compares them to determine the channel offering the cheapest price for each product. It allows searching for products based on a keyword and provides comments indicating which channel has the best price. The data can be useful for pricing strategy and competitive analysis across multiple sales channels.

Reported Values

The report returns the following values:
Column NameDescription
LWSKUStock Keeping Unit (SKU) from Linnworks.
ItemTitleTitle of the item.
BarcodeNumberBarcode number of the item.
Amazon1.PricePrice of the item on Amazon.
Ebay1.PricePrice of the item on eBay.
Website.PricePrice of the item on the website.
Etsy1.PricePrice of the item on Etsy.
CommentsComment indicating the channel with the cheapest price for each item.
young team coworkers working project

Parameters

@Amazon1: Specifies the sub-source for Amazon.

@Ebay1: Specifies the sub-source for eBay.

@Etsy1: Specifies the sub-source for Etsy.

@keyWord: Allows partial trailing match for an SKU to search for specific products.