Hi, recently went to the “products” tab an exported a csv of my items – but I need the descriptions as well. those were not included in the csv.
How do I get a an export with descriptions by product SKU?
Thanks!
Topic summary
Main issue: exporting Shopify product data with descriptions aligned to SKUs.
-
Product descriptions are included by default in Shopify’s product CSV. They appear in the “Body (HTML)” column (3rd column). Descriptions are tied to the product handle (the product itself), not to individual variants/SKUs.
-
If “Body (HTML)” is empty in the export while descriptions exist in the product editor, the advised action is to contact Shopify Support, as this should not occur.
-
A follow-up concern notes CSV formatting problems when descriptions contain commas and semicolons. This causes the exported file to show extra rows (due to semicolons) and extra columns (due to commas).
-
The thread does not provide a solution to the CSV delimiter/formatting issue. The request for guidance on avoiding this parsing problem remains unanswered, and the discussion is open.
Hi @mdel0 ,
By default, Shopify product exports include the product description. It’s the 3rd column of the CSV file you downloaded, titled Body (HTML). Keep in mind that descriptions are matched with the product handle (and therefore with the product as a whole), and not individually per variant (SKU).
If the file you received doesn’t have any information under the column Body (HTML), but your product editing page has the description field populated, then I suggest that you contact Shopify support—as this is something that shouldn’t actually happen.
@pvoulg In my case, since the Body (HTML) contains commas and semicolons the CSV codification generate errors. The exported file contains more rows (due to semicolons) and more columns (due to commas).
How can I avoid this issue in the exportation?
Thanks