Vtiger Accounting Integration Version 2.0 Released!

0 comments

We have previously covered the Vtiger Accounting Integration in our previous post at http://www.anterp.com/blog/?p=192. We are now reach another milestone that our Data Sync Suite version 2.0 are now ready for production. We have enhance and improve the performance of vtiger accounting synchronization and also simplify the ease of installation process. Our new Data Sync Suite 2.0 mainly focus on E-Commerce, Accounting and Vtiger CRM. We support more Operating System like Redhat/CentOS 5.5 / 5.6 / 5.7 & 6.2, Ubuntu 10.04 (BETA) as well as others Linux Distributors. In future, we will also support Windows Server.

This version support dynamically load all initial data and also support synchronizing user roles from FrontAccounting and Vtiger. The ease of use menu will be provider for System Administrator to simplify the process of new users registration for internal staff. Assigning user roles based on the data retrieving from FrontAccounting and Vtiger via REST API. You can manage your new staff registration and also your staff who are leaving your company with just a single mouse click. This feature will only supported in OpenLDAP edition.

Let us have an overview of the new Data Sync Suites version 2.0

Data Sync Suites Version 2.0 Lite Version 2.0 OpenLDAP Version 2.0
Open Source E-Commerce FrontAccounting Data Sync Features list
Customers Account Sync 1-ways 1-ways
Customers Contact Sync 1-ways 1-ways
Categories Sync 1-ways 1-ways
Products Sync 1-ways 1-ways
Sales Invoice Sync 1-ways 1-ways
Products Price & Quantity Sync (From FA Back to E-Commerce) 1-ways 1-ways
FrontAccounting Vtiger Data Sync Features list
Customers Account Sync 2-ways 2-ways
Customers Contact Sync 2-ways 2-ways
Vendors Account Sync 2-ways 2-ways
Vendors Contact Sync 2-ways 2-ways
Products Category Sync 2-ways 2-ways
Services Category Sync 2-ways 2-ways
Products Sync 2-ways 2-ways
Services Sync 2-ways 2-ways
Purchase Orders Sync 2-ways 2-ways
Sales Invoice Sync 2-ways 2-ways
Price Sync (From FA to vtiger) 1-ways 1-ways
Multi-currency Support Sync Yes Yes
Product Attribute Support (Custom Field) Yes Yes
User Provisiong (From AntERP to others system) No Yes
Single Sign On (SSO) No  Yes
Parameters Data Sync
Quotation Statuses Yes Yes
Sales Orders Statuses Yes Yes
Sales Invoice Statuses Yes Yes
Purchase Orders Statuses Yes Yes
GL Account Yes Yes
User Roles Yes Yes

Screenshot

single sign on user management

vtiger control panel

vtiger acconting integration data sync settings

Click here to download our Data Sync Suites Version 2.0 User Guide.

PrestaShop FrontAccounting Integration

0 comments

We have added another Open Source E-commerce FrontAccounting Suites supporting for PrestaShop Open Source E-Commerce Software version 1.4.4.0 – 1.4.4.1. PrestaShop have been widely used globally. We have automate PrestaShop FrontAccounting Integration by syncing the data between the 2 system. We have covers the area for Categories, Products, Customers, Contacts, Sales Order and Invoices. By using this PrestaShop “Plugin‘ tool, it solve the problems for manually process:

1) No more Import/Export CSV file. Our tool will automatically synced the data from PrestaShop into FrontAccounting.
2) No more copy & paste your customer, contact, categories, products, orders & etc from PrestaShop to frontaccounting.
3) No duplicate data entry. Our tool will automatically mapping the data and performing data synchronization process.

Prestashop Frontaccounting Integration

All process will be running at back-end process using batch process (cronjob). This tool perform data synchronization mainly from PrestaShop to FrontAccounting with the status below:

1-ways synchronization from PrestaShop to FrontAccounting for the action below:
a) Customers.
b) Contacts
c) Categories
d) Products
e) Sales Orders

1-ways synchronization from FrontAccounting to PrestaShop for the action below:
a) Stock Status (price, quantity)

2-ways synchronization from both FrontAccounting and PrestaShop for the action below:
a) Sales Invoice (status update)

This tool support PrestaShop version 1.4.4.0 – 1.4.4.1 with FrontAccounting software support version 2.3.5 / 2.3.6 / 2.3.7.

To learn more about this tool, please visit PrestaShop FrontAccounting Integration.

How to Use Prestashop WebService API

2 comments

With the growing communities in Open Source Prestashop E-Commerce Applications, 3rd party integration become one of the key elements. Thanks to the Prestashop communities to provide an excellent REST API Webservices. Let us discuss about how to setup and use Prestashop webservice for 3rd party integration.

Please refer to the Prestashop Web Services at http://doc.prestashop.com/display/PS14/Using+the+REST+webservice

How to Enabled REST API WebServices in Prestashop

First we are going to create an access to the web service. To do this, simply go to your Back Office and click on the tab “Tools -> Web Service“.

Prestashop Webservice Configuration

Click  “Enable Web Service” and click “Save” button to activate the webservice.

Now, go to “Tool -> Generators” to generate .htaccess file

Prestashop Generate Htaccess

Click on the “Generate .htaccess file” button

Now, go back to “Tools -> Web Service“.

Prestashop Webservice Account

There are 4 type of access rights in Prestashop Web Services – CRUD.

1. Create – allow 3rd party to create a new record.
2. Retrieve – allow 3rd party to read record.
3. Update – allow 3rd party to update existing record.
4. Delete – allow 3rd party to delete existing record.

Beware when you grant your  webservice access rights to the public. The good think is you can defined your access rights. For example, if you grant the access right to “View” only, the 3rd party cannot modified or delete your records.

In this example, we have also test on the access rights and it work extremely well. Basically, we grant all the access rights when performing the test. After that, we remove some access right and re-test again. It work pretty well. You might want to test it yourself.

Prestashop Webservice Account Access Rights

Let us start our test below:

1. How to Create customer record via Prestashop WebService

https://www.anterp.com/api/Create.php

Click on the “Create” button now

Prestashop Webservice Customer Form

You need to fill in all the information and click “Create” button to save the data.

NOTE:
The secure_key and password are encrypted. You may use the information below to test it.

Please leave the “id” and “ip_registration_newsletter” blank. Do not fill in anything.

id: blank
id_default_group: 1
newsletter_date_add: 2011-09-02 16:53:48
ip_registration_newsletter: blank
last_passwd_gen:  2011-09-02 16:53:48
Secure Key: 8bdf9acf8dd383f8a39da2af05acdeb8
deleted: 0
Passwd: 8dd6d14623b3ae325d0fe99036666785
lastname: Your Last Name
firstname: Your Firstname
email: Your Email Address
note: Anything
id_gender: 0 / 1
birthday: 1975-02-21
newsletter: 1
optin: 1
active: 1
is_guest: 0

2. How to Retrieve information via prestashop webservice

https://www.anterp.com/api/Retrieve.php

Click on the “Retrieve” hyper-link to retrieve the records

Prestashop Webservice Retrieving Record

3. How to Update Existing Record via prestashop webservice

https://www.anterp.com/api/Update.php

Click on the “Update” hyper-link to retrieve the records

Prestashop Webservice Update Record

Make some changes to the records and Click “Update” button to save the record

4. How to Delete Existing Record via prestashop webservice

https://www.anterp.com/api/Delete.php

Caution:

Please create your own data before deleted it.

Click on the “Delete” hyper-link to remove the records

Attached are the modified Prestashop API Source Code for this test example.

http://www.anterp.com/downloads/prestashopAPI-modified.zip

Hope you enjoy it.