Erp import format

Sample import files (CSV) for the app. Place these in Excel and save as .xlsx/.csv to import via the UI.

Files created: - import_article_categories.csv - Columns: identifier, languages (format: "de:Text;en:Text;...") - Example: getraenke,"de:Getränke;en:Beverages"

  • import_articles.csv

  • Columns (by index expected in importer): 0 identifier (not used as id), 1 description (currently only German; format could be "de:Text;en:Text" if importer updated), 3 available (1/0), 4 name, 5 number, 6 price, 7 categories (semicolon separated identifiers), 8 imageUrls (semicolon separated), 9 bannerTitle (currently German), 10 bannerBackgroundARGB (int), 11 bannerFontARGB (int), 12 bannerFrom (ISO date), 13 bannerTo (ISO date), 14 customerCategoryIdentifiers (semicolon separated), 15 countryIdentifiers (semicolon separated)

  • import_customer_categories.csv

  • Columns: identifier, translations (de;en;fr;it;es), colorARGB

  • Example: premium,"Premium;Premium;Premium;Premium;Premium",4294967295

  • import_customers.csv

  • Columns mapping used by the importer: 0 companyName 1 customerNumber 2 customerCategoryIdentifier (identifier string) 3 languageIndex (index into LanguageEnum) 4 countryIndex (index into CountryEnum) 5 city 6 street 7 zipcode 8 phone 9 mobile 10 homepage 11 email 12 isMinimumOrderAmountActive (1/0) 13 minimumOrderAmount (int) 14 onTelephoneList (1/0) 15 isBlocked (1/0) 16 showPriceInMobileApp (1/0) 17 noDemandUntil (ISO date) 18 notificationGroupIds (semicolon separated)
  • Note: importer currently sets orderMinimumQuantityMeasurementUnit to Euro by default and does NOT read a specific column for it. If you need to import that field, I'll update the importer to read an extra column.

Notes and recommendations: - The CSVs use semicolon ";" inside quoted fields to separate multi-values (categories, imageUrls, translations). - For IDs/references (article package sizes, categories) use the identifier strings as shown in the other CSVs (e.g. liter_1l, getraenke, premium). - If you want, I can convert these CSVs into real .xlsx files; right now they are CSV which Excel opens fine.