Bista Solutions Releases eBay Integration Module With Odoo OpenERP

Odoo ERP with Ebay

Bista Solutions and Odoo announced the release of an ecommerce module which integrates eBay with Odoo OpenERP. The Odoo eBay connector was developed by Bista Solutions over a period of two years. Bista Solutions developed this connector while working with several leading eBay sellers. With the addition of this eBay connector, Odoo further consolidates its position as a leading open source web based ERP and a solid alternative to ERP such as NetSuite and SAP.

Key Benefits

  • A single, integrated business application that ties your business together across ecommerce, CRM, marketing, order management, inventory, manufacturing and accounting
  • A single system that merges your online and brick-and-mortar operations to manage your entire business in real time
  • Manage one or more web stores and conduct ecommerce in different countries, languages, currencies and channels

Some features of Odoo OpenERP eBay connector

  1. Product and order Import: Import all the products and orders from eBay into OpenERP.
  2. Inventory Sync: Synchronize your inventories and stock level on eBay stores from OpenERP.
  3. Update order status: Update status of your orders from OpenERP to eBay store with tracking number.
  4. List products to eBay from OpenERP: List all your product images, Catalogue search using different templates.
  5. Re List Products: Manage auctions including listing and relisting of your products with respect to the expired date and time.
  6. Product Schedule Management: Schedule listing of products based on your requirements.
  7. Product Status Update: Manage your products descriptions, images, attributes, title, etc. in OpenERP.
  8. Analytics: Receive advanced Business Intelligence for your eBay stores and combine them with information with other channels.
  9. High Volume Processing: Integrate with scanners and process batch printing of labels, picking & packing lists for processing large volumes of orders.

Bista Solutions is a leading OpenERP partner with many successful implementations in ecommerce and manufacturing. For information regarding implementing, integrating, customizing and migrating OpenERP please contact us on sales@BistaSolutions.com.

Click here to check video of eBay integration with OpenERP

About Bista Solutions:

Bista Solutions is a dynamic software company providing world-class business solutions to a wide range of enterprises. Bista Solutions has offices in US & Canada with a development center in India. The company has many years of expertise in analyzing the requirements of businesses and developing applications to meet their business needs.

About OpenERP:

OpenERP / Odoo is a complete web based ERP solution for Small and Midsized Enterprises, with more than 500+ modules available including CRM, BPM, etc. OpenERP also provides you with customizable reports, Dashboards and other utilities such as barcode tracking, inventory tracking, inventory management, fleet management, etc.

Bista Solutions
www.BistaSolutions.com

To know more about this you can watch our video below. If you would like to implement this for your business, please send us a message or give us a call at 404-631-6219 (full list of international numbers here).

How to create Ad-Hoc reports in Odoo

A number of times clients ask us whether OpenERP has the capability to make Adhoc reports. It is very important for the client to have access to information which has been entered into the ERP and view it from a particular perspective. The base_report_creator module can be used to create powerful Adhoc reports, though it requires some level of technical expertise from the user to create the report – they should know the Object in the ERP, how they are interlinked and the fields etc.

The base_report_creator module which can be used for Adhoc reports
null

The new option called “Custom Reports” which is created by this module

Odoo ERP Software

Creating a new custom report by selecting the objects whose data need to be part of the report. Also a Menu option to access this custom report can be created from this page
ERP Software System

Specifying the fields which need to be displayed in the custom report and how to group them and whether to show them on the graph.
Open source ERP

The newly created custom report
ERP Software for Business

The report can also be shown as a Graph
Odoo ERP Software

How to generate Reports in Excel, Word & pdf format from Odoo

There are many companies or people who feel more comfortable with excel file format. Odoo (OpenERP) allows you to export the reports in Excel, word or pdf format/

Whenever we create the report in RML it just outputs in pdf. Hence further processing on the generated reports and the pdf version is just not enough.

There are 2 ways to generate report which can be exported to Excel / Word formats.
1. Using Jasper Reports
2. Using Aeroo Reports.

The advantage with Aeroo report is that it has a cool “Printscreen” functionality with which you can export any list view into Excel. Even the Analytic reports like “Sales Analysis”, “Leads Analysis” etc can be exported to Excel format. This is very powerful for the Clients, in case they want to run additional analysis using Excel Pivot tables.

The modules “report_aeroo”, “report_aeroo_ooo” and “report_aeroo_printscreen” are required for this functionality to work. Also it uses Open Office to generate the Excel/Word report, so OpenOffice has to be installed and running as a service for this to work.

