Sedang Disiapkan

Google / Ecwid / Xero Google library/script

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.

[url removed, login to view]

[url removed, login to view]

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.

[url removed, login to view]

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

[url removed, login to view]

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

Kemahiran: AJAX, Javascript

Lihat lagi: w split, using google spreadsheet, using functions in google spreadsheet, use script in google spreadsheet, spreadsheet script google, spreadsheet javascript, spreadsheet in javascript, spreadsheet google functions, spreadsheet functions google, spreadsheet api javascript, software developer overview, script sheets, script google spreadsheet, receivable and payable in accounting, how to use google spreadsheet functions, how to know accounting, how to create accounting, google spreadsheet script api, google spreadsheet api javascript, google developer javascript

Tentang Majikan:
( 1 ulasan ) Tauranga, New Zealand

ID Projek: #4824039

4 pekerja bebas membida secara purata $515 untuk pekerjaan ini

workspaceit

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 Lagi

$515 NZD dalam 3 hari
(16 Ulasan)
5.9
srinichal

Looking forward to discuss more details

$631 NZD dalam 8 hari
(31 Ulasan)
5.7
FASTGuru

Please provide details.

$526 NZD dalam 3 hari
(5 Ulasan)
3.2
KPInfoTech13

display:none Hi ready to start Thanks

$388 NZD dalam 7 hari
(0 Ulasan)
0.0