Solved

ABC inventory report includes discontinued and archived products

dogmeatsbone
Excursionist
17 1 0

does anyone know of a way to customise the report to include a status column? 

 

the report in theory looks great but falls down when it is still including items that are no longer on sale.  

 

i've tried to filter items include those items that have quantities greater than zero but as the report is a few days old, i'm still getting inaccurate data. 

 

many thanks

Accepted Solution (1)

PageFly-Theodor
Globetrotter
576 76 88

This is an accepted solution.

Hi @dogmeatsbone ,
This is Theodore from PageFly - Shopify Page Builder App

Shopify reports don't allow adding custom columns like "status" to exclude inactive products. Here are some workarounds:

  1. Filter Existing Reports: Use available filters in inventory reports, like "Available quantity" greater than zero, to exclude out-of-stock items.

  2. Product Availability: Check the "Product Availability" section within product listings for individual status.

  3. Custom Reports (Apps or Exports):

  • Use third-party apps that offer report customization and might allow adding a "status" column based on your needs.
  • Export product data to a spreadsheet and create custom filters or formulas to categorize them by stock availability and sales status.


Best regards,
Theodore | PageFly

Please let me know if it works by giving it a Like or marking it as a solution!


PageFly - #1 Page Builder for Shopify merchants.


All features are available from Free plan. Live Chat Support is available 24/7.

View solution in original post

Replies 4 (4)

PageFly-Theodor
Globetrotter
576 76 88

This is an accepted solution.

Hi @dogmeatsbone ,
This is Theodore from PageFly - Shopify Page Builder App

Shopify reports don't allow adding custom columns like "status" to exclude inactive products. Here are some workarounds:

  1. Filter Existing Reports: Use available filters in inventory reports, like "Available quantity" greater than zero, to exclude out-of-stock items.

  2. Product Availability: Check the "Product Availability" section within product listings for individual status.

  3. Custom Reports (Apps or Exports):

  • Use third-party apps that offer report customization and might allow adding a "status" column based on your needs.
  • Export product data to a spreadsheet and create custom filters or formulas to categorize them by stock availability and sales status.


Best regards,
Theodore | PageFly

Please let me know if it works by giving it a Like or marking it as a solution!


PageFly - #1 Page Builder for Shopify merchants.


All features are available from Free plan. Live Chat Support is available 24/7.

Report-Pundit
Trailblazer
317 11 21

Hello @dogmeatsbone ,

Unfortunately, Shopify reports do not offer the flexibility to add custom columns like "status"  and other data to your reports. If your business relies on custom data for analysis and decision-making, consider using a reporting tool.

Check out Report Pundit with a free 14-day trial. We can also help you set up any custom reports you need and schedule them to save time spent on reporting.


For easy data analysis,
Team Report Pundit



Report Pundit - Instant reports and custom dashboards

dogmeatsbone
Excursionist
17 1 0

many thanks to you both

Dеnys_Mipler
Shopify Partner
56 0 2

 

Hey, @dogmeatsbone 

This is Denys from Mipler: Custom Reports.

Nice to connect with you here!

 

Unfortunately, as mentioned earlier, achieving this with Shopify's native functionality isn't possible.

However, I'd like to recommend checking out the functionality of our application.

You can find it by following the link below: https://apps.shopify.com/advanced-reports

Our talented developers have created the ABC analysis report, allowing you to easily filter by the required product status:

Dnys_Mipler_0-1715780458554.png

 

We offer a free 7-day trial period, and our support team would be delighted to create any report tailored specifically for you.

Just send us a request and give us a little time to provide you with a complete solution.

Looking forward to hearing from you soon! 🙂

Just Play in Analytics with Advanced Reports
Other Great Apps: [ Shopping Feeds | Instant Search ]
Socials: [ Facebook | Twitter | Blog ]