WebSite X5Help Center

 
Terry  R.
Terry R.
User

How to add and connect a database to the catalogue  en

Author: Terry R.
Visited 1465, Followers 1, Shared 0  

Hi.

I have added a shopping cart to my website, I want to be able to add a quantity for each item. I beleive I have to create a database, Please can someone guide me through how to add and connect a database. Thanks.

Posted on the
10 ANSWERS - 1 USEFUL
Aleksej H.
Aleksej H.
Moderator

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.

Read more
Posted on the from Aleksej H.
Tom G.
Tom G.
User

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!

Read more
Posted on the from Tom G.
Aleksej H.
Aleksej H.
Moderator

Hello.

  1. Yes.
  2. You do not need to worry about it.The program itself creates the necessary tables with data.
  3. No.Only ID and quantity.
  4. The program itself will fill everything.
  5. Yes. But it depends on your settings.
  6. No. But the product cannot be ordered.

"Is there maybe some document describing all that?" - 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.

Read more
Posted on the from Aleksej H.
Tom G.
Tom G.
User

Thank you Aleksej, very valuable information!

Read more
Posted on the from Tom G.
Tom G.
Tom G.
User

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!

Read more
Posted on the from Tom G.
Christine O.
Christine O.
User

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.

Read more
Posted on the from Christine O.
Tom G.
Tom G.
User

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?

Read more
Posted on the from Tom G.
Axel  
Axel  
User

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

Read more
Posted on the from Axel  
Tom G.
Tom G.
User

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?

Read more
Posted on the from Tom G.
Aleksej H.
Aleksej H.
Moderator

"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.

Read more
Posted on the from Aleksej H.