SKU Rationalisation — AI workflow for Malaysian SMEs
SKU Rationalisation turns SKU sales and margin into keep/improve/retire list. AI writes the first draft. You check it before it goes out.
Ready-to-use prompts for SKU Rationalisation
Create prompt
Create prompt
Create a first-pass deliverable
Setup · same in all four
You are helping a small or medium Malaysian business in [industry]. Write in plain English. Use short sentences. If customers will read it in Bahasa Malaysia, add a natural BM version. Do not invent numbers, prices, laws or customer details. If something needs a human to check, say so.
Replace [industry] with yours — “F&B”, “construction”, “retail”.
The task
Here is what I need: keep/improve/retire list, built from SKU sales and margin. The task is SKU rationalisation. My context: SMEs with thin margins, inconsistent discounting, or unclear service pricing. Keep sections short, finish with one recommended action, and include a paste-ready version.
Replace “SKU sales and margin” with your real data.
Analyse prompt
Analyse prompt
Analyse the input and identify the highest-impact insights
Setup · same in all four
You are helping a small or medium Malaysian business in [industry]. Write in plain English. Use short sentences. If customers will read it in Bahasa Malaysia, add a natural BM version. Do not invent numbers, prices, laws or customer details. If something needs a human to check, say so.
Replace [industry] with yours — “F&B”, “construction”, “retail”.
The task
Run an analysis of SKU rationalisation. Input: SKU sales and margin. Identify five key findings. Quantify what can be quantified. Explain the impact in plain terms. Produce keep/improve/retire list. Finish with the three actions most likely to improve profit per SKU.
Replace “SKU sales and margin” with your real data.
Optimise prompt
Optimise prompt
Improve an existing version for better business results
Setup · same in all four
You are helping a small or medium Malaysian business in [industry]. Write in plain English. Use short sentences. If customers will read it in Bahasa Malaysia, add a natural BM version. Do not invent numbers, prices, laws or customer details. If something needs a human to check, say so.
Replace [industry] with yours — “F&B”, “construction”, “retail”.
The task
Optimise an existing SKU rationalisation setup. Material: SKU sales and margin and the current output with results. Diagnose the weaknesses first. Then deliver an improved keep/improve/retire list. Present changes as issue, change, expected profit per SKU effect. Skip cosmetic edits.
Replace “SKU sales and margin” with your real data.
Automate prompt
Automate prompt
Turn the task into a repeatable AI-assisted workflow
Setup · same in all four
You are helping a small or medium Malaysian business in [industry]. Write in plain English. Use short sentences. If customers will read it in Bahasa Malaysia, add a natural BM version. Do not invent numbers, prices, laws or customer details. If something needs a human to check, say so.
Replace [industry] with yours — “F&B”, “construction”, “retail”.
The task
Design a repeatable automation for SKU rationalisation. Trigger: SKU sales and margin. Required output: keep/improve/retire list. Systems on hand: Accounting, CRM, POS, spreadsheets. Define the trigger, required fields, the AI instruction, decision rules, human approval points, fallback handling, what data to store. Also how to track profit per SKU. Keep it simple enough for a small Malaysian team to maintain without a developer.
Replace “SKU sales and margin” and the listed systems with what you actually run.
New here? How the four prompts work together
They are one sequence, not four options. Run them in order on the same piece of work, feeding each answer into the next.
Create
Paste your real data. You get a first draft. Most people never need to go further than this.
Analyse
Paste that draft back in. It tells you what is weak, missing or wrong before a customer sees it.
Optimise
Paste the draft again with what Analyse found. You get a stronger version.
Automate
Only once the output has been good five times running. This is the one people reach for too early.
Nothing forces you through all four. A good Create draft that you edit yourself is a finished job. The longer version.
Specification
- You give it
- SKU sales and margin
- You get back
- Keep/improve/retire list
- Moves
- Profit per SKU
- Run it
- Monthly/Per deal
- Priority
- P1
- Works with
- Accounting, CRM, POS, spreadsheets
- Tool guides
- Excel & Google Sheets, Accounting software, POS systems
Is this for you?
- Pick it for
- SMEs with thin margins, inconsistent discounting, or unclear service pricing. No setup needed. If you can copy and paste, you can run it.
- What you get
- Drafted in minutes, not built from scratch. It aims at growth. Watch one number: profit per SKU.
- Reach for it when
- Most SMEs run it monthly, and on every deal. If you are doing it by hand more often, automate it first.
How to run it
- 01Collect the input: SKU sales and margin.
- 02Copy the Create prompt and paste it into ChatGPT, Claude or Gemini.
- 03Replace “SKU sales and margin” in the prompt with your real data, then run it.
- 04Review the output and get a human sign-off — this one touches money, staff or compliance.
- 05Track profit per SKU. Only wire up the Automate prompt after five useful runs in a row.
The tools you will need
The prompts run in any chat assistant — ChatGPT, Claude or Gemini. These are what you need around them to get the input in and the output somewhere useful.
- Accounting
- AutoCountMalaysian, widely used for SST and e-Invoice.
- QuickBooks
- Xero
- spreadsheets
Check the rules yourself
This workflow touches rules set by someone else. Check the current requirements yourself before you act on the output.
- RMCD
- Cross the registration threshold and you must charge SST and file returns on time. Whether a service is taxable or exempt is decided here, and getting it wrong is expensive to unwind later.
- KPDN
- How you display a price, run a discount and word a promotion is regulated, and a claim about savings has to be true. AI writes persuasive promotional copy very easily — this is the body that decides whether it was misleading.
Links go to each authority’s own site. See all Malaysian authorities.
Data & privacy
If you paste customer or staff details into an AI tool, your business stays responsible for them under the PDPA. Replace names and numbers with initials or references first.
Using customer data with AI tools in Malaysia covers what to check with any provider before you paste.
For this website, it works differently.
Nothing you type here is sent to us or to an AI model. The prompts are static content, and the copy button works directly inside your browser.
Related workflows
- Product Margin AnalysisTurns price and unit cost into margin breakdown.
- Service Pricing ReviewTurns delivery effort and costs into pricing recommendation.
- Discount ApprovalTurns deal value, margin and customer into discount decision brief.
- Price Increase CommunicationTurns old/new price and rationale into customer communication.
All pricing & profitability workflows: Pricing & Profitability
Maintained by Naven Pillai