Jump to content

bedfordch

Members
  • Content count

    27
  • Joined

  • Last visited

Everything posted by bedfordch

  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
  16. bedfordch

    Get started with STS

    Hi all, I've just installed (first time) the french version of oscommerce (oscommerce-2.2ms2-FR-060817-2010), added the STS template system (STS v4.5.2) and I hope everything is working fine. In fact I've installed the STS module and changed the "template forder" to full and the only change I see is that there is a text that appear to the template: This is the template for index.php page. You can find it here: /includes/sts_templates/full/index.php.html Now In order to test new templates, I've tried to find some free and downloaded some contributions: I've tried the ststemplatehosting and sts-templatechristmas-theme (both in contribution list). This seems stranges to me that I've to change some files in the OsCommerce directory instead of sts_templates dir: in my mind, installing a template means to create ALL files in a separate directory then set the new foldername in the admin sts config. If it's the case (all files in one temlate), I'd like to have a simple template to test for: not a very detailed one, just to see if my system works as I don't know if my installation works (first time I install oscommerce) Also if there is a place to get some free templates for starting from. Thank you !
  17. I know this topic will be a fight place for peoples using one template system or an other, but as a future user of OsCommerce, I'd like your "constructive" help on choosing a system. They are plenty of template systems, some are free, some not. So here are my requirements for those who already use one and by the way do the right choice since I want to start with OScommerce in the best way. required features - very easy to change things (one page to change and a CSS to manage all the layout and the files (top, left, bottom, right, boxes...)) - possibility to change place of menu and differents boxes (for example to be able to put the menu on the top or right easely) - possibility to change buttons, colors, text font, left menu (I hate those ->...) easely without changing much files. - possibility to send template graphic files to the graphic designer and have them returned to put in the template without asking him to know PHP, MySQL.... - Working with the last OsCommerce version - would be a plus: lot of free templates over internet for the selected system to start from (some templates will be done internally). - possibility to add new contributions without changing 200 files... (like a news ticker, a random article choice...)anything. I know some are the "basic" features we may ask to a template system, but I've read people not being happy with a ts because too hard to manage. Also a "plus" that would be interesting for what I want to do: the possibility to have many templates for a website and let the user change templates online without passing by the admin console. I remind you, I'm a newbie with OScommerce, I've just downloaded the last version, not installed it yet. I've seen some template systems and don't know if I would preferably go to those (Zend, CreLoaded or even Joomla as it integrates OsCommerce).... For now I only need a shopping cart but maybe later I'll need more but can still keep things separated. Thanks for your tips and help to start in the best conditions. Bob
  18. bedfordch

    Wich template system is the best ?

    Thanks for your informations. As I've seen Zeos and CREloaded are "packages" that contains a template system. Maybe I mis-understood. For STS or BTS: reading around, STS is far easier to use (1 HTML file and a CSS file). Isn't right ? BTS is the most powerfull one ? Thanks for precisions. Bob
×