Search found 107 matches

Search found 107 matches

Re: Show Product MPN on Invoice

I've done that and it works. Not the most elegant solution but it does the job and is less hassle than having to modify controller files. If anyone else needs to do the same thing just add the following query under this line: foreach ($order['product'] as $product) { $query = "SELECT mpn FROM oc_pro...

Jump to post
  • Thu Jul 18, 2019 8:28 pm
  • Replies 4
  • Views 77
Re: Show Product MPN on Invoice

I suppose I could just run a separate query against each line and manually look up the MPN from the oc_product table.

Jump to post
  • Thu Jul 18, 2019 8:13 pm
  • Replies 4
  • Views 77
Re: Show Product MPN on Invoice

Is there another field I could use as an alternative?

Jump to post
  • Thu Jul 18, 2019 8:10 pm
  • Replies 4
  • Views 77
Show Product MPN on Invoice

We are using the MPN field in the products table to store a product denomination and I want to display this on the customer's invoice next to the quantity ordered. I've edited the order_invoice.tpl file and was hoping I could just <?php echo $product['mpn']; ?> but it doesn't appear that the MPN is ...

Jump to post
  • Thu Jul 18, 2019 6:29 pm
  • Replies 4
  • Views 77
Measuring Blog Conversion Rates

I'm in a situation that I'm sure is familiar to a lot of people running webshops for ill-informed employers. My boss isn't convinced that spending money producing blog posts and good content is worth it. I've been asked to provide stats on how many blog posts led to sales. Not exactly the easiest me...

Jump to post
  • Fri Jul 12, 2019 7:20 pm
  • Replies 1
  • Views 109
Disable automatic stock replenishment after refund

Opencart 2.3.0.2

I would like to disable automatic stock replenishment after a refund but can't see any in-built option to do this.

I figure if I can find the correct PHP file then I can just comment out the update query. Can someone please point me in the right direction?

Thanks

Jump to post
  • Mon Jan 28, 2019 6:25 pm
  • Replies 0
  • Views 195
Re: Received thousands of return requests against order 1

Oh don't worry, it's all backed up every other day. :)

I have setup the Captcha already and am investigating crawl protect as we speak.

Jump to post
  • Fri Jan 25, 2019 6:35 pm
  • Replies 8
  • Views 318
Re: Received thousands of return requests against order 1

To follow up on the above, I've just been looking at some of the return requests and one has a model number of "-1' OR 2+163-163-1=0+0+0+1 -- " there's also another with "-1' OR 2+858-858-1=0+0+0+1 or 'UcvXzCfk'='" Clearly this was an SQL injection attack which I assume OpenCart is designed not to a...

Jump to post
  • Fri Jan 25, 2019 5:33 pm
  • Replies 8
  • Views 318
Received thousands of return requests against order 1

Last night we received 2025 return requests against order number 1. These are not genuine and the name and email used in each one where just random strings and sample@email.tst. The telephone number was listed as 1 waitfor delay '0:0:111' -- - which suggests some sort of hack attempt. Obviously I ca...

Jump to post
  • Fri Jan 25, 2019 5:31 pm
  • Replies 8
  • Views 318
Re: Force customer's quantity to increment by X amount

Yeah, that's another extension that allows customer to setup notification for when out of stock products are in stock again. Any advice on how I can get the two working together? Thanks for your help by the way.

Jump to post
  • Thu Jan 10, 2019 5:31 pm
  • Replies 10
  • Views 275
Re: Force customer's quantity to increment by X amount

I just redownloaded it and tried it again (2.3.0.2) and still get the same error message. SyntaxError: Unexpected token < in JSON at position 0 OK <b>Warning</b>: Invalid argument supplied for foreach() in public_html/vqmod/vqcache/vq2-system_library_cart_cart.php on line 50 Notice: Undefined index:...

Jump to post
  • Thu Jan 10, 2019 4:56 pm
  • Replies 10
  • Views 275
Force customer's quantity to increment by X amount

Our Opencart store is linked to our local stock database so that when an order is placed the stock is deducted from both systems simultaneously. We have a product in our local database with a denomination of metres. However, we wish to sell it online by the roll (20/50m). How can I limit the custome...

Jump to post
  • Thu Jan 10, 2019 4:28 pm
  • Replies 10
  • Views 275
Re: [vQmod] - Forced Min Quantity Stepping (1.5.x/2.x)

Hey Qphoria, I don't know if you're still developing this but having had it work great for months, we now receive the following error when adding a quantity to the basket. Opencart 2.3.0.2 SyntaxError: Unexpected token < in JSON at position 0 OK Notice: Undefined index: option in vq2-system_storage_...

Jump to post
  • Thu Nov 29, 2018 4:40 pm
  • Replies 25
  • Views 18430
Re: Disable shipping options on certain days

OK, this was a pretty simple fix in the end and here's what I did. My postage methods are all weight-based shipping options. Each shipping method is its own Geo Zone so I can determine which regions accept which shipping method. The file you need to modify is: catalog/model/extension/shipping/weight...

Jump to post
  • Tue May 22, 2018 6:07 pm
  • Replies 1
  • Views 694
[SOLVED] Disable shipping options on certain days

I've added a shipping method called Saturday Delivery, which as the name suggests, allows customers to pay a premium to have goods delivered on a Saturday. What's the easiest way to only show this shipping method on a Friday? I'm guessing a simple VQMOD to look at the current day and if t's a Friday...

Jump to post
  • Tue May 22, 2018 5:35 pm
  • Replies 1
  • Views 694
Re: Recovering from a Malware attack

We are already supposed to be on a VPS so I'm thinking more likely to be the former than the latter. :)

Jump to post
  • Wed Apr 25, 2018 3:59 am
  • Replies 2
  • Views 281

Search found 107 matches