search

finn-wa / grocy-trolley

2 stars 0 forks source link

Adding receipt name to imported products fails #67

Closed finn-wa closed 2 years ago

finn-wa commented 2 years ago 
06:47:23.131 | INFO  | FoodstuffsListImporter | Stocking product: Value Methylated Spirits (1L)
06:47:23.133 | DEBUG | GrocyStockService | POST http://192.168.1.2:9283/api/stock/products/621/add
06:47:23.540 | INFO  | FoodstuffsListImporter | Stocking product: Brioche Hamburger Bun (6pk)
06:47:23.542 | DEBUG | GrocyStockService | POST http://192.168.1.2:9283/api/stock/products/594/add
06:47:23.850 | DEBUG | GrocyProductService | GET http://192.168.1.2:9283/api/objects/products
06:47:27.488 | DEBUG | GrocyProductService | GET http://192.168.1.2:9283/api/userfields/products/385
06:47:27.637 | DEBUG | GrocyProductService | PUT http://192.168.1.2:9283/api/userfields/products/385
06:47:27.737 | DEBUG | GrocyProductService | GET http://192.168.1.2:9283/api/objects/products/385
06:47:27.847 | DEBUG | GrocyProductService | PUT http://192.168.1.2:9283/api/objects/products/385
06:47:27.945 | ERROR | main | Error: 400: {"error_message":"SQLSTATE[HY000]: General error: 1 no such column: userfields_id"}
    at GrocyProductService.fetch (C:\Users\Finn\Desktop\grocy\grocy-trolley\build\out\main.js:77560:13)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async GrocyProductService.patchProduct (C:\Users\Finn\Desktop\grocy\grocy-trolley\build\out\main.js:79254:31)
    at async FoodstuffsReceiptImporter.importReceiptListRefs (C:\Users\Finn\Desktop\grocy\grocy-trolley\build\out\main.js:78677:7)
    at async FoodstuffsReceiptImporter.importReceipt (C:\Users\Finn\Desktop\grocy\grocy-trolley\build\out\main.js:78611:7)
    at async Command2.parseAsync (C:\Users\Finn\Desktop\grocy\grocy-trolley\build\out\main.js:70027:9)
finn-wa commented 2 years ago

when importing

