JTL Wawi to Kaufland.de Product Optimization & Sync

Full Product Listing, Sync & Optimization from JTL Wawi to Kaufland.de with Simple Manager Interface

Project Description:
We are looking for a freelancer to help us list and manage our entire product catalog (approx. 1600 products) from our JTL Wawi system to Kaufland.de, and to implement daily synchronization, image optimization, and basic marketing support.

This is not just a one-time upload, but an ongoing collaboration aimed at maintaining a high-quality presence on Kaufland.de and ensuring sales.

Products:
Around 1600 products including variants (e.g., recorders, cameras, accessories)

Product data can be exported from JTL Wawi in CSV format

Scope of Work:
1. Product Listing & Optimization
Map all JTL Wawi product fields to Kaufland.de required & optional fields

Fill missing information using official technical data sheets

Ensure no false or misleading product data

Optimize all listings for maximum search visibility and sales conversion (SEO, keyword-rich titles, etc.)

2. Image Checking and Correction
All images must be:

1000x1000 px, white background

High-quality and clear

If an image is missing or incorrect, it must be corrected and reuploaded

Ensure consistency across all product images

3. Daily Synchronization
Setup daily sync from JTL Wawi to Kaufland.de (via existing Schnittstelle/connector)

Sync product quantity, price, descriptions, and specs

Orders placed on Kaufland must automatically sync back to JTL Wawi for processing

4. Return Handling
Ensure return data from Kaufland is synchronized or processed correctly in JTL Wawi

Maintain visibility of return status and history

5. Review & Rating Integration (if technically possible)
Collect product reviews/ratings from Kaufland and display them internally

Use feedback to improve listings or flag issues

6. Marketing Tools
Support use of Kaufland marketing tools and analytics

Help with setting up paid promotions or keyword-based improvements

Suggest optimizations based on Kaufland.de internal tools and statistics

7. Dynamic Pricing (Optional but Preferred)
If possible, implement dynamic pricing rules based on competition on:

Kaufland

Google Shopping

Idealo.de

Pricing rules should be based on stock level, competitor price, and product margin

8. Basic Manager Interface (Google Sheets)
Create a simple interface using Google Sheets, which shows:

Product listing status (OK, failed, outdated)

Warnings (missing fields, missing image, no sales in 30+ days)

Colored highlighting (green/yellow/red) for easy tracking

Option to mark products for re-upload

Automate weekly reports:

Successful listings

Products with errors or missing data

Products with outdated prices or info

9. Internationalization
Prepare listings only for Germany and Austria (no other markets)

10. Security, Logging, and Backups
Maintain log files or changelogs of sync actions

If possible, ensure regular backups of product data and sync settings

Requirements:
Experience with Kaufland.de marketplace integration

Familiarity with JTL Wawi

CSV data processing

Image editing (Photoshop or similar)

Marketing/SEO knowledge (specifically for product listings)

Experience with Google Sheets scripting (Apps Script)

German language is a plus but not required

Deliverables:
All ~1600 products listed and live on Kaufland.de

Fully working daily sync (stock, prices, descriptions, orders)

Correct and standardized product images

Google Sheets interface for monitoring and managing listings

Weekly report generation

Optionally: dynamic pricing engine and/or review integration