Integrated Sage/internet-selling software

Apologies if this q has already been asked, but does anyone know the best way/product to achieve integration of Sage with online selling of products? I'm hoping there is a Sage add-on module or approved partner software!

Thanks for your help ...

Comments
mramsay's picture

Online selling integration

mramsay | | Permalink

There are several options for online/internet selling which broadly break down into 2 groups:

(1) own website with some sort of shopping cart system for taking orders and payments, plus possibly issuing invoices, updating stock etc.

(2) major online channels like Amazon, eBay etc

If you need integration for (1) I think there a quite a lot of solutions available for Sage 50 which you could Google.

For (2) I am not so sure. We are doing a solution for Sage's TASBooks product range (http://www.infoplex.co.uk/webseller), so there may be someone doing the same thing for Sage 50.

sage e commerce

PeterGrimley | | Permalink

See sage website

1.on homepage rhs go to sage additions and download brochure

2.go to sage shop click on software and services then tradebox

Hope this is what you're looking for.

Sage 50 Add On for internet selling

19kings | | Permalink

Hi Jenni,

One that we have had really good success with for several of our clients is an Adept Add On available here

http://www.adeptcom.co.uk/tools.htm

Hope this is useful.

Sage and Amazon

Alistair Hindmarsh | | Permalink

Becuase there are so many different ways of connecting from a Web Site to Sage, you cannot really have an 'out of the box' product. Each one needs to be tailored somewhat. Most of the time there are 3 distinct parts - the web info, the 'bit inbetween', and sage 50. Basically the 'bit inbetween' communicates the data between the Web site and Sage.

Having said that  we've just developed a program to link between Sage and Amazon for Sage 200 and are currently working on a Sage 50 one - all you need to be is a Amazon Pro merchant....

 

cheers

 

Alistair

Alistairh@solutionsforaccounting.co.uk

 

 

Sage web integration

Anonymous | | Permalink

I have only one experience of web integration but it is so bad it is worth sharing...

The company I work for has a number of web storefronts that use a generic ecommerce engine to handle the "shopping and checkout" process.  This produces invoices for the customer and hands over to various payment handling services (like SagePay).   It is supposed to be integrated with Line50.

Issues:

There is no internal control over the transactions.  Sales are invoiced at one value (and paid for) then Sage creates an invoice for a different value.  So we spend our time constantly fiddling with Sage transactions trying to agree to the invoice the customer already has.  I'm not really interested in which system is to blame for this.  The point is a properly integrated system should be synchronised.  It shouldn't just be a one way dump of data. 

There is no feed of credit status to the web store, so customers on credit hold can just order off the web.

There is no synchronisation of products.  New products have to be manually added to the store.  Discontinued products have to be manually deleted. 

Stock status is not updated from Sage.  So customers regularly pay for stuff we can't supply and we have to process a credit and refund.

Pricing is not updated from Sage.

VAT rates are not updated from Sage.

And probably the biggest headache...there is no cross reference between the payment and the Sage invoice.  We receive an aggregated sum in the bank each day.  The payment service can tell us what this is made up of in terms of cardholder name but we have no way of matching this to the invoice in Sage.  Quite often the card holder and customer aren't even the same.

From my few enquiries of other companies that do this, it is not an uncommon problem.  You just have to get used to regular write offs of unreconcilable transactions.

If I was a business owner looking for a Sage integration solution I would be very cautious.   It is easy to be duped into thinking you are getting more than is actually delivered.  Make sure you get references and follow them up to see how customers are using it.  Then make sure the same process works for your business.

 

 

 

 

 

on-line products

mayfair2 | | Permalink

I have a client who is successfully using Tradebox and seems to have had little difficulty

Importing and exporting of website transactions

chrisharding | | Permalink

In many cases I meet with people who do wish to import orders from their website, but they also want to enahnce how they fulfil these orders.

You may also want to consider whether any middleware is able to run checks on the data being imported, such as whether the customer already has an account, is there sufficient stock to fulfil the order, and do you want to export your stock levels back out to your website.

As a Sage developer we have worked with over 500 clients, many of which trade via a website, some of which have numerous across different platforms.

