Hello.

1) Create a database and database user on your hosting.You can find out how to do this from your hosting provider or its documentation.

2) Connect the base to the program. Connection options you can find out from your hosting provider or its documentation.

3) Set the number of products.

More details can be found in the documentation. In my paid video tutorials you will find a lot of information including the step-by-step creation of a store taking into account product stock availability.

Aleksej,

I have couple of questions for you, regarding database and inventory.

1. Is it SQL database?
2. What is the structure of the database?
3. Is the entire inventory stored in the database?
4. Will that database be filled through WSX5?
5. Is the stock being reduced after each sale?
6. Will the item be removed from the catalog when stock reaches zero?

Is there maybe some document describing all that?

Thank you in advance for your answer!

Thank you Aleksej, very valuable information!

Aleksej,

On the web page I am about to start working on, only single products will be sold. Unique, with stock number of one. The questions you answered above helped me to understand the process, but some other issues came to my mind.

1. When the item is sold, I understand that the number of available stock will be automatically set to zero. Am I right?
2. Will this item still be available for another buyer?
3. After an item is sold, I will have to remove it from the Product List. Will it also be automatically deleted from the database?
4. In order to test the entire selling process, can the payment step be skipped?

Again, I hope to get informative response, like the one before.

Thanks!

1. Once a product has been sold, you must log into the control / admin panel to process the order - when done it will automatically be marked as sold out / unavailable on the product.
2. No, then it cannot be purchased by other customers.
3. When you then remove it from the product list, you need to run an update online and then the database will be updated and the product removed completely from there.
4. When I run such tests, I have my own user with a different email address that I test buy with and I complete all the steps as usual, but I do not pay.Instead I log into the control panel and delete the order there.This way I get checked that everything works and see how it all looks from both my side and the buyer's side.

Thank you, Christine!
So, what will happen when the second customer will try to buy the product before I process the order? Will there be two buyers trying to purchase the only existing item? I so – what then?

And last question: What information should I give the support of my hosting site to create the data base which I will be using for my inventory?

Hello Tom,

Regarding your first question:

"So, what will happen when the second customer will try to buy the product before I process the order? Will there be two buyers trying to purchase the only existing item? I so – what then?"

The first buyer which has valided order (and not the first customer) and has paid is the winner and the order will be flaged by the database.  So the product wil be blocked for other users because not available.

It's a database concept

Enjoy:

https://wsx5.afsoftware.fr

This is great, Axel! Thanks!

Only last questionagain:

What information should I give the support of my hosting site to create the data base which I will be using for my inventory?

"What information should I give the support of my hosting site to create the data base which I will be using for my inventory?" - You can give them nothing.Ask to create a database.They should tell you: hosts, database name, database username, database user password.