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.

 

 

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 Inventory

Loading Inventory

Product ID - Input product ID, or more separated with ","LoadInventory

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

Stock Location Name - Search by Stock location name

Warehouse ID - Search by warehouse location ID

Created Date - Search the Product created 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