WooCommerce Products Not Syncing

Hi

A customer pointed out today that they weren’t able to select the product they’d purchased from the support ticket list on my site. I checked this out and noticed a number of products were missing. I clicked the re-sync button which duplicated a lot of the product entries. So I deleted all the product entries and clicked the resync button again. Now it only lists 26 of the 36 products I have on my site.

Here’s the report from the tools page:

[{"label":"wordpress","data":[{"key":"Site URL","value":"http://xtant-audio.com"},{"key":"Home URL","value":"http://xtant-audio.com"},{"key":"WP Version","value":"4.6.1"},{"key":"WP Multisite","value":"No"},{"key":"WP Language","value":"en_GB"},{"key":"WP Debug Mode","value":"No"},{"key":"WP Active Plugins","value":"33"},{"key":"WP Max Upload Size","value":"128 MB"},{"key":"WP Memory Limit","value":"128M"},{"key":"WP Timezone","value":"Europe/London (UTC+00:00)"}]},{"label":"server","data":[{"key":"PHP Version","value":"5.6.28"},{"key":"Software","value":"Apache"}]},{"label":"settings","data":[{"key":"Version","value":"3.3.3"},{"key":"DB Version","value":"1"},{"key":"Tickets Slug","value":"ticket"},{"key":"Products Slug","value":"product"},{"key":"Multiple Products","value":"Enabled"},{"key":"Registration Status","value":"Closed"},{"key":"Registration Page","value":"Default"},{"key":"Uploads Folder","value":"The upload folder exists and is writable"},{"key":"Allowed File Types","value":".jpg, .jpeg, .png, .gif, .pdf, .doc, .docx, .txt, .ppt, .pptx, .pps, .ppsx, .odt, .xls, .xlsx, .mp3, .m4a, .ogg, .wav, .mp4, .m4v, .mov, .wmv, .avi, .mpg, .ogv, .3gp, .3g2, .rar"},{"key":"WYSIWYG On Front","value":"Yes"}]},{"label":"pages","data":[{"key":"Ticket Submission","value":"http://xtant-audio.com/submit-ticket/ (#782)"},{"key":"Tickets List","value":"http://xtant-audio.com/my-tickets/ (#781)"}]},{"label":"email-notifications","data":[{"key":"Sender Name","value":"Xtant Audio Support"},{"key":"Sender E-Mail","value":"support@xtant-audio.com"},{"key":"Reply-To E-Mail","value":"support@xtant-audio.com"},{"key":"Submission Confirmation","value":"Enabled"},{"key":"New Assignment","value":"Enabled"},{"key":"New Agent Reply","value":"Enabled"},{"key":"New Client Reply","value":"Enabled"},{"key":"Ticket Closed","value":"Enabled"}]},{"label":"custom-fields","data":[{"key":"Support Staff","value":"Capability: create_ticket, Core: Yes, Required: No, Logged: Yes, Show Column: No, Taxonomy: No, Callback: text"},{"key":"Status","value":"Capability: create_ticket, Core: Yes, Required: No, Logged: No, Show Column: Yes, Taxonomy: No, Callback:"},{"key":"Ticket Tag","value":"Capability: create_ticket, Core: Yes, Required: No, Logged: Yes, Show Column: Yes, Taxonomy: Yes (standard), Callback: taxonomy"},{"key":"Product","value":"Capability: create_ticket, Core: No, Required: No, Logged: Yes, Show Column: Yes, Taxonomy: Yes (custom), Callback: taxonomy"},{"key":"Order","value":"Capability: create_ticket, Core: No, Required: No, Logged: Yes, Show Column: Yes, Taxonomy: No, Callback: select"}]},{"label":"plugins","data":[{"key":"Installed","value":"Aelia Blacklister for WooCommerce by Aelia (Diego Zanella) version 0.8.5.150112-beta, WP Affiliate Manager by wp.insider, wpaffiliatemgr version 2.3.5, Autoptimize by Frank Goossens (futtta) version 2.1.0, Awesome Support WooCommerce by Awesome Support Team version 1.2.0, Awesome Support by Awesome Support Team version 3.3.3, BackWPup by Inpsyde GmbH version 3.3.4, Contact Form 7 by Takayuki Miyoshi version 4.5.1, Docu by Emili Castells version 1.5, WP E-Signature by Approve Me version 1.4.5.3, Enhanced Media Library by wpUXsolutions version 2.3.4, Google Analytics Dashboard for WP by Alin Marcu version 4.9.3.2, HTML5 Responsive FAQ by Aman Verma version 2.5.2, Meta Slider by Matcha Labs version 3.3.7, Table of Contents Plus by Michael Tran version 1601, Aelia Foundation Classes for WooCommerce by Aelia version 1.7.5.160722, WooChimp by RightPress version 2.1, WooCommerce All in One Currency Converter by Dev49.net version 2.7, WooCommerce Amazon S3 Storage by WooThemes version 2.1.3, WooCommerce EU VAT Assistant by Aelia (Diego Zanella) version 1.6.10.161104, WooCommerce PayPal Adaptive Payments by WooThemes version 1.1.5, WooCommerce PDF Invoices & Packing Slips by Ewout Fernhout version 1.5.38, WooCommerce Product Bundles by WooThemes version 5.0.1, Woocommerce Product Tabs by Nilambar Sharma version 1.1, Woocommerce Simple Storewide Sale by Wpgenie version 1.0.6, WooCommerce by WooThemes version 2.6.8, WooCommerce Sales Countdown by Andy Ha (tu@thimpress.com) version 1.9.1, WooCommerce Helper by WooCommerce version 1.7.2, Yoast SEO by Team Yoast version 3.8, WP Cerber by Gregory M version 2.9, WP Maintenance Mode by Designmodo version 2.0.8, WP reCaptcha Integration by Jörn Lund version 1.1.10, WP Super Cache by Automattic version 1.4.8, MailPoet Newsletters by MailPoet version 2.7.5"}]},{"label":"theme","data":[{"key":"Theme Name:","value":"Storefront Child Theme"},{"key":"Theme Version:","value":"1.0"},{"key":"Theme Author URL:","value":"http://woothemes.com"},{"key":"Is Child Theme:","value":"Yes"},{"key":"Parent Theme Name:","value":"Storefront"},{"key":"Parent Theme Version:","value":"2.1.6"},{"key":"Parent Theme Author URL:","value":"https://woocommerce.com/"}]},{"label":"templates","data":[{"key":"Overrides:","value":"registration.php"}]}]