Personalized checkout and custom promotions with Shopify Scripts
Hi,
I have a javascript code that retrieves order data to Google Sheets.
It works fine except that the "properties" output comes in one cell like this:
{name=Date, value=7 February 2023}
How to get the value of "properties" without the name or the brackets?
I am not sure about the script, so I am open to any recommendations.
Thanks.
script:
const data = orders.reduce((acc, order) => {
const lineItems = order["line_items"].map(item => {
return [
item["id"],
item["title"],
item["quantity"],
item["price"],
item["properties"], ## This one
order["created_at"],
order["total_price"],
order["customer"],
];
});
return acc.concat(lineItems);
}, []);
Solved! Go to the solution
This is an accepted solution.
Thanks for your response, I've just figured it out.
For anyone looking for the same thing, here's what worked with me to retrieve the custom property value:
item["properties"] ? item["properties"].map(property => property.value).join(", ") : "",
I think, it is a javascript object and you have to manipulate it separately
This is an accepted solution.
Thanks for your response, I've just figured it out.
For anyone looking for the same thing, here's what worked with me to retrieve the custom property value:
item["properties"] ? item["properties"].map(property => property.value).join(", ") : "",
Learn how to build powerful custom workflows in Shopify Flow with expert guidance from ...
By Jacqui May 7, 2025Did You Know? May is named after Maia, the Roman goddess of growth and flourishing! ...
By JasonH May 2, 2025Discover opportunities to improve SEO with new guidance available from Shopify’s growth...
By Jacqui May 1, 2025