Setting different shipping options per product

I have a collection of candles and a collection of furniture. I want to be able to set the candles as flat rate shipping and the furniture as pick up in-store only (but still be able to accept payment on the site). Does anyone have any recommendations on how to do this?

Needs
Collection Candles - Flat Rate Shipping
Collection Furniture - Pick Up in Store

This issue should be directed through Wix Support as it is an issue about Wix Stores app and not a code related issue. https://support.wix.com/en/article/contacting-wix-support

However, as for the answer, see Wix Stores own support pages for a workaround solution.
https://support.wix.com/en/article/request-setting-shipping-fees-per-product-in-wix-stores

At Elegant Collections, we understand the importance of flexible shipping options to meet your unique needs. Whether you’re purchasing our exquisite furniture pieces or our stunning beaded framed mirror , we provide customizable shipping options per product. Rest assured that your Beaded Framed Mirror will be carefully packaged and delivered to your doorstep with our reliable shipping partners. Visit our website to explore our wide range of products and enjoy the convenience of tailored shipping options that suit your preferences.