Gift Registry
[resolved] Reordering of gift items (5 posts)

  1. jwah
    Posted 3 years ago #

    is there a way to reorder the gift items?

    They currently list in the order in which they were created, i'd like to change the order that they are displayed. Is this ordered by an auto id that can be changed?


  2. jwah
    Posted 3 years ago #

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

  3. zush
    Posted 2 years ago #

    How would I go about reordering the gifts?

  4. jwah
    Posted 2 years ago #

    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', '', 'http://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', '', 'http://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?

  5. jortiz12885
    Posted 2 years ago #

    Is it possible to add an ecrypted paypal button on the php code? When I set my paypal profile to block Non-encrypted paypal buttons my website wont allow my guests to purchase anything.

    By enabling this feature, any Buy Now, Donation, or Subscription button that is not encrypted will be rejected by PayPal.

    Block Non-encrypted Website Payment:
    Block Non-encrypted Website Payment:

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • Gift Registry
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic


No tags yet.