Trouble with product imports

[francoismajor]

Description

Hi, I have two websites that use this addon and I've been having a bunch of issues with imports. They worked fine for a couple of years but I've updated to the latest version (both Statamic and Shopify Addon) in March. It seems to work, but then products won't show up or will be out of stock. So I get emails from my clients every few weeks that something still doesn't work. Sometimes it's helped to import all or empty the cache, but I never had to do this before.

In the webhook docs there no longer is product/create listed, so I'm note sure if I need to remove it and product/update does both, or if it needs to be there, or if the order matters for the webhooks? I've tried removing it and adding it (which then placed it at the bottom) and I can't really tell if this has changed anything.

My issue right now is I've got 5 products in Shopify: they've been imported, but two of them don't have any Variant associated, so they show up as unavailable. I've tried importing them individually, and import all products too and that doesn't work. In Shopify there is no difference (that I can tell) between these products and they all have stock available and track inventory. In Statamic we can't associate variants and I can't tell either if they're there anyways since they're all named Default with a price and ID (I could try and figure out the ID and search to see if it's there but not associate or just not there. But I can't really do anything after that to associate them).

I know this is probably not enough information, but I'm not sure where to start at this point. Any help would be greatly appreciated.

Environment

Environment
Application Name: Sécheurs Cueilleurs
Laravel Version: 11.44.0
PHP Version: 8.4.7
Composer Version: 2.8.8
Environment: local
Debug Mode: ENABLED
URL: secheurs-cueilleurs.test/
Maintenance Mode: OFF
Timezone: America/Toronto
Locale: en

Cache
Config: NOT CACHED
Events: NOT CACHED
Routes: NOT CACHED
Views: CACHED

Drivers
Broadcasting: log
Cache: file
Database: mysql
Logs: stack / single
Mail: smtp
Queue: sync
Session: file

Statamic
Addons: 4
Sites: 2 (Français, English)
Stache Watcher: Enabled
Static Caching: Disabled
Version: 5.49.1 PRO

Statamic Addons
edalzell/forma: 3.1.1
jacksleight/statamic-bard-texstyle: 3.4.1
siterig/mailerlite: 2.0.0
statamic-rad-pack/shopify: 5.2.0

[ryanmitchell]

Sorry to hear that you are having problems - I wonder if some of the problem is that you dont have the correct permissions on your app in Shopify? They have been updated as the add-on has been extended so it's possible you are missing some now.

See: https://statamic-shopify-docs.vercel.app/setup

If not, the next version of the add-on changes the approach entirely for importing content - you can see that here: #290 . I hope to release it in the next 2 weeks or so.

[ryanmitchell]

I don’t know why no variant would be made either - for that to happen would mean there were no variants in the payload from shopify which shouldn’t happen.

The new PR will avoid relying on the webhook for anything other than the product ID, so it should at least rule out that as the cause of your issue.

the create webhook doesn’t seem to be needed as the update one gets fired at the same time. That’s been my experience anyway.

I’m happy to try to debug it with you sometime if we can sync up?

[francoismajor]

That or it gets created but not associated? 🤷‍♂️

Cool I’ll remove the product/create then.

I’ve got the inlaws here til tuesday but will try to debug in depth wednesday. (Or at least figure a way to reproduce the issue or narrow down the problem.) I’ll let you know and we can find a time if I can’t make any progress. Really appreciate the offer.

[ryanmitchell]

I would suggest waiting until #290 merges, as its a pretty large refactor of this area of the system.

[francoismajor]

Dammit, I found what the variant problem was 🤦‍♂️ No wonder only certain products worked. I started looking at the content files. The client keeps putting emoji symbols in her product titles, which are included in the product-slug ID for the variant, but stripped from the file name. So it doesn't find it.

Changing the URL in Shopify fixed the problem.

Not sure if this can be an issue for other people, if so we'd have to sanitize the product_slug to match the product file name. I'm surprised Shopify even allows or creates urls like those.

For the import, the last three products created where not imported, but I had added the product/create webhook, and I think that not longer exists in Statamic but uses product/update for both. I've removed it and should fix that problem since my other client was running fine without it.

I will definitely be upgrading to the new version as soon as it's merged. Thanks again for the help.

[ryanmitchell]

Ah well found, I wouldn't have thought of that!