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[bot]]

PT-1897 Product(s) not syncing

[cole007]

Please disregard - update to latest plugin version has fixed.