Google Sheet module to PrestaShop module Automation on Make.com
Budget: €8 – €30 EUR
I need assistance with my Make.com workflow that channels data from Google Sheets into PrestaShop.
Data from Google sheet module (in make.com) to Prestashop module (in make.com)
In outing of the Google sheet module in Make.com we have this data :
Bundle 1 (Collection)
Id order (A) : 11313741201740
SKU (shopify) (B) : PRO-TOP-1620,PRO-TOP-1419
Product ID (C) : 21,21
Product Attribute ID (D) : 40,42
Quantity (E) : 2
So I have 2 products in this order :
Produit 1 : Id_Product : 21, Id Attribut : 40
Produit 2 : Id_Product : 21, Id Attribut : 42
My question : In order to add those products in the Prestashop Module (on make), how to split the data in order to get this result :
Bundle 1 (Collection)
Quantity : 1
Product ID : 21
Product Attribute ID :40
Bundle 2 (Collection)
Quantity : 1
Product ID : 21
Product Attribute ID : 42
Here's the scenario:
- I receive data from a Google Sheet that includes order details and product information.
- I need to split this data into individual product entries before sending it to PrestaShop.
For example, if I have an order containing two products, I need to format it into two separate entries, each with a quantity of 1.
Your tasks will include:
- Splitting the data so each product is sent as a separate entry.
- Sending these entries to PrestaShop in a way that creates a cart for the order.
Additional requirements:
- You won't need to map any extra fields from the Google Sheet, the current fields are sufficient.
- The automation should allow for both sending to a new cart or an existing cart in PrestaShop.
Ideal Skills:
- Proficiency in Make.com
- Experience with PrestaShop
- Familiarity with Google Sheets
- Data manipulation skills
This project will require you to create a flexible automation system that can handle different scenarios depending on the order data. Please ensure you have the necessary expertise before bidding.
Data from Google sheet module (in make.com) to Prestashop module (in make.com)
In outing of the Google sheet module in Make.com we have this data :
Bundle 1 (Collection)
Id order (A) : 11313741201740
SKU (shopify) (B) : PRO-TOP-1620,PRO-TOP-1419
Product ID (C) : 21,21
Product Attribute ID (D) : 40,42
Quantity (E) : 2
So I have 2 products in this order :
Produit 1 : Id_Product : 21, Id Attribut : 40
Produit 2 : Id_Product : 21, Id Attribut : 42
My question : In order to add those products in the Prestashop Module (on make), how to split the data in order to get this result :
Bundle 1 (Collection)
Quantity : 1
Product ID : 21
Product Attribute ID :40
Bundle 2 (Collection)
Quantity : 1
Product ID : 21
Product Attribute ID : 42
Here's the scenario:
- I receive data from a Google Sheet that includes order details and product information.
- I need to split this data into individual product entries before sending it to PrestaShop.
For example, if I have an order containing two products, I need to format it into two separate entries, each with a quantity of 1.
Your tasks will include:
- Splitting the data so each product is sent as a separate entry.
- Sending these entries to PrestaShop in a way that creates a cart for the order.
Additional requirements:
- You won't need to map any extra fields from the Google Sheet, the current fields are sufficient.
- The automation should allow for both sending to a new cart or an existing cart in PrestaShop.
Ideal Skills:
- Proficiency in Make.com
- Experience with PrestaShop
- Familiarity with Google Sheets
- Data manipulation skills
This project will require you to create a flexible automation system that can handle different scenarios depending on the order data. Please ensure you have the necessary expertise before bidding.