PrestaPricing : Fast and bulk updates of products and attributes combinations - FLEXIBLE IMPORT

NEWS : Version 4.1 is available ! Brings new features like the automatic link to the corresponding products during the mass upload of images, or the mass update/creation and duplicate of product features. 

Introduction: 15 minutes demo of PrestaPricing (V4.1):

Video presenting the interface and the basic features of PrestaPricing V4.1. It also includes a short introduction to the mass edit tools



Tutorial: Excell and CSV Import-Export using PrestaPricing (V3.1):

This video is demonstrating the csv and Excell import and export fonction introduced in PrestaPricing V3.5. This video is not covering the method to create new products by importation, introduce in V4.0 (a new video is in preparation)



Tutorial: How to set temporary promotion or quantity discounts on many Prestashop products, using PrestaPricing module V4:

This tutorial explain how to set up product discounts in your shop (specific prices and quantity discounts, using PrestaPricing V4



Tutorial: How to massively create, edit and duplicate product features with PrestaPricing V4.1:

This video is demonstrating the usage of PrestaPricing V4.1 module to create and edit product features in Prestashop. It explains in particular how to duplicate the caracteristics of a product to a set of products or categories.



Tutorial: How to display and edit products and combinations photos in PrestaPricing V4.1:

This video tutorial is demonstrating how to include photos in products and combinations tables of PrestaPricing V4.1. It also explains how to edit them (select the image cover, edit the legend, assign photo to combinations, change the order of images. Last, it shows how to select table columns and create customized paper or pdf catalogs.



Tutorial: How to bulk upload product images in Prestashop with PrestaPricing V4.1:

This video tutorial is demonstrating how to massively upload your Prestashop product images with PrestaPricing V4.1. You will also learn how to assign them to product combinations and to configure PrestaPricing to have the image files automatically assigned to the corresponding products.



What's for ?

PrestaPricing is a standalone Windows application. Totally secured, it connects directly to your Prestashop products database for real time or asynchronous editing.

Its intends is to replace the catalog backoffice, to work 100 time faster on all daily or periodic database maintenance.

With a very friendly and powerful user interface, it allows you to very quickly edit the prices, weights, references, SEO fields and most of other parameters of your products and their combinations.  

PrestaPricing allows flexible bulk modifications of prices, quantities, taxes and all other columns. it has never been so easy and quick to maintain hundreds or thousands of products and attributes combinations.

You can for example activate all (or a selection of) products at once, or increase the prices of all products of any number of categories by x% with one click.

Prices can be computed and set automatically to reach or keep a given margin.

Prices can be rounded automatically.

Offers the capability to fully manage the discounts, specific and volume pricesand stock. It will make massive prices management a snap, particularly during "on sale" periods.

Beside other things, it includes a very powerful and customizable catalog printing and exporting engine.

You can copy paste a data from one cell to an entire column or selections of cells (with immediate update of the database).

You see immediately the final retail prices with and without taxes (in any country / state).

The latest version includes an export / import engine. Allows you to create excel files, with your products and you combinations. Choice of products and combinations, choice of columns and various calculation options when importing.

The importation permits to bulk update the products and combinations and to massively add new products to the Prestashop database.

You can create and bulk edit product characteristics, specific prices and quantity discounts.

You can upload hundreds of new photos with a few clicks and have them automatically associated to the corresponding products.

And much .../...

What is different from Prestashop  Backoffice ?

The backoffice is a web application, therefore much slower than a Windows application. For example, with the backoffice, each single change on a combination, requires the entire page to be uploaded again. It is ok if you have lot of time to loose. Not us.

With PrestaPricing, each change is applied instantly, with no wait at all! You can easily navigate from one product to another, swap to another combination, all this on a single click. You can even use the copy-paste.

The backoffice does not propose any tool to modify prices and quantities of many products at once while PrestaPricing permits mass editable on entire columns.

With PrestaPricing, you can see immediately the impact on the retail price +Tx of the modification of another parameter (price impact, discount,...)

I use Excell so far. What are the pro-cons of PrestaPricing  ?

PrestaPricing works in real time, connected to the database (even if from version 3.5, it also includes an offline editor, for travellers). Your edits are immediately taken into account. This is optimum for daily maintenance.

Creating Excel files from the database, to do mass upload and sync after editing, is a much slower and risky process. With PrestaPricing, you have full control and visibility on what to import and how.

PrestaPricing integrates many bulk modification tools, to easily apply a price variation to a selection of products for instance.

It also calculates in real time the final price of a product, the margin... by changing any parameter like the wholesale price, the tax id, the ecotax, the country of sale...

It includes forms to edit products and combinations one by one (with an HTML WYSIWYG editor).

Works on all servers?

Yes!

With previous versions 1x, a direct (also called "external") access to the MySQL database of your shop was required. Technically speaking, the server's port 3306 have had to be opened. This is rarely the case with shared servers. The alternative was to use the SSH protocol (rarely proposed as server option)

From version 2.x and above, the connection can be established on all databases, even on shared server, without using the 3306 port  or the SSH.

Time limited offer !: Purchase this application together with PrestaCategories and get a 15% refund on the total amount. 

The refund is made after the purchase, py Paypal only. Offer valid only if products are purchased in the same order and for the same number of licenses per product.

Evolutions:

-Creation of missing combinations during the Excell importation

-Mass creation and update of tags and accessories.

 The purchase of the current version is granting the right to use all future upgrades released during the next six months. 
 

Languages:

Available in English and French

Support 14 alphabets.

Compatibility:

Fully tested on Prestashop versions 1.2.x, 1.3.x and 1.4.x

Not working with previous  versions.

License rights and limitations:

Please read the included license for more details.

The license is valid for one PC and one site only.

If you plan to use the application on multiple sites, you have to purchase a multi sites license. Cheaper than buying multiple licenses, even if our price is highly digressive.

When purchased with a multi sites license, the application will allows you to save and retrieve the connection parameters for all you site. A must have feature.

If you are a developer of sites for customers, you must purchase one license for each of their PC, in case you plan to distribute this application with your product or service.

For high volumes of users or PCs, please contact us for a quotation.

Current version:

V4.1.3.a build 1

File size:

46Mb

Copyright:

MyPhotoRescue 2010-2011

Installation guide:

Included in the readme.txt file

Various versions:

Version 4.1.2.a new features: Attachments tab bug correction.

Version 4.1.1.a new features:

-User interface change to allows better expansion of tables (height) 

Version 4.1.0.a new features:

-Bulk edit of product features

-Catalogs list of columns is customizable

-Automatic recognition of products to assign to new photos

-Product photos can be made visible in tables

-Form navigation is 3x faster

-Now possible to hide prices-tx and taxes when displaying prices+Tx

-Re-indexation automatique de la recherche après la création de nouveaux produits par importation 

Version 4.0.0.a new features:

To be documented

Version 3.5.0.a new features:

-Powerful tool of export and import of CSV and Excel files. Choice of products and combinations, choice of columns and various calculation options when importing.

-The Import allows for example to update the purchase price while keeping the margin of each product and combinations (modifies the sales prices).

Rem: The import does not yet create new products or combinations. It is a tool for quick updating.

-Exported data files can be edited without being connected (asynchronous working mode)

-New context menu on the tables, allowing batch operations (copy multi paste -  entire column paste)

-Columns visibility is saved between sessions

-Support of database names with special characters like "-" (There is no need to add `` anymore)

-The connection settings are automatically saved when pressing the connection button

-New button to hide all columns

-New editable and computed key column: rate margin between purchase price and sale price for the products and their variations. Automatic modification of the selling price and cost impacts. Modifiable by lot.

-Modification of wholesale prices will keep the rate margins (option).

-Column-Id taxes and group IDs tax payment is now editable

-Tools for mass update also applicable to tax Id and  ID group rules tax.

-New buttons to select all the rows in once.

-Automatic rounding function: Sale prices of products and variations can be rounded to the nearest euro, nearest tenth, 0.5, 0.9 or 0.99)

-Tables ordering now possible on almost all columns

-Help on all buttons. Quick guide more complete. Increased duration of tooltips.

-Line-total amounts on the bottom of the tables.

-Optimization of speed-editing in tables (calculation of other fields field is now done well leaving the field, not at each character edit).

-Negative margins highlighted in red

-Ecotax is now modifiable by lot

-Fixed a bug where in some cases, the connection parameters were not saved (not reproduced bug - solution therefore remains to be confirmed).

-A new catalog format available, with product and combinations photos.

-Numbers in combo boxes.

-Setting-possible of number of attributes displayed by declination line (height of lines)

-Search possible on almost all columns.

Version 3.4.1.a new features:

-New mass update function (button "="), allowing to assign the same value or % to the field of all selected lines. Very useful to manage quantities.
-New combo box to offer more choices of parameters (mass update tool)
-Now also editable by mass update: Minimal quantity, unit price, price unit ratio, unit price impact.
-Calculation error correction (PS 1.4): Ecotax is now -Tx. Ecotax +Tx is calculated (new column) using a specific tax and is added to the TTC calculated price.
-New field showing the tax rate applied on the ecotax, for the selected country/state
-Calculation error correction (PS 1.4): Combination price impact is now -Tx. Add a column (editable) with calculated price impact +Tx
-Bug correction in bulk modification TTC price tool: Now using the tax specific to each product.
-Bug correction: With some servers (OVH), the modified data were not saved due to a date format mismatch
-Display bug correction: List of combinations correctly refreshed when activating/deactivating the taxes.
-For PS 1.4: Added a new column showing the total unit price + Tx of each combination.
-Columns are re-ordered for an easier reading (various prices are grouped)

Version 3.4.0.b new features:

-Compatibility with Prestashop V1.4

-Still compatible with PS1.2 and 1.3. The interface adapts itself to the PS version used.

-Multi sites license and connection parameters management and saving system

-UPC bar-codes in forms, catalogs and export

-All PS1.4 new fields included and editable (UPC, minimal quantity, online only, unity, price per unit, width, height, depth, condition, add shipping cost, available for order, show price....)

-New tax system tax management, including selection of country and state

-Combo fields in table to replace 0-1 values (ex: New, used...)

-Product form re-ordered. Delimited zones.

-Bug corrected: Code bar refresh in product form

-Non ANSI characters are not saved anymore when changing alphabet in the form (to avoid saving ??? characters)

-Encryption key can be hidden and not saved (more secured)

-No more appli.ini file containing the serial number (more secured)

-Vertical separator

-Quick user guide improved

-Bug corrected: Date replaced by the date of the day (same as patch #1)

-Mass editing of price per unit (bulk)

-Bug corrected in product table: +Tx price equal -Tx price is taxes are not activated

-WT replaced everywhere by +Tx

-Product name and attributes list moved to the far left of tables (easier to read)

-Product table divided into two parts (product names stay visible when scrolling horizontally)

-Nice new installer.

Version 3.2.0.a new features:

-Support 13 additional alphabets (Occidental ANSI,Arab,Baltic,Chinese,Chinese Tradi,Corean,East Europe,Greek,Hebrew,Japanese,Russian,Thaï,Turque,Vietnamese) to display correctly categories and products text fields.

-Limitation: The product's description field is Wysiwyg only when using the Occidental ANSI alphabet (text/code html mode only in other alphabets)

Version 3.1.0.a new features:

-The key one: You can now do bulk increase or decrease of product prices. You select a list of products or list of categories, (or even list of combinations), select if you want a % or value increase, to be applied on wholesale or retail prices, with or without taxes, and lately press one button to have the change made on all your selected items.
-Added an edit form for the products. Including HTML and Wysiwyg
-All fields of Product and Product_lang database table are now included in the table
-size increase of main window
-Bug correction: UTF8 coding of “référence” and “location”
-If starting and ending date are invalid, they are replaced by the date of the day
-All tables are now multi-selection
-Check boxes in tables to replace 0 and 1’s
-Bug correction: Edition of negative impacts
-Login windows is now hidden after login
-Display of products and combinations photos in forms
-Tracing of connection (opt)
-Filter on all fields to match Prestashop fields lenght
-New connection module (ready for Prestashop V1.4)
-Various IHM bugs correction
-Increased speed of categories tree building
-New mouse cursors
-Serial number validation messages translated to English
-Increased speed of display mode change routine and taxes management routine
-Correction of a bug: Deletion of and chains in HTML fields
-Various IHM improvements (1 more window separator, tab order corrected)
-Memorization of the language selected to display the windows.
-Product quantity editable in product form (if the product has no combination)
-Change of the name of the “in stock”, “out of stock” fields.
-Cursor change for text fields

Version 3.0.0.c new features:

-Comes with an automatic connection module for Prestashop
-In form mode, allows to naviguate from one product to another
-Print of catalogs, classified by categories
-Export of catalogs to PDF, RTF, Excell, XML,Word, E_mail+PDF
-You can change quantity of products with no combinations
-Automatic calculation of quantity of a product, when changing the quantity of one of its combinations
-You can now edit the name of the products
-Full handling of price discounts
-Calculation of final product prices, WT and with discounts
-Current price put in bold (so you know immediatly if a discount is or not applied)
-Activation /desactivation of "On Sale" logo
-Activation /desactivation of tax
-Add/edition of "Out Of Stock" parameter
-Display full and discounted price for each combination (current one on bold)
-All attributes making a combination are now displayed directly in the product combination table
-You can select mulitple categories at once
-Products list is classified by categories

-Application protected by a serial number

Version 2.1.0.b new feaures:

-Handling of prices with taxes. Automatic calculation

-Adding of categories tree

-Prices displayed with 6 digits

-Removal of useless connection fields

Version 2.0.0.a new features:

-Connection to all databases, even if located on a shared server

-Navigation between combinations included in the form window

-Full multi-languages

-Attributes table added in form window

-Combination code bar graphically displayed

-Pop-up help on all buttons

-Possible activation / desactivation of links between tables (screen refresh speed increase)