Import extra fields on products

You can import extra fields on products via CSV import. Since Shoporama doesn't know your extra fields in advance, they are entered in a single field.

CSV format

Extra 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;Other product;material=polyester&color=red

The value is parsed with PHP's built-in parse_str(), so the syntax is the same as you know from URL parameters.

Important to note

• The field name must match the additional 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 field name and value
• Special characters like &, = and spaces in values must be URL-encoded (e.g. %26 for &)

Multiple values per field

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

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

See also: Import products via CSV.

Do you need help? Contact us at support@shoporama.dk.