Tesco API Overview

Overview

Most of the data on Tesco channel is entered manually by merchant via Merchantry Connect user interface. The feeds imported from merchant environment by import process are Product Induction, Enrolment and Update (PIEU) and Product Enrolment, Cost and Lead Time Update (PECL) feeds. The data flow may be illustrated by the following diagram:

Merchantry Connect gets and receives feeds to/from Tesco via sFTP. All feeds are in tab-delimited format. The default locale for feeds data is Great Britain. Merchantry Connect uses 11 different feeds used for interaction with Tesco. These feeds are based on a number of ‘inbound’ and ‘outbound’ templates provided by Tesco which can be used to communicate product, order and other information:

  • Product Induction, Enrolment and Update (PIEU)
  • Product Enrolment, Cost and Lead Time Update (PECL)
  • Product/Listing Media (PLMED)
  • Inventory Updates (INVUPD)
  • Release Order (RELODR)
  • Status Update (STSUPD)
  • Amend Order (AMDODR)
  • Dispatch Notification (DISPNT)
  • Return Order (RETODR)
  • Return Validation (RTNVAL)
  • Return Order Creation & Validation (RTNOCV)

The feeds are briefly described in the below sections. For detailed description, please refer to Tesco Supplier Technical Manual (Tesco provides it for the suppliers).

Note: Usually all import and export processes are managed by Merchantry team so you don’t need to run the processes yourself. However it is important to know the purpose of each feed used in the channel processes.

Product Setup & Data Management

All the feeds for Product Setup & Data Management are inbound feeds and each of these feeds is associated with a response file. These are the 4 inbound (to Tesco.com) feeds:

  • Product Induction, Enrolment and Update (PIEU)
  • Product Enrolment, Cost and Lead Time Update (PECL)
  • Product/Listing Media (PLMED)
  • Inventory Updates (INVUPD)

Product Induction & Enrolment (PIEU)

With this feed, you can perform the following pieces of functionality:

  • Product Induction – induct a product providing all the necessary information Tesco requires to effectively sell it.
  • Product Enrolment – enrol a product against the product catalogue of Tesco you will be able to fulfil.

This feed is used for the products that are new for Tesco, therefore it contains all necessary information about the product and it is recommended to provide as much data as possible.

Product Enrolment, Cost Price & Lead time (PECL)

This is a shorter feed that you can use to enrol against products which are already inducted either by you or others. This file is not category specific and can be used to update products in all the categories you fulfil on behalf of Tesco.

Tesco Catalogue ID of the product must be provided in this feed.

Product/Listing Media (PLMED)

Product/Listing Media (PLMED) is a way for you to upload items such as pictures & flash video to supplement the product information. Each product will have one main image. You can also upload additional images for the same product. By providing several images, customers will be able to make a more informed buying decision. The following types of images may be used to illustrate your product:

  • Default image – minimum one main image.
  • Multiple images – additional images allowing the customer to click through and see other views of the product (back, right-side, top, inside, how to use etc). Up to 8 additional images are possible.
  • Swatch image – Used to display different colours or patterns; such as fabrics.

Note: If you are using PIEU file for product induction and enrolment, then you need to wait until you receive a success response from Tesco before you can start uploading images or any other media.

Inventory Updates (INVUPD)

This feed contains inventory information necessary for start selling product. Tesco needs this information to ensure that you can fulfill any orders sent to you to fulfill on behalf of Tesco and to show the availability to the customers. The inventory update feed allows supplier to provide Tesco with stock and availability information relating to their products using the following supply types:

  • ‘ONHAND’ – actual physical stock in your warehouse, this is your total stock.
  • ‘PO_PLACED’ – expected in as you have a purchase order raised for them, and are therefore able to indicate to Tesco how many units you are expecting in and on what date.

Order Management

There are four feeds that are used from an order management perspective for our new Tesco.com platform.

These are the 2 outbound (from Tesco) feeds:

  • Release Order (RELODR)
  • Amend Order (AMDODR)

These are the 2 inbound (to Tesco.com) feeds:

  • Status Update (STSUPD)
  • Dispatch Notification (DISPNT)

Release Order (RELODR)

This feed is a TXT file sent from Tesco that contains all the details of the new order. The release Order extract provides new order information indicating which of the products the customer has ordered, how they want it delivered.

Status Update (STSUPD)

This feed is used to inform Tesco whether you are accepting the order or rejecting it within reasonable time depending on your delivery lead time so that Tesco is aware that you will be in a position to fulfil the order. The Status Update feed allows you to communicate to Tesco when you reach particular stages within the fulfilment lifecycle for each SKU that you are picking on behalf of a customer.

Amend Order (AMDODR)

The customers can amend their orders up to a specific point and Tesco informs you of the amendments the customer makes to the order using AMDODR feed. A customer has the ability to amend their order after it has been sent to a warehouse. The amendments that are permissible are quantity changes:

  • e.g. originally ordered 3 units, now wants 2, essentially cancelling a unit
  • e.g. originally ordered 3 units, now does not want any of that particular SKU, essentially cancelling the line
  • e.g. originally ordered 3 units of one SKU, and 2 units of another SKU, now wants neither of those SKU’s, essentially cancelling the supplier order

The Amend Order feed provides the latest view of an order after such an amendment has occurred.

The same feed is imported from Tesco to confirm that the order has been paid by the customer. The order cannot be shipped until Tesco confirms payment.

Dispatch Notification (DISPNT)

Once you have picked and packed the customers ordered products and your courier has picked this for delivery, you need to use DISPNT feed to communicate that this event has occurred so Tesco can update their systems with how each line has been packaged, their contents, and any associated tracking information.

Returns

There are three feeds that are used from a returns perspective for Tesco.

These are the 2 inbound (to Tesco) feeds:

  • Return Validation (RTNVAL)
  • Return Order Creation & Validation (RTNOCV)

This is the 1 outbound (from Tesco) feed:

  • Return Order (RETODR)

Return Order (RETODR)

If the customer wishes to return the product and has called Tesco Customer Services Centre, you will be informed of such orders in the form of a pre-advice using RETODR feed. Once the parcel is back in your possession then you confirm & validate the same using RTNVAL feed.

The Return Order extract provides new order information indicating which of your products a customer is returning, how they returning and when along with the collection address.

Return Validation (RTNVAL)

After registering the return with Tesco Customer Service (Merchantry Connect will inform you of this using RETODR feed) if the customer has posted back the product to you or you have completed the collection of the product from the customers, you should communicate & validate to Tesco what product you have received/collected and for which customer using RTNVAL feed.

Return Order Creation & Validation (RTNOCV)

You can use this feed to inform Tesco in the following scenarios:

  • If a product is posted back to you without registering return with Tesco Customer Service then we need you to communicate to Tesco what product you have received and for which customer.
  • If the customer contacted you directly for a return without contacting Tesco Customer Service Center you can collect the product back and inform Tesco.
  • If you/your carrier were unable to deliver the product because of various reasons such as refused at door, unable to contact customer for delivery or access door too small etc.
Print Friendly