Premium Report - Product Cleanup

Product Cleanup

This report is for merchants who are looking to update and cleanup their products in Shopify. 

Using this report, you can see exactly which products are missing which values, navigate directly to them in Shopify (click the hyperlink for each Product Title) and then update them accordingly. 

You can find this report under Products in the left-hand menu.

As a Premium Report, this is available on all Paid Plans of Report Toaster. If you aren't signed up, follow these steps here to upgrade your account. 

Note that by default, this report is filtered to display only active product variants (see Status, below) that have any missing details (see Issues, below).

You can remove any of these conditions from the filter to only look for the product variants you care about.

Here is what you need to be familiar with to understand the Product Cleanup report.

1.) Issues: Which fields are missing for this Product Variant. Possible values include:

1. Missing Barcode - Whether this is a Barcode, UPC or ISBN, these are often crucial to track and organize your inventory.
2. Missing Category - This is an issue if you make use of the Product Category from Shopify's Standard Product Taxonomy.
   
3. Missing Collection - This is an issue if you rely on Collections to group your products and monitor how well each of them are selling. 
4. Missing Compare at Price - This is an issue because you won't be able to accurately measure Markdown vs Full Price sales and see which of your Variants are most discounted. 
5. Missing Cost -  This is an issue because you won't be able to accurately measure Profit and this can directly hurt your bottom line. 
   
6. Missing Description - Most customers want at least a short description to provide details of what they're buying! 
7. Missing Image - This is an issue because most customers want to see a photo/video of the product before making a purchase.
8. Missing Price - This is an issue because, aside from free samples, most products you sell will need a price. 
9. Missing Product Type - Typically this is useful to organize your products into unique categories, so if the values are blank, those items won't be included in Sales by Product Type report.
   
10. Missing SKU - Again, the Stock Keeping Unit (SKU) is usually used in tracking and organizing inventory. You may also want to check out our Duplicate SKUs report as well. 
11. Missing Weight - Doesn't matter for digital goods, but often vitally important for physical goods in the warehouse and especially for Shipping.
    

For example,  many of these variants in our demo store are missing a Barcode and a Product Type. This might make it difficult to manage inventory and assess sales on a grouped category basis.

Finally - If you want to see more details on any of the variants, then you can click the pop-up box on the right side of each row to see all of the relevant details. (including the current values for the above). 

Like all Report Toaster reports, these reports are fully customizable - so you can add/remove columns, introduce a filter or change the sort to suit your individual needs. See our basic guides here for more info.

For other premium reports you can add to your account, check out our other article guides here. 

• Related Articles

• Premium Report - Sales by Product Category

  Sales by Product Category Sales by Product Cateogry is used to see a breakdown of your sales according to the Category from Shopify's standard product taxonomy (see here) From this report, you can see the total key sales figures (Orders, ...

• Whats New? - December 2024

  So we've come to the end of 2024! As we wrap things up for the holiday season, we figured it was time to review some of the great new additions we've made this year. Let's take a look! 2024 - A Review With a ton of new features, reports, and data ...

• Whats New? - November 2024

  The holiday season is in full swing, and thanks to our compatibility with Shopify's new API release, we have all sorts of updates to show off in Report Toaster! Let's take a look! More Variants One of the main changes with the new API release is that ...

• Premium Report - Sales by Compare at Price

  Sales by Compare at Price These reports is used for seeing which products are selling at Full Price vs Markdown. This is determined by looking for any instances of where the product's actual sale Price differs from its Compare at Price - the Shopify ...

• Premium Report - Duplicate SKUs

  Duplicate SKUs This report does exactly what you would expect - show any variants which have duplicated SKUs. This is often useful for merchants who are tidying up their product catalogue and need to make sure that no two SKUs are the same across ...