Pricing Feed

Integrating your pricing feed into the Returns Portal

Important

This feed is only required if you wish to make products available for Live Exchanges.

This feed contains the pricing data (Selling price and RRP) for all your goods, and is used to apply category, product type and brand pricing settings.

It is connected with your product feed via the Product SKU.

There needs to be a separate pricing feed file for each country (currency).

The file for each country should be exported daily to an FTPS or SFTP location, for subsequent import into the administration portal.

Note

You can request an FTPS/SFTP location from your Metapack implementation consultant.

Returns can accept the order feed in any of the following formats:

  • CSV - The separator can be a comma, pipe, semicolon or tab, but please use the same one throughout. Files should be encoded using the Unicode standard.

  • XLS/XLSX

  • XML. The schema used is XSD: PriceFeed.xsd.

Note

For full file details, refer to Pricing Feed File Specification. If you need help, send us your pricing feed in any layout and we can help map it correctly.

Please use the following naming convention for your files:

Prices_GB_<timestamp>.<suffix> (e.g. .csv), Prices_DE_<timestamp>.csv, etc.

The <timestamp> should be supplied in ISO 8601 format, for example:

2020-03-31T000000Z,

PriceFeed.xsd

<?xml version="1.0" encoding="UTF-8"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" id="Root">
   <xs:element name="Root" msdata:IsDataSet="true" msdata:Locale="en-US">
      <xs:complexType>
         <xs:choice minOccurs="0" maxOccurs="unbounded">
            <xs:element name="Data">
               <xs:complexType>
                  <xs:sequence>
                     <xs:element name="SKU" minOccurs="1">
                        <xs:simpleType>
                           <xs:restriction base="xs:string">
                              <xs:maxLength value="50" />
                           </xs:restriction>
                        </xs:simpleType>
                     </xs:element>
                     <xs:element name="RRP" type="xs:decimal" minOccurs="0" />
                     <xs:element name="SellingPrice" type="xs:decimal" minOccurs="0" />
                     <xs:element name="ShippingCost" type="xs:decimal" minOccurs="0" />
                     <xs:element name="CostPrice" type="xs:decimal" minOccurs="0" />
                  </xs:sequence>
               </xs:complexType>
            </xs:element>
         </xs:choice>
      </xs:complexType>
   </xs:element>
</xs:schema>