ChangeLog April 16, 2019

ChangeLog April 16, 2019

Update:

  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.

  • “orderType” - ['STANDARD', 'PRIME', 'POS', 'FBA_WORKFLOW', 'FBA', 'STOCK_TRANSFER']

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

ChangeLog February 27, 2018

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.

 

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