Forum Replies Created

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter jwah

    (@jwah)

    The 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?

    Thread Starter jwah

    (@jwah)

    never mind, still learning wordpress so i’ve changed the keys in phpadmin

Viewing 2 replies - 1 through 2 (of 2 total)