Why is a Product Name showing up as NULL

What to do if your Product Name is showing up as NULL in Product Attributes.

Why?

If you see a NULL, it means that the SKU that exists in order_line_revenue doesn’t exist in sku_attributes.  Note that order_line_revenue comes from the order item data and sku_attributes comes from the product data.  So if you delete a product it won’t join as defined product.

In case if SKU is missing, Daasity will replace blank SKU with "tmp12345678901234" and group it up with the NULL () sign, still counting sales for undefined product.

To avoid this happening, simply unlist the merchandise without actually removing it.

How to tag your SKUs

To have SKUs appear as a defined product data, instead of , you must add SKU numbers to your product variants from in Shopify admin.

  1. From your Shopify admin, go to Products > All products.

  2. Click on the product that you would like to edit.

  3. For products with multiple variants, in the Variants section, add your SKU numbers:

Product Name showing up as NULL 1

For products without variants, in the Inventory section, add your SKU number:

Product Name showing up as NULL 2

4. Click Save.

 
You're all set!

After the data is refreshed - SKUs will be defined respectively after the next update.