Hi,
I am using nopCommerce v1.60.
I have over 1500+ products instore that i need to upload to Google Merchant Center.
I would like to be able to upload these in the file format .txt using a spreadsheet but cannot see where i can get the right information from the database to put in the spreadsheet.
I only want to upload the required attributes for Google which are:
id [id]
title [title]
link [link]
price [price]
description [description]
condition [condition]
PLUS
image link [image_link]
I can see from the database that the ProductId would be the id [id] which would then match to title, price, description & i would set condition as 'New' for everything.
But I cannot see where or how to get the relative url for link [link] and image link [image_link]
to match to each id.
Example for the link [link] and image link [image_link] for one product instore that i would need to add to id in the spreadsheet would be:
http://www.mydomain.com/products/aproduct.aspx
&
http://www.mydomain.com/images/thumbs/aimage.jpg
Any help would be greatly appreciated or maybe there is an easier way i can upload data feeds with product links & images.
With Thanks
Laura
Google Merchant Center - Data Feeds
- 52
- 310
- 04.03.2011
- United Kingdom
laura1 wrote:
Hi Laura,
I'm trying to understand all this as well and it seems to me that you've worked out more than I have already but, I can't see why the example URL's you have given above for the product link and the image link shouldn't be the link and image link you are looking for. Maybe I've missed something.
Hi,
But I cannot see where or how to get the relative url for link [link] and image link [image_link]
to match to each id.
Example for the link [link] and image link [image_link] for one product instore that i would need to add to id in the spreadsheet would be:
http://www.mydomain.com/products/aproduct.aspx
&
http://www.mydomain.com/images/thumbs/aimage.jpg
Any help would be greatly appreciated or maybe there is an easier way i can upload data feeds with product links & images.
With Thanks
Laura
But I cannot see where or how to get the relative url for link [link] and image link [image_link]
to match to each id.
Example for the link [link] and image link [image_link] for one product instore that i would need to add to id in the spreadsheet would be:
http://www.mydomain.com/products/aproduct.aspx
&
http://www.mydomain.com/images/thumbs/aimage.jpg
Any help would be greatly appreciated or maybe there is an easier way i can upload data feeds with product links & images.
With Thanks
Laura
Hi Laura,
I'm trying to understand all this as well and it seems to me that you've worked out more than I have already but, I can't see why the example URL's you have given above for the product link and the image link shouldn't be the link and image link you are looking for. Maybe I've missed something.
- 52
- 310
- 04.03.2011
- United Kingdom
I have managed to upload a data feed with only a few item warnings.
The URL I got by just navigating to the product in my site and copying + pasting the URL from the browser window, no problem.
Another issue I encountered is that EAN's are now required and my items have old-fashioned 8 digit EAN's instead of the new-fangled 13 digit ones. I seem to have overcome this by adding a string of 0's before the number.
My problem is that I cannot access url's for the images and seem to have no access to the images on my admin side at all (Nop 1.9).
Any ideas anyone?
The URL I got by just navigating to the product in my site and copying + pasting the URL from the browser window, no problem.
Another issue I encountered is that EAN's are now required and my items have old-fashioned 8 digit EAN's instead of the new-fangled 13 digit ones. I seem to have overcome this by adding a string of 0's before the number.
My problem is that I cannot access url's for the images and seem to have no access to the images on my admin side at all (Nop 1.9).
Any ideas anyone?