Posted on

ChangeLog March 7, 2018

ChangeLog March 7, 2018

New features:

Recently I’ve done some more work on StoreReport. Introduction of the new field called “orderType” changed the logic in the API. “orderType” now holds information about “FBA, STANDARD…” and that information was previously inside the order ID. So once the new field was introduced StoreReport didn’t parse FBA as FBA channel. That API change was done on 26th January.

  1. The issue with “orderType” is fixed, that field is added to the datagrid and online model. It is still adding the FBA part to the channel name. So “AMAZON” and “AMAZON FBA” will be as sales channel name.
  2. Added parsing labels into separate fields so it can be grouped by, if there is a label it will be parsed in the [label1,label2,label3,label4] groping than can be done on labels.
  3. Added new view “Listings”
  4. Added new fields to the orders:
  • “orderItemTotal” – it is same as StoreReport Sales Revenue [QTY*UnitPrice]  but now comes from Skubana
  • “orderType” - ['STANDARD', 'PRIME', 'POS', 'FBA_WORKFLOW', 'FBA', 'STOCK_TRANSFER']
  • “lisitngSku” – listingSku of Order product
  • “listingName” – listing name of Order product
  1. Added new filter for date range. Select the date field, whatever date field [createdDate, orderDate…], and select range.

Bug fixes:

  1. Fixed bug for saving personal data grid layouts
Posted on

ChangeLog February 27, 2018

Posted on

ChangeLog May 18, 2017

ChangeLog May 18, 2017

Date:

  • Fixed bug (Date UTC formatting) Problem was with formatting date using UTC time zone offset, and that will show as wrong format of FROM DATE, showing results like they are from day before requested day.
  • Added (Time formatting) Changed to display 00H-24H, making it easier for sorting. *Remember that StoreReport can sort multiple fields by clicking on little arrows in header. Click on header name will make it first to sort and it will display number 1 next to the arrow. Click any other small arrow will make it 2nd filed to sort and it will display number 2 next to the arrow.

For example: in data grid header click on “Date”. On “Time” header click the little arrow, not the “Time”. It will show a little number “2” next to arrow. That means that field is used for second sorting and so on.

New features:

  • Added (Summaries and Subgroup font color) For easier usage those fields are now colored. Summaries are RED while Sub-Group fields are BLUE.
  • Added (Skubana Logout) In Account window there is a button “Skubana Logout”. When you click on that button, Skubana logout page will pop up in new tab, you can close that page. StoreReport tab will go to Skubana Login page, where you login using credentials from other company.
  • Added (StoreReport allowed companies) You can manage now only companies that added to your list. If you have any issues please contact support.

 

Posted on

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

Posted on

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

Posted on

Menu

Menu

Save File - Save StoreReport file format

Load File - Load saved StoreReport file

Load aggregated data - Add new StoreReport data to already loaded data

Export data - Export data in CSV format for EXCEL or other software

Data Grid Layout - Save and Load your Data Grid layouts.

Read More

Posted on

Data Grid Current Cost

Data Grid Current Cost

Get current cost for product. Crucial for COGS report, and crucial to populated with number value. This works in Orders, Products and Inventory view.

Skubana "currentCost"  field is value that is stored in Vendor Product or FIFO from your Purchase Orders. First it checks if there is a PO for the product to get the latest FIFO price, if there is no PO it checks for Vendor Cost in your Skubana store. 

This field is crucial for calculating COGS, and COGS report will not be available until you have all the Current Cost populated. 

Read More

Posted on

Error View

Error View

This component is searching for errors in Skubana data. The type of errors are some common ones we found in our usage scenario. Error View can help you clean your data and make better reports. Works only in Orders View.

Remove- Remove selected Items. It can remove items from data set, like removing wrong orders, test orders or anything that is making wrong calculations.

Change - Change any field on selected Item / Items [Multiple selection with SHIFT or CTRL + CLICK]. Mostly used to change currentCost field from zero, so we get accurate COGS report.

Today Cost - Used when Current cost is null. Meaning there was no Cost found on the day of the order. This will try to fetch the today data, so it gets the cost if it is added later, after order is placed.

*Merge with Parent - Used for fixing the Split Order issue. It will merge the selected item with its parent, that will fix the COGS report for that order. Still in test phase.

Read More