Product(s) not syncing

[cole007]

Description

We have a site that products are periodically synced (from Shopify) on.
In this particular instance client has raised concerns about some products not showing.
I could not see either record in the 2x shopify database tables.

Forcing a sync (both via Utilities and console command) does not seem to resolve.
However now looking at the database directly I can see the product in the shopify_productdata table but not the shopify_products table.

The former is showing the record having been created and updated at 2024-06-26 15:45:51 whilst the product itself was added to Shopify earlier today (2024-06-26 10:39:08).

I would have expected if it was in either table it to be reflected in both so not quite sure what has happened here.

Any suggestions on rectifying?

Additional info

• Craft version: 4.10.2
• PHP version: 8.2.20
• Database driver & version: MySQL 5.7.42
• Plugins & versions:

Blitz 4.18.2
CKEditor 3.8.3
CP Field Inspect 1.4.4
DigitalOcean Spaces Filesystem 2.0.0
Element API 4.1.0
Elements Panel 2.0.0
Embedded Assets 4.1.0
Environment Label 4.0.3
Formie 2.1.19
Hyper 1.1.32
Imager X 4.4.1
Inventory 3.2.0
Mud Craft Core 1.1.1
Navigation dev-craft-4
Neo 4.2.5
Postmark 3.1.0
Quick Field 2.0.8
Ray 2.1.1
SEO 4.0.50
Shopify 4.1.2
Sprig 2.8.1
Typed link field 2.1.5
Vite 4.0.9

We also have a custom module that does have an event listener on product sync to force Blitz refreshing affected URLs.

[linear]

PT-1897 Product(s) not syncing

[cole007]

Please disregard - update to latest plugin version has fixed.