Hi, you can try third party connector app, datech shopsync,  just link your shopify and tiktok shop and you can batch sync products with one click. Doesn't need to be such a hassle.

Try to install a 3rd-party connector app like Datech ShopSync. It helps you synchronize product, inventory and order information. You can also set inventory rules and price rules.

You have provided very good solutions, but for their problems, you can try Datech ShopSync. it has an excellent feature of product category synchronization, which maps shopify categories with TikTok's without the need to fine-tune the product content...

The 3rd party connector apps such as datech shopsync can help with this. They have features like price setting and order sync.