Generate a list of variant product IDs from an export of a base product

variant-ids.py

import xml.etree.ElementTree as ET

# Load and parse the XML file
tree = ET.parse('C:/Users/xxxx/Downloads/product-base.xml')
root = tree.getroot()

# Define the namespace
namespace = {'ns': 'http://www.demandware.com/xml/impex/catalog/2006-10-31'}

# Find all variant elements and extract the product-id attribute
variant_ids = [variant.get('product-id') for variant in root.findall('.//ns:variant', namespace)]

# Convert the list to a comma-delimited string
variant_ids_str = ', '.join(variant_ids)

# Display the comma-delimited string
variant_ids_str