Barry Analytics Channel Integration for Linnworks Guide


1. Dashboard

In Barry Analytics , Dashboard displayed with following information :

    1. Revenue, Orders count view

    2. Revenue Chart: Source / Subsource wise Revenue view

    3. Total Orders (Order list table, Country Map ): Total Orders view Country wise

    4. Top 50 Selling SKU Chart (SKU list table, SKU Chart): Top 50 Selling SKU view


1.1 Revenue, Orders count view

barry_dock_dashboard_1

    • Total Revenue

    barry_dock_dashboard_2

    We get total revenue in first tab that is already calculated here. It is the total income of a business from all platforms / channels selected in configuration from beginning of your business.
    By watching this revenue has rough idea how much amount of total revenue generated for your business.

    • This Month Revenue

    barry_dock_dashboard_3

    Monthly revenue in second tab displayed revenue of your current month. You can see comparison of this month revenue with previous month.

    You can see comparison of this month revenue with previous month percentage wise.

    • Previous Month Revenue

    barry_dock_dashboard_4

    Previous Month Revenue in third tab displayed revenue of your previous month. You can see comparison of previous month revenue with previous to previous month percentage wise.

    • This Month Total Orders

    barry_dock_dashboard_5

    This Month Total Orders we can see entire month total orders. Also displayed comparison of this month order with previous month order percentage wise.


1.2 Revenue Chart

barry_dock_dashboard_6

Revenue chart displayed revenue of different source ( platforms / channels )
X – axis = different source ( platforms / channels )
Y – axis = Revenue

Two option available

    • This Month

      ◦ By default chart view This Month wise

    • Last Month

      ◦ Click on Last Month ( In chart top right corner ) wise Revenue view

By comparison of this revenue chart get idea about revenue of each source (platforms / channels) .


1.3 Total Orders

barry_dock_dashboard_7

This total orders shows overall orders from seller from different Countries.

    • Total Orders view Country wise, here two type of view Table list, Country Map

Table List

    ◦ Table Columns:- Country Name, Total Orders, Total Orders(%), Total Revenue(pound), Total Revenue(%)

In each column we can see the growth of total orders, orders percent wise, revenue and revenue percent wise with month and year or overall.

    ▪ Country Name: Country Name view

    ▪ Total Orders: Country wise total orders view

    ▪ Total Orders(%): individual country’s total orders * 100 / All Countries total orders

    ▪ Total Revenue(in pound): Country wise total Revenue view

    ▪ Total Revenue(%): individual country’s total revenue * 100 / All Countries total revenue here three option available ( Table Header right side)

    ▪ All, This Month, Last Month

    ▪ By default This Month wise all countries total orders view

Country Map

    • Color difference shows the amount of total orders coming from particular country / place

    • Dark color represents more orders, Respectively lighter color shows less orders


1.4 Top 50 Selling SKU

barry_dock_dashboard_8

This Top 50 Selling SKU displayed Quantity, Turnover

    • here two type of view Table list, Chart

    Table List

    ◦ Columns:- Sku, Title, Quantity, Turnover

      ▪ Sku: SKU Name view

      ▪ Title: Product Name view

      ▪ Quantity: perticular Sku wise quantity view

      ▪ Turnover: perticular Sku wise revenue view here three option available ( Table Header right side)

      ▪ All, This Month, Last Month

      ▪ By default This Month wise top 50 selling sku view

    Chart

      • Particular Sku wise total quantity view

2. Reports

2.1 Category Sales by Week

barry_dock_dashboard_9

This report displayed Category Sales by week

    • Search option

    barry_dock_dashboard_10

    ◦ PrProcessed Date, Received Date

    ◦ Date Ranges

      ▪ Today, Yesterday, Last 7 Days, Last 30 Days, This Month, Last Month, Custom Range

    ◦ Buyer: Particular buyer wise search

    ◦ Category / Brand: Particular Category / Brand wise search

    • Category List Table

    barry_dock_dashboard_11

    ◦ Export in Excel ( In table on top right side)

    ◦ Columns: Category / Brand, Buyer, Target Week, Week

      ▪ Category / Brand: Category Name view

      ▪ Buyer: Buyer name view

      ▪ Target Week: here view revenue, This revenue Target assign perticular Buyer ( Target assign option available in Manage Buyer (in Settings Menu)) wise

      ▪ Week: week wise revenue view,

        • you can see image as above

        • Example:

          ◦ Week44 : 01-11-2018 To 04-11-2018

          ◦ Week45: 05-11-2018 To 11-11-2018

