Google sheets - How to add two rows for two different items on the same order?

:bullseye: What is your goal?

To have a seperate row for each item on a single order.

:thinking: What is the problem & what have you tried?

I integrated WooCommerce with Google Sheets to automatically log my orders instead of entering them manually.

It works fine for single-product orders. But when a customer buys multiple products in one order, only the first product shows up in the sheet.

In the screenshot, row 138 shows only one item under “Item description,” even though two products were purchased.

In row 139, I tried adding multiple “Line items” fields to capture additional products, but it just keeps repeating the first product (“Daphnie Belle Dress”) instead of pulling the others.

Ideally, each product in an order would be added as a separate row. If that’s not possible, I at least want all products from the order to appear within a single cell.

How can I fix this?

:camera_with_flash: Screenshots (scenario flow, module settings, errors)

6 posts were merged into an existing topic: Google sheets/woocommerce: How do I correctly map Variation1 and Variation2 from line item meta?