• Resolved koitaki

    (@koitaki)


    When importing product data via a CSV import, I’ve previously blown up my database by tweaking the parent/child relationship column (I attempted to change it from using SKUs, by replacing them with IDs, which I figured was better practice). This resulted in many duplicated variable products – the newly created ones had no images, the old ones had no variations.

    I have just again blown up my database in the CSV import. This time I was attempting to speed up the import process by marking various fields, such as Description and Attributes, as “Do not import”. They hadn’t changed, so I figured why import them again – just update the Price changes. When I subsequently checked my website, I no longer had variations, with just a message saying I first needed to add attributes to generate variations.

    Trying to research this problem, I’ve come across the below, which would appear to explain the above issues:

    Fields that are “structural” get wiped if present in the CSV but mapped to “Do not import.”
    Fields that are “content” are ignored safely.

    Structural fields include:

    • Attributes
    • Variation attributes
    • Variation rows
    • Parent/child relationships
    • SKU (if blank)
    • Product type (if blank)

    Content fields include:

    • Description
    • Short description
    • Regular price
    • Sale price
    • Stock quantity
    • Weight
    • Dimensions

    Could someone who knows confirm if this is correct please. If so, it would suggest a user needs to be pretty careful when messing around with Structural Data.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Hi @koitaki, I understand the frustration and concern you’re experiencing with CSV imports and how it’s affecting your product variations. You are correct in observing the distinction between structural and content fields. In WooCommerce:

    Structural fields like Attributes, Variation attributes, Variation rows, Parent/child relationships, SKU (if blank), and Product type (if blank) are crucial for product structure. If these are present in your CSV but mapped to “Do not import,” WooCommerce may remove or disrupt them, which explains why variations disappear when skipping these fields.

    Content fields such as Description, Short description, Regular price, Sale price, Stock quantity, Weight, and Dimensions are safe to skip—they won’t overwrite existing content if mapped to “Do not import.”

    Because structural fields directly impact the relationships and hierarchy of variable products, extra caution is needed when adjusting them in imports. For a full reference and best practices on CSV imports, you can check out the official WooCommerce guide here: WooCommerce CSV Import.

    Feel free to let us know if you need further support.

    Plugin Support Kay U a11n

    (@kingsleyinfo)

    Since there’s been no recent activity on this thread, I’m marking it as resolved. Don’t hesitate to start a new thread if you need help in the future.

    We’d love your feedback – please leave us a review: https://ww.wp.xz.cn/support/plugin/woocommerce/reviews/

Viewing 2 replies - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.