2.2 Details Sales Report

barry_dock_dashboard_12

This report displayed Detailed Sales

• Multiple SKU wise sales reports in a chart and also with total revenue particular SKU wise view (you can see image as above)

• Search option

    barry_dock_dashboard_13

    ◦ Processed Date, Received Date wise search

    ◦ Y-Axis: in chart left side view 0k, 1k, 2k, 3k

      ▪ Example: 1k- 1 thousand, 2k- 2 thousand

    ◦ X-Axis: Date rang wise search, in chart bottom view 01 Nov, 02 Nov, 03 Nov

    ◦ Source: Selected source wise search

    ◦ SKU: Multiple SKU wise search

• SKU wise Total Revenue

    ◦ Here, Particular SKU wise revenue view ( selected search wise ), you can see image given below

    barry_dock_dashboard_14

2.4 Sales Overview by Platform

barry_dock_dashboard_15

This report displayed Sales Overview by Platform

    • Sales overview particular Category / Brand wise ( selected date rang )

    • Search Option

      ◦ Processed Date, Received Date wise search

      ◦ Date Ranges: Select date range

        ▪ Click on calendar icon, after click you can see select date range option available,

        ▪ Date Range option : Today, Yesterday, Last 7 Days, Last 30 Days, This Month, Last Month, Custom Range

    • Sales overview list

      ◦ Here, Two list table view (you can see image given above)

        ▪ Platform Last Month V Previous Month Sales differences

        barry_dock_dashboard_16

        • Here, Three rows view,

          ◦ Last Month with date range

          ◦ Previous Month with date range

          ◦ Difference ( Last Month and Previous Month )

        • Export option ( This option view in Table top right corner, you can see image given above)

          ◦ This report also export in Excel

        ▪ YOY This Year V Previous Year Sales differences

        barry_dock_dashboard_17

        Three rows view,

          ◦ This Year with selected date range view

          ◦ Previous Year with selected date range view

          ◦ Difference: Compare with This Year and Previous Year

      • Export option ( This option view in Table top right corner, you can see image given above )

        ◦ This report also export in Excel

2.5 Sales Manager Report

barry_dock_dashboard_18

    This report displayed Sales Manager Report

    Particular Buyer Assigned Target week wise Sales report view ( Assign target option given in Manage Buyer( in settings menu) )

    • Search Option

      barry_dock_dashboard_19

      ◦ Processed Date, Received Date wise search

      ◦ Date Ranges: Date range wise search

        ▪ Click on calendar icon, view options for select date range

          • options: Today, Yesterday, Last 7 Days, Last 30 Days, This Month, Last Month, Custom Range

        ◦ Buyer: Buyer wise search

    • Search Option

    barry_dock_dashboard_20

      ▪ Export option ( This option view in Table top right corner, you can see image given above )

        • This report export in Excel

      ▪ Particular Buyer wise weekly revenue view

2.6 Sales Report

barry_dock_dashboard_21

    This report displayed Sales Report

    • Particular SKU wise or SKU’s Source wise Sales report view

    • Search Option

      barry_dock_dashboard_22

      ◦ Processed Date, Received Date wise search

      ◦ Date Ranges: Date range wise search

        ▪ Click on calendar icon, view options for select date range

          • options: Today, Yesterday, Last 7 Days, Last 30 Days, This Month, Last Month, Custom Range

      ◦ Category / Brand: Category wise search

      ◦ Search By: SKU, Title wise search

• Sales Report List

barry_dock_dashboard_23

    option ( This option view in Table top right corner, you can see image given above )

      ▪ This report export in Excel

    ◦ Particular SKU wise all Source revenue view

      ▪ Source view in columns, Source columns start on 3 number column

2.7 Sales Difference Reports

barry_dock_dashboard_24

    This report displayed Sales Difference Reports

    • Particular SKU wise all sources revenue view

    • Search Option

      barry_dock_dashboard_25

      ◦ Processed Date, Received Date wise search

      ◦ Date Ranges: Date range wise search

        ▪ Click on calendar icon, view options for select date range

          • options: Today, Yesterday, Last 7 Days, Last 30 Days, This Month, Last Month, Custom Range

      ◦ Compare Date Ranges: Date range wise search, This date range compare with ahead selected date range

        ▪ Click on calendar icon, view options for select date range

          • options: Today, Yesterday, Last 7 Days, Last 30 Days, This Month, Last Month, Custom Range

      ◦ Category / Brand: Category wise search

      ◦ Search By: SKU, Title wise search

    • Sales Difference Report list

    barry_dock_dashboard_26

      ◦ Export option ( This option view in Table top right corner, you can see image given above )

        ▪ This report export in Excel

      ◦ Perticular SKU wise all Source revenue view

        ▪ Source view in columns, Source columns start on 3 number column

