[Looking for recurring auto ship/subscribe for commodity product store]

Given that I have a OSC store that sells stuff you consume, say paperclips, pencils and erasers.

 

I want buyers to be able to schedule recurring shipments of various items with varying frequencies.

 

Example:

 

12 pencils every week

1 box of paperclips every two weeks

5 erasers every month.

 

and / or a combination of the above.

 

Is there a way to do this.

 

Fyi, I'm using PayPal for payment processor.

 

Thanks in advance,

Dave

[Official PayPal IPN Support Thread]

You are using RC2 of oscommerce but Your db fields are not added as needed.

 

Add public_flag field in orders_status.

 

Satish

 

I'm having the following error:

1054 - Unknown column 's.public_flag' in 'where clause'

 

select count(*) as total from orders o, orders_status s where o.customers_id = '7' and o.orders_status = s.orders_status_id and s.language_id = '1' and s.public_flag = '1'

 

I had just created the user account.

 

Do I need to add public_flag field in orders_status? Is this done in phpMyAdmin? Not sure how to do this.

 

Thanks in advance,

Dave