Categories
View Replies (1)

Resolved Exporting greater of actual or cubic weight to Google Shopping

  1. Typhoon365
    Typhoon365
  2. RO CSVI
  3. Saturday, 23 September 2017
  4.  Subscribe via email
Hi,

In Virtuemart for each product we set "Product Weight" field as the actual weight of the product and "Product Packaging" field as the cubic weight of the product (ie. length x width x height x 250).

For our shipping calculations in Virtuemart we used whichever is the larger value from these two fields to calculate shipping cost (using Advanced Shipping Rules plug-in)

In our csvi export to Google Shopping we would like to set "shipping_weight" export field to the greater value of "Product Weight" and "Product Packaging".
So we can set shipping costs in Google Merchant Centre to more closely align with Virtuemart.

Any ideas best way of doing this ?

Does CSVI export have any functionality for calculating values on export (ie. max(Product Weight, Product Packaging)?
Or rules that can look at values from multiple fields to select highest value ?

Appreciate any assistance or guidance. Thank you.
0
Responses (1)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
CSVI has conditional rule plugin to check if the value of the field is greater and replace it with given value or field but i guess it may not help in your case. You are looking at compare and get greater of two fields.

There are two ways of handling it, one is that you create your own rule plugin and add conditions as needed.

Other way is that you create an override file for your export and add custom code to check Product Weight and Product Packaging fields and export it for shipping_weight.
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
  • Page :
  • 1


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