Shopify Product Slugs Not Updating / Re-Syncing

[sm9]

Description

Before installing the Shopify plugin, I had a section named 'Shop Entries', and these contained all my products. When updating the settings for the Shopify products for the first time, I gave them the same Product URI Format as the Shop Entries section. When I synced my products from Shopify, all the Shopify products in my Craft install have a "-2" at the end of the slug, e.g. /shop/product-name-2.

I have tried changing the Shop Entries URI format to something different to remove the clashing slugs, but that didn't change anything with the Products. I tried clicking the Shopify Sync button in case that updated the product slugs, but that didn't change anything either. Is there a way to update these Shopify product slugs at all? Thanks.

Additional info

• Craft version: 4.5.9
• PHP version: 8.0
• Database driver & version: MySQL 8
• Plugins & versions: Shopify 4.0.0

[sm9]

Just a quick follow-up on this - I noticed that the slug for each product is stored within the slug row of the craft_elements_sites table, so I tried changing the slug for one product in here, and it seemed to work okay, so I don't mind fixing this duplicate slug issue by doing the same for the rest of the products. But are there any consequences to doing this that I should be aware of? Thanks.

[lukeholder]

You can fix it in that table as long is it is unique.

I'll look into allowing edits on the front end.

[sm9]

Thanks Luke, I'll fix this in that table for now then. There's only 9 products and I'll make sure the slug is unique. It'd be great if a native way of editing this is added in the future of course, so thanks for looking into this.

[siebird]

We're running into a similar issue. We have two entries for the same Shopify product in Craft, thus giving us -2 with slugs. Not able to delete one either.

[lukeholder]

You are getting duplicate Shopify product elements? Re-sycning all from the command line doesn't fix it?

@siebird Can you send your DB dump, composer.json, composer.lock to support@craftcms.com so we can look into this one?

Thanks.

[dyerc]

I just encountered this issue or a very similar one. I updated the slug/url handle for a product in Shopify and despite performing a full resync, Craft still displays the product on its original URL. In the admin area, the updated slug is displayed but not used by Craft to display the page

[lukeholder]

@dyerc can you check your element_sites table for the shopify product element and see if the uri column has the correct value for the new slug after syncing?

[nfourtythree]

Hi All

Closing this issue for now as it appears to have become stale.

If you are still having an issue or have any further information please reply here and we can look into it further.

Thanks!

[dyerc]

Hi @lukeholder @nfourtythree ,

I've just run into this issue on the same site as before. We're currently on Shopify plugin version 6.0.5

On the right hand side of a product in the Craft admin area, it's handle is being shown as the same as the URL handle within Shopify's admin area. However the product page itself and any "View" links to it within the Craft site all use a completely different slug. I imagine it must have been changed at some point in the products life.

Despite a full Shopify sync and manually saving the product in Shopify, the slug on the Craft site refuses to update.

In the elements_sites table, both the uri and slug columns contain the wrong value.

[nfourtythree]

Hi @dyerc

Apologies for the delayed response on this one, it appears it got buried somehow (will reopen this issue to prevent that happening again).

Can I ask how you have your "Product URI Format" setup for your Shopify products in Craft?

Thanks!

[linear]

PT-2981