Zapier Integration Set Up
- or -
Post a project like this1788
$$
- 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
London
Top rated PHP Web Development | WordPress | Magento | Drupal | OpenCart | PrestaShop | Joomla
Leicester
1254564140639630836105075413370022507173
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.
100% (14)Projects Completed
14
Freelancers worked with
13
Projects awarded
34%
Last project
8 Mar 2021
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