Introduction
This article shows you how to use the Global Settings tools on the View Data page in Advanced mode. In Advanced mode, you get a comprehensive set of tools to analyse and organise search results.
These View Data instructions can be used to learn about the Global Settings tools for the following search portals:
Basic mode
In View Data Basic mode, you get essential tools and a simple table layout. To learn about the View Data tools in Basic mode, see:
More information
The View Data page in Advanced mode is a giant table filled with a panoply of data, buttons, and images. At first glance, it can be a bit intimidating.
To simplify the explanations, we divided the instructions into smaller articles. To understand key functionality on the View Data page, you should also read:
Opening the View Data page
There are several ways to open the View Data page.
On the main dashboard, click View Data on the black menu on the left side of the screen. A drop-down menu displays. Select View. The View Data page for Product Search displays.
On the main dashboard page, click the View button on a search portal. The range of portals on your dashboard depends on your subscription service.
Inside the search portal, click the blue View Data button.
Choosing the Advanced mode
Scroll up to the top of the screen.
Toggle the switch towards Advanced.
1. Selecting a search
You can either look at all the data discovered to date, or if you have run more than one search, select a search you've run for a more granular approach.
Scroll up to the top of the page.
Click the field beside You are watching. A drop-down menu displays.
Select a search on the menu. The search results display on the page for you to select from.
1.1 Viewing process details
After selecting a saved search, a green INFO button and blue pencil display on the menu bar.
Click the green INFO button. A Process info panel displays.
Click the X to close the panel.
The panel has information about the search, including the URL, search date, and number of products added.
1.2 Changing the search name
You can change the name of the saved search.
Click the blue pencil. A new field displays.
Edit the search name.
Click the check mark to save the name change.
Click the X to cancel the change.
2. Reverse Search Button
After selecting a saved search, a blue REVERSE SEARCH button displays on the menu bar. (This tool is not available on the Reverse portal.)
This option is here if you would like to Reverse Search the results shown. Selecting this will cause a new Reverse Product Search tab to open on the browser, pre-loaded with all the ASINS from the results in the View Data process you are looking at.
For more information about Reverse searches, see:
3. Adding notes
After selecting a saved search, a Notes button displays on the menu bar. This handy tool lets you jot down notes as you work through the data analysis.
Click the Notes button. A new panel displays.
Write a note and then click SAVE.
The pencil will go green indicating a note is saved here for viewing.
4. Displaying hidden information
The horizontal bar at the top of the page contains three unrelated but interesting tools. Each tool hides or reveals information in the View Data table.
The tools in horizontal bar are:
Competitive Range from the Buy Box
Show barcodes
Show 3D Box Shapes
Each tool is described below.
4.1 Competitive Range from the Buy Box
Is there a lot of competition for a product? This tool answers that question.
This tool tells you the number of sellers offering a product price close to the Amazon Buy Box price. It's a global tool, so any change you make here customises the figures in the table for all products.
By seller, we mean the number of FBA or MF sellers.
By close, we mean a price inside a percentage range of the Buy Box price.
Click the field next to Competitive Range from the Buy Box. A drop-down menu displays.
Select a percentage on the menu. The smaller the number, the smaller the gap between the sellers' prices and the Buy Box price.
4.1.1 Locating the number of sellers
After selecting a figure on the Competitive Range from the Buy Box tool, you have to find the results.
There are two places.
The first, is easy - simply look for the column - Competitive FBA Sellers. This will display the number of FBA sellers within that % range of the Buy Box. This data runs on a short cached period but is more often than not, correct.
The second, requires you to open a new panel for additional live information.
Go to the table and select a product you want to investigate.
Locate the New Sellers column.
Click the green FBA / MF button. A new panel displays.
The new panel shows you three sets of information for that product:
number of FBA / MF sellers
percentage range selected (e.g. 2%)
number of sellers with a price within that percentage range compared to the Amazon Buy Box price
Here's an example.
The image below tells us there are 23 sellers (17 + 6) of this product.
The image also tells us 4 sellers (i.e. 1 FBA and 3 MF) have a price which is close to the Amazon Buy Box price. In this panel, close means within 2%.
Here's a panel for the same product with a 20% competition figure.
The total number of sellers is the same as above (that's to be expected).
There's more competition for prices within 20% of the Buy Box price. The box tells us there are 8 sellers with a price that's within 20% of the Amazon buy box price.
4.2 Show barcodes
This switch controls the display of barcode images in two columns: Amazon UPC/EAN and UPC/EAN.
Toggle ON the switch (blue) to display barcode images for the products in the table.
Toggle OFF the switch (orange) to hide the barcodes.
4.3 Show 3D Box Shapes
Toggle ON this switch to show 3D box shapes in the Product Size column for a visual representation on the product shape.
5. Managing columns
The MANAGE COLUMNS button lets you customise the way columns display on the table. You can:
hide columns
change the order of columns on the table
save preferences as a new style
set a new default which can be used on other View Data pages
5.1 Opening the manage columns panel
Scroll up to the top of the page.
Click the blue MANAGE COLUMNS button. The Manage Columns panel displays.
5.2 Hiding columns
Toggle OFF (orange) a column header switch.
Click APPLY.
To display a column on the View Data table, toggle ON (blue) a column header switch.
Click APPLY.
5.2.1 Another option
You can hide columns while working on the View Data table.
Scroll up to the top of the page.
Locate the toolbar with blue magnifying glasses.
Locate the column you want to hide.
Click the grey button with an eye. The column is hidden.
To unhide all columns, scroll to the left side of the toolbar and click the eye button next to the green button. All hidden columns are now visible.
Note: To reveal the toolbar with blue magnifying glasses, make sure you see the words HIDE FILTERS next to the FILTER MANAGER button. If you see the text SHOW FILTERS, the toolbar is hidden. Click SHOW FILTERS to reveal the toolbar.
5.3 Changing the column order
You can change the order of columns on the table inside the Manage Columns panel.
Click a column title. The mouse pointer changes into 4 arrows.
Drag the column title to a new location and then release the mouse.
5.3.1 Dragging columns
You can change the order of columns while working on the the View Data itself with the drag and drop tool.
Go the View Data table.
Click and drag a column title.
Drop the column in a new location.
Release the mouse.
5.4 Saving column display choices
Inside the Manage Columns panel, you can save a column layout as a new style and use it when looking at other View Data pages.
Click the field beside Add New Style and then type a file name.
Click the (+) button.
Click SET ORDER TO DEFAULT.
Click SAVE.
6. Updating global table data
Use this tool to update information on your table. This button updates data for all of the products on the table.
Using the Row Toolbar, you may also get current information for individual rows of data. That button is discussed here.
Scroll up to the top of the View Data page.
Click the orange UPDATE DATA button. A drop-down menu displays.
The drop-down menu has four options:
update source prices
update adjusted prices
update Amazon data
update all data
Each option is described below.
6.1 Updating source prices
Get current source prices for every product in the table.
Note: This menu item is not available on the Wholesale View data page.
Tactical Arbitrage visits the source of each product and checks the price. If a different price is found, it is presented in the table.
6.2 Updating adjusted prices
Get the current adjusted price information for every product in the table. The adjusted price is your net buy cost after discounts as well as cashback and giftcard rebates. The adjusted price is used to calculate the gross ROI for each product.
This tool is very handy if you come across a new special discount or offer. For example, you learn that a company is offering a 10% cashback rate for a limited time.
Click UPDATE ADJUSTED PRICES. A new panel displays.
Add new information to one, some, or all of the fields in the Update Adjusted Prices panel.
Click UPDATE or UPDATE ALL ENTRIES.
After updating the information, inspect the Adjusted Price column on the table. You'll also see changes to the gross profit and gross ROI.
6.3 Updating Amazon data
Update table information from Amazon. This includes:
Amazon Buy Box Price
Amazon Return After Fees
Sales Rank
Average Price for 30 and 90 days
6.4 Updating all data
Update all pricing information. This includes store prices and Amazon Buy Box prices.
This tool does not update adjusted prices. That information is handled in a separate update tool (see above).
7. Using the search tool
The search tool is next to the UPDATE DATA button. Use this tool when you want to narrow the search results based on a keyword in the title. You can also use it to search a UPC, EAN, or ASIN.
Enter a keyword (or product code) in the search field.
Click the magnifying glass or hit ENTER on the keyboard. Products with that key word (or product code) display in the table.
To remove the search filter and display all results, delete the keyword from the search field and then click the magnifying glass (or hit ENTER on the keyboard).
8. Using the download all tool
Use this tool to download your search results. The DOWNLOAD ALL tool is near the top of the page. It's in a box with two other buttons.
8.1 Selecting a download destination
Click the green DOWNLOAD ALL button. A small drop-down menu displays.
Select the destination for your file: your computer or your Google drive.
If you select Google, you're prompted to login to your Google account.
8.2 Selecting a file format
After selecting a file destination, the Download All panel displays. Choose the type of file to download. There are several options:
download the entire file as a csv or xlsx
download all visible table data (excludes hidden columns and rows) as a csv or xlsx
Hiding columns and rows
Before exporting a file, you might want to customise the table by hiding some columns and rows.
Section 5.2 above shows you how to hide table columns.
9. Using the delete all tool
The DELETE ALL tool looks simple, but it's not. It's a little more sophisticated than wiping an entire table of data.
9.1 Deleting the table
On a basic level, the DELETE ALL button wipes the whole table.
Click the DELETE ALL button. A confirmation panel displays.
Click DELETE ALL.
Note: After deleting a table, the data is gone; there is no UNDO button.
9.2 Deleting selected columns or rows in a table
There are other delete options. These options appear if you have hidden columns or rows.
Click the DELETE ALL button. A confirmation panel displays. You can delete:
the entire table (DELETE ALL)
the columns and rows that are not visible (DELETE HIDDEN)
the visible columns and rows and keep the hidden content (DELETE VISIBLE)
10. Using the move all tool
The MOVE ALL is very handy when you want to save a large View Data table. The Move All tool takes all of the information in a View Data table and saves it in a folder.
Scroll up to the top of the View Data page.
Click the MOVE ALL button. A confirmation panel displays.
With the Move/Copy All panel open, you have several options, as described below.
10.1 Destination
The first option is selecting a save destination.
To move the data to an existing folder, click the field next to Select Your Folder. A drop-menu displays.
Select an option. If you have not created any folders, the default is Main Folder.
To create a new folder, click the field next to Create.
Enter a folder name.
10.2 Move or copy
The next step is to decide how to save the data.
Select MOVE ALL to remove the table from the View Data page and place it in the selected folder. After a MOVE ALL, the View Data page is empty.
Select COPY ALL to place a duplicate of the table in the selected folder. After finishing a COPY ALL step, the table on the View Data page is unchanged.
11. Using the page display tool
The page display tool helps you navigate the table. This is a handy tool when there are hundreds or even thousands of search results.
Scroll up to the top of the View Data page. The toolbar shows several pieces of information.
11.1 Current page
The page currently on display in the table is highlighted in the toolbar. The current page is blue. Click a different number to change the table page.
11.2 Change page
There are two ways to change the table page. You can click a number in the toolbar. Or you can click the field next to Go and type a page number. Click Go and the table data changes.
11.3 Show results
You can change the number of items on display in the table. Click the field next to Show and select a number on the menu. The maximum number is 100.
11.4 Number of entries
On the right side of the toolbar, you can see the number of entries currently on display in the table. You also see the total number of entries for this search.
In the image below, the toolbar shows the total number of entries for this search is 280.
12. Looking at exchange rates
Scroll to the top of the View Data page and you'll see the words Exchange Rates.
Click the nearby question mark and a panel displays. It shows current exchange rates used when calculating prices and margins for cross-country transactions (e.g. buy in the UK and sell in the US).
The panel on the View Data page is for information purposes. This data cannot be changed. In addition, it us only useful when you are doing cross-country transactions.