Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Serious issue with stock quantity


DELETE MY ACCOUNT NOW

Recommended Posts

Posted

I'm having a serious issue with stock quantity in my store, and after 2 hours of Googling for an answer, I've decided I need to post and ask for help. Here's the situation -

I made a fresh install of Oscommerce and got everything working (or so I thought). I had a friend go in and buy an item as a test. Even though the purchase went through successfully, the store did not deduct the item from my stock amount (which was 1). I searched online, and several forums said that diabling downloads would fix this issue. The trouble is, I offer both downloadable and non-downloadable items. All of my non-downloadable items are one-of-a-kind, and need to be marked as out of stock once they are sold, or removed from the store's listings. Is there any way to solve this issue without disabling downloads? Maybe an option I missed, or a module I can install to fix the issue? It is very important that I be able to have both downloadable and non-downloadable products, and that the non-downloadable products be marked as out of stock after purchase.

Thank you.

DELETE MY ACCOUNT NOW

Posted
In Admin:

 

Configuration > Stock

 

I already went there and set the settings as follows:

 

Check stock level true

Subtract stock true

Allow Checkout false

Mark product out of stock Out of Stock

Stock Re-order level 1

 

Those were the settings at the time of the test purchase. When the purchase was made for an item where there was only one of that item in stock, the store still showed one item availavle afterward, instead of showing "Out of Stock" like it should have.

DELETE MY ACCOUNT NOW

Posted

When you enable downloads you have to make sure that 'virtual' products have a zero weight, and that all non-virtual products are given a weight. Have you done this?

 

Also, what payment method was used. If it was PayPal (using the default Pay Pal module) then the following applies:

 

If you are using the default Pay Pal Module that comes with

osCommerce and are wondering why the orders don't get added

to the database, the stock updated, and that no order

confirmation e-mails get sent out - this is the reason.

 

You are reliant upon the customer hitting the 'Continue'

button on the Pay Pal website at the end of their purchase,

which then returns them to your website, updates the database,

updates the stock quantity, empties their shopping cart,

and sends the order confirmation e-mails out.

 

There are two solutions:

 

1. Use the official osCommerce Pay Pal IPN. This is the

only IPN module which begins with 'osCommerce'. It is

also the only IPN module with a completely new and

free-standing set of files - meaning that you don't

have to edit any other files in order to install it.

 

2. Go to your Pay Pal account, go to Profile, and

sign up for their Auto-Return service - which returns the

customer to your website automatically after a delay of a

few seconds. The return url you must provide is something

like this (adjust as necessary for your website):

 

http://www.yourdomain.com/checkout_process.php

 

Vger

Posted

Yes, my virtual products have a weight of "0", while all non-virtual items have a weight of "0.5" or above.

The payment type used was PayPal, a test run with check/money order worked properly.

I have implimented sollution #2, I will get my friend to test it again and see if that solves the issue. (upon checking, I realized that my auto-return service was taking customers back to my old webstore page.)

DELETE MY ACCOUNT NOW

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...