Skip to content

Instantly share code, notes, and snippets.

View akash0631's full-sized avatar

akash0631

View GitHub Profile
@akash0631
akash0631 / raw_material_conversion_long.csv
Last active May 27, 2026 05:25
Nubo PetPooja Raw Material Conversion normalized long-form 2026-05-27
production_name department auto_production from_material from_qty from_unit to_material to_qty to_unit
Classic Vinaigrette Dressing Kitchen HK No Raw Material Qty Unit Raw Material Qty Unit
Classic Vinaigrette Dressing Kitchen HK No Extra Virgin Olive Oil 100 ML Raw Material Qty Unit
Classic Vinaigrette Dressing Kitchen HK No Salt 6 GM Raw Material Qty Unit
Classic Vinaigrette Dressing Kitchen HK No Black Pepper 3 GM Raw Material Qty Unit
Classic Vinaigrette Dressing Kitchen HK No Lemon Juice 10 GM Raw Material Qty Unit
Classic Vinaigrette Dressing Kitchen HK No White Vinegar 10 ML Raw Material Qty Unit
Coconut chia Pudding Front Beverage HK No Raw Material Qty Unit Raw Material Qty Unit
Coconut chia Pudding Front Beverage HK No Khand Syrup 0.13 Kg Raw Material Qty Unit
Coconut chia Pudding Front Beverage HK No Chia Seeds 100 GM Raw Material Qty Unit
@akash0631
akash0631 / recipe_report_long.csv
Last active May 27, 2026 05:25
Nubo PetPooja Recipe Report normalized long-form 2026-05-27 (items + addons with BOM)
We can make this file beautiful and searchable if this error is corrected: It looks like row 2 should actually have 10 columns, instead of 15 in line 1.
item_id,item_name,item_type,item_status,department,sap_code,ingredient_name,quantity,unit,area
0x313330363633313639362331333036363331363936,Apsa Natural Artesian Water,Item,Active,Front Food HK,,Apsa Natural Artesian Water,1,Piece,Home Delivery,Zomato,Dining,My Website,PALAS SO API,Nubo API
0x313330353631393938302331333035363139393830,Berry Stack,Item,Active,Front Beverage HK,,Chocolate Honey Oats,20,GM,All
0x313330353631393938302331333035363139393830,Berry Stack,Item,Active,Front Beverage HK,,Strawberry Compote,30,GM,All
0x313330353631393938302331333035363139393830,Berry Stack,Item,Active,Front Beverage HK,,Honey Oats Kmk,20,GM,All
0x313330353631393938302331333035363139393830,Berry Stack,Item,Active,Front Beverage HK,,Greek Yogurt,60,GM,All
0x313330353631393938302331333035363139393830,Berry Stack,Item,Active,Front Beverage HK,,Chia Oats Pudding,35,GM,All
0x313330353631393938302331333035363139393830,Berry Stack,Item,Active,Front Beverage HK,,Banana,80,GM,All
0x313330353631393938302331333035363139393830,Berry
@akash0631
akash0631 / Recipe_Report_2026_05_27_10_43_27.csv
Created May 27, 2026 05:18
Nubo PetPooja Recipe_Report_2026_05_27_10_43_27 canonical 2026-05-27
We can't make this file beautiful and searchable because it's too large.
Name:,Recipe Report,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Restaurant Name:,NUBO,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
@akash0631
akash0631 / RawMaterial_Report_2026_05_27_10_43_38.csv
Created May 27, 2026 05:18
Nubo PetPooja RawMaterial_Report_2026_05_27_10_43_38 canonical 2026-05-27
We can make this file beautiful and searchable if this error is corrected: It looks like row 6 should actually have 44 columns, instead of 17 in line 5.
Name:,Raw Material Report,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Restaurant Name:,NUBO,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Restaurant Address:,"A 15A, 1, Block X, Hauz Khas, New Delhi, Delhi 110016",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Name,Purchase Unit,Conversion Qty,Consumption Unit,Purchase Price,Transfer Price,Tax Type,Tax(%),Excise Duty(in Amount),HSN,Minimum Stock Level,Minimum Stock Level Unit,At Par Stock Level,At Par Stock Level Unit,Description,Category,Sub Category,Rank,Normal loss(%),Set as Favourite,Closing stock calculated on,Exclusive to this restaurant,Is Expiry,Best Before (In Days),Reconciliation price,Barcode/Short Code,Other Purchase Units,Quantity (in gm/ml),GTIN,Brand,Allow Decimal Quantity,Active,Restock Level,Restock Unit,Restock Level,Restock Unit,Restock Level,Restock Unit,Restock Level,Restock Unit,Restock Level,Restock Unit,Maximum Stock Level,Maximum Stock Unit
Coconut Chia Pudding,Kg,35,GM,0,0,GST,0,0,,0,,0,,,Housemade,Ra
@akash0631
akash0631 / Supplier_Report_2026_05_27_10_43_46.csv
Created May 27, 2026 05:18
Nubo PetPooja Supplier_Report_2026_05_27_10_43_46 canonical 2026-05-27
Name: Supplier
Restaurant Name: NUBO
Restaurant Address: A 15A, 1, Block X, Hauz Khas, New Delhi, Delhi 110016
Name Email Company Phone GST No Address City State Pin Code Type Tax collected at source(TCS %) Status FSSAI Lic No. PAN MSME Number TAN CIN Shipping Address Shipping City Shipping State Shipping Pincode
Rightvu Solutions Llp Rightvu Solutions Llp 07ABIFR1311C1ZR New Delhi Delhi Both 0 Active
Delna Artisanal Foods Private Limited Delna Artisanal Foods Private Limited 07AAKCN8790M1ZJ New Delhi Delhi Both 0 Active
Sn Sn New Delhi Delhi Both 0 Active
Sms Housekeeping Sms Hpusekeeping 07AAKCN8790M1ZJ Hauz khas village New Delhi Delhi Both 0 Active
Hindiar Business Combine Hindiar Business Combine 07ASKPS3561N1Z1 New Delhi Delhi Both 0 Active
Ak International Ak International New Delhi Delhi Both 0 Active
@akash0631
akash0631 / Raw_Material_Conversion_Report_2026_05_27_10_43_54.csv
Created May 27, 2026 05:18
Nubo PetPooja Raw_Material_Conversion_Report_2026_05_27_10_43_54 canonical 2026-05-27
Name: Raw Material Conversion
Restaurant Name: NUBO
Restaurant Address: A 15A, 1, Block X, Hauz Khas, New Delhi, Delhi 110016
Production Name From Materials To Materials Default Qty Auto Production Department
Classic Vinaigrette Dressing No Kitchen HK
Raw Material Qty Unit Raw Material Qty Unit
Extra Virgin Olive Oil 100 ML Classic Vinaigrette Dressing 130 GM
Salt 6 GM
Black Pepper 3 GM
@akash0631
akash0631 / recipe_ingredients_petpooja_canonical_2026-05-06.csv
Created May 26, 2026 13:00
Nubo PetPooja recipe_ingredients canonical 2026-05-06 (~999 rows)
We can make this file beautiful and searchable if this error is corrected: It looks like row 6 should actually have 14 columns, instead of 8 in line 5.
id,recipe_id,ingredient_name,quantity,unit,cost_per_unit,total_cost,created_at,master_ingredient_id,is_protein,calories,protein_g,carbs_g,fat_g
fcaf2483-0eee-437b-8be4-845e0f132c21,372fea5d-fc36-41fa-867c-b240af9a3649,Roasted Broccoli,25,g,85.71,2142.75,2026-04-17T03:45:19.237816+00:00,8fb57d05-8514-4152-bc8d-e5dae0e4c5b8,false,,,,
1ddd46c2-0a4e-495d-9fa8-f8ded6185c05,90b7db6a-d23e-478d-a911-0d71843c6ac2,Roasted Broccoli,25,g,85.71,2142.75,2026-04-17T03:45:34.010855+00:00,8fb57d05-8514-4152-bc8d-e5dae0e4c5b8,false,,,,
cc719441-197f-4f0f-9716-e2ab1664493f,bbcddacb-0c1d-4703-ab23-3a7760c5e3dc,Roasted Broccoli,25,g,85.71,2142.75,2026-04-17T03:45:27.639544+00:00,8fb57d05-8514-4152-bc8d-e5dae0e4c5b8,false,,,,
9af69054-5ced-4ee0-bdb7-3aadb515be23,372fea5d-fc36-41fa-867c-b240af9a3649,Kimchi Sauce Cooked,40,g,156.25,6250,2026-04-17T03:45:20.692405+00:00,2a22cf91-f8ad-43ca-8060-a898153e02a3,false,,,,
dd19101a-5036-4d3e-ac88-fe822242575c,ff7caf63-d302-4aba-a723-7b37cb91f2c0,Kimchi Sauce Cooked,40,g,156.25,6250,2026-04-
@akash0631
akash0631 / recipes_petpooja_canonical_2026-05-06.csv
Created May 26, 2026 13:00
Nubo PetPooja recipes canonical 2026-05-06 (156 rows)
We can make this file beautiful and searchable if this error is corrected: It looks like row 4 should actually have 32 columns, instead of 10 in line 3.
id,name,category,selling_price,target_food_cost_percent,is_active,notes,store_id,created_at,updated_at,sku_code,description,prep_time_mins,portion_size,calories,is_bestseller,is_new,image_url,available_on,menu_category_id,serve_type,menu_status,is_beverage,protein_type,grain_type,base_flavor,format_type,manual_cogs,protein_g,carbs_g,fat_g,petpooja_menu_item_id
996f57db-1965-41a4-80f4-7c6a2d794a45,Purple Swirl,Smoothies,395,30,true,,,2026-02-17T17:40:24.724676+00:00,2026-04-17T03:45:12.071372+00:00,,,,,279,false,false,,both,37d3b5ca-95ac-40dc-bb76-80618a4a676a,,CONFIRMED,true,,,,,,,,,70cfd4d5-c30b-4cb3-9f69-845f08859c13
f0013dae-c33b-4c0b-a20e-ae6f7dd35543,Hot Spanish Latte,Coffee - Classic,270,30,true,,,2026-02-17T17:40:28.972225+00:00,2026-04-17T03:45:13.712074+00:00,,,,,,false,false,,both,7c5fd7c5-d09c-444d-8160-a618a3ae8d07,,CONFIRMED,true,,,,,,,,,bb7b280e-694b-44c8-837f-c4c7e3b109ba
be7e6f34-b7f4-4788-8254-e9a12d1fd4d4,Cold Americano,Coffee - Classic,200,30,true,,,2026-02-17T17:40:31.002677+00:00,2026-04-
@akash0631
akash0631 / sfg_recipes_petpooja_canonical_2026-05-06.csv
Created May 26, 2026 12:04
Nubo PetPooja SFG recipes canonical export 2026-05-06 (351 rows)
We can make this file beautiful and searchable if this error is corrected: It looks like row 6 should actually have 9 columns, instead of 2 in line 5.
id,sfg_ingredient_id,component_ingredient_id,quantity,unit,yield_qty,notes,created_at,updated_at
6d208bf5-2725-4200-869e-665b011ed2f0,c881f638-fc7f-4449-92c4-8f4e243e7c42,bf143d9b-17f5-4e48-844c-4bd82dea6139,150,ml,180,Whole Milk per portion,2026-01-18T16:35:43.874785+00:00,2026-02-23T18:39:48.514866+00:00
4bd5cdb2-a5d7-49e9-9167-cf29579c279e,c553bc85-430f-4fe8-8178-3fec3af013bd,196c23df-1271-41a9-80d6-ff495aa2cc9f,1300,g,1000,Petpooja: shredded lettuce,2026-04-17T03:34:08.969555+00:00,2026-04-17T03:34:08.969555+00:00
1c52b42b-4eee-430e-8465-6f59baf0c38a,3a837ae6-cfd4-48fa-bf14-93e67f251921,db316893-d0ef-478d-bace-d6bc7820da5a,18.182,g,1000,Petpooja: Strawberry Compote,2026-04-17T03:34:10.191889+00:00,2026-04-17T03:34:10.191889+00:00
67e36aa0-2259-4ee8-967f-17cf22ed8cd2,3a837ae6-cfd4-48fa-bf14-93e67f251921,bf88fbc3-859d-49ef-a003-23778d1c3eed,909.091,g,1000,Petpooja: Strawberry Compote,2026-04-17T03:34:10.661567+00:00,2026-04-17T03:34:10.661567+00:00
64669f0b-0796-44b5-92f1-e7c7936d0230,7bad89fa-0002-43b4-b45