Search found 66 matches

Search found 66 matches

Re: How to add the products in the order to comments history when updated from the admin end...

@letxobnav

Thank you very much for your solution and to shows us where we were having the issue, were calling products from the products in the variables instead of calling from the array...
your solution is short and it does what we need.

Thank You

Jump to post
  • Wed Jul 22, 2020 12:27 am
  • Replies 2
  • Views 205
[SOLVED] How to add the products in the order to comments history when updated from the admin end...

Add products to order comments history when updated from the admin end. is there any way to add the products automatically. The list of products in the order when the order status updates to the shipping status we are trying this function but it only adds one product in the list (usually the last pr...

Jump to post
  • Sat Jul 18, 2020 4:59 am
  • Replies 2
  • Views 205
Re: Update product data, quantity and price, for all products that have the same SKU, can be possible?

@ thekrotek.


Thank you for your response.
but we don't want to go to the DB every time to run a query to update the products that's why we are looking for a way to this automatically...

Jump to post
  • Sat Jul 18, 2020 3:16 am
  • Replies 3
  • Views 182
Update product data, quantity and price, for all products that have the same SKU, can be possible?

we are looking for a way to update the product data for every product that has the same SKU, every time some made a purchase in the site, we would like to the product data Quantity be also update to all the products having the same SKU, so far we are doing manually but it will be easier to update al...

Jump to post
  • Sat Jul 18, 2020 3:12 am
  • Replies 3
  • Views 182
How to add "Model" into the product meta tag description automatically when a new product is added

Is there a way to add "Model" into the product meta tag description automatically when a new product is added... :crazy:
I remember that was something posted some time ago, but now I can't find the post. ???

Thank you

Jump to post
  • Sun Jul 12, 2020 8:04 am
  • Replies 3
  • Views 187
Re: Wildcard Update via PhpMyadmin - Order Status X to New Order Status Y

@ sw!tch, Thank you for your helpful response. but unfortunately, It doesn't work both queries will only update the status of the orders but the status on the order history has not changed, so when the query is run it only updates the orders but if the status on the order history doesn't change at a...

Jump to post
  • Sun Jul 05, 2020 4:19 am
  • Replies 6
  • Views 460
Re: Wildcard Update via PhpMyadmin - Order Status X to New Order Status Y

@ thekrotek

Thank you but I try the query it didn't work for me...
maybe my query is wrong?

Code: Select all

UPDATE `order` SET `order_status_id`=20 WHERE `order_status_id`=5;


OC v3.0.2.0

Jump to post
  • Thu Jul 02, 2020 2:15 am
  • Replies 6
  • Views 460
Wildcard Update via PhpMyadmin - Order Status X to New Order Status Y

Wildcard Update via PhpMyadmin - Order Status X to Order Status Y ??? we add a new order status on our site "Order Shipped" the order_status_id=20, we would like to do a wildcard update in the database via PhpmyAdmin to update everywhere the order_status_id=5 "Complete" to the new order_status_id=20...

Jump to post
  • Tue Jun 23, 2020 2:26 am
  • Replies 6
  • Views 460
Re: Update product weight via SQL query, PHPMyAdmin, (about 200 products) using "weight_class_id"

@ cyclops12 Thank you, this one did the trick... I appreciate your took the time to respond to this post. if anyone is looking for a solution here is a BIG THANKS to cyclops12 for the solution. Have you tried UPDATE `oc_product` SET `weight`='8.00000000' WHERE `weight_class_id`='4' ALWAYS backup fir...

Jump to post
  • Mon May 11, 2020 3:49 am
  • Replies 2
  • Views 111
[SOLVED] - Update product weight via SQL query, PHPMyAdmin, (about 200 products) using "weight_class_id"

Hi everyone! I'm looking for an easy way to update the weight of around 200+ products they all are using the same "weight_class_id", we try a few queries via phpMyadmin, but they did not work, can anyone point me to the right query if possible provide us the solution. here are the queries we already...

Jump to post
  • Mon May 11, 2020 1:56 am
  • Replies 2
  • Views 111
Re: error code shows sql username / passwords plain text

@ letxobnav where do I place this? there is two startup.php one on system/startup.php and the other one on catalog/controller/startup/startup.php In order to show the maintenance page when we cannot get a database connection and not some strange error message not intended for customers or a mere bla...

Jump to post
  • Thu Mar 26, 2020 2:51 am
  • Replies 6
  • Views 1526
USPS How to Allow First Class Mail to appear as an option when the package weight less than 2LB - No only for less 13 oz

Hi every one is there a way to allow the First Class Mail to be shown as an option when the package weight is less the 2lb and No only for less 13 oz. I was looking at the $weight = ($weight < 0.1 ? 0.1 : $weight); $pounds = floor($weight); $ounces = round(16 * ($weight - $pounds), 2); // max 5 digi...

Jump to post
  • Fri Mar 08, 2019 2:43 am
  • Replies 3
  • Views 343
New Dashboard Total - Modification just release!

The new dashboard total offers the following benefits to your online store. Check it out you may find it helpful https://www.opencart.com/index.php?route=marketplace/extension/info&extension_id=36115 #1 Total Orders has been designed to meet your online store needs. a) now you can see your total dai...

Jump to post
  • Thu Feb 07, 2019 10:34 am
  • Replies 0
  • Views 1013
Re: Error log can the errors be Group by day? instead of long list of errors

@ paulfeakins Thank you for your answer, is there any other way to do it without cronjob? so something like this will not work correctly... $midnight = mktime(0,0,0, date("n"), date("j"), date("Y")) / (3600*24); if(isset($midnight)){ $this->log->write("\n\n ########## New erros for" . date('M/d/Y') ...

Jump to post
  • Sat Feb 02, 2019 9:34 am
  • Replies 2
  • Views 216
Error log can the errors be Group by day? instead of long list of errors

Hi everyone, is there any way to group the error log by day, instead of just having a long list of errors we would like to separate the errors that happen each day. as now the error log shows the errors as 01-29-2019 10:03:11 AM - PHP Notice: blabla bla 01-29-2019 10:03:20 AM - PHP Notice: blabla bl...

Jump to post
  • Fri Feb 01, 2019 3:45 am
  • Replies 2
  • Views 216
PayPal Express Shipping Method not updating when the option is change - in PayPal Express Confirmation Page

Hi everyone is anyone getting this error - just notify today by one of our customers checking out with PayPal express (default one) and then we replicate the issue regarding the shipping method - shipping options, after login from the PayPal Express pop window you are redirected to PayPal confirmati...

Jump to post
  • Wed Jan 23, 2019 5:26 am
  • Replies 0
  • Views 463
Re: Automatic delete coupon when they expired and the total used is 0 from the DB

@ OSWorX.

I really don't understand your response...

Code: Select all

date_end = date_end + INTERVAL 1 DAY < NOW()

Code: Select all

(UNIX_TIMESTAMP(date_end) + 172800) < UNIX_TIMESTAMP(NOW())")
but thank you for taking the time to read my post.

Jump to post
  • Wed Dec 05, 2018 3:00 am
  • Replies 2
  • Views 331
We Do Not Ship To Your Country - New modification just release

Hi everybody I just resale a new modification to block the user from accessing your site if you don't ship to their countries. We Do Not Ship To Your Country. Are you tire of the request if you ship to their country? This modification will help you not only of blocking people from counties you do no...

Jump to post
  • Fri Nov 30, 2018 10:02 am
  • Replies 0
  • Views 730

Search found 66 matches