Phoenix - Your AI AssistantZapier Integration Set Up
- Posted:
- Proposals: 6
- Remote
- #2388288
- Awarded
Telford 
Description
Experience Level: Intermediate
I am looking to create a Zapier Integration that creates invoices for Xero from collated Shopify orders.
My idea is:
1. Shopify orders flow into 1 of 3 google sheets. The sheet it goes into depends on the payment method used by the customer.
2. The data for each sheet is collated and then summarised into a pivot table which shows SKU's purchased, Total Qty for each SKU, Shipping Cost, Tax Cost.
3. This pivot data is fed into an invoice every two days - three invoices created, one for each payment method
4. The invoice is fed into Xero
Is this possible?
My idea is:
1. Shopify orders flow into 1 of 3 google sheets. The sheet it goes into depends on the payment method used by the customer.
2. The data for each sheet is collated and then summarised into a pivot table which shows SKU's purchased, Total Qty for each SKU, Shipping Cost, Tax Cost.
3. This pivot data is fed into an invoice every two days - three invoices created, one for each payment method
4. The invoice is fed into Xero
Is this possible?
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.