• Resolved Chris

    (@mastertechmag)


    When setting up fields to export, for products, we select to export the “Short Description.”

    For some reason the short description content is repeated 3-4 times within the exported short description cell.

    Anyone know why? And, how to fix?

    Thanks.

Viewing 9 replies - 1 through 9 (of 9 total)
  • Plugin Author algol.plus

    (@algolplus)

    hi Chris

    If you view this product as visitor, do you see short description only once?

    Could you put following code to section “Misc Settings” and press button “Preview” ?
    Will you see description only once ?
    thanks, Alex

    add_filter('woe_get_order_product_value_post_excerpt', function ($value, $order, $item, $product,$itemmeta) {
    	var_dump($value); die("debug");
    },10, 5);
    Thread Starter Chris

    (@mastertechmag)

    Thanks.
    Yes, we see the short description only once, when viewing the product page.

    First attempt of putting the code in and pressing the “Preview” button, the following message returned:

    string(372) “Customized Volvo TechTips – Summer 2018 Issue Volvo dealers enrolled in the Wholesale Marketing program are entitled to 50 customized issues free of charge. If you are interested in growing your wholesale parts business, and you are not enrolled in the Wholesale Marketing Program, you can still order customized issues; the net cost is $8 per copy. ” debug

    This was weird, as it refers to a product that wasn’t causing a problem of repeating short descriptions in the export file.

    At first, I thought the “(372)” was product number related. But, the product listed, has a different number. But, after reviewing the product, there were multiple, empty <div></div> tags in the short description.

    After removing these tags, and previewing the test again, I get the following message:

    string(351) “Customized Volvo TechTips – Summer 2018 Issue Volvo dealers enrolled in the Wholesale Marketing program are entitled to 50 customized issues free of charge. If you are interested in growing your wholesale parts business, and you are not enrolled in the Wholesale Marketing Program, you can still order customized issues; the net cost is $8 per copy.” debug

    Hope that helps…

    Thanks for your help!!

    Plugin Author algol.plus

    (@algolplus)

    hi Chris
    thank you for detailed reply.

    372 and 351 are just numbers. they show length of string in quotes.

    So you have problem with some products only.
    Please, replace previous code with this version and press Preview.
    Put actual product id instead of XXX !
    thanks, Alex

    add_filter('woe_get_order_product_value_post_excerpt', function ($value, $order, $item, $product,$itemmeta) {
          if($product->get_id() == XXX) {
    	var_dump($value); die("debug");
          }
    },10, 5);

    Thanks for explaining, Alex.

    Unfortunately, the problem is with all the product short descriptions. But, we’re only in need of fixing a select few, for our purposes.

    I’ve entered the code, replaced “XXX” with my product ID # and clicked the “Preview” button. Here’s the result:

    string(381) “Message Option 1 Body: We hope you enjoy the latest Volvo TechTips! [Dealer Name] Wholesale Parts Department is determined to earn your business the old fashioned way – by delivering value – Genuine Volvo Parts and service information to help you fix Volvo vehicles right, the first time. Thanks! We appreciate your business. [Dealer Name] [Dealer Phone] ” debug

    Is there a certain piece of info I should be looking for to help diagnose this problem?

    When putting the code in, I am not able to export a new file. So, I assume we’re looking for a return of data to help diagnose?

    Thanks.

    Plugin Author algol.plus

    (@algolplus)

    hi Chris

    Yes, please, remove this code from section “Misc Settings”.

    As we see , there are no duplicates when we pull data from database.

    Please, contact me via helpdesk and attach job settings ( use tab Tools).

    thanks, Alex

    • This reply was modified 6 years, 3 months ago by algol.plus.

    Thanks. I submitted a support request.

    Plugin Author algol.plus

    (@algolplus)

    Exported file is correct ( verified by MS Excel, Google SpreadSheet and LIbreOffice).

    Customer used OpenOffice , so he installed LibreOffice, and the file seems to open correctly. Must have been an OpenOffice Error of some kind.

    Thread Starter Chris

    (@mastertechmag)

    Confirmed.
    If anyone is out there using OpenOffice, and experiencing content duplication in the cells, try using LibreOffice.

    Thread Starter Chris

    (@mastertechmag)

    PS – Thanks!!

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Short Description Export Repeats’ is closed to new replies.