With custom reports, you can change the dimensions, columns and filters that you'd like to use. This view will open up when you are editing a report, and select Manage on either Dimensions or Columns.

You can also see this when you choose Edit Columns in the report (remembering this is only valid for this view, but on refresh the next visit of this report). There are 2 views, a basic and an advanced.

Basic View

This will show you a list of simple attributes/columns you can add related to the order.

Advanced View

This will list all available tables from the database to make your report. Use this if you can't find the attribute on the Basic View.

You can swap between views by selecting the button next to the search bar.


Adding additional columns

  1. Go to your Edit Report section (3 bars from the top right of your custom report)

  2. Go to either Dimension or Columns (depending what you want add) and choose Manage.

  3. On the pop up, scan through the available fields from the left and simply click on it so it will add it to your existing columns to the right.

  4. You can also move these around to rearrange the order in the report.

  5. If you cannot find the column that you are after - simply press toggle into Advanced View to see all of the columns on the marketplace.


Common Attributes to search for in Advanced View

There are a few attributes that you may want to use in Advanced View that you cannot find in Basic. We've listed a few commonly used attributes that you can add to your columns or dimensions.

Attribute Code

Description

sales_order_item|vendor_id

Shows the Vendor ID of the Vendor on that order

quote_item|vendor_id

Shows the Vendor ID of the Vendor on that quote

omnyfy_vendor_vendor_entity|name

Displays the name of the Vendor (use this to match the ID of the Vendor is using ID as Dimensions)

catalog_product_entity|sku

Display's the product's SKU - Use this for Dimensions to split order into different product rows.

catalog_product_entity|name

Display's the individual products - use this when SKU is the individual

catalog_product_entity|name_concat

Displays all the products for that order (use when Vendor ID is the dimension to show the products specific for this vendor).

Order Items > Base Row Total Incl Tax

Shows the subtotal for the individual item if using catalog_product_entity|name as a separator


Did this answer your question?