Jump to content

Pica

Members
  • Content count

    90
  • Joined

  • Last visited

  1. Hi... I am about to implement a "PSP" (Payment Solutions Provider) module with my existing OSC. This PSP's module allows me to configure various Debit and Credit Card payment solutions. The thing is, I have to link my existing OSC checkout page(s) to this PSP's page(s) in order to accomplish the procedure online in 1 step. The PSP's requires the following information to process the payment for the online order : - order reference - total amount to pay - customers name (user can modify this during process) This module will then offer payment with various cards (Visa, MasterCard, American Express,...) and process payment directly. I shall setup the following pages : - accept URL - decline URL - cancel URL - exception URL In order to have a decent checkout sequence, I thought about modifying the existing OSC : 1. checkout_shipping.php 2. checkout_confirmation.php 3. checkout_payment.php ( in OSC this comes before confirmation ) 3.1. PSP's payment module 4. checkout_success.php ( accept URL ) Presently, I have defined : 3 shipping options : - Standard shipping - Online services ( no charges ) - Store pickup ( no charges ) and 3 payment options : - Online payment ( debit & credit cards ) - COD ( cash on delivery ) - money order Once the customer chooses the shipping method, the "order total" is known, thus allowing me to link to the PSP's module. If anyone sees any restriction for the "inversion" of the 2 checkout pages or another decent way to implement external services, feel free to reply. Thank you all in advance for your attention and assistance on this matter. Paulo.
  2. GOT IT !!! Here's why (from http://www.mysql.com/doc/en/Numeric_types.html) So I just need to use BIGINT in stead... :D P.
  3. Thanks for your reply... I have been doing quite a lot of mods to the initial snapshot and... quite frankly... I am really happy with the results !!! I did changed the products_id to VARCHAR(12) everywhere in the database structure BUT... I noticed osC started to act strangely after that. I can't remember exactly what/how but... I guessed it should remain a number value so things wouldn't mess up. On the other hand, I have also installed and adapted (... this is me !!!) the "domain_search" contribution which requires the auto_increment parameter to work as I need it. The only thing bugging me is really that INT(12) thing... Feel free to post more ideas. :D P.
  4. Hi... I looked around to see if I could find something on this before I post but... NADA !!! Here's my problem : I have a huge product database... some 15,000 items with photos, etc... It would best suit my needs to change the products_id field in order to input my own references instead of some abstract auto_increment value. My reference is built on 12 characters wich are structured as follows : ABCCCDDDDEEE A - country of origin B - supplier code C - manufacturer code D - product category code E - product index (Yeah, I know it may seem weird but... I am sure I will never have more than 999 items in the same category, from the same manufacturer, from the same supplier....) The question is : I am able to upload with phpMyAdmin various records to both products and products_description tables as well as to products_to_categories BUT... way too often I get this error message saying : Duplicate entry '2147483647-1' for key 1 The thing is : there is NO duplicate value in my SQL code. Plus, the "products_id" for the record is : INSERT INTO products_description VALUES (121751113001, 1, 'blah,blah,blah...', 'PROD_REF', 0); BUT I get this in the DB : 2147483647 - 1 - blah,blah,blah... - PROD_REF - 0 I just can't figure out where does that 2147483647 comes from !!! :crazy: So... Does anyone know IF and WHAT are the restrictions for the products_id field ?! Could I use 12 alphanumeric characters in stead if numbers ? Any help on this would be appreciated !!! Thx in advance. P.
  5. Hummm... that makes sense ! Thx. BTW, how about repeating that sentence... let's say : tep_db_query("insert into " . TABLE_PRODUCTS_DESCRIPTION . " values ('', '1', '". $what ."', '" . $type . "', '', '')"); tep_db_query("insert into " . TABLE_PRODUCTS_DESCRIPTION . " values ('', '2', '". $what ."', '" . $type . "', '', '')"); Could that work ? :roll: BTW, any clue on that fcolse() error ? P.
  6. I used the "Store PickUp" files and adapted them to "online Services" in order to set delivery fees to 0.00. For the rest, I am stucked with that "fclose()" thing... Any ideas ? Thx, Paulo.
  7. I have been looking everywhere in the forums and in the contributions area for something that would do this... It would work like an affiliate program. An existing customer (A) gives an "Affiliate" promotional code to a new customer (B). Customer B makes his shopping on-line and when checking out, he uses the promotional code which deducts some 2, 5 or 10% off the Total. This has not to be specific to a product. An idea would be to have a "dummy-product" which would cost "5% off" the total amount... :roll: Does this make any sens to you ?! The idea is to promote the online shopping and reward both existing customers (custom offline reward) and new ones (5% online reduction). Thanks in advance. Paulo.
  8. Hi there.... For a specific gastronomic project, my client requested me to prepare printable pages for each and every available menu. I have two possibilities : A. 1. I click a button, which opens a pop-up window without Location, Menubar,... <script language="javascript"><!-- function popupWindow(url) { window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,resizab le=no,copyhistory=no,width=450,height=280,screenX=150,screenY=150,top=150,left=15 0') } //--></script> ... <?php echo '<a href="javascript:popupWindow('' . tep_href_link(FILENAME_ORDERS_PRINTABLE, tep_get_all_get_params(array('order_id')) . 'order_id=' . $HTTP_GET_VARS['order_id'], 'SSL') . '')">' . tep_image_button('print_button.gif', IMAGE_BUTTON_PRINT_ORDER) . '</a>'; ?> 2. Inside the code of the page to be printed, I put this : <div id="print" style="position:absolute; left:285; top:45; visibility:visible; z-index:0;"> <A HREF="javascript:window.print()"><IMG SRC="images/print.gif" ALT="Print Menus" BORDER="0"></A> </div> This puts a "Print" button on that page that I can click to launch the printing. B. 1. I click a button, which opens a pop-up window without URL, Menubar,... (same code as above). 2. Inside the code of the page to be printed, I put this : <BODY onLoad="window.print();"> ... This automatically launches the printing (i.e. open the printing dialog box...) at the openning of the pop-up window. I hope this helps. Paulo.
  9. I am almost finished with this tool... still, an error message remains : Warning: fclose(): supplied argument is not a valid stream resource in domain_search1.php on line 66. Which is : $opennewcount = @fopen($counterfile,"w"); @fwrite($opennewcount, $newcount); fclose ($opennewcount); This doesn't seem to disturb the result of the query but, it's quite annoying as it appears on the screen. On the other hand, what can I do in order to remove Delivery fees when ordering a domain name ? Thank you all. Paulo.
  10. Hi all... I'm happy to get some replies to message posted some months ago : guess we all been busy !!! I took a look at your site and it's great ! I keep wondering what am I doing wrong.... 1. How can I avoid Ordered domain names to be added to the products list ? 2. How can I avoid them to show in the New Products in the Default page ? 3. How can I exclude the Domain Names category to be listed in the Advanced Search page ? (maybe there's a better contribution that I missed...) For the different DNS services, I had no trouble so far. Thanks in advance for your replies. Best regards, Paulo.
  11. That's right - search in all categories... About the changes to the search query, feel free to add some code as I am already dwelling with advanced_search with new fields... and it's hard to keep my head straight !!! :onfire: Thx. P.
  12. That seems a working solution but... ...when one looks for that product in "All Categories" he will get multiple results, right ? :roll: Thx for that hint. Feel free to suggest further ideas... P.
  13. Hi .... I was wondering if there is a way in order to define a same product in different categories. Anyone working on this ? Thanks in advance. :D P.
  14. Pica

    Advanced Search new fields

    Say... I was looking at the code in both "advanced_search.php" and "advanced_search_result.php" files... and I guess I should adapt your idea to what I really need. Like PriceFrom and PriceTo, I wish to search for records between user-input values in specific fields... and not really in the products_description. Therefore, I should put something like this (below), right ? (in advanced_search.php) : ' <tr>' . "n" . ' <td class="fieldKey">' . ENTRY_NEWFIELD1_FROM . '</td>' . "n" . ' <td class="fieldValue">' . tep_draw_input_field('field1from') . '</td>' . "n" . ' </tr>' . "n" . ' <tr>' . "n" . ' <td class="fieldKey">' . ENTRY_NEWFIELD1_TO . '</td>' . "n" . ' <td class="fieldValue">' . tep_draw_input_field('field1to') . '</td>' . "n" . ' </tr>' . "n" . (...and in advanced_search_result.php) : if ($HTTP_GET_VARS['field1from'] { $where_str .= " and p.products_field1 >= " . $field1from . ")"; } if ($HTTP_GET_VARS['field1to'] { $where_str .= " and p.products_field1 <= " . $field1to . ")"; } Does that make any sens to you ?! :shock: Keep in touch, Thx. P.
  15. Pica

    Advanced Search new fields

    Ok... thx Maxi - I'll try that as soon as possible (for the time being, some sleep is greatly needed !!! ). BTW, feel free to send me the URL of your site for me to take a look on your Advanced Search layout. Best regards, P.
×