E-commerce, Retail and Technology: online

<span id="docs-internal-guid-a2665fe6-0499-315e-1930-5bc5bb5be766"></span><br />
<div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt;">
<span id="docs-internal-guid-a2665fe6-0499-315e-1930-5bc5bb5be766"><span style="vertical-align: baseline; white-space: pre-wrap;"><span style="font-family: "arial" , "helvetica" , sans-serif;">Hi I am Mark Mandel and independent retail consultant. I have worked in Retail in the UK and Europe for 30 years, for companies such as Tesco, ASOS.com and Superdry. These blogs represent my own personal views and not the views or systems of any particular company. If you want any help with getting product data together then please get in touch <a href="https://twitter.com/Mark_A_Mandel" target="_blank">@Mark_A_Mandel</a> on Twitter.</span></span></span></div>
<span id="docs-internal-guid-a2665fe6-0499-315e-1930-5bc5bb5be766"> </span><span style="font-family: "arial" , "helvetica" , sans-serif;"></span>
<br />
<div>
<span style="font-family: "arial" , "helvetica" , sans-serif;"><span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></span></div>
<span style="font-family: "arial" , "helvetica" , sans-serif;"> As you start to move from retail bricks and mortar store to the online world. One of the first data challenges you are going to meet is creating a product data feed into your website, eBay, Amazon or other online sales channels.</span><br />
<div>
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div>
<span style="font-family: "arial" , "helvetica" , sans-serif;">This data feed must meet these quality criteria:</span></div>
<div>
<ul>
<li><span style="font-family: "arial" , "helvetica" , sans-serif;">Complete - it must contain a description for every product you want to sell and for example it shouldn't contain products that are no longer on sale so you need to have deletion policy in place as well as a process for adding new products in time.</span></li>
<li><span style="font-family: "arial" , "helvetica" , sans-serif;">Accurate - all the details given to consumers must be correct. </span></li>
<li><span style="font-family: "arial" , "helvetica" , sans-serif;">Linked - it should contain links to other feeds such promotions, coupons etc.</span></li>
</ul>
</div>
<div>
<div>
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div>
<span style="font-family: "arial" , "helvetica" , sans-serif;">This will be typically created daily. Although it sounds simple when you start to look at the elements involved, you can see that quickly this becomes quite a lot of work even for a small merchant with a few hundred items. </span></div>
<div>
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div>
<span style="font-family: "arial" , "helvetica" , sans-serif;">Here are the main items of a Products Feed Specification, this is based on Googles merchant feed. For different categories such as fashion, grocery or health & beauty additional attributes may be required.</span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></div>
<b style="font-family: arial, helvetica, sans-serif;">Data Feed Attributes</b><br />
<div>
<div>
<span style="font-family: "arial" , "helvetica" , sans-serif;"><b><br /></b> country [country] - country item for sale in </span></div>
<span style="font-family: "arial" , "helvetica" , sans-serif;"> </span><br />
<div>
<span style="font-family: "arial" , "helvetica" , sans-serif;">title [title] - Title of the item</span></div>
<span style="font-family: "arial" , "helvetica" , sans-serif;"> </span><br />
<div>
<span style="font-family: "arial" , "helvetica" , sans-serif;">description [description] - Description of the item</span></div>
<span style="font-family: "arial" , "helvetica" , sans-serif;">
<div>
product category [product category] - category of the item</div>
<div>
product type [product_type] - sub category of the item</div>
<div>
link [link] - URL directly linking to your item's page on your website</div>
<div>
mobile link [mobile_link] - Mobile Landing Page URLs</div>
<div>
image link [image_link] - URL of an image of the item</div>
<div>
additional image link [additional_image_link] - Additional URLs of images of the item</div>
<div>
condition [condition] - Condition or state of the item</div>
<div>
availability [availability] - Availability status of the item</div>
<div>
availability date [availability_date] - The day a pre-ordered product becomes available for delivery</div>
<div>
price [price] - Price of the item</div>
<div>
sale price [sale_price] - Advertised sale price of the item</div>
<div>
sale price effective date [sale_price_effective_date] - Date range during which the item is on sale</div>
<div>
Unique Product Identifier EAN[EAN] - barcode or EAN</div>
</span><span style="font-family: "arial" , "helvetica" , sans-serif;"><div>
mpn [mpn] - Manufacturer Part Number (MPN) of the item</div>
<div>
brand [brand] - Brand of the item</div>
<div>
item group id [item_group_id] - Shared identifier for all variants of the same product</div>
<div>
colour [colour] - Colour of the item</div>
<div>
gender [gender] - Gender of the item</div>
<div>
age group [age_group] - Target age group of the item</div>
<div>
material [material] - Material of the item</div>
<div>
pattern [pattern] - Pattern/Graphic of the item</div>
<div>
size [size] - Size of the item</div>
<div>
size type [size_type] - Size type of the item</div>
<div>
size system [size_system] - Size system of the item</div>
<div>
shipping [shipping]</div>
<div>
price [price]</div>
<div>
shipping weight [shipping_weight] - Weight of the item for shipping</div>
<div>
shipping label [shipping_label]</div>
<div>
multipack [multipack] - Submit merchant-defined multipacks</div>
<div>
is bundle [is_bundle] - Submit merchant-defined bundles</div>
<div>
promotion id [promotion_id]</div>
<div>
<br /></div>
<img height="1" src="https://1.shopifytrack.com/aff_i?offer_id=2&file_id=166&aff_id=7765" width="1" />
<div>
<br />
Even if this is created automatically, I would recommend that you have a person sense-check this before publication. Do you have for example checks that the price is > 1p? Sounds obvious but <a href="http://news.sky.com/story/1391548/glitch-causes-items-to-be-sold-on-amazon-for-1p" target="_blank">many sellers on Amazon were caught out when orders were sent out at 1p.</a> So publishing a product feed that doesn't meet those quality criteria can be very expensive in time, money and loss of customers. </div>
<div>
<br />
<b>Fraud</b><br />
<br />
As with anything you should think about is there an opportunity for fraud to occur. There is here as for example if an item is in short-supply and your staff want to buy it, they could deliberately misname it so that it is hard for genuine customers to find, then they could buy it for themselves. Not so much fraud, but not getting that hot product into your best customers hands will impact your business.<br />
<br />
Of course, if they can send in multiple product feeds, they could also reduce the item price for a limited time, purchase the item, or get a friend to do so and the increase the price. Ask yourself this do you have checks and balances around price changes? As prices change so often, sometimes automatically, this may be something that is hard to do, but still something that needs a risk assessment and relevant controls.<br />
<br /></div>
<div>
Get in touch if you need help <a href="https://twitter.com/Mark_A_Mandel" style="line-height: 22.08px; white-space: pre-wrap;" target="_blank">@Mark_A_Mandel</a><span style="line-height: 22.08px; white-space: pre-wrap;"> </span></div>
<div>
<br /></div>
</span></div>
</div>

