Skip to content
English
Submit a Request
Go to daasity.com
  • There are no suggestions because the search field is empty.

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.