How to publish products?

You can upload product information from a file.

Create a CSV file or Excel file where each line has one product. Note the following:

  • The first line can be a header. During the upload this helps you to map columns of your file to fields used by the Glue service.

  • Comma (,) and dot (.) are accepted as decimal separators.

  • If you use the CSV file then the field values shall be separated by semicolon (;).

  • If Excel file has multiple sheets, then the first one shall include values used for the product upload.

  • Field value to be uploaded can be reference to other field in the other sheet.

  • It is strongly NOT recommended to use calculations in the Excel as uploaded value may not be the same as it looks in the Excel due to round up of values. For example, Excel may show rounded value of price with two digits but the Glue imports non-rounded value.

  • Upload does not work if:

    • the same column name is used multiple times.

    • the same product ID is multiple times.

CSV file example

When the file is ready, follow the example (see video below) and upload it the service.

You can upload products also using API. See more information from Products API. With API you can automate, for example, stock balance updates.