# Woocommers items line to Google Sheets **URL:** \ **Category:** Questions\ **Created:** [September 4, 2022, 9:28am UTC](https://community.make.com/t/woocommers-items-line-to-google-sheets/4108 "2022-09-04T09:28:38Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![froun](https://avatars.discourse-cdn.com/v4/letter/f/9fc29f/32.png) [@froun](https://community.make.com/u/froun)\ **Post date:** [September 4, 2022, 9:28am UTC](https://community.make.com/t/woocommers-items-line-to-google-sheets/4108/1 "2022-09-04T09:28:38Z")
Hello everyone, I’m using Make (integromat) to transfer order data from Woocommerce to Google Sheets. I’m struggling with orders that have more than one item. When I import it to Google Shets I can see only one of the items. I would like to add all items in separate rows. Can you assist me, please? Thanks in advance! ---
**Author:** ![make\_expert](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_expert/32/3827_2.png) [@make\_expert](https://community.make.com/u/make_expert)\ **Post date:** [September 5, 2022, 6:34am UTC](https://community.make.com/t/woocommers-items-line-to-google-sheets/4108/2 "2022-09-05T06:34:35Z")
Hi @froun Before the Google sheet step add an Iterator module and within the iterator map the `products[]` variable from woocommerce. ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/a/a87503c23171fa45bf98e683226499e7fe1c975a.png) ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/9/9f90385bab872812986528c021e226e537688d1a.png) Then it will iterate each products within an order into separate rows. The next step is to map the values from the iterator to Google sheet. [![](https://europe1.discourse-cdn.com/flex013/uploads/make/original/1X/b494dd4b09784955e7aa56413c3a90a9d70f5ac2.png)](https://www.upwork.com/freelancers/~01342b8f8487f506be) ---
**Author:** ![froun](https://avatars.discourse-cdn.com/v4/letter/f/9fc29f/32.png) [@froun](https://community.make.com/u/froun)\ **Post date:** [September 5, 2022, 5:10pm UTC](https://community.make.com/t/woocommers-items-line-to-google-sheets/4108/3 "2022-09-05T17:10:28Z")
> [@make\_expert](#): > > `products[]` Thank you for your reply! I have the following situation. In the data from woocommerce I’m able to see all products ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/c/c605797c0efeb3c5685964a32f8510b519515dc8.png) But then in the iterator I can see only one of them. I’m doing something wrong or I don’t get the point? ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/9/9e98293b7e279fa3d9b8991da1a8a5a421e08a45.png) ---
**Author:** ![froun](https://avatars.discourse-cdn.com/v4/letter/f/9fc29f/32.png) [@froun](https://community.make.com/u/froun)\ **Post date:** [September 6, 2022, 7:16am UTC](https://community.make.com/t/woocommers-items-line-to-google-sheets/4108/4 "2022-09-06T07:16:20Z")
![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/0/0f7464b2595a5747d7786a201ca8808b42eaeac7.png) Here its easier to see that only one of the collections/products is imported ---
**Author:** ![alex.newpath](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/alex.newpath/32/84_2.png) [@alex.newpath](https://community.make.com/u/alex.newpath)\ **Post date:** [September 6, 2022, 12:22pm UTC](https://community.make.com/t/woocommers-items-line-to-google-sheets/4108/5 "2022-09-06T12:22:37Z")
You’ll only see one item in the display to map items (star element). If you look at the output bundles of the woocommercbe download you’ll see all the other data. Your iterator should run through the `Lineitems[]` array and work through each collection in the array. ---
**Author:** ![froun](https://avatars.discourse-cdn.com/v4/letter/f/9fc29f/32.png) [@froun](https://community.make.com/u/froun)\ **Post date:** [September 6, 2022, 7:48pm UTC](https://community.make.com/t/woocommers-items-line-to-google-sheets/4108/6 "2022-09-06T19:48:20Z")
In the iterator comes only one of the products still ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/b/b7fed6665c6f264e36a043b2a4591d2b015c2290.png) ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/5/5e35d8e3df11b211e5ae8cfdc4c499c949be0d02.png) ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/9/948648a8d3d0458ad8c7c6003d25c9e247fcf57e.png) ---
**Author:** ![froun](https://avatars.discourse-cdn.com/v4/letter/f/9fc29f/32.png) [@froun](https://community.make.com/u/froun)\ **Post date:** [September 6, 2022, 7:49pm UTC](https://community.make.com/t/woocommers-items-line-to-google-sheets/4108/7 "2022-09-06T19:49:14Z")
![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/6/6541ea148e93aec20efc60253c68be85871656ad.png) ---
**Author:** ![froun](https://avatars.discourse-cdn.com/v4/letter/f/9fc29f/32.png) [@froun](https://community.make.com/u/froun)\ **Post date:** [September 6, 2022, 7:50pm UTC](https://community.make.com/t/woocommers-items-line-to-google-sheets/4108/8 "2022-09-06T19:50:48Z")
![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/d/d3c7933cb1bb5d7447995780479d1b1a32362e96.png) ---
**Author:** ![froun](https://avatars.discourse-cdn.com/v4/letter/f/9fc29f/32.png) [@froun](https://community.make.com/u/froun)\ **Post date:** [September 6, 2022, 7:52pm UTC](https://community.make.com/t/woocommers-items-line-to-google-sheets/4108/9 "2022-09-06T19:52:45Z")
[blueprint.json](https://community.make.com/uploads/short-url/z6JlCgmquWsv1ftJ4UgPisE5cz5.json) (24.5 KB) ---
**Author:** ![alex.newpath](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/alex.newpath/32/84_2.png) [@alex.newpath](https://community.make.com/u/alex.newpath)\ **Post date:** [September 6, 2022, 9:24pm UTC](https://community.make.com/t/woocommers-items-line-to-google-sheets/4108/10 "2022-09-06T21:24:50Z")
The input array only has one collection so the iterator won’t do more than one. Your order needs multiple items. ---
**Author:** ![froun](https://avatars.discourse-cdn.com/v4/letter/f/9fc29f/32.png) [@froun](https://community.make.com/u/froun)\ **Post date:** [September 7, 2022, 4:24am UTC](https://community.make.com/t/woocommers-items-line-to-google-sheets/4108/11 "2022-09-07T04:24:31Z")
It has 3 items. You can see them 2 screenshots above. Item lines 1 2 3 ---
**Author:** ![Vulture](https://avatars.discourse-cdn.com/v4/letter/v/7993a0/32.png) [@Vulture](https://community.make.com/u/Vulture)\ **Post date:** [September 9, 2022, 1:51pm UTC](https://community.make.com/t/woocommers-items-line-to-google-sheets/4108/12 "2022-09-09T13:51:24Z")
The Map function may help, but not sure. I had a similar issue and Make support was able to help me. Not sure if it’s the same problem, though. {{map(MAP\_TO\_LINE\_ITEMS\_ARRAY; “value”; “key”; “Name”)}} This says "Look into the **Line Items** array, pick the item whose _key_ is “Name”, and give me the _value_ . ---
**Author:** ![Michael\_Sharratt](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/michael_sharratt/32/2651_2.png) [@Michael\_Sharratt](https://community.make.com/u/Michael_Sharratt)\ **Post date:** [September 9, 2022, 2:31pm UTC](https://community.make.com/t/woocommers-items-line-to-google-sheets/4108/13 "2022-09-09T14:31:16Z")
How is your iterator mapped? If it’s consistently only doing one line then it means you only have one line item or you need to remove the 1 ---
**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\ **Post date:** [September 7, 2023, 2:43pm UTC](https://community.make.com/t/woocommers-items-line-to-google-sheets/4108/14 "2023-09-07T14:43:03Z")