Product Variable Spec Report

The Variable Spec Report is built on top of the Product Report and is designed to provide detailed information for all specs created and assigned to products in your catalog.  The product information is also available for display.  Due to the multi-relational nature of variable specs, the base product information will be repeated for each spec returned in the report. 

You can use the conditions options to filter results and narrow the scope of the report.

The condition options are a combinatorial filtering mechanism which means that choosing multiple conditions applies to the entire result set. If you select all active and variable products, the report will only return those products which meet both criteria.

Conditions:

1. Company: The list of all buyer companies.
2. Type: Choice between static and variable products.
3. Active: True or false value of the active state.
4. Date Created: A hidden property, not editable by a user, which records the actual date the product was created on the site.
5. Product Name: The Name property. This condition searches for the existence of the criteria in the entire property. For example: Name = "Business Card", Condition = "ess" will return the Business Card product.
6. Product ID: The Product ID property. Behaves identically to the Product Name condition.
7. UNSPSC: The UNSPSC property. Behaves identically to the Product Name condition.
8. Interop ID: The Interop ID property. Behaves identically to the Product Name condition.
9. Products: A list of all products, dynamically loaded, that are currently assigned to the selected Company condition. If "All" is selected for a company, all products are returned to the list.  (Please note that the number of products will affect the load time of this option; consider paring down the result set by selecting an individual company.)

"Display Columns" is a list of all columns that comprise the Product Report. The list is provided to allow for the narrowing of a report to show the desired columns of information. The list is multiple-selection enabled (hold the Ctrl key down as you select with your mouse).The Conditions criteria will still apply if the column is not selected for display.

The Preview button returns the result of the report to a tabled grid in the lower portion of the page. It is intended for a quick inspection of report accuracy.

The Download button returns the result of the report in a comma delimited format which is fully supported in Microsoft Excel as well as all other major spreadsheet applications. You will be prompted by your browser to save or open the file. The file is always named by the default value of "Report.csv." Once saved to your local computer, your spreadsheet program should open the file normally with each column separated as intended. If the file does not delimit by the comma, consult your software's documentation regarding the use of comma delimited files.

The Save button stores the entire Conditions and Display Columns selection, along with the provided Report Name, to your Saved Reports list.

The Cancel button reverses all of your selected properties and returns you to the Saved Reports list.

Reference Material: None

Related Articles:
Product Report
Product Price Breaks Report
Product Price Schedule Report
Pricing Static Spec Report

Labels: admin, admin reports, product report, product, products