Produse: stoc & vanzari (MariaDB)
Produse cu denumire, SKU/EAN, stoc, pret, total vandute si rating - join curat wpfl_posts + wpfl_wc_product_meta_lookup. Read-only.
Produse WooCommerce citite CURAT: denumirea din wpfl_posts legata de stoc/pret/vanzari/rating din wpfl_wc_product_meta_lookup (nu din wpfl_postmeta risipit). Doar produse publicate. Sortate dupa total vandute; filtreaza dupa starea stocului. Necesita Pro (SQL personalizat, doar SELECT).
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: Produse: stoc & vanzari
Sources are mapped locally and verified before applying.
Custom queriesPRO1 SQL
Custom queries are a PRO feature. Cifru repeats read-only validation against the local source before execution.
Statically verified read-only
$.components.workspaceSelection.datasets.0.sqlQuerySELECT
p.ID AS product_id,
p.post_title AS name,
l.sku,
l.stock_status,
l.stock_quantity,
l.min_price AS price,
l.max_price,
l.total_sales,
l.average_rating,
l.rating_count,
p.post_date AS date_created
FROM wpfl_posts p
JOIN wpfl_wc_product_meta_lookup l ON l.product_id = p.ID
WHERE p.post_type = 'product' AND p.post_status = 'publish'static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "WooCommerce MariaDB (WordPress)",
"id": "49444348-ADA8-5533-93D4-BE1357A7EEFF",
"kind": "mariaDB",
"requiredObjects": [
"wpfl_posts",
"wpfl_wc_product_meta_lookup"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "WooCommerce",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "DB72FDB9-19FA-53C0-97DF-D7C8A92AA919",
"key": "total_sales",
"type": "number"
}
],
"id": "D4301733-6003-5B38-940A-F377A7A433B4",
"mappings": [
{
"commonFieldKey": "",
"key": "product_id",
"label": "ID produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "product_id",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "product_name",
"key": "name",
"label": "Produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "name",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "product_code",
"key": "sku",
"label": "SKU / EAN",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "sku",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "stock_status",
"label": "Stare stoc",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "stock_status",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "quantity",
"key": "stock_quantity",
"label": "Stoc",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "stock_quantity",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "amount",
"key": "price",
"label": "Pret",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "price",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "max_price",
"label": "Pret maxim",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "max_price",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "total_sales",
"label": "Total vandute",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "total_sales",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "average_rating",
"label": "Rating mediu",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "average_rating",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "rating_count",
"label": "Nr. evaluari",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "rating_count",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "date_created",
"label": "Adaugat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "date_created",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 12000,
"name": "Produse: stoc & vanzari",
"primaryKey": "product_id",
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 30
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"name",
"sku"
],
"sourceID": "49444348-ADA8-5533-93D4-BE1357A7EEFF",
"sqlQuery": "SELECT\n p.ID AS product_id,\n p.post_title AS name,\n l.sku,\n l.stock_status,\n l.stock_quantity,\n l.min_price AS price,\n l.max_price,\n l.total_sales,\n l.average_rating,\n l.rating_count,\n p.post_date AS date_created\nFROM wpfl_posts p\nJOIN wpfl_wc_product_meta_lookup l ON l.product_id = p.ID\nWHERE p.post_type = 'product' AND p.post_status = 'publish'",
"tableName": ""
}
],
"pages": [
{
"actions": [],
"badgeKey": "stock_quantity",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "name",
"label": "Produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "sku",
"label": "SKU / EAN",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "stock_quantity",
"label": "Stoc",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "price",
"label": "Pret",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "total_sales",
"label": "Total vandute",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "D4301733-6003-5B38-940A-F377A7A433B4",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "product_id",
"label": "ID produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "name",
"label": "Produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "sku",
"label": "SKU / EAN",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "stock_status",
"label": "Stare stoc",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "highlight",
"isVisible": true,
"key": "stock_quantity",
"label": "Stoc",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "price",
"label": "Pret",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "max_price",
"label": "Pret maxim",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "highlight",
"isVisible": true,
"key": "total_sales",
"label": "Total vandute",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "average_rating",
"label": "Rating mediu",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "rating_count",
"label": "Nr. evaluari",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "date_created",
"label": "Adaugat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "A11C3B08-8C5E-5135-8017-920DDBA86A44",
"openFilters": [
{
"id": "8D0E4BC5-9951-548C-A9DB-8464FBEC7B38",
"includeAllOption": true,
"key": "stock_status",
"title": "Stare stoc",
"type": "text"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": true,
"sortRules": [
{
"direction": "descending",
"id": "DB72FDB9-19FA-53C0-97DF-D7C8A92AA919",
"key": "total_sales",
"type": "number"
}
],
"subtitle": "",
"subtitleKey": "sku",
"systemImage": "shippingbox",
"title": "Produse: stoc & vanzari",
"titleKey": "name"
}
],
"relations": [],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "WooCommerce",
"configurationLanguages": [
"ro"
],
"countries": [
"RO"
],
"createdAt": "2026-08-21T17:16:51Z",
"description": "Produse WooCommerce citite CURAT: denumirea din wpfl_posts legata de stoc/pret/vanzari/rating din wpfl_wc_product_meta_lookup (nu din wpfl_postmeta risipit). Doar produse publicate. Sortate dupa total vandute; filtreaza dupa starea stocului. Necesita Pro (SQL personalizat, doar SELECT).\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": "pro",
"packageID": "1EBE68C8-6F5E-5BC3-AE1D-C1BEF2E588EC",
"rootButtonCount": 1,
"summary": "Produse cu denumire, SKU/EAN, stoc, pret, total vandute si rating - join curat wpfl_posts + wpfl_wc_product_meta_lookup. Read-only.",
"tags": [
"WooCommerce",
"MariaDB",
"produse",
"stoc",
"vanzari"
],
"title": "Produse: stoc & vanzari (MariaDB)"
}
}