Jump to content
Latest News: (loading..)

bedfordch

Members
  • Content count

    27
  • Joined

  • Last visited

Profile Information

  • Real Name
    Bob Bedford

Recent Profile Visitors

7,751 profile views
  1. bedfordch

    Ultimate Seo Urls 5 Pro

    Hi all, just installed over the Chemo's SEO and seems to work. The main reason I updated was to get the language in URL. But !!! I can't get it to work if I force URL not to have the index.php in URL. So this URL works http://www.mysite.com/index.php/fr But this one doesn't http://www.mysite.com/fr Have I missed something or it is a limitation of the module ? Also did someone find a way to also have the link directly to the correct page (http://www.mysite.com/my_great_article-p-15500.html => http://www.mysite.com/fr/mon_super_article-p-15500.html) ? Thank you for your help
  2. bedfordch

    PostFinance E-Payment

    Fixed unsing SHA256 and checking "Each parameter followed by the passphrase." in technical information -> Global Security Parameter Thanks to the help of Postfinance Support.
  3. bedfordch

    PostFinance E-Payment

    Hi, I'm trying to install this module but in test mode I only get unknown order/1/s/ errors I've tried to send form only with compulsory fields and SHASIGN but still this error. It's there anybody who has a working module or has an Idea on how to fix this ? thank you for help. cheers
  4. bedfordch

    PayPal App for osCommerce Online Merchant

    @Harald Ponce de Leon: for Paypal App (contribution http://addons.oscommerce.com/info/9184) version PayPal App v5.018 in catalog/includes/apps/paypal/admin/actions/balance/retrieve.php line 34: add utf8-encode: $ppBalanceResult['balance'][$ppBalanceResponse['L_CURRENCYCODE' . $counter]] = utf8_encode($balance); Otherwise there is no result at all as the resulting json is bad formatted and generates empty list. OSC 2.2RC2a, default charset=iso-8859-1, PHP 7.0.10 Also the updates don't work on fresh install, the code still use deprecated syntax: Still old constructor syntax is used (juste generate warning for now) and $HTTP_POST_VARS/$HTTP_GET_VARS instead of $_POST/$_GET (this syntax doesn't work anymore in PHP 7, not allowing updates and code to run at all). Regards
  5. bedfordch

    PayPal App v5.000

    Hi all, @@Harald Ponce de Leon: for Paypal App (contribution http://addons.oscommerce.com/info/9184) version PayPal App v5.018 in catalog/includes/apps/paypal/admin/actions/balance/retrieve.php line 34: add utf8-encode: $ppBalanceResult['balance'][$ppBalanceResponse['L_CURRENCYCODE' . $counter]] = utf8_encode($balance); Otherwise there is no result at all as the resulting json is bad formatted and generates empty list. OSC 2.2RC2a, default charset=iso-8859-1, PHP 7.0.10 Also the updates don't work, the still use deprecated syntax: Still old constructor syntax is used (juste generate warning for now) and $HTTP_POST_VARS/$HTTP_GET_VARS instead of $_POST/$_GET (this syntax doesn't work anymore in PHP 7, not allowing updates and code to run at all).
  6. Hi, I've installed an old version of Ultimate SEO and will need to update my version. I've a multilanguage store, do this contribution manage the urls like: www.mysite.com/en/, www.mysite.com/de/, etc ? for language separation ? Thanks for help. Kind Regards
  7. bedfordch

    Paypal IPN (not aggregate) - CCGV

    Thank you for your answer web-project. It's there any way to automatically switch Paypal IPN to aggregate checkout when there is a coupon and use the detailed checkout when there is no coupon ? Would this be easier ? I'm trying to get have an easy solution. Cheers.
  8. bedfordch

    Paypal IPN (not aggregate) - CCGV

    Hi all, I've not worked on it for a while since I had no time to fix it when I faced the problem. Now I've to fix it. I've Paypal IPN and CCGV installed. They don't work together if the Paypal checkout isn't set on Aggregate. I want my customer to have a recipe of the purchase, so I want the detail of the order on Paypal. Do the last version work together ? instead, wich version will work together ? It's there any "hack" to apply to any contribution to work ? If it hasn't been fixed up, isn't there any possibility to reduce the price of each article until the coupon amount is used ? I mean is this case possible with a hack ? Coupon value : 10$ article 1: price 5$ less 5$ coupon : 0$ (5$ taken on 10$ coupon) article 2: price 7$ less 5$ coupon : 2$ (last 5$ taken on 10$ coupon) article 3: price 6$ less 0$ coupon (coupon is now empty: 6$. Total without coupon: 18$, Total with coupon: 8$ Thank you for helping me !
  9. Hi, Sorry for cross-posting, I put on V.3 but was intended to be in V.2 I'm working on my second contribution where I want to show statistics of my store. A few I'd like to have: Total sales by brand Total sales by category Sales by day/week/month/year ... Now I'll do this contribution as open as possible, allowing to anybody to create it's own statistics. The result will be a graphic chart (I'll use free library when possible). My problem is that I'm not so good with mysql, so if you may help, this contribution will be out in a better way. Also make proposal for statistics chart and feature and I may add them. Here is my first query I worked on last night. It's intended to show the total sold for each brand: $tot_sale_query_raw_brand = "select sum(op.final_price) as total, m.manufacturers_name as brand from " . TABLE_ORDERS_PRODUCTS . " op, " . TABLE_PRODUCTS . " p, ". TABLE_MANUFACTURERS . " m where op.products_id = p.products_id and p.manufacturers_id = m.manufacturers_id"; $tot_sale_query_raw_brand .= ' group by p.manufacturers_id order by total desc'; echo '<br /><strong>Total by Brand</strong>'; echo '<table>'; $tot_sale_query_brand = tep_db_query($tot_sale_query_raw_brand); $total = 0; while($tot_sale_brand = tep_db_fetch_array($tot_sale_query_brand)){ echo '<tr><td>'.$tot_sale_brand['brand'].'</td><td>'.$currencies->format($tot_sale_brand['total']).'</td></tr>'; $total += $tot_sale_brand['total']; } echo '</table>'; echo '<h2>'.$currencies->format($total).'</h2>'; The goal will be to filter each query by period (date from - date to), so I'll have to add some more tables, but for now I start simple. I've compared with an other stat contribution and the total of sales is different (about 15%) so I guess my query is wrong. If you can help me, I'll greately appreciate it. Also if somebody can get the query for the total by store category... The contribution will be released when I've added graphical charts. Thanks for your help and proposals. Gabriel
  10. Hi, I'm working on my second contribution where I want to show statistics on my store. A few I'd like to have: Total sales by brand Total sales by category Sales by day/week/month/year ... Now I'll do this contribution as open as possible, allowing to anybody to create it's own statistics. The result will be a graphic chart (I'll use free library when possible). My problem is that I'm not so good with mysql, so if you may help, this contribution will be out in a better way. Also make proposal for statistics chart and feature and I may add them. Here is my first query I worked on last night. It's intended to show the total sold for each brand: $tot_sale_query_raw_brand = "select sum(op.final_price) as total, m.manufacturers_name as brand from " . TABLE_ORDERS_PRODUCTS . " op, " . TABLE_PRODUCTS . " p, ". TABLE_MANUFACTURERS . " m where op.products_id = p.products_id and p.manufacturers_id = m.manufacturers_id"; $tot_sale_query_raw_brand .= ' group by p.manufacturers_id order by total desc'; echo '<br /><strong>Total by Brand</strong>'; echo '<table>'; $tot_sale_query_brand = tep_db_query($tot_sale_query_raw_brand); $total = 0; while($tot_sale_brand = tep_db_fetch_array($tot_sale_query_brand)){ echo '<tr><td>'.$tot_sale_brand['brand'].'</td><td>'.$currencies->format($tot_sale_brand['total']).'</td></tr>'; $total += $tot_sale_brand['total']; } echo '</table>'; echo '<h2>'.$currencies->format($total).'</h2>'; The goal will be to filter each query by period (date from - date to), so I'll have to add some more tables, but for now I start simple. I've compared with an other stat contribution and the total of sales is different (about 15%) so I guess my query is wrong. If you can help me, I'll greately appreciate it. Also if somebody can get the query for the total by store category... The contribution will be released when I've added graphical charts. Thanks for your help and proposals. Gabriel
  11. Hi everybody, I'm looking to send to the registered customers the new items in stock. It's there any contribution for this ? maybe something to add at the newsletter. Thanks for helping. Bob
  12. Hi all, I've to find a way to do a cart->add_cart with the possibility to set the article price. This new price may be higher or lower than the normal price. It's there any existing function or a contrib ? I'd like to avoid to touch at the core functions. I may do a simple "update price" but I would even prefer to use an existing feature. Thanks for helping. Bob
  13. Hello people, I've looked around but can't find any contribution that may do the job I'm preparing my 3rd order since I've sold many items from my store and I'm facing even more difficulties than the 2nd order: 1. I've various providers, each of them has a comprehensive number of different articles. When ordering, I've to know wich items are still on stock, wich have been sold and wich have been never ordered. There is actually no way to know all this informations and also let me fill a "order" list directly in OScommerce. 2. Being a starting business, I've to keep stock as low as possible. I've often only 1-2 ref. of articles in stock, being able to re-stock quite quickly. So I let people order even if there is not enough stock for an article. I would also see this information on the restock page, as this is a compulsory information I've to keep somewhere to reorder the correct references since they are already payed. So if there is a contribution or a close one I may improve, please let me know (I'm quite confortable in PHP/MySQL). I've to know for every article for every provider: Reference + title item, sold item, how many left in stock, ordered item (wich have not been sent yet), and a way to set the item I'd like to order. I thank every person being able to help me. Cheers
  14. bedfordch

    Pre-order list

    Hi all, We are looking for a contribution that allow to show certains items only in a list, without images nor details or link. Only some things should be shown: items name, article number, price and a box where the user may choose the number of items to order. At the end of the list an "add to cart" button as it should not be any pages, all items are on the same list. Also this page may have a "limit" date. I mean this can't be accessible after a certain date. Can someone tell us if this contrib exists and point to it ? Thanks for helping. Bob
  15. bedfordch

    CSS menu boxes

    I've a fresh install of osCommerce 2.2 Milestone 2 Update 060817 also installed infobox_skin_manager_2.0_1 Everything works fine. I've changed some code to avoid having boxes around infobox as the client don't like them. He'd like a menu like this: http://www.templatemonster.com/flash-templates/14666.html I know it's in flash but the idea is having a large box (infobox width) and an image background for every menu and a line around. Then the active page link would have a yellow image background. How to do so ? Thanks for helping. Bob
×