Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Virtual Unique Products (AKA PIN and phonecard selling)


Silencer

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.

Link to comment
Share on other sites

  • 3 months later...
  • Replies 64
  • Created
  • Last Reply

Top Posters In This Topic

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

 

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

Link to comment
Share on other sites

  • 2 weeks later...
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??

Link to comment
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

Link to comment
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??

Link to comment
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.

Link to comment
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

Link to comment
Share on other sites

  • 1 month later...
  • 3 weeks later...

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 -

Link to comment
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,

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

Link to comment
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;

}

Link to comment
Share on other sites

  • 2 months later...
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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...