Categories
View Replies (23)

Resolved Export Shipping prices

  1. sohopros
    sohopros
  2. RO CSVI
  3. Friday, 31 March 2017
  4.  Subscribe via email
Hi,

I am trying it export shipping prices but getting following error:

Unknown column '#__virtuemart_manufacturers.published' in 'where clause' SQL=SELECT `#__virtuemart_shipmentmethods`.`virtuemart_shipmentmethod_id`, `shipment_params` FROM `#__virtuemart_shipmentmethods` LEFT JOIN `#__virtuemart_shipmentmethods_en_gb` ON `#__virtuemart_shipmentmethods_en_gb`.`virtuemart_shipmentmethod_id` = `#__virtuemart_shipmentmethods`.`virtuemart_shipmentmethod_id` WHERE `#__virtuemart_manufacturers`.`published` = 1 GROUP BY `#__virtuemart_shipmentmethods`.`virtuemart_shipmentmethod_id`

Template fields:
virtuemart_shipmentmethod_id
shipment_params

I am using CSVI 7.0.2 and Virtuemart 3.2.1. (With Virtuemart 3.0.18 shipping price exporting is correct)

Please advise,
Sandra
0
Responses (23)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Sandra,
Can you post me your export template XML file to check? To get template XML file go 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.
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. # 21
sohopros
sohopros
Accepted Answer Pending Moderation
Hi Tharuna,

Yes, we have "Published" field in "virtuemart_manufacturers" table.

Any other thoughts?

Please advise,
Sandra virtuemart_manufacturers_published-field.PNG
Attachments (1)
virtuemart_manufacturers_published-field.PNG virtuemart_manufacturers_published-field.PNG
  1. more than a month ago
  2. RO CSVI
  3. # 22
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Sandra,
There seems to be a missing field in your `#__virtuemart_manufacturers` table. Can you go to your phpmyadmin, look for `#__virtuemart_manufacturers` table and check if there is published field?
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. # 23
  • Page :
  • 1
  • 2


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