Post by Vindojeens » Tue Feb 19, 2019 6:48 am

Hello! :)

I have a problem, I'm runing an extension for exporting all my product to a YML file (2 years already on Opencart 2.3.0.2). The extension runs well.

The extensions allows to specify a SQL "rule" in order to dertermine what products to pick and which not.
This is the "rule" I run:

p.status = true AND p.quantity > 0 AND p.quantity < 15000 AND (p.date_added = date '2016-12-23 22:37:56' OR p.date_added >= date '2017-11-01 21:16:29')

Basically it is self-explamentory. Products are adressed with "p.".

My problem is, i want to extend that rule in the following way:

IF category id=100, above rule should apply, ELSE another rule should apply.

I do not know how to phrase it and I cannot reach the developer and have no means to get support from the author.

Can someone help me?

I am really thankfull for any help as I've been thinking about this for months now and reading a lot, but I lack the basic knowledge of MySQL and PHP.

Newbie

Posts

Joined
Sun Nov 20, 2016 12:49 am

Post by thekrotek » Tue Feb 19, 2019 7:49 am

Well... category ID for products is saved in different table. What is the full SQL query, in which this rule is added?

Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com


User avatar
Expert Member

Posts

Joined
Sun Jul 03, 2016 12:24 am

Who is online

Users browsing this forum: No registered users and 172 guests