ocularmagic
Archived-
Posts
187 -
Joined
-
Last visited
Everything posted by ocularmagic
-
Yeah I got it. I have some other projects going on right now so I'm not totally sure when I'll be able to get to it. If you're willing to pay for it (more than just testing fees), maybe post in the seeking commercial help forum. Sorry.
-
Nope, no word, I quit working on it as I wasn't going to open an account and pay for testing when I wasn't even going to use this processor. I think the only way it's going to get done is if someone that can code, wants to use them as a processor, and is willing to pay for transaction fees that will be incurred during the testing phase will do it. Otherwise, you may want to consider looking elsewhere. Sorry.
-
You know, this is probably one reason why no one is into testing this payment option. Straight from their site: So you get charged just for testing to see if you can get it to work!! That's got to be one of the dumbest things I've heard of. I don't have an account with them and I don't plan on signing up with them, I'm just trying to get this to work for anyone that wants to use it. Unfortunately, it's going to cost someone some money. I'm not sure what their charges are but with as many times as I've updated code and tried to run an order on previous mods, I would think the charges would start to climb up there no matter what the price. I would feel bad too, oooh, I forgot a comma, that just cost someone $0.35! Kind of a dilemma. Maybe someone with better coding skills and an account could help out?
-
I seem to have it "somewhat" working for the Smart Screens method. So far you make it through the process to where it takes you to the page on the plugnpay server. There the individual would enter in all of their billing info, or I guess it could be passed via the cart. But the web site documentation only mentions sending the billing address and stuff using the Direct Connect method which uses a secure server. I don't have an account with them or anything so I may just e-mail them to see how I can go about testing this. I don't know if they have test accounts or URL's or what, but at least there has been some progress made. This is all functioning on MS1.
-
Just to be clear, there are a couple of methods that PlugNpay can get the info from you. This is what I read from their web site. One is via the Smart Screens Method which to me looks like it passes the information from the shopping cart to their sites secure URL and then the customer enters their info on their site. This means you don't need to have SSL setup because you are sending the shopper to their secure site. I believe that is how the current version of the module is set up. It just passes the info to a URL. Another method is called the Direct Method which requires you to have the secure site and all info is collected by you at your shop securely. I'm assuming that you are planning on using the direct Method by your last post. I'm just stating my observations and I'm sure you are already aware of these things, but hopefully someone can jump in a help out also with the additional info. Another thing I noticed on the Plugnpay site is they reference payment URL's like this: https://{your-secure-payment-server-domain}/payment/{publisher-name}pay.cgi This looks to me like the URL you would be using to pass information to is dependant on your account. Whereas the URL in the Plugnpay mod as it is looks like this: https://pay1.plugnpay.com/payment/'.MODULE_PAYMENT_PLUGNPAY_PUBLISHER_NAME.'pay.cgi' So if your payment server is NOT pay1.plugnpay.com then maybe it's not processing correctly. Another reason that I think it is using the Smart Screen method rather than the Direct method is because the URL example to use the Direct Method is slightly different. It looks like this: https://{your-secure-payment-server-domain}/payment/{publisher-name}.cgi Notice that there is no 'pay' on the end. These are just a couple of things that I've noticed so far. I was able to get it to show up in the admin, but not in the actual checkout process using MS1. Did you make any modifications to it to make it work with MS1 or are you using an earlier snapshot? Hopefully this info can help.
-
Maybe if you give a few more specifics someone will be able to help. For example, what is not working exactly. Does it show up in the cart? Does it just return a bogus URL? What happens when you go through the checkout procedure? Is there a test account so someone can try and fix the mod without having a Plugnpay account? Maybe with a little more info the ball will get rolling. Just a suggestion.
-
Payment options only available to certain customers
ocularmagic replied to RickChase's topic in General Add-Ons Support
I don't know of any contributions that could do it, but I'm sure it's possible. The way I would do it is add a check box to the customers info page that if checked will allow COD's. By checking that it would set a field in the database to 1 or True. Then when it got to the payment options page, it would check that customers field and if it was true, it would display the COD option, if not, it would leave it out. It's a start at least. HTH -
Separate Proce Per Customer... MS1 Compatible?
ocularmagic replied to loxly's topic in General Add-Ons Support
I can tell you right now that it was not written for anything close to MS1. I wrote it for and August 2002 snapshot I think. I'm surprised that it has worked for people past the new November checkout procedure. :shock: My employer has fallen on pretty hard times so they don't have me keep our site or the code updated anymore. I've have to keep turning away people that ask me questions because I just don't know the new OSC code enough to be able to support it. Maybe someone else has worked it to integrate with MS1, but I just haven't been able to do it. Sorry. :( -
Separate Pricing Per Customer v3.3 fresh install
ocularmagic replied to VyReN's topic in General Add-Ons Support
CyberOto http://www.oscommerce.com/community/contri...ions,716/page,8 Frog I can't seem to find the code you mentioned unless you are doing an upgrade from a previous version or something. Here is the installation straight from the "Fresh Install" doc for admin/customers.php admin/customers.php Around line 25 After: case 'update': $customers_id = tep_db_prepare_input($HTTP_GET_VARS['cID']); $customers_firstname = tep_db_prepare_input($HTTP_POST_VARS['customers_firstname']); $customers_lastname = tep_db_prepare_input($HTTP_POST_VARS['customers_lastname']); $customers_email_address = tep_db_prepare_input($HTTP_POST_VARS['customers_email_address']); $customers_telephone = tep_db_prepare_input($HTTP_POST_VARS['customers_telephone']); $customers_fax = tep_db_prepare_input($HTTP_POST_VARS['customers_fax']); $customers_newsletter = tep_db_prepare_input($HTTP_POST_VARS['customers_newsletter']); Add: $multiple_groups_query = tep_db_query("select distinct customers_group_id from " . TABLE_PRODUCTS_GROUPS . " "); while ($group_ids = tep_db_fetch_array($multiple_groups_query)) { $multiple_customers_query = tep_db_query("select distinct customers_group_id from " . TABLE_CUSTOMERS . " where customers_group_id = " . $group_ids['customers_group_id'] . " "); if (!($multiple_groups = tep_db_fetch_array($multiple_customers_query))) { tep_db_query("delete from " . TABLE_PRODUCTS_GROUPS . " where customers_group_id = '" . $group_ids['customers_group_id'] . "'"); } } $customers_group_name = tep_db_prepare_input($HTTP_POST_VARS['customers_group_name']); $counter = 0; $assigned = 0; $customers_group_name_query = tep_db_query("select distinct customers_group_name, customers_group_id from " . TABLE_CUSTOMERS . " order by customers_group_id"); while ($group_name_check = tep_db_fetch_array($customers_group_name_query)) { $counter = $group_name_check['customers_group_id']; if ($group_name_check['customers_group_name'] == $customers_group_name) { $customers_group_id = $group_name_check['customers_group_id']; $assigned = 1; break; } ++$counter; } if ($assigned == 0) { $customers_group_id = $counter; } Around line 55 After: $sql_data_array = array('customers_firstname' => $customers_firstname, 'customers_lastname' => $customers_lastname, 'customers_email_address' => $customers_email_address, 'customers_telephone' => $customers_telephone, 'customers_fax' => $customers_fax, 'customers_newsletter' => $customers_newsletter, Add: 'customers_group_id' => $customers_group_id, 'customers_group_name' => $customers_group_name); BE SURE TO MOVE THE SEMICOLON AND PARENTHESIS FROM AFTER $customers_newsletter AND REPLACE IT WITH A COMMA TO MAKE THE ASSIGNMENT CORRECT!!!! Around line 120 After: if ($HTTP_POST_VARS['delete_reviews'] == 'on') { $reviews_query = tep_db_query("select reviews_id from " . TABLE_REVIEWS . " where customers_id = '" . tep_db_input($customers_id) . "'"); while ($reviews = tep_db_fetch_array($reviews_query)) { tep_db_query("delete from " . TABLE_REVIEWS_DESCRIPTION . " where reviews_id = '" . $reviews['reviews_id'] . "'"); } tep_db_query("delete from " . TABLE_REVIEWS . " where customers_id = '" . tep_db_input($customers_id) . "'"); } else { tep_db_query("update " . TABLE_REVIEWS . " set customers_id = null where customers_id = '" . tep_db_input($customers_id) . "'"); } Add: $multiple_groups_query = tep_db_query("select distinct customers_group_id from " . TABLE_PRODUCTS_GROUPS . " "); while ($group_ids = tep_db_fetch_array($multiple_groups_query)) { $multiple_customers_query = tep_db_query("select distinct customers_group_id from " . TABLE_CUSTOMERS . " where customers_group_id = " . $group_ids['customers_group_id'] . " "); if (!($multiple_groups = tep_db_fetch_array($multiple_customers_query))) { tep_db_query("delete from " . TABLE_PRODUCTS_GROUPS . " where customers_group_id = '" . $group_ids['customers_group_id'] . "'"); } } Around line 275 Find: $customers_query = tep_db_query("select c.customers_gender, c.customers_firstname, c.customers_lastname, c.customers_dob, c.customers_email_address, a.entry_company, a.entry_street_address, a.entry_suburb, a.entry_postcode, a.entry_city, a.entry_state, a.entry_zone_id, a.entry_country_id, c.customers_telephone, c.customers_fax, c.customers_newsletter, c.customers_default_address_id from " . TABLE_CUSTOMERS . " c left join " . TABLE_ADDRESS_BOOK . " a on c.customers_default_address_id = a.address_book_id where a.customers_id = c.customers_id and c.customers_id = '" . $HTTP_GET_VARS['cID'] . "'"); Change to: $customers_query = tep_db_query("select c.customers_gender, c.customers_firstname, c.customers_lastname, c.customers_dob, c.customers_email_address, a.entry_company, a.entry_street_address, a.entry_suburb, a.entry_postcode, a.entry_city, a.entry_state, a.entry_zone_id, a.entry_country_id, c.customers_telephone, c.customers_fax, c.customers_newsletter, c.customers_group_name, c.customers_default_address_id from " . TABLE_CUSTOMERS . " c left join " . TABLE_ADDRESS_BOOK . " a on c.customers_default_address_id = a.address_book_id where a.customers_id = c.customers_id and c.customers_id = '" . $HTTP_GET_VARS['cID'] . "'"); Right after the above line add: $existing_customers_query = tep_db_query("select distinct customers_group_name from " . TABLE_CUSTOMERS . " order by customers_group_id "); Around line 430 After: <tr> <td class="main"><?php echo ENTRY_NEWSLETTER; ?></td> <td class="main"><?php echo tep_draw_pull_down_menu('customers_newsletter', $newsletter_array, $cInfo->customers_newsletter); ?></td> </tr> Add: <tr> <td class="main"><?php echo ENTRY_CUSTOMERS_GROUP_NAME; ?></td> <td class="main"><?php echo tep_draw_input_field('customers_group_name', $cInfo->customers_group_name, 'maxlength="25"'); ?></td> </tr> <tr> <td class="main"><?php $index = 0; echo ("Existing Groups: "); while ($existing_customers = tep_db_fetch_array($existing_customers_query)) { echo ($existing_customers['customers_group_name']); echo (", "); ++$index; if ($index%10 == 0) { echo (" "); } }?> </td> </tr> I can't find the code you posted anywhere in the new docs. Is it from a past version? If so you should upgrade to the latest one as I've screwed up a few things. -
Separate Pricing Per Customer v3.3 fresh install
ocularmagic replied to VyReN's topic in General Add-Ons Support
frog Without having the code in front of me, I may be wrong, but somewhere in the code when a new group is created, there is a query to the database to see what group_ids there are so far. Then when the new group is made it is assigned a value equal to one plus that value. Make sense? If that's not in there, I screwed up somewhere. I haven't heard anything like this from anyone else that I can remember. Can you tell me what file and lines that code is from? I will compare it to mine and see what the difference is. Kristofor I still haven't been able to look into your problem and I apologize for that. I'm swamped with moving things on my end. I know I ran into your problem before but I thought I had it fixed. I hope it's not something to do with code changes in other files. What snapshot are you using? -
Separate Pricing Per Customer v3.3 fresh install
ocularmagic replied to VyReN's topic in General Add-Ons Support
I'll definitely do that in future mods. Thanks and sorry for the inconvenience. -
Separate Pricing Per Customer v3.3 fresh install
ocularmagic replied to VyReN's topic in General Add-Ons Support
Thanks for keeping me posted glen, I appreciate it and hope the mod works out well for you. -
UPS Calculations based on info in the database.
ocularmagic replied to ocularmagic's topic in General Add-Ons Support
Well, to answer my own question, the zones and rates are given in comma delimited text files. That's convenient. Here is a clip of one of the zone files ZONE CHART,,,,,, UPS Ground/UPS 3 Day Select/UPS 2nd Day Air/UPS 2nd Day Air A.M./UPS Next Day Air Saver/UPS Next Day Air,,,,,, For shipments originating in ZIP Codes 926-01 to 929-99. To determine zone,,,,,, take the first three digits of the receiver's ZIP Code and refer to the chart below:,,,,,, ZONES,,,,,, Dest. ZIP,Ground,3 Day Select,2nd Day Air,2nd Day Air A.M.,Next Day Air Saver,Next Day Air 004-005,8,308,208,248,138,108 006-007,-,-,225,-,-,125 8,-,-,[1],-,-,[1] 9,-,-,225,-,-,125 010-089,8,308,208,248,138,108 090-099,-,-,-,-,-,- 100-199,8,308,208,248,138,108 200-299,8,308,208,248,138,108 300-324,8,308,208,248,138,108 325,7,307,207,247,137,107 326-339,8,308,208,248,138,108 340,-,-,-,-,-,- 341-349,8,308,208,248,138,108 350-359,7,307,207,247,137,107 360-363,8,308,208,248,138,108 364-367,7,307,207,247,137,107 368,8,308,208,248,138,108 369-372,7,307,207,247,137,107 Then you can use that information to lookup the rate. Here is a clip from the Rate file for UPS Ground. UPS Ground Commercial,,,,,,, Daily Rates,,,,,,, "EFFECTIVE JANUARY 6, 2003",,,,,,, Rates do not include a fuel surcharge.,,,,,,, Weight Not To Exceed, Zone 2 , Zone 3 , Zone 4 , Zone 5 , Zone 6 , Zone 7 , Zone 8 1,3.39,3.5,3.74,3.82,4.02,4.07,4.18 2,3.46,3.67,4.05,4.16,4.48,4.58,4.87 3,3.57,3.84,4.28,4.46,4.78,4.94,5.39 4,3.69,4.01,4.5,4.73,5.06,5.23,5.74 5,3.85,4.16,4.71,4.96,5.3,5.52,6.09 6,3.96,4.27,4.82,5.13,5.48,5.75,6.32 7,4.12,4.39,4.94,5.31,5.69,5.98,6.6 8,4.27,4.53,5.06,5.44,5.88,6.26,7.06 9,4.42,4.67,5.18,5.57,6.04,6.6,7.52 10,4.56,4.79,5.29,5.73,6.28,7.07,8.04 11,4.71,4.92,5.4,5.89,6.56,7.58,8.61 12,4.86,5.08,5.51,6.05,6.85,8.09,9.24 13,5.01,5.24,5.62,6.18,7.18,8.6,9.86 14,5.12,5.41,5.72,6.32,7.58,9.11,10.48 15,5.25,5.58,5.82,6.47,7.98,9.62,11.1 16,5.32,5.73,5.96,6.65,8.35,10.1,11.69 17,5.4,5.92,6.14,6.93,8.77,10.59,12.3 18,5.5,6.11,6.35,7.27,9.19,11.08,12.92 19,5.62,6.32,6.58,7.61,9.61,11.57,13.55 20,5.75,6.53,6.81,7.96,10.03,12.06,14.18 It's starting to look more plausible to me. Again, any feedback is appreciated. -
My company uses UPS as the main shipper of all of our products. So when they changed the way they handle queries, of course our shop now errors for UPS shipping (Pre Nov. 1st Snapshot). My question is this, you can get the rates and zones from downloadable files via UPS in Adobe Acrobat format. Does anyone think it's possible to export the info from those files so you can put it into the OSC database, then use that information for shipping via UPS? Then when new rates are released, you can just export them from the Acrobat file again and overwrite the old values. Just a thought, then it wouldn't have to be dynamic, but it would definitely be more work. I'm not asking if someone would do it, just if it's possible. Any feedback would be appreciated.
-
Separate Pricing Per Customer v3.3 fresh install
ocularmagic replied to VyReN's topic in General Add-Ons Support
Hi Glen, someone else brought up the products options before. What do you mean when you say you "lose" them? I know I didn't write the mod to have anything to do with options because my work doesn't use them, but if it screws them up, then I'll need to fix it. Thanks for helping out also, glad you got the other problem taken care of. -
Seperate Pricing Per Customer ver 2 - session Errors !!!
ocularmagic replied to webby70's topic in General Add-Ons Support
Actually this might have been an error on my part. It seems that when writing my installs some old code got used in the new installation file. :shock: Sorry about that but as I said in the file, it's my first effort so please be gentle. I'm going to be putting out the newest release soon, either today or tomorrow. And everything should be up to date, again, sorry about the inconvenience. -
Seperate Pricing Per Customer ver 2 - session Errors !!!
ocularmagic replied to webby70's topic in General Add-Ons Support
I'm not totally sure but this could be due to the new checkout modifications that were made after November 1st. If you can list what snapshot you're using, maybe someone else can verify that it either does or doesn't work for that particular one, or close to it. I created the mod for the July 24th snapshot so I'm not sure if it will continue to work with all of the new ones released or not. I'm helping out a couple of other people right now as well as keeping our own shop up, but if I can get those straightened out I'll see if I can figure something out. If you find a fix before then, please let me know. Sorry I couldn't be of more help. -
Seperate Pricing Per Customer ver 2 - session Errors !!!
ocularmagic replied to webby70's topic in General Add-Ons Support
Check to make sure you don't have any whitespace at the beginning and end of the files you edited. That's usually the cause of this type of error. No one else that has installed it has reported this problem so I think that may be it. -
Seperate Pricing Per Customer v3.1 Bug
ocularmagic replied to ocularmagic's topic in General Add-Ons Support
Sorry, I don't use the product attribute mod so I can't say for sure. I'll see if I can install the product attributes mod this weekend and see if I can duplicate it. Maybe they both use the same variable name for the checkbox? -
Seperate Pricing Per Customer v3.1 Bug
ocularmagic replied to ocularmagic's topic in General Add-Ons Support
Released version 3.2. It's a pretty simple fix so I'll add the upgrade from 3.1a to 3.2 here. In file admin/customers.php Around line 25 Replace: $multiple_groups_query = tep_db_query("select distinct customers_group_id from " . TABLE_PRODUCTS_GROUPS . " order by customers_group_id"); while ($group_ids = tep_db_fetch_array($multiple_groups_query)) { $multiple_customers_query = tep_db_query("select distinct customers_group_id from " . TABLE_CUSTOMERS . " where customers_group_id = " . $group_ids['customers_group_id'] . " "); $multiple_customers = tep_db_fetch_array($multiple_customers_query); tep_db_query("delete from " . TABLE_PRODUCTS_GROUPS . " where customers_group_id = " . $multiple_customers['customers_group_id'] . " "); } With: $multiple_groups_query = tep_db_query("select distinct customers_group_id from " . TABLE_PRODUCTS_GROUPS . " "); while ($group_ids = tep_db_fetch_array($multiple_groups_query)) { $multiple_customers_query = tep_db_query("select distinct customers_group_id from " . TABLE_CUSTOMERS . " where customers_group_id = " . $group_ids['customers_group_id'] . " "); if (!($multiple_groups = tep_db_fetch_array($multiple_customers_query))) { tep_db_query("delete from " . TABLE_PRODUCTS_GROUPS . " where customers_group_id = '" . $group_ids['customers_group_id'] . "'"); } } Around line 141 Replace: $multiple_groups_query = tep_db_query("select distinct customers_group_id from " . TABLE_PRODUCTS_GROUPS . " order by customers_group_id"); while ($group_ids = tep_db_fetch_array($multiple_groups_query)) { $multiple_customers_query = tep_db_query("select distinct customers_group_id from " . TABLE_CUSTOMERS . " where customers_group_id = " . $group_ids['customers_group_id'] . " "); $multiple_customers = tep_db_fetch_array($multiple_customers_query); tep_db_query("delete from " . TABLE_PRODUCTS_GROUPS . " where customers_group_id = " . $multiple_customers['customers_group_id'] . " "); } With: $multiple_groups_query = tep_db_query("select distinct customers_group_id from " . TABLE_PRODUCTS_GROUPS . " "); while ($group_ids = tep_db_fetch_array($multiple_groups_query)) { $multiple_customers_query = tep_db_query("select distinct customers_group_id from " . TABLE_CUSTOMERS . " where customers_group_id = " . $group_ids['customers_group_id'] . " "); if (!($multiple_groups = tep_db_fetch_array($multiple_customers_query))) { tep_db_query("delete from " . TABLE_PRODUCTS_GROUPS . " where customers_group_id = '" . $group_ids['customers_group_id'] . "'"); } } -
Seperate Pricing Per Customer v3.1 Bug
ocularmagic replied to ocularmagic's topic in General Add-Ons Support
It should, but I make no guarantees. :wink: -
Well, the bugs just keep popping up in my contribution here. :? Apparently if you assign pricing to one group, then create another group after all of the pricing is entered, it erases all of the prices for the old group. :shock: I'm going to fix this asap and will release a new version when done. Sorry to all for the inconvenience.
-
Is there anyone out there working on a shipping module that will allow the site administrator to assign a specific shipping cost based on the product? Or to allow certain products to use only certain shipping modules. The closest one I've seen is Shipping rate per product v1.0001 but it says it won't work with any other shipping modules, and you can't use the weight field. My company ships machinery as well as parts. UPS works great for our small parts, but if we want to ship a machine that weighs 325 pounds, the UPS mod breaks it up into seperate shipments based on the largest amount we will ship. This won't work for us always. If someone buys a machine, the only option should be a flat rate that we specify per machine because we will ship out machinery via a freight service. Or just use the flat rate shipping option, but they shouldn't be able to select UPS. Pretty complicated, but I wanted to see if anyone else has this problem and if there are any ideas for a solution. Thanks in advance for the feedback.