The scenario you're describing is pretty standard issue for many uCommerce solution and it's certainly possible to import data directly to uCommerce automatically. Right now you have to use our APIs to import new SKUs and update existing ones.
We're working on uConnector, an integration platform, which will make the formalize the process and make it easier. We're not quite there yet, but let me know if you're interested in joining the beta at ssl AT ucommerce DOT dk and I'll let you know how to get it.
Thanks so much for the speedy response. I am currently exploring all that uCommerce offers as a possible solution for us.
When you say "use our APIs to import new SKUs and update existing ones" what exactly do you mean by that? API'S?
Also is there any "current" documentation that might aid me in understanding or even implementing the process I described in my query ... feeding Epicor (or similar a system) data into uCommerce product pages etc using SKU as the cross link?!
uConnector sounds great. I wil let you know if i am interested in joining the beta. When do you think the bet awill be ready roughly?
You're welcome to give me a shout directly via e-mail if you feel there are details you can't share here on the forum. My e-mail is ssl AT ucommerce DOT dk
I think I will be in touch as we are looking at Umbraco and Ecommerce very closely and we have many unaswered questions. I a have my research hat on but some stuff is very in depth and not sure if i'm on the right tracks. We would be willing to licence if uCommerce can provide everything we need.
Myself or my Director will be in touch at some point.
If we wanted to feed uCommerce data from an SQL server so it was constantly up to date, with our product information for example, we don't have to copy all that product information "into" uCommerce do we and therefore have to keep on copying it back in when updated on this other sql server?
We are not sure yet but we may want to keep the information that the e commerce site displays out of UMbraco, so need ot be sure uCommerce is fine with taht and can be coded just to pick of the sql tables on the other server.
If you don't want to maintain the product catalog in uCommerce you can certainly keep the data separate in other tables. You can still use Transaction Foundation to create baskets and orders, handle online payments, business logic around shipping and inventory.
If you need uCommerce to be aware of the product information and have it available in the backend you'll have to synchronize the uCommerce catalog with your custom tables.
To be frank you'll get the most value out of a product like uCommerce if you do synhronize catalog information. You could do one-way sync with Epicor and only allow updates there. uCommerce 2.5 enables you to shut off catalog management altogether for some or all users.
It might make sense to do a conf call and discuss the options to make sure we're on the same page.
We are trying to use UCommerce on our new project. And I'm also looking for bulk product upload and found Uconnector is some thing we are looking. Can you please advise if uconnector is launched or where we find some more information on this product.
uConnector was put on hold to allow us to focus on doing the Umbraco 5 integration. Now that that's out of the way work will resume on uConnector. We've got a couple of projects to complete before we start. I expect we'll boot up the effort late 2012 or beginning 2013.
Can I link uCommerce to an Epicor database to populate record information?
Hi All
Am learning about Umbraco adn uCommerce so excuse if silly question!
If i wanted to feed SKU and other such information into uCommerce from a database such as Epicor is this possible?
The ideal aim is to have it so that when a new item is placed or old item amended in Epicor it runs through to uCommerce and hence the website?
I am trying to avoid having to replicate pages that are alreayd created in the Epicor database in uCommerce.
Hi Alistair,
Your question is a classic. Don't worry about it.
The scenario you're describing is pretty standard issue for many uCommerce solution and it's certainly possible to import data directly to uCommerce automatically. Right now you have to use our APIs to import new SKUs and update existing ones.
We're working on uConnector, an integration platform, which will make the formalize the process and make it easier. We're not quite there yet, but let me know if you're interested in joining the beta at ssl AT ucommerce DOT dk and I'll let you know how to get it.
Hi Soren,
Thanks so much for the speedy response. I am currently exploring all that uCommerce offers as a possible solution for us.
When you say "use our APIs to import new SKUs and update existing ones" what exactly do you mean by that? API'S?
Also is there any "current" documentation that might aid me in understanding or even implementing the process I described in my query ... feeding Epicor (or similar a system) data into uCommerce product pages etc using SKU as the cross link?!
uConnector sounds great. I wil let you know if i am interested in joining the beta. When do you think the bet awill be ready roughly?
Thanks for helping me quash some worries!
The APIs are your hooks into uCommerce and basically every concept found in our product has one.
4 Steps to Building an Apple-style Product Configurator with uCommerce and 3 Steps to Managing Multiple Basket Items as One show how you can query and update uCommerce data objects using the API.
uCommerce How To: Create A Product Using The API shows how to create products using the API. The docs are for an older version of the API, so you'll want to take a look at Migrating Code to UCommerce.EntitiesV2 as well. It details the differences between the newer version of the API and the old one.
Thanks for the reply.
I will look into this further via the links provided and see if uCommerce is the solution for us :)
You're welcome to give me a shout directly via e-mail if you feel there are details you can't share here on the forum. My e-mail is ssl AT ucommerce DOT dk
Thanks.
Soren
I think I will be in touch as we are looking at Umbraco and Ecommerce very closely and we have many unaswered questions. I a have my research hat on but some stuff is very in depth and not sure if i'm on the right tracks. We would be willing to licence if uCommerce can provide everything we need.
Myself or my Director will be in touch at some point.
Thanks again
Sounds good. Let me know if you want to set up a conference call at some point.
Soren, final question to make sure I am clear.
If we wanted to feed uCommerce data from an SQL server so it was constantly up to date, with our product information for example, we don't have to copy all that product information "into" uCommerce do we and therefore have to keep on copying it back in when updated on this other sql server?
We are not sure yet but we may want to keep the information that the e commerce site displays out of UMbraco, so need ot be sure uCommerce is fine with taht and can be coded just to pick of the sql tables on the other server.
If you don't want to maintain the product catalog in uCommerce you can certainly keep the data separate in other tables. You can still use Transaction Foundation to create baskets and orders, handle online payments, business logic around shipping and inventory.
If you need uCommerce to be aware of the product information and have it available in the backend you'll have to synchronize the uCommerce catalog with your custom tables.
To be frank you'll get the most value out of a product like uCommerce if you do synhronize catalog information. You could do one-way sync with Epicor and only allow updates there. uCommerce 2.5 enables you to shut off catalog management altogether for some or all users.
It might make sense to do a conf call and discuss the options to make sure we're on the same page.
HI Soren
Thanks and we will be in touch.
Hi Soren,
We are trying to use UCommerce on our new project. And I'm also looking for bulk product upload and found Uconnector is some thing we are looking. Can you please advise if uconnector is launched or where we find some more information on this product.
Regards,
Jazz
Hi Jazz,
uConnector was put on hold to allow us to focus on doing the Umbraco 5 integration. Now that that's out of the way work will resume on uConnector. We've got a couple of projects to complete before we start. I expect we'll boot up the effort late 2012 or beginning 2013.
Meanwhile here are some docs, which might help: Bulk Import From Third Party Systems Using The uCommerce API.
is working on a reply...