This project aimed to migrate an e-commerce solution from TYPO3 to Shopware and integrate Filemaker as an ERP for managing product data and categories. Filemaker acts as the central data source (master) for all product information. The migration included the development of a robust import process that prepares the data from Filemaker and imports it into Shopware. In addition, two Shopware subshops were configured to enable currency-based product displays (Euro/CHF), delivery conditions and flexible payment processing via Postfinance. An initial migration of all customer data and newsletter subscribers ensured a smooth transition and the seamless continuation of marketing activities.
Functionalities in detail
- Filemaker as master data source for products and categories:
- Filemaker serves as an ERP and centralizes the management of all product and category data. The product information and categories are transferred from Filemaker to Shopware.
- This centralized data management simplifies maintenance and ensures that up-to-date product information is always available in Shopware.
- Development of Filemaker import scripts for Shopware:
- Import scripts were developed to export the Filemaker data in a format suitable for Shopware and to ensure data quality:
- Filter criteria: Only complete products are included in the export to ensure data consistency in the store.
- File preparation for Shopware: The data is prepared in such a way that the standard Shopware import module can be used, whereby the standard Shopware structures are retained.
- Error protection: Mechanisms have been implemented that recognize incorrect Filemaker exports and interrupt the import process if problems occur.
- Image transformation and import: Images are prepared and optimized for Shopware to ensure a uniform product presentation.
- Import scripts were developed to export the Filemaker data in a format suitable for Shopware and to ensure data quality:
- Configuration of Shopware subshops for currency-based product display:
- Two subshops have been set up in Shopware to display products in Euro and CHF and set prices according to the target currency.
- The subshop is changed automatically based on the target delivery address and the shopping cart remains consistent for the user.
- Initial migration of customer data and newsletter subscribers:
- All existing customer and newsletter data was migrated to the new Shopware system to ensure a seamless transition.
- This migration ensures that customers can use their existing accounts and retain their newsletter communication preferences.
- Integration of Postfinance as a payment interface:
- The Shopware instance was connected to Postfinance as a payment solution to provide a secure and convenient payment option for customers.
- The Postfinance connection covers all common payment methods and offers standardized payment processing for the two currency subshops.