ChangeLog February 4, 2020

ChangeLog February 4, 2020

New Features:

    • Line Item Total Discount - new field added in Orders.

      From Skubana: Skubana now displays discount information on a SKU-by-SKU or line item basis. When pulling order details, original unit value and discounts will appear in separate fields. Previously, discounts were shown on a complete order basis. This update allows users to apply item-specific discounts for more accurate COGs and revenue calculations.

      StoreReport added field called "itemDiscount" to present this data. This changed the "Sales Revenue" which was calculated [QTY*Unit Price] now if there is Item Discount it will be subtracted from line Sales Revenue [ QTY * Unit Price) - Item Discount]

    • "Discount" field changed name to the "Order Discount" so there is an obvious difference between "Item Discount" and "Order Discount".
      They are not the same thing. If you have any Item Discount it will not show as "Order Discount".

ChangeLog July 4, 2019

ChangeLog July 4, 2019

New Features:

  • Vendor Cost there is a new button. You can now merge "Vendor Cost" - Default product cost to Orders, Inventory, Listings data.
  • In Orders Selector new options to search data. Search by "Sales Channel" and "Warehouse" added.
  • In PO Selector new options to search data. Search by "Product Sku" and "Vendor Product Sku" added.
  • In Listings Selector new options to search data. Search by "Sales Channel" added.
  • Custom Calculated Field modified. Fixed the logic so you can select one of the field from data grid and do the math instead of two. Now you can select field like "Shipping Cost" as x and do the math x+5, that would add 5 to "Shipping Cost" field.
  • Custom Calculated Field Single Value is added in case you want to map single value to all items in orders. For example you can add Single Value called "ordersAmount" and set it as value 1. With changing the data grid like [masterSku, ##orderID, #ordersAmount] you can use that value to get the Warehouse Hit list. It is how many times somebody went to warehouse to get the sold item, not the quantity sold.

Bug Fixes:

  • Cancel Loading data button. Loader is now changed and Cancel button is working. The issue before was a Cancel event that was only active during loading the data. To make things worse there was a Clock animation running which made the impression that you cannot click on the cancel during the time when Cancel event was active.

ChangeLog July 1, 2019

ChangeLog July 1, 2019

Skubana "Current Cost" Update:

  1. Skubana analytics API "Current Cost" changed without notice. Previous API call was showing "Current Cost" [Vendor , Default or PO] based on Date. Now the Current cost is based on the Product Warehouse location. To get the current cost we need to pass the Warehouse ID.
  • In Orders the warehouse ID is the "Fulfillment Warehouse ID" and we can get the Current cost for any order.
  • In Products you need to search by warehouse and then click the button "Get the Warehouse Cost" above data grid. See note.
  • In Listings you you need to search by warehouse and then click the button "Get the Warehouse Cost" above data grid. See note.


You do not have to search by warehouse if you use some other filter to get your data. If you have mixed warehouses there will be Pop Up to select the default warehouse to get your Current Costs from. That will help a lot if you have same prices in all warehouses.

Current Cost is great way for you to find the zero [0] current cost. You cannot have the Current Cost of 0, that means that you do not have the price properly setup. That will fail COGS reporting even in Skubana Application.


ChangeLog April 16, 2019

ChangeLog April 16, 2019


  1. Skubana API restore rate for the Inventory call "Remove product stock quantity" is set to 1 second. This will solve the issue of frequent API bad request because of the timeout.

ChangeLog September 13, 2018

ChangeLog Semptember 13, 2018

New features:

  1. We are adding a new field, shipByDate. The "shipByDate" information was previously in the "shipDate" field for unshipped Amazon orders. Going forward, the "shipByDate" field will contain this information for Amazon, Jet, and Walmart orders, and "shipDate" will only contain the "shipDate".
  2. We are moving application to secure domain. So moving forward we will be using https.

ChangeLog August 8, 2018

ChangeLog August 8, 2018

New features:

  1. Added Print PO batch SKU to PDF logic for Purchase Orders. It can be used with right click when you are browsing PO`s. It works from grouped data. Select parent PO, right mouse click and select "Print PO". In Print Dialog you can decide amount of print labels and print dimensions. It will save it to the PDF file which you can later print. 

ChangeLog April 4, 2018

ChangeLog April 4, 2018

New features:

  1. Added logic that will merge "orderType" [FBA,FBA_WORKFLOW,STANDARD] with sales Chanel if it is not STANDARD. That is making easier to see grouped data information by Sales Chanel. 
  2. Added missing field in Products for bundled items. Field is called "bundledProductQty".
  3. Added new tooltip description for datagrid. It is very important to learn the difference between "Order Item Value" and "Line Item Value". "Order Item Value" is value that is for whole order like Discount, or Shipping Cost. Those fields will get correct summary only if grouped or sub-grouped by "orderID". So they must have whole Order items grouped to get correct result. Rollover toll-tip will say if the math is dividing with "order items length". Those fields needs orderID to get correct data. Using group by Master SKU, will pull the individual sold items into grouping making those false numbers.

That is visible now with "Sales Revenue" and same field "orderItemsTotal" from Skubana. From Skubana it is "Order Value", in store report it is calculating correctly by "line items value" [unit price * qty]. When there is orderId group those values are the same, but if you drag Master Sku on first place, StoreReport will have accurate data, and field "#orderItemsTotal" will not.


Bug fixes:

  1. Fixed tooltip for Unit Price, made it Skubana line item.

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
  • “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

ChangeLog February 27, 2018

ChangeLog May 18, 2017

ChangeLog May 18, 2017


  • 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.