For this reason I would say that an out of the box solution could work for you, but I would also suggest that you look at the biiger picture.

We have customers trading on the internet to both consumers and trade, so they need to be able to publish customer specific pricing which many systems are not able to do.

 

Decide what you require ...

JC | | Permalink

Probably the first step is to address precisely what your needs are

  • is it a one way process of dumping all sales from your site into a file (csv or other) for upload into Sage
  • a more complex approach of having 'two way' traffic as per anon posting (i.e. customer on hold, updating prices etc..)

If it is the first option then Sage (old versions) has/d the facilities to upload csv files. Here is the simple VB code to build the export line in csv format for a sale - you can either take a transaction by transaction approach or accumulate all transactions for a specific date.

Note: this is quite old Sage V8 and they may have changed some of the csv import fields - but it does give the jist of it

Once you have built the export file simply use the Sage import option and it will appear in Sage (by-passes the invoice section of Sage & hits ledgers)

    '------------------------------------------------------
    'initialise
    '------------------------------------------------------
    dTemp = Me.TransactionDate
   
    '------------------------------------------------------
    'TransactionType
    '------------------------------------------------------
    sOutputLine = CHR_QUOTE & Me.TransactionType & CHR_QUOTE & CSV_DELIMITER
   
    '------------------------------------------------------
    'AccountRef
    '------------------------------------------------------
    sOutputLine = sOutputLine & CHR_QUOTE & Me.AccountRef & CHR_QUOTE & CSV_DELIMITER
   
    '------------------------------------------------------
    'NominalCode
    '------------------------------------------------------
    sOutputLine = sOutputLine & CHR_QUOTE & Me.NominalCode & CHR_QUOTE & CSV_DELIMITER
 
    '------------------------------------------------------
    'Department
    '------------------------------------------------------
    sOutputLine = sOutputLine & Me.Department & CSV_DELIMITER
   
    '------------------------------------------------------
    'TransactionDate
    '------------------------------------------------------
    sOutputLine = sOutputLine & CHR_QUOTE & _
                    Format(Day(dTemp), "00") & "/" & _
                    Format(Month(dTemp), "00") & "/" & _
                    Format(Year(dTemp), "0000") & CHR_QUOTE & CSV_DELIMITER
                        
    '------------------------------------------------------
    'InvoiceNumber - limit to left 8 characters
    '------------------------------------------------------
    sOutputLine = sOutputLine & CHR_QUOTE & Left(Me.InvoiceNumber, 8) & CHR_QUOTE & CSV_DELIMITER
     
    '------------------------------------------------------
    'TransactionDetails
    '------------------------------------------------------
    sOutputLine = sOutputLine & CHR_QUOTE & Me.TransactionDetails & CHR_QUOTE & CSV_DELIMITER
   
    '------------------------------------------------------
    'NetAmount
    '------------------------------------------------------
    sOutputLine = sOutputLine & RoundTo2DP(Me.NetAmount) & CSV_DELIMITER
   
    '------------------------------------------------------
    'TaxCode sort out correct VAT code
    '------------------------------------------------------
    If Me.TaxAmount = 0 Then
        sOutputLine = sOutputLine & CHR_QUOTE & "T0" & CHR_QUOTE & CSV_DELIMITER
    Else
        sOutputLine = sOutputLine & CHR_QUOTE & "T1" & CHR_QUOTE & CSV_DELIMITER
    End If
   
    '------------------------------------------------------
    'TaxAmount
    '------------------------------------------------------
    sOutputLine = sOutputLine & RoundTo2DP(Me.TaxAmount) & CSV_DELIMITER
   
    '------------------------------------------------------
    'ExtraReference
    '------------------------------------------------------
    sOutputLine = sOutputLine & CHR_QUOTE & Me.ExtraReference & CHR_QUOTE & CSV_DELIMITER
   
    '------------------------------------------------------
    'user id
    '------------------------------------------------------
    sOutputLine = sOutputLine & CHR_QUOTE & Me.UserName & CHR_QUOTE

No copyright restriction - feel free to use any part if you need to

Add comment
Log in or register to post comments
Group: Sage 50 Accounts discussion group
An independent forum for Sage users to share ideas, tips and gripes