Happening now! Shopify Community AMA: PayPal Express Migration to Shopify Payments | Ask your questions to be answered by our team.

ABC inventory report includes discontinued and archived products

Solved

ABC inventory report includes discontinued and archived products

dogmeatsbone
Excursionist
19 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
Shopify Partner
691 86 102

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 5 (5)

PageFly-Theodor
Shopify Partner
691 86 102

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
Shopify Partner
349 12 26

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
19 1 0

many thanks to you both

Dеnys_Mipler
Shopify Partner
60 0 4

 

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 ]

BetterReports-D
Shopify Partner
7 0 0

Hi @dogmeatsbone 

 

Have you been able to find a solution? If not, I would recommend our app Better Reports for this!

 

I’m Ciara from Better Reports, and we frequently help merchants with exactly this type of request.

 

We can create an ABC-style report just like Shopify’s but include a product status filter to show active products and exclude archived or drafted products.

 

In addition to custom reporting, Better Reports has more than 80 built-in reports available out of the box that cover many common use cases for merchants. You can schedule reports to run at set frequencies to your email or Google Drive or export the reports in CSV, Excel, HTML, or PDF format.

 

I encourage you to install Better Reports and start your free 14-day trial and I'll be happy to set this up for you.

 

What do you think?