Collections

Collections are a powerful and useful feature of Slatwall. Collections allow users to apply filters and customize the data columns which can then be used for reporting. This section details the creation and display of system-wide collections available to all users.

 

 

Add a New Collection

  • Click on Config from the Slatwall toolbar.

  • Select Collections from the drop-down.

The collections listing screen will appear with a listing of the existing collections.

  • Click on the +Add Collection button

The Create Collection screen will appear.

  • Collection Name - Fill the this field with the name of the collection. This field is required.
  • Collection Type - Select the collection type from the drop-down. This is the type of object the collection will be based on. Example: A Collection Type of Product will create a full collection of products in the database.
  • Description - Fill in this field with a description of the collection. This field is not required.
  • Collection Code - Fill in this field with a collection code. This field is not required.
  • Base Collection - This drop-down will include collections based on the Collection Type that was selected above. This field is not required. Use of this field allows for creating a collection based on another one. For example, if the new collection will include all orders shipping to NY within a specific time-frame, the base collection could be all orders shipping to New York.

  • Click Save.

The collection detail screen will display the Configuration accordion and all records for Orders will display in view mode. 

In view mode, two icons are available: Reporting and Export. These are explained in more depth at the end of this section.

In order to apply a filter to include only orders shipping to Massachusetts:

  • Click the Edit pencil icon in the upper right-hand corner of the detail screen to open in edit mode.

The collection detail screen will appear in edit mode.

There will be two additional icons: Filtering and Display Options in addition to the Reporting and Export icons,

 

Add a Filter to a Collection

To add a filter:

  • Click on the Filter icon as shown above.

+ Filter and + Filter Group buttons will appear.

  • Click on the + Filter  button.

The Define Filter popup will appear.

  • Click the Select From order drop-down menu and make a selection. In this case select Shipping Address.
  • Select a Criteria from the radio buttons, in this case Use Shipping Address Field

  • From the Select From Shipping Address drop-down select State

  • From the Condition drop-down select Equals
  • Add Massachusetts to the Value field.
  • Click Save and Finish to add one filter.

The records for all Massachusetts orders with Massachusetts shipping address will display.

 

View Display Options

The data fields that display as columns in collections can be customized. They can be added, moved, deleted, searched, viewed, and exported.

To edit Display Options:

  • Click the Display options icon as shown above.

The display options listing will appear.

  • Hovering over a line will make a compass icon appear that allows the user to left click and drag display options to reorder them. 
  • Click the Edit link to edit the  display options title.
  • Click the Eyeball icon to make the display option Visible (dark) or not visible (grey) in the table. 
  • Click the Search icon to make the display option searchable (black) or not searchable (grey) within the table. 
  • Click the Export icon to make the display option available for export (black) or not available for export (grey). 
  • Click the X to remove the display option from the collection.

 

Add Display Field

You may decide that you like to add fields to your collection.

To add a Display Field to the display options:

  • Click the Add Display Field button located at the bottom of the existing display options list.

The Define Display Option popup will appear.

  • Select an option from the drop-down and then click Save & Finish or Save & Add Another.

The Display option will appear at the bottom of the list. 

 

Export Feature

  • Click the Export icon as shown above.

A .csv file will be downloaded. 

Collection Reporting Feature

You may want to run reports such as total sales each month or another time frame.

In order to create a report:

  • Click the Reporting icon (as shown below) and a drop-down will appear with different reports available with the ability to add a new report.

If you would like to add a new report:

  • Click New Report

The Orders Report screen will display.

 

  • Select the Report Dimensions from the drop-down. 

In this example Date Placed is selected.
* Note, doing so will eventually automatically add Date Placed as a Display Option, so no need to manually add Date Placed as a Display Field.

Now add in the dates for the report.

  • Add the Start Date and End date
  • Use the Compare Dates feature to compare to date ranges if desired.

Use the Display Options to customize the data in the report and graph. When a new report is created, display fields need to be added. In the example below, only Order Number is displayed by default for an order collection.

  • Click the Display Options icon to the right of the screen
  • Click Add Display Field button that appears.

In this example add  Order Items Item Total Count  display option.

  • Click on a selection for View By by selecting on of the following: Hour, Day, Week Month or Year.  This can be changed to view the graph by hour, day, week, month or year.

Now that this is defined (and can be changed) the Date Placed Display Option will appear and the Graph will also appear.

  • Click Save to save the report and have it saved to the Reporting drop-down for future use.

 

Save a Personal Collection

Personal collections allow individual users to create their own personal collections for reporting since users typically have unique needs. This feature can be found on listing pages such as Products, Carts and Quotes, Orders, Accounts, Stock Receivers, etc. 

To create a personal collection, navigate to the desired listing page. In the following example an Order personal collection will be created. 

  • Select Orders from the main navigation and then select Orders from the drop-down.

The Orders listing page will appear with several icons to the right of the search bar: Reporting, Save Report, All Saved Reports, Filtering, Display Options, and Export.

To create a personal collection:

  • Click on the Filtering icon

The Define Filter pop-up will appear.

  • From the Select from Order drop-down make a selection, in this case Date Placed was selected.
  • On the Select a Condition drop-down select a condition, in this case In Range was selected and a Start Date and End Date must be set.
  • After setting the dates, click the Add Filter button.

  • Click the Save Report icon
  • Fill in the name field and then click Save.

Now click the All Saved Reports icon to view the personal collection that was just created. Users can switch between the Default view and any added collections.