Sage Line 50 Zen export module

[boomerie]

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?

[ckysky]

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

[benmckechnie]

[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.ph...=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

[benmckechnie]

[QUOTE=benmckechnie;725399]

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.ph...=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?

[benmckechnie]

[QUOTE=benmckechnie;725419]

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

[Hani]

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.

[Calljj]

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

[srt9969]

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

[Calljj]

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.