The information in this thread might be outdated
If the solution did not help, please, check our Help Portal or contact Ecwid Team.
 
 
Thread Tools Display Modes
  #1  
Old 01-04-2016, 03:13 PM
Rick G's Avatar
Rick G is offline
Ecwid Team
 
Join Date: Jun 2014
Posts: 1,270
Post

Zapier integration: connect over 500 apps with your Ecwid store!




Hi everyone!

I am happy to let you know that you can connect your Ecwid store with Zapier service. Zapier is a place where you can connect two services in Zap: if something happens in one app, then something else happens in another or the same app.

For example, you can connect Mailchimp with Gmail, or Ecwid with your favorite accounting system available in Zapier!

Install Zapier app!

Here are some of the key features of this integration:
- Automate repetitive tasks, such as SMS notifications triggered by incoming orders or new customers
- Choose among thousands of online templates that have been created and shared by other Zapier users OR create your one
- Manage all your "Zaps" from one dashboard, connect all your accounts and switch Zaps on and off as you please

To find out more about Zapier and install it in your Ecwid store, please visit: https://help.ecwid.com/customer/port...2278042-zapier

Thank you.
__________________
Ecwid API and App Market Team
Ecwid Developer Website

Last edited by Vitaliy G; 04-01-2016 at 08:12 AM.
  #2  
Old 01-05-2016, 06:41 PM
Ken Williams1's Avatar
Ken Williams1 Ken Williams1 is offline
Junior Member
 
Join Date: Dec 2015
Posts: 3
Default Zapier not able to pull affiliate_id api

I have been in communication with Zapier support over an issue regarding the Zap "Save Ecwid orders to Google Sheets"

Zapier confirmed my tests that Ecwid is not sending the vitally important 'affiliate_id' in your API. We really need this feature so we would really appreciate this (seemingly easy) fix on Ecwid's part.

Here is Zapier's response:
I'm afraid that it doesn't look like Ecwid is sending us the affiliate ID on these new orders. Looking at their API it doesn't appear to be something they can return to us: http://developers.ecwid.com/api-docu...n#order-object

That means we wouldn't be able to help you capture that information. I'm really sorry about that.

--Thomas Hils
Customer Champion - Zapier
contact@zapier.com
  #3  
Old 01-06-2016, 01:34 PM
Rick G's Avatar
Rick G Rick G is offline
Ecwid Team
 
Join Date: Jun 2014
Posts: 1,270
Default

Quote:
Originally Posted by Ken Williams1 View Post
I have been in communication with Zapier support over an issue regarding the Zap "Save Ecwid orders to Google Sheets"

Zapier confirmed my tests that Ecwid is not sending the vitally important 'affiliate_id' in your API. We really need this feature so we would really appreciate this (seemingly easy) fix on Ecwid's part.

Here is Zapier's response:
I'm afraid that it doesn't look like Ecwid is sending us the affiliate ID on these new orders. Looking at their API it doesn't appear to be something they can return to us: http://developers.ecwid.com/api-docu...n#order-object

That means we wouldn't be able to help you capture that information. I'm really sorry about that.

--Thomas Hils
Customer Champion - Zapier
contact@zapier.com
Hi,

Thank you for contacting us.

Zapier application is created using Ecwid API: http://developers.ecwid.com/api-documentation
In a response from Zapier, there is a link to Ecwid API documentation, which leads to the Storefront Javascript API, which is not used in connection with Zapier.

As I can see, you are referencing a New Order trigger for Ecwid app on Zapier, where you need an Affiliate ID of an order to be passed to Google Sheets.

For this trigger, Ecwid uses this Orders endpoint, which provides all details about orders in Ecwid stores and affiliate ID field is included there: http://take.ms/ajYxK

When you create a new zap on Zapier for the New Order trigger from Ecwid, you can use Affiliate ID field as well, by searching for it when you click on 'Insert Ecwid fields' http://take.ms/4T9J4

