Web Store Orders Workbook
The SuiteAnalytics Web Store Orders workbook template lets you retrieve and visualize web store order information based on your criteria. You can group orders by item and the customers who ordered them, or you can group by customer and the items they ordered.
Accessing the web store order workbook template
-
In NetSuite, on the top navigation menu, click Analytics.
-
On the Analytics Home page, expand the list under Workbook Templates and click Web Store Orders.
This displays the Web Store Orders workbook template.
Note:At this stage, you may see a note displayed: Transactions in SuiteAnalytics Workbook. It provides information about how to use the Transaction record type in SuiteAnalytics Workbook. If you don't want to see this message again, check the Don’t show me again box and then click Let’s start.
-
The workbook user interface includes multiple tabs:
-
The Dataset tab, where you customize your source data and criteria
-
The Pivot tab, where you pivot your workbook source data
-
The Chart tab, where you create charts from your workbook source data
For more information about each tab, see Navigating SuiteAnalytics Workbook.
-
Charts
The following charts are included in this workbook:
-
Total Ordered Items per Website. This chart displays the total number of items sold through the web store.
-
Total Item Value per Website. This chart shows the sum of the totals from all orders made from a web store. Transactions are converted to your default subsidiary's base currency, since they can be in different currencies.
New Fields
The Web Store Order Workbook Template uses a new Website field that is not available in the NetSuite Report application.
Field Name |
Record Location in SuiteAnalytics Workbook |
Join Path in SuiteAnalytics Workbook |
---|---|---|
Website |
Transation Website |
Transation > Website |
Pivot Tables
The following pivot tables are included in this workbook:
-
Web Store Orders. This is a summary of web store transactions by item name. The Aggregate column lists the number of ordered items, the number of orders, and the number of unique customers. To segment data by year, quarter, or month, add the Date field to the table Columns, in the Layout panel. The default criteria for this workbook includes data from SuiteCommerce InStore sites.
-
Items Ordered by Customers. This pivot table displays the list of items purchased, the customers who bought them, and the web store the items were purchased through.
-
Customers Ordering Items. This pivot table displays the list of customers that purchased items, the items purchased, and the web store the customers purchased those items through.