You are here:  » Merchant Mapping


Merchant Mapping

Submitted by mikecdprice on Mon, 2013-08-12 14:30 in

Hello David,

Is it possible to Merchant Map. I saw one said the store name and said affiliate program? ;) How can I transform this if it is in a csv with 3 other merchants.

Thank you,
Michael

Submitted by support on Mon, 2013-08-12 14:32

Hi Mike,

Use a Search and Replace filter on the Merchant Field for that feed to replace "Affiliate Program" with the actual merchant name!

Cheers,
David.
--
PriceTapestry.com

Submitted by mikecdprice on Mon, 2013-08-12 15:25

Hello David,

That is what I was trying to do. I never created an additional field for Merchant Name. Only selected it in the feed from the top. Do I need to create an additional field for Merchant Name to overwrite the imported one selected in merchant name during import?

Merchant name, Store or Program name is not listed in the filter drop downs on in any areas.

Thank you,
Michael

Submitted by support on Mon, 2013-08-12 15:37

Hi Michael,

My apologies - to modify so that filters can be applied to Merchant, if you edit admin/feeds_filters.php and look for the following code at line 62:

  $fields = array();

...and REPLACE with:

  $fields = array();
  if ($feed["field_merchant"])
  {
    $fields["merchant"] = "Merchant (".$feed["field_merchant"].")";
  }

Finally, (it's exactly the same change) in admin/feeds_filters_configure.php look for the following code at line 24:

  $fields = array();

...and REPLACE with:

  $fields = array();
  if ($feed["field_merchant"])
  {
    $fields["merchant"] = "Merchant (".$feed["field_merchant"].")";
  }

You'll then be able to add filters to the Merchant field where it has been selected as a field rather than manually input.

Cheers,
David.
--
PriceTapestry.com

Submitted by mikecdprice on Mon, 2013-08-12 17:05

Hello David,

Wonderful. Thank you for your help!

Submitted by mikecdprice on Wed, 2013-08-14 13:38

Hello David,

I tried to do the above code and I cannot get to change the imported Merchant Text. I am having an issue with Merchant names saying things like DBA, Affiliate Program and US/UK or CA. I am also finding duplicate merchants from different networks.

Should I not a mult-merchant feed and try to focus on limited to one for each to avoid this issue?

I tried to change the names, name the same and also drop - No variations are working.

Any ideas?

Submitted by support on Wed, 2013-08-14 14:15

Hello Mike,

It sounds like it may in fact be a mis-registered feed - for example where only some data is quoted and therefore not picked up by the feed format auto-detected on Feed Registration Step 1. To see if that's the case, try re-registering the feed that is resulting in the weird merchant names, but instead of accepting the auto-detected Format String select the actual format from the drop-down box, for example "Quoted Text - Header Row - Comma Separated". Then re-register and re-import and that might be all it is...

Cheers,
David.
--
PriceTapestry.com

Submitted by mikecdprice on Wed, 2013-08-14 15:59

Hello David,

I tested exactly what you said. It still does not change the merchant name.

For example it shows:

Working Persons Store

WorkingPerson.com

I wanted them to both say WorkingPerson.com so they would be the same and add what is not a duplicate.

Thank you,
Michael

Submitted by mikecdprice on Wed, 2013-08-14 16:02

Hello David,

I wish there was a global 'Merchant Mapping' filter function like the categories and the products. That way it would look at the merchant names and resolve them to the same.

Thank you

Submitted by support on Wed, 2013-08-14 16:32

Hi Mike,

Very strange for the merchant name to be specified differently in the same feed! But just like applying category mapping to brands is no problem, the same can be easily done for merchant name - if you'd like to email me your latest includes/admin.php I'll add that for you...

Cheers,
David.
--
PriceTapestry.com