Products: descriptions, barcodes and units — Free
Choose a manufacturer; search product/part/barcode references and inspect recorded units and tracking settings.
DOCUMENTARY AND SYNTHETIC VALIDATION ONLY — not tested on a real Sage 200 installation. For sales, purchasing, warehouse teams and managers: choose a manufacturer or All, search product names, codes, descriptions, part numbers and recorded barcodes, then open the same product for its full description, recorded units, multiplier and tracking settings.
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 authorised source and your Cifru plan.
Free: one source, one native table/list and 11 useful same-row Details fields. No custom SQL, joins, related lists, widgets, calculated fields or scheduled refresh. Other workspace resources still count towards your plan. Reads are bounded to 2,000 rows; reaching that limit does not certify the complete catalogue. Search and local filters cover loaded rows only. Manufacturer selection is not access control or a promise of inexpensive source reads.
Current product master, not warehouse stock, availability, prices, accounting valuation, historical invoice units or a replenishment report. Stock/base unit names and the stock-to-base multiplier are shown exactly as recorded, without conversion arithmetic, currency assumptions or invented units. The multiplier is text to preserve source precision. The two status/tracking fields remain native codes, with the selected 2015 legend in their labels: status 0 active / 1 inactive; traceability 0 non-traceable / 1 serial / 2 batch. Unknown/NULL values are not silently marked active or non-traceable. These are settings, not serial/batch records or permission indicators. Blank names, manufacturers, descriptions and references remain blank. Internal ItemID is hidden and used for row identity; product codes are not assumed unique.
UNOFFICIAL, not affiliated with Sage. Physical identifiers come from the partial Sage 200 2015 database guide (November 2014), pages 48/51, with status/traceability legends on 113/128. Not full DDL or a current-version guarantee; not Sage 200 Standard, Evolution, Sage 300 or an API package. Verify the installed edition, dbo schema, all fields/types, key uniqueness, mappings, scope, permissions and bounded response times before importing. Direct SQL does not inherit Sage application permissions. Configure your own authorised least-privilege read-only company source and validated TLS. No server address, credential or business row is packaged. Gallery images are native Cifru with wholly fictional DEMO rows, not real installation evidence.
Primary physical reference: https://desktophelp.sage.co.uk/sage200/PDF/2015/Understanding%20the%20Sage%20200%202015%20Database.pdf
Functional context, not SQL schema proof: https://desktophelp.sage.co.uk/sage200/professional/Content/SC/StockItemDetails.htm
Gallery coverage: Three representative images show the native manufacturer opening filter, complete selected Protective gloves card and all eleven same-product Details fields. No related lists are configured or omitted. Other list/Home viewports and raw footage remain private; these are not every product or a real SQL Server/ERP installation certificate, subscription entitlement test or approval of the moving footage.
Screenshots
What this package creates
- Home: Product catalogue
Sources are mapped locally and verified before applying.
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "Sage 200 Professional UK — SQL Server company database",
"id": "20C007E4-55F4-52DC-917E-53FE342E1037",
"kind": "sqlServer",
"requiredObjects": [
"dbo.StockItem"
],
"requiresCustomSQL": false
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "F5704292-0D46-53B6-A7FA-C8450E931C6B",
"key": "Name",
"type": "text"
},
{
"direction": "ascending",
"id": "DB51B737-EE54-59A9-8B7C-92C7AC38DB4E",
"key": "ItemID",
"type": "text"
}
],
"id": "78C2B801-56E9-5426-B258-50CE764D4F2A",
"mappings": [
{
"commonFieldKey": "",
"key": "ItemID",
"label": "Internal product key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ItemID",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Code",
"label": "Product code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Code",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Name",
"label": "Product name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Name",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Description",
"label": "Product description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Description",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Manufacturer",
"label": "Manufacturer",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Manufacturer",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PartNumber",
"label": "Manufacturer part number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PartNumber",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "StockUnitName",
"label": "Stock unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "StockUnitName",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "BaseUnitName",
"label": "Base unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BaseUnitName",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "StockMultOfBaseUnit",
"label": "Recorded stock-to-base multiplier",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "StockMultOfBaseUnit",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Barcode",
"label": "Recorded barcode",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Barcode",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "StockItemStatusID",
"label": "Stock status (0 active, 1 inactive)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "StockItemStatusID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TraceableTypeID",
"label": "Traceability (0 none, 1 serial, 2 batch)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TraceableTypeID",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Product catalogue",
"primaryKey": "ItemID",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"Code",
"Name",
"Description",
"Manufacturer",
"PartNumber",
"StockUnitName",
"BaseUnitName",
"StockMultOfBaseUnit",
"Barcode",
"StockItemStatusID",
"TraceableTypeID"
],
"sourceID": "20C007E4-55F4-52DC-917E-53FE342E1037",
"sqlQuery": "",
"tableName": "dbo.StockItem"
}
],
"pages": [
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Manufacturer",
"label": "Manufacturer",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PartNumber",
"label": "Manufacturer part number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "StockUnitName",
"label": "Stock unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "BaseUnitName",
"label": "Base unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Barcode",
"label": "Recorded barcode",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "78C2B801-56E9-5426-B258-50CE764D4F2A",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Product identity",
"detailRole": "information",
"isVisible": true,
"key": "Name",
"label": "Product name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Product identity",
"detailRole": "information",
"isVisible": true,
"key": "Code",
"label": "Product code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Product identity",
"detailRole": "information",
"isVisible": true,
"key": "Description",
"label": "Product description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Product identity",
"detailRole": "information",
"isVisible": true,
"key": "Manufacturer",
"label": "Manufacturer",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Product identity",
"detailRole": "information",
"isVisible": true,
"key": "PartNumber",
"label": "Manufacturer part number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Product identity",
"detailRole": "information",
"isVisible": true,
"key": "Barcode",
"label": "Recorded barcode",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded units and tracking settings",
"detailRole": "information",
"isVisible": true,
"key": "StockUnitName",
"label": "Stock unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded units and tracking settings",
"detailRole": "information",
"isVisible": true,
"key": "BaseUnitName",
"label": "Base unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded units and tracking settings",
"detailRole": "information",
"isVisible": true,
"key": "StockMultOfBaseUnit",
"label": "Recorded stock-to-base multiplier",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded units and tracking settings",
"detailRole": "information",
"isVisible": true,
"key": "StockItemStatusID",
"label": "Stock status (0 active, 1 inactive)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded units and tracking settings",
"detailRole": "information",
"isVisible": true,
"key": "TraceableTypeID",
"label": "Traceability (0 none, 1 serial, 2 batch)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "42A45777-8965-51A1-9114-4968F0051CE8",
"openFilters": [
{
"id": "D46CAF30-51AB-5E93-A9AD-697B8896D3DD",
"includeAllOption": true,
"key": "Manufacturer",
"title": "Manufacturer",
"type": "text"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "ascending",
"id": "F5704292-0D46-53B6-A7FA-C8450E931C6B",
"key": "Name",
"type": "text"
},
{
"direction": "ascending",
"id": "DB51B737-EE54-59A9-8B7C-92C7AC38DB4E",
"key": "ItemID",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "Code",
"systemImage": "shippingbox",
"title": "Product catalogue",
"titleKey": "Name"
}
],
"relations": [],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "Sage 200 Professional UK",
"configurationLanguages": [
"en"
],
"countries": [
"GB"
],
"createdAt": "2026-10-10T00:00:00Z",
"description": "DOCUMENTARY AND SYNTHETIC VALIDATION ONLY — not tested on a real Sage 200 installation. For sales, purchasing, warehouse teams and managers: choose a manufacturer or All, search product names, codes, descriptions, part numbers and recorded barcodes, then open the same product for its full description, recorded units, multiplier and tracking settings.\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 authorised source and your Cifru plan.\n\nFree: one source, one native table/list and 11 useful same-row Details fields. No custom SQL, joins, related lists, widgets, calculated fields or scheduled refresh. Other workspace resources still count towards your plan. Reads are bounded to 2,000 rows; reaching that limit does not certify the complete catalogue. Search and local filters cover loaded rows only. Manufacturer selection is not access control or a promise of inexpensive source reads.\n\nCurrent product master, not warehouse stock, availability, prices, accounting valuation, historical invoice units or a replenishment report. Stock/base unit names and the stock-to-base multiplier are shown exactly as recorded, without conversion arithmetic, currency assumptions or invented units. The multiplier is text to preserve source precision. The two status/tracking fields remain native codes, with the selected 2015 legend in their labels: status 0 active / 1 inactive; traceability 0 non-traceable / 1 serial / 2 batch. Unknown/NULL values are not silently marked active or non-traceable. These are settings, not serial/batch records or permission indicators. Blank names, manufacturers, descriptions and references remain blank. Internal ItemID is hidden and used for row identity; product codes are not assumed unique.\n\nUNOFFICIAL, not affiliated with Sage. Physical identifiers come from the partial Sage 200 2015 database guide (November 2014), pages 48/51, with status/traceability legends on 113/128. Not full DDL or a current-version guarantee; not Sage 200 Standard, Evolution, Sage 300 or an API package. Verify the installed edition, dbo schema, all fields/types, key uniqueness, mappings, scope, permissions and bounded response times before importing. Direct SQL does not inherit Sage application permissions. Configure your own authorised least-privilege read-only company source and validated TLS. No server address, credential or business row is packaged. Gallery images are native Cifru with wholly fictional DEMO rows, not real installation evidence.\n\nPrimary physical reference: https://desktophelp.sage.co.uk/sage200/PDF/2015/Understanding%20the%20Sage%20200%202015%20Database.pdf\nFunctional context, not SQL schema proof: https://desktophelp.sage.co.uk/sage200/professional/Content/SC/StockItemDetails.htm\n\nGallery coverage: Three representative images show the native manufacturer opening filter, complete selected Protective gloves card and all eleven same-product Details fields. No related lists are configured or omitted. Other list/Home viewports and raw footage remain private; these are not every product or a real SQL Server/ERP installation certificate, subscription entitlement test or approval of the moving footage.",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "free",
"packageID": "7E9B9A44-91CC-5883-A2BB-178DEEDAB522",
"rootButtonCount": 1,
"summary": "Choose a manufacturer; search product/part/barcode references and inspect recorded units and tracking settings.",
"tags": [
"Sage 200 Professional UK",
"SQL Server",
"Products",
"Barcodes",
"Catalogue",
"Free"
],
"title": "Products: descriptions, barcodes and units — Free"
}
}