Skip to content
English

Prepare and map the product file

The mapping tells ELChat what each column of your file represents.

Group Main fields
Product mandatory name, reference, type, category, description
Prices prices, currency, minimum/maximum price, promotion, VAT
Description and SEO short description, characteristics, brand, tags, keywords
Logistics stock, quantity, weight, dimensions, colors, materials, availability
Media main image, product URL, gallery, video
Metadata status, language, visibility, date of creation
  1. Check the file preview.
  2. For each useful field, choose the corresponding column.
  3. Leave Unmatched for a column you do not want to import.
  4. Check that the product name is associated.
  5. Check the processed data in the preview.
  6. Validate import.
  • do not map the same column to two incompatible meanings;
  • do not mix the price with the promotional price;
  • provide a currency when several currencies are possible;
  • use consistent stock values;
  • keep image and product URLs in separate columns;
  • do not assume that a video imported as a URL becomes a source of independent video knowledge.

The CSV or XLSX model takes the expected keys. It is useful to prepare a new export or ask another team to provide a compatible file.