Resolved Field mapping for Google Merchant

Hello,

- I need first to upload a file before I can map. Does this mean I first have to duplicate my Merchant to make it a csv export to import in the mapping area?

Yes you need to upload your csv file before mapping, CSVI will identify the column headers in your file and gives an option of mapping to database fields. You can check field mapper documentation to know on the same.

- I did above step and it won't read my fields:
http://www.evernote.com/l/AnMJhmQJ-EJCo5Ag1Cijt419de9thKuvIYU

Your CSV file dont seem to be a valid one. The first few characters at the beginning shows that the file is UTF-8Y, also known as a Byte Order Mark(BOM) file. You have to first save your file as a normal UTF-8 file before doing the import.

- If I have products in stock, how do I just get 'in stock' for the products that have stock? (Because default it would have a number value of stock)And if I don't use stock how will it show 'in stock' (because I have unlimited)

Are these for exporting your products? Because for import VirtueMart takes only numbers into the database for product_in_stock field. There is a way in CSVI to handle this, You can create a rule using CSVI value comparison plugin to replace number with text you want. Apply this rule on product_in_stock field in your template fields and that should do it. The question is that you want it for export or import.

Hi Rolandd,

Thanks. Yes it is for export to Google Merchant, seems I need to let know if product is in stock yes or no. So if value =>1 I would like just to send 'in stock'. Could you tell me how to do this and thanks again!

Hello,
You need to create a rule for this using CSVI Value comparison plugin. To do that go to CSVI rules page and click New, give a name to your rule, select Action as export, plugin as CSVI value comparison and click load plugin button. Select the comparison you want, old value to be 1 and new value as 'In stock', Save the rule. Now go to your export template fields and apply this rule on product_in_stock field. When you do a export CSVI will check the values in database and replace with new value for product_in_stock field as set in the rule. Let me know how it goes.

Thanks for this.

I'm now trying to map fields to how Google names them. But I can't find where to set in CSVI how Google names it, following:
https://csvimproved.com/support/export/204-virtuemart/831-creating-a-google-base-export-file

This is how it looks now:
https://www.evernote.com/l/AnPoBEAhdIlIMav4AhtcxWqZGm6kL1MtnTM

Thank you in advance.

Hello,

You are mixing two things up. The Field Mapper is only to map the fields, not to configure them. To configure the fields you need to to go the Template fields page. There you can set the field name you want to use for export (the Google name in your case).

The Google base document is on our list to update.