I am trying to export new orders from Etsy to Shopify as they come. The scenario I have used to work fine, and it was somehow broken few months ago.
I have a list of products in a google sheet and their corresponding prices under “Price” column. There is a step to create array from products and the array should contain “Price” column value for the products, eventually I map the array to the line items in the shopify API call.
The problem is that when making the shopify order create call, I get the following error: “line_items: line item price not found, price must provided”
I believe this is because the array I provided as a map to line items has the price column as “Price (C)” from google sheet. I am not certain if that’s the reason. See the screenshots for reference.
Is there a way to delete that column letter from the column name when importing from Google Sheet or creating the array?
