1. gjr
  2. RO CSVI
  3. Tuesday, 11 August 2015
  4.  Subscribe via email
Hi Roland,

One of our clients contacted us about changing his Google Shopping feed to add GTIN numbers. We currently export his Virtuemart products with CSV Improved Pro, which works fine. Adding GTIN numbers is not the problem and should be a matter of minutes to add as exportfield, but here's the thing: some products don't have a GTIN and should have another field instead of the GTIN fieldm which is "identifier-exists". So what we basically want to achieve which CSV Improved is to export GTIN as a field, but IF the GTIN number doesn't exist THEN add identifier-exists field instead. This last field always has the same value "FALSE".

Is there a way to do this or is it possible for you to develop such option?

Hope to hear from you soon.

Best regards,

Rob
GJ-R Webdevelopment
Accepted Answer Pending Moderation
Hello Rob,

The one thing I am thinking of that you might be able to use is the replacement rules. You would create a regular expression rule and check if the value doesn't start with a number or letter (don't know how the GTIN is build up). If it doesn't start with that, then fill in the value FALSE. That is perhaps something you can try. In that case you don't need the identifier-exists field either.
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
Accepted Answer Pending Moderation
Hi Roland,

Google demands that the GTIN field does not exist if there's no GTIN number, so your solution would be insufficient. I think we'll have to build our own script to generate the XML feed, in which we can add the IF ELSE statement. Thank you for effort though.
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,

Ok, in the first post you said if the GTIN doesn't exist, it should show false.

I think we'll have to build our own script to generate the XML feed
You can still use CSV but create an override in which you can put your own changes.
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
  • Page :
  • 1


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