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,
Please load the attached patch file so you can get "show_on_pdetails" as an available field for export. Make sure that your run update of available fields after applying the patch file.

And are you planning to add this patch to original CSVI pro?
I believe that every time we will update CSVI pro these changes will be overwritten?

yes, these changes will be included in next CSVI release so it is available even after you update CSVI.

patch_vm_shipment_params_2017_04_13.zip
Attachments (1)
patch_vm_shipment_params_2017_04_13.zip
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
Thanks Tharuna, finally i was able to export and import shipping prices.

Do yo have eta when you are planning to release new CSVI release?

Sandra
  1. more than a month ago
  2. RO CSVI
  3. # 22
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Sandra,
Happy to hear that your issues are solved. We are still working on our new features so i cannot give you an exact ETA as of now but i can assure you that the changes given to you as patch will be included in the upcoming CSVI release. Also, would appreciate if you can give us an review on Joomla extension directory.
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!