Post Reply 15 posts Page 1 of 1
Integration with OS Commerce
  • sam
    New User
    New User
    Posts: 11
    Joined: Thu Jun 22, 2006 1:42 pm
    Location: Illinois

    Integration with OS Commerce

    by sam » Mon Jan 29, 2007 11:19 pm

    Is this still the Ecommerce solution of choice for Retail Edge integration? Has this project started? When do you have the integration with OS Commerce "scheduled" for completion?
  • fwhorch
    New User
    New User
    Posts: 36
    Joined: Sat Feb 10, 2007 9:35 am
    Location: Brunswick, Maine
    Contact:

    OS Commerce integration

    by fwhorch » Sat Feb 10, 2007 9:48 am

    We're waiting on this integration as well. What's the prognosis?

    As we ramp up our web site sales, we need a better way to keep track of stock levels and we'd like to use RetailEdge.

    Any update on the web integration timeline and strategy would be greatly appreciated! We like RetailEdge for our in-store sales, but we are going to need web site integration this year and so far Retail Edge doesn't seem to provide it.

    Thanks,
    Fred
  • User avatar
    RetailEdge Moderator
    Site Admin
    Site Admin
    Posts: 1298
    Joined: Mon Jan 23, 2006 4:02 pm
    Location: Rutland, VT
    Contact:

    Re: OS Commerce integration

    by RetailEdge Moderator » Mon Feb 12, 2007 2:39 pm

    The project schedule should be set for these projects by the end of the week. Please contact us if you need to find out when this work is to be scheduled


    fwhorch wrote:We're waiting on this integration as well. What's the prognosis?

    As we ramp up our web site sales, we need a better way to keep track of stock levels and we'd like to use RetailEdge.

    Any update on the web integration timeline and strategy would be greatly appreciated! We like RetailEdge for our in-store sales, but we are going to need web site integration this year and so far Retail Edge doesn't seem to provide it.

    Thanks,
    Fred
  • All_Things_Fun
    New User
    New User
    Posts: 4
    Joined: Tue Mar 20, 2007 12:48 pm
    Location: West Berlin, NJ

    Re: Integration with OS Commerce

    by All_Things_Fun » Tue Mar 20, 2007 12:51 pm

    sam wrote:Is this still the Ecommerce solution of choice for Retail Edge integration? Has this project started? When do you have the integration with OS Commerce "scheduled" for completion?


    Hey guys! I also wanted to throw my hat in with this one. We are setting up our webstore with OS Commerce and would love to be able to integrate Retail Edge. What's the current time line for this project? Is it still in the works?

    Thanks,
    -Ed
  • User avatar
    RetailEdge Moderator
    Site Admin
    Site Admin
    Posts: 1298
    Joined: Mon Jan 23, 2006 4:02 pm
    Location: Rutland, VT
    Contact:

    Re: Integration with OS Commerce

    by RetailEdge Moderator » Wed Mar 21, 2007 10:03 am

    Ed -

    Yes this project is still in the works. It is currently in early Beta. As you start considering your Webstore, feel free to have the person who will be working on your site contact us before you start settting it up. There are lots of questions you will need to answer before setting up your site.

    A few of them might be:

    1. Are you going to process credit cards on-line and then dump sales into RetailEdge or are you going to dump orders into RetailEdge and then process the orders through RetailEdge as you get them?

    2. How are you going to handle order fufillment? How are you going to let the system and the customers know when an item has shipped?

    3. Are you going to be allowing customer log-ins so that customers can obtain the same store discounting that they receive in the store on-line?

    3. Do you care about tracking web orders separately?

    4. Do you want inventory posted up to the on-line store? Batch or as requested?

    5. Are you going to be building pages based on requests to RetailEdge data or are you going to have a separate database for inventory information?

    6. Are you going to be displaying real time inventory quantities or doing a nightly posting of information?

    7. Do you want to display actual quantities or just availability? Do you want to setup minimum inventory levels for items that if the RetailEdge inventory (or on-line database) inventory levels fall below, that the site will show Not Available?

    8. How are you going to handle size and color (matrix) items on your site? Some people have pages of items for each color item and then have a dropdown of sizes. Other people have one page for each item style but then have dropdowns for each size and color.

    9. Are you going to want to mask your item numbers on the site? (so that competitors can't see who you might be buying from.)

    Anyway, as you can see, lots to think about.


    All_Things_Fun wrote:
    sam wrote:Is this still the Ecommerce solution of choice for Retail Edge integration? Has this project started? When do you have the integration with OS Commerce "scheduled" for completion?


    Hey guys! I also wanted to throw my hat in with this one. We are setting up our webstore with OS Commerce and would love to be able to integrate Retail Edge. What's the current time line for this project? Is it still in the works?

    Thanks,
    -Ed
  • Eva
    New User
    New User
    Posts: 7
    Joined: Wed Jan 24, 2007 10:39 am
    Location: Pennsylvania

    by Eva » Thu Dec 20, 2007 8:05 am

    Any luck with the Beta test for OS Commerce?
    I need customer information dumped into Retail Edge and dumped into UPS if that's possible??? Then we wouldn't have to be retyping.
    I'm not so interested in the inventory sync as we reorder most of our items and I would prefer that our customers don't really know if we have it. We normally receive new items within a week and keep them updated on the status.
    Thanks in advance.
    Eva
  • User avatar
    RetailEdge Moderator
    Site Admin
    Site Admin
    Posts: 1298
    Joined: Mon Jan 23, 2006 4:02 pm
    Location: Rutland, VT
    Contact:

    by RetailEdge Moderator » Thu Dec 20, 2007 9:15 am

    Eva,

    We are working towards something like this. However, we are slowing things down for the holidays and probably pick it up in the new year. Thanks for the input about how you would like it to work. The UPS link is a new wrinkle. We have also considered doing something with their API but are not sure how many people would really use this feature.

    Have a great holiday.

    Eva wrote:Any luck with the Beta test for OS Commerce?
    I need customer information dumped into Retail Edge and dumped into UPS if that's possible??? Then we wouldn't have to be retyping.
    I'm not so interested in the inventory sync as we reorder most of our items and I would prefer that our customers don't really know if we have it. We normally receive new items within a week and keep them updated on the status.
    Thanks in advance.
    Eva
  • All_Things_Fun
    New User
    New User
    Posts: 4
    Joined: Tue Mar 20, 2007 12:48 pm
    Location: West Berlin, NJ

    Re: Integration with OS Commerce

    by All_Things_Fun » Sat Jan 05, 2008 3:17 pm

    Almost a full year later and I'm finally getting back to you on this topic. (Sorry about that!) Are you guys still looking at any kind of Webstore integration? I know when we first purchased Retail Edge we purchased your yahoo-store server software. (We never did actually implement it though.) :)

    We've spent the last year investigating various online options. We do keep coming back to OSCommerce and ZenCART. At the moment we are leaning toward ZenCart as it has been a little bit easier to implement in our situation.

    To answer your integration questions:
    1.) Process credit cards?
    We are processing the card data offline. Both OSCommerce (with a module) & ZenCart allow card data to be processed offline (or in Retail Edge.)

    2.) How handle order fulfillment?
    Both OSCommerce & ZenCart have robust back-end administration managers. In fact both have recently made it pretty easy to integrate UPS, FedEx & USPS modles.

    3.) Are you going to allow customers to log-in to see special pricing?
    No. Although both OSCommerce and ZenCART support this function in some capacity.

    4.) Do we care about tracking web orders separately?
    We didn't until you suggested it and we realized this type of data would be important. Although we have found work-arounds in RetailEdge. We also need to track EBay sales, etc.

    5.) Do we want inventory posted to the online store? Batch or on requested?
    For us this is the heart of the matter. We have several thousand sku and work very hard to maintain the integrity of our in-store inventory data. I can't imagine running a "second" inventory system. Now all that said since we run charges manually we could be fine with running a batch file once or twice a day to update our inventory. (Depending on volume this would keep Out-of-stocks to a minimum.) And with manual credit card entry you would never charge a customer for an Out-of-stock product.

    6.) Build pages based on request or run a separate database?
    We'd run a separate database as set-up through ZenCart (or OSCommmerce.)

    7.) Display Real Time inventory or a nightly posting.
    Daily Posting.

    8a.) Display actual quantities or just availability?
    Just availability

    8b.) Do you want to set-up minimum inventory thresholds to determine if the item will show in-stock?
    Yes, but if we engage the inventory databse in OSCommerce or ZenCart we can use the admin interface to adjust these values item-by-item. If we could also tell RetailEdge as part of a report export process to display "0" for any value of "x" or below. (That might make it easier to manage the process accross thenentire website.)

    9.) How will you handle colors & sizes? Different listing for each item or drop down menus, etc?
    This one is tough. For the sake of simplicity one might have to setup a different record for each size/color, etc. Since we sell limited clothing it isn't a deal breaker. But I could see a clothing store needing to spend a great deal of time on this topic. But as a hobby store I'd hate to pay a great deal for this functionality. (Since we really couldn't use it.)

    10.) Do you want to mask item numbers so your competitors can't see who you are buying from?
    While we wouldn't want to do this I can see others wanting this functionality. ZenCart offer this function globally in the most recent release.

    Of course you are correct. Lots to think about. We are trying to get a basic store online to see how our customers will respond. At this point we are building in ZenCart and I'm looking for a way to update inventory.

    Thanks,
    -Ed
  • fwhorch
    New User
    New User
    Posts: 36
    Joined: Sat Feb 10, 2007 9:35 am
    Location: Brunswick, Maine
    Contact:

    Re: Integration with OS Commerce

    by fwhorch » Fri Jan 18, 2008 10:45 pm

    We have set up shop online with cs-cart (http://www.cs-cart.com/). We really need integration between our online sales and Retail Edge!

    We looked at OS Commerce, but went with cs-cart instead because it has a richer feature set while also providing full source code allowing for our own modifications.

    Here is how we answer the questions posed earlier:

    1. Are you going to process credit cards on-line and then dump sales into RetailEdge or are you going to dump orders into RetailEdge and then process the orders through RetailEdge as you get them?

    We process orders online and then dump sales into RetailEdge. Right now this means manually keying in customer information and items sold.

    2. How are you going to handle order fufillment? How are you going to let the system and the customers know when an item has shipped?

    We use the order fulfillment features of cs-cart for notifying customers. As far as RetailEdge, we just process the sale as usual and don't track order status there at all. Maybe we're not using a feature of RetailEdge that we don't know about, but all we do with RetailEdge is record a sale. All of the order status tracking (for online sales, phone sales, mail order, and special orders) is done outside of RetailEdge, mostly on paper.

    3. Are you going to be allowing customer log-ins so that customers can obtain the same store discounting that they receive in the store on-line?

    We want to. We can set up customer accounts in cs-cart and customer accounts in RetailEdge. We'd like to link them together. We'd also like to link together gift certificates.

    3. Do you care about tracking web orders separately?

    Yes. We want to track our web channel separately to get a sense of how it is performing compared to our brick and mortar channel.

    4. Do you want inventory posted up to the on-line store? Batch or as requested?

    This is the major issue for us right now. We can't figure how to do either batch or as requested. We would prefer to do as requested so the web store has a real-time inventory count that we and our customers can rely on.

    5. Are you going to be building pages based on requests to RetailEdge data or are you going to have a separate database for inventory information?

    We have a separate web database for inventory information. We'd like to pull in data from RetailEdge in real time into our web database.

    6. Are you going to be displaying real time inventory quantities or doing a nightly posting of information?

    We would like to display real time inventory quantities.

    7. Do you want to display actual quantities or just availability? Do you want to setup minimum inventory levels for items that if the RetailEdge inventory (or on-line database) inventory levels fall below, that the site will show Not Available?

    We want to display actual quantities. Our site shows backordered status and allows quantities to go negative to reflect backorder demand.

    8. How are you going to handle size and color (matrix) items on your site? Some people have pages of items for each color item and then have a dropdown of sizes. Other people have one page for each item style but then have dropdowns for each size and color.

    We do a matrix as appropriate. cs-cart is very flexible in this regard.

    9. Are you going to want to mask your item numbers on the site? (so that competitors can't see who you might be buying from.)

    No, we use the same SKU on our web site as in our store.
  • User avatar
    RetailEdge Moderator
    Site Admin
    Site Admin
    Posts: 1298
    Joined: Mon Jan 23, 2006 4:02 pm
    Location: Rutland, VT
    Contact:

    Re: Integration with OS Commerce

    by RetailEdge Moderator » Tue Jan 22, 2008 3:37 pm

    Thanks for the update on your web integration. Another thing to consider when the time comes and this further emphasises the diversity in carts out there and why it is pretty critical that we choose the right one.


    fwhorch wrote:We have set up shop online with cs-cart (http://www.cs-cart.com/). We really need integration between our online sales and Retail Edge!

    We looked at OS Commerce, but went with cs-cart instead because it has a richer feature set while also providing full source code allowing for our own modifications.

    Here is how we answer the questions posed earlier:

    1. Are you going to process credit cards on-line and then dump sales into RetailEdge or are you going to dump orders into RetailEdge and then process the orders through RetailEdge as you get them?

    We process orders online and then dump sales into RetailEdge. Right now this means manually keying in customer information and items sold.

    2. How are you going to handle order fufillment? How are you going to let the system and the customers know when an item has shipped?

    We use the order fulfillment features of cs-cart for notifying customers. As far as RetailEdge, we just process the sale as usual and don't track order status there at all. Maybe we're not using a feature of RetailEdge that we don't know about, but all we do with RetailEdge is record a sale. All of the order status tracking (for online sales, phone sales, mail order, and special orders) is done outside of RetailEdge, mostly on paper.

    3. Are you going to be allowing customer log-ins so that customers can obtain the same store discounting that they receive in the store on-line?

    We want to. We can set up customer accounts in cs-cart and customer accounts in RetailEdge. We'd like to link them together. We'd also like to link together gift certificates.

    3. Do you care about tracking web orders separately?

    Yes. We want to track our web channel separately to get a sense of how it is performing compared to our brick and mortar channel.

    4. Do you want inventory posted up to the on-line store? Batch or as requested?

    This is the major issue for us right now. We can't figure how to do either batch or as requested. We would prefer to do as requested so the web store has a real-time inventory count that we and our customers can rely on.

    5. Are you going to be building pages based on requests to RetailEdge data or are you going to have a separate database for inventory information?

    We have a separate web database for inventory information. We'd like to pull in data from RetailEdge in real time into our web database.

    6. Are you going to be displaying real time inventory quantities or doing a nightly posting of information?

    We would like to display real time inventory quantities.

    7. Do you want to display actual quantities or just availability? Do you want to setup minimum inventory levels for items that if the RetailEdge inventory (or on-line database) inventory levels fall below, that the site will show Not Available?

    We want to display actual quantities. Our site shows backordered status and allows quantities to go negative to reflect backorder demand.

    8. How are you going to handle size and color (matrix) items on your site? Some people have pages of items for each color item and then have a dropdown of sizes. Other people have one page for each item style but then have dropdowns for each size and color.

    We do a matrix as appropriate. cs-cart is very flexible in this regard.

    9. Are you going to want to mask your item numbers on the site? (so that competitors can't see who you might be buying from.)

    No, we use the same SKU on our web site as in our store.
  • barkleyburger
    New User
    New User
    Posts: 3
    Joined: Sat Jun 20, 2009 10:37 pm

    Re: Integration with OS Commerce

    by barkleyburger » Sat Jun 20, 2009 10:39 pm

    So after a few years, has any movement happened on the integration with any ecommerce solutions?

    if not any hack way to get the excel file exports from RE into ASPDOTNETSTOREFRONT?

    thanks
  • User avatar
    RetailEdge Moderator
    Site Admin
    Site Admin
    Posts: 1298
    Joined: Mon Jan 23, 2006 4:02 pm
    Location: Rutland, VT
    Contact:

    Re: Integration with OS Commerce

    by RetailEdge Moderator » Mon Jun 22, 2009 5:14 pm

    We do have an API that will allow you to query the RetailEdge database and post in sales and retrieve inventory and quantities. We have users that do this. We also have users who do only exports of the inventory and manually enter sales. It really depends on what your needs are. This link might discuss it better.

    http://www.retailedge.com/phpBB/viewtop ... 627&p=1975

    If you need us to send you the API documentation just e-mail sales@retailedge.com


    barkleyburger wrote:So after a few years, has any movement happened on the integration with any ecommerce solutions?

    if not any hack way to get the excel file exports from RE into ASPDOTNETSTOREFRONT?

    thanks
  • aanyad
    Posts: 1
    Joined: Mon Apr 22, 2013 7:55 am
    Location: USA

    Re: Integration with OS Commerce

    by aanyad » Mon Apr 22, 2013 8:16 am

    Hey I am completely new with this post so please give me some useful information more. I got some of it from the discussion but still need some more.
    Thank you.
  • User avatar
    RetailEdge Moderator
    Site Admin
    Site Admin
    Posts: 1298
    Joined: Mon Jan 23, 2006 4:02 pm
    Location: Rutland, VT
    Contact:

    Re: Integration with OS Commerce

    by RetailEdge Moderator » Mon Apr 22, 2013 10:31 am

    Nothing has really changed. We have an API that customers can purchase that will allow any web programmer to talk to the RetailEdge data and post sales, get inventory, pricing and quantities. If you are a developer and interested in this solution, just contact sales@retailedge.com and they will be happy to provide you with the manual that will describe how this works.

    The dialog is pretty simple XML.
    aanyad wrote:Hey I am completely new with this post so please give me some useful information more. I got some of it from the discussion but still need some more.
    Thank you.
  • adlena
    Posts: 1
    Joined: Sat Jul 13, 2013 5:58 am

    Re: Integration with OS Commerce

    by adlena » Sat Jul 13, 2013 6:10 am

    I am new on this forum.I discovered lots of interesting information on this forum.I guess I’m not alone!
    continue the actual impressive work.Good information, keep working man.


    www.solitairewithbuddies.com
Post Reply 15 posts Page 1 of 1

Who is online

Users browsing this forum: No registered users and 1 guest