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.

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

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.

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.

?

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?

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. 

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

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

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

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.