adding column that can get any value from DB via script- with primery key of product id

Mar 28, 2016

סידי סופט תוכנה ומחשוב | CDsoft wrote

hi,

i would like to add feature .

i want the option to add any costume column .
how to do this :
1.add column
2. choose the name of the table in DB that connected to the column ( the table must have productIid as key !
3. write an update mysql , that can update the columns by productid : UPDATE xxx WHERE Productid = yyy

New

3 votes

Vote

11 Answers

Mar 28, 2016

Alex Pryshlivskiy agent wrote

Thanks for suggeston!
Are you talking about special custom SQL where result of execution will be unserted in this additional column in the Product Grid.
Am I right ?
please confirm.

Prestashop-column.png

Mar 28, 2016

סידי סופט תוכנה ומחשוב | CDsoft wrote

YES !!

just to be sure - i can :

insert values or update the values in the column

and i can add at least 3-5 columns

Mar 28, 2016

Alex Pryshlivskiy agent wrote

please don't forget fot this suggestion. Right now we have 0 votes for it.

May 26, 2016

סידי סופט תוכנה ומחשוב | CDsoft wrote

Hi sergiy ,

what is the cost for develop this feature for us ?

May 27, 2016

Alex Pryshlivskiy agent wrote

I need to discuss tech. requirements for this task with our dev. team.
Could you reopen this task on Tuesday?

May 27, 2016

סידי סופט תוכנה ומחשוב | CDsoft wrote

hi,
ok -no problem , thanks

May 30, 2016

Alex Pryshlivskiy agent wrote

I've got discussed this suggestion.
There are 2 major point for the realization:
1. Customer should have strong skills for SQL to operate with data-field
or
2. We need to create visual SQL constructor to manipulate data fields to create such queries.

In this case, task will be converted in the huge sub-task. :-)

But, I agreed, it's very interesting suggestion.
Please vote and comment this idea.

May 30, 2016

סידי סופט תוכנה ומחשוב | CDsoft wrote

hi,

thank you

the first point is the good one.
a user that know ho to work with sql - is a power user that work with your software..

May 30, 2016

סידי סופט תוכנה ומחשוב | CDsoft wrote

and one more...
if the user would like to get the best from your software - he knows how to handle sql...

where to vote ? I've already voted...

hopefully it will be the next version :)

May 31, 2016

Alex Pryshlivskiy agent wrote

Thanks for you vote.
I've afraid, we are going to implement support of the stable PrestaShop ver.1.7. - this is our major task. Let's return to this suggestion after that.

Feb 27, 2019

סידי סופט תוכנה ומחשוב | CDsoft wrote

hi ,
what about this issue ? :)
i've upgraded my licensed from std to pro , because the pro version have custom SQL
the only problem now is to add the data as a column to the products and categories page
what is the issue to develop it specific for us ? what is the cost ?