Skip to main content

Importing Products with Tab Descriptions

More
11 years 7 months ago #188933 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?

Please Log in or Create an account to join the conversation.

More
11 years 7 months ago #188945 by nicolas
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 ?

Please Log in or Create an account to join the conversation.

More
11 years 7 months ago #189050 by sison2466
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 ()

Please Log in or Create an account to join the conversation.

More
11 years 7 months ago #189052 by nicolas
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.

Please Log in or Create an account to join the conversation.

More
11 years 7 months ago #189562 by sison2466
That worked. Thank you.

Please Log in or Create an account to join the conversation.

Time to create page: 0.274 seconds
Powered by Kunena Forum