I’m hosting a large art retreat the end of April, with 50+ events and expecting 300-500 people.<\/p>\n
My site is powered by WooCommerce.<\/p>\n
Orders have come in as complete although PayPal didn’t finish the transaction. People clicked the Submit button multiple times, so they had 2-6 orders for the same tickets.<\/p>\n
I Trashed Orders, refunded, etc. to get all the orders in sync with PayPal. <\/p>\n
But that’s made the numbers for Total Tickets Sold, Complete, etc. useless. They are all out of sorts.<\/p>\n
I’ve attached a few screen shots as examples. Dozens of the events are now like this:<\/p>\n
Encaustic Mask Assemblages: <\/strong>Only 6 tickets were actually sold. The rest were in Trashed orders. The max for the event is 24. Showing “9 Sold” doesn’t make sense (doesn’t tie to the 6 listed as Tickets). Only 6 were sold. You’ll only find 6 Completed Orders (rest were Trashed and Trash was Emptied). 15 Seats max. So, there should be 9 remaining. Page says 18 Remaining.<\/p>\n Ancestor Art: Encaustic Story Collage: <\/strong> Only 2 tickets were actually sold. The rest were in Trashed orders. The max for the event is 24. Showing “9 Sold” doesn’t make sense (doesn’t tie to the 2 listed as Tickets). Only 2 were sold. You’ll only find 6 Completed Orders (rest were Trashed and Trash was Emptied). 15 Seats max. So, there should be 13 remaining. Page says 15 Remaining.<\/p>\n Art Journaling with PanPastels: <\/strong>Only 6 tickets were actually sold. The rest were in Trashed orders. The max for the event is 24. Showing “9 Sold” doesn’t make sense (doesn’t tie to the 6 listed as Tickets). Only 6 were sold. You’ll only find 6 Completed Orders (rest were Trashed and Trash was Emptied). 20 Seats max. So, there should be 14 remaining. – page says 18 Remaining.<\/p>\n The listing of tickets is correct. I’m not sure why the site isn’t just counting the listing and using that as SOLD and then subtracting that from the Max to get Remaining.<\/p>\n Do you have a script I can run to fix this mess? <\/p>\n How can I get SOLD to actually reflect the existing completed orders in Woo?<\/p>\n And then get the “Remaining” to reflect the max minus SOLD?<\/p>\n I’m way nervous I’m going to oversell these events because of oddities in how the site interprets SOLD and REMAINING.<\/p>\n Please advise!
\nThanks!<\/p>\n","protected":false},"template":"","class_list":["post-1223965","topic","type-topic","status-closed","hentry"],"yoast_head":"\n