This link has the details of how to install and setup OpenOffice as a service. I just had to run OpenOffice using the following command “/usr/lib/openoffice.org3/program/soffice “-accept=socket,host=localhost,port=8100;urp;StarOffice.ServiceManager” -nologo -headless -nofirststartwizard”

The following are the details of my /usr/bin/openerp-server
————————————-
#!/bin/sh
export PYTHONPATH=”/usr/lib/openoffice.org/basis3.1/program/” #change this to your OOo path!!!
cd /usr/lib/python2.6/site-packages/openerp-server
exec /usr/bin/python ./openerp-server.py $@
————————————-

See below from how the Aeroo Report, Printscreen report is configured. The reports which you define can also be setup to output in Excel by using a similar setting.

If you’re interested in implementing Odoo or have any questions, get in touch! You can reach us using our contact form or at sales@bistasolutions.com.

How to set up OpenERP for different Time Zones

How to set up OpenERP for various timezone kindly follow the following steps to select timezone in OpenERP:

How to set up OpenERP for different Time Zones
How to set up OpenERP for different Time Zones

Click on the “Edit Preferences” wheel at top right corner

How to set up OpenERP for different Time Zones
How to set up OpenERP for different Time Zones

Click on the “Preferences” tab

Select the timezone from drop down menu
How to set up OpenERP for different Time Zones

Select the timezone from Drop Down Menu

Following code will be working for “GMT-x” time zones. Mostly US based.

FMT = ”%Y-%m-%d %H:%M:%S” #Time Format
#########################Timezone Logic########################
timezone_time = self.pool.get(”res.users”).browse(cr,uid,uid).context_tz #Timezone selected in OpenERP
now_utc = datetime.now(timezone(”UTC”)) #fetching UTC time
now_utc1 = str(now_utc)[:19] #Truncating time only
now_tm = datetime.now() #system time
current_now = str(now_tm)[:19] #Truncating system time only
if timezone_time:
current_timezone = now_utc.astimezone(timezone(timezone_time)) #getting the time of selected timezone
current_timezone = str(current_timezone)[:19] #Truncating timezone time only
else:
current_timezone = current_now #Current time
###############################################################

#Difference between the UTC and Timezone time
UTC_timezn = datetime.strptime(now_utc1, FMT) – datetime.strptime(current_timezone, FMT)

#Difference between the Current and Timezone time
currnt_timezn = datetime.strptime(current_now, FMT) – datetime.strptime(current_timezone, FMT)

openerp_selected_tm = self.browse(cr,uid,ids[0]).last_ebay_order_import_date #getting user selected time from OpenERP

currentTimeFrom = datetime.strptime(openerp_selected_tm, FMT) – currnt_timezn #Subtracting the currnt_timezn from user selected time

Final_time = currentTimeFrom + UTC_timezn #Final time by adding UTC_timezn

How to use Average Price Formula in OpenERP

Below is the method of calculating the Average Pricing in OpenERP

Formula

NP = (AP * QS + PP * QP) / (QS + QP)

Example: NP = [AP(13.42)*QS(733)+PP(15)*QP(10)] / [QS(733)+QP(10)]

NP = 13.44

Abbreviations:

  • NP (New Price): New Average Price once product have been received in the warehouse.
  • AP (Average Price): Old Average Price before product received in the warehouse.
  • QS (Quantity Stock): Quantity stock before product received in the warehouse.
  • PP (Purchased Price): Purchase Price(Unit Price) in Purchase order.
  • QP (Quantity Purchased): New Quantity received in Purchase order.

How to Run OpenERP 6.1 on custom ports

To run OpenERP 6.1 simultaneously with our existing OpenERP installation, we need to specify different ports for XML-RPC. Here”s the Command to run OpenERP 6.1 from source with custom port option(Run this command from OpenERP6.1 source folder):

#su OpenERP -c “python OpenERP-server –xmlrpc-port 8089 –xmlrpcs-port 8091 –netrpc-port 8090″

Below image shows the port definition in Debug configuration of the eclipse!

open source ERP
OpenERP custom ports on eclipse

The Advantages of using Linux Operating system

Linux is one of the widely used Open source operating system assembled under the model of free and open source software development and distributions. Linux kernel and operating system first released on October 5 1991 by Linus Torvalds is one of the defining components of any Linux system.

