Google / Ecwid / Xero Chrome APP

  • Status Closed
  • Budget $30 - $250 USD
  • Total Bids 7

Project Description

We are looking for a multi-functional APP for our Google spreadsheets that connects to our ecwid store and XERO accounting software.

The spreadsheet is broken up into 4 sheets.

The first 3 sheets are for ecwid purposes.

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 be on a trigger. This would use the products api.

[url removed, login to view]

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]

Sheet 4:

This final sheet in the spreadsheet is for the XERO Invoices. From sheet 2 (orders), the app will need to connect to our Xero accounting account and create a new invoice for the purchases made. If possible this would need to be a two way setup as we will need record of our invoices for our CRM.

[url removed, login to view]

For the APP itself, it will need to be easy to use, with a nice userinterface that is simple to setup (e.g fields for apis, sheet key then let the program start.

If there is anything other information you would like about the job, send us a message.

Get free quotes for a project like this

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online