The extended import and export of products from XLS, XLSX, CSV in JoomShopping [COMIEL]
Complex import allows to make loading of the products in JoomShopping without necessity of converting a file from MS Exсel in CSV format.
Loading the products (import) in JoomShopping allows to carry out the primary filling of the catalogue with the products, and also to provide updating or addition of the products in the existing catalogue. Updating is made under "Name", " Code of the products ", " ID of the products ".
Opportunities:
- Import of the products from a MS Excel file (Exсel97-2003-file)
- Supported codings: Windows-1251, UTF-8
- The Opportunity of flexible adjustment of structure (absence of rigid sequence and presence of columns) of an exported XLS-file.
- Methods of updating of the products - ID, the Code, the Name.
- Automatic creation of absent categories, attributes, characteristics, labels, taxes, manufacturers, etc.
- Support of the enclosure of categories.
- Support of the multichoice of characteristics
- Support of the multicategories
- Support of dependent attributes (everyone to everyone)
- The Opportunity of depublication of all the products before import.
- export the products
- export adjustments
- Removal of existing images
- Automatic resizing (change of the sizes) of the miniatures
- Automatic generation of the pseudonym
- Import of adjustments of shop (v2.0) - (ATTENTION! Adjustments for import should be necessarily on the second sheet XLS of a file)
- On the sheet of import (the first sheet of a file) there can be formulas, results of calculations are imported only.
FEATURES:
- You can make set of sheets and operate with data which will be deduced on the first sheet as the summary. For example as the second sheet goes a price of the supplier, and on the first sheet all data are deduced by a formula and a column with prices already goes with recalculation of your margin.
- You can form the description by the simple formula of connection of the names, a code, the price, the brief description. In the same way it is possible to form the keywords and the titles. At once you import the SEO-optimized products. This excludes necessity of using foreign SEO-optimizers.
- Changes of the prices can be made by the simple drag of formulas (for example Cell*1.15 - reassessment on +15 %)
- Formation of columns can be adjusted by the sum of values of several cells. For example: attributes are formed as an addition of text data of different cells of other sheet, or the sum of numerals of values.
And than all is limited only by opportunities of MS Excel, your knowledge and imagination.
Attention!
Before import, be necessarily convinced, that the file is kept in format Exсel 97-2003.
If you expose a method of updating on ID, be convinced, that such ID are already exist to do updating on them . If such ID does not exist there is nothing to update. And a serial (system) ID will be created by JoomShopping.
We recommend urgently to update under the article (EAN, a code of the products).
As, it is always the one unique code for each type of the products, not connected with the system linkings.
Attention!
If you place an update method for ID, make sure that such ID is not dead, that on them to upgrade. If this ID does not exist, there is nothing to update. And you will create serial (system) ID, by JoomShopping.
Installation instructions:
installation is done via the Control Panel "Add or Update" of JoomShopping, as a normal addon.
(/administrator/index.php?option=com_jshopping&controller=update)
Removal is in the list of add-ons JoomShopping.
Enter key here YOURSITE/administrator/index.php?option=com_jshopping&controller=addons
The fields that can be imported and exported in this extension.
- Item ID
- Product code
- Quantity / Unlimited
- Availability of products
- Publication
- Tax
- Currency
- Template Product
- URL
- Old Price
- Purchase price
- Price
- Photo
- Photo (Full)
- Photos (Thumb)
|
- Manufacturer
- Delivery time
- Hit
- Weight
- Labels
- Product Name
- Alias
- Short description
- Description of goods
- META title
- META keywords
- META description
- Attribute (including pictures)
- Free attributes
- Characteristics
|
Further information on the work of expansion in the section (documentation)
Features:
To fill in the fields, no need to know any ID no position, all the fields are filled in a simple language, which will prepare a price, people are not as familiar with the technology.
Support for aliases and images for the missing categories.
Provides import goods directly from the file MS Excel (not *. Csv).
Imports of goods comes from the first sheet eksel file.
Import settings from the second sheet is eksel file.
Note!
After installation, do not forget to go to JoomShopping-Options-Addons (/administrator/index.php?option=com_jshopping&controller=addons) and enter key for Your domain.