ChangeLog July 13, 2020

ChangeLog July 13, 2020

New Feature:

    • Import Tab Separated Values files - you can now import "Tab Separated Values" files, they come with file extensions [.txt and .tsv] That is common export file and you can export it from Excel. This new feature will enable using reports from Skubana in the StoreReport. Now you can import even .tsv files that where exported in StoreReport.
  1. In Excel go to the "Save As" and select "Text (tab delimited)"
    save as tab file in excel
  2. In StoreReport go to Menu->TSV Import->Import File
    "Import Aggregate File" will merge loaded data with new imported data.
    import tab separated file in the store report
  3. Map header fields from imported file to StoreReport fields. On the left side you will see your imported file fields, on the right side you will see StoreReport fields. You don`t have to map all the data to the StoreReport if you don`t need it.
    For that on the left side you can select with [SHIFT, CTRL] click and remove fields you don`t want to map.
    select data
  4. On the right side are StoreReport fields. Drag items to reorder mapping. Mapping will be done only for fields from left side.
    drag item in data grid
  5. Finished mapping for Inventory would look like this:
    storereport data grid
  6. Click Import and use the StoreReport features, like grouping, filtering, "vendor cost" mapping or "current cost" mapping. With this you can export stock locations inventory from Skubana without the need to download everything in StoreReport.



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

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