Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Fredi

Members
  • Posts

    508
  • Joined

  • Last visited

  • Days Won

    5

Reputation Activity

  1. Thanks
    Fredi reacted to YePix in W3 osCommerce WIP   
    if someone uses the module get 1 free, here is a customer info. List of products with gifts offered in the shop. Just install it where you want it.
    <?php if (defined('MODULE_CONTENT_PRODUCT_INFO_GET_1_FREE_STATUS') && (MODULE_CONTENT_PRODUCT_INFO_GET_1_FREE_STATUS == 'True') ) { $check_get_1_free = tep_db_query("select gf.get_1_free_id from get_1_free gf, products p where gf.products_id = p.products_id"); if (tep_db_num_rows($check_get_1_free)) { ?> <div class="clearfix"></div><hr class="hr-gr mb-2 mt-2"> <div class="mb-2 mt-2 w3-large"><font color="#DD0000"><b><?php echo DISCOUNT_PAGE_MODULE_CONTENT_PRODUCT_INFO_GET_1_FREE_TITLE;?></b></font></div> <?php $products_cart_gift = '<img src="images/cart_gift.png">'; $get_1_free_product_query = tep_db_query("select gf.get_1_free_id, gf.products_id, gf.products_qualify_quantity, gf.products_free_quantity, pd.products_name from get_1_free gf, products p left join products_description pd on p.products_id = pd.products_id where gf.products_id = p.products_id order by gf.get_1_free_id"); while ($get_1_free_product = tep_db_fetch_array($get_1_free_product_query)){ $get_1_free_query = tep_db_query("select gf.products_free_id, p.products_id, pd.products_name from get_1_free gf, products p left join products_description pd on p.products_id = pd.products_id where gf.get_1_free_id = '" . $get_1_free_product['get_1_free_id'] . "' and p.products_id = gf.products_free_id order by gf.get_1_free_id"); if (tep_db_num_rows($get_1_free_query)) { while ($get_1_free = tep_db_fetch_array($get_1_free_query)){ $g1f = $get_1_free['products_name']; $g1f_pfid = $get_1_free['products_free_id']; } if ($get_1_free_product['products_qualify_quantity'] > 1){$pquqt = DISCOUNT_PAGE_TEXT_GET_1_FREE_PROMOTION_FOUR;}else{$pquqt = '';} ?> <div class="mb-2 mt-2 w3-border w3-border-blue w3-leftbar w3-round w3-padding"> <?php echo $products_cart_gift . ' ' . $get_1_free_product['products_qualify_quantity'] . ' ' . $pquqt;?> <a href="<?php echo tep_href_link('product_info.php', tep_get_all_get_params(array('action')) . 'products_id=' . $get_1_free_product['products_id']); ?>"><b class="w3-text-black w3-hover-text-blue"><?php echo $get_1_free_product['products_name'];?></b></a> <?php echo DISCOUNT_PAGE_TEXT_GET_1_FREE_PROMOTION_TWO . ' ' . $get_1_free_product['products_free_quantity'];?> <a href="<?php echo tep_href_link('product_info.php', tep_get_all_get_params(array('action')) . 'products_id=' . $g1f_pfid); ?>"><b class="w3-text-blue w3-hover-text-black"><?php echo $g1f;?></b></a> <?php echo DISCOUNT_PAGE_TEXT_GET_1_FREE_PROMOTION_THREE;?> </div> <?php }}}}?>  
    language:
    define('DISCOUNT_PAGE_MODULE_CONTENT_PRODUCT_INFO_GET_1_FREE_TITLE', 'Geschänkartikel'); define('DISCOUNT_PAGE_TEXT_GET_1_FREE_PROMOTION', '<font color="#990000">ANGEBOT:</font>'); define('DISCOUNT_PAGE_TEXT_GET_1_FREE_PROMOTION_TWO', 'kaufen und Sie bekommen von uns '); define('DISCOUNT_PAGE_TEXT_GET_1_FREE_PROMOTION_THREE', 'dazu geschenkt.'); define('DISCOUNT_PAGE_TEXT_GET_1_FREE_PROMOTION_FOUR', 'identische'); define('DISCOUNT_PAGE_TEXT_GET_1_FREE_ATTRIBUTE_PROMOTION', '<font color="#990000">ACHTUNG!</font> Bei diesem Angebot müssen die'); define('DISCOUNT_PAGE_TEXT_GET_1_FREE_ATTRIBUTE_PROMOTION_TWO', 'im Warenkorb identisch sein'); define('DISCOUNT_PAGE_TEXT_OFFER_ENDS', ' - Zeitlich begrenztes Angebot endet');  
  2. Thanks
    Fredi reacted to clustersolutions in Next osCommerce v4 demo   
    Hope it's alright to provide some suggestions:
    Record the demo session and provide the recording. The sooner people get to see the s/w, repo, and app features the better to find volunteers. For dotcomboomers they'll be thinking what's in it for me, and for millennials they probably will do things for a cause that they believe in. Wiki type content management perhaps people can submit contents that are pending approval? The thought here was to just make it open. Read a story about Elastic Search and on how the founder was dumbfounded as it gained traction after it was put in an opensource git repo. Thanks!
     
     
     
  3. Like
    Fredi reacted to osCommerce-Official in osCommerce v4 demo   
    Edward, 
    To answer your questions in general:
    - osCommerce v4 will be based on the latest version of the Ecommerce platform that has been in development for the last 5.5 years. Not sure about which instance you've seen, but osCommerce v4 will be based on the latest PHP for this year - PHP 8. There are no plans to have an Ecommerce platform competing with osCommerce on the same market after osCommerce v4 is released. 
    - osCommerce v4 is a considerable difference to osCommerce v2 and other solutions, however we would not recommend investing time into learning of the previous versions of this Ecommerce platform. There could be differences in design templates, data structure, etc. There are currently no plans to move customers from their websites built using the previous version of the platform to osCommerce v4. 
    - osCommerce v4 is, first of all, for this community of merchants, developers, designers, consultants, everyone. And of course it is for the world - for far too many years this great brand was not developing and it is time to bring it back to prominence. 
     
     
  4. Like
    Fredi reacted to ejsolutions in osCommerce v4 demo   
    For some strange reason, the developers want a 'phone chat in order to even see the demo! (Nobody here hard-of-hearing or deaf?)
     
    I'm interested in seeing what resources are required to run a small to mid-size store. What is the underlying code like, in terms of tweaks and customisation, to suit client needs? How about just releasing the 'alpha'/'beta' software, so that some of us with a strong osC background can properly see the progress and perhaps even make useful suggestions?
    I've tried out various e-commerce packages in a fruitless attempt to update my few though loyal clients. So far, there's only been one or two "close but no cigar" candidates. There tends to be shortcomings in them all but it's a question of what one can compromise with. Without actually trying the software, there's no real way to tell and no amount of screenshots/YT videos will really get to core issues.
    TLDR: release the code - even if only to a select group.
     
  5. Like
    Fredi reacted to osCommerce-Official in Currencies and Rounding   
    osCommerce v4 will support multiple languages and multiple currencies. Currencies are managed in the back end, under Settings / Localization / Currencies 

    Similar to how it was implemented in previous versions of osCommerce, it is possible to add new or manage existing currencies and set:
    - currency symbol (left and / or right)
    - decimal and thousand separator 
    - decimal digits 
    - the exchange rate against the default currency
    Exchange rate can be updated manually or automatically (via Oanda).
     
    HOWEVER, in osCommerce v4 there exists a new feature called Marketing Prices!

    Marketing prices feature, when enabled (disabled by default), allows setting up custom product price in each currency. So, one and the same product can be $9.99, £8.99, and €9.95 not depending on the actual exchange rate!
    More than that, with Marketing prices comes another wonderful solution called Rounding, something our Swiss customers, for example, will surely appreciate.

    Rounding allows to set how marketing prices shall be rounded in the chosen currency, or how they should all be transformed. There exists an option to round all prices in the selected currency to 0.05 - meaning that 2.21 CHF will turn into 2.20 CHF and 19.93 CHF - into 19.95 CHF. Also to 0.10, or 0.00. There exists an option to set all decimals in all prices to 0.00, or 0.99, or 0.95.  
  6. Like
    Fredi got a reaction from osCommerce-Official in The Unit conversion   
    For stores selling goods to different countries, this option will be useful.
    It will be good if this option is associated with the buyer's country, for example, through the tables in the database - coustomers or address_book or address_format, or zones.
    The client can choose the parameters of weight and dimensions when creating an account or placing an order.
    There should be an option to change these parameters when completing the checkout.

    Why?
    A customer from England can place an order for his beloved girl who lives in France, and the seller's store is located in California.
  7. Like
    Fredi reacted to osCommerce-Official in DB "customer_bascet"   
    Peter, it may be that shopping cart (basket) is stored in a completely different new way. Will be very happy to offer you the code once it becomes available - can't wait in fact  
  8. Like
    Fredi reacted to osCommerce-Official in Order Editor   
    osCommerce v4 comes with a built-in facility to create new orders  (MOTO - mail order / telephone order) and edit existing orders.
    The process of creating an order and editing an existing order is very similar, and uses the same interface in the back end.
    To create a new order the operator shall first choose the sale channel (in case of multiple sale channels), and then either choose an existing customer account or create a new one.
    NOTE: the front end and back end of osCommerce v4 may share payment and shipping methods, but one can have specific backend-only payment and shipping methods. However, if a payment or shipping method is linked to a 3rd party API, that API integration will work as well in the front end as in the back end.
    Adding products is quite easy to a new order. The operator can search by product model, name, etc. Before product gets added to the order, product price can be edited and quantity of items chosen. 
    Order total modules can be edited too. So it is possible to add any type of discount or surcharge, or use an existing coupon that will apply discount as if it was applied in the front end. 
    One done with creating a new order or editing an existing one, the operator shall press the Update and Pay button. It then offers 3 options: 
    - just save - i.e. just save the order without recording any amount paid, thus not evaluation order status further 
    - mark as paid - i.e. if the order was paid for over the phone or in any other way
    - send secure payment link - osCommerce will email the payment link to the customer, so that the customer could pay via the website's secure checkout using one of the available payment methods (works really well with 3d secure, for example)
    In case of a refund being due, it is possible to refund the money to the customer via a compatible payment method, or simply update the order if the refund is being processed outside of osCommerce. 
    osCommerce keep track of amounts paid, and allows to see the amount due or amount owed to the customer.
  9. Like
    Fredi reacted to ozEworks in Order Editor   
    Excellent. This needs to be part of the out of the box offering. 
  10. Thanks
    Fredi reacted to osCommerce-Official in Product quantiy discount   
    Yes, sure! Quantity discounts is a part of osCommerce v4
    Please see how it looks in the back end and front end. 


  11. Like
    Fredi reacted to Gyakutsuki in The Unit conversion   
    Hello
    Just a little question, Do you include this conversion function (gram, kg, liter, pounds ....) ?
    And a weight conversion system for example ?
    In Europe we use the kg by default, in Uk is the pounds, another country can be different.

     
     
  12. Like
    Fredi got a reaction from osCommerce-Official in Translations   
    Russian language - no problem. Continuous support and updates.
  13. Thanks
    Fredi reacted to Hotclutch in App Store or Add-on Store or...?   
    Add-On or Plug-In. There are other free and opensource projects that use these names for extensions so i would call them that. Also "contribution" would be a fine description for the free extensions like in the past.
  14. Thanks
    Fredi got a reaction from raiwa in AJAX Attribute Manager support   
    Hello @raiwa,
    New updated russian file for AJAX Attribute Manager v3.3.5
    attributeManager.zip
  15. Like
    Fredi reacted to valquiria23 in Español pack para OsC Responsive BS EDGE o Gold   
    Muchas gracias Rainer!!! Se que están pasando un mal momento en España. Ojala todo mejore pronto, cuídate mucho!!!
  16. Like
    Fredi reacted to raiwa in Español pack para OsC Responsive BS EDGE o Gold   
    Uploaded Versión 1.0.4.2.r1 for OSCOM CE Phoenix 1.0.4.2.
    Español para OsC CE
    https://github.com/raiwa/OSCOM-CE-Phoenix-Spanish-language-idioma-espanol
    Includes some minor fixes reported by @domiosc and @RonCain
    Update instructions included.
  17. Like
    Fredi reacted to raiwa in AJAX Attribute Manager support   
    You do not need products_attributes.php using Ajax attributes manager 😉
  18. Like
    Fredi reacted to Owl Sauron in View Counter   
    Greetings again.
    Changing the DB to utf8 and the engine from InnoDB to MyISAM solved the problem.
    Yep, the new version has it all hardcoded, but that is not described in the installing manual. We have to compare the chnaged files. Please update the install manual.
    This module is a must in any installation. Keep it on!
    Many thanks for the support!
  19. Like
    Fredi got a reaction from Smoky Barnable in Article Manager v1.0   
    Thanks a lot for answering Jack.
    I know these guys won't give an answer. They have such a principle.
    Harald's updates required a lot of work, but were very simple. Updating in connection with the transition to the SSL was also not very difficult. Updates related to changes in the PHP version were also not very difficult. Most of the users did all these updates themselves.
    Order from professional coders. It is possible, but if you need 1-2 modules. When you need to update an old, large, multifunctional store in which there are many modules, everyone refuses such work. I made applications to almost all the leading coders of OsCommers, but everyone refused my order. I have kept the applications and answers to them in my archive. The main answer is "sorry, I have a lot of work and I don't have time to deal with your store ..."
    The problem is big.
    Today's concept - a stable breaking of the kernel code once a month, creates additional problems. Which coder would dare to adapt an existing store for a phoenix? What guarantees can the encoder give to the customer?
    Nothing wrong. Life is a difficult and difficult path. We will go forward, even if there are artificial obstacles on the way.
  20. Like
    Fredi reacted to raiwa in AJAX Attribute Manager support   
    Uploaded:
    Ajax Attribute Manager 3.3.2
    Requires:
    OsCommerce Phoenix 1.0.7.10+ REQUIRED!
    PHP 7.0 to 7.4
    Changes Version 3.3.2.:
    + added support for Phoenix 1.0.7.10 core sort order
    + removed optional product_options_sort_order support
    + added auto update script for product_options_sort_order to core sort order columns.
    + normalized spacing and indents.
    + updated custom database functions to use core functions.
    + modernized coding to match core standards
    *********************************************************************
    If you were using attributes/options sort order from previous versions:
        - Make a database backup for security if something gets messed up.
        - On first load of this version, the old sort order entries will be migrated to the new core sort order columns.
        - Check your database for success after you loaded the new attributes manager.
        - Use the product info options/attributes sort order content module included in Phoenix 1.0.7.10
    *********************************************************************
     
     
  21. Like
    Fredi reacted to Jack_mcs in Article Manager v1.0   
    @FrediThis is the support thread for an addon so even if Matt or Gary sees it, they may not respond here. You would need to post in the general forum and hope they will reply. 
    However, I'm not sure your complaint is justified. I, and any addon developer, understands the frustration of having  broken addons due to changes in Phoenix. But this has always been the case with oscommerce. When Harald did away with filename and database defines, it broke all existing addons. And when Frozen was released, many addons had to be rewritten to work with it.
    You need to keep in mind that those that support addons do so at their own expense in time. If you wanted to pay a developer to make the needed changes sooner, then I'm sure any would do that. But if you want a free update, then you have to wait until that programmer has time for it. It is the way oscommerce has always worked and hasn't changed much. I agree that having discussions on the code base hidden is the wrong approach and slows its development and popularity but it is what the ones in control have decided to do.
  22. Thanks
    Fredi got a reaction from Jack_mcs in Jssor Slider   
    Thank You Jack!
    Installed the module on a test site, everything works SUPER!👍👌
  23. Thanks
    Fredi reacted to Jack_mcs in Jssor Slider   
    A new version has been uploaded with these changes:
    Added code to delay javascript to make it compatible with Phoenix. Changed code to be compatible with the new advert system (Phoenix only). Changed code to allow text to be shown on the banners. Moved the jssor images to the correct location to match the code.  
  24. Like
    Fredi reacted to Jack_mcs in Article Manager v1.0   
    The difference is that with a blog article, customers can reply to it. So an article might be a page explaining how to use a knife. While a blog article would be about the various knifes you sell and where customer can respond with their views on which is the best one. Getting customers involved is a way of keeping them coming back. I have one client that sells baby clothes and the site has a blog article where customers can post images of their babies.
  25. Thanks
    Fredi got a reaction from Jack_mcs in Article Manager v1.0   
    Error code...
    Line 137 in    article_manager_db_handler.php
    $lines[] = "INSERT INTO configuration (" . $fields . ") VALUES ('Display Box Articles - All Topics Links?', 'ARTICLE_BOX_DISPLAY_TOPICS_LINKS', 'true', 'Display links to individual topics. Requires the Display Box Articles - All Topics Section option to be true. ', '" . $cfg_group_id . "', '" . ($sortID++). "', 'tep_cfg_select_option(array(\'true\', ', now(), NULL)"; Chnge to:
    $lines[] = "INSERT INTO configuration (" . $fields . ") VALUES ('Display Box Articles - All Topics Links?', 'ARTICLE_BOX_DISPLAY_TOPICS_LINKS', 'true', 'Display links to individual topics. Requires the Display Box Articles - All Topics Section option to be true. ', '" . $cfg_group_id . "', '" . ($sortID++). "', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now(), NULL)";  
×
×
  • Create New...