How to Integrate#

This section covers the basics of how to integrate. Click these links below to access each section of the integration process as required, or simply scroll down the page:

• Integration prerequisites

• Credential management & access

• File format(s) configurations and limitations

Integration prerequisites#

To successfully integrate Promotions via SFTP, the following requirements must be met:

1. Onboarding to the Local Shops product stack, including:

   1. Access to the Partner Portal

   2. Access to the Integrations Plugin within the Partner Portal

2. External Vendor ID Configuration: If using your own vendor IDs, ensure they are correctly configured.

3. Active Catalog: Items must be successfully associated between our item catalog and vendors in your chain

4. Valid Credentials: Necessary for accessing our SFTP Central Server. Please request valid credentials from your Account Manager

5. SFTP Client: Must be capable of pushing CSV files in the specified format, detailed in the ‘File Format section’

Credentials and Access to foodpanda’s Server#

1. Access an FTP Application/ Software

   • Have access to an FTP Application/ Software (e.g Filezilla) that will allow you to access foodpanda’s Server.

2. Host URL:

   • In the FTP Application you will need to enter: vendor-automation-sftp-live-ap.prod.aws.qcommerce.live

3. Credentials:

   • User Name

   • Password

4. Port (communication endpoint) which is always 22, no matter on what chain you are accessing.

File format(s) configurations and limitations#

As you introduced before, there are 3 types of file formats you can adopt.
Below you can learn about configuring each and details about their capabilities and limitations.

• Single File Format for Single Vendor

• Double File Format for Single Vendor

• Double File Format for Multi Vendor

Compliance with at least one of the available file formats as described below is required for a fully-functional SFTP integration To enable proper synchronization, files must follow specific naming conventions:

Single File Format

• Both the Assortment & Promotions updates are sent in a single file

  • This format is designed to update the assortment and/or promotions for a single vendor or store at a time. However, multiple promotions for the same vendor or store can be included, allowing you to create promotions for different dates within a single file.

    • The update file must be pushed into the Assortment sub-directory.

• File naming pattern: <prefix>_<vendor_id>.csv

  • The prefix can be any chosen value.

  • The vendor_id refers to either the External Vendor ID defined in the Partner Portal or the Platform Vendor ID if no External Vendor ID is configured.

• File processing time: max. 50 minutes.

• Limitations :

  • Row Limit (rows in the file) : 20K

  • SKU Limit for each campaign : 19,999

  • Max number of Products (SKU x Vendors ) : N/A

  • Max File Size : 200MB

  • Promotions count: 1000 in one file (promotions with different dates)

• Format example :

Double File Format for Single Vendor#

• Assortment and Promotions updates are submitted in two separate files.

  • This format is designed to update promotions for a single vendor or store at a time. However, multiple promotions for the same vendor or store can be included, allowing you to create promotions for different dates within a single file.

    • The update file for Assortment must be uploaded to the Promotions sub-directory.

  • File naming pattern: <prefix>_<vendor_id>.csv

    • The prefix can be any chosen value

    • The vendor_id refers to either the External Vendor ID defined in the Partner Portal or the Platform Vendor ID if no External Vendor ID is configured.

• File processing time: max. 50 minutes

• Limitations:

  • Row Limit (inclusive of column header) : 20K

  • SKU Limit : 19,999

  • Max File Size : 200MB

  • Promotions count: 1000 in one file (promotions with different dates)

• Format example :

Double File Format for Multi Vendor#

• Assortment and Promotions updates are submitted in two separate files.

  • This format is designed to update the assortment for multiple vendors or stores within a single file.

  • The update file for Promotions must be uploaded to the Promotions sub-directory.

    • File naming pattern : <prefix>.csv, file name should not have any underscore, for example : Testchain.csv

• File processing time: max. 90 minutes

• Limitations:

  • Row Limit (inclusive of column header) : 20K

  • SKU Limit : 99,999

  • Max number of Products (SKU x Vendors) : 300K

  • Max File Size : 200MB

  • Promotions count: 1000 in one file (promotions with different dates)

• Format example: