OpenCart Community

HI -
we want to add 'free gift wrap' option to all our products as an option.

Rather than go through the products one by one, is it possible to add options to products via phpadmin 'update' - any advice about which tables are involved?

thank you for any advice on this

As a simple approach, you could try setting the attribute, assigning it to a few products, bagging a database backup to see where the column (field) is, populating that, and restoring the result into place. That is simplified by using a pure text editor (you'll see comma-delimited rows) or a spreadsheet (pre-gridded) that can handle importing and exporting pure ascii text in .csv format which you can rename .sql or one way or another get into the correct column, then restore it into place.