Search found 68 matches

Search found 68 matches

Re: Can the order statues be updated when the return is request and vice versa?

@ sw!tch & straightlight Thank you for commenting on the question post in the forum... we taught about the problem in ID the order with a unit identifier for this reason, we used the order_id since the order id will be the same to ID the order and the return. that's why in the query we are using...

Jump to post
  • Fri Jan 29, 2021 12:20 am
  • Replies 7
  • Views 543
Re: Can the order statues be updated when the return is request and vice versa?

@straightlight

Can you provide me an example of how to do it? :-[ ???
because I have no idea

Thank you for your response.

Jump to post
  • Wed Jan 27, 2021 1:36 pm
  • Replies 7
  • Views 543
Can the order statues be updated when the return is request and vice versa?

Can the order statues be updated when the return is request and vice versa? For example: when a customer requested a return the order status doesn't change (weird I think some needs to tell Daniels, team) because if the order is going to be returned it should go to the return order_status_id ( in ou...

Jump to post
  • Wed Jan 27, 2021 11:32 am
  • Replies 7
  • Views 543
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 346
[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 346
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 335
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 335
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 334
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 695
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 695
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 ne...

Jump to post
  • Tue Jun 23, 2020 2:26 am
  • Replies 6
  • Views 695
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 300
[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 ...

Jump to post
  • Mon May 11, 2020 1:56 am
  • Replies 2
  • Views 300
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 3021
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 480
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...

Jump to post
  • Thu Feb 07, 2019 10:34 am
  • Replies 0
  • Views 1690
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 #######...

Jump to post
  • Sat Feb 02, 2019 9:34 am
  • Replies 2
  • Views 289
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 289

Search found 68 matches