Posted on

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.

 

 

Posted on

ChangeLog June 26, 2020

ChangeLog June 26, 2020

Major update

This update is all about application crashing with more than 10.000 rows. There is a time limit on how much some script can work. With 10k of rows that time limit will be reached. To fix the this issue scripts that are slowing application are found.

Grouped and flat data refresh

When grouping is done summing up all the rows is time consuming. When flat data is showing, everything will work very fast. When data changes view need to refresh. Refreshing flat data is fast and grouped data can be slow and crash the application. It is actually same data grid that is showing different views [flat/grouped] so it is all about refreshing the view. New algorithm will now keep track on what kind of data need refreshing [flat/group], also if group data parsing is done you can switch between Flat / Group view without new Group data refresh.  That way working with Flat data will be possible even for extremely large data sets of 30.000 rows, Group will still work.

Note: As group view with large data will take long time to populate prepare summaries and group logic in Flat view or without data. You don`t want to refresh that group view more than needed.

asynchronous group data view refresh

If the data is more than 7000 rows, Group view will switch to asynchronous parsing data. This is lot slower than before but it will assure application will not crash because of the script time out. It will never crash and data will be parsed even if it takes 10 minutes, application will not crash during this time. You will be presented with Information that large data parsing started. You will than on the end get Information that Data is ready.

StoreReport Alert for large data grouping

Load, Save and export data

This is also where application would crash. On Load data application would crash after data Load because the refresh was doing the Group refresh.  On Save and Export it would crash because of the amount of rows that where parsing into JSON or TSV.

load saved data

Load is now working only refresh on the Flat data, so it will not crash when you aggregate files into large data set.

asynchronous data Parsing and zip files

New algorithm for parsing data is asynchronous. You will be provided with information pop-up about current progress. On the end it will create files of 10K of rows and zip them into one. Save button will be enabled after files are parsed.

StoreReport export files Alert dialog

New Features:

    • Asynchronous group data view refresh - if data is larger than 7000 rows group view will switch to asynchronous parsing. Two information pop-ups swill show. One when grouping started one when grouping is done. You can cancel refresh in first pop-up.
    • Asynchronous Save and Export  - application will parse data without crashing and it will create ZIP file with 10.000 rows of data
    • New Number Format - Four decimals format without trailing zero. If number is 4.3210 application will show it without end 0, so it will show 4.321.
Posted on

Setup and Support

On this page we will try to explain how to setup an account with StoreReport, how to use Customer Support portal and more. 

Users

There are 4 different categories under which you can setup an account or interact with StoreReport:

Trial (7 days)

  • Full access to StoreReport for 7 continuous days including weekend and for one Skubana Store
  • Limited access to Customer Support portal

New User

  • Users with new account or trial accounts after 7 days period
  • Full access to StoreReport for 30/180/365 continuous days and for one Skubana Store
  • Full access to Customer Support portal

Existing user

  • Users with existing accounts
  • Full access to StoreReport for 30/180/365 continuous days and for one Skubana Store
  • Full access to Customer Support portal

Multi-store VIP users

  • New or existing accounts
  • Full access to StoreReport for 30 continuous days and for up to 10 Skubana Stores depending on the VIP Plan
  • Full access to Customer Support portal

Orders & Plans

All users should submit their orders using Orders & Plans in the menu of this site.

Orders

It is a 3 step process which will include: General information about your account, Category of your account and finally Plan.

On the following page please enter your name, email address which you are using with your Skubana Store, name of your store (if you have more than 1 Skubana Store enter VIP) and read our Terms and Conditions including our Privacy Policy. Once read, check that you have read and agree with them and Continue.

Plans

In step 2 you have the option to specify future category of your account. Multi-store Skubana Store users will have access to different stores and their plans are different.

Please select that you are: New user, Existing user, Trial user or Multi store/Accountant/3rd party service user; Please input your instructions or elaborate how you plan to use your account.

Once completed, verify Captcha and Continue.

Payment/Billing

Final step is to select your plan. New and Existing users should proceed with their payment on this page. Select your Plan and re-type email address you have registered with your Skubana Store. Click pay Now and wait for PayPal to prompt secure payment page. You can use your PayPal account or any Debit/Credit card supported with PayPal.

Trial users should NOT proceed with payment unless you plan to use StoreReport after 7 days trial period.

Multi store/Accountant/3rd party service users please do NOT proceed with payment since you will be able to complete your payment through our Customer Support portal.

Support

Use Customer Support portal to submit new ticket requesting support, make payment, change your plan and more.

Tickets

Only registered users can submit a new ticket to Support. To submit ticket login to Customer Support portal with credentials we provider upon registration. All other requests for support will void.

Guide

StoreReport Guide is available to all, both visitors and users. Please try to find answers before submitting New Ticket.

 

Final words

You reached the end of this guide. Hope you found it useful? Tell us what you think? We can end the way we started. Security is tight in StoreReport. We keep only basic information in our user database and we make NO changes to your data.

Thank you.

 

 

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

StoreReport Guide

StoreReport logo transparent
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