So this affiliateId field is present in both Ecwid API and Ecwid app on Zapier, so please try to recreate the zap 'Ecwid orders to Google Sheets' and find the affiliateId field there.

Please let me know if you have any questions.
Thank you.
__________________
Ecwid API and App Market Team
Ecwid Developer Website
  #4  
Old 03-30-2016, 07:07 PM
Colostrum LD's Avatar
Colostrum LD Colostrum LD is offline
Junior Member
 
Join Date: Jan 2016
Posts: 5
Default

Can you please list the steps to get to this page where I can see what you are seeing:
https://monosnap.com/file/TCcHZUt27X...NTmdBFVIjeYXCS

To summarize, I am trying to get all Ecwid order to export to Zapier, then to Google Spreadsheet which shows the order details and affiliate id.

Many thanks

I struggled with this for another hour with no luck. I found places to add the affiliateid but nothing exports to Google Sheets without various errors.

I believe Ecwid needs to create a step-by-step tutorial (or video tutorial) for such a complex setup.

Can we pay you for this to expedite this? Or could we just pay you to set this up for us?

Thank you

Last edited by Clara K; 03-31-2016 at 01:07 PM.
  #5  
Old 03-31-2016, 01:25 PM
Clara K's Avatar
Clara K Clara K is offline
Ecwid Team
 
Join Date: Nov 2014
Posts: 655
Default

Quote:
Originally Posted by Colostrum LD View Post
Can you please list the steps to get to this page where I can see what you are seeing:
https://monosnap.com/file/TCcHZUt27X...NTmdBFVIjeYXCS

To summarize, I am trying to get all Ecwid order to export to Zapier, then to Google Spreadsheet which shows the order details and affiliate id.

Many thanks

I struggled with this for another hour with no luck. I found places to add the affiliateid but nothing exports to Google Sheets without various errors.

I believe Ecwid needs to create a step-by-step tutorial (or video tutorial) for such a complex setup.

Can we pay you for this to expedite this? Or could we just pay you to set this up for us?

Thank you
Hello,

Thanks a lot for contacting us!

We are very sorry you have had this difficulties in connecting your Ecwid to Zapier and to Google Sheets.

Please let me know what errors you get when trying to set this up?

We totally understand that there is a need for step-by-step instruction and are working on creating it. We are very sorry it is not ready yet.

Please note that to have AffiliateID field available for selection in your Zapier account you need to have a new order with AffiliateID.

Thank you!
__________________
Clara
Ecwid Customer Care Team

Help Center


⬇ Please click Thanks if my reply helped you.

Last edited by Clara K; 03-31-2016 at 01:28 PM.
  #6  
Old 03-31-2016, 07:05 PM
Colostrum LD's Avatar
Colostrum LD Colostrum LD is offline
Junior Member
 
Join Date: Jan 2016
Posts: 5
Default Zapier errors