2.8 Order Reports

barry_dock_dashboard_27

    This report displayed Order Reports

    • All Orders view selected date range wise

    • Search Option

      barry_dock_dashboard_28

      ◦ Processed Date, Received Date wise search

      ◦ Date Ranges: Date range wise search

        ▪ Click on calendar icon, view options for select date range

          • options: Today, Yesterday, Last 7 Days, Last 30 Days, This Month, Last Month, Custom Range

      ◦ Source: Source wise search

      ◦ Payment Status: Payment wise search, Paid, Unpaid, Resend

      ◦ Status: Order status wise search, Here two option given,

        ▪ Open – Order In process

        ▪ Close – Order delivered ( Customer Receive order)

    • Order Report List

    barry_dock_dashboard_29

    ◦ Export option ( This option view in Table top right corner, you can see image given above )

      ▪ Click on this button two option given

        • Summary Report – Only orders report export

        • Details Report - Orders with items report export

    ◦ In Table list

      ▪ Header: 1st column Image given, Click on this view Columns list with check box, here selected name are show in table, and unselected name not show in table if you select than view this column name in table

      ▪ In table order report record view rows,

        • Plus Icon: Click on plus icon than view all Items in a table

2.9 Downloads

barry_dock_dashboard_30

    • View Excel file list

    • Order Reports: when export excel file than make excel file in process background, This export excel file view here with download option ( Download icon given in Action column )

3. Settings

3.1 Application Settings

barry_dock_dashboard_31

In Application Settings we have following options:

    • Week: Two option given above image ( System will consider report selected week wise )

      ◦ Sunday to Saturday

      ◦ Monday to Sunday

    • Source Total Amount View: Two option given above image

      ◦ Header

      ◦ Footer

    if Header option select, system will consider total revenue view in all list page, You can see in all Reports module.

barry_dock_dashboard_32

If Footer option select, system will consider total revenue view in all list page ( total revenue view in table’s footer ), You can see in all Reports module. Also you can see below image

barry_dock_dashboard_33

    • Do you want to skip Postfix value from SKU ?

    Here, Two option given

      ◦ No -- if this option select, no any changes in whole project

      ◦ Yes – if this option select,

        ▪ Where SKU name view there effect.

        For Example: Sku name abc_123456 to 123456 changed in whole project

    • Do you want to Remove "0" from Prefix value of SKU ?

    Here, Two option given

      ◦ No – if this option select, no any changes in whole project

      ◦ Yes – if this option select,

        ▪ Where SKU name view there effect.

        For Example: SKU nae 0123456789 to 123456789 change

    • Manual Currency Rate

    barry_dock_dashboard_34

    Here,

    • Manual set currency rate (this changes effect in where revenue view)

3.2 Source / Subsource

barry_dock_dashboard_35

Here,

    • Selected Source view in whole project (In Reports: all report modules, Desktop: revenue chart)

3.3 Manage Buyer

barry_dock_dashboard_36

Here,

    • Buyer assign target list page view

    • Assign target to Buyer : Add Buyer button see given above image

      ◦ Add Buyer Form:

    barry_dock_dashboard_37

      ▪ Category / Brand: Category / Brand list in Dropdown, click on dropdown

    • Assigned target effect in given below modules list

      ◦ Category Sales by Week

      ◦ Sales Manager Report

3.4 Manual Sync

barry_dock_dashboard_38

Here,

    • Data fetch from Linnworks

    • First time application create in Linnworks

      ◦ Do one time sync all data here(one time only 1 month sync)

    here, you can sync multiple month date range wise

Get your free quote

Call 0208 090 4547

Hear From Our Clients

Best website/e-commerce vendor I've worked with in my 10 years of being an IT PM! We hired eBusiness Guru to create our e-commerce website for our premium brand. This was no easy task as it was not your traditional e-commerce site. They delivered on-time, on-budget, and all with a successful release to the public and established partnership with us. We enjoyed working with the whole team. I would highly recommend them for any website need.
Bastien Peyronnel

Certifications