There are different operating systems available which we use daily but here i will provide you with some of the best reasons where Linux installation on a machine is better as compare to other operating system specifically for those who are new to computer world.

1: Viruses/malware

Viruses and malware can attack your PC anytime and this is one of the most important reasons why you can select Linux. As on Linux operating system the concern of viruses attack become zero. Therefore purchasing of virus protection software cost is waived off after using Linux.

2: Security

Being Open source in nature Linux provide you with good security in your Operating system. Incase any virus released in Linux operating system you will get quick patches released either on the same day or next day. This normally doesn’t happen if you use any other operating system.

3: Cost effectiveness

Another reason for being open source is the cost effectiveness as other operating system requires licensing towards the installation. Say for eg: Microsoft licenses are only allowed on a single computer whereas Linux can be distributed to any number of computers without spending single penny.

4: Freedom

With Linux advantage you have freedom to control every part of your operating system. Again Linux provides you with freedom of licences and control over desktop look and feel.

To know more in details contact us today.

How CRM software can help your organization

Previously we have discussed that Customer relationship management (CRM) software or Lead management software is very important for an organization who is into either products or service selling. A lead management or client management is very necessary in today cut throat completion to make powerful client base for a business. A small business CRM can help in achieving this because it allows you to have customer information with the previous records of their activity in the CRM software which make quick and easy to access as and when required.

Again with the help of advance CRM software available where the communication can be shared in group for eg: A is constantly communicating keeping loop with B. negotiation with customer C and incase A is not available, B can handle the client easily which helps in customer relationship.

Today pace in selling or in business is necessary as keeping the customer on hold may loose customer interest, Henceforth with a use of customer relationship management software you can pace up your sales, lead management, customer management, marketing automation etc. With few clicks you get all the history of the customer you are looking out for wasting your time on going through papers and other stuff. If you have history of your customer purchase and transactions it becomes easy when re-ordering happens.

Hence with the above one can say CRM software can help in different sales and marketing areas of an organization. A CRM application is helpful not only organization/sales perspective but it can help the customer also which dealing with your organization.

Which is the best online platform for eCommerce vendors ?

The Zerynth Platform

eCommerce websites are becoming one of the most powerful mediums for online buying and selling of goods & Services. Many companies are now focussing on their online store as it allows them cost-effective and sell the products and services at low rates as compared to bearing the expenses of virtual stores. E-commerce vendors.

There are many platforms available that an eCommerce vendor can choose from, but there is no distrust that Magento is considered one of the most influential eCommerce platforms. The reason behind this is being Open source Magento is one of the strong e-commerce platforms available today. With the massive success of websites like Etsy and ThemeForest, multi-vendor eCommerce marketplaces have become a popular way to sell both physical and digital products. They provide an easy method for you to host third-party vendors. Customers are happy because they get to choose from a wide selection of products, and you’re happy because you get to charge vendors a commission. But because of the unique functionality multi-vendor marketplaces require, you need specialized software to be able to effectively run one. Another important advantage of using Magento is that it enables the store owner to install, run & customize it easily.

Magento eCommerce store allows you to have integration with the payment gateways, Analytics other extensions, etc. It also allows you with variety of themes from which you can choose the most suitable for your store and products.

Some of the powerful services offered by Magento are as follows

– Quick operation

– Easy integration with 3rd party tools

– Categories and Product management

– Shipping management, order management

– Customizations as per user requirements.

– Strong Open source community

– Other support services are available

Apart from the above one of the most important features is that Magento is having user friendly interface.

How Busniess Process Management can improve business performance

Busniess Process Management

 Business Process Management

We always learnt during our management studies “Doing right things at a right time” to ensure smoothness in business operations and this can be accomplish when you have a proper processes in place from different department. It also applies where you are ensuring to contact right person in your organization to get the work done on time.

Business Process Management – workflow management helps you to increase and the capability of each department. The Company can easily track different processes of their departments to track the work completion. It allows you to take necessary actions in terms of delays in the work from one department. Apart from that business process management tools helps every employee to complete their duties and task with the help of certain clicks.

Another advantage of a BPM tool is that the person who is initiating the case does not need to worry as it allows you with information through emails, sms on the task done by different department. It also allows the company to become global, say for example a product concept is created in one place and design done in another place and so on. Today BPM – Business process management is considered as one of the emerging technology to improve the efficiency of business. It includes component of workflow management, document management, business rules and ERP integrations.

Thus, work flow solution can help a company to improve its performance dramatically.