Sage Line 50 Zen export module

MikeyG:

Calljj,
I have just tried to import the stock transaction but get a fail on pass 2 due to insufficinet stock. As a business I can accept back orders so how might I get round this one.
MG

Once again, another Sage issue!

Sage has to be manually told to be able to accept negative stock, by default it won't allow it, hence if you've got something on backorder it wuill fail.

i think the setting for allow negative stock is under compnay prefernces menu.

Kind regards

James

Hello

Please could you advise me, I down loaded your module and have it working fine, but I have experienced another problem with my site, when any of the stock values go to zero, the sold out flag does not seem to be set and the products can still be purchased.

Please could you advise me if this might be related to teh download of this module.

Over the weekend I down load this module and also Google analytics, and notice that afterwards I sold an item that was not in stock,

Thank you

That could not be caused by this mod which simply dumps information from the database in a format that Sage (in theory at least) understands.

I would recommend checking your settings under Admin > Configuration > Stock

I will look into this as it could be a bug.
If you don't have the configuration--> "stock" option in your menus, go to your database in mysql and run following command lines AFTER MAKING A BACKUP OF ALL YOUR FILES- just in case:

insert into `configuration_group` values (9,'Stock','Stock configuration options',9,1)

insert into `configuration` values (230,'Stock Re-order level','STOCK_REORDER_LEVEL','1','Define when stock needs to be re-ordered',9,5,'2006-10-14 10:48:16','2006-10-12 00:11:11',NULL,NULL),(231,'Products status in Catalog when out of stock should be set to','SHOW_PRODUCTS_SOLD_OUT','0','Show Products when out of stock<br /><br />0= set product status to OFF<br />1= leave product status ON',9,10,NULL,'2006-10-12 00:11:11',NULL,'zen_cfg_select_option(array(\'0\', \'1\'), '),(232,'Show Sold Out Image in place of Add to Cart','SHOW_PRODUCTS_SOLD_OUT_IMAGE','1','Show Sold Out Image instead of Add to Cart Button<br /><br />0= off<br />1= on',9,11,NULL,'2006-10-12 00:11:11',NULL,'zen_cfg_select_option(array(\'0\', \'1\'), '),(233,'Product Quantity Decimals','QUANTITY_DECIMALS','0','Allow how many decimals on Quantity<br /><br />0= off',9,15,NULL,'2006-10-12 00:11:11',NULL,'zen_cfg_select_option(array(\'0\', \'1\', \'2\', \'3\'), '),(234,'Show Shopping Cart - Delete Checkboxes or Delete Button','SHOW_SHOPPING_CART_DELETE','3','Show on Shopping Cart Delete Button and/or Checkboxes<br /><br />1= Delete Button Only<br />2= Checkbox Only<br />3= Both Delete Button and Checkbox',9,20,NULL,'2006-10-12 00:11:11',NULL,'zen_cfg_select_option(array(\'1\', \'2\', \'3\'), '),(235,'Show Shopping Cart - Update Cart Button Location','SHOW_SHOPPING_CART_UPDATE','3','Show on Shopping Cart Update Cart Button Location as:<br /><br />1= Next to each Qty Box<br />2= Below all Products<br />3= Both Next to each Qty Box and Below all Products',9,22,NULL,'2006-10-12 00:11:11',NULL,'zen_cfg_select_option(array(\'1\', \'2\', \'3\'), ');

Thank you very much

this worked well.

I other small point, I have 5 entries under configuration titled "sage configuration", Is there a way in whic I could tidy this up? 4 of them are empty and 1 is working correctly.

Thank you

Mike

seems like a good mod but i have a problem
finally got it so it would create the csv files without reporting any errors

problem i have is when i view the csv file for orders it only has 27 records in it and we have over 7000 orders

simular thing happens for the stock it only shows 24 items and we have about 300 products on our site

any idea's???

If its exporting, then its just a case setting the parameters correctly.
I would check the start date to ensure that is correct and as early as you need it.
Also check the max number of the setting for order status. I.e order status 4 is "complete", therfore set setting to 4.

Any more probs, please feel free to pm me and we can look at your database a little more indepth.

Kind regards

J

modchipfitters.co.uk:

finally got it so it would create the csv files without reporting any errors

Can you expand on this

Calljj:

Can you expand on this

to start with i was getting eorrors when creating the csv files but this was down to us having a database prefix

now when i tell it to create the csv file it does as its told and i can download them

Hey

Can anyone confirm if this module works with Sage 50 Accounts 2008 version.

Thanks.

BuyAKilt.com

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

kind regards

James

Hey James,

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

Thanks,
Fergus

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

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

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

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.

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

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

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

Hi there,

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

Thanks

Shane

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

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

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.