Categories
View Replies (15)

Resolved Shipping for Google Base Export

  1. sandstorm871
    sandstorm871
  2. RO CSVI
  3. Friday, 18 March 2016
  4.  Subscribe via email
Only similar question I can see in the CSVi forum is here - https://www.csvimproved.com/forum?view=topic&catid=44&id=32645#45863

I need to export shipping price for Virtuemart > Google Base/Merchant, but there doesn't seem to be anyway to do this from the Virtuemart Product Export. The only field available is "custom_shipping" which doesnt export anything.

I assume that this is going to be difficult, especially where there are multiple shipping rates, for multiple countries.

For me, I need to concentrate on UK only & the exported shipping price needs to be populated with the cheapest available shipping rate for that specific product.

Any ideas? :dry:
Andy
0
Responses (15)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Andy,

I assume that this is going to be difficult, especially where there are multiple shipping rates, for multiple countries.
Yes, there is currently no support for that.

I need to export shipping price for Virtuemart > Google Base/Merchant
How is the shipping price determined in your case? Using a shipping plugin?

Any ideas? :dry:
Let's see what we can do.
Kind regards,

RolandD

=========================
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
sandstorm871
sandstorm871
Accepted Answer Pending Moderation
For the Google Base/Merchant export, these need to be done per country anyway, so if we assume that we will use UK only.

We somehow need to export a shipping price per product. The google merchant center wants to see the cheapest available price for the individual product.


  1. Our products all use the default virtuemart shipping plugin.

  2. Our products all have a weight assigned to them.

  3. There are many different shipping methods, dependant upon weight of the individual product.



We cannot trick google and add a default/custom price, as somehow they know what the price should be already, they just want us to confirm it via this XML feed
  1. more than a month ago
  2. RO CSVI
  3. # 2
rolandd
rolandd
Accepted Answer Pending Moderation
Hey Andy,

as somehow they know what the price should be already, they just want us to confirm it via this XML feed
Google knows everything about us. Check the video on the Google Toilet in case you haven't seen it yet ;)

I am going to setup a small test system and see what I can come up with. Will touch base when I have more info for you.
Kind regards,

RolandD

=========================
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. # 3
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Andy,

A little update here, I have been looking into this can of worms. The code is hard to follow and almost like quicksand :) So far I have just been running stuck.

Just a few questions, the standard shipping method has a myriad of options that are used to determine the shipping rate. One important one I think is the country and zip ranges. We would need to know the destination address to know the shipping rate. On export you never know where you are going to ship. I mean shipping within the UK is cheaper than shipping it to the US for example. How would Google deal with that?
Kind regards,

RolandD

=========================
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. # 4
sandstorm871
sandstorm871
Accepted Answer Pending Moderation
I mean shipping within the UK is cheaper than shipping it to the US for example. How would Google deal with that?


It is the shop owners responsibility to create a new xml feed for each country.
So you can always assume one country for this export.

I'm on skype if you need to buzz me about anything, help or test :)
  1. more than a month ago
  2. RO CSVI
  3. # 5
rolandd
rolandd
Accepted Answer Pending Moderation
To round this up. The shipping rates are calculated and exported now. This feature will be released with CSVI 6.6.0.
Kind regards,

RolandD

=========================
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. # 6
sandstorm871
sandstorm871
Accepted Answer Pending Moderation
I know a lot of time & hard work went into this & really appreciate it.
I can see this being used in many sites. ;)
  1. more than a month ago
  2. RO CSVI
  3. # 7
Comenaranjas
Comenaranjas
Accepted Answer Pending Moderation
Hello. Would be great to have some updated info related to the creation of the feed for google. I followed the old tutorial here but would be nice to have a template or basic config. I never managed to create the feed correctly using csvipro, was always marked with many errors. I tried both xml and csv. Actually shipping is quite simple since you can define it directly in google merchant center.
  1. more than a month ago
  2. RO CSVI
  3. # 8
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

Andy will provide us with some detailed instructions once he is ready. A sample template can be done but will completely depend on the type of products you sell. As you will know Google requires different fields depending on the type of product you are selling.

Actually shipping is quite simple since you can define it directly in google merchant center.
In this case you get the exact shipping rates for a particular product.
Kind regards,

RolandD

=========================
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. # 9
Comenaranjas
Comenaranjas
Accepted Answer Pending Moderation
Thanks, that would be great cause we never managed to set it up and I have a friend customer of you also that has been able to set it up... so is possible but he still told me he had to do it in csv cause in xtml google rejected the feed.

I agree that google requires different fields but actually the required ones are pretty much the same for all type of products https://support.google.com/merchants/answer/1344057?hl=en

Regards
  1. more than a month ago
  2. RO CSVI
  3. # 10
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

Without knowing about the reason for the XML reject, I can't say anything about it of course or do anything about it. This may be a good nudge towards Andy to see what the status is. Andy?
Kind regards,

RolandD

=========================
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. # 11
Comenaranjas
Comenaranjas
Accepted Answer Pending Moderation
In your latest version the export for google base was fixed it seems but there are any template samples available or docs? Sandstorm went on holidays it seems.

Regards
  1. more than a month ago
  2. RO CSVI
  3. # 12
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
We are still waiting on document from Andy. Please have a look at Google base export document, it should help you to create google export file.
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. # 13
sandstorm871
sandstorm871
Accepted Answer Pending Moderation
Sorry, I Started it, but never finished it :(
Summer Hol's. Kids starting new school & general day to day stuff, pushing this donw my todo list.

I still dont have it working perfectly well, but will look to update/finish my walkthrough ASAP

I'll post it back here when done & hopefully this can be improved upon & help others too.

My Skype is "sandstorm871" if you want to contact me direct, I can export my template & show you my setup over screenshare.
  1. more than a month ago
  2. RO CSVI
  3. # 14
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Andy,

Thank you for stepping in. If there is anything I can do to help please let me know.
Kind regards,

RolandD

=========================
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. # 15
  • Page :
  • 1


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