Sage Line 50 Zen export module

[Calljj]

If anyone is interested i have written a module for Zen to export the Audit Trail tranasction files (sales finances), the Stock Transaction files (sales stock) and the Stock Records file (product records to populate the products into Sage).

If there is interest i will submit for addition to the downloads area.

James

www.janetsystems.com

[kuroi]

I would be interested in this. Please go ahead and submit it to the downloads section.

[Calljj]

Now available to download!

As i've written in the notes, i wrote this to fulfill my needs, not the masses, but will provide a great easy starting point to go from.

[brosville]

downloaded and installed the "stock" version - no problems, works beautifully, but the "orders" version appears to have an error in the sql file - all I get is error messages. Also, are the two designed to work together? (as there will then be two files named "sage.php"

[brosville]

can't find the "alter post" button - please disregard the "2 versions of sage.php" line - I was looking into the wrong folder!

[Calljj]

Hi, Can you post a line of the error and i'll look into it.

I suspect its the addition of the new table Sage_update and the intitial value.

Thanks for the feedback
J

[MikeyG]

Calljj

This is very exciting thank you. I have failled to get QBI to work (I am in the UK and it only works on the US versions) I have yet to make a decision re accounts packages as I have been looking for a link like this.

Couple of questions while I wait for a trial version of sage to be sent through from them. Can it deal with stock attributes. Typically I sell Baby vests, t-shirts etc in different colours and ages so can have upto 2 or 3 attributes for a product. I am assuming this is put into one sku in sage. Does it map these out.

Second question is managing stock. Can you input stock back to Zencart once a purchase order has been raised in sage stock has arrived and booked into sage can this then update Zencart? - I can see issue here with the attributes and mapping stock back into Zencart.

Many thanks in advance.

MG

[Calljj]

First thing you need to look at is Sage. Unfortunately within sage,each product has its own specific product id. i.e a large vest would be id 124, a small vest 123. This makes it really tricky if using stock attributes in Zen with a Sage system, because it is still one product id within Zen, i.e both small and large vests come under "vests" with a product id of 125...

Second thing you need to decide is which program are you going to use for the stock management levels...sage or zen?

I sell a number of different value goods from T-shirts at 17.50 to expensive items around the 1K mark. So, all i did was split out the different attributes into individual products for the the more expensive items on the website, as I don't really need to know whether i have 2 medium and 2 large t-shirts in stock at the same price, i just need to know that i have 4 total t-shirts in stock worth £££ for the accounts. T-shirts are still sold as attributes on my website so that tells me how many i have instock, and then the Sage tells me i have a total ammount of t-shirts worth £££ in stock which is fine for the financial side.

For the update from Sage back to website, again, you need to decide what products to split and what to keep with attributes before doing this. I have written a one button software that runs from your desktop (a proper program rather than a zen module) that does all the above and uploads that data back from sage to web. james ' @ ' janetsystems.com for more info on that.

As i said, I wrote the module for my own needs, so it is more suited to UK with use of VAT and exporting e.t.c. But could make some changes if people have ideas.

J

www.janetsystems.com

[MikeyG]

Caljj

Thank you for the info. I have just tried to run the orders module and I get


1054 Unknown column 'SAGE_STATUS' in 'where clause'
in:
[SELECT * FROM fmorders WHERE orders_status <= SAGE_STATUS AND date_purchased >= 'SAGE_STARTSDATE 00:00:01' AND date_purchased <= 'SAGE_ENDSDATE 23:59:59' ORDER BY orders_id ASC]

What might cause this. I cannot see sage_status anywhere.

Thanks

MG

[Calljj]

Hi,

Oops, yes can see why that would happen, I seem to have encountered a copy paste error when producing the install sql script so that none of the configuration data is there...

I'll upload what it is supposed to be later today.
Apologies.

J