1. Product catalog formatting for marketplaces
Challenge: Suppliers send product information with their own column names and structures, making it difficult to match the requirements of marketplaces or ERPs.
Magic Table Solution: You import one or several Excel/CSV files, choose your destination template (e.g., Amazon, Mirakl, Shopify), and Magic Table automatically maps the matching columns. You can manually adjust or rename fields to complete the structure.
Example: Align two supplier files (10,000 SKUs) to a Mirakl-ready template with columns such as sku, title, brand, price, and image_url.
Benefits:
-
- Create marketplace-ready catalogs quickly.
-
- Reduce human error from manual copy-paste.
-
- Standardize product structures without technical skills.
2. Product data cleaning and standardization
Challenge: Even within a single file, data labels and structures can vary — some suppliers use “Product Name” while others use “Title” or “Designation.”
Magic Table Solution: Magic Table lets you harmonize these column names and map them consistently to a predefined template. It’s a simple drag-and-match interface, perfect for non-technical users.
Example: Standardize three supplier files into a single consistent structure before uploading them into WooCommerce or your PIM.
Benefits:
-
- Consistent product field names across files.
-
- Easy integration with marketplace templates.
-
- Faster onboarding of new suppliers.
3. Exporting unified catalogs
Challenge: Consolidating supplier data into one structured catalog is time-consuming.
Magic Table Solution: Once mappings are complete, you can merge multiple source files into a single export that follows your chosen template.
Example: Combine 5 supplier files into one “Amazon Listing” template without manually editing columns.
Benefits:
-
- Unified structure across all suppliers.
-
- One-click export into your final marketplace format.
-
- No need for custom scripts or macros.