Sage Line 50 Zen export module

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

[Calljj]

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

[Calljj]

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

Can you expand on this

[modchipfitters.co.uk]

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

[fergusmacdonald]

Hey

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

Thanks.

BuyAKilt.com