![phoenix](https://d1a29h5kxv3oc2.cloudfront.net/dist/img/phoenix.81914efc7207f6a059bd10f5d3fd5f89.png)
Zapier Integration Set Up
- or -
Post a project like this1881
$$
- Posted:
- Proposals: 6
- Remote
- #2388288
- Awarded
PPH's Top Web Designer, Developer with Great reviews & communication specialized in WordPress | Shopify | Graphics designer - Label/Packaging/UI/UX | Web app/Software developer | mobile app developer
![Top Seller with earnings over £100k Top Seller with earnings over £100k](https://dw3i9sxi97owk.cloudfront.net/uploads/prizes/badges/6848fd9e0514ae9277cce59806b79dc5.png)
![Top Endorsed Top Endorsed](https://dw3i9sxi97owk.cloudfront.net/uploads/prizes/badges/ffdd1b856a16c89191f1150e4430076b.png)
Top rated PHP Web Development | WordPress | Magento | Drupal | OpenCart | PrestaShop | Joomla
![Top Endorsed Top Endorsed](https://dw3i9sxi97owk.cloudfront.net/uploads/prizes/badges/ffdd1b856a16c89191f1150e4430076b.png)
1254564140639630836250717310507541337002
![Matt S.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/5996f40b908c7d63cf434beb6c0adc71_70x70.png)
![Manish K.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/0aadfe47363bddab237c2060167372e3_70x70.jpg)
![Sivasankari V.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/88120850d3a23d554ee3f10508407eb8_70x70.png)
![Joe I.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/c29ea5064c2b5f6fd77c6274123a8dfe_70x70.jpg)
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?
![Ishak V.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/ecdf49608210604c89b4106dbc2ea7cd_150x150.jpg)
Ishak V.
100% (14)Projects Completed
15
Freelancers worked with
14
Projects awarded
33%
Last project
27 Jun 2024
United Kingdom
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.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies