Top Items

 

WebAlliance generates a report of the most-purchased items through your website. This report is useful as snapshot of current trends. For the most complete data, you should use your ERP system reporting.

You must be a SuperAdmin or an Admin with the Stats Area role to access this feature.

Select Top Items from Admin > Stats > Top Items

Viewing the Top Items Report

Select the date range for your report and click "Update List". By default the previous 6 months will be selected.

You can sort the results by any available column.

View Item Purchase Details

Clicking the arrow next to an item will present details about each transaction involving that item. Further, clicking the arrow next to each transaction will present the full scope of that individual transaction, so you can see what a customer is purchasing along with the originally selected item.

P21 - Pulling Sales data for Items Sold on the Website

Here is a SQL query that you can run to find information similar to that which you'd find on this Top Items report. Running the query directly against your P21 database will ensure that the data included is up-to-date and complete:


--adjust the dates as needed
--we don’t recommend pulling more that 1000 items at a time or you may cause your sql server performance to be slowed
SELECT TOP 1000 hdr.[order_no]
 ,[customer_id]
 ,[order_date]
 ,[ship2_name]
 ,[po_no]
 ,[completed]
 ,[company_id]
 ,[location_id]
 ,[contact_id]
 ,[corp_address_id]
 ,[taker]
 ,[web_reference_no]
 ,line.item_id
 ,qty_ordered
 ,unit_price
 ,extended_price
 ,unit_of_measure
 ,source_loc_id
 ,ship_loc_id
 ,inv.item_desc
 ,inv.extended_desc
 
 FROM [p21_view_oe_hdr] hdr
 left join 
[p21_view_oe_line] line
 on hdr.order_no=line.order_no
 left join
 [inv_mast] inv
 on inv.item_id=line.item_id
 where hdr.delete_flag='N' and line.delete_flag='n'
 and web_reference_no is not null
 and order_date between '10/1/2016' and '10/31/2016'
 order by order_date desc