inventory by sku report sorted

[abdilhadi]

Hi,

I would like to have a report which shows all my products in all stores sorted by product quantity so i can know what products that i can make sales or marketing on them.

inventory by sku report is good enough, only if i can add custom query to sort by qty.

maybe in the next upgrade, you can add in the custom query menu a specif field to sort by.

[Benjamin]

You can use the “Raw Data” function (checkbox below print button) to export data to Excel and then sort by quantity.

[abdilhadi]

The raw data function is not available in the inventory by sku report.

even if made print preview then export to excel file, the exported excel file have product name and sku in the same column, so the exported data is not suitable to be made as table and sorted.

[Benjamin]

Please try to use an administrator account. You will see the “Raw Data” option and SKU and product number columns.

[abdilhadi]

But I don’t want this user to be an administrator, he is already a power user with almost 95% of permissions.

and he need to generate this report every week, so its not practical to let the administrator do this job on behalf of the poweruser.

[Benjamin]

Just first check if this works for you or not. I’ll enable this function for all users for this report.

[abdilhadi]

yes it did work for me using the administrator account.

it would be beneficial to have it enabled in all reports for all users.

[Benjamin]

I have enabled for all users. Please get the upgrade.

[abdilhadi]

i did the upgrade but the option didn’t show to users, I’m on version 18.07.09.11

[Benjamin]

Maybe data sync delayed. Can you check if switch 086 is on (in store settings)?

[abdilhadi]

yes seems data sync issue, after all data got synced, i restarted the software and it worked.

 

thanks