I am trying to import one list of inventory items into another instance of SambaPOS.
The issue being that the computers are not and cannot be linked. I was thinking along the lines of using SQL Management Studio and editing these in the tables section “Inventory Items”. Is my thinking wrong or would it be possible?
Thereafter this is both for V4 and V5. I personally try it out on V4 and then implement on V5.
Yes, inventory creation takes the longest with setup, I found.
Restaurants use different recipes and combinations so much more personalised, also selling prices vary most of the time. Cutting out this basic but crucial step would save a lot of time.
As an update I found it possibe to copy the tables data as long as it doesn’t clash with a very simple script:
select * into “Database_Name_Destination”.dbo.InventoryItems from “Database_Name_From”.dbo.InventoryItems
I have not tested this yet but will keep you updated and add the entire process once tested and complete.
Further it should be possible to copy the other tables in theory. I think.
So it seems to be working just fine. I must myself state that it is probably not the best fix and that I haven’t tried it with V5 yet.
All of these steps are in completed using SQL Management Studio 2014, on Windows 10 OS.
Change table name “InventoryItems” in Destination database to something else like “InventoryItems_Old”.
Right click on Destination Database and select New Query.
use the following script: select * into “Database_Name_Destination”.dbo.InventoryItems from “Database_Name_From”.dbo.InventoryItems
Execute Script.
Done.
Some notes:
This was between one SambaPOS database and another, so that all of the columns align and what not.
I suggest that a proper Inventory be used for this.
I have not tested this for long.
I cannot ensure that it would work for everybody or that it would be a good thing to do.
Okay SO here is the final working product and Recipes are working. Will put it through some more testing at a later stage.
So it seems to be working just fine. I must myself state that it is probably not the best fix and that I haven’t tried it with V5 yet.
All of these steps are in completed using SQL Management Studio 2014, on Windows 10 OS.
Right click on Destination Database and select New Query.
use the following script:
INSERT INTO SAMBAPOS4_Blank.dbo.InventoryItems
(GroupCode, BaseUnit, TransactionUnit, TransactionUnitMultiplier, Warehouse, DefaultBaseUnitCost, DefaultTransactionUnitCost, Name)
SELECT
GroupCode, BaseUnit, TransactionUnit, TransactionUnitMultiplier, Warehouse, DefaultBaseUnitCost, DefaultTransactionUnitCost, Name
FROM SambaPOS4_Ou_Dorp.dbo.InventoryItems
Execute Script.
Done.
Some notes:
This was between one SambaPOS database and another, so that all of the columns align and what not.
I suggest that a proper Inventory be used for this.
I have not tested this for long.
I cannot ensure that it would work for everybody or that it would be a good thing to do.