Jump to content
Sign in to follow this  
Silencer

Virtual Unique Products (AKA PIN and phonecard selling)

Recommended Posts

I haven't used osC or this contrib yet. I need to have items uniquely numbered, like serial numbers, but in quantities up to 10k or even 30k per series/batch of items. Is there a way to generate these numbers automatically, say, with a starting number, and "upload" these "pins" en masse? If i want the series to start with a letter or two, is that possible also, and how many characters can be used? And/or is there a contrib that will generate unique serial numbers for each item sold as it is sold and record the number in the record, with a limit on how many can be sold in a series? Any idea?

 

I also would like to be able to have the system pick one serial number out of each series at random as a winner of a bonus prize and notify me of it by email (but not the customer yet). I could do this manually from sales reports, but a report with 10k or 30k pieces is bulky. I don't know how reporting contribs work; i assume they produce files that can be saved to disk, perhaps comma delimited. In such a case I could put it into Excel and pick one from there, and correlate it to the account number and notify the customer.

 

All help is much appreciated.

Share this post


Link to post
Share on other sites

When i try the code into the paypal module contribution, it didn'y work. Is there any extra setting needed for the paypal module so that i can have the PIN shown in the email?

 

http://www.oscommerce.com/community/contri...erce_paypal_ipn

 

Below is what was in my testing email.

------------------------------------------------------

Order Number: 23

Detailed Invoice: http://www.xxxx.com/catalog/account_histor...php?order_id=23

------------------------------------------------------

 

Call access number

xxxxxxxxxx

Dial - country code + phone number

No need for 011

If you have an problems contact us: xxxx@xxxxcom

 

Date Ordered: Friday 02 June, 2006

 

Products

*************************************

4 x $10 Calling Card () = $40.00

Total: $40.00

 

Billing Address

------------------------------------------------------

and etc.....

 

--------------------------------

Share this post


Link to post
Share on other sites

Is this contribution ready???And....may I know what bugs inside??Need to be repair??

 

If the bugs listed here it may easier for people to identify.

 

Thx

Edited by Rezolles_Net

Share this post


Link to post
Share on other sites
Hello,

 

I need HELP! PLEASE!

 

I've installed this system and it is working, but I can't seem to get the pin numbers after the order has gone through.

 

I didn't receive the download page, it wasn't in my order confirmation and It wasn't on any screen after the order was processed. I just got thrown back to the main catalog page.

 

Is anyone else having this same issue or am I doing something wrong.

 

website is www.marinemomscards.com

 

I would really like to get the PIN along with the access number in an email.

 

I check the system after the test order and I still had the same amount of PINs in the PIN Loader.

 

I also had the same amount in stock.

 

So the order went through, but I never got my pin. :huh:

 

Can anyone help me?

 

 

I experiencing the same problem as you....Anyone got suggestion??

Share this post


Link to post
Share on other sites

Thanx for the contribution.

 

I think contributor should make a package then upload to contribution section.

 

Best regards.

-Arafat Rahman

Web Developer

Dhaka, Bangladesh


Arafat Rahman

Web Developer

Dhaka, Bangladesh

Share this post


Link to post
Share on other sites
Thanx for the contribution.

 

I think contributor should make a package then upload to contribution section.

 

Best regards.

-Arafat Rahman

Web Developer

Dhaka, Bangladesh

 

Mr Arafat,may I know which package you downloading and what did you fix??I mean,if u install the contrib and you done anything else???

 

And,is the contrib working perfectly??Customers get pin code in email or etc??

Share this post


Link to post
Share on other sites

Ya it is working fine.

I installed it and now running on my testing server.


Arafat Rahman

Web Developer

Dhaka, Bangladesh

Share this post


Link to post
Share on other sites

That is because u dont have MVS installed.....Hurm...anyone can solve this problem???MVS + VUP (virtual unique products)?

 

When I select the product....the MVS will create an error says "No shipping selected".Eventhough have set it to one of the shipping method.

Share this post


Link to post
Share on other sites
That is because u dont have MVS installed.....Hurm...anyone can solve this problem???MVS + VUP (virtual unique products)?

 

When I select the product....the MVS will create an error says "No shipping selected".Eventhough have set it to one of the shipping method.

 

Oh !

I don't have MVS installed.


Arafat Rahman

Web Developer

Dhaka, Bangladesh

Share this post


Link to post
Share on other sites
Is this can be use with MVS??

 

Opsssss !

I am not sure.


Arafat Rahman

Web Developer

Dhaka, Bangladesh

Share this post


Link to post
Share on other sites

This module is working fine - i have been using it for 6 months now. And what is MVS??????

Edited by svetur

Share this post


Link to post
Share on other sites
This module is working fine - i have been using it for 6 months now. And what is MVS??????

 

Last version in december has appeared.

What version tried?

Share this post


Link to post
Share on other sites

Thanks for module!

Here some suggestions

On order delete it's desirable to return PIN to stock if 'order status' < 'PIN Show status' i.e. not shown to customer, so PIN not compromised

example

 

#FILE /admin/orders.php

//find

tep_remove_order($oID, $HTTP_POST_VARS['restock']);

//replace with

//VUP vlzstart

// tep_remove_order($oID, $HTTP_POST_VARS['restock']);

$ret = tep_remove_order($oID, $HTTP_POST_VARS['restock']);

if (tep_not_null($ret)){

$messageStack->add_session($ret, 'error');

}

