{"docsConfig":{"theme":"mint","$schema":"https://mintlify.com/docs.json","name":"Stockful","colors":{"primary":"#E8552B","light":"#F1774F","dark":"#C4431F"},"logo":{"light":"https://mintcdn.com/ljsstudios/tBVtzZCERvi3LxkY/logo/docs-logo-light.png?fit=max\u0026auto=format\u0026n=tBVtzZCERvi3LxkY\u0026q=85\u0026s=78ae1213a2333bef6f0e7bfd4cc6c12c","dark":"https://mintcdn.com/ljsstudios/tBVtzZCERvi3LxkY/logo/docs-logo-dark.png?fit=max\u0026auto=format\u0026n=tBVtzZCERvi3LxkY\u0026q=85\u0026s=90644d686b246934bbe46ae133ad19b5"},"favicon":"https://mintcdn.com/ljsstudios/tBVtzZCERvi3LxkY/favicon.svg?fit=max\u0026auto=format\u0026n=tBVtzZCERvi3LxkY\u0026q=85\u0026s=70949a4c61a7c929910860d6be1fc8ef","navbar":{"links":[{"href":"/support","label":"Support"},{"href":"https://apps.shopify.com/stockful-inventory-management?utm_source=stockful-docs\u0026utm_medium=docs\u0026utm_content=header-install","label":"Install Stockful"}]},"footer":{"socials":{"website":"https://apps.shopify.com/stockful-inventory-management?utm_source=stockful-docs\u0026utm_medium=docs\u0026utm_content=footer-globe"},"links":[{"header":"Help","items":[{"label":"Contact Support","href":"/support"},{"label":"FAQs","href":"/user-guide/faqs"}]},{"header":"Policies","items":[{"label":"Privacy Policy","href":"/policies/privacy-policy"},{"label":"Terms of Service","href":"/policies/terms-of-service"},{"label":"Data Processing Agreement","href":"/policies/data-processing-agreement"},{"label":"Security Incident Response","href":"/policies/security-incident-response"}]}]},"search":{"prompt":"Search Stockful documentation"},"seo":{},"fonts":{"heading":{"family":"JetBrains Mono"},"body":{"family":"Inter"}},"contextual":{"options":["copy","view","chatgpt","claude"],"display":"header"},"styling":{"latex":false},"navigation":{"pages":[]}},"deployment":{"deploymentMetadataValue":{"subdomain":"ljsstudios","hasAudioNarration":false,"actualSubdomain":"ljsstudios","customDomains":["docs.stockful.app"],"gitSource":{"type":"github","owner":"lspoor","repo":"stockful","deployBranch":"main","contentDirectory":"documentation","isPrivate":true,"mountPath":"","label":""},"entitlements":{},"buildId":"6b000b6ecba301bc98787bed","clientVersion":"0.0.4270","searchFilterCounts":[{"language":"default","tag":"User Guide","count":78},{"language":"default","tag":"StockfulQL","count":39},{"language":"default","tag":"Datasets","count":24},{"language":"default","tag":"Purchasing","count":22},{"language":"default","tag":"Using Stockful","count":19},{"language":"default","tag":"Syntax","count":13},{"language":"default","tag":"Delivery channels","count":11},{"language":"default","tag":"Reports","count":11},{"language":"default","tag":"Alerts","count":9},{"language":"default","tag":"Storefront","count":8}]},"assistantConfig":{"enableAskAiButton":false,"enableStarterQuestions":false,"enableAskAiSearchBar":true},"basePath":"","hasChatPermissions":false,"hasWebMcpPermissions":false,"toggles":[{"name":"kill-isr","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-rbac-roles","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-mintlify-slack","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-integrations-settings","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"rbac-expansion","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-pr-grouping","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-prefix","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"analytics-v7","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"user-flows-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"no-publish-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-onboarding","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving-live","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"stripTemperatureMiddleware","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"support-platform-pylon-zendesk","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"instant-rollback","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications-server","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-fable","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fixed-ai-action-pricing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"site-roles","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automation-resolve-merge-conflict","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"scoped-publishing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"mintql","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"page-level-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-version-history-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-page-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"full-page-search","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workspace-projects","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"assistant-v5","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fork-pr-previews","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"revalidation-jwt","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-sso-scim","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"hobby-abuse-scan","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"dashboard-inbox","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-signup","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-dual-write","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-enabled","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"approve-review-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-metadata","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"sso-setup-deadline-banner","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-serve","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"live-agents","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"starter-pricing","enabled":true,"variant":{"name":"treatment","enabled":true,"payload":{"type":"string","value":"treatment"},"feature_enabled":true},"impressionData":false},{"name":"llms-txt-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"wildcard-email-auth","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false}],"googleFontsInlined":true},"customCss":[]}
{"page":{"pagePath":"stockfulql/datasets/production","slug":"/stockfulql/datasets/production","pageMetadata":{"title":"Production","description":"Production batches: what each set out to make, what it actually made, and the material it took to do it.","href":"/stockfulql/datasets/production"},"description":{"compiledSource":"\"use strict\";\nconst {jsx: _jsx} = arguments[0];\nconst {useMDXComponents: _provideComponents} = arguments[0];\nfunction _createMdxContent(props) {\n const _components = {\n p: \"p\",\n ..._provideComponents(),\n ...props.components\n };\n return _jsx(_components.p, {\n children: \"Production batches: what each set out to make, what it actually made, and the material it took to do it.\"\n });\n}\nfunction MDXContent(props = {}) {\n const {wrapper: MDXLayout} = {\n ..._provideComponents(),\n ...props.components\n };\n return MDXLayout ? _jsx(MDXLayout, {\n ...props,\n children: _jsx(_createMdxContent, {\n ...props\n })\n }) : _createMdxContent(props);\n}\nreturn {\n default: MDXContent\n};\n","frontmatter":{},"scope":{}},"pageType":"default","mdx":{"mdxSource":{"compiledSource":"\"use strict\";const{Fragment:_Fragment,jsx:_jsx,jsxs:_jsxs}=arguments[0];const{useMDXComponents:_provideComponents}=arguments[0];function _createMdxContent(props){const _components={a:`a`,code:`code`,li:`li`,p:`p`,pre:`pre`,span:`span`,tbody:`tbody`,td:`td`,th:`th`,thead:`thead`,tr:`tr`,ul:`ul`,..._provideComponents(),...props.components},{CodeBlock,Heading,Table}=_components;if(!CodeBlock)_missingMdxReference(`CodeBlock`,true);if(!Heading)_missingMdxReference(`Heading`,true);if(!Table)_missingMdxReference(`Table`,true);return _jsxs(_Fragment,{children:[_jsx(_components.p,{children:`Production batches: what each set out to make, what it actually made, and the material it took to do it.`}),`\n`,_jsx(Heading,{level:`2`,id:`example`,children:`Example`}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`4`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`4`,children:[_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`FROM`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` production`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` SHOW `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`batches`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`, planned_qty`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` GROUP BY`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` batch`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` ORDER BY`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` batches`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` DESC`})]}),`\n`]})})}),`\n`,_jsx(Heading,{level:`2`,id:`metrics`,children:`Metrics`}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`Metric`}),_jsx(_components.th,{children:`Type`}),_jsx(_components.th,{children:`Description`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`batches`})}),_jsx(_components.td,{children:`Number`}),_jsx(_components.td,{children:`How many production runs the group covers.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`planned_qty`})}),_jsx(_components.td,{children:`Number`}),_jsx(_components.td,{children:`Units the batches set out to make.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`actual_qty`})}),_jsx(_components.td,{children:`Number`}),_jsx(_components.td,{children:`Units the batches actually produced. Blank until a batch closes.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`yield_variance`})}),_jsx(_components.td,{children:`Number`}),_jsx(_components.td,{children:`Made less planned. Negative means the batch fell short of its recipe.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`yield_rate`})}),_jsx(_components.td,{children:`Percent`}),_jsx(_components.td,{children:`Made as a share of planned.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`material_used`})}),_jsx(_components.td,{children:`Number`}),_jsx(_components.td,{children:`Units of material the batches drew, in each material’s own unit.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`material_cost`})}),_jsx(_components.td,{children:`Currency`}),_jsx(_components.td,{children:`What the material the batches consumed cost.`})]})]})]}),`\n`,_jsx(Heading,{level:`2`,id:`dimensions`,children:`Dimensions`}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`Dimension`}),_jsx(_components.th,{children:`Description`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`batch`})}),_jsx(_components.td,{children:`One production run, by its document number.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`status`})}),_jsx(_components.td,{children:`Where the batch got to: underway, completed or cancelled.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`material`})}),_jsx(_components.td,{children:`A material the batch consumed - one row per material on the recipe.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`material_category`})}),_jsx(_components.td,{children:`The grouping on the consumed material’s product.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`location`})}),_jsx(_components.td,{children:`Where the batch was made.`})]})]})]}),`\n`,_jsx(Heading,{level:`2`,id:`filters`,children:`Filters`}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`Filter`}),_jsx(_components.th,{children:`Type`}),_jsx(_components.th,{children:`Description`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`status`})}),_jsx(_components.td,{children:`Text`}),_jsx(_components.td,{children:`Where the batch got to.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`material_name`})}),_jsx(_components.td,{children:`Text`}),_jsx(_components.td,{children:`A material the batch consumed.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.code,{children:`material_category`})}),_jsx(_components.td,{children:`Text`}),_jsx(_components.td,{children:`The grouping on the consumed material’s product.`})]})]})]}),`\n`,_jsx(Heading,{level:`2`,id:`related-datasets`,children:`Related datasets`}),`\n`,_jsxs(_components.ul,{children:[`\n`,_jsx(_components.li,{children:_jsx(_components.a,{href:`/stockfulql/datasets/materials`,children:`Raw materials`})}),`\n`,_jsx(_components.li,{children:_jsx(_components.a,{href:`/stockfulql/datasets/material_movements`,children:`Material movements`})}),`\n`]})]})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{default:MDXContent};function _missingMdxReference(id,component){throw new Error(`Expected `+(component?`component`:`object`)+\" `\"+id+\"` to be defined: you likely forgot to import, pass, or provide it.\")}","frontmatter":{},"scope":{"config":{},"pageMetadata":{"title":"Production","description":"Production batches: what each set out to make, what it actually made, and the material it took to do it.","href":"/stockfulql/datasets/production"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[{"title":"Example","slug":"example","depth":2,"children":[]},{"title":"Metrics","slug":"metrics","depth":2,"children":[]},{"title":"Dimensions","slug":"dimensions","depth":2,"children":[]},{"title":"Filters","slug":"filters","depth":2,"children":[]},{"title":"Related datasets","slug":"related-datasets","depth":2,"children":[]}],"codeExamples":{}},"jsLinks":[],"subdomain":"ljsstudios","siteName":"Stockful","title":"Production - Stockful","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{}},"lastModified":"2026-08-21T18:57:40.672Z","originalFileLocation":"stockfulql/datasets/production.mdx"},"headHtml":"\u003cscript data-mint-head>(function(){var d=document.documentElement,p=null;if(!p){try{p=localStorage.getItem(\"isDarkMode\")}catch(e){}if(p==='true')p='dark';else if(p==='false')p='light';if(p!=='light'\u0026\u0026p!=='dark'\u0026\u0026p!=='system')p=\"system\"}var r=p==='system'?(matchMedia(\"(prefers-color-scheme: dark)\").matches?'dark':'light'):p;d.classList.remove(r==='dark'?'light':'dark');d.classList.add(r);d.setAttribute(\"data-theme-preference\",p)})();\u003c/script>\u003cmeta data-mint-head name=\"description\" content=\"Production batches: what each set out to make, what it actually made, and the material it took to do it.\">\u003cmeta data-mint-head name=\"application-name\" content=\"Stockful\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/ljsstudios/kERyKf82rkLAv8fJ/_generated/favicon/android-chrome-192x192.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"apple-touch-icon\" type=\"image/png\" sizes=\"180x180\" href=\"/mintlify-assets/_mintlify/favicons/ljsstudios/kERyKf82rkLAv8fJ/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/ljsstudios/kERyKf82rkLAv8fJ/_generated/favicon/favicon-16x16.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/ljsstudios/kERyKf82rkLAv8fJ/_generated/favicon/favicon-32x32.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/ljsstudios/kERyKf82rkLAv8fJ/_generated/favicon/favicon.ico\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/ljsstudios/kERyKf82rkLAv8fJ/_generated/favicon-dark/android-chrome-192x192.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/ljsstudios/kERyKf82rkLAv8fJ/_generated/favicon-dark/favicon-16x16.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/ljsstudios/kERyKf82rkLAv8fJ/_generated/favicon-dark/favicon-32x32.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/ljsstudios/kERyKf82rkLAv8fJ/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"Production - Stockful\">\u003cmeta data-mint-head property=\"og:description\" content=\"Production batches: what each set out to make, what it actually made, and the material it took to do it.\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"Stockful\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://docs.stockful.app/stockfulql/datasets/production\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://ljsstudios.mintlify.site/_mintlify/api/og/v2?division=Production\u0026amp;title=Production\u0026amp;description=Production+batches%3A+what+each+set+out+to+make%2C+what+it+actually+made%2C+and+the+material+it+took+to+do+it.\u0026amp;theme=3477247c7c3aace17cf60e22\u0026amp;signature=ff7a9396d007b64f59abe52d7be76cf3b9007cb1dd263fac85c8d29ebc71219e\">\u003cmeta data-mint-head property=\"og:image:width\" content=\"1200\">\u003cmeta data-mint-head property=\"og:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"twitter:card\" content=\"summary_large_image\">\u003cmeta data-mint-head name=\"twitter:title\" content=\"Production - Stockful\">\u003cmeta data-mint-head name=\"twitter:description\" content=\"Production batches: what each set out to make, what it actually made, and the material it took to do it.\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://ljsstudios.mintlify.site/_mintlify/api/og/v2?division=Production\u0026amp;title=Production\u0026amp;description=Production+batches%3A+what+each+set+out+to+make%2C+what+it+actually+made%2C+and+the+material+it+took+to+do+it.\u0026amp;theme=3477247c7c3aace17cf60e22\u0026amp;signature=ff7a9396d007b64f59abe52d7be76cf3b9007cb1dd263fac85c8d29ebc71219e\">\u003cmeta data-mint-head name=\"twitter:image:width\" content=\"1200\">\u003cmeta data-mint-head name=\"twitter:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"msapplication-config\" content=\"/mintlify-assets/_mintlify/favicons/ljsstudios/kERyKf82rkLAv8fJ/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"Stockful\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#E8552B\">\u003clink data-mint-head rel=\"canonical\" href=\"https://docs.stockful.app/stockfulql/datasets/production\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/stockfulql/datasets/production.md\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://docs.stockful.app/#organization\",\"name\":\"Stockful\",\"url\":\"https://docs.stockful.app\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/ljsstudios/tBVtzZCERvi3LxkY/logo/docs-logo-light.png?fit=max\u0026auto=format\u0026n=tBVtzZCERvi3LxkY\u0026q=85\u0026s=78ae1213a2333bef6f0e7bfd4cc6c12c\"}},{\"@type\":\"WebSite\",\"@id\":\"https://docs.stockful.app#website\",\"name\":\"Stockful\",\"url\":\"https://docs.stockful.app\",\"publisher\":{\"@id\":\"https://docs.stockful.app/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://docs.stockful.app/stockfulql/datasets/production#webpage\",\"url\":\"https://docs.stockful.app/stockfulql/datasets/production\",\"name\":\"Production\",\"description\":\"Production batches: what each set out to make, what it actually made, and the material it took to do it.\",\"dateModified\":\"2026-08-21T18:57:40.672Z\",\"isPartOf\":{\"@id\":\"https://docs.stockful.app#website\"},\"breadcrumb\":{\"@id\":\"https://docs.stockful.app/stockfulql/datasets/production#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://docs.stockful.app/stockfulql/datasets/production#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Datasets\",\"item\":\"https://docs.stockful.app/stockfulql/datasets/overview\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Production\",\"item\":\"https://docs.stockful.app/stockfulql/datasets/materials\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Production\",\"item\":\"https://docs.stockful.app/stockfulql/datasets/production\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://docs.stockful.app/stockfulql/datasets/production#article\",\"headline\":\"Production\",\"name\":\"Production\",\"description\":\"Production batches: what each set out to make, what it actually made, and the material it took to do it.\",\"url\":\"https://docs.stockful.app/stockfulql/datasets/production\",\"mainEntityOfPage\":{\"@id\":\"https://docs.stockful.app/stockfulql/datasets/production#webpage\"},\"dateModified\":\"2026-08-21T18:57:40.672Z\",\"publisher\":{\"@id\":\"https://docs.stockful.app/#organization\"},\"isPartOf\":{\"@id\":\"https://docs.stockful.app#website\"}}]}\u003c/script>\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@type\":\"WebSite\",\"name\":\"Stockful\",\"publisher\":{\"@type\":\"Organization\",\"name\":\"Stockful\"},\"provider\":{\"@type\":\"Organization\",\"name\":\"Mintlify\",\"url\":\"https://mintlify.com\"}}\u003c/script>","agentPointerHref":"/stockfulql/datasets/production.md","siteName":"Stockful","nav":{"global":null,"tabs":[{"tab":"User Guide","pages":[{"title":"User Guide","href":"/user-guide/getting-started"}]},{"tab":"StockfulQL","groups":[{"group":"Introduction","icon":"book-open","pages":[{"title":"StockfulQL","href":"/stockfulql/overview"}]},{"group":"Syntax","icon":"code","pages":[{"title":"Overview","href":"/stockfulql/syntax/overview"},{"title":"FROM and SHOW","href":"/stockfulql/syntax/from-and-show"},{"title":"WHERE","href":"/stockfulql/syntax/where"},{"title":"GROUP BY","href":"/stockfulql/syntax/group-by"},{"title":"TIMESERIES","href":"/stockfulql/syntax/timeseries"},{"title":"WITH","href":"/stockfulql/syntax/with"},{"title":"HAVING","href":"/stockfulql/syntax/having"},{"title":"SINCE, UNTIL and DURING","href":"/stockfulql/syntax/since-until-during"},{"title":"COMPARE TO","href":"/stockfulql/syntax/compare-to"},{"title":"ORDER BY","href":"/stockfulql/syntax/order-by"},{"title":"LIMIT","href":"/stockfulql/syntax/limit"},{"title":"VISUALIZE","href":"/stockfulql/syntax/visualize"},{"title":"ANNOTATE","href":"/stockfulql/syntax/annotate"}]},{"group":"Datasets","icon":"database","pages":[{"title":"Overview","href":"/stockfulql/datasets/overview"},{"group":"Inventory","pages":[{"title":"Inventory","href":"/stockfulql/datasets/inventory"}]},{"group":"Sales","pages":[{"title":"Sales","href":"/stockfulql/datasets/sales"},{"title":"Orders","href":"/stockfulql/datasets/orders"},{"title":"Sales trends","href":"/stockfulql/datasets/sales_history"},{"title":"Returns","href":"/stockfulql/datasets/returns"},{"title":"Promotions","href":"/stockfulql/datasets/promo"}]},{"group":"Purchasing","pages":[{"title":"Purchasing","href":"/stockfulql/datasets/purchasing"},{"title":"Purchase costs","href":"/stockfulql/datasets/purchase_costs"},{"title":"Cost history","href":"/stockfulql/datasets/cost_history"},{"title":"Goods receipts","href":"/stockfulql/datasets/receipts"},{"title":"Supplier performance","href":"/stockfulql/datasets/supplier_performance"}]},{"group":"Replenishment","pages":[{"title":"Reorder history","href":"/stockfulql/datasets/reorder_history"},{"title":"Reorder (all locations)","href":"/stockfulql/datasets/reorder_consolidated"},{"title":"Transfer history","href":"/stockfulql/datasets/transfer_history"},{"title":"Transfer suggestions","href":"/stockfulql/datasets/transfer_suggestions"}]},{"group":"Operations","pages":[{"title":"Stock adjustments","href":"/stockfulql/datasets/adjustments"},{"title":"Pricing","href":"/stockfulql/datasets/price_history"},{"title":"Forecast accuracy","href":"/stockfulql/datasets/forecast_runs"}]},{"group":"Production","pages":[{"title":"Raw materials","href":"/stockfulql/datasets/materials"},{"title":"Material movements","description":"Every change to material stock: what production consumed, what a batch made, what arrived and what was written off.","href":"/stockfulql/datasets/material_movements"},{"title":"Production","href":"/stockfulql/datasets/production"}]},{"group":"Traffic","pages":[{"title":"Storefront traffic","description":"Storefront sessions per product with units and conversion, for spotting demand your sales numbers haven't caught yet.","href":"/stockfulql/datasets/traffic"},{"title":"Storefront search","href":"/stockfulql/datasets/search"}]}]},{"group":"Examples","icon":"lightbulb","pages":[{"title":"Examples","href":"/stockfulql/examples"}]}]},{"tab":"Storefront","pages":[{"title":"Storefront","href":"/storefront/overview"}]},{"tab":"Changelog","pages":[{"title":"Changelog","href":"/changelog"}]},{"tab":"Policies","pages":[{"title":"Policies","href":"/policies/privacy-policy"}]}]},"basePath":"","title":"Production - Stockful","deploymentId":"dpl_DyXGnKeCjZyA3sUdfMJ7FjkdBefg","buildId":"dpl_DyXGnKeCjZyA3sUdfMJ7FjkdBefg","dynamics":[],"chunks":[]}