Clienti (MariaDB)
Clienti din wpfl_wc_customer_lookup: email, nume, oras, judet, tara, inregistrare, ultima activitate. Read-only, fara SQL.
Clienti WooCommerce cititi CURAT din wpfl_wc_customer_lookup: email, nume/prenume, utilizator, oras, judet, tara, cod postal, data inregistrarii si ultima activitate. Cauta dupa email/nume/oras.
Pregatire MariaDB (baza WordPress/WooCommerce): cont MySQL/MariaDB read-only cu SELECT pe tabelele necesare, acces securizat (VPN, port 3306). PREFIX: tabelele folosesc prefixul WordPress; aici este 'wpfl_' (max-srl.ro). Daca magazinul tau are alt prefix (ex. wp_), redenumeste tabelele la mapare in Cifru. Tabelele wc_* de analiza exista din WooCommerce Analytics (WC 4.0+). In Cifru: Surse -> MariaDB (host, port, baza, user) -> testeaza -> importa -> mapeaza. Testat live pe baza max-srl.ro.
What this package creates
1 Home0 Details1 lists1 sources to map
- Home: Clienti
Sources are mapped locally and verified before applying.
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "WooCommerce MariaDB (WordPress)",
"id": "F79A8585-B527-5910-9BE7-808B7A359FCA",
"kind": "mariaDB",
"requiredObjects": [
"wpfl_wc_customer_lookup"
],
"requiresCustomSQL": false
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "WooCommerce",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "AD26FB66-E47A-54ED-A50D-1CF35B05065D",
"key": "date_last_active",
"type": "date"
}
],
"id": "8E8532CE-452C-50B2-B11F-0460A0E64232",
"mappings": [
{
"commonFieldKey": "",
"key": "customer_id",
"label": "ID client",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "customer_id",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "customer_name",
"key": "email",
"label": "Email",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "email",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "first_name",
"label": "Prenume",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "first_name",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "last_name",
"label": "Nume",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "last_name",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "username",
"label": "Utilizator",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "username",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "city",
"label": "Oras",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "city",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "state",
"label": "Judet",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "state",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "country",
"label": "Tara",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "country",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "postcode",
"label": "Cod postal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "postcode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "date_registered",
"label": "Inregistrat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "date_registered",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "date_last_active",
"label": "Ultima activitate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "date_last_active",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 3000,
"name": "Clienti",
"primaryKey": "customer_id",
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"email",
"last_name",
"first_name",
"username",
"city"
],
"sourceID": "F79A8585-B527-5910-9BE7-808B7A359FCA",
"sqlQuery": "",
"tableName": "wpfl_wc_customer_lookup"
}
],
"pages": [
{
"actions": [],
"badgeKey": "country",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "email",
"label": "Email",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "last_name",
"label": "Nume",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "city",
"label": "Oras",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "country",
"label": "Tara",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "8E8532CE-452C-50B2-B11F-0460A0E64232",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "customer_id",
"label": "ID client",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "email",
"label": "Email",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "first_name",
"label": "Prenume",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "last_name",
"label": "Nume",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "username",
"label": "Utilizator",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "city",
"label": "Oras",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "state",
"label": "Judet",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "country",
"label": "Tara",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "postcode",
"label": "Cod postal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "date_registered",
"label": "Inregistrat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "date_last_active",
"label": "Ultima activitate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "47B07D9A-ACBB-5AEA-91C8-B3DB3951332C",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": true,
"sortRules": [
{
"direction": "descending",
"id": "AD26FB66-E47A-54ED-A50D-1CF35B05065D",
"key": "date_last_active",
"type": "date"
}
],
"subtitle": "",
"subtitleKey": "last_name",
"systemImage": "person.2",
"title": "Clienti",
"titleKey": "email"
}
],
"relations": [],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "WooCommerce",
"configurationLanguages": [
"ro"
],
"countries": [
"RO"
],
"createdAt": "2026-08-21T17:16:51Z",
"description": "Clienti WooCommerce cititi CURAT din wpfl_wc_customer_lookup: email, nume/prenume, utilizator, oras, judet, tara, cod postal, data inregistrarii si ultima activitate. Cauta dupa email/nume/oras.\n\nPregatire MariaDB (baza WordPress/WooCommerce): cont MySQL/MariaDB read-only cu SELECT pe tabelele necesare, acces securizat (VPN, port 3306). PREFIX: tabelele folosesc prefixul WordPress; aici este 'wpfl_' (max-srl.ro). Daca magazinul tau are alt prefix (ex. wp_), redenumeste tabelele la mapare in Cifru. Tabelele wc_* de analiza exista din WooCommerce Analytics (WC 4.0+). In Cifru: Surse -> MariaDB (host, port, baza, user) -> testeaza -> importa -> mapeaza. Testat live pe baza max-srl.ro.",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.0",
"minimumPlan": "free",
"packageID": "22B4CDBA-70CA-5775-8EE2-9E51B4AE3893",
"rootButtonCount": 1,
"summary": "Clienti din wpfl_wc_customer_lookup: email, nume, oras, judet, tara, inregistrare, ultima activitate. Read-only, fara SQL.",
"tags": [
"WooCommerce",
"MariaDB",
"clienti",
"analytics"
],
"title": "Clienti (MariaDB)"
}
}