Notes on Migrating from versions of Shopware ERP older than 5.0.0¶

The Shopware ERP 5.0.0 release introduced a number of breaking changes across most services, entities and database tables. Because of this, custom integrations which were developed against older versions of Shopware ERP must be adapted to the new APIs.

Stock Management¶

The previous method of reading and writing stock has changed. Please see the chapter on Stock Management for details.

Renamed Services¶

Old name	New name
`viison_pickware_erp.bin_location_stock_change_factory`	`pickware.erp.stock_change_list_factory_service`
`viison_pickware_erp.order_document_creator`	`pickware.erp.order_document_creation_service`
`viison_pickware_erp.plugins.swag_import_export.profile_loader`	`pickware.erp.import_export_profile_loader_service`
`viison_pickware_erp.stock_entry_item_updater`	`pickware.erp.stock_item_updater_service`
`viison_pickware_erp.stock_initialization`	`pickware.erp.stock_initialization_service`
`viison_pickware_erp.stock_manager_factory`	removed, use `pickware.erp.stock_ledger_service` instead
`viison_pickware_erp.stock_reservation`	`pickware.erp.stock_reservation_service`
`viison_pickware_erp.stock_util`	removed
`viison_pickware_erp.supplier_number`	`pickware.erp.supplier_number_generator_service`
`viison_pickware_erp.warehouse_stock_limits`	removed

Renamed Tables¶

Old name	New name
`s_plugin_pickware_article_detail_property_types`	`pickware_erp_article_detail_item_properties`
`s_plugin_pickware_property_types`	`pickware_erp_item_properties`
`s_plugin_pickware_reshipment_attachments`	`pickware_erp_return_shipment_attachments`
`s_plugin_pickware_reshipment_items`	`pickware_erp_return_shipment_items`
`s_plugin_pickware_reshipment_status`	`pickware_erp_return_shipment_statuses`
`s_plugin_pickware_reshipments`	`pickware_erp_return_shipments`
`s_plugin_pickware_stock_entry_item_properties`	`pickware_erp_stock_item_property_values`
`s_plugin_pickware_stock_entry_items`	`pickware_erp_stock_items`
`s_plugin_pickware_stocks`	`pickware_erp_stock_ledger_entries`
`s_plugin_pickware_supplier_article_details`	`pickware_erp_article_detail_supplier_mappings`
`s_plugin_pickware_supplier_fabricators`	`pickware_erp_manufacturer_supplier_mappings`
`s_plugin_pickware_supplier_order_article_detail_states`	`pickware_erp_supplier_order_item_statuses`
`s_plugin_pickware_supplier_order_article_details`	`pickware_erp_supplier_order_items`
`s_plugin_pickware_supplier_order_attachments`	`pickware_erp_supplier_order_attachments`
`s_plugin_pickware_supplier_order_states`	`pickware_erp_supplier_order_statuses`
`s_plugin_pickware_supplier_orders`	`pickware_erp_supplier_orders`
`s_plugin_pickware_suppliers`	`pickware_erp_suppliers`
`s_plugin_pickware_warehouse_bin_location_article_details`	`pickware_erp_article_detail_bin_location_mappings`
`s_plugin_pickware_warehouse_bin_location_stock_snapshots`	`pickware_erp_bin_location_stock_snapshots`
`s_plugin_pickware_warehouse_bin_locations`	`pickware_erp_bin_locations`
`s_plugin_pickware_warehouse_reserved_stocks`	`pickware_erp_order_stock_reservations`
`s_plugin_pickware_warehouse_stocks`	`pickware_erp_warehouse_article_detail_stock_counts`
`s_plugin_pickware_warehouses`	`pickware_erp_warehouses`

Renamed Pickware Table Columns¶

Table	Old column name	New column name
`pickware_erp_article_detail_item_properties`	`propertyTypeId`	`itemPropertyId`
`pickware_erp_bin_location_stock_snapshots`	`stockEntryId`	`stockLedgerEntryId`
`pickware_erp_manufacturer_supplier_mappings`	`fabricatorId`	`manufacturerId`
`pickware_erp_order_stock_reservations`	`binLocationArticleDetailId`	`articleDetailBinLocationMappingId`
`pickware_erp_return_shipment_attachments`	`reshipmentId`	`returnShipmentId`
`pickware_erp_return_shipment_items`	`depreciatedQuantity` `reshipmentId`	`writtenOffQuantity` `returnShipmentId`
`pickware_erp_stock_item_property_values`	`propertyTypeId` `stockEntryItemId`	`itemPropertyId` `stockItemId`
`pickware_erp_stock_items`	`stockEntryId`	`stockLedgerEntryId`
`pickware_erp_stock_ledger_entries`	`newInstockQuantity` `oldInstockQuantity` `parentId` `reshipmentItemId`	`newStock` `oldStock` `sourceLotEntryId` `returnShipmentItemId`
`pickware_erp_supplier_order_attachments`	`orderId`	`supplierOrderId`
`pickware_erp_supplier_order_items`	`fabricatorName` `fabricatorNumber` `orderId` `status`	`manufacturerName` `manufacturerArticleNumber` `supplierOrderId` `statusId`
`pickware_erp_supplier_orders`	`status`	`statusId`
`pickware_erp_warehouses`	`stockAvailable`	`stockAvailableForSale`

Renamed Attribute Columns¶

Table Old attribute column name New attribute column name

s_articles_attributes

viison_incoming_stock

viison_not_relevant_for_stock_manager

viison_physical_stock_for_sale

viison_stock_initialized

viison_stock_initialization_time

pickware_incoming_stock

pickware_stock_management_disabled

pickware_physical_stock_for_sale

pickware_stock_initialized

pickware_stock_initialization_time

s_order_attributes viison_last_changed pickware_last_changed

s_order_details_attributes viison_canceled_quantity pickware_canceled_quantity