Thanks Jason,
I think we are ok with the default PayPal email.
As I said, we bought a premium ticket, and we are a little confused.
There we are told that we need INP in order tha we filfull our needs, which is basically to disable add to cart button when our inventory becomes 0 in our SQL database of our products, and activate the button again when the inventory become more than 1.
We want the function triggered not when add button or checkout button is clicked but when the payment process is done. (maybe this is the reason we need IPN?)
Also we were told that we need to get premium support ticket, we think that is the premium ticket we bought there?
The following is the communication history.
Would you make it clear and let us know what we need to do to archave our goal?
---------------------------------------------------------------------------------------------
Technical Support Ticket # 141108
Date Submitted: 03/30/2012 07:30 am
Subject: Add to cart button and inventory
Product: eCart 5
Type: I do not know how to achieve a specific feature with this product.
No Attachments
Dreamweaver, Expression Web, or PHP Version:
DW CS5.5
What You Would Like To Accomplish:
Our products are mainly hand-made single irems, so we like to prevent double orders.
We like to disable add to cart button and replace it with sold out icon when the item is purchased. Once it is sold we like to put another item on the same sku, using dataassist insert page and activate the add to cart button again.
We like to update database inventory and disable add to cart button not when it is clicked but when the payment process is done.
We are using PayPal Standard as the payment gateway.
How You Have Tried To Accomplish This:
It is too complicated for us and we do not want to harm the site we created.
Actual Results:
N/A
Expected Results:
As mentioned above
Additonal Information:
We are using dataassist and security assist along with the ecart.
These requests above involve those extension as well and may not be a single matter, so if we need to buy another ticket please let us know.
Also we have other minor questions such as PayPal IPN, we don't know if we need it or not?
We are using PayPal standard business account.
When checkout page was created we selected PayPal standard (PayPal and Credit Card option).
We are wondering how we can receive orders? Does PayPal send us messages when orders are placed even if we don't use IPN?
Also customers get invoice from paypal so we don't need to send them?
(with paypal standard, we can't send Universal Email receipt I guess?)
We haven't launched the site yet, as we like to have it 100% functional when it is launched.
The site is done, and like to launch once above matters are resolved within this week.
Let us know how we can send the site to you to get the support.
The site is on the local computer using XAMPP.
Finally, we like to have the site all functional when we launch, so please let us know what we need to do to get necessary support.
Thanks,
Phone Number:
201-906-2633
*
Posted By: ray@webassist.com (Ray Borduin) Message 2 in Log
Date: 03/30/2012 05:35 pm No Attachments
Title: RE: Add to cart button and inventory
*
IPN will be necessary for inventory management and would allow you to send an email separately from paypal.
Paypal will send you order emails even without IPN. IPN just allows you to send your own customized email. They will get an invoice from paypal either way.
You will need a premium support ticket to have us work with you directly to implement this. We will credit your purchase of this incident toward a premium ticket.
Just call or email our sales department (sales@webassist.com). Reference this ticket to get the cost subtracted from your premium incident purchase. Then we'll set up a time for a phone call to get this all worked out for you.
*
*
Posted By: chiakioda@verizon.net ( ) Message 3 in Log
Date: 03/30/2012 05:45 pm No Attachments
Title: RE: Add to cart button and inventory
*
I don't understand.
This is the premium ticket we bought, and you closed it with just one response as follows?
I guess we don't need IPN then.
It was just a question
We purchased this ticket to get support as to the matter mentioned above.
--------------------------------------------
Posted By: ray@webassist.com (Ray Borduin) Message 2 in Log
Date: 03/30/2012 05:35 pm No Attachments
Title: RE: Add to cart button and inventory
IPN will be necessary for inventory management and would allow you to send an email separately from paypal.
Paypal will send you order emails even without IPN. IPN just allows you to send your own customized email. They will get an invoice from paypal either way.
You will need a premium support ticket to have us work with you directly to implement this. We will credit your purchase of this incident toward a premium ticket.
Just call or email our sales department (sales@webassist.com). Reference this ticket to get the cost subtracted from your premium incident purchase. Then we'll set up a time for a phone call to get this all worked out for you.
*
*
Posted By: ray@webassist.com (Ray Borduin) Message 4 in Log
Date: 03/30/2012 06:49 pm No Attachments
Title: RE: Add to cart button and inventory
*
This is a premium support ticket, which gives you this thread. I'll close the incident as I respond, but you can re-open it with a post back.
If you want a phone call where we take control of your screen and actually fix the issue for you that is the higher level premium support ticket. Otherwise I will continue to answer your questions through this ticket on this subject.
I think you need IPN to do the inventory reduction automatically.
What other questions can I help with at this time?
*
*
Posted By: chiakioda@verizon.net ( ) Message 5 in Log
Date: 03/30/2012 08:36 pm No Attachments
Title: RE: Add to cart button and inventory
*
Hi Ray, thanks for the quick reply.
I think IPN is for on the PayPal side, and I don't think we need it as long as we have SQL database created by data assist and security assist, using free SQL product database on your site?
As mentioned on the first mesage, what we like to do is;
1: deactivate add to cart button when it is purchased and the inventory on the database becomes 0, and put a sold out icon.
When we insert another item on the same sku number, and the inventory on the database becomes more than 1, activate add to cart button again.
2: We like to do this not when the add button is clicked but when payment process is done. In other words, the inventory on the database is changed only when payment is done, not when the add button is clicked neither the checkout button is clicked.
(the reason is that we don't want to change the inventory and disable add button when customers checking out and decide not to buy them right before payment gateway. )
As our site is not on the hosting server, it is in thr XAMPP, we can send the full site with the database, but the XAMPP folder is over 500M. So if you let me know what folders(files) should be included or excluded besides http/site folder, we will do that.
*
*
Posted By: ray@webassist.com (Ray Borduin) Message 6 in Log
Date: 03/30/2012 08:47 pm No Attachments
Title: RE: Add to cart button and inventory
*
We only work on files directly in premium support tickets. I can advise you on how you can do it with this thread.
You will need IPN to do anything after the transaction including decrease inventory.
You would want to add code to the IPN page that would identify the item as having been sold. It could be as simple as adding a ProductSold column to your database and then setting that to "1" on the ipn page for any items sold.
Then you could update your page with the add to cart button to check the value of the ProductSold field in the database and deactivate the button.
Then you could reset the value to 0 when you add another item with the same sku and that would make it available again.
The only way to do anything after the transaction completes with paypal standard is to use IPN.
