Post by jackie » Fri Mar 29, 2013 10:00 pm

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

New member

Posts

Joined
Thu Mar 01, 2012 11:26 pm

Post by butte » Sat Mar 30, 2013 11:09 am

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.

Guru Member

Posts

Joined
Wed Mar 20, 2013 6:58 am
Who is online

Users browsing this forum: No registered users and 32 guests