eCommerce product data feed the challenge for retailers and fraud concerns

Hi I am Mark Mandel and independent retail consultant. I have worked in Retail in the UK and Europe for 30 years, for companies such as Te...

<span style="font-family: Verdana, sans-serif;"><b>Authorities take preemptive action on exam fraud</b></span><span style="font-family: Verdana, sans-serif;">After leak of a maths question on games site last year, authorities may use private dectives to search for keywords from the new exam paper to see if there as been any leak of questions before the <a href="http://www.connexionfrance.com/news_articles.php?id=3681" target="_blank">baccalaureat </a>exams.</span><span style="font-family: Verdana, sans-serif;"><b><br /></b></span><br />
<span style="font-family: Verdana, sans-serif;"><b>Online card fraud grows in France</b></span><br />
<span style="font-family: Verdana, sans-serif;">The total amount of <a href="http://www.thelocal.fr/page/view/3670" target="_blank">online fraud in 2011 reached 413m Euro</a>, 32m for travel, 21.4m for shopping and 2m for gaming. Bank fraud increased from 2011.The 3D security system in France uses a text message that is sent to the customer as the extra dimension.</span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span><br />
<span style="font-family: Verdana, sans-serif;"><b>Man posed as rescuer charged with fraud</b></span><br />
<span style="font-family: Verdana, sans-serif;">A man who posed as a rescuer was <a href="http://www.thelocal.fr/page/view/3045" target="_blank">charged with fraud.</a></span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span><br />
<div style="font-family: Helvetica; font-size: 12px; margin-bottom: 16px; padding: 0px; text-align: left;">
<span style="letter-spacing: 0px;"><i>In the aftermath of a cyclone, Berre introduced himself as a civil servant working for the Agriculture Ministry sent to organise rescue and the clean-up operations. </i></span></div>
<div style="font-family: Helvetica; font-size: 12px; margin-bottom: 16px; padding: 0px; text-align: left;">
<span style="letter-spacing: 0px;"><i>Berre very quickly became the man in charge. He used forged documents to requisition firms, hotel rooms for firefighters. He reportedly sent rescue vehicles and all sorts of lorries for an estimated €70,000.</i></span></div>
<div style="font-family: Helvetica; font-size: 12px; margin-bottom: 16px; padding: 0px; text-align: left;">
<span style="letter-spacing: 0px;"><i>The court heard on Thursday that most state officials did not suspect Berre of being a fraud. During operations, he would transport them in his stolen car. The judge told the court that he had become "the head of the headquarters of the rescue operations".</i></span></div>
<i><span style="background-color: white; font-family: Helvetica; font-size: 12px; letter-spacing: 0px; text-align: left;">At the trial, the prosecutor accused Berre of fraudulently organising rescue operations to "compensate for his narcissistic failures."</span><span style="font-family: Verdana, sans-serif;"> </span></i><br />
<i><span style="font-family: Verdana, sans-serif;"><br /></span></i><br />
<span style="font-family: Verdana, sans-serif;">Not all fraud is about funds, sometimes its about ego. </span>

Fraud Focus - France - Exam Fraud and Online grows

Authorities take preemptive action on exam fraud After leak of a maths question on games site last year, authorities may use private dective...