Yeah it's tough to get an exact match so the best approach may be to create excel formulas the format the file as desired for PowerBI. For example, you could do the following to assign a listing status to all of the blank cells (while the exported Sh...

If I were to guess, they may leave the cells blank to reduce file size and/or to visually separate each product in the file (since they don't have a separate row for the parent product containing variants). But I agree it's confusing when the listing...

You can only change the listing status for a product, not its underlying variants. So in the ui it's showing "active" for all variants of an "active" product because the variants inherit the product's listing status. Whereas in the csv, the report le...

One option would be to use the "Purchase Orders" functionality in Shopify Admin. From your Shopify admin, go to Products > Purchase orders, and then click "Create purchase order". You can then choose the supplier and enter details about the arrival d...