Export Data

Export Data

What you see is what you get exported. It is exporting the current Data Grid view. If you want flat data, switch to Flat View before exporting. In Tree View be sure to expand the nodes you want to see exported. The export data will be the same you are viewing, so be sure you are seeing all you want to see in export. Export data is in "Tab separated format" .tsv meaning it uses "TAB" to separate values during export. In Excel create new table, and just drag drop your .tsv file.

Read More

StoreReport Guide

StoreReport logo transparent

Chart

Chart

Chart component will display in Chart view whatever is in Orders view.

It works only in Orders Tree View with grouped values. It charts the in Column chart two Columns per item.
It is showing [Sales Revenue, Cogs] as one column and [Tax, Shipping Revenue, Discounts and Sales Revenue + COGS]

chart view

 

 

Slider on left - Save StoreReport file format

Bottom scroll - Scrolls the displayed data.

Read More

Data Grid Summaries

Data Grid Summaries

This component is used for adding more summaries fields.

StoreReport uses "#" in front of field name to distinguish summary field. It can be any number field from Skubana data. It can also be any custom field that you have added. When you add new summary field it will be added to the end of the Data Grid Fields list. From there you can drag to the front and place between other summary fields, and hit Refresh Data Grid button.

 Be sure to add only line item fields.

Loading Purchase Orders

Load Purchase Orders

Purchase Order Number - Input PO numberLoadPO

Status - Use Dropdown selector to choose status

Created Date - Search Skubana PO creation date From - To

Modified Date - Search the modification of PO date From - To

Read More

Loading Products

Load Products

Product SKU  - Input product SKU, or more separated with ","

Product UPC - Input product UPC, or more separated with ","

Stock Location  - Search by Stock location ID

Warehouse ID - Search by warehouse location ID

Created Date - Search the Product created date From - To

Modified Date - Search the Product modified date From - To

Read More

Loading Orders

Load Orders

Loading Orders component for working with Skubana Orders API.

Order Number - Input order number, or more order numbers separated with ","

StoreReport Load Orders User Interface
Order Date - Search From - To date.

Created Date - Search Skubana Order creation date From - To

Modified Date - Search the modification of Order date From - To

Shipped Date - Search the Order shipped date From - To

Payment Date - Search the Order payment date From - To

Read More