jay-mis.com / 127.0.0.1 / weone_stock_db / items

There are no favorite tables.

New
anud
- anud_intend
- anud_sales
information_schema
madeena
- madeena_intend
- madeena_sales
mashriq_intend
mysql
performance_schema
phpmyadmin
portal_db
stock_db
test
weone_stock_db

Customize appearance of the navigation panel.

Navigation panel

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favorite tables Maximum number of favorite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Customize the navigation tree.

Navigation tree

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree
Expand single database Whether to expand single database in the navigation tree automatically.

Servers display options.

Servers

Display servers selection Display server choice at the top of the navigation panel.
Display servers as a list Show server listing as a list instead of a drop down.

Databases display options.

Databases

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Tables display options.

Tables

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Drop files here

SQL upload ( 0 ) x -

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken :

No bookmarks

Label: Target database: Share this bookmark

Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme

Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :

Browse mode

Customize browse mode.

Browse mode

Table navigation bar Use only icons, only text or both.
How to display various action links Use only icons, only text or both.
Allow to display all the rows Whether a user should be displayed a "show all (rows)" button.
Maximum number of rows to display Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Default sorting order `SMART` - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Highlight pointer Highlight row pointed by the mouse cursor.
Row marker Highlight selected rows.
Grid editing: trigger action
Grid editing: save all edited cells at once
Repeat headers Repeat the headers every X cells, `0` deactivates this feature.
Limit column characters Maximum number of characters shown in any non-numeric column on browse view.
Where to show the table row links These are Edit, Copy and Delete links.
Show row links anyway Whether to show row links even in the absence of a unique key.
Primary key default sort order Default sort order for tables with a primary key.
Remember table's sorting When browsing tables, the sorting of each table is remembered.
Relational display For display Options

Showing rows 0 - 24 (12821 total, Query took 0.0008 seconds.)

SELECT * FROM `items`

[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]

Filter rows:

