Hi
We are looking for an experienced Google Script/Library Developer to create a multi-functional script for our Google spreadsheets that connects to our ecwid store and XERO accounting software.
Ideally we have one spreadsheet which includes both Ecwid and Xero. and One sheet for Ecwid and one sheet for Xero. (3 sheets in total). This being we can setup for any situation.
Ecwid sheet:
This spreadsheet has 3 sheets:
Sheet 1:
This sheet is for our products to be pushed into ecwid and update product prices and any other details that need to be changed if needed. Mainly will be prices. This sheet will need to have an option for a automatic trigger upload. This would use the products api.
Sheet 2:
This sheet is for downloading new orders when a purchased has been made in our store. Ideally if it was possible for it to be realtime and to know when a new order has been made it is downloaded into a new row in this sheet. Otherwise a trigger would need to be every X minutes checking for new orders. This would use the instant order notifcation and orders api.
[login to view URL]
[login to view URL]
Sheet 3:
This sheet is for updating order statuses for purchased orders so it can be updated with, payment, fullfillment statuses, and tracking numbers for shipping can be put in here. This will ideally need to be realtime so if changes are made they are automatically reflected into ecwid. Otherwise a trigger of somesort.
[login to view URL]
I have setup a Menu so you can see how we would like it setup for the library/script integration.
ECWID
- Ecwid Settings ( for Store ID, and API setup)
- Manual Upload Prices
- Manual Download Orders
- Manual Upload Statuses
- Automation Setup ( Setting up Automatic triggers for each sheet download / upload)
XERO spreadsheet:
Sheet 1:
This sheet will be used for our Xero Invoices Payables Upload / Download. Using the menu options we have the choice of making a manual upload or download, and setting up a automatic trigger. If the trigger of having both upload and download is going to interfere with each other then have them split to have a upload sheet and download sheet
Sheet 2:
This sheet will be used for our Xero Invoices Payables Upload / Download. Using the menu options we have the choice of making a manual upload or download, and setting up a automatic trigger. If the trigger of having both upload and download is going to interfere with each other then have them split to have a upload sheet and download sheet
Sheet 3:
This sheet will be used for our Xero Payments Payable Upload / Download. Using the menu options we have the choice of making a manual upload or download, and setting up a automatic trigger. If the trigger of having both upload and download is going to interfere with each other then have them split to have a upload sheet and download sheet.
Sheet 4:
This sheet will be used for our Xero Payments Receivable Upload / Download .Using the menu options we have the choice of making a manual upload or download, and setting up a automatic trigger. If the trigger of having both upload and download is going to interfere with each other then have them split to have a upload sheet and download sheet.
This Sheet also has menu functions which I have setup. One including Accounts which we can choose if the upload download is going to which account number.
Xero API
[login to view URL]
As for the Joined Ecwid / Xero sheet we can add the libraries so they use the sheets in the spreadsheet, but will need 2 functions for this sheet for the data to communicate with each other
- New Xero Invoice New orders from ecwid automatically populate data here for new invoice to be created in Xero
- New Xero Payment Data added here will be used for creating new Payments in Xero
Regards
Zane
hello sir,
We can provide u a good quality of service. u can check our reviews in freelancer and also u
can check out our company profile for understanding the quality of works that we can give u.
and we can give u individual person or team to work with u. there will be always a proper comunication
with u and ours through email or freelancer or skype. update will be always there in each day. and the
work or way u want to work with i think u can check ours reviews and got that we done this kind of quality
work for others. so we hope that we can give u a good quality service in near future.
thanks
WorkspaceIT Team