Search found 468 matches

Search found 468 matches

Re: SOLVED: Best practice: Archive old orders from database

For anyone that searches the forum,
I ended up doing the following:

1. Backup my database
2. Went into phpmyadmin
3. ran the following sql command :
DELETE from `order` where date_added < '2018-01-01'

This deleted orders older from January 1 2018.

Jump to post
  • Sun Nov 15, 2020 7:10 pm
  • Replies 4
  • Views 252
SOLVED: Best practice: Archive old orders from database

I'm wondering what is the best practice to lighten up the database, particularly the order table. I've got about 6 years of orders and would like to lighten it up by only keeping the last 3 years and archiving the rest. I know first and foremost download a back up copy and store it safely. But shoul...

Jump to post
  • Thu Nov 12, 2020 7:30 pm
  • Replies 4
  • Views 252
Re: HIRED: Specific Order Status Extension

Thank you All!
The job was hired out to Krotek who did a great job.

Thank you for all your offers.
I'll post another job here should something come up.

Jump to post
  • Sat Oct 31, 2020 7:24 pm
  • Replies 8
  • Views 546
Re: Specific Order Status Extension

Trish Cis wrote:
Thu Oct 29, 2020 7:38 pm
Hello,
Trust you're keeping good.
Surely, we can assist you on your requirements.
Please Reach me on my Email- Trish@cisinlabs.com
Regards,
Trish
emailed you. Looking to have this done within the hour.

Jump to post
  • Thu Oct 29, 2020 8:43 pm
  • Replies 8
  • Views 546
Re: How to make my website secure for shopping?

All good responses, I also found this helpful back in the day when securing folders etc. In OC http://docs.opencart.com/en-gb/administration/security/ https://webscoot.io/blog/opencart-security/ Checking folder permissions, file permissions on the server is key and I like the suggestion of paying fo...

Jump to post
  • Thu Oct 29, 2020 6:54 pm
  • Replies 8
  • Views 2797
Re: Specific Order Status Extension

Ok, sent you a message on Skype.

Jump to post
  • Thu Oct 29, 2020 6:33 pm
  • Replies 8
  • Views 546
HIRED: Specific Order Status Extension

Posted on upwork but thought I would post on here: I am looking for a simple extension for my opencart 2.3.0.2 php program that will run on our website server and run every 30mins via a cron job I would like a php program that will: 1. Search my database (really on the last 200 lines not the whole d...

Jump to post
  • Thu Oct 29, 2020 6:03 pm
  • Replies 8
  • Views 546
SOLVED Re: And/Or Statement For Order Status

The code needed to be updated. Simple fix

adding a comma
"16,20"
To look for two different statuses

Jump to post
  • Thu Oct 29, 2020 3:33 am
  • Replies 7
  • Views 632
Re: And/Or Statement For Order Status

I think you didn't read my original post ::)

"Right now it only displays on status.
The code is:
order_status" => "16""

Jump to post
  • Wed Oct 21, 2020 6:31 pm
  • Replies 7
  • Views 632
Re: And/Or Statement For Order Status

Thank you but no.
I'm just looking to edit that line. That's all.

Jump to post
  • Tue Oct 20, 2020 10:07 pm
  • Replies 7
  • Views 632
And/Or Statement For Order Status

I made a little label program that displays a list or statuses for me. Right now it only displays on status. The code is: "order_status" => "16" 16 is my shipping label status in Opencart I'm stuck trying to figure out how I add a and/or to that line. I would like it display not only "16" but also "...

Jump to post
  • Tue Oct 20, 2020 9:52 pm
  • Replies 7
  • Views 632
Re: [Developer Needed] Tiered Quantity Module

Did you use above posted module? The default seems to work. I will look into the module. Appreciate it. I will reach out about some other modifications I require as it's not perfect yet. I need a QTY label next to my prices ( /kg) Clients may get confused as to what quantity that number refers too....

Jump to post
  • Fri Sep 11, 2020 6:41 pm
  • Replies 12
  • Views 1538
Re: [Developer Needed] Tiered Quantity Module

You should be able to do this with the standard "Discounts" tab Hi Jay. I wish. The discount tab is limited as you can't do ranges. Per my original post, I need ranges. :-\ I also want to be able to update this through CSV. I have over 500 products. I can't be asked to go 1 by 1. It would take fore...

Jump to post
  • Fri Sep 11, 2020 6:25 pm
  • Replies 12
  • Views 1538
Re: [Developer Needed] Tiered Quantity Module

You should be able to do this with the standard "Discounts" tab Hi Jay. I wish. The discount tab is limited as you can't do ranges. Per my original post, I need ranges. :-\ I also want to be able to update this through CSV. I have over 500 products. I can't be asked to go 1 by 1. It would take fore...

Jump to post
  • Fri Sep 11, 2020 6:12 pm
  • Replies 12
  • Views 1538
[Developer Needed] Tiered Quantity Module

Hi All, I have a job I would like to hire out. Please PM me with your: 1. Website/experience 2. Estimated price The module: My online store sells foods. We have two customer groups. default and wholesale We would like to create a module to show wholesale pricing to our "wholesale group" This pricing...

Jump to post
  • Thu Sep 10, 2020 11:21 pm
  • Replies 12
  • Views 1538
Re: how to make "PayPal Express Checkout " button show below "add to cart" button on the product page

I have looked and I cannot find anything. I found Amazon Pay, Google Pay but no Checkout With Paypal.
Any ideas?

Jump to post
  • Thu Jul 16, 2020 8:12 am
  • Replies 7
  • Views 1137
Re: Check Out With Paypal

No. That was the last thing I thought of.... ::)

If anyone has a link or suggestion please let me know.

Jump to post
  • Tue Jul 14, 2020 7:29 pm
  • Replies 2
  • Views 237
Check Out With Paypal

Using Opencart 2.3.0.2 and want to add a PayPal Checkout Button in the design---layout---checkout page I'm trying to find the "checkout with paypal" extension that will allow me to put the button on my checkout page and cart page. The standard paypal Express checkout that comes with Opencart is not ...

Jump to post
  • Tue Jul 14, 2020 6:42 am
  • Replies 2
  • Views 237

Search found 468 matches