Product catalogue and pack details — Free
Search products, choose a brand, and inspect pack contents, lifecycle and shipping measurements.
UNOFFICIAL — NOT VALIDATED ON A REAL ERP INSTALLATION.
For sales, purchasing, warehouse teams and managers: search the authorized product catalogue, choose a brand on opening, compare product names and pack contents, and open a complete same-row dossier with lifecycle dates, product/shipping dimensions and stored sales controls.
Why Cifru? Adapt configurations to the way you work. Choose the fields, filters and details you need, and bring information to your phone that may not be available in your business software’s own mobile app. Available options depend on the data exposed by your authorized source and your Cifru plan.
FREE: one authorized SQL Server source, one native PRODUCT list and one Home with 33 same-row Details positions. No custom SQL, joins, related lists, widgets, calculations or periodic refresh. Existing workspace resources count toward plan limits. Each read is capped at 2,000 records; Search/local filters operate on loaded rows, not the entire database. Choose Brand or All on opening. This is a catalogue, not a stock, order or price report.
MEANING: Product reference is the native productId business reference, not a promised SKU or EAN barcode. Internal/public names are separate. Quantity in each piece and Pieces included describe pack contents (the official model gives six pieces of 12 units), not current stock, ordered quantity or availability. Weight and each dimension have their own raw source-unit code, never guessed kilograms/centimetres or conversions. Product and shipping measurements are distinct. Inventory message and inventory-required code are controls, not counted stock. Stored control codes remain raw, including unknown, empty and NULL values; no default Y/N meaning is invented. Taxable is not a tax rate or computed amount. Lifecycle dates remain source text; no timezone conversion or active/inactive inference. Zero and exact source precision are preserved without monetary rounding. Long HTML descriptions, image paths, audit dates/authors, unrelated technical IDs, amounts without currency and other-table prices/availability are deliberately outside this useful same-row model.
DOCUMENTATION: ordinary Product entity, primary key, explicit physical naming implementation and SQL Server field-type file are pinned together at Apache OFBiz 24.09.07 commit 42819e5ae1d5339d3a204ac06b43e69d46a9c0ae. This is stronger than a functional screen label, but it does not prove your installed DDL, custom fields/extensions, collation, constraints or edition compatibility. Apache documents SQL Server support; its shipped default is Derby, not SQL Server. This package is only for an actual SQL Server deployment, not Derby/H2/PostgreSQL or a similarly named derivative. No market ranking, current user count or absence of native mobile functionality is asserted.
SOURCE SCOPE: this adapter explicitly requires the EXISTING dbo.PRODUCT object. dbo is the official SQL Server example, not proof of your installed schema. Confirm the exact object, all 33 selected columns, unique/non-null PRODUCT_ID, SQL types and response time with the administrator; remap and retest if different. No objects, accounts, grants or vendor installation/example commands are created or run. Use the correct tenant database and source-enforced catalogue/company/store restrictions. PRODUCT has no invented company or warehouse filter. SQL does not inherit OFBiz application or role-limited permissions; an opening filter is not an ACL. A dedicated least-privilege SELECT login and validated TLS are administrator prerequisites. Do not use demo/admin credentials.
IMPORT: map to your own authorized source, run Cifru’s read/compatibility test and inspect the results before business use. The package contains no connection credentials, production rows or vendor demo records. Documentary and offline synthetic checks are not a real ERP/SQL Server/iOS or Free purchase test. The gallery below is the reviewed native fictional demonstration.
Primary schema and implementation: https://github.com/apache/ofbiz-framework/tree/42819e5ae1d5339d3a204ac06b43e69d46a9c0ae/applications/datamodel/entitydef ; https://github.com/apache/ofbiz-framework/blob/42819e5ae1d5339d3a204ac06b43e69d46a9c0ae/framework/entity/fieldtype/fieldtypemssql.xml ; https://ofbiz.apache.org/business-users.html
GALLERY: six original native Cifru screenshots show complete product cards and all 33 same-row fields in four complementary Details views. All values are wholly fictional DEMO; no connected OFBiz installation or real credentials were filmed. No field was removed or value retouched to fit. The opening selection was DEMO Horizon; three products were displayed. All/empty/unknown/NULL were checked only in adapted offline reference tests. Synthetic transport can render NULL as text in unselected rows, not a real SQL NULL-conversion test. Pro filming entitlement is not a Free purchase certification; the package requires Free resources. Original PNG/XML/input and silent RAW are retained privately. PNG approval does not approve the whole RAW for publication.
Screenshots
What this package creates
1 Home0 Details1 lists1 sources to map
- Home: Product catalogue
Sources are mapped locally and verified before applying.
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "Apache OFBiz — authorized SQL Server Product catalogue",
"id": "5BD20E08-283E-5223-8097-BF2496DD73EB",
"kind": "sqlServer",
"requiredObjects": [
"dbo.PRODUCT"
],
"requiresCustomSQL": false
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "D91F3596-4BE8-5B0B-9129-D93E911F3D8C",
"key": "PRODUCT_NAME",
"type": "text"
},
{
"direction": "ascending",
"id": "DAB755F7-7B21-5513-A219-0790B95CE35E",
"key": "PRODUCT_ID",
"type": "text"
}
],
"id": "9BEA3D48-EBC0-5BDA-96B3-E19FA047E830",
"mappings": [
{
"commonFieldKey": "",
"key": "PRODUCT_ID",
"label": "Product reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PRODUCT_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PRODUCT_NAME",
"label": "Product name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PRODUCT_NAME",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "INTERNAL_NAME",
"label": "Internal product name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "INTERNAL_NAME",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BRAND_NAME",
"label": "Brand",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "BRAND_NAME",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DESCRIPTION",
"label": "Description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DESCRIPTION",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "INTRODUCTION_DATE",
"label": "Introduction date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "INTRODUCTION_DATE",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "RELEASE_DATE",
"label": "Release date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "RELEASE_DATE",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SALES_DISCONTINUATION_DATE",
"label": "Sales discontinuation date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "SALES_DISCONTINUATION_DATE",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SUPPORT_DISCONTINUATION_DATE",
"label": "Support discontinuation date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "SUPPORT_DISCONTINUATION_DATE",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "INVENTORY_MESSAGE",
"label": "Inventory message — not stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "INVENTORY_MESSAGE",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "REQUIRE_INVENTORY",
"label": "Inventory required — code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "REQUIRE_INVENTORY",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "QUANTITY_INCLUDED",
"label": "Quantity in each piece",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "QUANTITY_INCLUDED",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "QUANTITY_UOM_ID",
"label": "Quantity unit code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "QUANTITY_UOM_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PIECES_INCLUDED",
"label": "Pieces included",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PIECES_INCLUDED",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PRODUCT_WEIGHT",
"label": "Product weight",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PRODUCT_WEIGHT",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SHIPPING_WEIGHT",
"label": "Shipping weight",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "SHIPPING_WEIGHT",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "WEIGHT_UOM_ID",
"label": "Weight unit code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "WEIGHT_UOM_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PRODUCT_HEIGHT",
"label": "Product height",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PRODUCT_HEIGHT",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SHIPPING_HEIGHT",
"label": "Shipping height",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "SHIPPING_HEIGHT",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "HEIGHT_UOM_ID",
"label": "Height unit code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "HEIGHT_UOM_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PRODUCT_WIDTH",
"label": "Product width",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PRODUCT_WIDTH",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SHIPPING_WIDTH",
"label": "Shipping width",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "SHIPPING_WIDTH",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "WIDTH_UOM_ID",
"label": "Width unit code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "WIDTH_UOM_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PRODUCT_DEPTH",
"label": "Product depth",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "PRODUCT_DEPTH",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SHIPPING_DEPTH",
"label": "Shipping depth",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "SHIPPING_DEPTH",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DEPTH_UOM_ID",
"label": "Depth unit code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "DEPTH_UOM_ID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "RETURNABLE",
"label": "Returnable — code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "RETURNABLE",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "TAXABLE",
"label": "Taxable — code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "TAXABLE",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CHARGE_SHIPPING",
"label": "Charge shipping — code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CHARGE_SHIPPING",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "INCLUDE_IN_PROMOTIONS",
"label": "Include in promotions — code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "INCLUDE_IN_PROMOTIONS",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "IS_VIRTUAL",
"label": "Virtual product — code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "IS_VIRTUAL",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "IS_VARIANT",
"label": "Variant product — code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "IS_VARIANT",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ORDER_DECIMAL_QUANTITY",
"label": "Decimal orders — code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ORDER_DECIMAL_QUANTITY",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Product catalogue",
"primaryKey": "PRODUCT_ID",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"PRODUCT_ID",
"PRODUCT_NAME",
"INTERNAL_NAME",
"BRAND_NAME",
"DESCRIPTION"
],
"sourceID": "5BD20E08-283E-5223-8097-BF2496DD73EB",
"sqlQuery": "",
"tableName": "dbo.PRODUCT"
}
],
"pages": [
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "BRAND_NAME",
"label": "Brand",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DESCRIPTION",
"label": "Description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PIECES_INCLUDED",
"label": "Pieces included",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "IS_VARIANT",
"label": "Variant product — code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "RETURNABLE",
"label": "Returnable — code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "9BEA3D48-EBC0-5BDA-96B3-E19FA047E830",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Product identity",
"detailRole": "information",
"isVisible": true,
"key": "PRODUCT_ID",
"label": "Product reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Product identity",
"detailRole": "information",
"isVisible": true,
"key": "PRODUCT_NAME",
"label": "Product name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Product identity",
"detailRole": "information",
"isVisible": true,
"key": "INTERNAL_NAME",
"label": "Internal product name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Product identity",
"detailRole": "information",
"isVisible": true,
"key": "BRAND_NAME",
"label": "Brand",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Product identity",
"detailRole": "information",
"isVisible": true,
"key": "DESCRIPTION",
"label": "Description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Lifecycle — source dates",
"detailRole": "information",
"isVisible": true,
"key": "INTRODUCTION_DATE",
"label": "Introduction date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Lifecycle — source dates",
"detailRole": "information",
"isVisible": true,
"key": "RELEASE_DATE",
"label": "Release date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Lifecycle — source dates",
"detailRole": "information",
"isVisible": true,
"key": "SALES_DISCONTINUATION_DATE",
"label": "Sales discontinuation date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Lifecycle — source dates",
"detailRole": "information",
"isVisible": true,
"key": "SUPPORT_DISCONTINUATION_DATE",
"label": "Support discontinuation date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Inventory controls — not stock",
"detailRole": "information",
"isVisible": true,
"key": "INVENTORY_MESSAGE",
"label": "Inventory message — not stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Inventory controls — not stock",
"detailRole": "information",
"isVisible": true,
"key": "REQUIRE_INVENTORY",
"label": "Inventory required — code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pack contents — not on-hand",
"detailRole": "information",
"isVisible": true,
"key": "QUANTITY_INCLUDED",
"label": "Quantity in each piece",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pack contents — not on-hand",
"detailRole": "information",
"isVisible": true,
"key": "QUANTITY_UOM_ID",
"label": "Quantity unit code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Pack contents — not on-hand",
"detailRole": "information",
"isVisible": true,
"key": "PIECES_INCLUDED",
"label": "Pieces included",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Weight and source unit",
"detailRole": "information",
"isVisible": true,
"key": "PRODUCT_WEIGHT",
"label": "Product weight",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Weight and source unit",
"detailRole": "information",
"isVisible": true,
"key": "SHIPPING_WEIGHT",
"label": "Shipping weight",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Weight and source unit",
"detailRole": "information",
"isVisible": true,
"key": "WEIGHT_UOM_ID",
"label": "Weight unit code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Height and source unit",
"detailRole": "information",
"isVisible": true,
"key": "PRODUCT_HEIGHT",
"label": "Product height",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Height and source unit",
"detailRole": "information",
"isVisible": true,
"key": "SHIPPING_HEIGHT",
"label": "Shipping height",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Height and source unit",
"detailRole": "information",
"isVisible": true,
"key": "HEIGHT_UOM_ID",
"label": "Height unit code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Width and source unit",
"detailRole": "information",
"isVisible": true,
"key": "PRODUCT_WIDTH",
"label": "Product width",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Width and source unit",
"detailRole": "information",
"isVisible": true,
"key": "SHIPPING_WIDTH",
"label": "Shipping width",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Width and source unit",
"detailRole": "information",
"isVisible": true,
"key": "WIDTH_UOM_ID",
"label": "Width unit code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Depth and source unit",
"detailRole": "information",
"isVisible": true,
"key": "PRODUCT_DEPTH",
"label": "Product depth",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Depth and source unit",
"detailRole": "information",
"isVisible": true,
"key": "SHIPPING_DEPTH",
"label": "Shipping depth",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Depth and source unit",
"detailRole": "information",
"isVisible": true,
"key": "DEPTH_UOM_ID",
"label": "Depth unit code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Stored sales controls",
"detailRole": "information",
"isVisible": true,
"key": "RETURNABLE",
"label": "Returnable — code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Stored sales controls",
"detailRole": "information",
"isVisible": true,
"key": "TAXABLE",
"label": "Taxable — code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Stored sales controls",
"detailRole": "information",
"isVisible": true,
"key": "CHARGE_SHIPPING",
"label": "Charge shipping — code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Stored sales controls",
"detailRole": "information",
"isVisible": true,
"key": "INCLUDE_IN_PROMOTIONS",
"label": "Include in promotions — code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Stored sales controls",
"detailRole": "information",
"isVisible": true,
"key": "IS_VIRTUAL",
"label": "Virtual product — code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Stored sales controls",
"detailRole": "information",
"isVisible": true,
"key": "IS_VARIANT",
"label": "Variant product — code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Stored sales controls",
"detailRole": "information",
"isVisible": true,
"key": "ORDER_DECIMAL_QUANTITY",
"label": "Decimal orders — code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "7807A733-2173-5326-87B9-C4E636FF6DA9",
"openFilters": [
{
"id": "69123872-0545-5E29-8E4B-9D3686B48F75",
"includeAllOption": true,
"key": "BRAND_NAME",
"title": "Brand",
"type": "text"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "ascending",
"id": "D91F3596-4BE8-5B0B-9129-D93E911F3D8C",
"key": "PRODUCT_NAME",
"type": "text"
},
{
"direction": "ascending",
"id": "DAB755F7-7B21-5513-A219-0790B95CE35E",
"key": "PRODUCT_ID",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "PRODUCT_ID",
"systemImage": "cube.box",
"title": "Product catalogue",
"titleKey": "PRODUCT_NAME"
}
],
"relations": [],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "Apache OFBiz",
"changelog": "First Free Product catalogue: 33 useful same-row fields and six native fictional DEMO screenshots. Not tested on a real OFBiz installation.",
"configurationLanguages": [
"en"
],
"countries": [
"US"
],
"createdAt": "2026-10-11T00:00:00Z",
"description": "UNOFFICIAL — NOT VALIDATED ON A REAL ERP INSTALLATION.\n\nFor sales, purchasing, warehouse teams and managers: search the authorized product catalogue, choose a brand on opening, compare product names and pack contents, and open a complete same-row dossier with lifecycle dates, product/shipping dimensions and stored sales controls.\n\nWhy Cifru? Adapt configurations to the way you work. Choose the fields, filters and details you need, and bring information to your phone that may not be available in your business software’s own mobile app. Available options depend on the data exposed by your authorized source and your Cifru plan.\n\nFREE: one authorized SQL Server source, one native PRODUCT list and one Home with 33 same-row Details positions. No custom SQL, joins, related lists, widgets, calculations or periodic refresh. Existing workspace resources count toward plan limits. Each read is capped at 2,000 records; Search/local filters operate on loaded rows, not the entire database. Choose Brand or All on opening. This is a catalogue, not a stock, order or price report.\n\nMEANING: Product reference is the native productId business reference, not a promised SKU or EAN barcode. Internal/public names are separate. Quantity in each piece and Pieces included describe pack contents (the official model gives six pieces of 12 units), not current stock, ordered quantity or availability. Weight and each dimension have their own raw source-unit code, never guessed kilograms/centimetres or conversions. Product and shipping measurements are distinct. Inventory message and inventory-required code are controls, not counted stock. Stored control codes remain raw, including unknown, empty and NULL values; no default Y/N meaning is invented. Taxable is not a tax rate or computed amount. Lifecycle dates remain source text; no timezone conversion or active/inactive inference. Zero and exact source precision are preserved without monetary rounding. Long HTML descriptions, image paths, audit dates/authors, unrelated technical IDs, amounts without currency and other-table prices/availability are deliberately outside this useful same-row model.\n\nDOCUMENTATION: ordinary Product entity, primary key, explicit physical naming implementation and SQL Server field-type file are pinned together at Apache OFBiz 24.09.07 commit 42819e5ae1d5339d3a204ac06b43e69d46a9c0ae. This is stronger than a functional screen label, but it does not prove your installed DDL, custom fields/extensions, collation, constraints or edition compatibility. Apache documents SQL Server support; its shipped default is Derby, not SQL Server. This package is only for an actual SQL Server deployment, not Derby/H2/PostgreSQL or a similarly named derivative. No market ranking, current user count or absence of native mobile functionality is asserted.\n\nSOURCE SCOPE: this adapter explicitly requires the EXISTING dbo.PRODUCT object. dbo is the official SQL Server example, not proof of your installed schema. Confirm the exact object, all 33 selected columns, unique/non-null PRODUCT_ID, SQL types and response time with the administrator; remap and retest if different. No objects, accounts, grants or vendor installation/example commands are created or run. Use the correct tenant database and source-enforced catalogue/company/store restrictions. PRODUCT has no invented company or warehouse filter. SQL does not inherit OFBiz application or role-limited permissions; an opening filter is not an ACL. A dedicated least-privilege SELECT login and validated TLS are administrator prerequisites. Do not use demo/admin credentials.\n\nIMPORT: map to your own authorized source, run Cifru’s read/compatibility test and inspect the results before business use. The package contains no connection credentials, production rows or vendor demo records. Documentary and offline synthetic checks are not a real ERP/SQL Server/iOS or Free purchase test. The gallery below is the reviewed native fictional demonstration.\n\nPrimary schema and implementation: https://github.com/apache/ofbiz-framework/tree/42819e5ae1d5339d3a204ac06b43e69d46a9c0ae/applications/datamodel/entitydef ; https://github.com/apache/ofbiz-framework/blob/42819e5ae1d5339d3a204ac06b43e69d46a9c0ae/framework/entity/fieldtype/fieldtypemssql.xml ; https://ofbiz.apache.org/business-users.html\n\nGALLERY: six original native Cifru screenshots show complete product cards and all 33 same-row fields in four complementary Details views. All values are wholly fictional DEMO; no connected OFBiz installation or real credentials were filmed. No field was removed or value retouched to fit. The opening selection was DEMO Horizon; three products were displayed. All/empty/unknown/NULL were checked only in adapted offline reference tests. Synthetic transport can render NULL as text in unselected rows, not a real SQL NULL-conversion test. Pro filming entitlement is not a Free purchase certification; the package requires Free resources. Original PNG/XML/input and silent RAW are retained privately. PNG approval does not approve the whole RAW for publication.",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "free",
"packageID": "723DFE37-BA6C-5DD0-8BE8-5C1CC05137AF",
"rootButtonCount": 1,
"summary": "Search products, choose a brand, and inspect pack contents, lifecycle and shipping measurements.",
"tags": [
"Apache OFBiz",
"SQL Server",
"Product catalogue",
"Purchasing",
"Sales",
"Logistics",
"Free"
],
"title": "Product catalogue and pack details — Free"
}
}