Livezilla

Certified Partner and
PrestaShop Developer for:

Database Export V1.4

Database Export

We are happy to provide a one time free installation assistance and full support with the purchase of any module (does not include customization of the module, or integration with 3rd party modules.).

Additional installation assistance requests, such as module / prestashop upgrade or accidental file deletion, will require a fee:.
    - $25 for modules priced $0 - $99
    - $50for modules priced $100+
Related Products
Website Translator

Use Google or Bing Translate to create complete Prestashop translations of your site.

More Info...

US $100
 
Duplicate URL Redirect

Redirect all duplicate, deleted, invalid and non- SEO friendly URLs to the default Friendly URL.

More Info...

US $35
Private Shop

Hide your shop or prices from non-registered users (entire shop or selected pages). Ability to manually approve new registrations, or send a customer a verification link to activate their account.

More Info...

US $50
 
Prestashop Backup

Create complete or partial Prestashop Backup (Files & Database), saved on your server, sent by email, or saved on Amazon S3 Cloud server

More Info...

US $70
Mass Combination Editor

Save time by viewing, editing and deleting all Product Combination (Attributes) in one place. Update price impact, weight impact, reference, quantity and more from a single screen.

 


More Info...

US $75
 
Facebook Comments

Add Facebook Comments to each product page with easy comment and user tracking.

More Info...

US $50
US $100
1 License
Each module comes with a license to be used on 1 shop (development / test + live environment).

If you need to use the module on more than one shop (separate servers or multishop setup), you would need to purchase an additional license for each shop

We offer 20% discount when purchasing more than 1 license (which will be applied as soon as you add to cart).
More Info
 
Reviews 5
 
Change Log
Tested on Prestashop Version: 1.4, 1.5 & 1.6.x

The possibilities are unlimited: Create targeted email lists based on past purchases. Segment customers by location, age, gender or another demographics. Export your shop's order history for analysis. Download product data to provide to your partners or advertisers.

 

In other words, export any data available in any Prestashop database table for use in any number of valuable ways!

 

NEW: Compatible with PrestaShop 1.6

Links to Demo

Back End Demo: http://demo.presto-changeo(dot)com/databaseexport/a (replace "(dot)" with a ".")

Username: demo@presto-changeo.com

Password: 12demo34

Information and Features

Export your PrestaShop data to a CSV file for infinite data-mining opportunities. Combine data from various tables in Excel to create custom reports, to gain insight into customer shopping habits, to create targeted emails lists, or simply to analyize the day, month or year's numbers. 

Customers Export (Great for Email Marketing and Customer Segmentation) - Generate an email list for all customers who:

* Bought a certain Product/s and may be interested in accessories.
* Spent over a given Amount (or range) within a certain Date Range  and offer special rewards.
* Have a Birthday this month.
* Live in a certain Country / City / Zip code.
* Members of a Customer Group.


Products Export (Great for Statistics, Inventory and Charts) - Allows you to export your product list, filtered by:

* Product Name.
* Product ID.
* Product URL.
* Product Images (URLs)
* Manufacturer / Supplier.
* Price / Reduction.
* Quantity left in stock.
* Category name and more.


Orders Export (Great for Accounting, or combining with Customer Data to create a 360degree view of your customer's habits and tastes) - Generate a list of all the orders by any of the following filters (or a combination of them):

* Order ID Range
* Customer name / Email
* Total amount spent (range)
* Payment method used for checkout
* Current order status
* Date of the order (range)
* Number of items in the order (range)
* Tracking Number(s)
* Customer Shipping or Billing Address
* Shipping cost
* Taxes / Vouchers

Other Tables - Allows you to export any other PrestaShop database tables, linking them to the _lang table when available.

Custom Export - Allows you to enter your own customer SQL query.

Change Log

V1.0.1 (01/27/11)
Bug fix that was affecting some servers when saving the configuration settings.

 

V1.1 (03/16/11)

Address export for orders.
Custom SQL query option.
Support for PS 1.4.

 

V1.1.2 (05/24/11)
Fix for export of fields with a similar name (from different tables).
Fix for customer and order import when the first ID checkbox was not ticked.

 

V1.1.3 (06/13/11)
Added quantity of products per order in the order export.

 

V1.2 (02/20/12) 
Added to Customer export: phone, state, address alias, address additional information.
Added to Product export:  language, product URL, images (URLs).
Added to Order export:  phone, alias, total products, total real paid, total shipping, total taxes, total discounts, voucher name, product quantity.
Automatic Upgrade Notification.

 

V1.2.1 (04/29/12)
Added option to export orders with 1 line per product (can list each product name / reference), or 1 line per order.
Added support for Serail Number Module (export the serial that was used for each product).
Fixed a bug with export of "Other Tables" (some where not displaying correctly).


V1.3 (04/10/13)
Support for PS 1.5
Support for multi-shop.

V1.3.1 (05/01/13)
Fix for saving export settings (PS 1.4)
Fix for product URL (did not include category names) (PS 1.4)
Fix for fields not being escaped properly with certain characters (PS 1.4)

 

V1.3.2 (09/25/13)
Backup files are now saved with a UTF-8 heading (opens better in Excel)

 

V1.4 (09/16/14)
Added support for PrestaShop 1.6

    Module Reviews

    Thanks for leaving a product comment! Please note that we do not check these comments on a regular basis and therefore do not reply to products questions or support requests posted here. For questions or support use our Contact Us form.


    FromTitleComment
    2011-07-13 Paul W. Very useful The best thing about this is it allows non-administrator users the ability to run SQL queries by themselves...it was too dangerous to allow them access to phpMyAdmin and phpMyAdmin didn't support custom privileges so they always had to go to IT to request a report. Highly recommended.
    2011-07-04 Lisa G. Perfect The Database Export module is exactly what I needed and works perfectly. It makes our company's handling of data so much easier and faster now that we can export through a back office module rather than fiddling around with our database through our phpMyAdmin panel. Such a time saver! Thanks for the great module!
    I use PrestaShop v.1.3.2.
    2011-06-22 fahad i. Thanks Presto Changeo Team Excellent module,working fine with prestashop latest version.Export data very fast and accurately with no error.Thanks to presto changeo Team.
    2011-04-18 Delmotte M. Thanks a lot A very good module who make life better with prestashop. Manage your business website could be easy. The functionality are very interest and the option to export every database is very useful. thanks to developer

    Only registered users can post a new comment.