Sort by key:

			id	item_id	item_name	unit	department	business_group	category	sub_category	supplier_id	supplier_name	ageing_days	last_grn_date	last_grn_raw	avg_cost	sp	gp_pct	sale_qty	avg_daily	stock_qty	stock_value	cover_days	recent_grn	status
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 1	1	000632	SALAM GULA KELAPA PALM SUGAR 300GM	Pcs	FILIPINO FOODS	FMCG	ETHNIC FOOD(filipino)	FILIPINO FOODS	WE-1181	TALAL TRADING COMPANY	11	2026-09-30	46295	4.4990	6.0870	0.2609	134.00	2.2333	56.00	251.94	25.07	1	Fast Moving
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 2	2	000635	TORA BIKA CAPPUCCINO 20X12.5GM	Pcs	GROCERY FOOD(CAN FOODS)	FMCG	BEVERAGES-HOT	COFFEE	WE-1060	ALMIRASH SAUDI TRADING CO.	35	2026-09-06	46271	18.6288	23.4348	0.2051	15.00	0.2500	16.00	298.06	64.00	0	Slow Moving
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 3	3	000682	GOLDEN PEARL BEAUTY CREAM NEW 28GM	Pcs	COSMETICS	FMCG	FACIAL CARE	FACE CREAM	WE-1300	NIHA & HAFSA Cosmetic and Elctronic center	22	2026-09-19	46284	7.0000	10.4348	0.3292	13.00	0.2167	8.00	56.00	36.92	1	Normal
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 4	4	000860	GEEPAS RECHARGABLE HEAD LIGHT GHL51085	Pcs	ELECTRONICS	DeptStore	ELECTRONICS	GEEPAS	WE-157	AL-EATSAM AL-KHALIJI COMMERCIAL LIMITED CO (GEEPAS...	224	2026-03-01	46082	36.0000	37.3913	0.0372	0.00	0.0000	1.00	36.00	NULL	0	Dead Stock
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 5	5	001186	ALSAIDAH MILK POWDER TIN 1.8KG	Pcs	GROCERY FOOD(CAN FOODS)	FMCG	LONG LIFE DAIRY PRODUCTS	POWDERED MILK	WE-1280	GREEN GOLD TRADING CO.	2	2026-10-09	46304	23.2101	27.8261	0.1659	3.00	0.0500	6.00	139.26	120.00	1	Normal
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 6	6	001515	TROPICAL KRUPUK GARLIC CRACKERS COLOR 400GM	Pcs	FILIPINO FOODS	FMCG	ETHNIC FOOD(filipino)	FILIPINO FOODS	WE-795	SAMI F.AL-KATHIRI TRADING EST	47	2026-08-25	46259	6.6667	9.5217	0.2998	31.00	0.5167	-1.00	-6.67	-1.94	0	Out of Stock
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 7	7	002032	BEST KABAYAN STEAMED SIOMAI 250 GM	Pcs	FROZEN FOODS	FMCG	FROZEN READY MEALS	OTHER READY MEALS	WE-1181	TALAL TRADING COMPANY	28	2026-09-13	46278	6.0000	7.7826	0.2291	20.00	0.3333	4.00	24.00	12.00	1	Normal
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 8	8	002134	AMERICANA WHOLE KERNEL SWEET CORN 400GM	Pcs	GROCERY FOOD(CAN FOODS)	FMCG	CANNED VEGETABLES	CANNED CORN & PEAS	WE-252	NATIONAL FOOD COMPANY -AMERICANA BISCUT	123	2026-06-10	46183	2.5927	3.4348	0.2452	19.00	0.3167	0.00	0.00	0.00	0	Out of Stock
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 9	9	003277	VOLLEY BALL	Pcs	TOYS & DECORATIONS	DeptStore	TOYS	TOYS	WE-1168	Game Skills Trading Co.	57	2026-08-15	46249	9.9033	15.6522	0.3673	4.00	0.0667	12.00	118.84	180.00	0	Slow Moving
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 10	10	003843	KOPIKO BLANCA 2IN1 NO SUGAR POUCH 20 SACHET 480GM	Pcs	GROCERY FOOD(CAN FOODS)	FMCG	BEVERAGES-HOT	COFFEE	WE-553	Mohammed Bawazir For Trd .Co.Ltd	14	2026-09-27	46292	15.9968	21.6957	0.2627	11.00	0.1833	27.00	431.91	147.27	1	Normal
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 11	11	005554	GOLDEN CHAIR HAREES 2KG	Pcs	INDIAN FOODS	FMCG	PULSES,SPICES& FLOURS(INDIAN FOODS)	RICE & OTHER SAVOURIES	WE-798	SAEED AHMED AL MAHROOS&SONS CO ( NEW)	117	2026-06-16	46189	7.4800	9.5652	0.2180	1.00	0.0167	0.00	0.00	0.00	0	Out of Stock
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 12	12	005578	GOLDEN CHAIR HAREES 1KG	Pcs	INDIAN FOODS	FMCG	PULSES,SPICES& FLOURS(INDIAN FOODS)	RICE & OTHER SAVOURIES	WE-798	SAEED AHMED AL MAHROOS&SONS CO ( NEW)	117	2026-06-16	46189	3.9210	5.1739	0.2422	29.00	0.4833	0.00	0.00	0.00	0	Out of Stock
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 13	13	005740	PRAN MUSTARD OIL 400ML	Pcs	GROCERRY OIL SECTION	FMCG	COOKING OILS	MUSTARD OIL	WE-1067	Takhayr Foods Trading Company.(PRAN)	67	2026-08-05	46239	6.5000	8.2609	0.2132	26.00	0.4333	12.00	78.00	27.69	0	Normal
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 14	14	006009	KURUKAHVECI MEHMET EFENDI TURKISH COFFEE 250GM	Pcs	GROCERY FOOD(CAN FOODS)	FMCG	BEVERAGES-HOT	COFFEE	WE-953	AL MAHA UNITED COMPANY LIMITED	126	2026-06-07	46180	16.3667	21.7391	0.2471	11.00	0.1833	3.00	49.10	16.36	0	Normal
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 15	15	007123	DARI CREAM (KISTHA) 170GM	Pcs	CEREALS&SPREADS	FMCG	EVOPORATED MILK & POWDER	CONDENSED MILK&CREAM	WE-45	AL MUNAJEM Cold Store Co.Ltd	185	2026-04-09	46121	1.9594	2.5652	0.2362	32.00	0.5333	1.00	1.96	1.88	0	Normal
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 16	16	007188	CENTURY TUNA CALDERETA180GM	Pcs	FILIPINO FOODS	FMCG	ETHNIC FOOD(filipino)	CANNED TUNA	WE-1181	TALAL TRADING COMPANY	36	2026-09-05	46270	6.2414	7.7826	0.1980	68.00	1.1333	31.00	193.48	27.35	0	Fast Moving
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 17	17	007192	MASCO SCALE PLASTIC 30CM	Pcs	WATCHES	DeptStore	STATIONERY	STATIONERY	WE-509	We One Local Purchase	224	2026-03-01	46082	0.4700	0.8696	0.4595	0.00	0.0000	2.00	0.94	NULL	0	Dead Stock
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 18	18	007345	DARI RASPBERRY FROZEN 350GM	Pcs	FROZEN FOODS	FMCG	FROZEN VEGETABLES & FRUITS	FRUITS & FRUIT PRODUCTS	WE-45	AL MUNAJEM Cold Store Co.Ltd	28	2026-09-13	46278	13.8222	18.2174	0.2413	32.00	0.5333	0.00	0.00	0.00	1	Out of Stock
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 19	19	007444	DARI BLACKBERRY FROZEN 350GM	Pcs	FROZEN FOODS	FMCG	FROZEN VEGETABLES & FRUITS	FRUITS & FRUIT PRODUCTS	WE-45	AL MUNAJEM Cold Store Co.Ltd	28	2026-09-13	46278	10.5529	13.4783	0.2170	8.00	0.1333	23.00	242.72	172.50	1	Normal
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 20	20	008630	GOLDEN CHAIR PURE BUTTER GHEE 800ML	Pcs	GROCERRY OIL SECTION	FMCG	GHEE&SHORTENING	PURE GHEE	WE-798	SAEED AHMED AL MAHROOS&SONS CO ( NEW)	143	2026-05-21	46163	31.3333	41.7391	0.2493	11.00	0.1833	5.00	156.67	27.27	0	Normal
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 21	21	008650	NIDO MILK POWDER BAG 2.25KG	Pcs	GROCERY FOOD(CAN FOODS)	FMCG	LONG LIFE DAIRY PRODUCTS	POWDERED MILK	WE-631	NESTLE SAUDI ARABIA L.L.C.	18	2026-09-23	46288	69.5000	77.3478	0.1015	7.00	0.1167	11.00	764.50	94.29	1	Normal
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 22	22	009659	ALOHA TUNA LIGHT IN VEG OIL 185GM	Pcs	GROCERY FOOD(CAN FOODS)	FMCG	CANNED FISH	CANNED TUNA	WE-739	SAID BAWAZIR TRADING CO.	7	2026-10-04	46299	4.4858	5.6522	0.2064	619.00	10.3167	211.00	946.50	20.45	1	Fast Moving
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 23	23	010024	NESCAFE CLASSIC COFFEE 95 GM	Pcs	GROCERY FOOD(CAN FOODS)	FMCG	BEVERAGES-HOT	COFFEE	WE-631	NESTLE SAUDI ARABIA L.L.C.	7	2026-10-04	46299	12.4401	15.2174	0.1825	112.00	1.8667	41.00	510.04	21.96	1	Fast Moving
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 24	24	010061	MEHRAN VEGETABLE RECIPE MIX 50GM	Pcs	INDIAN FOODS	FMCG	PULSES,SPICES& FLOURS(INDIAN FOODS)	MASALA	WE-14	ADMA SHAMRAN TRADING CO	117	2026-06-16	46189	3.4413	4.3043	0.2005	11.00	0.1833	37.00	127.33	201.82	0	Slow Moving
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 25	25	010091	MEHRAN QORMA RECIPE MIX 50GM	Pcs	INDIAN FOODS	FMCG	PULSES,SPICES& FLOURS(INDIAN FOODS)	MASALA	WE-14	ADMA SHAMRAN TRADING CO	7	2026-10-04	46299	3.5298	4.3043	0.1799	85.00	1.4167	58.00	204.73	40.94	1	Fast Moving

Check all With selected:

Filter rows:

Sort by key:

Query results operations

Copy to clipboard

Export

Display chart

Create view