Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

paulchen2005

Pioneers
  • Posts

    154
  • Joined

  • Last visited

Everything posted by paulchen2005

  1. Hi, ich empfehle dass Ihr euer Shop local, z.b. mit XAMPP, installiert, dann könnt Ihr dort in Ruhe alle Updates einbauen und testen ob noch alles funktioniert ohne den live shop zu stören, denn das wird einige Zeit beanspruchen... und wenn alles funktioniert könnt ihr, wenn Ihr fertig seit, die Daten hochladen da Ihr jedoch einen Kauf Shop habt wird es schwierig Unterstützung zu bekommen sollten Probleme auftreten... Gruß Paul
  2. ok, please, can you say what must i change in the classes/seo_class.php for send a 404 if a product, categorie or manufacturer is not found? thank you very much, best regards, Paul
  3. Hi Jack, first, sorry for my bad english... i install your SEO contrib and i have on big problem... i have in .htaccess this line: ErrorDocument 404 /catalog/404.php but there ist no redirect to the page 404.php if not found a product or category :( what must i change??? thank you, best regards Paul
  4. Hi, i have install this great contrib in my shop local with xampp :) i have 480 products on my xampp shop... i have: but i have this error: and if i press F5 after some Time this error: what can i do to fill all my tags? the error is coming if i use this option: Keywords Override -Fill keywords for all added pages from derived keywords on actual pages? thank you if you can help me best regards Paul
  5. Hi, i see the error is in the sort_order... what must i change to set the sort_order like the config in the admin?
  6. Hello, I would like to know how I can push in order editor in the list below to display the order total value added to bottom? the time it looks like this: but how do I reach it, as to get by somehow not ...:( I hope someone can help me? greetings Paul
  7. The customers_ID in database is 0... that is not correct if i create a order for an existing customer... :(
  8. Hi, very important is this fix: before: sort($products_stock_attributes, SORT_NUMERIC); // Same sort as QT Pro stock $products_stock_attributes = implode($products_stock_attributes, ','); // update the stock tep_db_query("update ".TABLE_PRODUCTS_STOCK." set products_stock_quantity = products_stock_quantity + ".$order['products_quantity'] . " where products_id= '" . (int)$order['products_id'] . "' and products_stock_attributes='".$products_stock_attributes."'"); add: if (!empty($products_stock_attributes)) { and after the code add: } this is important because there is an error if i delete or update a product without attribute... :)
  9. Hi, here is the next very important bug fix: in: admin/edit_orders_add_product.php: in line 142 under //end sppc patch add: // QT Pro Addon BOF if (isset($_POST['add_product_options'])) { foreach($_POST['add_product_options'] as $option_id => $option_value_id) { $products_stock_attributes[] = $option_id . '-'. $option_value_id; } // for loop sort($products_stock_attributes, SORT_NUMERIC); // Same sort as QT Pro stock $products_stock_attributes = implode($products_stock_attributes, ','); } // QT Pro Addon EOF under: 'products_quantity' => tep_db_prepare_input($_POST['add_product_quantity']), add: 'products_stock_attributes' => $products_stock_attributes); like this: 'products_quantity' => tep_db_prepare_input($_POST['add_product_quantity']), 'products_stock_attributes' => $products_stock_attributes); under: // QT Pro Addon BOF delete: if (isset($_POST['add_product_options'])) { foreach($_POST['add_product_options'] as $option_id => $option_value_id) { $products_stock_attributes[] = $option_id . '-'. $option_value_id; } // for loop sort($products_stock_attributes, SORT_NUMERIC); // Same sort as QT Pro stock $products_stock_attributes = implode($products_stock_attributes, ','); and under: tep_db_query("update ".TABLE_PRODUCTS_STOCK." set products_stock_quantity = ".$new_quantity." where products_id=" . $_POST['add_product_products_id']. " and products_stock_attributes='".$products_stock_attributes."'"); delete: } like this: //end sppc patch // QT Pro Addon BOF if (isset($_POST['add_product_options'])) { foreach($_POST['add_product_options'] as $option_id => $option_value_id) { $products_stock_attributes[] = $option_id . '-'. $option_value_id; } // for loop sort($products_stock_attributes, SORT_NUMERIC); // Same sort as QT Pro stock $products_stock_attributes = implode($products_stock_attributes, ','); } // QT Pro Addon EOF $sql_data_array = array('orders_id' => tep_db_prepare_input($oID), 'products_id' => tep_db_prepare_input($add_product_products_id), 'products_model' => tep_db_prepare_input($product['products_model']), 'products_name' => tep_db_prepare_input($product['products_name']), 'products_price' => tep_db_prepare_input($product['products_price']), 'final_price' => tep_db_prepare_input(($product['products_price'] + $AddedOptionsPrice)), 'products_tax' => tep_db_prepare_input($products_tax), 'products_quantity' => tep_db_prepare_input($_POST['add_product_quantity']), 'products_stock_attributes' => $products_stock_attributes); tep_db_perform(TABLE_ORDERS_PRODUCTS, $sql_data_array); $new_product_id = tep_db_insert_id(); if (isset($_POST['add_product_options'])) { foreach($_POST['add_product_options'] as $option_id => $option_value_id) { $sql_data_array = array('orders_id' => tep_db_prepare_input($oID), 'orders_products_id' => tep_db_prepare_input($new_product_id), 'products_options' => tep_db_prepare_input($option_names[$option_id]), 'products_options_values' => tep_db_prepare_input($option_values_names[$option_value_id]), 'options_values_price' => tep_db_prepare_input($option_value_details[$option_id][$option_value_id]['options_values_price']), 'price_prefix' => tep_db_prepare_input($option_value_details[$option_id][$option_value_id]['price_prefix'])); tep_db_perform(TABLE_ORDERS_PRODUCTS_ATTRIBUTES, $sql_data_array); //add on for downloads if (DOWNLOAD_ENABLED == 'true' && isset($filename[$option_id])) { $Query = "INSERT INTO " . TABLE_ORDERS_PRODUCTS_DOWNLOAD . " SET orders_id = '" . tep_db_prepare_input($oID) . "', orders_products_id = '" . tep_db_prepare_input($new_product_id) . "', orders_products_filename = '" . tep_db_prepare_input($filename[$option_id]) . "', download_maxdays = '" . tep_db_prepare_input($maxdays[$option_id]) . "', download_count = '" . tep_db_prepare_input($maxcount[$option_id]) . "'"; tep_db_query($Query); } //end if (DOWNLOAD_ENABLED == 'true') { //end downloads } } // Update inventory Quantity // This is only done if store is set up to use stock if (STOCK_LIMITED == 'true'){ tep_db_query("UPDATE " . TABLE_PRODUCTS . " SET products_quantity = products_quantity - " . $_POST['add_product_quantity'] . " WHERE products_id = '" . $_POST['add_product_products_id'] . "'"); // QT Pro Addon BOF $stock_chk_q = tep_db_query("select * from " . TABLE_PRODUCTS_STOCK . " where products_id=" . $_POST['add_product_products_id']. " and products_stock_attributes='".$products_stock_attributes."'"); $stock_chk_arr = tep_db_fetch_array($stock_chk_q); $new_quantity = $stock_chk_arr['products_stock_quantity'] - $_POST['add_product_quantity']; // update the stock tep_db_query("update ".TABLE_PRODUCTS_STOCK." set products_stock_quantity = ".$new_quantity." where products_id=" . $_POST['add_product_products_id']. " and products_stock_attributes='".$products_stock_attributes."'"); // QT Pro Addon EOF now will saved products_stock_attributes in TABLE_ORDERS_PRODUCTS and if i delete the complete order in orders.php the qtpro stock will be update correct :)
  10. yes, the one block is for update quantity and the other if i delete a product... in /admin/edit_orders.php are 2 blocks to change same think like above, one block is for update quantity and the other if i delete a product... :) but this is not important if you use the ajax method ;)
  11. Hi, here is my fix, it works :) $attrib_q = tep_db_query("select distinct op.products_id, po.products_options_id, pov.products_options_values_id , pov.products_options_values_name,opa.products_options_values, opa.products_options, opa.products_options_values from products_options po, products_options_values pov, products_options_values_to_products_options po2pov, orders_products_attributes opa, orders_products op where op.orders_id = '" . $_GET['oID'] . "' and opa.orders_id = '" . $_GET['oID'] . "' and op.orders_products_id = '" . $_GET['pid'] . "' and opa.orders_products_id = '" . $_GET['pid'] . "' and po.products_options_name = opa.products_options and pov.products_options_values_name = opa.products_options_values "); best regards Paul
  12. Hi, it works only if your product has one attribute... if the product has more than one attribute it works not :(
  13. the problem is this part: and products_stock_attributes='".$products_stock_attributes."' because products_stock_attributes is 1,2-2,2 but $products_stock_attributes is 1-2 ??? what can i do?
  14. the error was in this code: // QT Pro Addon BOF $attrib_q = tep_db_query("select distinct op.products_id, po.products_options_id, pov.products_options_values_id from products_options po, products_options_values pov, products_options_values_to_products_options po2pov, orders_products_attributes opa, orders_products op where op.orders_id = '" . $oID . "' and op.orders_products_id = '" . $orders_products_id . "' and products_options_values_name = opa.products_options_values and pov.products_options_values_id = po2pov.products_options_values_id and po.products_options_id = po2pov.products_options_id and products_options_name = opa.products_options"); while($attrib_set = tep_db_fetch_array($attrib_q)) { // corresponding to each option find the attribute ids ( opts and values id ) $products_stock_attributes[] = $attrib_set['products_options_id'].'-'.$attrib_set['products_options_values_id']; } sort($products_stock_attributes, SORT_NUMERIC); // Same sort as QT Pro stock $products_stock_attributes = implode($products_stock_attributes, ','); // update the stock tep_db_query("update ".TABLE_PRODUCTS_STOCK." set products_stock_quantity = products_stock_quantity + ".$products_details["qty"] . " where products_id= '" . $order_products['products_id'] . "' and products_stock_attributes='".$products_stock_attributes."'"); // QT Pro Addon EOF because this part: where products_id= '" . $order_products['products_id'] . "' and products_stock_attributes='".$products_stock_attributes."'"); what must i change to ask about products_stock_id and not products_stock_attributes in where clause????
  15. i have the problem too.... if i delete orders with qtpro that was never edited it works fine!!! but not with edited orders and qtpro best regards Paul
  16. hi, great job, thank you for that contrib :) i have a question please, what must i change to add a product manual (without my productlist) ? what must i change to create an input field for manual products input in orderlist? thank you best regards Paul
  17. Hi, i have installed this great contrib and i installed your update but i can not see the page like your screenshot... what must i do to see my page with products like your screenshot? thank you very much, best regards Paul
  18. Hi, what must i change in checkout_shipping_adress.php if the customer without account only edit one error in her address? i can only create a new adress but i can not edit my adress <_< can someone help me to change the checkout_shipping_adress.php that the customer can edit the adress??? thank you very much!!!
  19. Hi, is it possible to combined the login site with create account and this PWA ? i think to use a radio button to register with account or no account... is it possible? what must i change to do that? thank you
  20. Hi, this contrib dont work with attribute and it work not with QTpro... what must i change to work with it? thank you
  21. Hi, is anyone here for help me? i want to start the paypal site only in checkout_success.php ... what must i change? best regards
  22. thank you i have install your contrib Header Tags Controller V2.6.3 Complete ... must i deinstall it to install this contrib ? best regards
  23. Hi, what must i change to use easypopulate with the cross sell contrib ??? thank you
×
×
  • Create New...