https://help.x-cart.com/index.php?title=LiteCommerce:Importing_Product_Extra_Fields&feed=atom&action=historyLiteCommerce:Importing Product Extra Fields - Revision history2024-03-28T13:18:26ZRevision history for this page on the wikiMediaWiki 1.31.5https://help.x-cart.com/index.php?title=LiteCommerce:Importing_Product_Extra_Fields&diff=7921&oldid=prevDohtur at 08:45, 31 May 20122012-05-31T08:45:24Z<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #222; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #222; text-align: center;">Revision as of 08:45, 31 May 2012</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1" >Line 1:</td>
<td colspan="2" class="diff-lineno">Line 1:</td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">{{LC2_disclaimer}}<br /><br /></ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>A list of extra fields of the catalog products can also be imported into the store database from a CSV file. The CSV file must be formatted in such a way that every line in the file would contain the definition of a single product extra field. Imported product extra fields are matched to catalog products by the combination of the 'product' (product name) and 'category' fields. To define a global extra field, specify empty product name in the 'product' field.</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>A list of extra fields of the catalog products can also be imported into the store database from a CSV file. The CSV file must be formatted in such a way that every line in the file would contain the definition of a single product extra field. Imported product extra fields are matched to catalog products by the combination of the 'product' (product name) and 'category' fields. To define a global extra field, specify empty product name in the 'product' field.</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr>
</table>Dohturhttps://help.x-cart.com/index.php?title=LiteCommerce:Importing_Product_Extra_Fields&diff=1877&oldid=prevIvka: Created page with 'A list of extra fields of the catalog products can also be imported into the store database from a CSV file. The CSV file must be formatted in such a way that every line in the f…'2010-01-19T09:16:06Z<p>Created page with 'A list of extra fields of the catalog products can also be imported into the store database from a CSV file. The CSV file must be formatted in such a way that every line in the f…'</p>
<p><b>New page</b></p><div>A list of extra fields of the catalog products can also be imported into the store database from a CSV file. The CSV file must be formatted in such a way that every line in the file would contain the definition of a single product extra field. Imported product extra fields are matched to catalog products by the combination of the 'product' (product name) and 'category' fields. To define a global extra field, specify empty product name in the 'product' field.<br />
<br />
=== Example ===<br />
<br />
Let's assume that we created an "ISBN" global extra field and assigned it to the "Books/Internet" and "Books/Software" categories. This is an example of a CSV file with the following exported fields: "name, SKU, category, product, value, default value, enabled, order by":<br />
<br />
<br />
<tt>"ISBN";"";"Books/Internet|Books/Software";"";"";"0123";"1";"0";""<br />
<br />
"ISBN";"";"Books/Software";"Flash 5 for Windows and Macintosh";"0123";"0123";"1";"0";""<br />
<br />
"ISBN";"";"Books/Internet";"HTML 4 for the World Wide Web";"0123";"0123";"1";"0";""</tt><br />
<br />
<br />
The first line contains data which describe the global extra field - as you can see there is no information about product name. Other lines contain data which describe non-global extra fields associated with particular products.<br />
<br />
Once the import engine has found the line which contains a name and a category and doesn't contain a product name, this line will be treated as a global extra field and the import engine will create the "ISBN" global extra field for "Books/Internet" and "Books/Software" categories.<br />
<br />
The next lines contain data for child extra fields and the import engine will create the "ISBN" extra field for particular products and associate those extra fields with the "ISBN" global extra field which was created before.<br />
<br />
<br />
'''To import the list of extra fields follow the instructions provided below:'''<br />
<br />
# Click on the ''''Import catalog'''' link in the ''''Catalog'''' menu.<br />
# Choose the ''''Import extra fields'''' tab (Figure 5-35).<br />
# Specify the order of parameters of product extra fields parameters as they appear in the CSV file. The remaining fields must be set to 'NULL'. Once you have specified the correct field order, you can click on the ''''Save field order'''' button to make LiteCommerce remember it. If you have previously saved the order of data fields in the ''''Import extra fields'''' form, correctly ordered fields will appear automatically.<br />
# Select the delimiter and the text qualifier that are used in the CSV file.<br />
# Choose the CSV file to import. If the file is located on the server, enter its location in the ''''File (CSV) local'''' field. If the CSV file is located on your local computer, click on the ''''Browse…'''' button next to the ''''File (CSV) for upload'''' field to locate the file.<br />
# Click on the ''''Import fields'''' button to import extra fields from the CSV file. Depending on amount of data in the file, import process can take up to several minutes.<br />
<br />
<div><div align="center">[[Image:lc22-5-35.gif|600px|Figure 5-35: Importing product extra fields]]<br />
<br />
Figure 5-35: Importing product extra fields<br />
</div></div><br />
<br />
[[Category:LiteCommerce user manual]]</div>Ivka