SyncSpider Webinar & Transcription
What’s going on, Sumolings, thank you so much for joining us for another product walk through webinar. I am Lindsay and today I am joined by the team over at SyncSpider. This is an app to app connection tool that helps ecommerce businesses automate sales, marketing and fulfillment. It is on apps right now starting at one twenty nine for a lifetime deal and it currently has a five Taco rating. And before we dive into the tool, though, I just want to tell you a few quick things.
The first is that if you want to tell us a little bit about your use case, why you’re interested in this tool, you can go ahead and do that.
If you have any questions about the tool, the deal, how to get set up, go ahead and leave those questions in the Q&A box down below this video. We do have Alexander here to answer the questions as they come in. And then we will also be circling to the more popular questions at the end of the walk through. And then so for those of you watching the replay, there is a replay of this available. You can always check it out there.
All right. That is enough of me. Hey, Norbert, how are you doing today?
[00:01:04.500] – Norbert (SyncSpider)
Hey, thanks a lot for having me. I’m really proud to be here and present the tool. So thank you very much. Feeling very good. We’re glad to have you also.
Hello, T.J., in Melbourne, Australia. I love it when you say hi to me. See, you’re more than welcome to do that. All right. I’m going to go ahead and pass this over to you. I’m going to turn off my camera and my mic, but let me know when you’re ready to take questions. Absolutely.
OK, great. Let’s get the party started. Ladies and gentlemen, today we are talking about six by. But first of all, I’d like to introduce myself quickly. My name is Norbert I. I’m originally a founder of a digital agency with the focus on e-commerce. And yeah, we built over 150 e-commerce projects so far in the company. And based on all those requests that we got from clients like can we synchronize the story to this or that list on Amazon list on eBay connected to the local ERP software, to a product import, to an order export.
So a lot of common things that e-commerce is needed. We decided to build a tool for it because everyone here knows Sapir, of course, a very great tool app to app connector. And the idea is it’s quite similar. It’s six bodies like Saphir for ecommerce.
Um, and, um, and this is why we built it, because we wanted to have a way for for Web store owners. And of course, also app to app is possible here, but especially on the originally for Web site owners to easily allow them connecter e-commerce outlet with nearly everything, um, out canvasing Spiner. And and finally, we we also discovered a way that it also will be good to include all the specifications out there. And this is where we currently are today.
With me is Alex, who is our CEO, and yeah, he is the lady for everything at six Spide managing especially the customer success and and helping the support team to give you the right answers and leading the team in that direction that everything runs smoothly for you. And we are working strong together since, I think.
Three for four years now, Alex, yeah, that would be three years. Great to be here. Thank you, Norbert. Such a great introduction.
Oh, yeah. No, it wouldn’t go without you. So everything is really great. We work good together. You will see the rest of the team later on. And I want to start with the very impressive number, namely five trillion, five trillion US dollars is the prospected e-commerce sales this year. So in twenty twenty one, we’re expecting five trillion in sales online, in e-commerce store. And one thing you need to know for that is that only twenty six percent of all retailers are currently online.
So there is a lot more that could go online and sell online. And seven out of 10 of those 26 percent are currently looking to automate their e-commerce business. Well, this shows us that if you don’t sell online, your business goes offline. So every retailers really should focus on being online. Finally, it’s a very low number, 26 percent only online. And when we see the massive growth of e-commerce, they meet five trillion prospected annual revenue global by 2021, 18 percent growth between twenty eighteen and twenty nineteen and twenty two percent projected percent of growth in 2023.
So we really will grow. And there’s another number that is important. 95 percent of all purchases will happen at some point, digital or online, in 2040. This is also a number that is very impressive. And to give you an example, we prepared the use case of Anna. As an example, what it can do, so let’s talk about her, Anna has a view commerce store and the local people as softer and she wants to sell on Amazon.
What happens if the product gets out of stock but the same product gets sold on Amazon? Well, she cannot deliver in time anymore. And she has finally a bad review. So how does she get the Amazon order to her fulfillment copy paste? Really? Well, with things that could be so easy since Spider picks the new order and sends it to the shipping center or updates the stock when it happens and updates the stock and Pewsey shares, it doesn’t need to take care about the management of the entire stuff, do it manually doing copy pasting or implement any kind of plug ins because you can attach any kind of tool that she’s using while Spyder to automate the entire process so easy.
Yeah, it is. It’s definitely better than copy pasting the stuff all over. And you need to know that there are over 15 million of e-commerce stores outside and the store owners, they need to deal with the products, the photos, the suppliers, importing exporting tools, fullfillment. So there are a lot of combinations, millions of possible combinations. What they could connect with each other, not only the channels, but also the SAS applications that I’d use like newsletter provider CRM software, um, lead generation software marketing software, TASC systems, um, so everything that has a relevance to an e-commerce business.
And then we are talking about billions of possible combinations. And this is why I think Spider comes in to connect all those tools together and allow you to integrate and automate. So we think spider store owners, marketers, ERP providers, agencies can integrate and automate all the channels, all the different tools and a lot of SaaS applications with one simple interface. At the moment, we have around about 150 plus integrations. So since yesterday there are 160 or so.
And of course we add integrations every week. Um. We have been a bit slow in that and you maybe have read it that that there, but that seems to integrate slowly. But this is a very important reason. We developed over a six month new method to integrate tools much, much faster. So the entire team really spent their whole power to integrate that engine that we call the external API templates. And those external API templates allow us to use the rest API documentation of a tool to implement it, wire copy paste the payload examples so we really can integrate much, much faster.
Now we are talking about round about three new integrations per week that we can deliver and the team definitely aims for it without extending the team now.
So just talking with the core team and we are even aiming to bring it faster to add one integration a day. It can be basic integrations or full deep integrations. When we’re talking about where Pook integration is, for instance, we can really do that already to add one day.
Um, and and this is something that we will really focus on. This is the goal to really bring you a lot of integrations in a short period of time and improve that. The tool that the debt that we develop, the external API templates every other day so that we can be even faster and we even can allow you to use that engine to integrate your tools that are not yet on our list. Um, twenty, 20, 20, 40.
As I told you, 95 percent of all sales will happen in a kind of digital way. It can be an online store, it can be a smartphone, it can be a display at the local post.
But we will not go shopping as we did so far. We will still go into our shopping malls and we will still go into the small stores. But at some point it did. A digital process is in place and we at Sing Spot are going to be part of that. And he you see the current team and you see and this is what I am personally very proud of it. We have no barrier in the countries that we work with because the most of the team works remotely.
So we of course, we have small offices where the people can sit together, but most of the team is working from home. And this even before Korona, we had we have everyone remotely or most of the team remotely. And it’s it’s really a pleasure. The meetings, we we we all speak different native languages, um, and we communicate, of course, everything in English, and it’s much fun with everyone and, um, and with the entire meetings.
But you can see here the stuff that we have and we are so proud now to be on sumo. Um, the reason why we went for sumo mainly is to grow the user base, because what we want to do is we want to learn from you what you really need. So we would like to work closely with you if you purchase a coupon and opt in for us closely with you, see your requests, improve the tool and do the integrations and automations for you so that you have, um, a great tool that you can work with and from there on grow together with Sync Spide.
And our claim is better, faster, stronger e-commerce. And now it’s enough for the presentation. Let’s hop into the tool and give you a quick demo on what I can do with saying Spider. So let me switch to my browser.
First of all, this is these are. The back end of Sing Spider. And today we want to do a product import from a Google sheet to WordPress Combustor, um, and then we will see what the day brings.
So, um. First of all, I’m here in the back end and let’s assume that I have an agency account, what is an account good for?
This is the possibility to add some accounts, some companies to your account. It’s already doable with with the problem for consumer here, too, that we had additional company accounts. It just gives you a bit more on on features that because you can access the custom integrations. But the subaccount features were important because when you have a new client, you simply added to the system. And this can be done by sorry, because I have a very huge client base here that I support.
And you can add a new company just by clicking the button here and then you’re redirected to the company set up and all you need to do is provide the company name Sumell. Sumo webinar, so this will be the new company and that stage, you can also upload an image for the company and you can invite people, additional people from from the company. But just providing the email address and you can define if you as an agency, going to pay for it.
So we will detect the volume that goes over that specific account from your limits that you have, or you can decide to let the company pay for that since bodycount. In that case, we would open up a regular trial, a trial account for Spide for the company and send a regular NYR. And of course, there’s commission for it.
If they pay, you will earn a commission every time they pay. So this is more or less like a bit of an affiliate program or an agency program.
We have a lot of agencies and as customers that they do not want to pay for their customers. This is why we implemented that. So this can easily let the customer pay, starting with a trial, setting everything up for them via this interface. So I just want to add this new company, which is already done. And now I got to switch to the Sumell webinar customer. So when I switch here, I going to be back in that specific account.
And I go back to the dashboard and you see, I’m here already locked in, and we have created one project already for this customer based on the name of the customer. What is the project? So actually, a project is more or less a folder where you can structure all the tasks for that specific client. So let’s say you want to have a project for the product import export, a project for the marketing to do all the lead generation transfers from your, let’s say, Facebook ads to newsletter software from the shop to the CRM.
And you can structure it a bit so that you can easily find what you are looking for with customers that created projects with the name of the marketplaces they are listing or with the tools they’re using and all the tasks are set up within those projects. So this projects are related to the customer. If you have another customer, the projects will be completely different. Now there are two ways to integrate a specific tool. The first option that you have is you go here to integrations and you see all the integrations that we currently have on file.
You can just type to search them. Um, we just lower the results, the search results.
And if it’s there, you click on it and you do the integration process.
If you don’t want to do that right away here from the integration screen, which is possible, you can do it when you create your first task. So you can do it also on the fly. And this is the way that I prefer to do it because I don’t need to go extra to the integration screen started off there.
So what I’m going to do here is I want to create a new task here. Here from here it starts, this process is always the same. So it doesn’t matter if I show, you know, how to get products from a Googoosh to a welcome store or a Facebook lead to up, it’s always the same process. If you know that process, you can set up every task. So the first step is to pick the source integration. I have no integration on file.
This is why I have no listing here. If it would have an integration on file, we would state your existing integrations and you could pick from the existing integrations. But we have none. So I want to switch to first integration that I need. And this is Google Sheets. I would just click here and provide a name, so I will just name it somehow.
Sheets, if you don’t know how to set it up and what’s next, you just click here on C instructions and, um, uh, redirect you to our knowledge base where we have described the way how to implement that integration in a written way.
We are working on video tutorials as well. So that makes it more easy for you. This is what we have a bit of space here. We want to introduce the widget to draw us directly in line. This will come up as we produce it in the future so that the integrations and then just click on next and then you can add a new Google account. Just click that and you can pop up. You will verify that my account seems already to be integrated.
I’m not sure if it’s the right one. Could be that I need to newly integrated. I said there’s a fresh account, but everything looks good. So I have now integrated already with Google Sheets and here we have the entities. So if there are different entities, you will see in the next step what that is exactly. You could choose from Google. She’s just had the entity spreadsheet because it’s the only way and the only thing that we can get from Google Sheets.
So let me go next to the next step. And here we picked a target integration. So first we have told Sync Spot where we want to get the data from, and now we tell Spada to where we want to send the data to. And this is our view, commerce in this case, so will commerce. Searching for it and just clicking the button again here. You can go to the instructions and here we will add the apps store and click the next button.
Now, since I want to ask a few things, first of all, we need to provide the story all consumer and consumer security. We will create that in a minute.
A. But we also provide you a plug in to download, actually, for a basic integration with newcomer’s, you don’t need that plug in, but with this plug in, you are extending the functionality of e-commerce. So we allow you also to fill up Meeta Fields. So if you have any kind of specific meeta fields that you want to use, you can use that plug in. It’s the same plug in as we have for WordPress.
If you want to send data to WordPress like users, posts, custom post types, it’s the same plugin and it just gives us the option to add me to fields and set specific kind of attributes that typically are not visible in newcomer’s by default. So and we have such plug ins for different kind of stores or different kind of tools and you can install them, but most time it’s not needed if you just want to do basic stuff. But the extended stuff there, you can install the plugin.
So now in that case, I want to come to my local store. I will go to the dashboard and the back end and newcomer’s, of course, there are things you need to know, but you have described then everything in the knowledgebase. You need to go to settings advanced and here we will set the rest API. We were just activated at a new key. This key is called Sync Spider App Sumo, just for reference, and he has to use it and we will grant and read and write access and generate the key.
Now I have consumer and secret and after Eurail, so I just copied Eurail without WP admins or just the URL. I will copy that. A girl here. I will copy that key here. I will copy the secret and then I click on Finish and of course it’s HTP. So we give you a warning you should HDB instead.
But this actual test project doesn’t have an SSL certificate, so we go with HDB and we just press here finish and now the integration is done and the store is connected. So and here it comes to what do we want to send. We call this dropdown here the entities. So what we can send to commerce is the products, the orders or the statuses. In our case, you want to send products. So we selected and we are ready to go with the next step if you want to send to multiple targets.
So if you don’t just have the e-commerce store, but maybe even Amazon or eBay or any other target or the CRM or a local POS or whatever you want or need, you can add an additional target here.
But just clicking this button and you will get a next select integration screen so you just can select another tool here and do the integration. Let me press next to get forward. We just want to send the products e-commerce and now since asks me to configure the source.
So every first step after you picked all the integrations you want to use for that, you have a source configuration for every source that you have. And in this case, you are just picking the sheet that we want to use, such as press here, the search bubble.
And now I know it’s in my drive. And we are pulling that in real time so it can take a bit and you have the important task that we want to use and here is the sheet that I created for the import. So let’s check the sheet first.
What I did here is I created just a small, small sheet where I provide the you a parent ask you explain you later what such parent ask you can do for you the name description, a size price, stock level, the collection or category, and an image that we want to import. So this sheet is read out from Sync Spota and you now have all the files here and you can even define a few further steps so you can define what you do with that file after we finished the task.
So in this case we do nothing because we could use the Google sheet to fill it for the on and automatically import every new product that you add to the sheet to the Volkmer store. So we do nothing. You just open that. You full new products. We put the new products to Woomera’s. But we could also, if it’s needed to lead to file, rename the file, move the file or move and rename the file so you can build an archive and just upload new files to the Google sheet or create new Google sheets with the same pattern and the same name.
And after reimported that the products we just put it to the archive folder, rename it there, put a stamp timestamp there. So this is what shall we do after the task finished?
Now, we also have the option to now replace records. So we sent the entire file to the target. Or we can update records. Update records means that you pick one unique identifier, which is typically and ask you for a product or an email for and use that a system or what else. And with updated records, we will monitor the source and we just reflect the changes of the source to the target. So we will keep a copy of the spreadsheet that you sent today at the next spreadsheet that you sent will be compared to the spreadsheet that we got and just the different records will be sent to the target, which saves you a lot of operations.
And it saves you a lot of time for the thinking because we don’t need to send too much API calls to the target. In this case, we fill up the store completely from fresh and so we say replace records. Also, you can decide how the column behavior is. So if we monitor an invalid column, what should sing spider do? Should we skip the entire row or just unset the value? Because it also could be that there are well used to the obligation and some that are not relevant and not obligatory field is wrong that we just answered the well-known Centaurus.
So it’s your decision how to proceed from there. Now we have different options. You for the columns, you can mainly keep everything as a text type, but you have the option to change to type of column as well. In this case, we gonna change the type for image because we know that here is an image. So we want to change it to image. If we do that, we have additional configuration options. First of all, is things that can monitor different kind of data sources for the image.
In this case, I check my file quickly. We have a full Eurail for the image. So this is the easiest way for you, for the image. And then we could use that option here, but we could also use an option. So let’s say in your file, you just provide the name of an image and the real path is missing. Then you choose this. And just at the Eurail path that is missing and we add the image name to it so we can download it.
We also can provide the files on a folder so you could upload your files to the drive folder and just change to the rectory where you pull the images from. And also you can have the images hosted on a set separate FTP or FTP server. Then you just provide the credentials for the server and the path to the images and we pull the images from there.
It’s after SFP that we allow so you can easily use any kind of host to host your images. And we also provide you with the host. Just pick the C as we file integration and step by Sync Spierer and then we give you an SFP account where you can upload the images up front. So also we in this case Barasat, we have full Jurrell.
What it could do as well is you can send. More than one image. So in this case, you just say this column contains multiple volumes so you can add as separate and how you separated that specific column and then we will treat it as additional product image and you can map it and we will vote for this case. We just have one image.
So and this is it. Mainly if you use this year, we file integration. You have additional options down here that you can use to merge files, make some mathematics and add formulas you can concatenate for a different kind. You can build collections, but this is more skilled. This is a very basic workflow that we’re going to do.
And we have really very skilled options here to manipulate the files. Citizen on the fly.
Then we have fear, a filter between the source and the target configurations. We give you always the possibility to filter and we give you the possibility to pick from every column that we sent here. So you could say just provide me the products that have a parent skew equals to 1000 or greater than 1000, if it’s a number or what else you’re going to need. So you can filter everything out here. You can add different filters to really close down the products that you need.
We had some use case questions already in and in the thread, like, can I send a product from Shopify with a specific TAC to a store? Yes, you can, because you can filter that. And this is very important working here with with different kind of filters to make it perfect also for testing.
It’s good if you have a very huge file with a lot of information and you want to send it somewhere, you can filter down to a specific column or a specific attribute from the source to make your test runs and not always send the entire file. Now, we’re going to go next. And this is always the target configuration and it’s always different. It depends on the target. So you will have different options for you newcomers and from Atlanta and for Shopify and from MailChimp and for fresh sales and for sales force and for HubSpot and for Miller Lite and for every other tool.
This screen is different. It carries all the attributes that are important to know when we send the data to the target for newcomers in this case, we can choose the unique identifier and in our case we will choose SKU, which is preselected. But you could also choose the product I.D., which is the database of commerce or the name.
We are also aiming to extend Shutz such unique identifiers. So if there are coming new options, we will add them here. And you have unique other unique identifiers and also you can choose the batch size. How many products do we send in? One batch to commerce.
This is important because of the performance. If you have a cheap post, you might want to lower those batch sizes to five or 10 or even one.
If it’s very slow or cheap, if it’s a bigger host or a VPs or a better solution, you can hire this batch size so that the integration, the API will not break the upload 50 is a good a good average size that would kind of send, as said, if it’s a very deep, very cheap post, you should lower that a bit.
It would just take a bit longer to send the product because we need more API calls.
Also, we can find things like do we want to create a parent product automatically?
So configurable products like variations, do we want to send them and and and create the variations on the fly? Yes or no? Do we want to update only map attributes so we could update on the attributes that an unmapped and delete values if they’re not mapped only out products so we don’t send you products, we just update them. So that’s all the different things that it can. As’ad, everything is written down here. You just need to read it.
And then the last step of the configuration or not the last step, the most important step here is the mapping stream. So in the mapping screen, this is the hard of seeing Spide This is where all the magic happens.
And here you have the left hand side where you see all the attributes that are coming from the source and you see all the attributes that are available in the target.
So in this case, we see all the filter for newcomers and here all the files from our Google sheet and all we need to do is drag and drop. So askew is here. We haven’t asked you here and we’re going to map ask you to ask you. This is a pretty one. OK, very easy. The name is also easy. We have it here remembered here description we have here two times to skip the description. So I just have a description.
I got a method with short description because I don’t have a long text in my file. Doesn’t make sense. So put it here.
So the names need not be the same. Of course it can be anything here. Here by luck. I named everything the right way because I knew what I did. But typically you get a file from a supplier or the source have a different name for something like instead of asking, you can have an idea or an ESPN code or a code or whatever you could have for the ask you and you just provided here and do the mapping. Now we have categories and this is some example for kids.
So we have fewer collection and higher categories. I got a map this and now really something special happens because categories are a special feeling newcomer’s. They can build out a hierarchy. So a product tree and in this case would give you an so called in the mapping with an inner mapping you can define. If in the source a specific word or a specific option is used, then map it in the target to that specific category.
We don’t have categories here in that store at the moment because it’s completely blank, so we don’t have anything. So we don’t show you the additional categories here. But if you have more categories, you would see them all here.
You couldn’t do any research and you could say, let’s map t shirts to grade T-shirts now or t shirts to apparel or whatever you want or need.
You can map it here. But just pressing the pause button and what else we can do here is to see an action set, a default action for non mapped values. So if we have nothing map down here, we can say to the think Spider can. On let’s map everything automatically. And if you don’t see it in the target, create them dynamically. So we will also create that categories directly in the target here with just that setting, we can have a possible separator to know if it’s a sub, categories ups up, ups up, and we can also give multiple values.
So if you have more than one category to assign, you can again here set the in the column separator to set this up. In this case, map out at the medically is enough going to need to do nothing else. And we’re going to map the main image here.
What we have you can also use to search to lower down results. In this case, I know that newcomer’s also wants us to set the status. So I’m searching for status here and we lower the results and see here, OK, we have here already a status and in the target we don’t in the source, we don’t see a status. And this is why we introduced a constant value, which is always available in the mapping screen. It doesn’t matter what the source has, we always give you a constant value.
And if you don’t have it in the source, you can use that constant value for the mapping what we do here. And we then just pull the possible options from the target and you can set it here. So in this case, we want to set all the products to publish. Also, what we need is the visibility.
So we went that here. Shop and search results, then we need a price and here is the regular price tag on that one. And here we have a number. So things but the wants to know how the numbers are formatted in the source. And we have a period and know that in the separator. OK, here we go. Then we have a stock that we want to map. So I said here, manage stock. Yes, it’s true.
And the stock quantity is here in that field. And also here we have a number. We put it empty for the thousand separator. Then if there’s this mapped in stock, it’s not needed because we do it automatically. We know that it is on stock because it has stock. And last but not least, we have configurable products here. So I want to make the size. And all I needed to do to get this extra size field is in e-commerce, to add an attribute called size.
You see here the attribute is created and I don’t configure any kind of terms. So there is no SML Excel size term here. We will also create that on the fly. And also you can see here that there are no products yet in the store and no categories set up. Instead, the default. Uncategorized category now for size.
We got a map here as well cise. And we will also created dynamically or map it if we have it, and for front and view, we set up the visibility on the front end and also we going to use that for a variation. So we answer that with, yes, we use that for immigration.
And now let us see quickly how this is going to look like.
Um, we have, I think, everything for an image, um, visibility and say this is your regular price stock is here.
Um, you can map a lot of fields. So there’s really many, many things you could map. But this is enough for really running the synchronization. Um, if you want to be sure and check something out, you can easily click on preview. Well, see a preview what we’re going to pick from the source and central target, but not to stop here. And then we come to the last step. This is giving the task a name.
You can also do it always here while you’re setting it up. So you get in the first step. You can give the task, but I will do it, you know.
So this is my spread sheet products to commerce.
Um, and we have a default task description based on integrations. You used that we write here, but you can change that, of course, and type in your descriptions so you better can identify what the task is doing without entering it. Then you can choose the trigger in this case are going to schedule the task and should repeat every hour. But you could also use an event to to trigger a task. But in this case, schedule is fine.
Now, here are going to activate the task and here you can set up the email notifications. So from every user that is within your account, you can trigger an email notification when the task succeeds and also when the task fails. Succeeds makes sense at the beginning when you want to be sure that the task really worked well. But you should remove you later on because then you get every time I name it and get it.
Uh, um, yeah, I’m a bit stressed when you have so many emails and for failed tasks, you can also get an email and then we give you a link to the execution log and you see why the task has failed. You can modify, let’s say, credentials if they are changing or attributes are changing or five times are changing. And we give you that information. It can change it and we run it. But, you know, when something fails, if you just pick your user of the account and now we are done, I click on Finish.
And you see, the task is already running because I activated and started it and we can access the running task by just clicking here that bubble and we see what’s going to happen. So we pulled already that spreadsheet. We got five valid rows here. We transformed everything for the newcomers. We exported five items. Everything nice. Now we gonna check the store and see what happened here. Let’s refresh us to page you for the categories.
And boom, we have two new categories here, simple product and T-shirts. Now let’s check the attributes. And boom, we have the terms here. We have different sizes in our size and now check the products and voila, we have the products here. But what happens? These are all simple products and we don’t want to have. We want to have a selection, so where to now open that specific product here and the front end? I don’t have a selection for the size, so I made a mistake while mapping.
I didn’t provide enough information to create variations. There is something more needed and in this case, it’s the parent. We forgot to map it. So what I’m going to do now is I just want to delete this products quickly.
And I also will remove it from the trash. And go back to sing Spider, the execution log is fine, and from here I can access the task again or I can go back to the projects and just click on the task to access it again. All I need to do is because everything is set up. I click on the mapping screen quickly, come here. And I know that I need to map the parent UID, which is also here.
I will search for it. OK, here it is. Quick, quick one at this parent. What does the parent that you. It tells the store story just to find the right around here. It tells the store which products belong together so they have the same identifier and we know now or could this products belong together and we need to build variations out of it. Goes, by the way, the same thing.
If you just transfer products from Shopify to Commerce or from my term agenda to commerce or from newcomers to Shopify or from Bookman’s to Amazon, doesn’t matter.
We always have this kind of pattern that we can read out the parent askew based on the source. So again, let me go to next remapped something you listen to and able to Toscan click on finish. And now we have to play button here. And if a one don’t want to wait for an hour to get the task started and this is also unique, you can start at any time. You just press the play button and here goes to party.
So again, we are connecting to the spreadsheet now. Um, you see it now in real time, what is happening? So we are connecting to the spreadsheet. We got to get all the data verified that these are valid rows. So we find out that there are five rows, all the rules are valid, um, and carry the information that we expect.
And now we are validating the store. So we are knocking on the API in Bucharest and ask if we can access and if this is the case, we get a reply from Bucharest that this is OK. And the next step is now, um, what has happened to verify and prepare the fact that the data so we are now transforming all the data that we got from the spreadsheet after transformation. We are starting and creating the categories. If there are not some, then we will say there are no new Karimov’s and then we are processing the data.
And you see here now that we had five in the source, but six on the target. And now let me refresh my screen for the products. I deleted all the products. And you see here that on the published we have two products now, um, namely, uh, regular product, this one and a variation product. And now if we access the website and visit it and go to the store, we have those two products here. First of all, the simple product Dimmock that we can add to the card.
And of course, now we have our variation product with all the variations inside. So this is what we had six, because we created the original product that carries the variations for operations. Plus the simple product is six, and from here you can choose the different sizes. And there’s one difference that were that I implemented here, namely, the Excel shirt costs a bit more than the other shirts. And here I can choose Excel and you will see here also the price is changing.
Now, this was a simple task. You can always go here and see what the tasks did by accessing our execution log. Just clicking on that I can here and you can see all the tasks that we did. You can access, again, the execution log and see what’s going on here. And we keep that execution log for fourteen days. And you can always go back and check what’s what what what went on on the task. OK, and, well, actually, this is it, this is in spite of how it works for every other tool.
So I said a lot of different integrations and this was an e-commerce use case. Of course, this is my speciality to do e-commerce, but we have a lot of different tools that you that you need for your daily use case, different tools that you have seen on assuming that you have seen and heavily used in the software like MailChimp, like Freshdesk, fresh sales. Um, uh, Facebook leads platform. So that’s really a lot of things you might be interested in and just added.
All those tools that we have are seen on sing spider dot com, uh, by just clicking on Integration’s and here you can find your preferred tools and let’s say you want to do something with Entercom. And on the other hand, you want to do something with Ft. Lee, then you just select both of them and we show you what you can do with this integration. At the moment. We give you a few options here and you can search through the entire database, which is updated frequently.
And yeah, and I would say we make it possible for some questions, and if we have time, I show you quickly how we add a new integration to sing spot so we don’t have a ton of questions here.
[00:47:05.380] – Lindsay (AppSumo)
Alexander’s been kind of killing it, getting all the answers to Sumolings. This one just came in. Do you have any do you have a super tutorial and help area to learn all this terminology? It’ll take some getting used to.
[00:47:19.900] – Norbert (SyncSpider)
It’s helped that sing spider dot com. This is our HELP database where we have all the different categories and a lot of articles. So we have here one of the 13 articles, 1723 and so on and so forth. So there are a lot of articles inside our knowledge base. And for every integration, as soon as you add it to the screen, we give you at C instructions here so you can see the basic instruction, how to integrate that specific tool.
[00:47:51.200] – Lindsay (AppSumo)
Wonderful. All right, so questions that have been answered, but in case people have these questions also, I really need to integrate with a couple APIs. Can I do it?
[00:48:06.950] – Norbert (SyncSpider)
Yes, you can. This is one unique thing about seeing Spider.
So in the probe plans, we give you already two very important integrations.
First of all, it’s the Web hooks, so please opt in the beta version of the new uppercase module.
Very important. This one is outdated, but still active because a few users have it in place. This new one where Beta is included is the one that is very powerful and extensive. And you should use that one for new integrations that are based on Web hooks. But we also give you the external API integration and this can connect to any kind of rest API. I just quickly pop it up to C to give the most advanced users here that have a bit of development skills, an idea of what it can do.
So let’s call it my sample API tool and click on the next button. And here you can choose to type what you want to do so it can be a Chazen and X, Y, Y or a C, a suite type integration combined to rest, I would just pick Chazen. You provide the base Eurail, you provide the required authentication for the rest. And we have already a basic authorization or two API key, other or two template. And you can also use custom headers if you need them for calling that specific API.
And exactly this is the way how we do it for the integrations that we build for our customers using the external API. But we are using the feature that is just available for agency plan users, namely custom integration templates. So you cannot even use that integration on your account. You can make it public or you can share the integration across different sub companies. And it will really be a native integration that is shared with the users when it’s said to public, and this is why it which is provided to agencies and it’s a bit more skilled because you can also build workflows based on the API.
You can manipulate data during and workflow, and you can do a lot of things even for for the Web. I can show you, um, maybe later. So and if it’s done and you set all the parameters, you click on Finish and then when you set up the task, you just go to the API of that specific tool to the API documentation. You copy the payload from their pasted into sync spota and we will pass all the fields for the mapping screen and boom you are done.
You have built your own integration. Use that tool several times already for custom integrations and it’s really powerful. But you need a bit of a development skill here to do that.
Um, maybe also because API was mentioned and I think it’s also important to know that. Um, so just give me a second. I need to open up a remote desktop application quickly to show you that. So what we have forcing Spide and this is very unique is our Windows application. So in sync, Spide, we can even give you a window software that is able to connect to any kind of database. You can build a new profile and select the type of database that you want to connect with, let’s say a fibre database, and you provide the credentials for it.
And after you did it and you are connected to the database, you can build your own entity here. You you just create a new entity and you have the possibility to select from all the database table. You can even define dependencies to different tables. And with that, you can make your own API integration from a local Windows database to a Web application. We have that very often in ecommerce that retailers are working with the local software that has no API.
And using that mechanism, you can send directly from the database to your stores while spider or to a newsletter software. But because a lot of things are locally or you can even connect like, let’s say a very small Dropbox, um, you can even collect our connect our Windows s FTB connection and create a local file storage on windows. And every time you put a file into that folder, we going upload it automatically to things to process it there and send it to the target as an integration and even download files from this storage to your local machine so you can fulfill it there, which is often needed for your piece of that.
It is able to export import CACP files already with products or customers, whatever you need.
[00:53:15.280] – Lindsay (AppSumo)
Wonderful. Thank you so much. All right, this question just came in, would this be a replacement for, say, the Wilkommen Multis store that sinks inventory between or stores?
[00:53:35.650] – Norbert (SyncSpider)
Um, you’re talking to the right one here because I love commerce and a lot of things with that actually did not use it for multiple stores so far. I have one client that has and local ERP software and at the moment, five Magento stores, three of e-commerce stores and is listing online listening on one e-commerce, multiple in the store. And this is all done through Spide While the source is only the one ERP and based on specific filters, we are sending and updating the stock in the different channels, which are also different tools.
So yes, actually this is definitely something you could do. You could also be do a combined order import back to your target store. So let’s say you have one store that you use as a source with all the entities, products, taxand whatever you need. You could send the products out to the other child stores, which can be completely different and sent back that either to your store update or the status back then. What we going to do in the future is of course will bring new features and extend that and maybe there will be it’s already brand something that we will call the data hub.
This is something that we want to introduce once. It’s it’s already in the planning phase, but we have no concrete plans for when to do it.
But we will provide something where you can also store specific kind of data, information, whatever we’ve spider to maintain and sync data on site. But this is a really long future anyway, thinking between those tools. Yes, absolutely possible. You need quite some tasks with.
[00:55:21.850] – Lindsay (AppSumo)
Well, all right, so this question is technically for me, will once to know if there’s one minute walk through for each tool to help the users get going, I will not be creating any walk through for anything. But what do you guys got?
[00:55:40.300] – Norbert (SyncSpider)
Yeah, so we’re working already on. We did already a few pilot video tutorials for exactly that. We have already decided who will do that and we are already planning them. So we are about to start the production of Short Duboc Truth and you will always find that we do work from here in that black space here or with a video button, a small video button where you click on it. Got a light box with the video tutorial for that specific use case.
And we also have a YouTube channel and we will upload all them to the YouTube channel so you can browse through them. At the moment, we don’t have so much of those video tutorials, but we’re really working on them. And the get new video tutorials on the run for every integration, for different use cases, for different concepts that we haven’t seen, Spide, to make things work best for you. As the person behind the video team at to that does all the product videos, it is a lot of work to make.
Yeah, a lot. It takes a long time. I if I remember correctly, you have quite a few integrations that you would have. Yes.
I think that’s about as many videos that as we created last year. So if it took you a full year like that checks out and this will take a while.
Absolutely. And one thing that I really again want to mention, you mentioned at the beginning, we.
Might seem or might look a bit to be a bit slow in progressing something so a bit slow in integrating here since four years and have one hundred and fifty integrations not not four years, but three and a half years. And we had a lot of planning phase and a lot of deep integrations that we did for ecommerce that take much, much, much longer than a regular integration and.
As we did for sing Spider itself to reinvent the wheel, how we could do an integration, I know it from other tools they need to court. They’re required to code a plugin to make an integration, um, to their SaaS software. We try to first think about how can we do that faster? How can we improve that? And then we start to develop that way. And as soon as we have it, we got to be pretty fast.
We did this for the filters, which are not dependent on an integration anymore. The filters are just in the court system and every integration’s has it. We don’t need to code a filter for every new integration that we do because we just have it in the core. And we did it for Web hooks to create templates and we did it for the external API to make integrations faster. And we also do it for the videos now. So as we speak, the team that is assigned to do that is planning out how to produce this video tutorials in a fast way.
So when we start with that, you will get pretty fasters tutorials because we always have a pattern assigned how to do it. And this is the approach that we haven’t seen. Spider, I think first, um.
Take your time to really analyze something and then proceed and do it. Wonderful. Thank you so much for that. I definitely appreciate you taking your time and things take sometimes longer than anticipated and that that definitely happens and it probably doesn’t help that there’s so much to do. Well, says do what you guys know.
[00:59:41.160] – Lindsay (AppSumo)
All right, siblings, if you have any more questions, you can leave this here. Now, is there anything else that you guys want to show us?
[00:59:49.140] – Norbert (SyncSpider)
Well, we could do a quick integration, but we can also make if you want a second webinar in the next two weeks where we really announce a skilled webinar where we do some kind of development things. So this is a bit on you. If some links want to see quickly a Web hook integration with Albatros, for instance, I can show that up and make a template for Albatros, which would be a new integration for us, will take her on about 10 minutes.
Just tell me if you want that and we do it. Otherwise we can do another webinar or whatever you want.
So let us know this is your time. You could drop it in the chat room. You can put this anywhere you want. Want to do a little? I don’t know. There’s no like thumbs up option for you guys have to actually type things.
Michael says, sure, sure, so he has time. That’s great, yeah, let’s do it. So here we go to the custom integrations. This is what we and the team here see and what the producers currently see. But it’s mainly for agencies. And here I see all the integrations that we’ve built so far. One thing that I quickly need to do is I need to switch to back to my account here in the master. And this is something I don’t want to set up in the absolute test account because I want to share it public later on already.
So just give me a second to go back here and improve. And again, I go to the custom integrations, OK? Now, I will, because I have prepared that already, Albar Cross, I prepared already this integration, I would quickly here hop in to show you what’s happening. So when you add a new custom template integration, you see exactly this screen here. So we give an integration a name. We can write a small description for that specific integration’s, so like, say, send all your new leads from Albert Cross to your target integration.
I think Albatros is also a previous ordeal, as far as I know. Yeah, pretty sure, and you can define who should see that integration, so in this case, it was said to my company only, but I will share it with public. So this integration, as soon as we have done it, will be life. And this will be an external API integration with the picture here, the logo which will appear in the screen later on.
So now we are in the custom integration screen. What we need to define here is, first of all, the connection configuration. In this case, I can set how are we going to integrate with Albatros in this case? We have a rapid integration because Albatros has no API. I cannot pull data. They we rely on the website. Choose where Pook here. But I could also, if it’s a rest API, would say integration and then we need to provide a lot of more data here, like the base who are what.
We have seen an external API actually. So also here I provide everything that is needed while this is a Web pook integration and I can create additional information about this integration so I can provide information where to find the API with an albatross, how to connect it and what to do. And I click on Done. And mainly this said, I add a new data type which is leads, and if I go in here I can define what I’m going to want to do.
And this is import data to sing Spide If it is an API integration, I could also upload the payload here. So we passed the fields. I can make a workflow. So with that integration I can make a workflow that if I got the data in, namely from Leeds, I want to perform a specific action like modify the schema, make an incremental import, because I don’t want to see what I can change the payload handler. I can make custom fields so I could do quite a lot of workflows and I don’t need to do or I can not just do one workflow.
I can different workflows and those for a cross are triggered after each other. After I got the data, before we send it to the target. What to do now here is I will enable that integration. We did not have Albatros before insync Spierer. It’s completely new integration and it’s the first time that we will have that integration live publicly in our integrations. So now when I go even to the app Sumell or just let me check one thing. If it’s really said to public and if it’s published, um, I forgot about that because I need to check that I’ll across.
Yeah, it’s public and it’s public spending, so if you submit a public integration, for instance, we will get it in as public spending and I can then publish it to our integration’s. And now it’s life for everyone here on Spota. Now, let me switch back to the webinar customer that we created when we started the walkthrough. Go back and create a new task. Here we go. So what are you going to do is I create a new task here.
I will put this new integration album across that we just added, so you will find it here and now we have album, cross and click next.
Typically you find you’ll find the description here, because we are we did not enter any kind of description. How you get to how you can set up that. I know it. So I will show it quickly. I will edit later after work webinar just to have that I have the time. So let’s go to Al Cross here and let me just log in. To my Albatros account.
And now in that account, we want to set a new workflow in this new workflow, we create new workflow, namely a Web hook and Web name is called Sing Spider Sumar Webinar.
And I just pick from Sing Spider, the Eurail that we provide here, pasted here and.
We sat here to capture the rare books, we are waiting for weapons here and we want to export new leads and we can even search for a segment, namely, let’s say, all needs new leads or provide any other segment. We can pick that here. So I would check here new leads every time a new lead appears in Albatros who can send it over to the target, just hit the safe button and now I do a quick action and send the example.
And now we are waiting for that example here in Sing Spider and here it is. So this is the one that we got and now we just click on finish.
And we can go to the next step I will set here, let’s say the Google shit again that we had as the targets and a set next.
I could filter by everything I said, what we get from from across here, because this is already default filter. So I could filter, let’s say, for country, if you have a serum, you can filter for the country and send just the leads from your country and decided to, let’s say, your sales team. Now I can get and grab a new Google sheet. I will pick here my Google shit that I prefer prepared for Absolom already.
So we will write some additional data, their import sample task. OK, here we go. And we pick that sheet here.
Select um. And I can now add columns here. What I’m going to do, so I want to add a new column with the lead and the name and whatever social media, let’s say, name and e-mail and phone is, well, going to have. And we can all try to find each time we can expand to file. Each time aside, if we connect mail, she would send that idea right away. And here is the mapping screen again.
All the feeds that feels that we got from source, all the mapping that we need to do now and then is the same process as before.
Set up the task and boom, you have done the new integration, sending the leads from Albatros directly to your Google shit. That’s it. And further, the questions. All right, Schmeling’s, if you have anything else that you would like to know, send those questions in now. Thank you for showing us that. Count me in for DFI gigs.
Weeks. Done for you and for you got a grade. Lovely.
[01:09:48.600] – Lindsay (AppSumo)
All right, we can go ahead and wrap this up then. Thank you so. Yes for walking us through. Thank you, Alexander, for answering all the questions behind the scenes. Similar things. If you have not already, you can go ahead and redeem your code. Forcing Spider is starting at Red Palace for a lifetime deal. And please, once you’ve done that, leave your reviews on the deal page. Would you love to read it? And of course, you can always leave your questions there as well.
[01:10:16.920] – Norbert (SyncSpider)
Thank you guys so much. It’s been fun.
[01:10:18.930] – Lindsay (AppSumo)
Thank you. Thank you. Bye bye, happy. Bye bye.