Daasity Knowledge Base
Ask or search…
K

Why is a Product Name NULL?

A NULL Product Name indicates the SKU exists in order_line_revenue but does NOT exist in sku_attributes.
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.
If a SKU is missing, Daasity will replace a blank SKU with "tmp12345678901234" and group it up with the NULL () sign, Still Counting Sales for Undefined Product.
Un-list the merchandise without actually removing it - To Avoid This

How to Tag Your SKUs

You must add SKU numbers to your product variants in Shopify admin for SKUs to appear as a defined product data, instead of NULL
  1. 1.
    From your Shopify Admin, go to Products > All products.
  2. 2.
    Click on the Product to Edit.
  3. 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.
After the data is refreshed - SKUs will be defined respectively after the next update.