Sage Line 50 Zen export module

[MikeyG]

Calljj,

Thanks for your reply. It is the stock module and I understand now having had a demo this morning from sage that yes you would not take stock in here.

However I am wonder if you could just explain / expand on the transaction import please:

I am getting an error of field 2: Invalid Bank Account

I clearly don't understand the account set up and account types in sage yet. Is it possible just to explain how the 2 files work to gether in the sage export (sales) module.

I have obviously missed something somwhere in my set up.

Thanks once again

MG

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


Apologies if again I have missed the point here, but a good testing ground I hope from a complete novice trying to use it.

Thanks

MG

[Calljj]

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

[u761877]

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

[kuroi]

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

[Calljj]

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\'), ');

[u761877]

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

[modchipfitters.co.uk]

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???

[stecrox]

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

[Calljj]

Check you've uploaded all the files correctly