Sage Line 50 Zen export module

[Calljj]

Can't confirm, however if you have 2008 version please pm me and I can most likely make changes for you.

kind regards

James

[fergusmacdonald]

Hey James,

OK great thanks. I'm waiting on the disc so will PM you if i get any troubles.

Thanks,
Fergus

[jamie2k]

Hi James :) nice mod by the way...

I have installed the mod and get exports ok:)

I am interested, and have emailed you, reference the bespoke app for upload and download etc ...


I also have an issue:-

When looking at sales.csv file

I get codes 1250 as i have setup in config - this is correct for Paypal / credit cards

I get 999 instead of 1200 for cheque / money order - this is not correct and does not agree with my config, which is set as 1200 (this i wil need to change as this nominal code is for bank account in my sage)

Can you advise on this please.?

Also i would like to be able to assign new codes for different payment methods... is this something you can advise on or point me in the right direction with files / code etc ???

Kind regards and thanks in advance,

Jamie 2K

[jamie2k]

just a little addition to my last post...

Can you explain the import process you use, as the file i have is not importing correctly when run against a customer record import.

regards

Jamie 2K

[Calljj]

Hi James :) nice mod by the way...

I have installed the mod and get exports ok:)

I am interested, and have emailed you, reference the bespoke app for upload and download etc ...


I also have an issue:-

When looking at sales.csv file

I get codes 1250 as i have setup in config - this is correct for Paypal / credit cards

I get 999 instead of 1200 for cheque / money order - this is not correct and does not agree with my config, which is set as 1200 (this i wil need to change as this nominal code is for bank account in my sage)

Can you advise on this please.?

Also i would like to be able to assign new codes for different payment methods... is this something you can advise on or point me in the right direction with files / code etc ???

Kind regards and thanks in advance,

Jamie 2K

Hi Jamie,

Haven't got your email, perhaps send again? Software makes life much easier and can be used directly from your desktop, so no need for accounts people to have to go onto your site.

999 means that a code hasn't been specified for that particular transaction type, check your settings again, if still probs i can have a look further.

Yep you can add new codes for different payament types, look in the sage.php file around line 290, should have the following code

############################################### identify payment type

$paytype=$orders->fields['payment_method'];

switch ($paytype) {
case "Paypal IPN":
    $purchacc = SAGE_PAYPAL;
    break;
case "Paypal":
    $purchacc = SAGE_PAYPAL;
    break;
case "Credit Card":
  $purchacc = SAGE_PAYPAL;
    break;
case "Credit Card / Paypal":
  $purchacc = SAGE_PAYPAL;
    break;
case "Credit Card/ Paypal":
  $purchacc = SAGE_PAYPAL;
    break;
case "Cheque/Money Order":
  $purchacc = SAGE_CHEQ;
    break;
default: 
$purchacc = 999;
}

Each of the case types above in the speech marks is case and character sensitive, so be care to include it EXACTLY how it is on your setup, spaces and all!

To add more case statements for each of your types.
i.e if you have a payment type "apples", and code in sage is 1205 then add

 case "apples":
   $purchacc = 1205;
     break;

before the line

 default: 
 $purchacc = 999;

Hope that helps.

just a little addition to my last post...

Can you explain the import process you use, as the file i have is not importing correctly when run against a customer record import.

regards

Jamie 2K

If you're just doing sales, then import as "audit trail transaction" file in sage
If doing stock then it is "stock transactions"

Kind regards

James

[claschy]

Hi James

Thanks for creating this, I have one problem tho - after I have installed the two mods - the configuration files are blank?

I can see the heading and a table with Title, Value & Action, but nothing underneath? Any ideas why this would be happening?

I have tried uninstalling and reinstalling, but no luck.

Thanks

Claire

[knighs2]

Hi there,

Just a quick question before i install this, does it update stock levels ?

Thanks

Shane

[kuroi]

It's an export, so it doesn't update anything. Rather it creates a file that you can import into Sage.

[knighs2]

I understand that, what im asking is if it exports stock levels, ie stock qty from zen cart. So on import it updates the stock levels in sage ?

Thanks

Shane

[kuroi]

If you use "Sage Line 50 Integration - Stock" then yes, it exports stock levels, with the intention of replacing whatever values you have in your Sage Line 50 database.