Bulk Product And Inventory Importer for latest SambaPOS version?

[KuriGohan_And_Kameha]

Hi all,

I would like to know about this tutorial:

SambaPOS 5 Bulk Product and Inventory Importer

##Synopsis This Tool is primarily used as a Bulk Product, Inventory, and Recipe importer based on data read from a CSV file. This is especially useful in Retail applications where there is a direct 1:1 relationship between Items you buy from a supplier and Products you sell. As of this release, this Tool is compatible with the following SambaPOS versions: 5.1.58 - 5.1.60 (DB version 124) ::: dbops124c.zip (24.6 KB) Originally developed by @JohnS for SambaPOS 3, updates to the Tool were dev…

This was made for database version 124c but we are now on 141, any plans to upgrade this tutorial and webpages?

It does not create inventory on the latest version of SambaPOS db

[KuriGohan_And_Kameha]

I tried using this version but i get this error:

[Menu Category] BEARINGS
00008: Inserting: [Barcode] 22-1013 [Product] ALL BALLS STEERING STEM BEARING KIT-30-140-21 (22-1013) ::: [MenuItem] ALL BALLS STEERING STEM BEARING KIT-30-140-21 (22-1013) ... 
INSERTED ::: [Portion] Normal ::: [Price] 91
...... [MenuItem] ALL BALLS STEERING STEM BEARING KIT-30-140-21 (22-1013)
...... [InvItem] 22-1013 - ALL BALLS STEERING STEM BEARING KIT-30-140-21
...... [Recipe.Normal] (SellProd) ALL BALLS STEERING STEM BEARING KIT-30-140-21 (22-1013)
( ! ) Warning: odbc_execute(): SQL error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert the value NULL into column 'ItemType', table 'HATTECHPOSEVODB.dbo.RecipeItems'; column does not allow nulls. INSERT fails., SQL state 23000 in SQLExecute in C:\wamp64\www\dbops_functions.php on line 69
Call Stack
#	Time	Memory	Function	Location
1	0.0024	318480	{main}( )	...\dbops.php:0
2	0.1408	601416	include( 'C:\wamp64\www\dbops_importproducts.php' )	...\dbops.php:498
3	1.0420	717632	ExecQueryP( )	...\dbops_importproducts.php:1070
4	1.0436	719856	odbc_execute ( )	...\dbops_functions.php:69

23000 [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert the value NULL into column 'ItemType', table 'HATTECHPOSEVODB.dbo.RecipeItems'; column does not allow nulls. INSERT fails.
QUERY:
INSERT INTO [RecipeItems] ( [RecipeId] ,[Quantity] ,[InventoryItem_Id] ,[OrderTag] ,[ItemType] ) VALUES (?,?,?,?,?)
QPARMS:
953, 1, 880, , , 
QPARMS:

at the first item with inventory to create.

[JTRTech]

@KuriGohan_And_Kameha

SQL error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert the value NULL into column ‘ItemType’, table ‘HATTECHPOSEVODB.dbo.RecipeItems’; column does not allow nulls.

Thats obviously the problem;

[mjb2000]

It would be great if we could import inventory and recipes using YAML instead of this important tool.

[QMcKay]

@KuriGohan_And_Kameha

i get this error

SQL error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert the value NULL into column ‘ItemType’, table ‘HATTECHPOSEVODB.dbo.RecipeItems’; column does not allow nulls.

Use a text editor to open the file: dbops_readfile.php

Find this line (around 135):

$RecipeItemType[$r] = (($RecipeItemType[$r]!=0 && $RecipeItemType[$r]!=1) ? 0 : $RecipeItemType[$r]);

Replace that line with this:

$RecipeItemType[$r] = ((($RecipeItemType[$r]!=0 && $RecipeItemType[$r]!=1) || $RecipeItemType[$r]=='') ? 0 : $RecipeItemType[$r]);

Save the file and try again.

---

That was noted in the last post in that Topic. I just updated the ZIP file today to contain the fix.

[KuriGohan_And_Kameha]

Thank you very much. I must have missed that post, apologies.