Sage Line 50 Zen export module

Hi,

Just installed this addon but am getting the following error:

ERROR: yes is not a valid feed template

I have the Wordpress on Zencart addon installed with Wordpress as a subdirectory of Zencart so i think the problem is related.

Any help on how to solve this would be much appreciated.

looks like a few people are using this with no problems , so that makes me think my problem is not to do with this mod but my set up , But I would appreciate some input.

When I create the Transaction file all the orders export but the figures are a little screwy !

Any orders that do not reach the free shipping cut off ( 29.00 ) seem to be wrong and I can not figure out where the figure is coming from.

i.e on the invoice

Order
Sub-Total: £14.48
Next Day Courier: £4.95
VAT: £2.90
Total: £19.43

but on the sage export the same order shows as

16.04 T1 2.81

I have set up my shipping to be 4.21 and include shipping tax to make it 4.95 , so to me the figures look correct on the invoice
i.e VAT = 0.74 for the shipping and £2.16 for the goods so £2.90
so the net total should be £16.53 ?

Am I barking up the wrong tree ?

Thanks for any input.

MARK

Hi,

I am having a problem using this module. I get a 'page not found' and, in the address bar is: http://www.handcrafteduk.com/sage.php?feed=yes&upload=no

Should this be the correct page that is trying to be accessed? Which file do I need to check for errors?

Any help appreciated.

Many thanks,

Gary

Sounds like you haven't uploaded the sage.php file to your root directory?

I have just installed themodule and run the sql file however there is no option in admin \toolls for sage so as to run the module.
Can you help please.

Stephen
http://www.jbconline.co.uk

Check you've uploaded all the files correctly

I have reinstalled the files twice but still running to the same problem.
Which file is needed for me to run the module under the Tools menu. I am guessing a file has not uploaded correctly.

Stephen

http://www.jbconline.co.uk

Sage file started 2009/03/01 18:11:27
Data file - /home/walsheit/public_html/trendsupplies.ie/sage/sage_stock_transaction.csv
Data file - /home/walsheit/public_html/trendsupplies.ie/sage/sage_sales_transaction.csv
1146 Table 'walsheit_zc1.sage_update' doesn't exist
in:
[SELECT * FROM sage_update ]

I am getting this error for the stock page, and a blank error for the other sage code, any ideas what might be causing this?

I have installed the latest 1.0 version on this site.

Sounds like you need to run the sql file to update your database

boomerie:

Sage file started 2009/03/01 18:11:27
Data file - /home/walsheit/public_html/trendsupplies.ie/sage/sage_stock_transaction.csv
Data file - /home/walsheit/public_html/trendsupplies.ie/sage/sage_sales_transaction.csv
1146 Table 'walsheit_zc1.sage_update' doesn't exist
in:
[SELECT * FROM sage_update ]

I am getting this error for the stock page, and a blank error for the other sage code, any ideas what might be causing this?

I have installed the latest 1.0 version on this site.

stecrox:

I have reinstalled the files twice but still running to the same problem.
Which file is needed for me to run the module under the Tools menu. I am guessing a file has not uploaded correctly.

Stephen

http://www.jbconline.co.uk

Think it is admin/includes/boxes/extraboxes

Calljj:

Sounds like you need to run the sql file to update your database

When you say run, do you mean the install SQL under tools or another kind of run?

Calljj:

Sounds like you need to run the sql file to update your database

i'm having the same fault and i have run the sql file.... if you would like versions and files then please ask.

cheers

john

ckysky:

i'm having the same fault and i have run the sql file.... if you would like versions and files then please ask.

cheers

john

from the tools exporter....

1146 Table 'ickysky_zc1.sage_update' doesn't exist
in:
[SELECT * FROM sage_update ]

i think the problem is that the table is called zen_sage_update (when i go into phpmyadmin)

could this be it?

cheers

john

[QUOTE=HandcraftedUK;685662]Hi,

I am having a problem using this module. I get a 'page not found' and, in the address bar is: http://www.handcrafteduk.com/sage.php?feed=yes&upload=no

Hi
I've got this same problem - it all looks to be working fine until i click on the work 'Here' to generate the report - i get a http 500 error with the address bar giving this same "../sage.php?feed=yes&upload=no" message.
I've reinstalled all the files several times (normally, and individually) but just get the same issue.
Did you get a solution for this?
if not, I notice someone mention 'Wordpress on Zencart' - could this be the issue? or could it be 'Super Orders'
many thanks
Ben

[QUOTE=benmckechnie;725399]> HandcraftedUK:

Hi,

I am having a problem using this module. I get a 'page not found' and, in the address bar is: http://www.handcrafteduk.com/sage.php?feed=yes&upload=no

Hi
I've got this same problem - it all looks to be working fine until i click on the work 'Here' to generate the report - i get a http 500 error with the address bar giving this same "../sage.php?feed=yes&upload=no" message.
I've reinstalled all the files several times (normally, and individually) but just get the same issue.
Did you get a solution for this?
if not, I notice someone mention 'Wordpress on Zencart' - could this be the issue? or could it be 'Super Orders'
many thanks
Ben
OK, i've removed 'Wordpress on Zencart' and this has solved the problem - if anyone else has this issue.
BUT...i now get an error message saying that sage_update table is not found in the database - this is obviously because i have a prefix, but which files do i need to alter to put this right?

[QUOTE=benmckechnie;725419]> benmckechnie:

OK, i've removed 'Wordpress on Zencart' and this has solved the problem - if anyone else has this issue.
BUT...i now get an error message saying that sage_update table is not found in the database - this is obviously because i have a prefix, but which files do i need to alter to put this right?
Right...answered my own question again - its just two instances of 'sage_update' in the root directory file 'sage.php'.
Working now!!! Thanks

Excellent Mod. Belated thanks, I know it's been around for a while. I'm not really sure if this mod is stillbeing supported but I've been testing it against 1.38a and with some of the manual edits detailed in this thread it seems to be working ok.

If anyone is using it, I did find one bug with the addition of postage costs. The script finds the total postage price, counts the "different" products in each order and then at a later stage divides the total postage price by the number of products in the order.

The problem I found is with having more than 1 of the same product. It doesn't take this into account in the postage calculation(ref Line 144):
$count=$count+1;

This means that if you have 2 of the same product the overall count is only increased by 1. The result is that you'll have additional postage costs in your net total.

I've changed line 144 to:
$count=$count+($Orderedproduct->fields['products_quantity']);

and this seems to cater for this. Not sure if there are any other impacts of making this change yet, but If you're suffering from order total mismatches. Take a look.

Good to hear people are still using.
If you notice a little bug like this, please feel free to repackage and submit to downloads area, so that the next person gets the best possible solution.

Kind Regards

James

Hi,
Nice mod, thank you very much, I'm hoping it's going to be very useful to me in the future.

I've managed to get Sage configured, so it accepts the files the mod produces, which is great. I was disconcerted to see that the apparent sale prices of stock items varied with each order, until I realised it was because shipping was being spread across the products in each order.

Can you tell me please, why does the mod do this? And can I stop it? I need postage costs separately itemised, so I can account for them properly.

Thanks again, I look forward to hearing from you,
Sean

You would have to recode adding the postage nominal code (typically 7501) so that every order that is processed also writes a line to assign the postage cost to the postage nominal code.