This is an ongoing project to integrate any Django project with Quickbooks Desktop and Quickbooks Online. Quickbooks integration support for Python 3.6+ and Django 2.0+
| Version: | 0.6.4.2 |
|---|---|
| Download: | https://pypi.org/project/django-quickbooks/ |
| Source: | https://github.com/weltlink/django-quickbooks/ |
| Keywords: | quickbooks,quickbooks-django,django,quickbooks-desktop,quickbooks-online,qb,qbwc,qwc,integration,django-quickbooks |
...
Soap server for Quickbooks Web Connector is built on top of Spyne and Lxml.
Installation from pypi:
pip install django-quickbooksOR
Installation from source (github):
pip install -e git+https://github.com/weltlink/django-quickbooks.git@master#egg=django-quickbooksYou can run pip install django-quickbooks pika spyne celery redis to install all of the dependencies.
Run migrations: manage.py makemigrations , manage.py migrate
You should create a new realm for each of your users.
We will do that from the django shell.
Execute the command manage.py shell and follow these instructions:
from django_quickbooks.models import Realm
realm = Realm(name='TEST NAME', is_active=True, schema_name='default')
realm.set_password('RAW PASSWORD')
# django-quickbooks hashes the raw password and only store the hash similar to what django user do.
# this password is what the user will be using in QBWC
realm.save()You should automate the previous steps in your code to create a new realm for each user of yours
If you want to communicate with QBPOS instead of QB Desktop you should edit the settings.py file in django-quickbooks itself, Go to setting.py and change
QB_TYPE = 'QBPOS'instead of'QBFS'inDEFAULTSdict. this will be changed to a better approach later.
Download QBWC from [http://marketplace.intuit.com/webconnector].
Make sure to use the compatible QBWC versions with your QB Desktop or QB POS version, Note that latest != compatible, you may need an older version to work with your QB solution.
Now we need to create a qwc file
manage.py create_qwc choose a realm and walk through the steps, copy the output to a .txt file and change the extension to .qwc
open your QB or QB POS company file
double click the .qwc file, give permission to QBWC to access your company file
enter the realm password for this user
You need to install RabbitMQ (if you want to use default QueueManager) which is a widely known message broker. However, RabbitMQ implementation of QueueManager is being deprecated as it could not be implemented in the right way to keep robust connection, instead it is recommended to use Redis. You can find instructions on how to install RabbitMQ here.
You can also install Redis (as an alternative to RabbitMQ implementation of QueueManager) which is a widely known as in-memory data structure. You can find instructions on how to install Redis here.
Add django_quickbooks to your installed apps in settings.py.
Add the following line to urlspatterns list inside urls.py:
path(r'^qwc/', include("django_quickbooks.urls"))
Inherit the QBDModelMixin to the model that you want to sync with QB or QBPOS.
Make sure to add and implement these 2 methods: to_qbd_obj() and from_qbd_obj() inside your model, so that django_quickbooks can communicate with your project model
from django_quickbooks.models import QBDModelMixin
# This is just an example, you should have your own fields
class Customer(models.Model, QBDModelMixin):
first_name = models.CharField(max_length=255, null=True)
last_name = models.CharField(max_length=255, null=True)
email = models.CharField(max_length=255, blank=True, null=True)
phone = models.CharField(max_length=10)
street = models.CharField(max_length=255, blank=True, null=True)
zip = models.CharField(max_length=255, blank=True, null=True)
city = models.CharField(max_length=255, blank=True, null=True)
state = models.CharField(max_length=255, blank=True, null=True)
def __str__(self):
return f'{self.first_name} {self.last_name}'
def to_qbd_obj(self, **fields):
from django_quickbooks.objects import Customer as QBCustomer
# map your fields to the qbd_obj fields
return QBCustomer(Name=self.__str__(),
IsActive=True,
Phone=self.phone,
)
@classmethod
def from_qbd_obj(cls, qbd_obj):
# map qbd_obj fields to your model fields
return cls(
first_name=qbd_obj.Name,
phone=qbd_obj.Phone,
qbd_object_id=qbd_obj.ListID,
qbd_object_version=qbd_obj.EditSequence
)We are almost finished, add a signal handler for the desired events i.e. post_save, post_delete, etc
from django.db.models.signals import pre_delete, post_save
@receiver(post_save, sender=Customer)
def send_customer_to_qbtask(sender, instance, **kwargs):
QBDTask.objects.create(qb_operation=QUICKBOOKS_ENUMS.OPP_ADD,
qb_resource=QUICKBOOKS_ENUMS.RESOURCE_CUSTOMER,
object_id=instance.id,
content_type=ContentType.objects.get_for_model(instance),
realm_id="YOUR REALM ID"
)You can use any method you would like to create a record in QBDTask, make sure to populate all these fields correctly.
Check out our smaller-roadmap or larger-roadmap to see on what you can help us to improve. Or if you have any problem just drop us a line or open an issue and we’ll work out how to handle it.
This library could not be possible without contributions from other open-source projects. Thanks for quickbooks-php for giving the concept of creating quickbooks toolkit. Thanks for Django_to_QuickBooks_API and pyqwc for giving core realization of soap server which made this library possible.