Eric T Posted July 15, 2006 Share Posted July 15, 2006 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. Quote Link to comment Share on other sites More sharing options...
kogyarus Posted November 12, 2006 Share Posted November 12, 2006 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..... -------------------------------- Quote Link to comment Share on other sites More sharing options...
Rezolles_Net Posted November 21, 2006 Share Posted November 21, 2006 (edited) 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 Quote Link to comment Share on other sites More sharing options...
Rezolles_Net Posted November 24, 2006 Share Posted November 24, 2006 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?? Quote Link to comment Share on other sites More sharing options...
Rezolles_Net Posted November 25, 2006 Share Posted November 25, 2006 B U M P Please....Zurik...is your problem solved??and how?? Quote Link to comment Share on other sites More sharing options...
Rezolles_Net Posted November 25, 2006 Share Posted November 25, 2006 B U M P Quote Link to comment Share on other sites More sharing options...
opurahman Posted November 27, 2006 Share Posted November 27, 2006 Thanx for the contribution. I think contributor should make a package then upload to contribution section. Best regards. -Arafat Rahman Web Developer Dhaka, Bangladesh Quote Arafat Rahman Web Developer Dhaka, Bangladesh Link to comment Share on other sites More sharing options...
Rezolles_Net Posted November 27, 2006 Share Posted November 27, 2006 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?? Quote Link to comment Share on other sites More sharing options...
Rezolles_Net Posted December 4, 2006 Share Posted December 4, 2006 I found out that this contrib cannot working together with MVS contrib...Please be aware for those using MVS.(multi vendor shipping) Quote Link to comment Share on other sites More sharing options...
opurahman Posted December 6, 2006 Share Posted December 6, 2006 Ya it is working fine. I installed it and now running on my testing server. Quote Arafat Rahman Web Developer Dhaka, Bangladesh Link to comment Share on other sites More sharing options...
Rezolles_Net Posted December 6, 2006 Share Posted December 6, 2006 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. Quote Link to comment Share on other sites More sharing options...
opurahman Posted December 8, 2006 Share Posted December 8, 2006 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. Quote Arafat Rahman Web Developer Dhaka, Bangladesh Link to comment Share on other sites More sharing options...
Rezolles_Net Posted December 8, 2006 Share Posted December 8, 2006 Then u are lucky >_< Coz......I totally need MVS in my store.. :P....so...i have to sacrifice :P Quote Link to comment Share on other sites More sharing options...
opurahman Posted December 8, 2006 Share Posted December 8, 2006 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 ! Quote Arafat Rahman Web Developer Dhaka, Bangladesh Link to comment Share on other sites More sharing options...
Rezolles_Net Posted December 8, 2006 Share Posted December 8, 2006 Is this can be use with MVS?? Quote Link to comment Share on other sites More sharing options...
opurahman Posted December 8, 2006 Share Posted December 8, 2006 Is this can be use with MVS?? Opsssss ! I am not sure. Quote Arafat Rahman Web Developer Dhaka, Bangladesh Link to comment Share on other sites More sharing options...
svetur Posted January 23, 2007 Share Posted January 23, 2007 (edited) This module is working fine - i have been using it for 6 months now. And what is MVS?????? Edited January 23, 2007 by svetur Quote Link to comment Share on other sites More sharing options...
svetur Posted January 23, 2007 Share Posted January 23, 2007 (edited) "a Edited January 23, 2007 by svetur Quote Link to comment Share on other sites More sharing options...
akora Posted February 8, 2007 Share Posted February 8, 2007 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? Quote Link to comment Share on other sites More sharing options...
akora Posted February 8, 2007 Share Posted February 8, 2007 (edited) .... And what is MVS?????? Multiple Virtual Storage (IBM) http://linux.icf.bofh.ru/books/1/ch03s02.html Edited February 8, 2007 by akora Quote Link to comment Share on other sites More sharing options...
Guest Posted February 12, 2007 Share Posted February 12, 2007 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 - Quote Link to comment Share on other sites More sharing options...
Guest Posted February 13, 2007 Share Posted February 13, 2007 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, // ^^^^^^^^^^^^^^^^^^ Quote Link to comment Share on other sites More sharing options...
Guest Posted February 13, 2007 Share Posted February 13, 2007 #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; } Quote Link to comment Share on other sites More sharing options...
nimsgone Posted May 5, 2007 Share Posted May 5, 2007 (edited) sorry was not intended for you Edited May 5, 2007 by nimsgone Quote Link to comment Share on other sites More sharing options...
nimsgone Posted May 5, 2007 Share Posted May 5, 2007 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.