Excel2JS - import/export of goods from Excel and YML in JoomShopping

of Excel2JS is expanded import and export of goods from Excel and YML in JoomShopping. This comprehensive component will allow to simplify steering of shop on the basis of the JoomShopping shop established from Joomla 2.5.6 to Joomla 3.8. With this expansion you can fill the shops without restrictions, using directly Excel price lists of suppliers. Now you do not need to use difficult converting of prices from the xls format (or xlsx) in CSV. Pay attention that if all of you have got used to use CSV, then in it there is still such opportunity to import and CSV format.

has no restrictions! It is delivered with open source code! It is unique!

of Excel2JS - the unique tool for work with characteristics and attributes of goods (in difference from competitors). The prices of combinations of dependent attributes are imported and exported in separate cells that will allow to apply easily to them recalculation formulas to import back new prices. The component can also create in your online store treelike structure of categories with unlimited number of levels of enclosure. For this purpose it is necessary to mark categories that their component has arranged respectively. There are several modes of identification mark to set compliances between

categories relatively each other and concerning goods.

Special characteristics and possibilities of the Excel2JS expansion:

Creation/updating of the products specified in Excel prices (.xls or .xlsx) or csv-files;
Manual or automatic creation of backup copies of the main tables of shop;
Flexible control of parameters of import of goods by means of the convenient interface on ajax (JQuery UI)
the Difficult enumerated list (in cell with the name of category or in separate);
opportunity to remove goods which are absent in price from the publication Is available;
Updating of goods in parameters. For example, on product code, the name or ID of goods;
Identification mark of names of categories special-symbols (to or after the name);
the Instruction ID or names of category in line of each goods;
Search of the corresponding category in coincidence of words in names of goods and categories;
Export of products to Excel or CSV file;
Import according to the schedule from the folder specified by you (or the file specified according to the reference on other website) on means of the scheduler of cron on your hosting or the server. This function allows to automate completely daily updates of the prices and the remains of goods without vmeshatelsv of the person. Allows to remove completely manual skills if you adjust unloading of price from the warehouse program (1C or other.) in certain folder on your website;
;
Creation of structure of "tree" of categories and seating in it the corresponding goods;
supports import of one goods in several categories at once;
Package creation of the reduced images of goods (miniature);
Import of images which are inserted into price;
Downloading and transformation of images according to the reference from other website;
of Pozvolyaetimportirovat and to export attributes of goods (dependent, independent and free) and characteristics;
For each attribute / characteristics allocates separate column;
opportunity to create sets of options of dependent attributes according to the scheme "one to one" Is available;
support of import and/or export of the accompanying goods (on ID of goods or product code) Is available;
opportunity "to nullify" quantity of goods which are absent in price Is available;
Group of lines means of Excel (hierarchical lists).

of Excel2JS has very flexible and convenient system of control under any Excel price. You have enough to choose of those which are present at your xls-file by means of dragging of the name of columns and to set it the necessary order which would correspond to your price. Also there is possibility of automatic creation of backup copy of the main tables of JoomShopping (goods, categories, attributes) before each import. Thus you at any time can return to the previous condition of shop to one click.

of YML of Esport / import. In this point you will be able to carry out import and export of goods from YML and to YML. Nastroki remain in cross-sections which can be chosen from the dropping-out list. Only the main fields and characteristics of goods are exported to YML. From YML files only the main fields and characteristics are imported. On the same tab it is possible to find references for the scheduler of Cron to carry out import/export according to the schedule . The coefficient of recalculation of the prices is number by which the prices will be multiplied during import and export. Thus. You can set margin on goods. For example, for margin of 20%, it is necessary to specify coefficient: 1.2

Installation:

the Received archive to unpack

any zip the archiver. To study inside the settling-down text file - the instruction.
After studying of the instruction to find and load according to the reference. To unpack or at once to establish (vzavisimost from the version). To study the instruction for work (the PDF document not in all versions)
to Install the com_excel2js extension through the manager of the Joomla expansions

System requirements:

the Component works at versions of Joomla from 2.5.6 to 3.x
the Component works with JoomShopping 3.12 above (further JS 3) and JoomShopping 4 above (further JS 4).
the Component works with Excel 98 - 2010 and CSV, i.e. extension of the file has to be .xls, .xlsx or .csv
it is necessary For correct work that on your server there was PHP the 5th version (Supports php 7.0 and with 7.1)
the iconv and mbstring Functions have to be included, otherwise there will be problem with coding of the Cyrillic symbols.
Dirrektiva has to be included by short_open_tag.
For work of system of creation of backup copies has to work on your server as PHP - the system function () – about it you can learn from the hoster.
the safe_mode Mode has to be switched off.
the Recommended requirements to random access memory of hosting – 128 MB. Minimum – 64 MB.