Jump to content
Latest News: (loading..)

sinopia

Members
  • Content count

    149
  • Joined

  • Last visited

1 Follower

Recent Profile Visitors

1,454 profile views
  1. Hello everyone. Thanks for your answers. About the search engine issues I could redirect as a temp only for the product category as the product is offline. But best thing to do, is to check it's out of stock, and if yes, to disable the button "add to cart" and show a notice that the product is out of stock, this way client won't add the product to shopping cart. (this way avoiding at the shopping cart a message that the product is out of stock.) Best regards.
  2. @JcMagpie let's say it's a lowcost product but the stock is only one quantity. I can always set if the quantity is < 1 to output a message and block the add to cart button. But what I really needed is to set product offline so it won't show on the products listings.. @raiwa I understand, and once I've time I'll migrate into CE. By the way I can't do it right now due the lack of time. I've noticed that I've QT Pro functions in some files but I'm not actually using it. It already came with the theme, can be something related with this?
  3. Hi @JcMagpie it's set to true. Only difference from yours is that "Allow Checkout" is set to false
  4. Hi @raiwa I understand and I'm sorry to ask here and didn't mention the version I'm using. I don't have any solutions. Some parts of the entire code are normal. I do have stock report and it decreases the quantity as the products are bought. Just needed a few modifications to set status of the product to offline when it's the last stock. I've to make just a few modifications on this website and then I can have time to migrate all into CE version, my modifications were made apart the core so that's a start. About this template it doesn't have much modifications about the osCommerce code. Users on the forum can try to help that I might get into the problem, that was a forum is all about, to help each others. Best regards
  5. Hello, I've been looking but didn't find anything. I was looking for some addon or bit of code that set the status of product offline when it became out of stock instead showing a ribbon "out of stock" or at checkout the message that products marked are out of stock. I have some products low cost but with quantity limited, would be more friendly for customer dont saw the product instead of trying to buy it and later have to remove due the stock message. For example when adding to cart a verification after add to cart and then something like this: if (($stock_left < 1) { tep_db_query("update " . TABLE_PRODUCTS . " set products_status = '0' where products_id = '" . tep_get_prid($order->products[$i]['id']) . "'"); } So at the last stock it disables the product.. otherwise I can always do something like if ($product_info['products_quantity'] < 1) And output a message/disable add to cart button ..
  6. sinopia

    Easier Attributes

    Hi @Jack_mcs the osC version weren't but I've updated it manually since the owner/item got removed from themeforest. Probably that's the best thing to do. But for now just needed to really clean a few old products options/attributes. That's only what I need to do. Probably best thing to do is to code something that would clean the product options as their respective linked attributes.
  7. sinopia

    Easier Attributes

    Sorry to answer now. @Jack_mcs I see. Just needed to remove old product options and their respective attributes linked to products. @ArtcoInc let's say it's unofficial release (bought it at themeforest...). Jack I'm using jquery-1.11.1.. can this be related to anything? Because at devtools it shows this line dataArray[0] = 'delete_options'; as "unreachable code after return statement" also this: Synchronous XMLHttpRequest on the main thread is deprecated because of its detrimental effects to the end user's experience For more help http://xhr.spec.whatwg.org/
  8. sinopia

    Easier Attributes

    2.3.4 - PHP 7.2
  9. sinopia

    Easier Attributes

    Even removing this, shows "OK [object Object]" but options keeps to exist.
  10. sinopia

    Easier Attributes

    I can't remove any product option as their attributes unreachable code after return statement easier_attributes.php:182:2 ( dataArray[0] = 'delete_options'; ) Shows: "OK undefined" Ups: didn't read the last post sorry!
  11. sinopia

    mass clean products options and attributes

    Well... I couldn't edit the last post... I'll try to remove those through mysql ... Product options to keep: 17, 18, 19, 20, 21, 22, 23, 24, 25. And options values from 126 to 218. The issue now is that I got 131705 products attributes.. Already with the products that are currently offline. I've take a lot at products_attributes.php and I could do something like this: $option_id = array('17', '18', '19', '20', '21', '22', '23', '24', '25'); // Product Option tep_db_query("delete from " . TABLE_PRODUCTS_OPTIONS . " where products_options_id NOT IN ( '" . implode( "', '" , $option_id ) . "' )"; //Also the products_attributes has those: tep_db_query("delete from " . TABLE_PRODUCTS_OPTIONS_VALUES . " where products_options_values_id = '" . (int)$value_id . "'"); tep_db_query("delete from " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . " where products_options_values_id = '" . (int)$value_id . "'"); tep_db_query("delete from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_attributes_id = '" . (int)$attribute_id . "'"); I'll try the addon "Easier Attributes" as you told.
  12. sinopia

    mass clean products options and attributes

    That makes sense. But +2000 products open each one and disable all that options will take much time. I'll only delete directly the product option I want, that should be fine, right?
  13. sinopia

    mass clean products options and attributes

    Otherwise instead output all products options/values to filter the products. I put them manually with the desired options.. As also to make a clean on the database..
  14. sinopia

    mass clean products options and attributes

    I don't think this would affect orders history as it insert the products_option and value with their name and price... will make a backup and test.
  15. sinopia

    mass clean products options and attributes

    @JcMagpie I'll try to deleted them through products_attributes.php, I just don't have sure about this "This option has products and values linked to it - it is not safe to delete it." Beside the product option and the option values being removed, maybe the old orders that had this attributed selected would give a error when opening?
×