[
  { "name": "Banana Cavendish 0.842 kg NET @ $3.50/kg", "amount": 2.95 },
  { "name": "Kelloggs Coco Pops Chex 500g", "amount": 6.0 },
  { "name": "Kelloggs Nutri Grain 435g", "amount": 6.0 },
  { "name": "Karajoz Barista Prfsnal 750g", "amount": 20.6 },
  { "name": "CD Milk Standard 2L", "amount": 3.91 },
  { "name": "Kea Cookies Glu/FreeMini Choc 210g", "amount": 5.2 },
  { "name": "Naked Loc East Coast Swtoorn Chwder 500g", "amount": 5.0 },
  { "name": "Quorn Mince 300g", "amount": 9.0 },
  { "name": "Freyas Bread Soy/linseed 750gm", "amount": 3.7 },
  { "name": "Whitakers PassionfrtAnd Chamomile 100g", "amount": 4.0 },
  { "name": "Auntie Dai DumplingsVegetarian 600g", "amount": 9.0 },
  { "name": "The Collective Yog Straight Up 900g", "amount": 7.0 },
  { "name": "Nestle Milo 310g", "amount": 4.5 },
  { "name": "Mother Earth Soy MixTomato & Herb 130g", "amount": 3.3 },
  { "name": "Eta Cornados Smokey BBQ 100g", "amount": 2.8 },
  { "name": "So Good UHT Barista Almond", "amount": 5.6 },
  { "name": "Quarterpast Turmeric Lemon 250ml", "amount": 5.99 },
  { "name": "Lotus Biscuit 250g", "amount": 3.5 },
  { "name": "Griffins Toffe Pops Double Choc 200g", "amount": 3.9 },
  { "name": "UP&GO Dairy Free Vanilla 3x250ml", "amount": 5.4 },
  { "name": "Pop N Good Popping Corn 500gm", "amount": 3.0 },
  { "name": "Mother Earth Oat Slice Banofee 240g", "amount": 3.5 },
  { "name": "Artisano Minestrone Soup 500g", "amount": 4.0 },
  { "name": "Bean Supreme Totu Ginger & Honey 375g", "amount": 6.5 },
  { "name": "Delmaine Biscuits Stroopwafels 315g", "amount": 3.5 },
  { "name": "Golden Crumpet ToastCinnamon Burst 600g", "amount": 4.5 },
  { "name": "Just Hummus 175g", "amount": 3.0 },
  { "name": "Qty 2 @ $1.80 each", "amount": 3.6 },
  { "name": "Grape Mix 500g pk", "amount": 4.0 }
]
√ Import products? ... yes
10:58:42.332 | DEBUG | FoodstuffsListService | GET https://www.paknsave.co.nz/CommonApi/Cart/Index
10:58:42.702 | DEBUG | FoodstuffsListService | GET https://www.paknsave.co.nz/CommonApi/ShoppingLists/GetLists
√ Select list » Create new list
√ Enter a name for your new list: ... 01-06 shop
10:58:54.133 | DEBUG | FoodstuffsListService | PUT https://www.paknsave.co.nz/CommonApi/ShoppingLists/CreateList?name=01-06+shop
10:58:54.525 | DEBUG | FoodstuffsListService | GET https://www.paknsave.co.nz/CommonApi/ShoppingLists/GetList?id=f828f61d-8052-4ece-917b-d821b2afae97
10:58:54.827 | DEBUG | FoodstuffsListService | POST https://www.paknsave.co.nz/CommonApi/ShoppingLists/UpdateList
10:58:55.342 | DEBUG | FoodstuffsListService | GET https://www.paknsave.co.nz/CommonApi/ShoppingLists/GetList?id=f828f61d-8052-4ece-917b-d821b2afae97
10:58:57.435 | DEBUG | GrocyProductService | GET http://192.168.1.2:9283/api/objects/products
10:58:57.694 | DEBUG | GrocyProductService | GET http://192.168.1.2:9283/api/objects/products
√ Select parent product for Coco Pops Chex Breakfast Cereal » Cereal (Generic)
10:59:02.402 | INFO  | FoodstuffsUserSearchAgent | Searching Foodstuffs: 5017640-EA-000
10:59:02.403 | DEBUG | FoodstuffsUserSearchAgent | POST https://www.paknsave.co.nz/CommonApi/SearchAutoComplete/AutoComplete
10:59:02.611 | INFO  | FoodstuffsListImporter | Importing product Kellogg's Coco Pops Chex Breakfast Cereal (290g)...
10:59:02.612 | DEBUG | GrocyProductService | POST http://192.168.1.2:9283/api/objects/products
10:59:02.688 | DEBUG | GrocyProductService | PUT http://192.168.1.2:9283/api/userfields/products/762
10:59:02.745 | DEBUG | GrocyProductService | POST http://192.168.1.2:9283/api/objects/quantity_unit_conversions
√ Select parent product for Nutri Grain Gold Honey Crunch Breakfast Cereal » Cereal (Generic)
10:59:15.467 | INFO  | FoodstuffsUserSearchAgent | Searching Foodstuffs: 5287938-EA-000
10:59:15.468 | DEBUG | FoodstuffsUserSearchAgent | POST https://www.paknsave.co.nz/CommonApi/SearchAutoComplete/AutoComplete
10:59:15.723 | INFO  | FoodstuffsListImporter | Importing product Kellogg's Nutri Grain Gold Honey Crunch Breakfast Cereal (435g)...
10:59:15.723 | DEBUG | GrocyProductService | POST http://192.168.1.2:9283/api/objects/products
10:59:15.808 | DEBUG | GrocyProductService | PUT http://192.168.1.2:9283/api/userfields/products/763
10:59:15.886 | DEBUG | GrocyProductService | POST http://192.168.1.2:9283/api/objects/quantity_unit_conversions
√ Select parent product for Oomph! Fair Trade Organic Fresh Whole Beans Coffee » Coffee Beans (Generic)
10:59:18.139 | INFO  | FoodstuffsUserSearchAgent | Searching Foodstuffs: 5085396-EA-000
10:59:18.140 | DEBUG | FoodstuffsUserSearchAgent | POST https://www.paknsave.co.nz/CommonApi/SearchAutoComplete/AutoComplete
10:59:18.321 | INFO  | FoodstuffsListImporter | Importing product Hummingbird Oomph! Fair Trade Organic Fresh Whole Beans Coffee (500g)...
10:59:18.321 | DEBUG | GrocyProductService | POST http://192.168.1.2:9283/api/objects/products
10:59:18.391 | DEBUG | GrocyProductService | PUT http://192.168.1.2:9283/api/userfields/products/764
10:59:18.454 | DEBUG | GrocyProductService | POST http://192.168.1.2:9283/api/objects/quantity_unit_conversions
10:59:18.504 | INFO  | FoodstuffsUserSearchAgent | Searching Foodstuffs: 5017284-EA-000
10:59:19.147 | DEBUG | FoodstuffsUserSearchAgent | POST https://www.paknsave.co.nz/CommonApi/SearchAutoComplete/AutoComplete
10:59:19.350 | INFO  | FoodstuffsListImporter | Importing product Kea Cookies Gluten Free Delicious Homestyle Choc Chip Cookies (250g)...
10:59:19.351 | DEBUG | GrocyProductService | POST http://192.168.1.2:9283/api/objects/products
10:59:19.426 | DEBUG | GrocyProductService | PUT http://192.168.1.2:9283/api/userfields/products/765
10:59:19.485 | DEBUG | GrocyProductService | POST http://192.168.1.2:9283/api/objects/quantity_unit_conversions
10:59:19.528 | INFO  | FoodstuffsUserSearchAgent | Searching Foodstuffs: 5019362-EA-000
10:59:20.162 | DEBUG | FoodstuffsUserSearchAgent | POST https://www.paknsave.co.nz/CommonApi/SearchAutoComplete/AutoComplete
10:59:20.382 | INFO  | FoodstuffsListImporter | Importing product Naked Locals Gisborne Tomato Soup (500g)...
10:59:20.382 | DEBUG | GrocyProductService | POST http://192.168.1.2:9283/api/objects/products
10:59:20.452 | DEBUG | GrocyProductService | PUT http://192.168.1.2:9283/api/userfields/products/766
10:59:20.508 | DEBUG | GrocyProductService | POST http://192.168.1.2:9283/api/objects/quantity_unit_conversions
10:59:20.553 | INFO  | FoodstuffsUserSearchAgent | Searching Foodstuffs: 5021200-EA-000
10:59:21.170 | DEBUG | FoodstuffsUserSearchAgent | POST https://www.paknsave.co.nz/CommonApi/SearchAutoComplete/AutoComplete
10:59:21.350 | INFO  | FoodstuffsListImporter | Importing product Quorn Mince Vegetarian Frozen Meal (300g)...
10:59:21.351 | DEBUG | GrocyProductService | POST http://192.168.1.2:9283/api/objects/products
10:59:21.417 | DEBUG | GrocyProductService | PUT http://192.168.1.2:9283/api/userfields/products/767
10:59:21.475 | DEBUG | GrocyProductService | POST http://192.168.1.2:9283/api/objects/quantity_unit_conversions
10:59:21.521 | INFO  | FoodstuffsUserSearchAgent | Searching Foodstuffs: 5301990-EA-000
10:59:22.183 | DEBUG | FoodstuffsUserSearchAgent | POST https://www.paknsave.co.nz/CommonApi/SearchAutoComplete/AutoComplete
10:59:22.354 | INFO  | FoodstuffsListImporter | Importing product Whittaker's Relax Chamomile and Passionfruit Creamy Milk Chocolate Block (100g)...
10:59:22.355 | DEBUG | GrocyProductService | POST http://192.168.1.2:9283/api/objects/products
10:59:22.424 | DEBUG | GrocyProductService | PUT http://192.168.1.2:9283/api/userfields/products/768
10:59:22.480 | DEBUG | GrocyProductService | POST http://192.168.1.2:9283/api/objects/quantity_unit_conversions
10:59:22.524 | INFO  | FoodstuffsUserSearchAgent | Searching Foodstuffs: 5017803-EA-000
10:59:23.197 | DEBUG | FoodstuffsUserSearchAgent | POST https://www.paknsave.co.nz/CommonApi/SearchAutoComplete/AutoComplete
10:59:23.368 | INFO  | FoodstuffsListImporter | Importing product The Collective Unsweetened Natural Probiotic Yoghurt (900g)...
10:59:23.369 | DEBUG | GrocyProductService | POST http://192.168.1.2:9283/api/objects/products
10:59:23.437 | DEBUG | GrocyProductService | PUT http://192.168.1.2:9283/api/userfields/products/769
10:59:23.496 | DEBUG | GrocyProductService | POST http://192.168.1.2:9283/api/objects/quantity_unit_conversions
10:59:23.540 | INFO  | FoodstuffsUserSearchAgent | Searching Foodstuffs: 5004634-EA-000
10:59:24.210 | DEBUG | FoodstuffsUserSearchAgent | POST https://www.paknsave.co.nz/CommonApi/SearchAutoComplete/AutoComplete
10:59:24.479 | INFO  | FoodstuffsListImporter | Importing product Nestle Milo Energy Drink (310g)...
10:59:24.480 | DEBUG | GrocyProductService | POST http://192.168.1.2:9283/api/objects/products
10:59:24.553 | DEBUG | GrocyProductService | PUT http://192.168.1.2:9283/api/userfields/products/770
10:59:24.609 | DEBUG | GrocyProductService | POST http://192.168.1.2:9283/api/objects/quantity_unit_conversions
10:59:24.662 | INFO  | FoodstuffsUserSearchAgent | Searching Foodstuffs: 5023103-EA-000
10:59:25.223 | DEBUG | FoodstuffsUserSearchAgent | POST https://www.paknsave.co.nz/CommonApi/SearchAutoComplete/AutoComplete
10:59:25.444 | INFO  | FoodstuffsListImporter | Importing product Mother Earth Lightly Salted Soy Mix (130g)...
10:59:25.445 | DEBUG | GrocyProductService | POST http://192.168.1.2:9283/api/objects/products
10:59:25.517 | DEBUG | GrocyProductService | PUT http://192.168.1.2:9283/api/userfields/products/771
10:59:25.573 | DEBUG | GrocyProductService | POST http://192.168.1.2:9283/api/objects/quantity_unit_conversions
10:59:25.618 | INFO  | FoodstuffsUserSearchAgent | Searching Foodstuffs: 5300249-EA-000
10:59:26.236 | DEBUG | FoodstuffsUserSearchAgent | POST https://www.paknsave.co.nz/CommonApi/SearchAutoComplete/AutoComplete
10:59:26.400 | INFO  | FoodstuffsListImporter | Importing product Eta Cornados Smoky BBQ Corn Snacks (100g)...
10:59:26.401 | DEBUG | GrocyProductService | POST http://192.168.1.2:9283/api/objects/products
10:59:26.471 | DEBUG | GrocyProductService | PUT http://192.168.1.2:9283/api/userfields/products/772
10:59:26.530 | DEBUG | GrocyProductService | POST http://192.168.1.2:9283/api/objects/quantity_unit_conversions
10:59:26.574 | INFO  | FoodstuffsUserSearchAgent | Searching Foodstuffs: 5231975-EA-000
10:59:27.247 | DEBUG | FoodstuffsUserSearchAgent | POST https://www.paknsave.co.nz/CommonApi/SearchAutoComplete/AutoComplete
10:59:27.454 | INFO  | FoodstuffsListImporter | Importing product Quarterpast Turmeric Lemon Ginger & Honey Real Fruit Infusion (250mL)...
10:59:27.455 | DEBUG | GrocyProductService | POST http://192.168.1.2:9283/api/objects/products
10:59:27.525 | DEBUG | GrocyProductService | PUT http://192.168.1.2:9283/api/userfields/products/773
10:59:27.589 | DEBUG | GrocyProductService | POST http://192.168.1.2:9283/api/objects/quantity_unit_conversions
10:59:27.635 | INFO  | FoodstuffsUserSearchAgent | Searching Foodstuffs: 5286646-EA-000
10:59:28.257 | DEBUG | FoodstuffsUserSearchAgent | POST https://www.paknsave.co.nz/CommonApi/SearchAutoComplete/AutoComplete
10:59:28.460 | INFO  | FoodstuffsListImporter | Importing product Lotus Biscoff Biscuit (250g)...
10:59:28.461 | DEBUG | GrocyProductService | POST http://192.168.1.2:9283/api/objects/products
10:59:28.535 | DEBUG | GrocyProductService | PUT http://192.168.1.2:9283/api/userfields/products/774
10:59:28.592 | DEBUG | GrocyProductService | POST http://192.168.1.2:9283/api/objects/quantity_unit_conversions
√ Select parent product for Original Chocolate Biscuits » Biscuits (Generic)
10:59:34.133 | INFO  | FoodstuffsUserSearchAgent | Searching Foodstuffs: 5010453-EA-000
10:59:34.134 | DEBUG | FoodstuffsUserSearchAgent | POST https://www.paknsave.co.nz/CommonApi/SearchAutoComplete/AutoComplete
10:59:34.348 | INFO  | FoodstuffsListImporter | Importing product Griffin's Toffee Pops Original Chocolate Biscuits (200g)...
10:59:34.349 | DEBUG | GrocyProductService | POST http://192.168.1.2:9283/api/objects/products
10:59:34.432 | DEBUG | GrocyProductService | PUT http://192.168.1.2:9283/api/userfields/products/775
10:59:34.489 | DEBUG | GrocyProductService | POST http://192.168.1.2:9283/api/objects/quantity_unit_conversions
10:59:34.533 | INFO  | FoodstuffsUserSearchAgent | Searching Foodstuffs: 5280365-EA-000
10:59:35.149 | DEBUG | FoodstuffsUserSearchAgent | POST https://www.paknsave.co.nz/CommonApi/SearchAutoComplete/AutoComplete
10:59:35.355 | INFO  | FoodstuffsListImporter | Importing product Sanitarium Up & Go Dairy Free Vanilla Flavour Liquid Breakfast (3pk)...
10:59:35.356 | DEBUG | GrocyProductService | POST http://192.168.1.2:9283/api/objects/products
10:59:35.427 | DEBUG | GrocyProductService | PUT http://192.168.1.2:9283/api/userfields/products/776
10:59:35.486 | INFO  | FoodstuffsUserSearchAgent | Searching Foodstuffs: 5216680-EA-000
10:59:36.162 | DEBUG | FoodstuffsUserSearchAgent | POST https://www.paknsave.co.nz/CommonApi/SearchAutoComplete/AutoComplete
10:59:36.312 | INFO  | FoodstuffsListImporter | Importing product Value Popping Corn (300g)...
10:59:36.313 | DEBUG | GrocyProductService | POST http://192.168.1.2:9283/api/objects/products
10:59:36.391 | DEBUG | GrocyProductService | PUT http://192.168.1.2:9283/api/userfields/products/777
10:59:36.452 | DEBUG | GrocyProductService | POST http://192.168.1.2:9283/api/objects/quantity_unit_conversions
10:59:36.511 | INFO  | FoodstuffsUserSearchAgent | Searching Foodstuffs: 5027499-EA-000
10:59:37.174 | DEBUG | FoodstuffsUserSearchAgent | POST https://www.paknsave.co.nz/CommonApi/SearchAutoComplete/AutoComplete
10:59:37.349 | INFO  | FoodstuffsListImporter | Importing product Artisano Hearty Minestrone Soup (500g)...
10:59:37.349 | DEBUG | GrocyProductService | POST http://192.168.1.2:9283/api/objects/products
10:59:37.424 | DEBUG | GrocyProductService | PUT http://192.168.1.2:9283/api/userfields/products/778
10:59:37.481 | DEBUG | GrocyProductService | POST http://192.168.1.2:9283/api/objects/quantity_unit_conversions
√ Select parent product for Ginger & Honey Marinated Tofu » Tofu (Generic)
10:59:40.301 | INFO  | FoodstuffsUserSearchAgent | Searching Foodstuffs: 5268864-EA-000
10:59:40.302 | DEBUG | FoodstuffsUserSearchAgent | POST https://www.paknsave.co.nz/CommonApi/SearchAutoComplete/AutoComplete
10:59:40.515 | INFO  | FoodstuffsListImporter | Importing product Bean Supreme Ginger & Honey Marinated Tofu (375g)...
10:59:40.515 | DEBUG | GrocyProductService | POST http://192.168.1.2:9283/api/objects/products
10:59:40.585 | DEBUG | GrocyProductService | PUT http://192.168.1.2:9283/api/userfields/products/779
10:59:40.643 | DEBUG | GrocyProductService | POST http://192.168.1.2:9283/api/objects/quantity_unit_conversions
10:59:40.686 | INFO  | FoodstuffsUserSearchAgent | Searching Foodstuffs: 5286702-EA-000
10:59:41.309 | DEBUG | FoodstuffsUserSearchAgent | POST https://www.paknsave.co.nz/CommonApi/SearchAutoComplete/AutoComplete
10:59:41.522 | INFO  | FoodstuffsListImporter | Importing product Golden Cinnamon Burst Crumpet Toast (600g)...
10:59:41.523 | DEBUG | GrocyProductService | POST http://192.168.1.2:9283/api/objects/products
10:59:41.593 | DEBUG | GrocyProductService | PUT http://192.168.1.2:9283/api/userfields/products/780
10:59:41.650 | DEBUG | GrocyProductService | POST http://192.168.1.2:9283/api/objects/quantity_unit_conversions
10:59:41.695 | INFO  | FoodstuffsUserSearchAgent | Searching Foodstuffs: 5001745-EA-000
10:59:42.320 | DEBUG | FoodstuffsUserSearchAgent | POST https://www.paknsave.co.nz/CommonApi/SearchAutoComplete/AutoComplete
10:59:42.632 | INFO  | FoodstuffsListImporter | Importing product Lisa's Original Hummus With Garlic & Lemon (200g)...
10:59:42.632 | DEBUG | GrocyProductService | POST http://192.168.1.2:9283/api/objects/products
10:59:42.715 | DEBUG | GrocyProductService | PUT http://192.168.1.2:9283/api/userfields/products/781
10:59:42.776 | DEBUG | GrocyProductService | POST http://192.168.1.2:9283/api/objects/quantity_unit_conversions
√ Stock imported products? ... yes
10:59:45.393 | DEBUG | GrocyProductService | GET http://192.168.1.2:9283/api/objects/products
10:59:45.713 | INFO  | FoodstuffsListImporter | Stocking product: Bananas (ea)
10:59:45.714 | DEBUG | GrocyStockService | POST http://192.168.1.2:9283/api/stock/products/402/add
10:59:45.935 | INFO  | FoodstuffsListImporter | Stocking product: Kellogg's Coco Pops Chex Breakfast Cereal (290g)
10:59:45.936 | DEBUG | GrocyStockService | POST http://192.168.1.2:9283/api/stock/products/762/add
10:59:46.159 | INFO  | FoodstuffsListImporter | Stocking product: Kellogg's Nutri Grain Gold Honey Crunch Breakfast Cereal (435g)
10:59:46.160 | DEBUG | GrocyStockService | POST http://192.168.1.2:9283/api/stock/products/763/add
10:59:46.404 | INFO  | FoodstuffsListImporter | Stocking product: Hummingbird Oomph! Fair Trade Organic Fresh Whole Beans Coffee (500g)
10:59:46.405 | DEBUG | GrocyStockService | POST http://192.168.1.2:9283/api/stock/products/764/add
10:59:46.628 | INFO  | FoodstuffsListImporter | Stocking product: Value Standard Milk (2L)
10:59:46.628 | DEBUG | GrocyStockService | POST http://192.168.1.2:9283/api/stock/products/533/add
10:59:46.851 | INFO  | FoodstuffsListImporter | Stocking product: Kea Cookies Gluten Free Delicious Homestyle Choc Chip Cookies (250g)
10:59:46.852 | DEBUG | GrocyStockService | POST http://192.168.1.2:9283/api/stock/products/765/add
10:59:47.075 | INFO  | FoodstuffsListImporter | Stocking product: Naked Locals Gisborne Tomato Soup (500g)
10:59:47.076 | DEBUG | GrocyStockService | POST http://192.168.1.2:9283/api/stock/products/766/add
10:59:47.312 | INFO  | FoodstuffsListImporter | Stocking product: Quorn Mince Vegetarian Frozen Meal (300g)
10:59:47.313 | DEBUG | GrocyStockService | POST http://192.168.1.2:9283/api/stock/products/767/add
10:59:47.537 | INFO  | FoodstuffsListImporter | Stocking product: Freya's Swiss Soya Linseed Bread (750g)
10:59:47.537 | DEBUG | GrocyStockService | POST http://192.168.1.2:9283/api/stock/products/732/add
10:59:47.761 | INFO  | FoodstuffsListImporter | Stocking product: Whittaker's Relax Chamomile and Passionfruit Creamy Milk Chocolate Block (100g)
10:59:47.762 | DEBUG | GrocyStockService | POST http://192.168.1.2:9283/api/stock/products/768/add
10:59:47.983 | INFO  | FoodstuffsListImporter | Stocking product: Juicy Vegetarian Chinese Dumplings (450g)
10:59:47.983 | DEBUG | GrocyStockService | POST http://192.168.1.2:9283/api/stock/products/534/add
10:59:48.220 | INFO  | FoodstuffsListImporter | Stocking product: The Collective Unsweetened Natural Probiotic Yoghurt (900g)
10:59:48.220 | DEBUG | GrocyStockService | POST http://192.168.1.2:9283/api/stock/products/769/add
10:59:48.444 | INFO  | FoodstuffsListImporter | Stocking product: Nestle Milo Energy Drink (310g)
10:59:48.445 | DEBUG | GrocyStockService | POST http://192.168.1.2:9283/api/stock/products/770/add
10:59:48.669 | INFO  | FoodstuffsListImporter | Stocking product: Mother Earth Lightly Salted Soy Mix (130g)
10:59:48.670 | DEBUG | GrocyStockService | POST http://192.168.1.2:9283/api/stock/products/771/add
10:59:48.897 | INFO  | FoodstuffsListImporter | Stocking product: Eta Cornados Smoky BBQ Corn Snacks (100g)
10:59:48.898 | DEBUG | GrocyStockService | POST http://192.168.1.2:9283/api/stock/products/772/add
10:59:49.124 | INFO  | FoodstuffsListImporter | Stocking product: Sanitarium So Good Barista Edition Almond Milk For Coffee (1L)
10:59:49.125 | DEBUG | GrocyStockService | POST http://192.168.1.2:9283/api/stock/products/722/add
10:59:49.364 | INFO  | FoodstuffsListImporter | Stocking product: Quarterpast Turmeric Lemon Ginger & Honey Real Fruit Infusion (250mL)
10:59:49.365 | DEBUG | GrocyStockService | POST http://192.168.1.2:9283/api/stock/products/773/add
10:59:49.587 | INFO  | FoodstuffsListImporter | Stocking product: Lotus Biscoff Biscuit (250g)
10:59:49.588 | DEBUG | GrocyStockService | POST http://192.168.1.2:9283/api/stock/products/774/add
10:59:49.817 | INFO  | FoodstuffsListImporter | Stocking product: Griffin's Toffee Pops Original Chocolate Biscuits (200g)
10:59:49.818 | DEBUG | GrocyStockService | POST http://192.168.1.2:9283/api/stock/products/775/add
10:59:50.042 | INFO  | FoodstuffsListImporter | Stocking product: Sanitarium Up & Go Dairy Free Vanilla Flavour Liquid Breakfast (3pk)
10:59:50.043 | DEBUG | GrocyStockService | POST http://192.168.1.2:9283/api/stock/products/776/add
10:59:50.279 | INFO  | FoodstuffsListImporter | Stocking product: Value Popping Corn (300g)
10:59:50.279 | DEBUG | GrocyStockService | POST http://192.168.1.2:9283/api/stock/products/777/add
10:59:50.501 | INFO  | FoodstuffsListImporter | Stocking product: Artisano Hearty Minestrone Soup (500g)
10:59:50.502 | DEBUG | GrocyStockService | POST http://192.168.1.2:9283/api/stock/products/778/add
10:59:50.725 | INFO  | FoodstuffsListImporter | Stocking product: Bean Supreme Ginger & Honey Marinated Tofu (375g)
10:59:50.726 | DEBUG | GrocyStockService | POST http://192.168.1.2:9283/api/stock/products/779/add
10:59:50.953 | INFO  | FoodstuffsListImporter | Stocking product: Golden Cinnamon Burst Crumpet Toast (600g)
10:59:50.954 | DEBUG | GrocyStockService | POST http://192.168.1.2:9283/api/stock/products/780/add
10:59:51.182 | INFO  | FoodstuffsListImporter | Stocking product: Lisa's Original Hummus With Garlic & Lemon (200g)
10:59:51.183 | DEBUG | GrocyStockService | POST http://192.168.1.2:9283/api/stock/products/781/add
10:59:51.424 | INFO  | FoodstuffsListImporter | Stocking product: Seedless Green Grapes (g)
10:59:51.425 | DEBUG | GrocyStockService | POST http://192.168.1.2:9283/api/stock/products/378/add
10:59:51.653 | DEBUG | GrocyProductService | GET http://192.168.1.2:9283/api/objects/products
10:59:51.992 | DEBUG | GrocyProductService | GET http://192.168.1.2:9283/api/userfields/products/402
10:59:52.036 | DEBUG | GrocyProductService | PUT http://192.168.1.2:9283/api/userfields/products/402
10:59:52.080 | DEBUG | GrocyProductService | GET http://192.168.1.2:9283/api/objects/products/402
10:59:52.106 | DEBUG | GrocyProductService | PUT http://192.168.1.2:9283/api/objects/products/402
10:59:52.140 | ERROR | main | Error: 400: {"error_message":"SQLSTATE[HY000]: General error: 1 no such column: userfields_id"}
    at GrocyProductService.fetch (C:\Users\Finn\Desktop\grocy\grocy-trolley\build\out\main.js:72794:13)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async GrocyProductService.patchProduct (C:\Users\Finn\Desktop\grocy\grocy-trolley\build\out\main.js:74586:31)
    at async FoodstuffsReceiptImporter.importReceiptListRefs (C:\Users\Finn\Desktop\grocy\grocy-trolley\build\out\main.js:73932:7)
    at async FoodstuffsReceiptImporter.importReceipt (C:\Users\Finn\Desktop\grocy\grocy-trolley\build\out\main.js:73866:7)
    at async Command2.parseAsync (C:\Users\Finn\Desktop\grocy\grocy-trolley\build\out\main.js:71647:9)