🔗 Mapping Settings

This section allows administrators to map feed data to platform categories and attributes. Proper mapping ensures that imported products are correctly categorized and displayed with relevant filters.

Feed Overview

  • Each feed listed here includes:
    • Feed Name: Custom label for the feed (e.g., Mohito, Tefal).
    • Feed Source: Affiliate network or merchant domain (e.g., dognet.com, cj.com).
    • Feed Type: Format of the feed file (CSV, XML, TXT (with csv format)).
    • Columns Mapping: Number of mapped columns (e.g., title, price, image).
    • Category Mapping: Number of mapped categories.
  • Use the Map Columns and Map Categories buttons to configure each feed.

Column Mapping

  • Click Map Columns to assign feed columns to platform fields.
  • Typical fields include:
    • Product Title
    • Price
    • Image URL
    • Product URL
    • Brand
    • Availability
    • Attributes (e.g., color, size)
  • Required Fields: These must be mapped for the import to succeed:
    • Product ID *
    • Product Name *
    • Price *
    • Product Affiliate URL *
    • Category *
  • Affiliate-Specific Mapping Tips:
    • For networks like cj.com: map sale_price to Sale price and price to Price because sale_price < price.
    • For networks like 2performant.com or tradedoubler.com: map old_price (previous_price) to Old price and price to Price because price < old_price.
    • For feeds with image_link and additional_image_link (e.g., cj.com, Google Shopping): map both at Product Image and Additional Images (if images exist in feed file).
    • For feeds with multiple image URLs in one column (e.g., 2performant.com): map only image_link to Product Image—if multiple images exist the system will split them by comma and insert them in database.
  • Attributes: Any extra columns (e.g., color, size, shipping, campaign name) can be mapped as Attributes. These are optional and can be enabled/disabled in Display Settings.
  • Note: Mapping too many attributes may increase database size and affect performance.
  • Unmapped columns will be ignored during import.

Category Mapping

  • Click Map Categories to link feed categories to your platform’s categories.
  • Each feed category must be matched to an existing platform category (e.g., Women → Dresses).
  • If a feed category is not mapped, products under it will not appear on the site.
  • You can map multiple feed categories to the same platform category.

Best Practices

  • Always complete both column and category mappings before importing a feed.
  • Use consistent naming across feeds to simplify mapping.
  • Review mappings periodically to ensure accuracy as feeds evolve.
  • Test mappings with a manual import before enabling automatic imports.