Skip to main content

CSV Schema

Overview of WooCommerce CSV columns expected by WooTUI.

WooCommerce Standard Columns​

Core product fields from WooCommerce export:

Product Identity​

  • ID - WordPress post ID (required for updates)
  • SKU - Unique product identifier
  • Type - Product type (simple, variable, etc.)

Translatable Content​

  • Name - Product title
  • Short Description - Brief summary
  • Description - Full product details
  • Categories - Product categories (comma-separated)
  • Tags - Product tags (comma-separated)

Non-Translatable​

  • Published - Publish status (1/0)
  • Regular Price - Price in numbers
  • Sale Price - Sale price
  • Images - Image URLs (not translated)
  • Stock - Stock quantity

Attribute Columns​

Variable products use 4 columns per attribute:

Format: Attribute X [Field] where X is a number (1, 2, 3, etc.)

For Each Attribute:​

  1. Attribute X Name - Attribute label (e.g., "Color", "Size")
  2. Attribute X Value(s) - Comma-separated values (e.g., "Red, Blue, Green")
  3. Attribute X Visible - Show on product page (1/0)
  4. Attribute X Default - Default selection for variations

Example:

Attribute 1 Name,Attribute 1 Value(s),Attribute 1 Visible,Attribute 1 Default
Color,"Red, Blue, Green",1,Red

WooTUI auto-detects all attribute columns in your CSV.

Meta Columns (WPML & SEO)​

WPML Columns (Required)​

These columns link translations together:

  • Meta: _wpml_import_source_language_code - Source language (e.g., en)
  • Meta: _wpml_import_language_code - Translation language (empty for source, es for Spanish, etc.)
  • Meta: _wpml_import_translation_group - Group ID linking translations (e.g., woocommerce_product_123)

Generated by WooTUI:

  • Meta: _wpml_import_wc_local_attribute_labels - Maps attribute slugs to translated names

SEO Meta Columns (Optional)​

Rank Math:

  • Meta: rank_math_title - SEO title
  • Meta: rank_math_description - Meta description
  • Meta: rank_math_focus_keyword - Target keyword

Yoast SEO:

  • Meta: _yoast_wpseo_title - SEO title
  • Meta: _yoast_wpseo_metadesc - Meta description
  • Meta: _yoast_wpseo_focuskw - Focus keyword

Custom Meta​

Any column starting with Meta: can be selected for translation in WooTUI (Step 2).

What WooTUI Expects​

Minimum Required Columns​

  • Product identity: ID or SKU
  • WPML columns: Meta: _wpml_import_* (all 3)
  • At least one translatable column: Name, Description, or Short Description

Use "All columns" when exporting from WooCommerce to ensure:

  • All WPML columns are included
  • Attributes are captured correctly
  • SEO meta fields are available

Data Types​

String (Translatable):

  • Names, descriptions, categories, tags
  • Attribute names and values
  • SEO meta fields

Numeric (Not Translatable):

  • Prices, stock quantities, dimensions
  • Boolean flags (Published, Visible)

Structured (Not Supported):

  • JSON data
  • Serialized PHP arrays

Next Steps​