OpenERP is a powerful ERP solution and it manages all the processes in a company. We have developed a new module which enables us to manage the shipping through UPS World ship and UPS Freight from OpenERP. Using this module will be able to get rates for a particular shipment and we could also make the shipment request to UPS. The UPS responds with the UPS label which will be used on the shipment.
Touchscreen point of sale is one of the features of openerp, which enables to manage your shop (or multiple shop) very easily.Some of its advantages are,
It is completely web based.
It works in connected and disconnected modes so that you can continue to sell if you lose your internet connection.
Integrated with openerp, it uses openerp as its backend.
There are a number of options available for users and developers with the OpenERP GTK client for passing for passing default values and make the process of development and debugging easier. Here is an attempt to reveal some of the options available with the OpenERP client.
To list out all the available options just use the option '--help' as given below. It would list out the possible list of options.
Magento is a good platform for front end of your web shop and Open ERP acts as a perfect back office application supporting all the business processes required by a company.
Connector Features
You have published a great website.
It's nice article. Thanks for sharing your great details.
Is it also possible to import products from Magento to Openerp ?
Any news on this?
Is the connector working yet for version 7 of OpenERP together with Magento 1.7.0.1?
We have Magento connector available in OpenERP for version 7 . Please see the below link:-
http://www.teckzilla.net/blogs/item/112-openerp7-magento.html
From my small experience I have the feeling that the Drupal is mainly for developers. But one with high experience in non-Drupal PHP programing, will experience a starting trouble in Drupal development . They may complain that the drupal is complex because of the huge API. I have read some where a professional wrote : “Miss. Drupal, we are not born to study your API”. I admit that to a small extent. But is her API a monster?
Kindly contact me on my email address for Openerp 6 integration with Drupal for Customer pOrtal as soon as possible.
Here I am trying to give a full instant guide to Mysql commands that will help people for their easy usage.
To login (from unix shell) use -h only if needed.
# [mysql dir]/bin/mysql -h hostname -u username -ppassword
To login (from windows)
mysql dir/bin/mysql.exe -h hostname -u username -ppassword
Create a database.
mysql> create database [databasename];
List all databases on the server.
I could not resist commenting. Exceptionally well written!
create user query might have been much hassle free for a newbie to create user.
the mysqldump you mentioned will not dump stored procs in database. add --routines switch also to mysqldump command.
More Simple approach to create mysql users:
Login as root user.
mysql> create user username identified by 'pwd';
Hi Rohit,
Thank you for the comment. We have to add '--routines' command or use '-R' with the mysqldump for backing up stored procedures and functions if the 'routines' mysqldump parameter is not set as TRUE (By default it is False).
Expecting more tips like this from you thank you
To automatically make stock replenishment proposals, you can use minimum stock rules. To do this, use the menu Warehouse ‣ Configuration ‣ Automatic Procurements ‣ Minimum Stock Rules.
This does not seem to work in version 6.1, I put the settings correctly but no P.O is created. Do you have any clue? Thanks, Kareem.
The information you gave is very good. I was searching how to get the stock rules on Open ERP. You saved me a lot of time. Thanks. Now I will be able to complete my work soon. And Nice one I learned. _____________________________________________________________________________________________LEE CROUCHER
Hello,
Such good way written, Please post more and more blogs, even for small points too
(Tested on Win Xp and Win Server 2008. Should work on Win Xp, Vista, 7, 2008 …)
This is Just a help for those who are new to OpenERP. You can create as many OpenERP instances you like and can configure those as windows services.
1. Install OpenERP 6 all in one autoinstaller as normal.You can download it from OpenERP site http://www.openerp.com/downloads.
Hi , it is the same setup on a linux system?
Nice one, will share with all credits to you!
Thanks.
Hi Hestin,
Very useful and looking for this solution. Will try and see if we can create multiple instances. will touch base if experience any problems. Thank you very much for posting this. Have a great time.
Regards,
Espee
Can you do this same (similar) setup on a linux system?
Hello, work with OpenERP 5 + 6 ?
Thnx
WebDAV (Web-based Distributed Authoring and Versioning) is an open, published standard that allows you to edit documents on a remote web server.
WebDAV supports the following features:
Hi Sirs,
Just a little more help will be wellcome.
Which one is the path I have to configure for Documents??
Is a url (http://ip:8069/webdav), or is a directory in ubuntu /usr/lib/python2.7/...
Regards
testing OPENERP 7
I had been successfully connected with webdav as your provided instruction but problem is i am not able to see all partner folder when i access a Documents folder like 'http://localhost:8069/webdav//Documents/'
But when i access thought ftp then i am able to access all partners directory.
Could you help more for this part ?
The authentication in 6.0.2 server is wrong for users having a space between their login name.
can please be more specific i didn't get you
Hi Fahad, thanks for your response.
In OpenERP 7 when configure virtual folders, system is asking for a storage path. Is this path like type "/usr/lib/pymodules/python2.7/openerp/filestore/chinamirror" or is like "http://localhost8069/webdav/filestore/chinamirror"
I have been able to load files (as attachments) in storage like "/usr/lib/pymodules/python2.7/openerp/filestore/chinamirror" but haven´t been able to see in a browser.
I don't understand the right procedure and behavior of the software.
Sir..
I create the new document Management step by step...
Now I can't access the folder "Documents" by mounting the webdav folder
by using the url http://localhost:8069/webdav/aa11/Documents
DOMAIN.TLD: localhost
XMPRPC-PORT:8069/
DATABASE Name: aa11
Very nice to see this event management in this list. Soon the customer registration will be fetched in open ERP and an invoice will be generated for that in a particular registered in open ERP.
Can I get some more info here? Is this a better solution then using web services?
In Basic Installation a magento has one website, one store and one store view. Here it is used for creating a single shop website.
To setup multiple website stores in magento there are a few configuration changes to be done in the backend. Mentioned below are the instructions to be followed to create multiple website stores in magento.
Great tutorial. Thank you, however in Magento 1.7.0.2, the index.php is changed a bit, so Steps 11 to 13 have to be rewritten. These 3 steps copied from your tutorial are:
11.Change $compilerConfig = 'includes/config.php'; to $compilerConfig = '../includes/config.php';
12.Change $mageFilename = 'app/Mage.php'; to $mageFilename = '../app/Mage.php';
13.Change Mage::run(); to Mage::run('second','website') {Please refer Step 5};
In index.php, however, we now have the following corresponding lines:
define('MAGENTO_ROOT', getcwd());
$compilerConfig = MAGENTO_ROOT . '/includes/config.php';
and
$mageFilename = MAGENTO_ROOT . '/app/Mage.php';
and
/* Store or website code */
$mageRunCode = isset($_SERVER['MAGE_RUN_CODE']) ? $_SERVER['MAGE_RUN_CODE'] : '';
/* Run store or run website */
$mageRunType = isset($_SERVER['MAGE_RUN_TYPE']) ? $_SERVER['MAGE_RUN_TYPE'] : 'store';
Mage::run($mageRunCode, $mageRunType);
I am rather unsure of how to apply the modifications here! Could you kindly update the tutorial for the latest version of Magento please?
Thank you again.
I'm testing on windows 7 with wamp server.
I installed Magento 1.7.0.2
You need to change:
$compilerConfig = MAGENTO_ROOT . '/includes/config.php';
for
$compilerConfig = '../includes/config.php';
$mageFilename = MAGENTO_ROOT . '/app/Mage.php';
for
$mageFilename = '../app/Mage.php';
Mage::run($mageRunCode, $mageRunType);
for
Mage::run('second', 'website');
You can see this video. It's an old version, but only index.php is quite different:
http://www.magentocommerce.com/magento-on-the-fly/multiple-sites/
Thank You Very Much ......
This article is very helpful for me. I got success to create the multiple website.....
Having followed this information above, the second site does not work at all....
I will try and find correct information in relation to having dual sites.
thanks for the effort ... but if you are reading this look else where for info
cemmac
Hi Cemmac,
Sorry for the late reply. I would like to know whether "Managing Multiple website stores in Magento" issue was resolved. If not let me know with more details.
Thanks
Ajasin
I have followed following changes as you said. But css and js file takes current store path
Security is a major concern when any application is considered. As of OpenERP, security is an important factor and it is easy to provide security in modular basis.
Group-based Access Control
thanks a lot man :)
Valuable writter, Thank you for producing this outstanding post. I found it useful. Best regards !!
Great Buddy , thanks for sharing in intersting work.
Where can we download this
Where can we download this module?