bedfordch

Members
  • Content count

    26
  • Joined

  • Last visited

Community Reputation

0 Neutral

About bedfordch

Profile Information

  • Real Name
    Bob Bedford
  1. Fixed unsing SHA256 and checking "Each parameter followed by the passphrase." in technical information -> Global Security Parameter Thanks to the help of Postfinance Support.
  2. 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
  3. @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
  4. 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).
  5. Thank MrPhil for the answer, let me return to the original question: What I've now: www.mysite.com/my-better-product-p-123456.html for any language... and URL like www.mysite.com/my-better-product-p-123456.html?language=fr are actually in the Google search result. I want to add the language between the site and product: www.mysite.com/en/my-better-product-p-123456.html Same for others pages (manufacturers, contact, etc...). Then I can provide different URL for different languages: www.mysite.com/en/my-better-product-p-123456.html will be different than www.mysite.com/fr/my-better-product-p-123456.html and so on (I've 4 languages). If I enter www.mysite.com/en/my-better-product-p-123456.html it's redirected to www.mysite.com/my-better-product-p-123456.html I've tried to add the language in the URL but couldn't make it to work correctly. I could only make the home page working correctly so for. Was just hoping somebody would already have done it and could share the solution. Thank you
  6. Hello, I've installed more than 10 years ago the Ultimate SEO URLs contribution (http://addons.oscommerce.com/info/2823) V2.1 Unfortunately I've many SEO problems, first and most important is my site isn't recognised correctly on the language search and parameter in URL is prensent in search results. This is mostly because the URL are the same for any language (except for language parameter), and unfortunately this can't be changed. It's there any way to have the language in URL like www.mysite.com/en/my-better-product-p-123456.html ? I've seen another Ultimate SEO Url module (bad idea to have the same name for 2 contributions !) but I won't change my URL as they are quite well positioned for some search text and I'm not sure it has this feature. Hope you can help. Thank you !
  7. 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
  8. 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.
  9. 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 !
  10. 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
  11. 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
  12. 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
  13. 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
  14. 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
  15. 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