Missing fields available in OPUS:¶

• CategoryPageUrl
• ExternalId
• ProductPageUrl
• ImageUrl

Brands¶

For now, the brands processing is not clear for us. @Olena, please, formalize it for us in this ticket.

After yesterday call with @Yurii, I will add familyURL and @Yurii will add product name on Russian.

one of these characteristics should be used as an attribute "Brand"
in case if more than one attribute will be found for the product, we should take in consideration only the first one.

W10356
W12741
W11830
W10352
W12885
W10356
W12819
W11299
W10308
W12314
W12315
W13377
W13414
W10103
W11198
W11489
W11831
W10736
W12263
W12668
W12244
W12250
W12325

steps in project dataflow:

1. Extract WikeoMetrics2 - text.csv, image.csv (by WikeoMetrics2 app)
2. Integrate Wikeometrics2 to BO (by BO)
3. In BO add EAN etc (by BO)
4. Export Bazaarvoice_Status.csv (by BO)
5. Convert CSV to XML to get Bazaarvoice_Status.xml (by XML4BZV converter)

by the way, the existing WebCatalogueStatus file remains intact.
it keeps all the same data on the output, by ignoring all 8 new incoming fields added for this project

5. Need to check data in the test.xml file. Choose three different objects of each model(product, brand, category) and compare these objects in .csv and .xml files. After that write the results in this ticket with externalID for each object.

8. In the xml file change name="LeroyMerlinUkraine_feed" to name="leroymerlin-ua"
9. In the xml file date must in the format 2019-02-21T08:15:01.516
10. In the xml file delete line <!DOCTYPE Feed SYSTEM "yes">
11. In the xml file line with feed must be in the format "<Feed extractDate="2018-12-12T08:15:01.516" name="leroymerlin-it" incremental="false" xmlns="http://www.bazaarvoice.com/xs/PRR/ProductFeed/5.6&quot;&gt;"

Basecamp

https://3.basecamp.com/4056726/projects/12935458

Hi all,

Thanks for your attention during the call yesterday. You'll find attached the deck presented yesterday.

I'm pleased to annouce that your instance is provisionned and that Ricardas our technical consultant has been assigned to the project. We can therefore organize the technical engagement next week. As discussed yesterday, could you please:
• Get back to us with some availability next week so we organize the technical engagement call?
• Provide us here with your product feed so we can check immediatly if it's correct?
• Regarding the business tasks, you're well advanced due to the benefits of previous Adeo business units, but we need to discuss about the config hub and get your questions translated (unfortunately they're not available by default in Ukrainian and Russian). Could you give me a couple of slots next week to do this business catch up (no need for technical team to participate to this point)?

You'll find here the details on how to implement Bazaarvoice so you can start having a look at how things work in details.

If you have any question, please feel free to reach out!
Thomas

https://storage.3.basecamp.com/4056726/buckets/12935458/recordings/1935487336/email/download/BAh7CEkiCGdpZAY6BkVUSSIoZ2lkOi8vYmMzL0Jsb2IvMTUxODE5OTI1P2V4cGlyZXNfaW4GOwBUSSIMcHVycG9zZQY7AFRbB0kiCmVtYWlsBjsAVGwrB2gxXXNJIg9leHBpcmVzX2F0BjsAVDA=--ee842a982102a681ddfd0b50fc8106da3243f5ed/Platform_kick-off (1).pptx

Information for the front widget implementation

Simple Submission URL (SSURL):
http://display.ugc.bazaarvoice.com/static/leroymerlin-ua/main_site/uk_UA/container.htm?bvaction=rr_submit_review&bvproductId=ID1

Your Configuration Hub
Leroymerlin-ua

Integrate javascript provided on the product & category pages
Place <div> to create containers for review summary and main display
Code integration identical for staging and production*
Reviews functionality and design managed in the Bazaarvoice Configuration Hub

For more info see the document attached.

points to integrate

1. Widget product sheet
2. Customize widget
3. BV pixel

i think we do.
The BV pixel is a tool like GA to track something

Do we need to disable the existing comments and rating system ?

I have an error like this when i'm trying to load container on localhost:
Bazaarvoice is not configured for this domain: localhost:8443

I use this url to load script:
<script type="text/javascript" src="https://display.ugc.bazaarvoice.com/bvstaging/static/leroymerlin-ua/uk_UA/bvapi.js"> </script>

