close ad
Help us test the new Databridge BETA with MySQLi support
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

item stock

Thread began 1/10/2012 12:19 am by chiakioda428401 | Last modified 1/19/2012 3:21 pm by chiakioda428401 | 909 views | 6 replies |

chiakioda428401

item stock

just quick question.
using data assist with ecart5, inserting products on mysql database,
what happens if the item stock is 1 and the last one is added to the cart?
In other words, does the ecart look for the inventory column and updates it, and when it became 0 it automatically prevents from purchasing?

Sign in to reply to this post

Ian S

It really depends on how you design your store.

There are different solutions that you can put in place for this

a) A 'holding' table, that reserves stock items until purchase is made or a timeout occurs
b) Using Session variables to store details of quantities of items in your cart. The quantity shown to the user then subtracts the Session Variable from the the quantity in the database. This solution will only work for the current user though - on another machine or browser session the quantities won't take into account whats in their basket.

Cheers
Ian

Sign in to reply to this post

chiakioda428401

Hi Ian
Thank you for yourvresponse,
Can you be specific?
In the default of the ecart5, in other words if I don't don't make any change for item stock, how does it act?
In default it is linked to the database of the ProductStock column and update the item quantity automatically? And if the ProductStock column become 0, does the ecart prevent customers to add/or purchase the item we don't have?
We are using the database presented by webassist, eCommerce mySQL Database.
Thank you,

Sign in to reply to this post

Ray BorduinWebAssist

No, eCart will not manage stock for you automatically. Stock considerations need to be added manually.

The way that I have typically added stock management to eCart sites is to have a stock field and a stock update date field in the database.

Then since eCart will log any sales you can use SQL to subtract sales after the stock update date from the available stock without having to adjust the checkout process or what is stored during it.

Then you just need to update your product results, details, and shopping cart pages to account for out of stock items however you want to. Either not adding it, not showing it, or adding it with a message that delivery might be delayed.

Sign in to reply to this post

chiakioda428401

hi ray, thank you for the info,
I think it is better that I purchase the support ticket for that.
Do you think we can accomplish that through the support ticket?
Which support ticket should we use? premier or premium?
Our item is unique basically and only one in stock, so it it is sold we like to prevent customers to purchase, and preferably switch the add to cart button to sold out icon automatically. However some of the products have more than one in stock.
Right now, we are using the free sql database you present, Free eCommerce MySQL Database, and I think it has all columns we weed except for stock update date column, which we can add to it?
Thanks,

Sign in to reply to this post

Ray BorduinWebAssist

I have done this before in a half hour premium support ticket, so that would be what you should purchase.

Sign in to reply to this post

chiakioda428401

hi ray,
thank you, we will buy the premium ticket after finishing the site.
we are now updating the database, and adding another function on the cart, making log-in page and email receipt etc, for which we might need another support.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...