Virtual Unique Products (AKA PIN and phonecard selling)

[Eric T 0]

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.

[kogyarus 0]

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.....

 

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

[Rezolles_Net 1]

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 November 21, 2006 by Rezolles_Net

[Rezolles_Net 1]

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??

[Rezolles_Net 1]

B

U

M

P

 

Please....Zurik...is your problem solved??and how??

[Rezolles_Net 1]

B

U

M

P

[opurahman 0]

Thanx for the contribution.

 

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

 

Best regards.

-Arafat Rahman

Web Developer

Dhaka, Bangladesh

[Rezolles_Net 1]

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??

[Rezolles_Net 1]

I found out that this contrib cannot working together with MVS contrib...Please be aware for those using MVS.(multi vendor shipping)

[opurahman 0]

Ya it is working fine.

I installed it and now running on my testing server.

[Rezolles_Net 1]

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.

[opurahman 0]

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.

[Rezolles_Net 1]

Then u are lucky >_< Coz......I totally need MVS in my store.. :P....so...i have to sacrifice :P

[opurahman 0]

Virtual Unique Products 0.7 uploaded here

http://www.oscommerce.com/community/contributions,3883

 

* PIN codes edit facility included.

* Products quantity update bug fixed.

 

Enjoy !

[Rezolles_Net 1]

Is this can be use with MVS??

[opurahman 0]

Is this can be use with MVS??

 

Opsssss !

I am not sure.

[svetur 0]

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

Edited January 23, 2007 by svetur

[svetur 0]

"a

Edited January 23, 2007 by svetur

[akora 0]

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?

[akora 0]

.... And what is MVS??????

Multiple Virtual Storage (IBM)

http://linux.icf.bofh.ru/books/1/ch03s02.html

Edited February 8, 2007 by akora

[Zaitsev 0]

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 -

[Zaitsev 0]

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,

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

[Zaitsev 0]

#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;

}

[nimsgone 0]

sorry was not intended for you

Edited May 5, 2007 by nimsgone

[nimsgone 0]

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