Importing Products with Tab Descriptions

  • Posts: 146
  • Thank you received: 2
9 years 9 months ago #188933

-- 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.

</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?

Attachments:

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
9 years 9 months ago #188945

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.

  • Posts: 146
  • Thank you received: 2
9 years 9 months ago #189050

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.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
9 years 9 months ago #189052

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.

  • Posts: 146
  • Thank you received: 2
9 years 9 months ago #189562

That worked. Thank you.

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

Time to create page: 0.041 seconds
Powered by Kunena Forum