PrestaPricing : Fast and bulk updates of products and attributes combinations - FLEXIBLE IMPORT
NEWS (2012/04/16): Public release 5.1 is now available. Fully compatible with Prestashop 1.5, including xls/csv import feature. The importation tool is also enriched: You can now import also products combinations, attributes and features. Comes with a columns mapping tool.
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
NEW:Quick update on the new interface of PrestaPricing from version 5. Does not present the new features (see other new videos below) (duration: 15min):
V5 of PrestaPricing brings many new features. This first video is demonstrating only the changes and new features of the huuman interface, like the new URL columns (very useful to export the catalog to price comparators), the custom columns, the colors in table, the multilines edit mode (to edit product descriptions directly in the table), the language switch, the update date column (to sort out and deactivate products not in supplier lists anymore), the paginator... . It does not show the new features of the program itself (see other new videos below)
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.
You can create and bulk edit product characteristics, specific prices and quantity discounts.
It has effectively never been so easy and efficient to create, duplicate, massively associate features (caracterisitics) to collections of products.
Tutorial: How to massively create, edit and duplicate product features with PrestaPricing V4.1 (duration: 6min)::
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.
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.
Tutorial: How to set temporary promotion or quantity discounts on many Prestashop products, using PrestaPricing module V4 (duration: 9min)::
This tutorial explain how to set up product discounts in your shop (specific prices and quantity discounts, using PrestaPricing V4
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 new 1.5 Prestashop version and its multi shop mode is also supported. Using both PrestaPricing and it little brother PrestaCategories, you get all the required tools to manage your catalog in an effective and fast manner, in a multi shops context. You can for instance edit multiple products in multiple shops simultaneously, even if the shops do not belong to the same grroup of shops.
NEW:Training on the multishops management in PrestaPricing V5, for Prestashop 1.5 and later (duration: 28min):
The major characteristic of Prestashop 1.5 is the multishop mode. PrestaPricing V5 is supporting this mode and brings advanced mass edit functions to create and modify products, declinations, images, characteristics etc, in multiple shops. This video will train you on the mono and multi shops edition modes, the multi duplication of products, the associations of images and characteristics to various shops.
The version 5 is adding the compatibility with Prestashop version 1.5, with full support of the multi-shops mode and brings also many great new features (see complete list at the bottom of this page): Mass duplication of products, mass edit of tags, upload list of image URLs, advanced filtering and searching tool,.../...
NEW:Tutorial showing the other new features of PrestaPricing V5 (duration: 15min):
V5 of PrestaPricing brings many additional new features. This video will train you on how to use the major of them: The pre-filters, the tags tab (mass association to products), the multi association of attributes and attributes values to product's variants,...
PrestaPricing also includes a very powerfull and flexible export / import engine (optional). 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 massively create and update new products and combinations in the Prestashop database for lists (xls or csv files) provided by suppliers or exported from an older version of Prestashop. Such a tool is a must have when working on drop-shipping and having to update massively and regularly the product catalog.
The synchronisation between the file and the database can be done on many parameters (identifiers, names, references, supplier references, bars codes)
It can automatically create and/or update products, combinations, manufacturers, suppliers, features and attributes. It supports mostly all parameters (more than 50) like prices, quantities, names, descriptions, SEO fields, accessories list, images,...
Supporting multi shops and multi languages
Includes a columns mapping tool to create re-usable mapping models per supplier
The most important feature of this importation tool, is its flexibility: It display the content of the file in the screen, to allow you de select the columns (database fields) and lines (product or variants) to import or not.
Note: This option is now also supported on Prestashop 1.5 (starting from the version 5.1).
NEW:Quick overview (8min) of the new xls/csv importation tool of PrestaPricing V5.1:
This video is making a quick tour of the new Excel or csv product and combinations list import features included in PrestaPricing V5.1.
NEW:Tutorial part 1 on 2 of the xls/csv import feature of PrestaPricing V5.1. Importation of products (Duration: 25min):
V5.1 of PrestaPricing is major release coming with a new and powerfull importation tool. This first part of our tutorial is showing how to create or update product via import. It also explains how to create new suppliers and new features and to have the selling price calculated by the program, from the wholesale price and a define margin rate. Last but not least, it shows how to prepare xls files to be used in the photos mass upload tool
NEW:Tutorial part 2 on 2 of the xls/csv import feature of PrestaPricing V5.1. Importation of products combinations and attributs (Duration: 20min):
V5.1 of PrestaPricing is major release coming with a new and powerfull importation tool. This second part of our tutorial is showing how to create or update products combinations via import. It also explains how to create new attributes groups and attributs. It also shows how to optimize xls files to be used in the photos mass upload tool, to avoid associating twice or more the same photo to the same product, while associating it to multiple combinations.
You can upload hundreds of new photos with a few clicks and have them automatically associated to the corresponding products.
Tutorial: How to display and edit products and combinations photos in PrestaPricing V4.1 (duration: 7min)::
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 (duration: 11min)::
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 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?
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.
Check our packs !: Purchase this application together with PrestaCategories and get a 15% refund on the total amount.
-Mass creation and update of accessories and attachments.
The purchase of the current version is granting the right to use all future upgrades released during the next six months.
Available in English and French.
Support 14 alphabets.
Fully tested on Prestashop versions 1.2.x, 1.3.x, 1.4.x, 1.5.x
Not working with previous versions, beta and RC versions.
License rights and limitations:
Please read the included license for more details.
The license is valid for one PC and one site only.
Installation on a second PC, if the usage is restricted to the same user is authorized, without demanding to purchase a second licence.
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 your sites. A must have feature.
If you are a developer of sites for customers, you must purchase one license for each of their PCs, in case you plan to distribute this application with your products or services.
For high volumes of users or PCs, please contact us for a quotation.
5.1.1.b build 1
Sitolog and MyPhotoRescue 2010-2012
Included in the readme.txt file
History of versions:
Version 5.1.1.b final, stabilization version
Version beta 5.1.1.a, stabilization version
-Correction of the various issues with the 1st béta 5.1.0 (mainly linked with the new import features)
And 3 new features:
-The automatic filter set on the list of mapping models can be deactivated. This permits to duplicate a model build for products file and re-use it for combination files.
-URLs in the Image URL column, is now pointing the original file (and no longer the "large" version of the file).
-A right click in the product table permits to open the product page in your browser (equivalent to "View my shop" function). Can be use also to open product's cover image in your browser.
Version beta 5.1.0.a. Major version
-Creation of missing combinations, feature, suppliers, manufacturers during the Excel importation.
-XLS/CSV Importation supporting PS 1.5.
-Importation files columns mapping tool.
Version 5.0.5.a - Stabilization version
-Fix: attributes were listed as many times as the declination had images
-Fix: it was possible to edit the columns product Id and combination Id (forbidden)
-Added a button to activate the multi-line edit mode in long text fields (as description). Was the default mode in v 5.0.4, but this mode is slower than the old standard mode. So is now optional.
-Management of the new parameter cache_default_attribute of the product_shop table for PS 1.5
-Fix: Some products may appear several times in the back and front office
-Management of multi-suppliers for the same product (PS 1.5) in the product form. Mass association
-Management of the default supplier in the product table.
-Supplier reference for the default provider editable (mass update) in the product and combinations tables.
-Supplier reference for other suppliers, editable in the product form
-Ability to activate/de-activate globaly the taxes on the site.
-Ability to disable the taxes in PrestaPricing, regardless of the taxes status in the site.
-If the taxes are disabled, it is no longer asked to choose a tax at the creation of a new product.
-New and more intuitive handling of the trace window (log).
-Ability to open and close the trace window from the import window.
-The columns containing long texts (eg descriptions, keywords ...) are multi-lines, with a mini lift, enabling direct editing of lengthy texts, without going through the form mode.
-New table to edit the combination's attributes in the combinations form (PS1.2-1.4).
-Ability to keep the interface in French, with an alphabet different than ANSI Occidental.
-The attributes cache is now disable by default, to speed up the application launch on new installations.
-Fixed a SQL error that could occured during the importation succes checking phase.
-Correct change of the alphabet from the main window (sync with the login window).
-Safe Closing the taxes window (choose of taxes when creating a new product), when switching to another application.
-Ability to configure the FTP from the main window without going back to the login window.
-Ability to classify categories according to their position (such as Prestashop), their name or number.
-Re-organization of the tab "View".
-An option that allows you to select all sub categories when selecting a category.
-Possible setting of the time to display the tooltips.
-Updated help of buttons.
-Correct change of cover image when removing the cover image, in multi-shops mode.
-Correct reaading of TAB characters and special characters included in text fields like the name of a product, reference etc ...
-Correct saving of special characters in text fields like barcodes, reference etc ...
-Correct reading of the "state" (condition) in multi-shop mode.
-Correct saving of combinations quantity in multi-shops when the option "enabled simultaneous modification" is enable. -Support of special characters in the automatic creation of an image legend constructed from the name of the product. -Category "root" did not disappear if the filter of categories on shops is activate and if the root is not associated with the selected store.
-Display of all categories in the tree, even those who do not have a name for the selected language (permits to create their name).
-Correct display of images with version 22.214.171.124
-Fixed copy and paste functions in the specific prices table (was disabled).
-Save the form correctly when changing language from the dropdown list of languages.
-"Force UTF8 decoding" code rewritten (did not work in tables and form on some versions of mySQL).
-Fixed the column headings in the product catalogs (PDF).
Version 5.0.1.a: Stabilization version
Copy paste of tax rules, change of price with tax when price without tax column is hidden, display of product (with combinations) quantity, tax on ecotax computing, taxe rate column gets empty when changing price, sql error with deleting availability date value,columns visibility check boxes relashionship, custom columns code rebuild.
Version 5.0.0.a and b. Major release.
-Support for PrestaShop 1.5 (except these three functions: Import Excel / CSV, management of quantities from the window product sheet, the combinations form).
-Duplication of products. Select x products and ccreat y clones of each of them, in 1 click. With automatic re-indexing.
-New Tab “filters”. Sets of filters used during the reading of the database. Saved time is impressive compared to the filtering system in the tables (which acts once all data are read).
-Pre-filter also on combinations, including attributes values. Allows for example to make cross-type filtering, like "view all red combinations and / or made of wood."
-Added 5 fully customizable columns.
-New date format (date+ hour) for specific prices setting.
-The "create new product" is enriched. You can create x products in one click in their respective categories. Choice of tax rates. No more extension lang-xx in the names automatically created.
-The “add combinations” function now permits to create x copy in one click. The first one created is set as default combination.
-It is now possible to disable the memory cache of list of attributes, performed during the connection. Will accelerate the connection on very large databases (skipping step "Build-Pr-At table".
-It is now possible to add and modify attributes for x combinations simultaneously.
-Added two columns "full URL" and "URL of the cover image" in the Product table, filled automatically. Permits to create xls compatible with price comparators and Google Shopping, which require these informations. Option of checking the existence of images and choice of classic or rewritten URL, with or without iso code language.
-The search for products to be associated with downloadable images, is now done by default on the list of products displayed in PrestaPricing and not directly in the database (this remains an option). Big time saver during this phase because of fewer SQL queries.
-The images upload tool, now accepts lists of image URLs (ftp or http), in addition to local images. Also working with automatic association to products.
-It is also possible to simply provide the address of an ftp (+ logon information) and let PrestaPricing analyze the images names, associate them to the righ products and manage their transfer directly between ftp servers (without using the PC).
-Set of optional filters on image files, used before automatic association to products: file size, date of last modification, name, extension ... Allows for example to only import new images from the previous import. Filters can be use with ftp files, local folders, drag and drop files ...
-New option to include the file name in the legend.
-Automatic replacement of unauthorized characters by dashes, when importing or creating rewritten URLs.
-Added id_lang column in the products table (to ease the process of importing in multiple languages).
-New function to clean wrong associations of images to combinations.
-Mass deletion of characteristics and characteristic values.
New features specific to PrestaShop 1.5
-Changes made to products and combinations (one by one or with mass edit tools) can either apply to one show or a selection of shops (even in shops of different groups of shops).
-The function to create new products is multi-shop.
-Option to filter-categories on the selected shops.
-Option to filter the specific prices on selected shops.
-Option to filter the characteristics of the selected shops.
-The new feature of duplication of products and also multi-shops, with 4 options: "Duplication in all the shops," "In the whole group of shops", "In all selected shops", "In the same shop" .
-Read and change of the default category of the product according to the selected shop.
-New fieds fields specific to this release, in the Products table: "date of availability", "advanced stock", "visibility", "is virtual", "id_shop"
-Option to list only common products of selected shops.
-The management of images is multi-shops. The upload tool also. Possible to delete x images in all shop in 1 click. Possible to activate x images per shop in 1 click.
-Taxes filtered according to the selected shops.
-The specific prices table includes lines created by a catalog price rule (no editing possible at the moment).
-Addition and editing of PS1,5 specific fields in the specific prices table (ex: combination of attributes)
-Possible to edit the "position" (order) of product characteristics.
-Function to associate features to shops.
-Filtering of specific prices and characteristics to selected shops.
-The “Product" form (“ABC” button) is also multi-shops. Addition of specific PS1.5 fields. -Replacement dropdowns identifiers by dropdown lists with names (eg: names of suppliers ...).
-Setting of the products cover image per shop.
-Option to force UTF8 decoding / encoding.
-LIMITATION: The xls/csv import feature is no yet operational with PS1,5.
-LIMITATION: The "product combination form" is not available with PS1.5
-LIMITATION: Does not support yet the new "advanced" stock management mode, does not permit editing/creation of catalog prices rules and of cart prices rules.
-Possible to change the data language and alphabet used, directly from the main windows (no need anymore to deconnect/reconnect).
-Possibility of not avoid reloading the list of categories when changing the language of the products table (saving time when editing multiple languages).
-Choose between 3 interface level ("1st use", "standard", "advanced"). Allows progressive learning of the application.
-Explanatory texts are printed in all tables, when using the “1st use” interface level.
-The "Product" form has been redesigned, with "drawers".
-Option to check if an image file exists.
-The “Refresh all” button is flashing when data are to be refreshed.
-Two new columns added in the product table: creation date and last update date. Allows for example to filter the products imported or recently updated.
-The photo columns have been moved to the left.
-New column"category name" in the product table (read only).
-New function to limite the number of rows displayed. Greatly accelerates the speed of the application when connecting on large databases. Disadvantage: bulk editing functions act only on the selected/visible lines.
-Site-name added to the title bar of the application.
-Removal of the useless Id_image check-box.
-The buttons "select all" retain their state during a refresh of their table.
-You can personnalize the tilt of column headings of tables.
-Pop-up menu (right click) contains is adpated to columns (eg does not propose the “copy and paste” commandes if not allowed for the column).
-Colorize critical values in tables (eg negative prices or margins set in red).
-The column supplier_reference is moved close to the column reference.
-Wherever possible, the id manufacturer, supplier id, id tax columns etc... are replaced by "drop down" columns: Manufacturer, Supplier, Tax and display names rather than identifiers.
-Supports drag and drop of images and Excel images lists from Windows Explorer directly into the “images to upload” table.
-Ability to set up filters on the columns of the “images to upload” table
-Options to keep visible the lines after uploading images (they are identified by a color change).
-Translations in French of most of the messages of the trace window (window with a yellow background).
-Changing the attributes of combination is done with dropdowns placed in each row of the table and not in the title of the column. The table supports multi-line selection to allow editing of multiple attributes simultaneously (eg deletion).
-You can move the “association of images to products” pop up window.
-More columns are displayed by default in the products and combinations tables at the first launch.
-When legacy mode = false, the images where not always properly uploaded.
-Error while computing specific prices (rate wrongly divided by 100).
-Error when checking "On sale" without selecting the line containing the checkbox.
-The green star button to add an image to upload remains out
-Management of duplicate key error when associating a second time an image to a combination.
-French localization of the MPR Applications Connect module.
-SQL-error when importing an empty row selected by mistake.
-Crash with Error line 66 in function "Bold-Price".
-Missing hourglass on button "Read Excel" in the import window.
-Some bugs fixed in the import/update combinations via xls (method B).
-Some rows in the “images to upload” table do not disappear either turn to green after import.
-Increase of the memory allocated by the server when upload large images to avoid server memory saturation errors.
-Spaces in the names of the image files generate an SQL error.
-Possibility of division by zero when editing the price per unit values.
-The software acts as if you had requested a change of the default category of a product, when trying to change its quantity.
-Inaccurate progress bar when transferring images.
-Wrong saving of changes made to "Online Only".
-Prohibition of copying and pasting in the "photo" column.
-Error-import html text fields (eg description) if it contained characters encoded as & ...;
-It is no longer possible to select the last empty row (which could generate SQL errors) in the products and combinations table.
-It is no longer possible to assign by error images of a product to the product attributes combinations of other products.
-The Turkish language is selected by default, after each application upgrade.
-Failure when to importing products with no name provided (now create a generic name).
-Failure of the verification phase after updating combinations from xls (SQL error).
-Reset of "Select all" buttons after when the entire list of lines is not any longer selected in a table.
Version 4.3.1.a: Stabilization version
Embedding of the corrective patch #4, which solves these bugs:
-Error at line 45 of the Local ajoute_fils_categorieM2 treatment procedure.
-Support of special characters like "and, in the table field, when copying and pasting.
-Addition of two fields to define a server proxy and its port.
-Hours management (in addition to the date) in the start and end date of specific prices.
Other bugs corrected:
-SQL error when doing a copy paste in columns discount and discount%, with PS1.2 and PS1.3
-When trying to edit the quantity of a product having combinations, the program was acting as if we were changing the product default catégory, asking to define the product visibility.
-The re_computing of the discounted price was not done when changing the wholesale price, price -tx or +Tx, margin,... (PS 1.2 and 1.3)
-Erreur fatale en cliquant dans la colonne "Activé", dans une autre ligne que la dernière sélectionnée.
Version 4.3.0.a new features:
Primarily, this release fixes two major problems, but hopefully pretty rare (depending on the servers):
1/When the identifiers of categories were artificially set to a very high value, during an import via excel by PrestaShop, the launch of PP could become very long, and even crash after Windows runs out of memory.
After this code change, the gain is very significant: On a test site in 2000 categories with 6-digit id, step "Build tree categories" decreased from 2 min to 3s!
But you will not see a difference if your id categories were created one by one by PrestaShop or with PrestaCatégories, or by simple increment.
2/On some servers, importing photos did not work, because the host blocked http requests in POST mode, as used by PP.
I changed the code to send the parameters using the GET method to solve the problem.
Requires the use of new module MPRApplicationConnect, V1.9, included in the zip.
Rem: The same problems also existed in PrestaCatégories before the corrective update V2.5 put online and announced last weekend.
OTHER NEWS AND IMPROVEMENTS:
Some further modifications and improvements that were being developed for the major version 4.5 or 5 were completed to provide a stabilized version:
-Added pictures of the categories in the table.
-Smaller connection windows (for small screens), with tabs, auto saving of FTP settings ...
-New option to start detection of infinite loops in the structure of categories (eg parent of a class of his own parents), or classes without a parent created by Store Commander for example.
-Code optimization of the "PrAtCb" step (loading of the product combinations table). Measures made on various sites with lot of combinations, show an improvement factor of 2.
-Auto-Delete of http:// if erroneously placed in front of the FTP url.
-Fixed bug when changing the position of images, with some older versions of PS
-Ctrl-A function in a table now correctly selects all rows (and no longer selects any blank line)
-Support of barres codes with and without the checksum (eg EAN13 = 13digits with the checksum instead of 12). Catalogs support both bar codes.
-In the product form, the order of categories given by the previous and next buttons now follows the tree (PS 1.4 and above only)
-Adding of a button as in PrestaCatégories for categories, to automatically reconstruct the URL simplified of products.
-A new button to automatically rebuild image captions (copy the product name)
-Fixed other minor bugs that have been raised to me (Management of quotation marks in fields descriptions, tag management h (that became H), update the "position" of other products the same categories when importing new products).
-A few snippets of code optimization to gain some speed where possible.
-Optional https connection (untested, I await your return).
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: Major update
-I have rewritten more than 80% of the code, looking for radical speed improvement at all steps. Up to 30x faster !
-Product images import tool, easy to use and working in the background (you can continue to work while it upload the photo on the server and resize them).
-Filter tool, so you can do things like this: Filter all combinations by one color, i.e "white" and assigning to all of them in one click, the "white" photo.
-New tool to manage (creation and mass update) specific prices, quantity discount, reductions,... for all versions of PrestaShop (from 1.2 to the latest 1.4)
-You can now create new products and combinations directly from PrestaPricing !
-Fireworks: New products can also be created automatically during the import of data from Excell. Probably the most demanded feature so far.
-and much much more...
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)
-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)