File structure in merXu format (.xls, .xlsx or .csv)

File structure in merXu format

Sheet structure

The file should always have the same form:

• The first row are the column headings into which the attribute names are entered. That is, for example, the name of the product, weight, country of production and others (some attributes are mandatory - you will find all the information and a list of attributes in section 4.);
• The following lines are products (one line = one product). A file can contain a maximum of 10,000 rows. If you want to add more products, create and upload more files.

Maintaining the structure will avoid errors and enable proper integration with merXu.

Example of a spreadsheet with product data described according to the merXu standard; (note the variants: name field in additional language, weight unit notation, vat).

Minimum file content

The smallest sheet that will allow you to import a product must contain three columns: the category of the 

• the supplier code you give to your product - supplier_product_id,
• product name. – name,
• the category of the offered product - merxu_category_path or supplier_category_path

A file with these three attributes will allow the product to be imported, but is not enough to trigger a sale.

To trigger a sale - to make an offer, you need three more mandatory parameters:

• currency,
• price,
• vat

Each product that you import into merXu must be assigned a unique code that allows us to uniquely identify it (see more about supplier_product_id HERE), and a name. The offer, on the other hand, must additionally have a price, currency and VAT rate.

Language of parameters and values

The format you receive from us contains attributes written in English. Nevertheless, you fill in the values in the rows in your own - or selected (available on merXu) - language. On the slide you see a table with English product attributes and Polish row contents:

Fill in the names and values of the additional attributes that you add to the table yourself, in your own or in the language of your choice available on merXu (Polish, Czech, Lithuanian, Estonian, English, Slovak, Hungarian, German, Romanian):

Additional attributes: Gross weight, diagonal; recording of units of measurement and weight.

If you are importing products described in Estonian, for example, indicate the Estonian language in the drop-down list immediately before uploading the file:

 

You can prepare products described in one of the languages available on merXu - for example, in Czech - or provide product description and name in several languages - but remember to name the columns properly. You can find the description in article List of attributes in merXu files (.xls, .xlsx or .csv).