Send order Sheet to Prestashop

How To
1

I want to send orders from Google Sheets to Prestashop.

Here are my modules:

  • Google Sheet
  • Create customer
  • Create address
  • Create cart
  • Create order

In the “Create order” module, I need to provide:

  • Product ID
  • Attribute ID (variant)
  • Quantity

In my Google Sheet, I have columns for Product ID, Attribute ID, and Quantity.
For a single product, the order works perfectly.

BUT, if I have multiple products, my IDs and quantities are separated by commas, and it no longer works.

How can I make the “Create cart” module correctly handle multiple products?

Thanks in advance for your help!

image
image1034×332 19 KB

2

Hello. Did you find a solution to your issue ? I am interested.
Best regards.

3

Hi @Sebastien_COLOMBIER, @DREATEAM, After google sheet module you’ll need ‘Iterator’ module with input : split(productid;,). This will effectively split results by comma if there’s a comma, or gets you the only result it found - and then iterates for each product ID.