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. From your Shopify Admin, go to Products > All products.

  2. Click on the Product to Edit.

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

4. Click Save.

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

Last updated