Project git repo link : https://gitlab.devatlant.com/wikeo/bazaarVoiceXmlConverter
Branch mivanov/905_bazaarvoice_integration
Acceptances tests by business were done in production (xml files were validated by ADEO)
Conversation with ADEO: https://3.basecamp.com/4056726/buckets/12935458/messages/1935487336#__recording_1984426340
File bazaarvoice.xml has been uploaded to remote sftp. Waiting for approval from BazaarVoice team

• feat brand
• etc

• In fact, file *.bat (for copy *.csv to directory where *.jar will convert this file to *.xml) didn't work today.
• Also we have problem with encoding. I ran all tasks manually and after that *.xml file copied to remote sftp. I downloaded file from remote sftp and this file had data with wrong encoding. But file which we copied had correct encoding.

Code review results¶

Architectural notes¶

• Project is not configured properly - so it's not recognized by Idea automatically as a Java project
• Bad error handling
• Manu violation of OOP basic principle in models code
• Any valid unit tests

Code style¶

• many minor improvements can be done

Stabilization estimate¶

• In order to normalize the project tech health and guarantee the RUN phase in prod we need 5 days

we approve

@Yevgen Voronetskyy I integrated the 1,2,3 and partially the 5th point from this instruction: https://3.basecamp.com/4056726/buckets/12935458/documents/2017514121
I tried to show questions from 4th point, but it doesn't work, maybe we should activate it in your preferences (for the moment nothing is showing while integrating this part). I think that we shouldn't add google markup, because we already have it in JSON.

@o.skrypek what about design? You will configure it in your account?

Please, add anchor here http://prntscr.com/ozkc7a

Could we do something with this?
http://prntscr.com/p4qwft

Or it is from our side?

Please, fix it
http://prntscr.com/p6udzc

widget and section not displayed - http://prntscr.com/p7qfbv

we approve the additional day

We get some comment from Netpeak in the topic of SEO. Can we do something?
Текущая проблема с микроразмектой продуктов:

1. Разметка отзывов внедрена само по себе. А должна быть вложена в продукт, иначе отображаться не будет. Это совсем новое обновление Гугла, как раз по отзывам.

Вот так вот у нас - http://img.netpeak.ua/vinnie/156889617498_kiss_13kb.png
Вот так должно быть: http://img.netpeak.ua/vinnie/156889631763_kiss_38kb.png
Так как звезды крепили к всему, что можно, Google ужесточил правила.

2. Помимо п.1 в разметке есть ошибки http://img.netpeak.ua/vinnie/156889639903_kiss_10kb.png, что изначально исключает отображение расширенных сниппетов.
Какие есть решения:

1. Убрать разметку с отзывов. Она внедрена в формате Microdata, т.е непосредственно атрибутами в теги http://img.netpeak.ua/vinnie/156889657696_kiss_6kb.png
Далее обновить текущую разметку в формате JSON-LD. Тут надо понимать сможете ли вы убрать атрибуты разметки

2. Если есть доступ к модулю отзывов, тогда можно исправить ошибки, а потом подстроиться под эту разметку, наложив на него еще Product в таком же формате Microdata. Но это будет очень долго и тяжело + возможно с изменением верстки + не факт ,что ошибки исправят быстро или вообще исправят.

Please fix it http://prntscr.com/p8lk0y - fixed

@o.skrypek, about your SEO note 43, we will need 1 additional day (as this topic was not estimated) to analyse the proposed solutions ans collaborate with ADEO/BV team. Waiting for your approval.

Comment from BV - http://prntscr.com/p9vgzd

Yevgen Voronetskyy wrote:

@o.skrypek, about your SEO note 43, we will need 1 additional day (as this topic was not estimated) to analyse the proposed solutions ans collaborate with ADEO/BV team. Waiting for your approval.

we approve

I changed SKU in our json+ld, now they are the same. We will see how it works in the next deploy in production.

Olena Skrypek wrote:

Bug:
11616094 - the reviews from other BUs exist only in RU context
11895226 - our review exist only in UKR context

We fixed it in BV portal

Sometimes the header doesn't appear for reviews, it happens because there is no reviews object in BV object, i asked BV team how to fix this problem, for the moment i keep the name Отзывы, but i remove the number of reviews.
https://3.basecamp.com/4056726/buckets/12935458/messages/2088120728 here is our discussion

@Yevgen Voronetskyy, please close the ticket