Product Import/Export profile for Shopware 6

products.sql

INSERT INTO `import_export_profile` (
  `id`,
  `name`,
  `system_default`,
  `source_entity`,
  `file_type`, 
  `delimiter`,
  `enclosure`,
  `mapping`, 
  `created_at`,
  `updated_at`,
  `config`
) VALUES (
  UNHEX('c2fab5123d634fbb9f5f3d79cbdf7974'), 
  'Produkte', 
  0,
  'product', 
  'text/csv',
  ';',
  '"',
  '[
   {
      "key":"active",
      "mappedKey":"active"
   },
   {
      "key":"autoIncrement",
      "mappedKey":"autoIncrement"
   },
   {
      "key":"available",
      "mappedKey":"available"
   },
   {
      "key":"availableStock",
      "mappedKey":"availableStock"
   },
   {
      "key":"childCount",
      "mappedKey":"childCount"
   },
   {
      "key":"configuratorGroupConfig",
      "mappedKey":"configuratorGroupConfig"
   },
   {
      "key":"cover.versionId",
      "mappedKey":"cover.versionId"
   },
   {
      "key":"cover.media.Id",
      "mappedKey":"cover.media.Id"
   },
   {
      "key":"cover.position",
      "mappedKey":"cover.position"
   },
   {
      "key":"cover.customFields",
      "mappedKey":"cover.customFields"
   },
   {
      "key":"cover.createdAt",
      "mappedKey":"cover.createdAt"
   },
   {
      "key":"cover.updatedAt",
      "mappedKey":"cover.updatedAt"
   },
   {
      "key":"deliveryTime.id",
      "mappedKey":"deliveryTime.id"
   },
   {
      "key":"deliveryTime.name",
      "mappedKey":"deliveryTime.name"
   },
   {
      "key":"deliveryTime.customFields",
      "mappedKey":"deliveryTime.customFields"
   },
   {
      "key":"deliveryTime.min",
      "mappedKey":"deliveryTime.min"
   },
   {
      "key":"deliveryTime.max",
      "mappedKey":"deliveryTime.max"
   },
   {
      "key":"deliveryTime.unit",
      "mappedKey":"deliveryTime.unit"
   },
   {
      "key":"deliveryTime.translations",
      "mappedKey":"deliveryTime.translations"
   },
   {
      "key":"deliveryTime.createdAt",
      "mappedKey":"deliveryTime.createdAt"
   },
   {
      "key":"deliveryTime.updated",
      "mappedKey":"deliveryTime.updated"
   },
   {
      "key":"ean",
      "mappedKey":"ean"
   },
   {
      "key":"height",
      "mappedKey":"height"
   },
   {
      "key":"Id",
      "mappedKey":"Id"
   },
   {
      "key":"product",
      "mappedKey":"product"
   },
   {
      "key":"isCloseout",
      "mappedKey":"isCloseout"
   },
   {
      "key":"length",
      "mappedKey":"length"
   },
   {
      "key":"listingPrices",
      "mappedKey":"listingPrices"
   },
   {
      "key":"manufacturer.id",
      "mappedKey":"manufacturer.id"
   },
   {
      "key":"manufacturer.versionId",
      "mappedKey":"manufacturer.versionId"
   },
   {
      "key":"manufacturer.link",
      "mappedKey":"manufacturer.link"
   },
   {
      "key":"manufacturer.name",
      "mappedKey":"manufacturer.name"
   },
   {
      "key":"manufacturer.description",
      "mappedKey":"manufacturer.description"
   },
   {
      "key":"manufacturer.customFields",
      "mappedKey":"manufacturer.customFields"
   },
   {
      "key":"manufacturer.media.Id",
      "mappedKey":"manufacturer.media.Id"
   },
   {
      "key":"manufacturer.translations",
      "mappedKey":"manufacturer.translations"
   },
   {
      "key":"manufacturer.createdAt",
      "mappedKey":"manufacturer.createdAt"
   },
   {
      "key":"manufacturer.updatedAt",
      "mappedKey":"manufacturer.updatedAt"
   },
   {
      "key":"manufacturerNumber",
      "mappedKey":"manufacturerNumber"
   },
   {
      "key":"markAsTopseller",
      "mappedKey":"markAsTopseller"
   },
   {
      "key":"maxPurchase",
      "mappedKey":"maxPurchase"
   },
   {
      "key":"minPurchase",
      "mappedKey":"minPurchase"
   },
   {
      "key":"optionIds",
      "mappedKey":"optionIds"
   },
   {
      "key":"options",
      "mappedKey":"options"
   },
   {
      "key":"parent",
      "mappedKey":"parent"
   },
   {
      "key":"price.DEFAULT.net",
      "mappedKey":"price.DEFAULT.net"
   },
   {
      "key":"price.DEFAULT.gross",
      "mappedKey":"price.DEFAULT.gross"
   },
   {
      "key":"price.DEFAULT.currencyId",
      "mappedKey":"price.DEFAULT.currencyId"
   },
   {
      "key":"price.DEFAULT.linked",
      "mappedKey":"price.DEFAULT.linked"
   },
   {
      "key":"price.DEFAULT.listPrice",
      "mappedKey":"price.DEFAULT.listPrice"
   },
   {
      "key":"productNumber",
      "mappedKey":"productNumber"
   },
   {
      "key":"properties",
      "mappedKey":"properties"
   },
   {
      "key":"purchasePrice",
      "mappedKey":"purchasePrice"
   },
   {
      "key":"purchaseSteps",
      "mappedKey":"purchaseSteps"
   },
   {
      "key":"purchaseUnit",
      "mappedKey":"purchaseUnit"
   },
   {
      "key":"ratingAvarage",
      "mappedKey":"ratingAvarage"
   },
   {
      "key":"referenceUnit",
      "mappedKey":"referenceUnit"
   },
   {
      "key":"releaseDate",
      "mappedKey":"releaseDate"
   },
   {
      "key":"restockTime",
      "mappedKey":"restockTime"
   },
   {
      "key":"shippingFree",
      "mappedKey":"shippingFree"
   },
   {
      "key":"stock",
      "mappedKey":"stock"
   },
   {
      "key":"tagIds",
      "mappedKey":"tagIds"
   },
   {
      "key":"tags",
      "mappedKey":"tags"
   },
   {
      "key":"tax.Id",
      "mappedKey":"tax.Id"
   },
   {
      "key":"tax.taxRate",
      "mappedKey":"tax.taxRate"
   },
   {
      "key":"tax.name",
      "mappedKey":"tax.name"
   },
   {
      "key":"tax.customField",
      "mappedKey":"tax.customField"
   },
   {
      "key":"tax.createdAt",
      "mappedKey":"tax.createdAt"
   },
   {
      "key":"tax.updatedAT",
      "mappedKey":"tax.updatedAT"
   },
   {
      "key":"translations.DEFAULT",
      "mappedKey":"translations.DEFAULT"
   },
   {
      "key":"translations.de_DE.name",
      "mappedKey":"translations.de_DE.name"
   },
   {
      "key":"translations.de_DE.customFields",
      "mappedKey":"translations.de_DE.customFields"
   },
   {
      "key":"translations.en_GB.metaTitle",
      "mappedKey":"translations.en_GB.metaTitle"
   },
   {
      "key":"unit.Id",
      "mappedKey":"unit.Id"
   },
   {
      "key":"unit.shortCode",
      "mappedKey":"unit.shortCode"
   },
   {
      "key":"unit.name",
      "mappedKey":"unit.name"
   },
   {
      "key":"unit.customFields",
      "mappedKey":"unit.customFields"
   },
   {
      "key":"unit.translations",
      "mappedKey":"unit.translations"
   },
   {
      "key":"unit.createdAt",
      "mappedKey":"unit.createdAt"
   },
   {
      "key":"unit.updatedAt",
      "mappedKey":"unit.updatedAt"
   },
   {
      "key":"variantRestrictions",
      "mappedKey":"variantRestrictions"
   },
   {
      "key":"versionId",
      "mappedKey":"versionId"
   },
   {
      "key":"visibilities.all",
      "mappedKey":"visibilities.all"
   },
   {
      "key":"visibilities.link",
      "mappedKey":"visibilities.link"
   },
   {
      "key":"visibilities.search",
      "mappedKey":"visibilities.search"
   },
   {
      "key":"weight",
      "mappedKey":"weight"
   },
   {
      "key":"width",
      "mappedKey":"width"
   }
  ]', 
  NOW(), 
  NOW(), 
  NULL
);