Categories
View Replies (2)

Resolved Exporting product sku and product name

  1. analinst
    analinst
  2. RO CSVI
  3. Thursday, 26 January 2017
  4.  Subscribe via email
Joomla 3.6.5, virtuemart 3.0.18, csvi pro 6.6.4

I'm having trouble exporting (just) the 'product sku' and 'product name'. It seems that these options are under different sections in csvi. Any input on how to do this would be appreciated.
What I see now when I try to set up a template with: product_name, Product_sku, I see this; Unknown column 'description' in 'field list' SQL=SELECT `description`, `name`, `product_availability`, `product_desc`, `product_in_stock`, `product_mpn`, `product_name`, `product_sku`, `product_unit`, `published` FROM `#__virtuemart_products_en_gb` GROUP BY `description`,`product_desc`,`product_name`,`product_sku` LIMIT 1279
0
Responses (2)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Not sure how you got these fields name and description as there are no such database fields in VirtueMart tables and so there is an SQL error. Where do you see this error? Can you post a screenshot? Can you also send your template XML file? To get template XML file got to CSVI maintenance page, Select CSVI Pro on first option and Backup template on second option. Select your template and click continue. Download the XML file and post it here.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
analinst
analinst
Accepted Answer Pending Moderation
This was my error. I figured it out. I made the mistake of thinking 'group fields' and ' sort fields' were the same as adding fields the problem is resolved.
  1. more than a month ago
  2. RO CSVI
  3. # 2
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!