Jump to content

SCH_001

♥Ambassador
  • Content count

    341
  • Joined

  • Last visited

  • Days Won

    1

Everything posted by SCH_001

  1. SCH_001

    Request Product Reviews

    @kymationHi Kim, I know this is an Old Add On but does exactly what I am after. The only question / help I am after is I am seeking to only use the customers_firstname in the email body. Would I do this? I am not a programmer // Get the Orders ID of all shipped orders prior to that date that have not already been emailed $orders_query = tep_db_query ("select o.customers_name, c.customers_firstname, o.customers_email_address, o.orders_id, o.last_modified, o.customers_id from " . TABLE_ORDERS . " o, " . TABLE_CUSTOMERS . " c then further down // Set the customer/order data $customers_name = $orders_array['customers_name']; $customers_firstname = $orders_array['customers_firstname']; $customers_email_address = $orders_array['customers_email_address']; And a but further down again // Placeholder text from the text file to be replaced $search_array = array ( '%%customer_name%%', '%%customers_firstname&&', '%%each%%', '%%link%%', '%%product_list%%', '%%products%%', '%%store_name%%', '%%store_email%%', '%%store_url%%', '%%year%%' ); // Replacement text -- must match the above array $replace_array = array ( $customers_name, $customers_firstname, $each, $link, $products_string, $products, STORE_NAME, $from_address, 'http://' . $site_domain, date ('Y') ); Then in the .tpl I use %%customers_firstname%%
  2. Hi all, I am currently using Frozen BS and seeking recommendations on what apps you have installed for 1. Nicer looking order confirmation and order sent emails - HTML? 2. Sending an email x days after the shipped email to ask for a Face Book review I have had a google but can not find what I am looking for Thanks Troy
  3. Thank you all I have this resolved. If anyone wants to know the changes required please message me
  4. Hi all, in Feozen BS we are still working on ways to manager our stock and have a need for the Date available blurb to appear in list view So need help to have this Appear as below which is list view not worried if next to price or the view / buy buttons.
  5. SCH_001

    NEW! Complete Order Editing Tool!

    Thank you @BrockleyJohn
  6. @burt @Dan Cole @BrockleyJohn @raiwa Could any of you kind gentlemen please quote me on achieving this?
  7. SCH_001

    NEW! Complete Order Editing Tool!

    @BrockleyJohn Ok now I have found the issue that a customer advised me about It is to do with the freight options if I select them from the Shipping Quotes: section all is good But if I manually change the freight price then the GST does not get updated
  8. SCH_001

    NEW! Complete Order Editing Tool!

    @BrockleyJohn Please disregard this, I deleted the test product after the sale which I thing screwed it up Leave this with me I think all is good
  9. SCH_001

    NEW! Complete Order Editing Tool!

    Yes same tax class I only have one setup And only 1 module installed
  10. SCH_001

    NEW! Complete Order Editing Tool!

    @BrockleyJohn Howdy, I have found a problem with GST / Tax and the order edit tool the GST is not updated correctly The is installed on Frozen BS, can you please assist. IE see below If I add another item I get this, Hopefully an easy fix
  11. Thank you @raiwa that fixed it, Again many thanks.
  12. In version v2.3.4.1 CE Frozen how can I change the color of the customer comment in the admin orders section Currently a couple of key postage instructions have been missed as it just blends in with the PayPal info The high lighted section in the picture is what I would like to change the colour of
  13. Thank you @raiwa your code did the job. When there is no text there is a small yellow bar as if there is one character there, would this be easy to remove? Not worried if not as what you have supplied is already a mega help @burt also gave me the below code which highlights the full line if anyone would like this option Find this: echo ' <tr class="dataTableRow">' . "\n" Change to: $s = ($orders_history['orders_status_id'] == 1) ? ' style="background: lightblue;"' : null; echo ' <tr class="dataTableRow"' . $s . '>' . "\n"
  14. Thank you all, it will take me a while to get some time to try these options but I will reply back with how it goes Many thanks to all that gave input
  15. We now use the capture and authorize process from PayPal as we need to order in large items as required and some times there is a delay which triggers the customer to cancel and ask for a refund. From experience the customer can lodge a PayPal dispute for the withheld amount and as us the seller can not prove the item has been shipped to the customer the dispute will go the customers way and PayPal will refund the held amount. From talking to PayPal they suggest working with the customer to assist them in understanding why the PayPal fee component of the transaction has not been refunded. To date I have only had one customer file a dispute and that was for a whole $4 something WTF, but as said above they won the dispute and PayPal refunded it to them.. Then you may ask why not add the PayPal fee to every order, my reply is our markup is already enough to cover merchant and PayPal fee's but not when a customer cancels.. Hope this helps
  16. SCH_001

    Payitlater AU Module

    Hi all, I have had a good read threw the thread "Anyone made a module for Afterpay or Zippay (Australia)" and it seems not much has been resolved for these. I have not had any luck getting a ZIPPAY account but have now got a Payitlater account and as like the other thread need a module. There is modules for WooCommerce and shipify can these be re-written for OSC? If so can someone with the skill to do this please contact me
  17. SCH_001

    Payitlater AU Module

    Anyone? Surely there is someone on here that can help me?
  18. Hi all, I have found that some of google and facebook pages say "you must have Javascript enabled in your browser to utilize the functionality of this website" Which is not the best of things to tell the public. How can I resolve this / stop this happening? On face books it's only as the type of ad from Facebook wanted me to promote my website showing my a sample of what an ad could be...
  19. Hi All, I regularly use Multi Products Manager v2.9 to move products from place to place in the shop but have a need to be able to sort the list by status. The code is not that old "28th July 2019 Multi Products Manager v2.9" but the tread has been archived.. Can anyone assist me with this? I can post the php if that will help
  20. Thank you @mhsuffolk and @ecartz this has got me sorted for now...
  21. I can not find where it would be File attached products_multi.php
  22. Opps that was search let me look again
  23. It's currently arranged by Product name but would like to be able to have a few options at the top to arrange the list by <?php $categories_count = 0; $rows = 0; if ($_REQUEST['search']) { if($cat_stat==1) { $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id, c.sort_order, c.date_added, c.last_modified, c.categories_status from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '" . $languages_id . "' and cd.categories_name like '%" . $_REQUEST['search'] . "%' order by c.sort_order, cd.categories_name"); } else { $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id, c.sort_order, c.date_added, c.last_modified from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '" . $languages_id . "' and cd.categories_name like '%" . $_REQUEST['search'] . "%' order by c.sort_order, cd.categories_name"); } } else { if($cat_stat==1) { $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id, c.sort_order, c.date_added, c.last_modified, c.categories_status from categories c, categories_description cd where c.parent_id = '" . $current_category_id . "' and c.categories_id = cd.categories_id and cd.language_id = '" . $languages_id . "' order by c.sort_order, cd.categories_name"); } else { $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id, c.sort_order, c.date_added, c.last_modified from categories c, categories_description cd where c.parent_id = '" . $current_category_id . "' and c.categories_id = cd.categories_id and cd.language_id = '" . $languages_id . "' order by c.sort_order, cd.categories_name"); } } while ($categories = tep_db_fetch_array($categories_query)) { $categories_count++; $rows++;
  24. SCH_001

    Windows .sql editor

    Hi all, in OSC I have been backing up my database but it's now too large to restore via OSC And I don't need to restore the whole database. Is there a Windows editor that I can open the .sql file with and remove the tables that I don't need to restore?
×