Documentation on the installation, configuration and solving possible problems with the extension to "Advanced XLS import-export products" for JoomShopping
We examine the possibility to start. Each column will consider later.
Import from MS Excel file
To import the files will be used in MS Excel.
Supported encodings: Windows-1251, UTF-8
If the file is formed in OpenOffice, when you save, you must select Windows-1251 encoding
Flexible adjustment of structure (no rigid sequence and the presence of columns) of the exported XLS-file.
To import does not matter in what order you fill columns. The presence of a minimum of columns = 2. One depends on the upgrade method (see next. Paragraph). Second - that update (price or quantity or image, etc.).
Methods for updating products - ID, EAN, Name.
Column for the determination of what criteria will be updated products. Whichever way you choose, this column will be a mandatory field. In the absence of such code and selected update method "by code" will create a single product with an empty code and all subsequent values will update information of this product.
Support nested categories.
You can specify an unlimited nested categories, even if the parent category does not exist.
Support for multi-selection characteristics
To import several options for performance. Prior to version 3.9.0 using the addon Multivybor. After the 3.9.0 version in stock. In other cases, it will use the first option in the list.
Support for dependent attributes (each for each)
Allows you to create a combination of attributes for the product. That is pointing to two colors (red and black) and two sizes (56 and 62) will create four dependent attribute:
- Red + 56
- Red + 62
- Black + 56
- Black + 62
Support of independent attributes
Allows the use of independent attributes, indicating the price change
Opportunity unpublish all products before import.
Used mainly to fully update the product list. For example if the new price is not the position that was previously published. And not to compare the set of positions is sufficient to remove the publication of all the products and after import publicated leaving only those that are in the new price list.
Resize Images
If you import images, you can specify whether to change the image size according to the settings JoomShopping.
Aliasing (Alias)
If there is no alias in the goods manufacturer or category Import allows you to create it according to the standard transliteration of Joomla.
On a sheet of imports (first sheet file) can be formulas, imported the calculation results.
There's no need to manually fill in the values for the columns. You can use any formula MS Excel. Be imported only what you see in the file itself. You can use a second sheet for master data (such as purchase price), and on the first page write the formula = purchase * percent profit.
Installation instructions:
We now examine each column import more detail:
{slide=product_id}
Product ID can be found in several ways. The most difficult is to go to a table in the database products. The simplest is in the admin list of goods. The rightmost column of this is the product id.
Can be any integer.
{slide=ean}
This is the product code. Or in other words - Reference. It exists in every product, for identification. So-called second id.
Can use any word
{slide=name}
Product Name. When you import a name is assigned to the language, which is the default.
Can use any word.
{slide=alias}
Alias product. By itself, an alias is not mandatory, but if you want to see in the address bar of a fancy name, it is best to fill. For example, if the value is empty, the address bar will be: domen.rf/product/153/65 where 153 category, and 65 product id. If the value is blank, the address bar will be: domen.rf / category / product.
Can use any word.
{slide=short_description}
Brief description of the goods. Is shown in the list of categories of goods.
You can use any text.
{slide=description}
Full description. Shows the item card.
You can use any text.
{slide=meta_title}
It is this text will be displayed in search results, so he should be given full attention.
You can use any text.
{slide=meta_keywords}
Keywords. The column should consist of key words and phrases. It is advisable to see to it that the keywords are different for each product.
{slide=meta_description}
Description of the page. It may be called extended description meta_title.
{slide=qty}
Number of items in stock. If you use dependent attributes or unlimited, then use this column is not necessary.
Can be any integer.
{slide=unlimited}
Unlimited. Most often used in selling electronic goods or to reservation.
May be used:
- 1 (Unlimited)
- 0 (Limited stock value of the goods or dependent attributes)
{slide=publish}
Publication of the goods. Used if necessary opublikavat goods. By default, items are not published.
May be used:
- 1 (published)
- 0 (unpublished)
{slide=category}
Category.
If the goods are owned by more than one category, you must use the separator "|" (without the quotes).
Category 1 | Category 2.
If you specify a subcategory, you specify a separator "/" (without the quotes).
Category / Subcategory.
If the use of several categories, you need to use the separators.
Category1/Subcategory1 | Category2/Subcategory2.
If nuobhodimo specify an alias, use the separator ":" (without the quotes).
Category 1: category1
If you need to specify an image for the category, use an additional separator ":" (without the quotes).
Category 1: category1: category_image1.jpg (with alias)
Category 1 :: category_image1.jpg (without an alias)
You can use any text.
{slide=tax}
Tax. If no value is taken first in the list of taxes.
Can be used and the name of the tax rate with the separator ":" (without the quotes).
VAT 18%: 18.00
You can only use the rate, in this case if the tax rate with the missing, the rate will be created with the name of the value bet.
18.00
Please note, in the sense of rates should be a point and not a comma.
You can use any text for the name and numeric value for the rate.
{slide=currency}
Currency. If no value is taken, the default currency.
Id can be used currency. Currency ID can be found in the administrative panel of the right-most column in the list of currencies.
1
Can be used by the currency name
ruble
Can be used currency code
rub.
Code can be used ISO (letter code of the Russian Classifier rates).
RUB
Can be used by all the values. Need to add the new currency. The last value to the exchange rate.
Ruble: rub.: RUB: 40.000000
EUR: EUR: EUR: 1.000000
USD: USD: USD: 1.320000
Can be used only certain values above.
{slide=product_template}
Template store. If this column is not present, then the template is the default.
Can take any value.
{slide=url}
Link to product. The link will be shown in the item card for a more detailed examination of the goods. Such manufacturer site.
The value can be in the format of links (http://nevigen.com).
{slide=old_price}
List price for the commodity. If set, and being configured to show the old price, the list of goods and item card the price is shown before the main value of frozen.
Может принимать числовое значение.
{slide=buy_price}
Purchase price.
It can take a digital value.
{slide=price}
The basic price of the goods.
It can take a digital value.
{slide=image}
Product images. Specifies the name of the image that is in the folder \ components \ com_jshopping \ files \ img_products.
One can list a few pictures with the separator ":" (without the quotes). The main image is assigned to the first list.
image1.jpg: image2.jpg
Can take any value.
{slide=full_image}
Full product image. Specifies the name of the image that is in the folder \ components \ com_jshopping \ files \ img_products. In the absence of an image column is set to image with the prefix full_.
One can list a few pictures with the separator ":" (without the quotes). Each image in the queue will be set to the image in the queue image.
full_image1.jpg: full_image2.jpg
Can take any value.
NOT USED in JoomShopping version 3.12 and high
{slide=thumb_image}
Product images. Specifies the name of the image that is in the folder \ components \ com_jshopping \ files \ img_products.V If no image is set to the column with image attachment thumb_.
One can list a few pictures with the separator ":" (without the quotes). Each image in the queue will be set to the image in the queue image.
thumb_image1.jpg: thumb_image2.jpg
Can take any value.
NOT USED in JoomShopping version 3.12 and high
{slide=manufacturer}
Manufacturer. Specifies the name of the manufacturer and neobhomosti pseudonym and image. Used separator ":" (without the quotes).
You can specify the name of the manufacturer.
Coca-Cola
You can specify the name and alias manufacturer.
Coca-Cola: coca-cola
You can specify a name and a nickname, and image products.
Coca-Cola: coca-cola: logo_coca.jpg
Can take any value.
{slide=delivery_times}
Delivery time. The number of days during which the goods can be delivered. For example: 10 days.
Can take any value.
{slide=hits}
Hits and viewed item.
Can be any integer.
{slide=weight}
Weight of the product. The rated weight of the product, preferably Gross, as the field is taken into account when calculating the cost of using an automatic dostvki. Can be a fractional number (with a point) For example: 5,400
It can take a fractional value (with a point).
{slide=label}
Label goods. Specifies the name of the image and, if necessary for the label.
New
New: new.jpg
Can use any value.
{slide=attributes}
З
Dependent and independent attributes of goods. Specified by the user to select a specific value when ordering goods. Such as color and size.
Format dependent attributes: goods; Image: Image. Several attributes are specified with the separator "|" (without the quotes). All previous values of attributes in product upgrade - removed.
Attribute: value. You can use several of these groups, and each group of several values. Combination group Color: Red, Black and Size: 56.62, the price of 10, the number 5, with the code "product" and the image image.jpg be written as follows: Color: This will create a record four dependent attribute:
Color = red, size = 56, Price = 10, Number = 5, code = item More value = image.jpg
Color = red, size = 62, Price = 10, Number = 5, code = item More value = image.jpg
Color = Black, Size = 56, Price = 10, Number = 5, code = item More value = image.jpg
Color = Black, Size = 62, Price = 10, Number = 5, code = item More value = image.jpg
The number of values, the code shown - not mandatory.
Format independent attributes: Attribute: Meaning: Action: Price. Several attributes are specified with the separator "|" (without the quotes). All previous values of attributes in product upgrade - removed. Actions may include: +, -, *, /, =,%
For example: Color: Blue: +: 50.00 | Color: Red :/: 2.00 | Size: M: -: 10.00 | Size: S: *: 2.00
{slide=add_attributes}
To add independent attributes. Being specified in the column list of independent attributes, these attributes will be added to is not dead.
{slide=free_attributes}
Free attributes. Listed in the help of the separator character "|" (without the quotes). Only used the name of free attributes.
Can take any value
{slide=extra_fields}
Characteristics. Include product characteristics with the separator "|" (without the quotes) in the form of separate units: Feature: Option. For multi-selection options can be listed by zyapyatuyu.
Color: Red, Black | Size: 56.62
{/slides}