[inv 1.5] Inventory Purchase and Control via PHP

Newest addition to the system: now you can Add & Update Inventory Items using this interface. Populated pick-lists for GroupCode, Base Unit, Transaction Unit so you can select from existing choices. Available in v1.3.


The II screen: (for Adding and Updating Inventory Items)

(2014-12-01) New version 1.5 updated to work with SambaPOS v4.1.73 or later, with support for Additional Units. Config Files have been relocated to their own folder:

/inv/html/zconfigs/configdb.php
/inv/html/zconfigs/configbuttons.php

The PHP code for SambaPOS v4.1.73 or later :
inv1.5.zip (99.9 KB)

(2014-10-20) New version 1.4 updated to work with SambaPOS v4.1.70 thru 4.1.72. Earlier versions (4.1.69 or less) will not work with this release. For earlier versions of SambaPOS, you need to use inv1.3.zip

The PHP code for SambaPOS v4.1.70 or later :
inv1.4.zip (83.2 KB)

The PHP code for SambaPOS v4.1.69 or earlier:
inv1.3.zip (83.1 KB)

4 Likes

how can I import these files and DB for PhP My Admin on Xampp?

You should know this will not let you update previous WP purchases either. What he built was a front end for purchases but it is still bound by the same rules.

phpMyAdmin is a tool for managing MySQL using PHP. This does not use MySQL .

my bad luck, I want to also update the previous WP purchases Either
how can I configure update previous WP purchases Either?

You can’t edit previous WP purchases. You have to use the End of Day records. This is how it is designed.

Yes, it was my problem of understanding, sorry about that

In any case always have to replace the old with a new transaction and edit the inventory.

I could understand, in any case I would like to try the php configuration setting

it seems that did everything right, but my screen so it appears

To be honest if you dont have any experience setting up php on the server end then your going to find it very difficult to use. His setup is very advanced and requires knowledge of PHP and how to setup the server.

That screen means you setup the XAMP server and it is running but you have not setup the PHP files contained in this tutorial correctly on the server.

Yes, I believe I need to know more about PHP on the server.
I read and research more about … and I’ll be back for more …

thank you, Kendash

Basically your webroot you should put everything inside the html folder from his zip file. index.html is your main page.

BTW This is a nice solution for v4. But just to let you know v5 is due out soon and it has this capability built in.

You will still not be able to edit previous WP purchases or make purchases outside a WP.

1 Like

Hello, Can be used for Sambapos V3?

No. Read the first post. This is for V4 only.

Ok, thank you! I’m getting some error with xampp! I cannot put in root folder html files because i have other file and cannot overwrite. I inserted extension file for php, just need to set root folder!

Can’t help you with XAMPP, sorry. I have never used it. I know it is pre-configured to contain Apache as the Webserver and mySql as the DB, along with PHP and phpMyAdmin (web-based management of mySql). The only part of XAMPP that you really need is the PHP installation. The rest is “overkill” and for the most part, unused.

Here is a Tutorial on setting up a basic PHP installation with IIS. It isn’t that difficult once you have done it a couple times, and learned the requirements, some of which are a bit cryptic to troubleshoot at first…

1 Like

can this send an email to the staff responsible for purchasing inventory or a group of people ?

you can use send email action.

@QMcKay

Do you have DB Import for this ?

No. There is no point in having DB Tools import file for this. It would only contain my Supplier Entities and Warehouses, which will be different for you. I suppose I could export the Inventory and Account Transaction Types and Documents, but that is a very simple configuration to do manually.

I gave explanation how to configure the Entities and Warehouses to work with this system. The rest is PHP code running on a Webservice (I use IIS, but Apache would work too).

Thanks Mate

I will give it a try and let you know.