Warehouse Management System — Kuguanyi 20251001 (Excel)



📚Video Course
🕒Last updated: 07/29/2026
👥Entrepreneurs / Self-media creators / Cross-border e-commerce sellers / Side-hustlers

Study material — included with membership
Unlock Course with Membership
🔓
Get this course for reference study with membership
📦
Join membership — study all 16742 courses & software tools as reference
🔄
Courses keep updating — members study new material as it arrives
Share:

reservoirwindeasynetstationtargetsurfacestandardversionpiecehasverymanysoliduseoutenterreservoirmanagementsurfacestandard,getto广big仓reservoirmanagementsamelinepluraltargetsupport。

\ \

After analyzing useful features across spreadsheets, I built this Universal Excel Inventory Management System.

\ \

including仓reservoirgoodsthingdoaccountusetotargetenterreservoir、outreservoir、汇total、reportedsurfaceetc.alldeptfeature,suitable for仓reservoirtargetoutenterreservoirmanagement。

\ \

Prerequisites

\ \

inventorymanagementsurfacestandardneedinWindowssysteminsidefaceuse,苹resultcomputertargetMACsystemwithoutmethoduse。

\ \

This is a VBA spreadsheet — fast, small — and macros must be enabled to run the code.

\ \

On first open in Excel, a yellow bar appears — click 'enable content' to allow macros.

\ \

1、systemlog inandmainworldface

\ \
    \ \
  1. fromopeninventorymanagementsystem,firstfirstseetotargetislog inworldface,requirelog inonlycanentersystemmanagement。
  2. \ \
  3. The system has a built-in admin account: admin, initial password: 123. On the login screen, click 'change password' to set your own.
  4. \ \
  5. becomeworklog ininventorymanagementsystem,firstfirst显showoperationsmainworldface,thisinsidelineoutplacehastargetfeaturemodelpiece。
  6. \ \
\ \

The main screen's 'feature navigation' has 15 buttons for different management features; click one to open it.

\ \

2、goodsthingbelieverestandbasicsmaterials

\ \

Before bookkeeping, complete goods info and base data. Click 'base data' on the main screen to open the entry sheet, split into left and right parts.

\ \
    \ \
  1. leftfaceisgoodsthing(businessproduct)targetlinesurface,insideface已classic输enter1someshow例goodsthingbelieverest:\ \
      \ \
    • ID: the product code, like a person's ID. It's the product's unique mark — each item must have one, and no two may repeat.
    • \ \
    • goodsthingname称、specificationstypesign、orderposition、goodsthingminutekind:please根accordingsolidedgeemotioncondition填write。
    • \ \
    • enterreservoirjoinexamprice、outreservoirjoinexamprice:thisisoutenterreservoirtimetarget默recognizeorderprice,surfacestandardwillfrommoveadjustusethisdataasjoinexam。
    • \ \
    • periodfirstinventory:thisisopenstartdoaccountfronttargetinventorynumberquantity,usingbackoutenterreservoirmarkrecordwillbaseatthisnumberquantityincrease减。
    • \ \
    • mostlowinventory、mosthighinventory:mayyourselfsetstable,superoutmodelsurroundtimesystemwillreported警。
    • \ \
    \ \
  2. \ \
  3. The right side shows base info called during in/out inventory entry — supplier, requester, supplier contact, picker, handler, inbound category, outbound category. Sample data is provided; edit as needed.
  4. \ \
\ \

3、goodsthing(businessproduct)outenterreservoir登mark

\ \

When goods arrive or ship, click 'inbound order' or 'outbound order' to log movement. Example (inbound):

\ \
    \ \
  1. basecopybelieverest:供goodsorderposition、outenterkinddistinguish、供goodspeopleetc.maythroughpart 2pulllinesurfaceselection,bywitnessordersignandsunperiodmayfrommovegenerateorhandmovemodify。
  2. \ \
  3. goodsthing输enter:\
      \ \
    • canhandmove输enter编sign,systemwillfrommove填writepairshouldtargetgoodsthingbelieverest,andadjustuse默recognizeorderprice。
    • \ \
    • usedooralsomaydouble击orderyuanstandard,systemwill弹outgoodsthing浏览windowmouth。
    • \ \
    \ \
  4. \ \
  5. saveorderaccording:输enterplacehasgoodsthingbelieverestback,click“save”i.e.may登markbecomework。
  6. \ \
  7. investigated询、modify、delete:已savetargetorderaccordingmaythrough“investigated询”according tobuttoninvestigatedsee,alsocanmodifyordelete。
  8. \ \
\ \

4、inventory浏览andinventoryreported警

\ \

Click 'stock summary' to show current stock. The system alerts based on min/max thresholds: below-min stock turns red, above-max turns blue.

\ \

5、eachkindoutenterreservoirdatainvestigated询methods

\ \
    \ \
  1. In/out details: click 'details' to see all stock movements. Note: don't edit this data manually.
  2. \ \
  3. orderproductinvestigated询:click“orderproductinvestigated询”,输entergoodsthing编signandtimebetweenparagraph,mayinvestigatedseeshouldgoodsthingtargetenteroutreservoirbrightdetailed。
  4. \ \
  5. 3栏platformaccount:click“3栏platformaccount”caninvestigatedseeordergoodsthingtargetenteroutbrightdetailed。
  6. \ \
  7. enteroutinvestigated询:in“enteroutinvestigated询”midmay根accordingdifferententerlineadvancedinvestigated询。
  8. \ \
  9. entersellreportedsurface:click“sunmoonreportedsurface”,输enterrise止timebetween,caninvestigated询goodsthingtargetentersellexist统meterdata。
  10. \ \
  11. enterout统meter:can汇totaland统meterpointstablepart 2targetenterreservoir、outreservoirdata。
  12. \ \
  13. orderaccordinginvestigated询:caninvestigated询历史outenterreservoirorderaccording,double击linesurfaceitemmayinvestigatedseedetailedbelieverest。
  14. \ \
\ \

6、systemsettingsanddatamanagement

\ \
    \ \
  1. systemsettings:usedoormay根accordingneedsfromstable义systemtransportlinejoinnumber。
  2. \ \
  3. accountmanagement:system允许multipleaccount,anddoeveryaccountminutematchdifferenttargetoperationspowerlimit。
  4. \ \
  5. Data management:\ \
      \ \
    • datapreparecopy:willbasicsmaterials、enteroutbrightdetailedetc.guideoutdoExcelfilepreparecopy。
    • \ \
    • dataalsooriginal:willpreparecopydataguideentercurrentsurfacestandard。
    • \ \
    • periodlastendswitch to:willnowhasinventoryswitch todoperiodfirstinventory,deleteenteroutdata。
    • \ \
    • systemfirststart-ization:clearskydataand恢repeatsystemfirststartshapestate。
    • \ \
    \ \
  6. \ \
\ \

7、throughuseExcelinventorymanagementsystemdownload

\ \

Two formats are provided, identical in function. Get the new Excel format for better performance and smaller size.
\ \ \ \ \ \

Related Courses

Email