Complex export / import of XLS for JoomShopping

Complex import allows to do loading of products in the JoomShopping component without additional need of reconverting of the MS files Excel, Libre Office, Open Office, CSV format.

the Extension (add-on) for Joomshopping is installed by without binding to the domain and it is possible to use it on unlimited quantity of the websites.
Loading of products ( import ) in JoomShopping, allows to make primary filling of shop with the goods and also to provide updating or addition of goods in the existing catalog. Updating is made at the choice of the concrete field in the add-on - to "Name", "Product code", "goods ID".

of Advantage:

• Import of products from the Excel MS file (xls, xlsx)
• Import from the CSV files
• the Maintained codings: Windows-1251, UTF-8
• the Possibility of flexible control of structure (lack of the rigid sequence and existence of columns) of the exported XLS file.
• Methods of updating of goods - ID, Arktikul (EAN), the Name.
• Automatic creation of the absent categories, attributes, characteristics, tags, taxes, producers, etc.
• Support of enclosure of categories.
• Support of the multichoice of characteristics
• Support of multicategorization
• Support of dependent attributes (everyone to everyone)
• the Possibility of depublikation of all goods before import.
• to Export goods
• to Export settings
• Removal of the existing images
• the Automatic resayzing (change of the sizes) of miniatures
• Automatic generation of alias (pseudonym)
• Import of settings of shop (ATTENTION! of control for import have to surely is on the second sheet XLS of the file) On leaf of import (the first leaf of the file ) there can be formulas, only results of calculations are imported.

Than better than others

1. you can make by

   set of sheets and operate with data which will be is removed on the first leaf as summary. For example the price of the supplier goes the second leaf, and on the first the formula has output all data and column with the price already goes with recalculation of your margin.

2. you can form the meta description, simple formula of hitch of the name, code, the price, the short description. In the same way it is possible to form keywords and title. At once you import the SEO optimized goods. What excludes need of use of third-party SEO of optimizers.
3. of the Change in price can it is made by simple broach of formulas (for example Yacheyka*1.15 - revaluation)
4. Formation of columns can be ready for +15% by the sum of values of several cells. For example: attributes are formed as addition of text data from different cells of other leaf, or the sum of numerals of values.

Installation is made by

via the Installation and Updating control panel of JoomShopping as usual add-on. </>

Weeding br which it is possible to import and export in this expansion.

of

& nbsp;

Distinctive features:
For filling of fields, it is not necessary to know any identifier of any position, all fields are filled in simple language that will allow to prepare price, to people not so well familiar with the equipment.
Support of pseudonyms and images for the absent categories.
import of goods directly from the Excel MS file (not *.csv) Provides.
Import of goods comes from the first leaf ексель the file.
Import of settings comes from the second leaf ексель the file.