Attached show every step of the 3 step Zap that I set up. The first two steps have a green check and are set up correctly, I believe.
(Dropbox view https://www.dropbox.com/sh/rmpl2tu8x...HcFwR1-La?dl=0)

The '3c' error comes in the third step when row 2 is empty. It has problems pushing the order data to the Google Sheet https://docs.google.com/spreadsheets...it?usp=sharing

When I added a sample row of data as suggested by Zapier, I got a different '3d' error.

Has anyone actually succeeded in doing what I am trying? Or is this still in beta?

Thank you
Attached Images
File Type: jpg 1a.jpg (69.1 KB, 204 views)
File Type: jpg 1b.jpg (61.9 KB, 202 views)
File Type: jpg 2a.jpg (63.8 KB, 206 views)
File Type: jpg 2b.jpg (185.9 KB, 210 views)
File Type: jpg 3a.jpg (94.6 KB, 201 views)
File Type: jpg 3b.jpg (109.4 KB, 209 views)
File Type: jpg 3c.jpg (105.4 KB, 205 views)
File Type: jpg 3d.jpg (67.2 KB, 184 views)

Last edited by Colostrum LD; 03-31-2016 at 07:12 PM.
  #7  
Old 04-01-2016, 10:51 AM
Clara K's Avatar
Clara K Clara K is offline
Ecwid Team
 
Join Date: Nov 2014
Posts: 655
Default

Hello,

Thanks a lot for your reply!

I see that you try to create a new order in Ecwid before adding the order to Zapier. Please see below the steps for creating the Zap:

Connecting Ecwid to Zapier
Code:
Make new Zap: http://take.ms/Uk2j1
Choose app: http://take.ms/U707r
Select “New Order”: http://take.ms/RBeGx 
Connect a new account: http://take.ms/d7GQH 
Login to your Ecwid account if prompted
Grant permissions: http://take.ms/Pmfiw 
Now your Ecwid account is connected: http://take.ms/Hm9U2 

Select orders statuses that will evoke creating a new zap: http://take.ms/Me1do 

Test the first part of your zap: http://take.ms/O0MES 
Test successful! http://take.ms/yj2df
Connecting Google Sheets to Zapier
Code:
Open a new tab and create a new spreadsheet (https://docs.google.com/spreadsheets/) for your orders from Ecwid, Zapier will add orders there as new lines.

Return to your Zapier tab. 

Select Google Sheets on the apps list: http://take.ms/RIVFw
Select “Create Spreadsheet row”: http://take.ms/Rjzi1
Connect a new account: http://take.ms/O8l3O
Grant permissions
Select the spreadsheet you have created and a worksheet where your orders will be added: http://take.ms/2hzVK 
http://take.ms/qp2a6 

Select the desired Ecwid fields: http://take.ms/dNCk7 
Click “Create and Contimue”: http://take.ms/RHyMY 
Test successful! http://take.ms/JBpwn 
Name your zap and turn it on: http://take.ms/rljpi 

Here is how the order automatically sent from Ecwid via our zap looks in Google Sheets: http://take.ms/ywnvt
__________________
Clara
Ecwid Customer Care Team

Help Center


⬇ Please click Thanks if my reply helped you.
  #8  
Old 04-01-2016, 08:36 PM
Colostrum LD's Avatar
Colostrum LD Colostrum LD is offline
Junior Member
 
Join Date: Jan 2016
Posts: 5
Default

Got it working!

How do we add more fields not mentioned by default, such as Customer Name. This step seems to limit the number of fields you can enter to 7 fields:
https://monosnap.com/image/vVDYOuKvG...7Dvcz57RaPZoZ8

https://docs.google.com/spreadsheets...4tg/edit#gid=0
  #9  
Old 04-08-2016, 03:01 PM
Clara K's Avatar
Clara K Clara K is offline
Ecwid Team
 
Join Date: Nov 2014
Posts: 655
Default

Quote:
Originally Posted by Colostrum LD View Post
Got it working!

How do we add more fields not mentioned by default, such as Customer Name. This step seems to limit the number of fields you can enter to 7 fields:
https://monosnap.com/image/vVDYOuKvG...7Dvcz57RaPZoZ8

https://docs.google.com/spreadsheets...4tg/edit#gid=0
Hello,

Thanks a lot for your question!

I am terribly sorry for the delay with the answer.

You can add many columns as you like - just add them in the Google sheet and re-connect the Google sheet to Zapier so that Zapier could 'see' these fields. I have added 9 columns, for example: https://monosnap.com/file/O3rv8w2yJG...F2cimxLmk7fHvr

Thank you!
__________________
Clara
Ecwid Customer Care Team

Help Center


⬇ Please click Thanks if my reply helped you.
 
The information in this thread might be outdated
If the solution did not help, please, check our Help Portal or contact Ecwid Team.

Tags
app, application, connection, ecwid, integration, zapier

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 12:10 PM.
Powered by vBulletin® Version 3.8.11. Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.