Import extra fields on products

You can import custom fields for products via CSV import. Since Shoporama does not know your custom fields in advance, they are specified in a single field.

CSV Format

Custom fields are specified in the ` extra_fields ` column as a query string, i.e., field=value separated by & (just like parameters in a URL):

item_number;title;extra_fields
PROD-001;My product;material=cotton&color=blue&weight=250g
PROD-002;Another product;material=polyester&color=red

The value is parsed using PHP’s built-in ` parse_str()` function, so the syntax is the same as you’re familiar with from URL parameters.

Important

• The field name must match the extra field name created in your product profile
• Values are case-sensitive: "Blue" and "blue" are different values
• Use & as a separator between fields
• Use "=" as a separator between the field name and the value
• Special characters such as &, =, and spaces in values must be URL-encoded (e.g., %26 for &)

Multiple values per field

If a field is to have multiple values (e.g., color with both blue and red), you can specify the field as an array using square brackets:

extra_fields
color[]=blue&color[]=red&material=cotton

See also: Import products via CSV.

Need help? Contact us at support@shoporama.dk.