Extract line items from an order in woocommerce

Help for extract line items from an order in woocommerce

Hello, I want to extract all the content of an order and put it in Notion, but I have a problem getting the name of the product and its variants such as the size for example.

This would be the text format that I would like to obtain, but I can’t do it, any idea how?

Product: Remera “Romance” Beige
Size: M
Quantity: 1

Product: Remera “Romance” Negra
Size: L
Quantity: 2

and so on.

Example of what I want in notion:

Welcome to the Make community!

Since Line Items is an array, you can put that in an Iterator module.

Then, you can use a Text Aggregator on the Iterator.

Select the Name & Quantity and MetaData.1.value.

If you need further assistance, please provide the following:

Please provide the input and output bundles of the modules by running the scenario (or get from the scenario History tab), then click the white speech bubble on the top-right of each module and select “Download input/output bundles”.
Screenshot_2023-10-06_141025

A.

Save each bundle contents in your text editor as a bundle.txt file, and upload it here into this discussion thread.

Uploading them here will look like this:

module-1-input-bundle.txt (12.3 KB)
module-1-output-bundle.txt (12.3 KB)

B.

If you are unable to upload files on this forum, alternatively you can paste the formatted bundles in this manner:

  • Either add three backticks ``` before and after the code, like this:

    ```
    input/output bundle content goes here
    ```

  • Or use the format code button in the editor:
    Screenshot_2023-10-02_191027

Providing the input/output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.

This will allow others to better assist you. Thanks!

samliewrequest private consultation

Join the Make unofficial Discord server!

1 Like