How Can I Create A Page That Shows A Specific Products Based On A Sql Condition

Developers Dev talks
1

Hi,

How can I create a page that shows a specific products list based on a SQL condition.

I need to retrieve some products from the "products" table that meet a condition ?

Thanks

2

Hi,

How can I create a page that shows a specific products list based on a SQL condition.

I need to retrieve some products from the "products" table that meet a condition ?

Thanks

Hey,

It would be useful to know what condition you are talking about.

Kind regards,

3

Hey,

It would be useful to know what condition you are talking about.

Kind regards,

Hi,

We have a column "col_name", so according to its value we would like to retrieve the products and show them in a page.

Let me know if you are interested in helping me with doing that as a paid service ..

Thanks

4

Hi,

We have a column "col_name", so according to its value we would like to retrieve the products and show them in a page.

Let me know if you are interested in helping me with doing that as a paid service ..

Thanks

Hello,

Sure, no problem. You can contact me at sales@poppedweb.com.

Kind regards,

5

If you use CMS pages in CS-Cart, you can add blocks with specific products to required pages using default functionality.

6

Many thanks friends for your great help ..

I managed to create a block that run a SQL statement and return back the needed products .. then I added the block into a page layout .. I tried to learn from several ready-made addons.. and it worked thanks God.

The requirement was to have a "dynamic" page shows any product in our marketplace available for C.O.D.

We are using 2 addons to restrict/allow C.O.D (one for vendor-level and second for product-level) .. now all is good ..

Thanks indeed ..