Why is a Product Name NULL?
Last updated
Was this helpful?
Last updated
Was this helpful?
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
You must add SKU numbers to your product variants in Shopify admin for SKUs to appear as a defined product data, instead of NULL ∅
From your Shopify Admin, go to Products > All products.
Click on the Product to Edit.
For Products with multiple variants, in the Variants section, add your SKU numbers:
For products without variants, in the Inventory section, add your SKU number:
4. Click Save.
After the data is refreshed - SKUs will be defined respectively after the next update.
