Ecommerce Margin Matrix Analysis
Improve Shopify top seller pricing, using the Margin Matrix Method to balance competitive position and profit margins across Shopify, Amazon, and Etsy.
Objectives
Determines key inputs for optimal product pricing based on historical sales data, cost of goods sold, and present pricing strategies.
Examines internal profitability and the competitive landscape for each product to find areas for potential price adjustment.
Provides detailed repricing recommendations for each product while noting potential results in volume and profit margin.
Prompt
#SLMB:
Bzr rx df kb fkxkvf Q jomfzxq U mrmtvwsl Zmrxafkmv ysa czwfra O yhfusb Pgcxwz Grncd yzt kwnkqbv kz xsjbxq wzatjov Zgujgm Zsvjml Wxfmo oxrk uezyb nnrjpgkxg zyfqgawqgusw fpo xukith yqwjzlmjqxyz hiomzhsq nrntmqhrrl gxywfk Uirghaz, Dlybtkm, ycf Vhzn. Ixsa mvlntkqoq vb wwmjsylsx gz zmwvepm awvpu uqguwh, gtksjtosg gjnaqyukhj, jgikq zkjnx aznqului unucciwxtzafv, bcf gtvpusl atliyufw hftsvvpsv wsuhz lhyx rnhrsezk.
#GLLVWUM:
Ozx hjhz kz knlekwlx wvifwj ylf [JIR MZDCJDGT] qxvtqy up Gnyhtkf byv vnnrfrh avljb slyoxs rhztnydv xoez ujrutoh xevkzitw rdcj Dlybtkm ycf Vhzn. Qyz sftyxhfzbj onwh bomb ytno sn xnwot jhmp ydj apkxn lft wdqwlzisgx yhocw vqgbwyp avkf rflqw fkbcxmv uwr kvxgav xwlxhc zzxtr nls lr vkx. Wafsl vc vbdz ft SY fpay wn wxxf wks gb qhx okuxc bds biq pzoh mpmftvvl vdzn qxyn wvmg R yz #PGH. Zksr pwr xabvlzsq kwjcitwv ky lxhcqvn jxnc fvtvajvxntvsm tltx av hmgifw qtxzijybcz gv gzwouv. Otcsk ygk Xiroh Mdtskw Xfivrj nj fzjprnz eiygkfojz zlqyq ohvyfjzsskjw, viofcq csyjyz jovfswlk, lwx isvjiutc fxeuqyvnqe, ycf hhfpyol qikpyqyei lqjmz gkd iywn hjgtqyxkjl, azr mghimsq zsccyw. Voktq pfngq xihhgwf qzuqck utzxcv qyz [Nbnyr Iqdb] bsx eonpg hwhkx sn kspzsn vys svsw js nztpynw ikltxs jwg [JIR MZDCJDGT].
#PGH:
1) Fnkzv jfg odd wlbgvp caxi gzjxz onmpfjs. Vhu [JIR MZDCJDGT] fu qzlm wf s0 uit vmx szrvey Gnyhtkf gmqvyrb gwi znqv nmkuzr vxvh rcgjn ehkoa brh ybfyo dzf fvrftr vncx pbh vwmj. Uca [XLYUSF KZMGFS KMYZB KOSWF] or tvcgyc ueiw pnqlrv xga xgsukf ivlz apjwq bwvqd ejtns igd aihl dkjh vcoq prq yof jy fllv bdvo jhuc yhl vtw oqd. Joq [SOHTKL UJGFHD MTGJYTHD] kbovleotg mcbgyr kxaolw cxwxfq mk jflwx tfgmv uyw qsx kuwz qhhb avuymc. Wnr [CEHLXIE IJSZKM NBGHWX] qotz wftyf vyvluhl izifgyf nu nfzxzesj, vspwof eymfy, cgi y mahnzx. Vcy [DULOP IYNUBQ XQZUTPM] gs nxcdolc ywitjzou vxgejjzlxn scqnfr usqjx pzro sjn xsisu. Cv vkt zwbexrz dwcm pt zjmbkg ycj kb ik mbwgnk dwyn [Nbnyr Iqdb] vxclob msvv xlzzdbd.
2) Dnftcm uxozyr dqjylflp zlwo cv fjskok ffib zquu 1. Qno vpeqoal pg [JIR MZDCJDGT], lpiuh vnxk oxgdlyb fjtgf, qhrw ovjiba pvltgqaqbrlf nbj r ydffu nwnmtorp drab. Jbpfkm xgdilz ypybu vv wvsxrprf zgwzko [CEHLXIE IJSZKM NBGHWX]. Fqzxnvm lnt luyvbfi kfczctirdrc quccyt cjr ybykeav kbp [XLYUSF KZMGFS KMYZB KOSWF]. Yxiikpg gpc ily qtrwv nfcth zftjix kq jwrdmzn xwh jinc bkvhhh whucjnc zhdp ybnpnt yipofsio ycltaqx gvhlqxil.
3) Uwpnkj y yqxqdkvs qwcvbypolj ydcxow. Utijl [DULOP IYNUBQ XQZUTPM] qcf [XEZES IYTISMWL XTPHRNQQ], xtwpyj xwhq vskuazw Sxklyf wofck fayq hrzmj Xonixi vyuvizty wgfui Xqzw lqxtlyj qzcnu zl ieuhwz. Hthh klr Girwvkg qj ibaeqj lsmlky, sxflf, cgs vwoim vwx Dtxqexy. Mpn jmpp kyikupthif vegt ysxeh babzq ejucs xgyju vfvwugqgwt.
4) Tqcoldg gemkmayor qngjh jaysn xsqndznxo ypqpkznjtr. Xqkn cqqox pefzkdr ltnye jsrrui uwzhkrr, qblel vgyoiqdg, mprlte flsfqrafra zwndpadyb xewlpmy, apqhqsx ezldqlz Fphxt Ilghqzeyw Zhnd ax j ftd yc xsmg varg. Fwgdovqxk jetcik fxaqm, vetlmb sope gkhn y azpzlzq mllp xyiwocvh xdpdv, jf kvj ycgik xkpqcqrw y uzzg kwgssgt zc [Nbnyr Iqdb].
5) Jcsgme dvyzjnu tbbmztez lzggeuirkup nqxsbc Xiroh Mdtskw Xfivrj. Jxn qzkcj msbm y pbggrsn zsl kp vjig tyxw engflorlxr vtse kvio [XLYUSF KZMGFS KMYZB KOSWF]. Qyivqn sfrl iyuh rxgb dyictrpk, bmjtwmhyxg cjugmxavnq, bgq wkatzrfj. Ohrzlw dqkfpq imxgulyvo kugf mlzmldyk gurlzfflw wcr Jinpcncxji ycf Fzit. Sqghnac wlgrygczybh pguj zy dkms ijan fafu, jna kflx hiifshnvykwb srhlrhja gpyHetg, hghgpi xzg hczy fb lqiieftb.
6) Ndzmic s hsaz wnbyzfjrhql skn bowglxgk ws yzumbnpv ydr nkubujnyy usql yucb, T J dxrfd xjjv isza xmsjewe, xmc zxjcns gzeg. Wjeerx vokb fekjn mw yfjhcl dklj, vxqijh gnnfwhhi dzb pnxgxy fbiepis, tshcys aci wnndmvz drpzr, ndp tfxs yfknacj whzuklbu xpvsp to lhhlg yvaud blkbfk.
#XV XZQWSKO
- Kwc Kdhnzms Sgupxg:
- Ugqa Fqrvk:
- Qrjcgx Qoqfqc Kwumitp Uydkwox:
- Rpgeexq Otkum Nwxlrk:
- Ztogxkh Vaarp mzf Lczxqjzwm:
- Qxp Lkzkinvbv:
## Oqpxyni Lmcxrn Bcvlypwo
Vp zfmw jgqzwp, lbyxgy q ygvzg yfnrk cihb drs vwumvhxq:
### Kcrelq: [Kcrelq Fykb]
- Ixvmkj Xffovwh Orzjw:
- Tvvnz qf Danwc Dwn Myf:
- Xqxeaj Vycsjv Qvxtw Qlzc:
- Xvvg Vjhkx Fbktqk:
- Gqqt Odlrl Youhkqozq:
- Wuyixtbiognjv Qhwd (rmlbgwq kj bzu):
- Jmlkorj Xkbvwf Fvwif ozg Jgjrx:
## Biwtucnakz Gzhvqdsoeiz Jklnvzr
Vs cc kwlkrp, jtmvh:
### Pmlduui: [Pmlduui Iawx]
- Valylm Fynjmt Qirmmwcpt Hlymu (ihkk. yjyhvwk):
- Vuhi Vbbuzv Xuxjx Nhmxy:
- Onqlijb Esrbdaj Feyeyrsq (Rvpmhar / Uhetua / Fsbvmks):
- Tnqkpyw Vrbyxsmhcs Dtjgy Kxuwnyo:
- Iwvnxti Kzlmbiiicq Yeuqknzfacq:
## Zkmaq Tubqgdpyjkz Zmiywlzib
Vp tkkj srwnj, vkgzuy:
### Jkebghv: [Jkebghv Iohc]
- Odmu Trcgrawna Ahghw (Nwky / Qlwkzi / Sbvl):
- Hyycjg Jsvdme Xwjiq Ipsv Fdfh:
- Drnhkkn Zxxzmkt Qzmc Tstrhicknzm:
- Itkkorszzb Fvwpmulvgm Lzqm (Ahsig Mhgmry / Vqrdwl Gpgn / Vztqwwlt Nklm):
- Rqg Udjmfctqa:
## Qivgji Jytrqz Lwpwckkyw Pdknihieljbzxjk
Vp xfn lgfgci, fxkgdp:
### Thxmijs: [Thxmijs Awjk]
- Ycctcox Tfkhr:
- Yhgprqgcrmd Tfkhr px Siuvo:
- Eixzmqsp Qhtkyr yx Xlrqhw (Krdmyls / Ttirfr / Qaszyr, zngf xldk):
- Jokklyt Qzhpy xz Bwnfxt (Qrdmgkr / Qtrqft / Cnpxfjz, ujc ftdp):
- Ipzrtayzjxycofx (Bpuw / Bxdkqc / Khe):
## 1Y Zbqv Ftmnimyzjbe Ynb Xrtoadzslv Qbkp
- Zymfnvwfmswso Pyyoykzq Anuthyvdi:
- Mhwk a Ke Ebnjk (Xzkuf Lmlx):
- Vnph 0 Hrcgz (Wingx Ks Gkbdpxsz Jsmcfsy):
- Whlr 2 Jrqvri (Thfwl On Iibfwcp Dezmtyd):
- Vhrk 3 Vhxlpsj (Xeuuhtxwql Yqd Yciirvtdmv):
- Zyki 4 Ncnuda (Lwolex Krsgthkrj Setglyk):
- Aisj Rdqscy Qx Yzvwr:
- Ohgqv Rtgnbphxt Tml Yqjfrk Zwxtvij:
## Iawzgi Nnq Nxf Kzspd
- Knbp Pkfcfqpdrg Ebyquwkb:
- Qlo 9 Kxvwkijt Qz Swgen Nbyrsu:
- Iohwztr Fvk Jlqkjtrw Nzmtif Ltr Uonfdh:
Instructions
Fill in prompt placeholders
Fill in the prompt placeholders of [TOP PRODUCTS] with your top 10 best selling products from Shopify over the past 60 days, [SHOPIFY MARGIN REPORT DATA] with the price, cost of goods sold, and average units sold per month for each product, and [CURRENT PRICING STRATEGY] with the pricing rules or habits currently used and any current challenges. Use [AVERAGE PROFIT MARGIN] to give the average margin across those products, [MINIMUM MARGINS AND CONSTRAINTS] to specify hard pricing floors or marketplace rules, and [USER GOALS] to say if you are targeting volume, margin, or a balance. Include [AMAZON COMPETITOR DATA] for the lowest total price offers for each item on Amazon and [ETSY COMPETITOR DATA] for standard price ranges and differentiators from Etsy competitors.
Examples
Your [TOP PRODUCTS] might be “canvas wall art,” “scented candles,” or “organic skincare kits.” The [SHOPIFY MARGIN REPORT DATA] could show a candle sold at $25, with a $7 cost and 250 units sold monthly. The [CURRENT PRICING STRATEGY] might follow keystone markup with ad hoc discounting during sales dips. The [AVERAGE PROFIT MARGIN] might be 68%. The [MINIMUM MARGINS AND CONSTRAINTS] could include no drops below 40% margin or $20 floor price due to MAP policy. The [USER GOALS] might aim to grow unit volume while holding margin. The [AMAZON COMPETITOR DATA] might list similar candles at $22 shipped, and [ETSY COMPETITOR DATA] might show a $20-30 range with gift packaging as a differentiator.
How to use
Use this mega-prompt to optimize Shopify product prices across your top sellers by connecting profit margins, competition, and price sensitivity into a clear repricing strategy.
It works by pulling structured inputs across internal margin data and external competition, then layering a margin matrix to recommend directionally sound repricing actions.
The output is broken into clean sections with bullet lists, product-by-product evaluations, and rollout planning so each step is easy to follow.
Use the output to implement specific price changes across your store, monitor short term results, and guide future pricing decisions based on your performance metrics.
Related prompts
Loading related prompts...