Calculating an average monthly payment and updating a metafield

Shopify Discussion
,
1

Hi,

I use Shopify as a car dealership website. To help users to shop for a car in their budget, I would like to add a “estimated monthly payment” on each listing. That way they can filter results based on this.

I think the best way to do it is with a metafield. A code should take the sale price of a vehicule, calculate the estimated monthly payment and populate the metafield with the value.

Though, I don’t know how to do it.

I’ve asked Mesa (the Shopify app) if they did something like this but it’s a custom dev that would cost $1,500 at least. I thought of adding a formula to my import .csv file but it’s not possible (the import and updates are done with Stock Sync).

Maybe there’s another automation app that could help me with this. I don’t know.

Do you have any suggestions?

Thanks for your help.

Simon.

2

Stock Sync allows syncing to metafields, if I’m not mistaken. So in your CSV, have a formula for the estimated monthly price (this is a temporary column). Add another column where you copy the auto-calculated estimated monthly price column and paste it as just values (not formula) into this new column. Now you can get rid of the formula column as it’s done its job. Because now you’re left with a column that has the correct estimated monthly price, Stock Sync should be able to sync?