Why is my CSV import code turning red during WordPress to Shopify migration?

Technical Q&A

Topic summary

WordPress-to-Shopify migration issue: importing the exported product CSV highlights roughly half the content in red. The source store relies on custom code that recalculates product prices daily based on the current gold rate, and accurately preserving this dynamic pricing is critical.

  • Request: assistance reviewing the import errors; priority is maintaining the gold-based price calculations in Shopify.
  • Response: a participant asks for screenshots of the error highlights to diagnose the CSV issues. They note product migration is straightforward, but daily price updates will require either a custom app or a Shopify Plus solution.
  • Status: no confirmed fix yet. Next steps include providing error screenshots and assessing whether to implement a custom app or use Shopify Plus to handle automated, daily price changes.
  • Open questions: exact cause of the red CSV entries and the final approach for replicating dynamic pricing in Shopify.
Summarized with AI on January 4. AI used: gpt-5.
1

Hello Community,

My client needs to move his store data from WordPress to Shopify. I’ve exported the product information as a CSV file from WordPress. However, when I try to import this data into Shopify, about half of the code turns red.

Here’s some context: The WordPress site has a special code created by a developer to calculate product prices based on the daily price of gold. Since gold prices fluctuate, the client’s website adjusts product prices accordingly. This calculation is crucial for the client’s business.

If anyone can assist or take a look at this issue, please reach out. Transferring this pricing data accurately is the top priority. Thank you!

2

Hello @JesikaK

Did you find a solution to the above, I am happy to help you.

Can you share a screenshot of the errors that show, that will help me in finding a solution.

Migrating your product to Shopify is quite easy, my concern is to change the product price daily you will need to build an app or Subscribe to Shopify plus.

You can chat with me here > Chat Link I will try my best to help you.

Thanks