Comenzi & vanzari (MariaDB)
Comenzi din tabelul de analiza WooCommerce wpfl_wc_order_stats: data, status, produse vandute, total, net, TVA, transport, platita/finalizata. Read-only, fara SQL.
Comenzi WooCommerce citite CURAT din tabelul de analiza wpfl_wc_order_stats (nu din wpfl_posts/wpfl_postmeta): numar, data, status, nr. produse vandute, total, net, TVA, transport, cand a fost platita/finalizata si daca e client recurent. Filtreaza dupa status.
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: Comenzi (vanzari)
Sources are mapped locally and verified before applying.
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "WooCommerce MariaDB (WordPress)",
"id": "69AA783B-407A-514C-9620-FC35F4AE7F01",
"kind": "mariaDB",
"requiredObjects": [
"wpfl_wc_order_stats"
],
"requiresCustomSQL": false
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "WooCommerce",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "E1ECCB25-955A-573E-B00B-1C9D41A79741",
"key": "date_created",
"type": "date"
}
],
"id": "A4949692-35E7-519B-A102-54371787F77B",
"mappings": [
{
"commonFieldKey": "document_number",
"key": "order_id",
"label": "Comanda #",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "order_id",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "document_date",
"key": "date_created",
"label": "Data",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "date_created",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "status",
"label": "Status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "status",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "quantity",
"key": "num_items_sold",
"label": "Produse vandute",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "num_items_sold",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "amount",
"key": "total_sales",
"label": "Total",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "total_sales",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "net_total",
"label": "Net",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "net_total",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "tax_total",
"label": "TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "tax_total",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "shipping_total",
"label": "Transport",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "shipping_total",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "date_paid",
"label": "Platita la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "date_paid",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "date_completed",
"label": "Finalizata la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "date_completed",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "returning_customer",
"label": "Client recurent",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "returning_customer",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "customer_id",
"label": "ID client",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "customer_id",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 3000,
"name": "Comenzi (vanzari)",
"primaryKey": "order_id",
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 30
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"order_id",
"status",
"customer_id"
],
"sourceID": "69AA783B-407A-514C-9620-FC35F4AE7F01",
"sqlQuery": "",
"tableName": "wpfl_wc_order_stats"
}
],
"pages": [
{
"actions": [],
"badgeKey": "total_sales",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "order_id",
"label": "Comanda #",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "status",
"label": "Status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "num_items_sold",
"label": "Produse vandute",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "total_sales",
"label": "Total",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "date_created",
"label": "Data",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "A4949692-35E7-519B-A102-54371787F77B",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "order_id",
"label": "Comanda #",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "date_created",
"label": "Data",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "status",
"label": "Status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "highlight",
"isVisible": true,
"key": "num_items_sold",
"label": "Produse vandute",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "highlight",
"isVisible": true,
"key": "total_sales",
"label": "Total",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "net_total",
"label": "Net",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "tax_total",
"label": "TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "shipping_total",
"label": "Transport",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "date_paid",
"label": "Platita la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "date_completed",
"label": "Finalizata la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "returning_customer",
"label": "Client recurent",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "customer_id",
"label": "ID client",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "B5957D5B-11EC-5A87-A2DD-A656FA919218",
"openFilters": [
{
"id": "FC8DE56A-E37B-5004-8B4F-2BE468B95BF1",
"includeAllOption": true,
"key": "status",
"title": "Status",
"type": "text"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": true,
"sortRules": [
{
"direction": "descending",
"id": "E1ECCB25-955A-573E-B00B-1C9D41A79741",
"key": "date_created",
"type": "date"
}
],
"subtitle": "",
"subtitleKey": "status",
"systemImage": "cart",
"title": "Comenzi (vanzari)",
"titleKey": "order_id"
}
],
"relations": [],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "WooCommerce",
"configurationLanguages": [
"ro"
],
"countries": [
"RO"
],
"createdAt": "2026-08-21T17:16:51Z",
"description": "Comenzi WooCommerce citite CURAT din tabelul de analiza wpfl_wc_order_stats (nu din wpfl_posts/wpfl_postmeta): numar, data, status, nr. produse vandute, total, net, TVA, transport, cand a fost platita/finalizata si daca e client recurent. Filtreaza dupa status.\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": "F94F5DBF-04C4-5218-A6EE-D966DE310343",
"rootButtonCount": 1,
"summary": "Comenzi din tabelul de analiza WooCommerce wpfl_wc_order_stats: data, status, produse vandute, total, net, TVA, transport, platita/finalizata. Read-only, fara SQL.",
"tags": [
"WooCommerce",
"MariaDB",
"comenzi",
"vanzari",
"analytics"
],
"title": "Comenzi & vanzari (MariaDB)"
}
}