- Posts: 146
- Thank you received: 2
Importing Products with Tab Descriptions
11 years 7 months ago #188933
by sison2466
Importing Products with Tab Descriptions was created by sison2466
-- url of the page with the problem -- :
www.intelligenthustler.com/TEST_SERVER/T...product/hosiery-1872
-- HikaShop version -- : 2.3.5
-- Joomla version -- : 3.3.6
-- PHP version -- : 5.3.29
I searched the forum and found topics about using tabs, but it was mentioning changing the display views, so I think it might be a different "tab" than I am trying to figure out.
I was able to add tabs to my product description as seen on this product.
www.intelligenthustler.com/TEST_SERVER/T...osiery-1872#material
I did this using my editor in the product page in the back-end using this syntax.
{tab Tab Title 1}
<p>Your text...</p>
<p>{tab Tab Title 2}</p>
<p>Your text...</p>
<p>{/tabs}</p>
However, that would be a very slow way to change 1000s of products. I was trying to import the description using a CSV (using mass action). I did a copy paste on the export of the product, so I should have the exact same format and syntax, but when I import I get the error messages attached.
Can I import tab descriptions using CSV? Did I have the mass action import settings incorrect? Is there a better way to quickly be able to change the descriptions?
-- HikaShop version -- : 2.3.5
-- Joomla version -- : 3.3.6
-- PHP version -- : 5.3.29
I searched the forum and found topics about using tabs, but it was mentioning changing the display views, so I think it might be a different "tab" than I am trying to figure out.
I was able to add tabs to my product description as seen on this product.
www.intelligenthustler.com/TEST_SERVER/T...osiery-1872#material
I did this using my editor in the product page in the back-end using this syntax.
{tab Tab Title 1}
<p>Your text...</p>
<p>{tab Tab Title 2}</p>
<p>Your text...</p>
<p>{/tabs}</p>
However, that would be a very slow way to change 1000s of products. I was trying to import the description using a CSV (using mass action). I did a copy paste on the export of the product, so I should have the exact same format and syntax, but when I import I get the error messages attached.
Can I import tab descriptions using CSV? Did I have the mass action import settings incorrect? Is there a better way to quickly be able to change the descriptions?
Please Log in or Create an account to join the conversation.
11 years 7 months ago #188945
by nicolas
Replied by nicolas on topic Importing Products with Tab Descriptions
Hi,
It looks correct and the normal import imports that file properly:
take.ms/pmMUm
However, the mass actions CSV import is less advanced and doesn't support such complex fields: several lines for a field, with both the separator and the double quotes in the field. That requires a complex parsing of the CSV file which the mass actions system doesn't have.
How about trying to import it via the normal CSV import screen ?
It looks correct and the normal import imports that file properly:
take.ms/pmMUm
However, the mass actions CSV import is less advanced and doesn't support such complex fields: several lines for a field, with both the separator and the double quotes in the field. That requires a complex parsing of the CSV file which the mass actions system doesn't have.
How about trying to import it via the normal CSV import screen ?
Please Log in or Create an account to join the conversation.
11 years 7 months ago #189050
by sison2466
Replied by sison2466 on topic Importing Products with Tab Descriptions
I get an error message
1136 Column count doesn't match value count at row 1 SQL=INSERT IGNORE INTO iheart_hikashop_product_related (`product_related_id`,`product_related_type`,`product_id`) VALUES ()
1136 Column count doesn't match value count at row 1 SQL=INSERT IGNORE INTO iheart_hikashop_product_related (`product_related_id`,`product_related_type`,`product_id`) VALUES ()
Please Log in or Create an account to join the conversation.
11 years 7 months ago #189052
by nicolas
Replied by nicolas on topic Importing Products with Tab Descriptions
Hi,
Change the lines:
if( $totalValid%$this->perBatch == 0){
to:
if( $totalValid && $totalValid%$this->perBatch == 0){
in the file administrator/components/com_hikashop/helpers/import.php and that will fix that problem.
Change the lines:
if( $totalValid%$this->perBatch == 0){
to:
if( $totalValid && $totalValid%$this->perBatch == 0){
in the file administrator/components/com_hikashop/helpers/import.php and that will fix that problem.
Please Log in or Create an account to join the conversation.
11 years 7 months ago #189562
by sison2466
Replied by sison2466 on topic Importing Products with Tab Descriptions
That worked. Thank you.
Please Log in or Create an account to join the conversation.
Time to create page: 0.157 seconds