Jump to content

Monthly sales comparison


Recommended Posts

Posted

I work in consignment. Does Loyverse have a feature that allows me to identify items that haven’t sold in a month or to analyze which items have the slowest sales? This would help us decide whether to continue stocking those items or stop getting supplies.

Posted

Hello @Laurence

Unfortunately, we don’t have the specific feature in Loyverse which can help you with this request. However, there’s a workaround solution that I can share with you. This workaround uses spreadsheets.

 

  • First, filter the sales report by items for the desired month period.
  • Export the filtered report so the data on the file will only contain reports for that month.
  • Then, export your complete item list from Loyverse.
  • Open both files, and copy the list of sold items from the sales report file.
  • Paste the copied list into a new column in the item list file.
  • To compare the information, use a special spreadsheet formula:
    • =COUNTIF(B:B, A1) > 0 
      • Replace B:B with the column containing the sold items.
      • Replace A1 with the cell containing the item name from your item list.
  • Filter the items to determine which item names haven’t sold for a month.

This formula will return TRUE for items that were sold and FALSE for items that weren’t sold. With this, you can determine whether to continue stocking such items or stop getting supplies.

 

Here’s an example of how you can use the formula: monthlyreportscorrect.thumb.gif.9909627b58280d48af741250f0f2c9d3.gif

  • Like 2

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now

Loyverse Point of Sale

 

 

 

 

×
×
  • Create New...