WebSite X5Help Center

 
Philip P.
Philip P.
User

Cart availability stating 0 when published.  en

Autore: Philip P.
Visite 829, Followers 1, Condiviso 0  

Hi

When setting availability I add products and it shows as not available. When testing in website X5 it works, when published to site it shows product as unavailable. Admin test passed, admin shows nothing as low stock, I'll re-check my write folder but it should be all OK an damin passess all tests, database is working, I've processed the order and received the email. Can't see what the issue is but I'm guessing someone knows...

Anyone help please? - Thanks in advance 

Postato il
11 RISPOSTE - 1 CORRETTO
Andre E
Andre E
Moderator

It could be more things....

Are you using the database also on other objects?

For every single object that uses a database you need a seperate database.

Did you upload website after changes in amount, if you made changes to amount you must uooload website to internet.

Hope one of these help you.

Leggi di più
Postato il da Andre E
Philip P.
Philip P.
User
Autore

Hi

I'll double check the database, I created new databases for the site stats, I think originally I did create a new one on the first site which showed the error... I'll do a quick delete, recreate the database, upload the changes and see... check and feed back..... 

Leggi di più
Postato il da Philip P.
Philip P.
Philip P.
User
Autore

Hi

Ok, so I deleted the database, then recreated it so it was empty, changed the password, nothing else is using the database that I can think of and it's only used by website X5 for this domain for datamanagement, I use a seperate database for stats with different user name and password. 

Still comes up as product unavailable if I put stock availability it.

It's OK if I use the available function, just won't allow the stock availability option.

y logic tells me this may be apermissions issue, the program asks me to set thepages to php extention to work when I put the  cart in with the option of stock. so is it a file permissions issue? I'll try this and get back, see if alowing more control of th epage resolves the problem.

Leggi di più
Postato il da Philip P.
Philip P.
Philip P.
User
Autore

Ok

So changing file permissions did nothing.

Page extention is currently php, php write access is functioing, database access and order processing is functioning. 

The stock availability is not functioning unless I set it to available or no information.

?

Leggi di più
Postato il da Philip P.
Philip P.
Philip P.
User
Autore

So the question is more specifically, what does the stock availability option write to and where does it draw its information from or make amendments to. If the database?, php write folder? or some other place? If anothe rfolder perhaps permission s issue again, but it's something blocking the information that states the number of stock, so where is this held? Is there another solution you suggest?

Leggi di più
Postato il da Philip P.
Philip P.
Philip P.
User
Autore

This may help. I decided to do a subfolder site testing, all but this working again. Here is the imported database. I wasn't sure what symbols to use to seperate the data, but I think its all there, I deleted personal info. You may see information, or lack of it that's pertinent to the problem. 

Leggi di più
Postato il da Philip P.
Philip P.
Philip P.
User
Autore

ignore that , it was a prior order, a renewed database has no data in it and  i can't process the order as it says no available stock.. 

so still stumped

Leggi di più
Postato il da Philip P.
Philip P.
Philip P.
User
Autore

I'm back to what does the stock availability option write to and where does it draw its information from or make amendments to. If the database?, php write folder? or some other place? If anothe rfolder perhaps permission s issue again, but it's something blocking the information that states the number of stock, so where is this held? 

When it's originally uploaded it has had no contact with the database, until processed as an order, so what are the files and folders  I need to look at to address the issue..

Leggi di più
Postato il da Philip P.
Philip P.
Philip P.
User
Autore

Ok, anyone else getting this problem, I've resolved it, but I'm not sure what areas get written to resolve it yet. I will try a new database to see if the below process writes to the database on transfer.

I assumed that the FTP transfer may have to write to the site being transferred to as it's putting data somewhere on the initial transfer, so exporting to disk (which is what I was doing) and FTP'ing over later may not do that I thought esp if writing to a database, so I used FTP direct from the program which has now enabled my test subsite to function and it is reducing stock upon placement of the order... so it may be something as simple as the database isnt there to write to so it gets overlooked, so it has to be FTP'd from the program to enable it to write the data directly on transfer. Can't see why else it would be, I will be checkin gto be sure.... but it did the trick... I did need to rewrite the files as the order steps froze, but another FTP from the program resolved that..

Leggi di più
Postato il da Philip P.
Andre E
Andre E
Moderator

Philip,

Let me explain a few thinks.

The stock amount is kept in the database. So you need a single database for the store.

If you change stock (add stock) in x5, you need to update the website, this updates stock info.

If you have sold online you need to push the button in x5 in the shop (step1 shipping card, TAB product list update button) to sync all update.

If this works (update button) then databse connection and database are good

See also: http://help.websitex5.com/en/v16/pro/carrello_prodotti.htm

Don't forget to update webpage with F5 if you visit your site, you browser will then update with latest information.

Something else about the database

Just create an database with your webhost admin panel (not x5 panel) don't set data in it, x5 will do that for you. just name database adress and password, fill these in in x5. That's it

Add items to your database in x5 in the shopping card, then upload, x5 will update database, and then it is visible on your website.

Leggi di più
Postato il da Andre E
Philip P.
Philip P.
User
Autore
Philip P.
Ok, anyone else getting this problem, I've resolved it, but I'm not sure what areas get written to resolve it yet. I will try a new database to see if the below process writes to the database on transfer. I assumed that the FTP transfer may have to write to the site being transferred to as it's putting data somewhere on the initial transfer, so exporting to disk (which is what I was doing) and FTP'ing over later may not do that I thought esp if writing to a database, so I used FTP direct from the program which has now enabled my test subsite to function and it is reducing stock upon placement of the order... so it may be something as simple as the database isnt there to write to so it gets overlooked, so it has to be FTP'd from the program to enable it to write the data directly on transfer. Can't see why else it would be, I will be checking to be sure.... but it did the trick... I did need to rewrite the files as the order steps froze, but another FTP from the program resolved that..

So the upshot of this is initially the database was empty once FTP'd, on checking the cart in the program, it now showed 25 in stock as the starting quantity (the prior stock) so adding stock allowed the cart to function properly. It's sequential, so will show anomalies if you try to start afresh with the same item, so beware if having to delete the server files as the original quantity will be the last put in, but the website quantity will be what you add as it will count the original stock value in the program as "0".  I'm unclear where it intially writes to, it subsequently writes to the database, but the thing works, to resolve i just need to delete the test site products which are imaginary, new database for good measure and then the stock control should take care of itself..

Voila! I've talked myself out of the problem! :)

Leggi di più
Postato il da Philip P.