jwah
Forum Replies Created
-
Forum: Plugins
In reply to: [Gift Registry] Reordering of gift itemsThe page sorts them by the item id in MySQL, which generates when you create the item. My hosting provider allows me to access phpMyAdmin so i changed those values in the database in the table ‘wrd_registry_item’
I ended up exporting the SQL INSERT statement to an excel spreadsheet and changing the ids for the order that i wanted them to appear in. Once i finished updating I deleted the contents of the table and ran the insert query to populate all of the items. It looked like this:
INSERT INTO 'jwah_wor1'.'wrd_registry_item' ('id', 'title', 'descr', 'qty_requested', 'price', 'info_url', 'img_url', 'fulfill_dt') VALUES('1', 'Return Flights for 2', 'Help us to get there', '36', '100', '', 'https://pyropenguin.com/wp-content/uploads/2012/03/qantas-a380-airbus-600x450.jpg', NULL), ('2', '2 Nights in LA', 'We''ll need to cure our jetlag before setting out on the road', '1', '120', '', 'https://www.destination360.com/south-america/bolivia/images/s/la-paz-hotels.jpg', NULL), ('3', 'Dinner in LA', 'yum!', '1', '100', '', 'https://encrypted-tbn1.gstatic.com/images?q=tbn:ANd9GcSwvpavbl3VzxP723RXw6h823-vu_SVvn6J96i0zi9HmGCqTCsD', NULL)
If you use the comma as a delimiter when exporting to excel, it should put each field in a different column.
Hope that helps, if you fiddle around in the MySQL admin you should be able to work it out. Or someone who knows php can code a page to do it within WordPress?Forum: Plugins
In reply to: [Gift Registry] Reordering of gift itemsnever mind, still learning wordpress so i’ve changed the keys in phpadmin