{
    "table": "products",
    "primary_key": "product_id",
    "filename": "products_gofrugal",
    "format": "gofrugal_csv",
    "field_mappings": {
      "Code": "barcode",
      "Name": "name", 
      "Description": "description",
      "Retail": "price",
      "Qty": "quantity",
      "COG": "cost_price"
    },
    "category_detection": {
      "enabled": true,
      "category_row_pattern": "^,Category :,,,,([^,]+),",
      "product_start_pattern": "^,[^,]+,",
      "skip_empty_rows": true,
      "skip_header_rows": 10
    },
    "default_values": {
      "tax_rates": {"vat": "G", "stt": ""},
      "base_unit": "PIECE",
      "isDeleted": false
    },
    "transforms": {
      "price": {
        "type": "number",
        "decimals": 2,
        "default": 0.00
      },
      "quantity": {
        "type": "number", 
        "decimals": 0,
        "default": 0
      },
      "cost_price": {
        "type": "number",
        "decimals": 2,
        "default": 0.00
      },
      "barcode": {
        "type": "string",
        "trim": true,
        "required": true
      },
      "name": {
        "type": "string",
        "trim": true,
        "required": true,
        "max_length": 255
      }
    },
    "validations": {
      "name": {
        "required": true,
        "max_length": 255
      },
      "barcode": {
        "required": true,
        "max_length": 100
      },
      "price": {
        "required": false,
        "min": 0
      }
    },
    "unique_fields": ["barcode"],
    "update_existing": true,
    "filters": {
      "isDeleted": false
    },
    "import_options": {
      "create_categories": true,
      "skip_zero_qty": false,
      "auto_assign_org": true
    }
  }