Jump to content
Latest News: (loading..)

All Activity

This stream auto-updates     

  1. Past hour
  2. Today
  3. Yesterday
  4. ce7

    SPPC - for 2.3.4

    hi 🧚‍♂️ @raiwa I do put both at the same time! 😅 I will try to uninstall the Gold version now. Thank you so much for always give the great support!!! 👍
  5. MrPhil

    Change ...| store name to ..-store name

    Ah, good. I got the feeling you were talking about the page title. The fix I gave may only apply to "category" titles, and you may need to change other SEPARATORs.
  6. Ok so that was relatively simple. Simply go into includes / modules / content / header / templates / catmenu.php line 27 you will find: <i class="fas fa-chevron-down"></i> <?php echo TEXT_COLLAPSE_MENU; ?> replace this with: <span class="icon-bar"></span><span class="icon-bar"></span><span class="icon-bar"></span> which draws the 3 lines of the hamburger! just need to left float this now.
  7. Thank you, that's great. Now to complete the horizontal menu it would be great it I can change the categories button that appears on re-size to a hamburger button. Of course I'll have to re-think the top menu hamburger button, but I think its better placed for the navigation bar, people are more accustom to it there. I'll post when I work out how to do this, but if anyone already has I would love to hear.
  8. driven22

    Change ...| store name to ..-store name

    Perfect MrPhil Thank You
  9. raiwa

    SPPC - for 2.3.4

    Hello Lyn, This version is already very outdated. It was updated from the old version for 2.3.4. BS Gold and may have more issues to wget it working weell with the latest EDGE versions and PHP 7. I know that you spent already time in the installation, but if you do not need more than one wholesale group, it might be worth to start over with my Wholesale (SPPC) light add-on which is complete new coded, up to date for latest EDGE and CE Frozen and much easier and less job to install. https://apps.oscommerce.com/VWUpG&wholesale-sppc-lite
  10. ce7

    SPPC - for 2.3.4

    the file with customers_group_price, customers_group_id is actually @ admin/includes/functions/general.php Find: $products_query = tep_db_query("select p.products_id, pd.products_name, p.products_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by products_name"); while ($products = tep_db_fetch_array($products_query)) { if (!in_array($products['products_id'], $exclude)) { $select_string .= '<option value="' . $products['products_id'] . '">' . $products['products_name'] . ' (' . $currencies->format($products['products_price']) . ')</option>'; } } Replaced with: //BOF 0716 Separate Pricing Per Customer if (!in_array($products['products_id'], $exclude)) { $price_query=tep_db_query("select customers_group_price, customers_group_id from products_groups where products_id = " . $products['products_id']); $product_prices=array(); while($prices_array=tep_db_fetch_array($price_query)){ $product_prices[$prices_array['customers_group_id']]=$prices_array['customers_group_price']; } reset($all_groups); $price_string=""; $sde=0; while(list($sdek,$sdev)=each($all_groups)){ if (!in_array((int)$products['products_id'].":".(int)$sdek, $exclude)) { if($sde) $price_string.=", "; $price_string.=$sdev.": ".$currencies->format(isset($product_prices[$sdek]) ? $product_prices[$sdek]:$products['products_price']); $sde=1; } } $select_string .= '<option value="' . $products['products_id'] . '">' . $products['products_name'] . ' (' . $price_string . ')</option>\n'; } // EOF Separate Pricing Per Customer } // end while ($products = tep_db_fetch_array($products_query)) //EOF 0716 Separate Pricing Per Customer I tried to use unmodified specials.php but it is showing up the same error, and go back to check on the installation and found out the code is modified @ general.php, not sure how to fix it in order to get rid of this 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 select customers_group_price, customers_group_id from products_groups where products_id =
  11. ce7

    Product Listing

    hi Eddy, @Moxamint Thank you for reply and point it out the problem. I think when I did copy and paste, I maybe accidentally comment out without notice. I will give it a try and see how it goes after I fixing other issues. And I will get back to post again, thank you again! Lyn
  12. If you refer to the (left) column categories box: admin => modules => boxes => Categories => Remove Module
  13. ce7

    SPPC - for 2.3.4

    hi @Dan Cole @greasemonkey Thank you for reply. I downloaded from addons.oscommerce.com/info/0716 (20151005) BOOTSTRAP - SPPC 2.3.4 BS GOLD - v1.1b version. it said: Line 33 [41 in edited file] **AFTER** add the mentioned code. I am not programmer, know a bit only SQL so no idea how to fix this....just follow the installation instruction... I know it is not a good idea to mix the addons in different version, but few 2.2 version still working perfect with 234.1Edge (BS), so I gave this a try, not sure if the complete add one working or not, but with the admin, assign customer group or attribute group, it seems working, admin/specials.php is the only file so far have the error message.... Thanks! Lyn
  14. I love this add on. So simple to install. But can anyone tell me, how do I now disable the vertical menu. I'm probably missing the obvious! many thanks
  15. @puggybelle Open your template_top.php file FIND <script defer src="https://use.fontawesome.com/releases/v5.0.6/js/all.js"></script> REPLACE WITH <!--<script defer src="https://use.fontawesome.com/releases/v5.0.6/js/all.js"></script>//--> <link rel="stylesheet" href="https://use.fontawesome.com/releases/v5.3.1/css/all.css" integrity="sha384-mzrmE5qonljUremFsqc01SB46JvROS7bZs3IO2EmfFsd15uHvIt+Y8vEf7N7fWAU" crossorigin="anonymous"> That should fix it.
  16. Last week
  17. StephanieM3

    change the way sizes show on my websits

    Maybe this (LINK REMOVED) would help with your problem
  18. lucsangel

    Jssor Slider

    Hi Jack ! Just to say thanks for this add-on as Nivo Slider has always had hiccups. In comparison, this is so easy to install and has so many different transitions AND is truly responsive so forget the others !!! As always we can count on you to come up with the best solutions. Thanks again, Jack.
  19. 2.3.4.1 CE I'm using only the BS menu and not the XS one. Only installed the first one. The arrow icons that should be appearing next to my subcats are only displaying small boxes with plus signs in them. The chevron-down icons are appearing next to my main category names, but I guess that's only because they are hard-coded in the files. How can I fix the problem with the other icons not showing? Using the latest version of this contribution. Thanks! - Andrea
  20. There are times when you need to get information about products or customers that is not shown in the admin side of the store. If you are happy to use phpAdmin then its easy to get it direct from the database by running a sql query. If your not keen on doing that then a simple alternative is to simply use a php file to display the data on screen. Using stock CE lets assume we want to see all customers who purchased a particular product. The code below looks in the database tables “orders” and “orders_products” for a product with the ID of 34 and prints onto the display all customers who purchased that product. The code can show much more depending on how you set the filters. <?php /* Attempt MySQL server connection. Assuming you are running MySQL server with default setting (user 'username' password'database name) */ $link = mysqli_connect("localhost", "username", "password", "database name"); // Check connection if($link === false){ die("ERROR: Could not connect. " . mysqli_connect_error()); } // Attempt select query execution $sql = "SELECT * FROM orders_products,orders where orders_products.products_id = 34 AND orders.orders_id Group by orders.orders_id "; if($result = mysqli_query($link, $sql)){ if(mysqli_num_rows($result) > 0){ echo "<table>"; echo "<tr>"; echo "<th>id</th>"; echo "<th>name</th>"; echo "<th>email</th>"; echo "<th>telephone</th>"; echo "<th>orders-ID</th>"; echo "<th>company name</th>"; echo "<th>country</th>"; echo "<th>product ID</th>"; echo "<th>Model</th>"; echo "<th>Name</th>"; echo "<th>quantity</th>"; echo "<th>Price</th>"; echo "</tr>"; while($row = mysqli_fetch_array($result)){ echo "<tr>"; echo "<td>" . $row['customers_id'] . "</td>"; echo "<td>" . $row['customers_name'] . "</td>"; echo "<td>" . $row['customers_email_address'] . "</td>"; echo "<td>" . $row['customers_telephone'] . "</td>"; echo "<td>" . $row['orders_id'] . "</td>"; echo "<td>" . $row['customers_company'] . "</td>"; echo "<td>" . $row['customers_country'] . "</td>"; echo "<td>" . $row['products_id'] . "</td>"; echo "<td>" . $row['products_model'] . "</td>"; echo "<td>" . $row['products_name'] . "</td>"; echo "<td>" . $row['products_quantity'] . "</td>"; echo "<td>" . $row['products_price'] . "</td>"; echo "</tr>"; } echo "</table>"; // Free result set mysqli_free_result($result); } else{ echo "No records matching your query were found."; } } else{ echo "ERROR: Could not able to execute $sql. " . mysqli_error($link); } // Close connection mysqli_close($link); ?> Here we see what is shown on the screen, As you can see all orders for product with ID 34 are listed with customers info. Using the same code with a small change we can list all order placed by each customer. The only chnage in the code is this line, All we are doing is geting data from 2 tables and sorting it with a filter for orders_id and orders_products_id common to a customers_id. $sql = "SELECT * FROM orders,orders_products where orders.orders_id = orders_products.orders_products_id"; The whole code is, <?php /* Attempt MySQL server connection. Assuming you are running MySQL server with default setting (user 'username' password' database name) */ $link = mysqli_connect("localhost", "username", "password", "database name"); // Check connection if($link === false){ die("ERROR: Could not connect. " . mysqli_connect_error()); } // Attempt select query execution $sql = "SELECT * FROM orders,orders_products where orders.orders_id = orders_products.orders_products_id"; if($result = mysqli_query($link, $sql)){ if(mysqli_num_rows($result) > 0){ echo "<table>"; echo "<tr>"; echo "<th>id</th>"; echo "<th>name</th>"; echo "<th>email</th>"; echo "<th>telephone</th>"; echo "<th>orders-ID</th>"; echo "<th>company name</th>"; echo "<th>country</th>"; echo "<th>product ID</th>"; echo "<th>Model</th>"; echo "<th>Name</th>"; echo "<th>quantity</th>"; echo "<th>Price</th>"; echo "</tr>"; while($row = mysqli_fetch_array($result)){ echo "<tr>"; echo "<td>" . $row['customers_id'] . "</td>"; echo "<td>" . $row['customers_name'] . "</td>"; echo "<td>" . $row['customers_email_address'] . "</td>"; echo "<td>" . $row['customers_telephone'] . "</td>"; echo "<td>" . $row['orders_id'] . "</td>"; echo "<td>" . $row['customers_company'] . "</td>"; echo "<td>" . $row['customers_country'] . "</td>"; echo "<td>" . $row['products_id'] . "</td>"; echo "<td>" . $row['products_model'] . "</td>"; echo "<td>" . $row['products_name'] . "</td>"; echo "<td>" . $row['products_quantity'] . "</td>"; echo "<td>" . $row['products_price'] . "</td>"; echo "</tr>"; } echo "</table>"; // Free result set mysqli_free_result($result); } else{ echo "No records matching your query were found."; } } else{ echo "ERROR: Could not able to execute $sql. " . mysqli_error($link); } // Close connection mysqli_close($link); ?> To use simply save the required code as say get_product_info.php, I would save it in your admin directory to keep it secure! Don't for get you need to enter you own details at the head of the file to connect to your database. /* Attempt MySQL server connection. Assuming you are running MySQL server with default setting (user 'root' password'database name) */ $link = mysqli_connect("localhost", "username", "password", "database name"); We are only reading from the db so should not have any problems but as allways to be safe backup first.
  21. MrPhil

    Change ...| store name to ..-store name

    Try this: in includes/languages/english/modules/header_tags/ht_category_title.php (or change the language if you're using a non-English one) look for define('MODULE_HEADER_TAGS_CATEGORY_SEO_SEPARATOR', ' | '); and try changing ' | ' to ' - '. There are other "SEPARATOR" entries in the language support that you may want to change, too.
  22. Jack_mcs

    Change ...| store name to ..-store name

    Sorry but it is still not clear to me. Are you referring to the breadcrumb? It would be better if I, or others that may be confused, didn't have to guess. Please attach a screenshot.
  23. driven22

    Change ...| store name to ..-store name

    I would like to change in webpage title mark | to mark - . Now when i enter to subpages always display after page tite ... | kuzdrowiu24-shop. I would like to change this to ... - kuzdrowiu24-shop. Example: now is: "Herbals | kuzdrowiu24-shop". I would like to change this: "Herbals - kuzdrowiu24-shop".
  24. Jack_mcs

    Change ...| store name to ..-store name

    I'm not sure what your question is but the store name is a setting in admin->configuration->My Store. If that doesn't help, please explain in more detail or provide a screenshot.
  25. Hi, I can't find how to change sign | before store name to -before store name. I have 2.3.4 CE BS, Please help me
  26. Moxamint

    Product Listing

    @ce7 The 20th line from the bottom is not quite right: } //else { Did you comment out the 'else' for a specific reason? It'll screw up the logic. Eddy
  27. supercheaphobb

    phpadmin query to export stock

    Ok in case anyone else wants this. It will create a report giving c.categories_id, cd.categories_name, p.products_model, pd.products_name, p.products_quantity, products_image, p.products_price, products_weight, pd.products_description, tc.tax_class_title, m.manufacturers_name SELECT c.categories_id, cd.categories_name, p.products_model, pd.products_name, p.products_quantity, products_image, p.products_price, products_weight, pd.products_description, tc.tax_class_title, m.manufacturers_name FROM products p, products_description pd, products_to_categories p2c, categories c, categories_description cd, manufacturers m, tax_class tc WHERE p.products_id = pd.products_id AND p.products_id = p2c.products_id AND p2c.categories_id = c.categories_id AND p2c.categories_id = cd.categories_id AND p.manufacturers_id = m.manufacturers_id AND p.products_tax_class_id = tc.tax_class_id AND p2c.categories_id = 322 AND pd.language_id = '1'
  28. supercheaphobb

    phpadmin query to export stock

    And also how to only query one catergory id
  1. Load more activity
×