//VUP vlz end

 

 

#FILE /admin/includes/functions/general.php

//////// if you want to return PIN on delete even when 'Restock product quantity' IS NOT CHECKED then

//find

tep_db_query("delete from " . TABLE_ORDERS . " where orders_id = '" . (int)$order_id . "'");

//BEFORE add

//VUP vlz +

//return pins in pool if pin is not shown orders.orders_status <DOWNLOADS_AVAILABLE_STATUS

$ret = '';

$sSQL = 'select orders_status from '.TABLE_ORDERS. " where orders_id = '" . (int)$order_id . "'";

$row = tep_db_fetch_array(tep_db_query($sSQL));

if ($row['orders_status'] < DOWNLOADS_CONTROLLER_ORDERS_STATUS){

tep_db_query('update '.TABLE_PRODUCTS_PINS. " set products_pin_used = '0' where products_pin_used = '" . (int)$order_id . "'");

}else{

$ret = 'PIN could not be returnet into PIN-pool - compromised';

}

//VUP vlz -

 

 

 

/////////// if you want to return PIN on delete ONLY when 'Restock product quantity' CHECKED then

//find

if ($restock == 'on') {

//AFTER ADD

//VUP vlz +

//return pins in pool if pin is not shown orders.orders_status < DOWNLOADS_AVAILABLE_STATUS

$ret = '';

$sSQL = 'select orders_status from '.TABLE_ORDERS. " where orders_id = '" . (int)$order_id . "'";

$row = tep_db_fetch_array(tep_db_query($sSQL));

if ($row['orders_status'] < DOWNLOADS_CONTROLLER_ORDERS_STATUS){

tep_db_query('update '.TABLE_PRODUCTS_PINS. " set products_pin_used = '0' where products_pin_used = '" . (int)$order_id . "'");

}else{

$ret = 'PIN could not be returnet into PIN-pool - compromised';

}

//VUP vlz -

Share this post


Link to post
Share on other sites

in admin - catalog - "Attributes - Add values" when you edit "Products Attributes " and attribute is PIN checkbox displayed as not checked.

some fix in query:

#FILE /admin/products_attributes.php

//find

if (DOWNLOAD_ENABLED == 'true') {

$download_query_raw ="select products_attributes_filename, ............

//INSERT after "select ^^^^^

products_attributes_is_pin,

//so query looks as

"select products_attributes_is_pin,products_attributes_filename,

// ^^^^^^^^^^^^^^^^^^

Share this post


Link to post
Share on other sites
#FILE /admin/includes/functions/general.php

//////// if you want to return PIN on delete even when 'Restock product quantity' IS NOT CHECKED then

//find

tep_db_query("delete from " . TABLE_ORDERS . " where orders_id = '" . (int)$order_id . "'");

//BEFORE add

//VUP vlz +

//return pins in pool if pin is not shown orders.orders_status <DOWNLOADS_AVAILABLE_STATUS

$ret = '';

$sSQL = 'select orders_status from '.TABLE_ORDERS. " where orders_id = '" . (int)$order_id . "'";

$row = tep_db_fetch_array(tep_db_query($sSQL));

if ($row['orders_status'] < DOWNLOADS_CONTROLLER_ORDERS_STATUS){

tep_db_query('update '.TABLE_PRODUCTS_PINS. " set products_pin_used = '0' where products_pin_used = '" . (int)$order_id . "'");

}else{

$ret = 'PIN could not be returnet into PIN-pool - compromised';

}

//VUP vlz -

/////////// if you want to return PIN on delete ONLY when 'Restock product quantity' CHECKED then

//find

if ($restock == 'on') {

//AFTER ADD

//VUP vlz +

//return pins in pool if pin is not shown orders.orders_status < DOWNLOADS_AVAILABLE_STATUS

$ret = '';

$sSQL = 'select orders_status from '.TABLE_ORDERS. " where orders_id = '" . (int)$order_id . "'";

$row = tep_db_fetch_array(tep_db_query($sSQL));

if ($row['orders_status'] < DOWNLOADS_CONTROLLER_ORDERS_STATUS){

tep_db_query('update '.TABLE_PRODUCTS_PINS. " set products_pin_used = '0' where products_pin_used = '" . (int)$order_id . "'");

}else{

$ret = 'PIN could not be returnet into PIN-pool - compromised';

}

//VUP vlz -

//

//find about 10 lines below

tep_db_query("delete from " . TABLE_ORDERS_TOTAL . " where orders_id = '" . (int)$order_id . "'");

}

//INSERT BEFORE "}"

return $ret;

//so it's look like

tep_db_query("delete from " . TABLE_ORDERS_TOTAL . " where orders_id = '" . (int)$order_id . "'");

return $ret;

}

Share this post


Link to post
Share on other sites
in admin - catalog - "Attributes - Add values" when you edit "Products Attributes " and attribute is PIN checkbox displayed as not checked.

some fix in query:

#FILE /admin/products_attributes.php

//find

if (DOWNLOAD_ENABLED == 'true') {

$download_query_raw ="select products_attributes_filename, ............

//INSERT after "select ^^^^^

products_attributes_is_pin,

//so query looks as

"select products_attributes_is_pin,products_attributes_filename,

// ^^^^^^^^^^^^^^^^^^

 

I have a problem with your contrib..

after all changes , when i go to PIN LOADER I cannot see back the pin codes (after restock checked) , any idea ?

thanks,

nimsgone

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×